CODEWITHSUNDEEP
mysqlsql
David542
David542

Reputation: 110592

ALTER TABLE contents

I was reviewing a sql dump produced by an external application and I saw something like this:

/*!40000 ALTER TABLE `records` ENABLE KEYS */;
UNLOCK TABLES;

What does the line:

/*!40000 ALTER TABLE `records` ENABLE KEYS */;

mean? Is this a comment, or something else? What is 40000?

Upvotes: 1

Views: 644

Answers (1)

Michael Mior
Michael Mior

Reputation: 28772

Those are conditional comments. The 40000 refers to a specific version of MySQL. This is to allow commands to run on versions of MySQL where they are supported and be ignored otherwise. This blog post has some more information.

Upvotes: 3

Related Questions