CREATE TABLE users ( u_id int(11) NOT NULL AUTO_INCREMENT, u_name varchar(32) NOT NULL DEFAULT '', u_password varchar(40) NOT NULL DEFAULT '', u_email varchar(64) NOT NULL DEFAULT '', u_activation_key varchar(40) NOT NULL DEFAULT '', u_active int(1) NOT NULL DEFAULT '0', PRIMARY KEY (u_id) ) ENGINE=MyISAM DEFAULT CHARSET=latin2;
I wyskakuje mi taki błąd:
Cytat
Błąd
zapytanie SQL:
CREATE TABLE users(
u_id int( 11 ) NOT NULL AUTO_INCREMENT ,
u_name varchar( 32 ) NOT NULL default '',
u_password varchar( 40 ) NOT NULL default '',
u_email varchar( 64 ) NOT NULL default '',
u_activation_key varchar( 40 ) NOT NULL default '',
u_active int( 1 ) NOT NULL default '0',
PRIMARY KEY ( u_id )
) ENGINE = MYISAM DEFAULT CHARSET = latin2
MySQL zwrócił komunikat:
#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=latin2' at line 9
zapytanie SQL:
CREATE TABLE users(
u_id int( 11 ) NOT NULL AUTO_INCREMENT ,
u_name varchar( 32 ) NOT NULL default '',
u_password varchar( 40 ) NOT NULL default '',
u_email varchar( 64 ) NOT NULL default '',
u_activation_key varchar( 40 ) NOT NULL default '',
u_active int( 1 ) NOT NULL default '0',
PRIMARY KEY ( u_id )
) ENGINE = MYISAM DEFAULT CHARSET = latin2
MySQL zwrócił komunikat:
#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=latin2' at line 9
Gdzie w tym poleceniu jest błąd?
@edit
Zmieniłem i dalej błąd :/
Dziękuję, Babcia@Stefa