Deason: Make php handle formatting
Deason: I don’t think you need a join or a union, just a group by
Collington: Im just running a query in mysql workbench
Benziger: SELECT SUMfield=’fail’ AS failures, SUMfield=’success’ AS successes FROM table;
Wingenter: Hi, I have two tables: category1 and category2 with same structure: id, name. how should I select all the names from both categories with one query? Is that some JOIN without conditions?
Maniace: Select ‘category1’, name FROM category1 UNION ALL select ‘category2’, name FROM category2;
Daws: Is there a way to track changes in a database? i wanna change something on the website and see which table is being updated
Mccaskin: Luist: Read through the code? Compare last changed dates in information_schema?
Kehrer: Luist, turn on mysql loggin and log ALL queries.
Deason: Luist: general log, binary log, audit plugin, tcp capture
Hanstine: Hey everyone! I’m having some issues inserting high-precision decimal values into my database from PHP. The values lose up to 3 decimals out of their six places, and it’s vital that all are kept. My column is created as a DECIMAL11, 8, and I insert the values using a prepared statement. The database is running on an Ubuntu server, and is version 14.14
Jarchow: Does anyone know what the cause could be?
Rivers: If I have a VARCHAR column with an index non-unique does the length affect the performance? Is it better to allow 10 vs 20 characters? What about 255 characters? I feel like smaller indexes would work better than really large ones, but I’m not an expert by any means.
Deason: Jargon_: can you reproduce this on sqlfiddle.com please without prepared statement
Deason: Dave_s: http://lists.mysql.com/mysql/174431
Riccitelli: Deason, I’ll give it a shot and report back
Fosher: Deason: The asker there states his column is not idexed or used in lookups and is related specifically to running an ALTER TABLE and whether the length of the VARCHAR will affect his InnoDB table performance.
Fordham: I’m trying to determine if it’s better to have a shorter key length than a longer one, eg up to 20 characters long vs up to 100 or what have you.
Deason: Dave_s: more space is not used for the column on disk, i believe this is also true in the buffer pool
Deason: Dave_s: you are are talking about a partial index?
Rancatti: Deason: I know that VARCHAR only consumes as much space as is required by the data in that column by that row it doesn’t “reserve” the space for 50 chars.
Petito: Deason, back from sqlfiddle. The correct data is shown there
Deason: Jargon_: maybe a problem in your app?
Beutler: Deason: An index like “.KEY code code.”
Deason: Dave_s: you are not asking about KEY code code20, right?
Tesmer: Deason, ahh, yeah, looking at it now. I’m using DBeaver to examine the data, but it rounds the values. Selecting from and showing the value in PHP displays the correct data
Cerniglia: Deason, Thanks for the help!
Menedez: Will remember sqlfiddle
Maddalena: Deason: http://pastebin.com/Li7RH5YT
Giudice: The code column, someone wants me to increase the length, but I want to make sure that having super long values in there won’t ***** up the performance.
Elhaj: Longer indexes have better performance
Furlotte: Hey any idea why /*!40000 ALTER TABLE user DISABLE KEYS */; would give me a Niedzwiedzki error near ‘ALTER TABLE’ on mysql 5.6 when called with mysql -uroot -pcheese mysql newusers.sql ?
Yamanaka: Usually I use cheeseburger and say it the way they do in Cloudy With a Chance of Meat*****
Wands: Fyi: https://www.youtube.com/watch?v=jgxqmzCVCVs
Borunda: Ashleyhindle: what is in a previous line?
Baggette: Boleware: LOCK TABLES user WRITE;
Alarcone: Check that it isn’t missing the ;
Herritt: Are you running it back into the same server that produced the dump?