But if I it’s impossible,.

 
Pendrak: Hes****: appreciate your help!

Biancardi: Rumery: i am actually following a book. sigh. book isn’t accurate.

Buschner: Rumery: could you enlighten me how will the script work then?

Rumery: Xcesariox, yep, that unfortunately happens :

Goldfield: Rumery: which LINE should i end the function

Rumery: Xcesariox, I am not experienced in node js, so you would get better help with this in their channel, but look at lines 16-19 – if error happens, you just release the connection but do nothing else, your code continues trying as if no error happened, you do it differently at lines 37-39

Coote: Rumery: i think i solved it.

Arcia: Rumery: the error lies with LINE 18. look again, i forgot to add return error.

Bielec: Rumery: thank you so much :

Rumery: Xcesariox, now remember what Hes**** said about dropping the table – it is not created afterwards so you end without a table to work on

Micucci: Rumery: eh i only fix line 18 , and when i execute the script it says ER_NO_SUCH_TABLE: Table ‘president.presidents’ doesn’t exist

Rumery: Xcesariox, yep, thats what we are saying – you are probably missing one more step – creating the table

Uptegraft: Rumery: oh! lol i did it! there was an earlier script i created to create the table, and then i run this script again and it worked!

Manaker: Mysql enterprise edition commercial = means that it’s not free and open-source right? did i understand it correctly?

Rumery: How can I get from “Using index; Using temporary; Using filesort” to “Using index; Using filesort” by ADDING one more distinct count? indexes used are the same

Stowe: Hi i am trying to create a function as shown here – http://pastie.org/10425317

Bough: Is it possible to give a user the permission to create and drop database matching a specific pattern like ‘%_username’ ?

Windsheimer: Buzzybron: Use around identifiers database/table/column/alias names and ‘ around strings and dates. MySQL does allow ” for strings, but ANSI standard uses ” for identifiers which you can enable with ANSI QUOTES option.

Rumery: Buzzybron, there is nothing about quoting variable names in there but I will better check

Rumery: Buzzybron, hm, seems it is allowed actually.

Sifontes: Does any one if ‘ORDER BY FIELDfieldname, a, b, c’ is specific to mysql or do most other engines support it?

Quinones: In mysql, when I do an update on two tables, like UPDATE user u, customer c SET u.name = ‘.’ WHERE . are the rows selected first and then updated “in parallel” or is it serial? that is, updated values in older rows can rewrite to subsequent rows

Rumery: Veganista, no idea if there is a specific function for it but you can write the same using CASE

Maultasch: Hi all, I’ve got a question: I’m trying to use a session variable as a default value in a CREATE statement, but that doesn’t work. Any idea how I could make it work?

Lett: Session var or user var? what is the statement and the error?

Lelis: Danblack: pasting it to gist, wait a sec

Messervy: Danblack: https://gist.github.com/rimas-kudelis/36e07d54ffa1dd5c95bf

Clyatt: RQ: MySQL does not allow variables in DEFAULT and you already know that

Crossen: And look at the max value of a smallint while you are theere too.

Hano: Salle: well I guess I have figured that out.

Nordeen: Danblack: so concat is the only way?

Clyatt: Danblack: It is 65535 for unsigned

Centore: Smallint is unsigned by the way ;

Clyatt: RQ: Why would you ever need that?

Meehl: Salle: need what exactly?

Corkron: Ah, cool. me thinking tiny. my bad.

Pandy: Salle: these statements live in a setup script, and I thought I’d make that script easier to configure by putting both variables at its top, and then just using them

Wagenaar: But if I it’s impossible, then I guess I can live without it