Venezia: Frew: would recommend not using sudo with mysql client, but that’s not your problem. what’s the error you get? paste it. access denied or what?
Pryce: Access denied, *just* now my coworker found it
Edell: The ~/.my.cnf was missing
Venezia: Ah, yeah? what was it
Decoux: And stop using sudo, period.
Treworgy: Hey guys, I’m curious the difference between these two: WHERE foo.bar = ‘Active’ AND foo2.bar2 LIKE ‘blah’ OR foo2.bar2 LIKE ‘blah2’ and WHERE foo.bar = ‘Active’ AND foo2.bar2 LIKE ‘blah’ OR foo2.bar2 LIKE ‘blah2’ ?
Awe: The second way gives me my desired results, but the first way seems to throw the first part of the WHERE clause out the window?
Bachinski: Alturic: there are rules of precedence that define how multiple AND and OR statements are evaluated. or you can use parens to clarify the logic
Bachinski: Alturic: precedence: a=b and b=c or d=f is not the same as a=b and b=c or d=f
Ottum: By rules of precedence do you mean order?
Gillespie: And I guess a=b and b=c or d=f isn’t the same as a=b and b=c or d=f either then?
Bachinski: Alturic: precedence: a=b and b=c or d=f is not the same as a=b and b=c or d=f
Millstein: And I guess a=b and b=c or d=f isn’t the same as a=b and b=c or d=f either then?
Bachinski: Alturic: that is incorrect
Giguere: So then a=b is the exact same as a=b since it’s not a multiple clause?
Bachinski: Yes. and that changes nothing when evaluated with the rest of the statement
Bakley: I guess my main confusion was, why does a=b and b=c or d=f seemingly? throw out the a=b portion of the clause?
Bachinski: Alturic: use parentheses to clarify your logic and don’t worry about it
Kaushiva: So you only need parenthesis when doing a=b and b=c OR d=f or would you need it if you did a=b and b=c OR d=f and e=g?
Conlan: In other words, do you only need to wrap OR clauses in parentheses
Kara: Nevermind, I got https://dev.mysql.com/doc/refman/5.0/en/operator-precedence.html
Sliney: How can I merge two wordpress databases so that one database’s information is appended to the others? I have a domain name that’s expired and want to learn more about merging two mysql databases
Sliney: Can anyone shed some light into this for me please?
Firth: I need to replace if id exists, or insert if not . . .
Decoux: Unnu: INSERT . ON DUPLICATE KEY .
Sliney: Decoux: what about any mysql commands?
Decoux: Sliney: you can use INSERT . SELECT to append rows from one table to another.
Decoux: Sliney: you can use UPDATE to update existing rows.
Decoux: Sliney: you can use DELETE to delete rows
Sliney: Okay, thanks Decoux I’ll take a look at those commands further in the dev guide for my version and see what I can find. thanks for getting me off on the right foot
Decoux: Sliney: you might want to read some sql tutorials too.
Sliney: I already know how to use update to update certain rows in the mysql tables for wordpress; I’ll have to go more in-depth with that though
Decoux: Sliney: you’ll need to learn about the wordpress data – what can be deleted, updated, or else.
Sliney: I read somewhere that I could possibly do something like, copy rows 1-5 and append them to this table
Sliney: But yea, understanding the wp DB and its data would be key as wel
Loiseau: Https://bpaste.net/show/3c621b84adaf what? Am I missing something here?
Kulka: Oh, I need to escape.
Latzig: Kirito_: don’t we all :-
Sliney: I’ve also tried kill -s STOP and TERM 4141
Sorells: I would like to dump all databases except for mysql and information_schema, how can I do that?
Rumery: But can’t find any switch to explicitly ignore mysql
Rumery: Pihpah, you can use –databases and list all DBs you WANT to dump