MySQL 4.1 and MySQL 5.0 Query Difference

May 27, 2006 at 7:34 am · Filed under MySQL Community
 PHPBB Web Hosting | PHPBB Hosting

anyone know how to best figure out what queries are going to break from 4.1 to 5.0?
read the manual section on upgrading from 4.1 to 5.0
 http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html

install a 5.0 test server

I did
 I need a way to run all the selects against it
 but the general query log is going to take a trick of coding to parse and the bin-log doesn't log selects
 also, anyone know anything about this? (googling doesn't help)
 Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log
how do I construct select state from 2 tables and remove the duplicate rows?
 SELECT * FROM t1,t2 WHERE…
 and remove duplicate row
that's a join
 do you mean union?
SELECT * FROM t1,t2 WHERE t1.cid = t2.cid && t1.aid = t2.aid
 and it did not remove duplicate
 how can i remove duplicate row in that statement?
GROUP BY or DISTINCT
any specific example please
Is it possible to print the results from MySQL Command Line Client?
yes

is there any way to load data from memory in mysql?
hrmm

load data infile is too slow for my application
RedACE, thx i got it
when you say "too slow", what's the bottleneck?
thanks nogger
cpu? disk?
Apparently it's the neck of the bottle. Try switching to cans.

 Web Hosting | Web Hosting Services

*
To prove that you're not a bot, enter this code
Anti-Spam Image

Leave a Comment

You must be logged in to post a comment.


Blog Tags:

Similar posts: