ja den her sql kode som jeg skal have ind i mysql kode:
1. CREATE TABLE `users` (
2. `ID` int(11) NOT NULL auto_increment,
3. `Username` varchar(255) NOT NULL,
4. `Password` varchar(255) NOT NULL,
5. `Temp_pass` varchar(55) default NULL,
6. `Temp_pass_active` tinyint(1) NOT NULL default '0',
7. `Email` varchar(255) NOT NULL,
8. `Active` int(11) NOT NULL default '0',
9. `Level_access` int(11) NOT NULL default '2',
10. `Random_key` varchar(32) default NULL,
11. PRIMARY KEY (`ID`),
12. UNIQUE KEY `Username` (`Username`),
13. UNIQUE KEY `Email` (`Email`)
14. ) ENGINE=MyISAM;
men hver gang siger den den her fejl:
Fejl
SQL-forespørgsel:
1. CREATE TABLE `users` (
2. `ID` int( 11 ) NOT NULL AUTO_INCREMENT ,
3. `Username` varchar( 255 ) NOT NULL ,
4. `Password` varchar( 255 ) NOT NULL ,
5. `Temp_pass` varchar( 55 ) default NULL ,
6. `Temp_pass_active` tinyint( 1 ) NOT NULL default '0',
7. `Email` varchar( 255 ) NOT NULL ,
8. `Active` int( 11 ) NOT NULL default '0',
9. `Level_access` int( 11 ) NOT NULL default '2',
10. `Random_key` varchar( 32 ) default NULL ,
11. PRIMARY KEY ( `ID` ) ,
12. UNIQUE KEY `Username` ( `Username` ) ,
13. UNIQUE KEY `Email` ( `Email` ) 14.
) ENGINE = MYISAM
MySQL returnerede: Dokumentation
#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 '1. CREATE TABLE `users` (
2. `ID` int(11) NOT NULL auto_increment,
' at line 1
nogen der kan hjælpe