|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
HELP with mySQL commands! Newbie!
Hello
I'm trying to install a php tool called Sitemapper that I DL from hotscripts.com There is a SQL txt file that I tried to cut/paste into PHPmyAdmin, Here is what I get: SQL-query : CREATE TABLE /*!32300 IF NOT EXISTS*/ section ( sectionID int(3) NOT NULL auto_increment, parentID int(3) NOT NULL DEFAULT '0', title varchar(255) NOT NULL DEFAULT '', content text , PRIMARY KEY (sectionID), INDEX title (title) ); MySQL said: You have an error in your SQL syntax near ''0', title varchar(255) NOT NULL DEFAULT '', content text , PRIMARY' at line 3 Anyone know what is wrong with the SQL entry? Thanks!!! |
|
#2
|
||||
|
||||
|
RE: HELP with mySQL commands! Newbie!
Use:
CREATE TABLE section ( sectionID int(3) NOT NULL auto_increment, parentID int(3) NOT NULL DEFAULT '0', title varchar(255) NOT NULL DEFAULT '', content text , PRIMARY KEY (sectionID), INDEX title (title) ); |
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > HELP with mySQL commands! Newbie! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|