Create a table in MySQL issue...

longsack

I'm using MySQL 5... Here is the table i'm trying to create...

mysql_query("CREATE TABLE daily (date VARCHAR(10) PRIMARY KEY,incoming MEDIUMINT(7) UNSIGNED,uniques MEDIUMINT(7) UNSIGNED,out MEDIUMINT(7) UNSIGNED,clicks MEDIUMINT(7) UNSIGNED) TYPE=MyISAM") or error(0, 740);

Here is the error I'm getting?
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 'out MEDIUMINT(7) UNSIGNED,clicks MEDIUMINT(7) UNSIGNED) TYPE=MyISAM' at line 1

Any idea whats wrong with it?

Thanks
jeremy

rsmith

Are you trying to create the table on the fly? If not I would recommend something like phpMyAdmin to help build your structure... unless of course it's not an option... I'm not great with SQL but I didn't think you could put UNSIGNED if you specified a length for the column type?

halojoy

rsmith wrote:
Are you trying to create the table on the fly?
If not I would recommend something like phpMyAdmin to help build your structure...
unless of course it's not an option...

I'm not great with SQL but
I didn't think you could put UNSIGNED
if you specified a length for the column type?

This is another way to write same code.
I use this, because I think it is easy to see each COLUMN
and do changes:

mysql_query(
"CREATE TABLE daily (
date VARCHAR(10) PRIMARY KEY,
incoming MEDIUMINT(7) UNSIGNED,
uniques MEDIUMINT(7) UNSIGNED,
out MEDIUMINT(7) UNSIGNED,
clicks MEDIUMINT(7) UNSIGNED
)
 TYPE=MyISAM") 
or error(0, 740);

regars 🙂
halojoy

NogDog

"out" is a reserved word, so it will need to be quoted with "back-ticks" if you want to use it as a column or table identifier. Or, you could just get into the habit of "back-ticking" all such identifiers and not having to worry about whether or not they are reserved words.

longsack

It is part of a install script .... so create on the fly...

Part of the code...

so not sure how to deal with it with MySQL... still very green with PHP/MySQL.. 🙂