Where is the best fit for MySQL 5.0 syntax?
Where can I find a manual for MySQL 5.0 syntax? What do I need, this tutorial that matches my version of MySQL server (MySQL 5.0)?
With that in mind: I am using MySQL 5.0 and NaviCat for the GUI. If I run this query:
CREATE TABLE `genres` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`genre_name` VARCHAR( 25 ) NOT NULL
`description` VARCHAR( 100 ) NOT NULL
) ENGINE = innodb;
-> Navicat gives me a check for your syntax error as well as a sql hint ..
Where can I find information on SQL 5.0 syntax? I tried the SQL site and Googled but no luck. Maybe I'm really an idiot ;-)
http://dev.mysql.com/doc/refman/5.0/en/
Specifically for the CREATE TABLE statement:
http://dev.mysql.com/doc/refman/5.0/en/create-table.html
How about http://dev.mysql.com/doc/refman/5.0/en/sql-syntax.html ?
Your request has a missing coma (,) between the third and fourth lines.
The Official MySQL Documentation is the best place. He has tutorials and links for everything
This should point in the right direction: MySQL Syntax Syntax
It looks like you are missing the comma at the end of this line (comma added):
`genre_name` VARCHAR( 25 ) NOT NULL,
You need a comma after every line except the last line of the create table statement.