Re: Trigger and "Warning: #1265 Data truncated"

2009-06-09 Thread Keith Edmunds
> Curdate() returns a datetime, which you are pushing into a date field. > It is truncating the time part. Just truncate it and you should be > fine :) Hmmm. Not according to http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_curdate or, indeed, experiments: mysql> selec

RE: IDE - SQLYog

2009-06-09 Thread Daevid Vincent
SQLYog by Webyog is the best mySQL GUI client for Windows. Hands down. not even a question. I've used them all I think. http://webyog.com/en/ There's even a free "community" version, but honestly it's worth purchasing the extended one for all the added features. They also release new ones all the

IDE

2009-06-09 Thread Mosaed zamil
Hello all, I used Database Workbench on trial bases. It is nice. I plan to purchase an IDE. Is is it the best around. Your feed back is appreciated. yours mosaed

Re: Compile problem (was: MySQL Community Server 5.1.35 has been released)

2009-06-09 Thread Joerg Bruehe
Dave, do you really consider it helpful to do "reply all" to a release announcement, trying to send it to the "announce" and "packagers" list, including a full quote of the announcement text, and using the original subject line, when you are asking for help about a compile problem? Dave Shariff