[MySQL]Niepoprawna skladnia, ale gdzie? Opcje

[Raven1122]

Kod:

[SQL] pobierz, plaintext 
CREATE TABLE 'emes_konfiguracja'(
'config_id' int(11) NOT NULL AUTO_INCREMENT,
'config_name' varchar( 5 ) NOT NULL DEFAULT, 
'config_value' varchar(255) NOT NULL DEFAULT,
PRIMARY KEY( 'config_id' )
) TYPE=MYISAM AUTO_INCREMENT=15;
[SQL] pobierz, plaintext 

Blad:
#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 ''emes_konfiguracja'( 'config_id' int(11) NOT NULL AUTO_INCREMENT, 'config_name' at line 1

Ten post edytował Raven1122 28.08.2011, 21:27:13

[Raven1122]

[SQL] pobierz, plaintext 
CREATE TABLE `emes_konfiguracja` (
`config_id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`config_name` varchar( 5 ) NOT NULL DEFAULT none,
`config_value` varchar( 255 ) NOT NULL DEFAULT none,
PRIMARY KEY ( `config_id` )
) TYPE = MYISAM AUTO_INCREMENT =15;
[SQL] pobierz, plaintext 

#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 'none, `config_value` varchar(255) NOT NULL DEFAULT none, PRIMARY KEY( `config_id' at line 1

Co teraz?