SQL Syntax help

Attempted table:

CREATE TABLE `displayid` (
`id` int(11) NOT NULL auto_increment,
`title` text,
`keyword` text,
`scode` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 7168 kB';

******************************************
Return from Cpanel SQL
SQL query:

CREATE TABLE `displayid` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` text,
`keyword` text,
`scode` longtext,
PRIMARY KEY ( `id` )
) ENGINE = InnoDB DEFAULT CHARSET = latin1 COMMENT = 'InnoDB free: 7168 kB'

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 'DEFAULT

CHARSET=latin1 COMMENT='InnoDB free: 7168 kB'' at line

What to do?

Thanks in Advance,

Mike

 

Thanks Kenneth! However it's a little deep for me.

Can someone just help me get this table to run?

Thanks again,

Mike

 

Hi David,

That is the attempted script install point. Try to see this from a newbie sight of view. I am simply trying to make a piece of software work by following instructions. In this case the code for the table is not working for this Cpanel set up. :

#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 'DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 7168 kB'' at line

So I am searching for a way to make my syntax work. I assume I must change the code a bit. But what?

Someone please help.

Mike

 

OK Thanks,

Mike