In order to determine which MySQL version you're running you can type the following command: mysql -V Sample results: # mysql -V mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386) # mysql -V mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu…...
Once you start messing around with charsets in MySQL you eventually get to a situation where the default charset for your database is UTF-8 but you want to import old backups in their own charset, for instance ISO-LATIN-1. But when you import it, MySQL…...
Okay, I desperately lack time to write full articles posts lately, so I'm going to make this quick! :P Background: Suppose you have a table named Now, here's my point: from my experience I have found that a hell lot of things can go wrong when you try…...
I could not find anything like this on the net, so I thought I'd make my own chart and share it... ;) MySQL version 3.23.58 +InnoDB 4.0.22 4.1.7 5.0 Release date 11-sept-03 27-oct-04 23-oct-04 not stable yet Row level locking yes yes yes yes…...
PhpMyAdmin does a pretty decent job at exporting MySql database with their structure and/or their data to a plain SQL file. One thing bugged me though: it encloses every table/column/whatever name in backquotes like in Life is good! :D...
We had this quite interesting situation at work today: I export an UTF-8 MySQL database into an UTF_8 SQL file. I *binary* FTP the file over to him. He plays the SQL in PHPmyAdmin all configured for UTF-8. He then checks the data in PHPmyAdmin: special…...
Running an app under PHP 4.3.8 and trying to connect to a MySQL 4.1 database can be pretty frustrating. By default it gives you a message like this: "Client does not support authentication protocol requested by server; consider upgrading MySQL client".…...
(via Cédric) Jim Gray [Links gone]: "Larry Ellison announced that Oracle is now running entirely on Linux. But he didn't say, "Incidentally we're going to run all of Oracle on MySQL on Linux." If you just connected the dots, that would be…...
MySQL offers pretty useful functions when you want to manipulate days: You can add a time interval to a date value with ADDDATE() or DATE_ADD() You can subtract a time interval from a date value witf DATE_SUB() You can find the interval between two…
mySQL has been planing to implement stored procedures and triggers in mySQL 5 for some time now... But lately, it looks like it's just gonna get better than expected... Via Simon Willison (great blog!), from chromatic's wrap-up of OSCON day 3: Brian…...