MySQL version


#1

Just making sure I’m reading this correctly…

[quote]mysql -V
[/quote]

mysql Ver 14.7 Distrib 4.1.8, for pc-linux (i386)

" If you specify the ON DUPLICATE KEY UPDATE clause (new in MySQL 4.1.0)"
http://dev.mysql.com/doc/mysql/en/insert.html

So that should work on this version of MySQL… ?

“You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON DUPLICATE KEY UPDATE…”


#2

DreamHost is currently using MySQL server 4.0.23.

mysql -V gives the version of the MySQL client which is currently 4.1.8 on the DreamHost servers. To get the server version, you have to connect to your server:

$ mysql -h -u -p

It will print out something like:

Your MySQL connection id is 56907 to server version: 4.0.23a-log