|the_wench||ray|away see http://dev.mysql.com/doc/refman/5.0/en/upgrade.html|
|chadmaynard||seekwill can you copy the data files?|
|action||chadmaynard doesn't wanna read. flame him|
|chadmaynard||doesn't wanna read. flame him|
|ray|away||seekwill: who do I work for?|
|raymond||grrrr... someone registered this "nick" already.|
|chadmaynard||ray|away->raymond: who do you work for?|
|raymond||chadmaynard: LoL, sorry. I didn't realize you didn't know. :)|
chadmaynard: What channel is this?
|chadmaynard||well i assumed that must be what you meant|
i've never seen you here raymond
|raymond||chadmaynard: /msg chanserv info #mysql|
|seekwill||Whoops, sorry, I thought you were the guy who asked how to upgrade. It's late. But still, I was fairly certain you can.|
|raymond||seekwill: can != good idea/supported|
raymond: Anyone who asks about upgrading I refer them to that link.
|chadmaynard||seems like you could upgrade that way but not downgrade|
|seekwill||raymond: See if you used your usual nick I wouldn't have made that mistake.|
raymond: Do you know I work with Mike Hillyer now?
|raymond||seekwill: I heard you that you did.|
and typing is a skill I don't have.
|seekwill||Oh I thought it was me dozing again.|
|action||seekwill needs to get a Solaris VM up|
|seekwill||needs to get a Solaris VM up|
|toyto1||guys can you help me with this mysql statement: -> http://hashmysql.org/paste/viewentry.php?id=7416|
|chadmaynard||Oh no.... slow!|
|toyto1||when i issue that mysql statement, it gives the result so long|
because of multiplte tables?
what do you think?
your matches in the like %asfd%
%foo% is never good
you have several
causes scans and refuses indexing
|toyto1||ahh ic, what should be a better way than that?|
|chadmaynard||can you think of a better way to implement whatever you are doing?|
|toyto1||hmm let me think|
|chadmaynard||and the multiple table select is incorrect|
|toyto1||what it makes incorrect there? in what line? can you pls tell me?|
|chadmaynard||"WHERE l.dteListDate LIKE '%2007-01-%'" <- you will never have anything before 2007 will you?|