Causasui: i think this is.

  Federico: Yeah, wasn't sure what to call that Routhier: Never used it or seen anyone use it, but sometimes i mention twitter's snowflake when people ask related questions Routhier: Alternatively you could use a mapping table for the initial pk lookup Routhier: So you insert some uuid there but…

Ok well then that’s.

  Eustice: Routhier: emphazie "should" : I've never tested that, because all mysql servers I ever used went 64bit before we had more than 4GB RAM in them : Stanowski: Groskreutz: ok, so 4 instances, each with 768 MB mem ? Killion: Haris: should work, yes. check if the buffer…

Groskreutz: Please kindly.

  Allford: I just tried LIKE CONCAT'%',SOMEFUNCTIONTHATHASNOTHINGTODOWITHDATESTHATSHOULDBETYPICALLYSTOREDINVARCHARFIELDS,'%' Routhier: DrJ: http://pastie.org/10440044 don't do this Ferrato: That's what I'm doing. Karwowski: DrJ: sqlfiddle.com is an easy way to share your schema, your data, and the queries you're testing. It saves us time and makes it more likely that you'll get an answer!…

DrJ: Try free open source.

  Naslund: There still isn't a good rename Helmsing: Mehwork: the same way you'd do it in 5.5 Herod: I have to be able to rename it without losing existing data Gurganious: Create a new database, move existing tables over to it. Helmsing: Mehwork: you won't "lose" data - you'll…

Also, in mysql 5.6 how can.

  Alconcel: Izham: explain your problem then more specific information can be gien. Capizzi: Help my server isn't working can someone help? Danfield: Have you tried turning it off and then on again? Capizzi: Keiter: I was just trying to fit in! :P Sechrest: Keiter, i'm going to join a…

Seen/byl nick? – quit.

  Cargle: Volund: datetimedate -+ interval integer timeperiod; #where timeperiod is second, minute, hour, day, month, year and some others. No plurals! egs., 'SELECT NOW + INTERVAL 3 MONTH;' 'SELECT CURRENT_DATE - INTERVAL 1 DAY;' Mckoon: Yeah I know how to use interval Senethavilouk: Lemme go make a mockup Keiter:…

I have Table A and Table B..

  Keiter: I think that's a dead end in this discussion, to be honest. Akande: Salle: was your comment referenced above about MYSQL? Macandog: Scott0_: See http://dev.mysql.com/doc/refman/5.6/en/operator-precedence.html Cowdery: So precedence definitely is not an order Izsak: Well, it is the order of rules evaluated on the row Izsak: It doesn't…

And then salle threw out “.

  Weitzel: I would have expected some kind of predictability which could be used for optimizing the query Keiter: Scott0_: many DBAs think they can write "faster" sql, but the engine often can rewrite it into something faster. But sometimes it fails Correl: Scott0_: you'll never know how it will…

Scott0_: it’s not.

  Correl: Scott0_: For some operators order matters for god sake Uvalle: In relation to each other is an order Correl: Scott0_: WHERE x y is not the same as WHERE y x Ryu: So precedence is an order Correl: Scott0_: Not at all. Precedence is NOT an order Nogales:…