Member Avatar for jeffm2008

Hi guys...

I know little to nothing about this and i was told to run this command, but I got this error when I did...does any know the correct syntax for this? I appreciate your help and thank you in advance!

Error

SQL query:

CREATE TABLE wp_wpmq(
id int( 11 ) NOT NULL AUTO_INCREMENT ,
email varchar( 100 ) NOT NULL default '',
subject varchar( 100 ) NOT NULL default '',
message text NOT NULL default '',
headers text,
attachments text PRIMARY KEY ( id )
)

MySQL said: Documentation
#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 '(id) )' at line 1

  • 2 Contributors
  • 1 Reply
  • 92 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by darkagn
Member Avatar for darkagn

Hi jeffm2008 and welcome to DaniWeb :)

You need a comma after your last column name and before the words PRIMARY KEY. Like so:

attachments text, PRIMARY KEY ( id )
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.