471,052 Members | 1,185 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,052 software developers and data experts.

help with error

I know nothing about this but am trying to create a table - can anyone see
whats wrong?
-----------------
Error

SQL-query :

CREATE TABLE journal(

'journalid'int( 11 ) NOT NULL AUTO_INCREMENT ,
'title'text NOT NULL ,
'description'text NOT NULL ,
'imagename'text NOT NULL ,
'entries'int( 11 ) NOT NULL default '0',
'views'int( 11 ) NOT NULL default '0',
'enabled'smallint( 6 ) default '0',
'timestamp'int( 11 ) NOT NULL default '0',
'userid'int( 11 ) NOT NULL default '0',
'mood'text NOT NULL ,
'np'text NOT NULL ,
PRIMARY KEY ( 'journalid' )
) TYPE = MYISAM

MySQL said:
#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
''journalid'int( 11 ) NOT NULL AUTO_INCREMENT ,
'title'text

Jul 20 '05 #1
1 1068
i found the error
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by wukexin | last post: by
5 posts views Thread by xuatla | last post: by
9 posts views Thread by YZK | last post: by
6 posts views Thread by Jax | last post: by
5 posts views Thread by Marc Violette | last post: by
1 post views Thread by Rahul | last post: by
12 posts views Thread by =?Utf-8?B?ZGdvdw==?= | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.