Error when creating database in MySQL using Netbeans 6.8

Question

I am trying to create a database using MySQL statements in NetBeans 6.8. However, I keep getting Error code 1064. I don't know what the problem is really since the same statements work in NetBeans 6.0. Here is the error:

Error code 1064, SQL state 42000: 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 '; /*!40000 ALTER TABLE students ENABLE KEYS */;

-- -- Definition of table `w' at line 1016 Line 46, column 1

Answer 1

This can be due to the previous SQL statements also. If you can post your SQL script, the problem can be traced.