박씨빌더 sql질문입니당~ 정보
박씨빌더 sql질문입니당~본문
SQL 쿼리 :
CREATE TABLE `g4_auth` (
`mb_id` varchar(255) NOT NULL default '',
`au_menu` varchar(20) NOT NULL default '',
`au_auth` set('r','w','d') NOT NULL default '',
PRIMARY KEY (`mb_id`,`au_menu`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr
MySQL 메시지:
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=euckr' at line 6
euckr utf8다이럽니당 ㅠㅠ 인식이안되용~도와주셔용
CREATE TABLE `g4_auth` (
`mb_id` varchar(255) NOT NULL default '',
`au_menu` varchar(20) NOT NULL default '',
`au_auth` set('r','w','d') NOT NULL default '',
PRIMARY KEY (`mb_id`,`au_menu`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr
MySQL 메시지:
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=euckr' at line 6
euckr utf8다이럽니당 ㅠㅠ 인식이안되용~도와주셔용
댓글 전체
CREATE TABLE `g4_auth` (
`mb_id` varchar(255) NOT NULL default '',
`au_menu` varchar(20) NOT NULL default '',
`au_auth` set('r','w','d') NOT NULL default '',
PRIMARY KEY (`mb_id`,`au_menu`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
";"요거 빠졌네용
`mb_id` varchar(255) NOT NULL default '',
`au_menu` varchar(20) NOT NULL default '',
`au_auth` set('r','w','d') NOT NULL default '',
PRIMARY KEY (`mb_id`,`au_menu`)
) ENGINE=MyISAM DEFAULT CHARSET=euckr;
";"요거 빠졌네용
