Gieselman: Varieur: does the tutorial create the database for the root account?
Varieur: Asterismo: no idea. Ask them.
Varieur: Asterismo: also, tutorials are for experts – use the official do***entation instead
Clare: Does something like this could work? SELECT * FROM table WHERE type = 3 OR type = 5 OR type = 4 and table.deleted = 1;
Holgerson: I am using a prepared statement to where pattern matching is made using the LIKE clause.do I have to use user-defined variables for this to work?
Hausladen: By could work I mean if I have to put the AND inside of parenthsis
Seegmiller: Or how can I combine the ANDs and the ORs?
Meinerding: SmashingX: you could do WHERE type = 3 OR type = 5 OR. AND table.deleted=1, but it might make more sense to do WHERE type IN 3, 5, 4 AND table.deleted = 1
Ridner: The logic behind when you need parentheses and when you don’t comes from https://dev.mysql.com/doc/refman/5.6/en/operator-precedence.html
Durousseau: Is anyone here familiar with MySQL Fabric?
Crumbly: Wanted to get thoughts/opinions on its abilities.
Biddleman: Segel, It looks like its a collection of python scripts, I have not played with it yet, just wanting to know the general census on it. Has anyone had any positive experiences with it? Negative experiences? etc.
Segel: CrazyTuxm: did you already read some blog posts about it and the comments section of those posts?
Segel: I would probably start where the conversation is happening ;
Tarwater: Segel, no I walked into office and someone mentions it.
Segel: Eg https://www.percona.com/blog/2014/04/25/managing-farms-of-mysql-servers-with-mysql-fabric/
Nanthanong: Segel, not much info in the comments.
Segel: I disagree and am quite amazed at how quickly you read that
Perret: Segel, there is maybe three “real” Q & A’s
Brandolino: Segel, all of which do not answer my question.
Masiejczyk: Where in sources is mechanism that accepts client request?
Segel: CrazyTuxm: maybe also look at maxscale while you determine your use case for fabric
Novara: I found this place: https://github.com/mysql/mysql-server/blob/5.5/sql/mysqld.cc#L5423
Segel: CrazyTuxm: they have a channel on chat, too
Voracek: But there thd is ready to execute object with thread
Deback: I have a table with an id, a date, and a foreign key id, say fid. is it possible to pick any id for which another id exists with same fid and date within 30 days?
Armen: Beefman, look into LEFT/RIGHT/INNER JOINS
Neve: Can someone shed some light on why this SELECT * FROM SELECT * FROM MY_TABLE LIMIT 0, 5000 is so much slower than SELECT * FROM MY_TABLE LIMIT 0, 5000?
Dammann: J_hertz123: because when you use that subquery the server has to fetch the entire thing before it can be processed by the outer query. put the limit inside the subquery. and always use ORDER BY when you use LIMIT
Dammann: J_hertz123: and show your real query, since this example probably excludes some important contextual information
Feikles: Kolbe: I am writing something that will dynamically create a query around another query, so this just an example rather then a real query since it could be anything really.
Dammann: J_hertz123: why are you doing such a thing?
Schaap: Kolbe: dynamic query tool
Ende: Hey guys. I created my first table :
Dammann: J_hertz123: why has the LIMIT clause moved outside of the parentheses then in your tool?
Dammann: J_hertz123: you can’t just paginate arbitrary queries in that way using limit. the result of the query could change from one invocation to the next, which means you’d get completely meaningless results.
Jeanlouis: Tylak: Resume Changing Event. Often when the need to revert to backups arrises and either none are available or existing ones are borked.
Belue: Kolbe: you mean if the data in the table changes or if MySQL returns data in a different order?