Username/p***word are ok,.

 
Clyatt: Pixelgrid: You can get duplicates and in your case it will make it impossible to use the select from the factoid

Clyatt: Pixelgrid: According to theory each and every table must have primary key. In practice there are rare cases when it is fine to not have one like with table storing logs, but these cases are very limited

Alquicira: Salle: i cant agree with you more

Scroggy: I will have to filter it in the backend for now

Straugh: After the query is done

Summar: Salle: That doesn’t show how to do it at runtime

Witten: I *don’t* want to restart the server/

Clyatt: Bracki: The manual quite explicitly tells you it can not be done without restarting the server. What you want doesn’t matter much

Vesper: Where does it say that?

Clyatt: Bracki: Third sentence at the very top

Clyatt: Bracki: If you care to read about performance_schema variable you will see there too

Clyatt: Bracki: Dynamic Variable No means exactly that: It can not be modified without restart.

Whitling: Salle: Cool. thanks for the heads up.

Silis: I have a problem i can’t seem to fix on my own

Galauiz: I want to copy a field from one table to another

Poggi: I have to check if the value isn’t already in te second table

Billiar: Bc it has to be a unique value in the second table

Kolarik: Insert into on duplicate key ?

Rumery: And what happens if it already exists? or more what you want to happen

Wolle: If it alreay exists there’s no need to copy it

Rumery: Then insert . on duplicate key update and update changing nothing as Dehner suggested is a good way, another one would be insert ignore in your case

Sillitoe: Ow, i guess i didn’t see Dehner’s comment

Imig: Does UPDATE foo set bar=bar; fire on update triggers?

Imig: I.e. does it fire even when no data changes?

Rumery: Never sure about that one. it finds the row but does not update by the usual output message matched X, changed 0, so I would guess NO, but better test it – it might fire only BEFORE update one for instance – it might change the bar value to something else and then the update might happen

Sabagh: Anyone know if i can get 5.6 client compiled with readline?

Sabagh: The hacks to fix ctrl-w don’t really work

Sabagh: Ctrl-w works, but ctrl-y after deleting several words only pasts the last word to be deleted, which is a pita

Sabagh: I tried to compile it myself, but I think I ran into this: http://bugs.mysql.com/bug.php?id=68087

Sabagh: Hmm. I guess I should try the patch

Sabagh: Https://bugs.mysql.com/bug.php?id=63130 # readline is no longer used in MySQL. # Uh?

Stalter: Sabagh: you can use rlwrap.

Stalter: Use mariadb client then :

Stalter: It works with 5.6 and has readline

Stalter: Clients are quite agnostic because mysql protocol doesn’t change

Stalter: Or use https://github.com/dbcli/mycli

Sabagh: Tanj: thanks for tips

Rumery: Tanj, did you try mycli? I noticed it a bit late on kickstarter I think, seemed like a good idea

Nicolay: Mariuscc, you have api.myhost.local for 2 different mysql instances?

Nicolay: Edit /etc/hosts if its defined in there

Kosiba: Well, I need it there.

Dituri: It’s not for 2 different mysql instances

Bisher: It’s just defined 192.168.10.10 api.myhost.local

Nicolay: So whats the problem? it looks as though your username or p***word is incorrect or your IP isnt allowed to connect

Demus: Mariuscc: See http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_skip_name_resolve

Caneles: Username/p***word are ok, because I can connect from console