CREATE TABLE webmemo_login_user (
no int(11) NOT NULL auto_increment,
member_no int(11) NOT NULL default '0',
userid varchar(15) NOT NULL default '',
name varchar(20) NOT NULL default '',
age varchar(3) NOT NULL default '-1',
sex enum('M', 'F') default 'M',
level varchar(5) not null default '10',
is_login enum('Y', 'N') default 'Y',
check_time int(13) default 0,
UNIQUE (userid),
PRIMARY KEY (no)
);
ÀÌ·¸°Ô sql ¹®À» ¸¸µé¾î Å×À̺íÀ» Çü¼ºÇÏ·Á°í Çϴµ¥ ¿¡·¯°¡ ³ª³×¿ä
¿À·ù
SQL ÁúÀÇ :
CREATE TABLE webmemo_login_user(
no int( 11 ) NOT NULL AUTO_INCREMENT ,
member_no int( 11 ) NOT NULL default '0',
userid varchar( 15 ) NOT NULL default '',
name varchar( 20 ) NOT NULL default '',
age varchar( 3 ) NOT NULL default '-1',
sex enum( 'M', 'F' ) default 'M',
LEVEL varchar( 5 ) NOT NULL default '10',
is_login enum( 'Y', 'N' ) default 'Y',
check_time int( 13 ) default0,
UNIQUE (
userid
),
PRIMARY KEY ( no )
)
MySQL ¸Þ½ÃÁö:
You have an error in your SQL syntax near 'default0,
UNIQUE ( userid ),
PRIMARY KEY ( no ) )' at line 9
¾îµð¸¦ °íÃÄ¾ß ÇÏ´ÂÁö Àß ¸ô¶ó¼¿ä ÁöµµÁ» ÇØÁÖ¼¼¿ä
|