Clever Geek Handbook

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 ;-)

+1


source to share


5 answers


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

+5


source


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.

+4


source


The Official MySQL Documentation is the best place. He has tutorials and links for everything

+3


source


This should point in the right direction: MySQL Syntax Syntax

+1


source


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.

+1


source






More articles:


All Articles