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