Jump to content

[SOLVED] create table problem, check the table please


plodos

Recommended Posts

MySQL Version: 5.0.16

CREATE TABLE IF NOT EXISTS `research_field` (
  `id` int(11) NOT NULL auto_increment,
  `field` varchar(250) collate latin1_general_ci NOT NULL
)

CREATE TABLE IF NOT EXISTS `reviewer_research_field` (
  `user` int(11) NOT NULL,
  `research_field_id` int(11) NOT NULL
)

Error : #1064 - 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 'CREATE TABLE IF NOT EXISTS `reviewer_research_field` (

  `user` int(11) NOT NUL' at line 7

 

 

What is the problem ?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.