Loading ...Strangely enough, select *,colname from tbname; works just fine, whereas select colname,* from tbname; fails! So if you would like to see all columns, but have one or more of them displayed to the left of the set, you have only one way left to do it ‘comfortably’: select colname,tbname.* from tbname; well two really [...]
This is not a technical post, but rather an informative appeal to ALL of you MySQL users. If you encounter a bug whilst working on MySQL look it up on bugs.mysql.com and if you find it: DON’T STOP THERE!! Comment on the bug report, explaining you too found the problem and would like it fixed! [...]
Next time you have an error whilst running an sql script into mysql using the pretty easy redirect into eg: mysql -uroot -pmsandbox -h127.0.0.1 -P3306 dbname < filename you might want to give the -v option a shot. MySQL normally outputs an error with the line number like: [mysql@dcassar-ubuntu /mysql/dumps/stored_procs 11:10:12]$ mysql -uroot -pmsandbox -h127.0.0.1 [...]
Last Tuesday I read the post from Dave where he encouraged people to give drizzle a shot. It got me thinking “why on earth have I not tried it before?” and so Wednesday night, having the options of watching criminal minds or dexter on tv or compiling drizzle, i figured, lets do the right thing [...]