Archive for June, 2010

mysql jdbc connector autoReconnect=true

Posted: 16th June 2010 by Darren Cassar in MySQL, Networking
Tags: , , , , , , ,
3

What makes you think jdbc autoreconnect is needed? Application is idle for long periods at a time? Wait_timeout too short? Network failure or glitches? Some good suggestions form Mark Matthews – Bug #5020 Having encountered the problem again myself today, trying to make jdbc for mysql reconnect any terminated connections using autoreconnect=true I figured out [...]

Datetime & Timestamp manipulation / migration explained

Posted: 15th June 2010 by Darren Cassar in Advanced, Intermediate, MySQL
Tags: , , , , , , , ,
2

Are you doing some datetime manipulation or maybe you are migrating from some database technology to MySQL or possibly using milliseconds? Here is an example on how to go about it: Say you have the following date: MAR 16 2008 09:12:51:893AM SELECT DATE_FORMAT(STR_TO_DATE(‘MAR 16 2008 09:12:51:893AM’,'%M %d %Y %h:%i:%s:%f%p’),’%Y%m%d%k%i%s.%f’); –> 2008031691251.893000 What if its PM [...]

Show warnings with MANY MANY warnings

Posted: 14th June 2010 by Darren Cassar in MySQL
Tags: , , , ,
0

What to do when you have too many warnings and would like to check them out. Say you were trying to run a query which returned a heap of warnings and you want to go through the list …. mysql> load data infile ‘/aaa/bbb/ccc’ into table xyz LINES TERMINATED BY ‘\r\n’; Query OK, 0 rows [...]