MySQL

Problems with MySQL conditional statements

(from http://www.mysqlfront.de/forum/viewtopic.php?p=11079

I've been tearing my hair out trying to work out why a MySQL dump won't import to my web host using phpMyAdmin. Error was:


Error

SQL query:

-- Host: localhost Database: mydb
-- ------------------------------------------------------
-- Server version 4.1.12a-nt
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

MySQL said: Documentation
#1065 - Query was empty

I didn't really understand what these statements meant, but now I know that they refer to "conditional" SQL statement, only to be executed if the MySQL database version is equal or greater to that specified. In this case, /*40101 refers to version 4.1.1.

Syndicate content