SQL Syntax help

[distinctedge]

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

 

[cPanelKenneth]

What to do?

Thanks in Advance,

Mike

Read the manual: http://dev.mysql.com/doc/refman/5.0/en/create-table.html

 

[distinctedge]

Read the manual: http://dev.mysql.com/doc/refman/5.0/en/create-table.html

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

Can someone just help me get this table to run?

Thanks again,

Mike

 

[cPanelDavidG]

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

Can someone just help me get this table to run?

Thanks again,

Mike

Why not just create it in phpMyAdmin?

 

[distinctedge]

Why not just create it in phpMyAdmin?

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

 

[cPanelDavidG]

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

Your choices are:

1. Contact the script developer for assistance (usually the best thing to do)
2. Read the SQL code and use phpMyAdmin to generate the same table
3. Learn SQL, read the MySQL manual and adjust the code accordingly

This is not a cPanel-specific issue.

 

[distinctedge]

OK Thanks,

Mike