SQL 메시지좀 봐주시면 안될까요 ㅠㅠ 정보
SQL 메시지좀 봐주시면 안될까요 ㅠㅠ본문
오류
SQL 질의:
--
--
-- --------------------------------------------------------
--
-- 테이블 구조 `g4_goods`
--
CREATE TABLE IF NOT EXISTS `g4_goods` (
`idx` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`c_code` varchar( 20 ) NOT NULL ,
`g_code` varchar( 20 ) NOT NULL ,
`g_name` varchar( 255 ) NOT NULL ,
`g_qty` int( 5 ) unsigned NOT NULL default '1',
`g_show` char( 1 ) NOT NULL default '1',
`g_order_flag` char( 1 ) NOT NULL default '1',
`g_order` int( 6 ) unsigned NOT NULL default '0',
`g_icon` varchar( 50 ) NOT NULL ,
`g_info` varchar( 255 ) NOT NULL ,
`g_sell_price` int( 10 ) unsigned NOT NULL ,
`g_price` int( 10 ) unsigned NOT NULL ,
`g_point` int( 10 ) unsigned NOT NULL ,
`g_option` text NOT NULL ,
`g_cnt` int( 10 ) unsigned NOT NULL default '100',
`g_min` int( 10 ) unsigned NOT NULL default '0',
`g_max` int( 10 ) unsigned NOT NULL default '0',
`g_create` varchar( 22 ) NOT NULL ,
`g_nation` varchar( 22 ) NOT NULL ,
`g_startdate` varchar( 22 ) NOT NULL ,
`g_enddate` varchar( 22 ) NOT NULL ,
`g_startdate` varchar( 22 ) NOT NULL ,
`g_enddate` varchar( 22 ) NOT NULL ,
`g_suc` int( 10 ) NOT NULL ,
`g_sale1` int( 10 ) NOT NULL ,
`g_sell_option` int( 10 ) NOT NULL ,
`g_tranc` varchar( 10 ) NOT NULL ,
`g_content` text NOT NULL ,
`g_sale` int( 10 ) unsigned NOT NULL ,
`g_hit` int( 10 ) unsigned NOT NULL ,
`g_img1` varchar( 100 ) NOT NULL ,
`g_img2` varchar( 100 ) NOT NULL ,
`g_img3` varchar( 100 ) NOT NULL ,
`g_datetime` datetime NOT NULL ,
PRIMARY KEY ( `idx` ) ) ENGINE = MYISAM DEFAULT CHARSET = euckr AUTO_INCREMENT =3;
MySQL 메시지:
#1060 - Duplicate column name 'g_startdate'
SQL 질의:
--
--
-- --------------------------------------------------------
--
-- 테이블 구조 `g4_goods`
--
CREATE TABLE IF NOT EXISTS `g4_goods` (
`idx` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`c_code` varchar( 20 ) NOT NULL ,
`g_code` varchar( 20 ) NOT NULL ,
`g_name` varchar( 255 ) NOT NULL ,
`g_qty` int( 5 ) unsigned NOT NULL default '1',
`g_show` char( 1 ) NOT NULL default '1',
`g_order_flag` char( 1 ) NOT NULL default '1',
`g_order` int( 6 ) unsigned NOT NULL default '0',
`g_icon` varchar( 50 ) NOT NULL ,
`g_info` varchar( 255 ) NOT NULL ,
`g_sell_price` int( 10 ) unsigned NOT NULL ,
`g_price` int( 10 ) unsigned NOT NULL ,
`g_point` int( 10 ) unsigned NOT NULL ,
`g_option` text NOT NULL ,
`g_cnt` int( 10 ) unsigned NOT NULL default '100',
`g_min` int( 10 ) unsigned NOT NULL default '0',
`g_max` int( 10 ) unsigned NOT NULL default '0',
`g_create` varchar( 22 ) NOT NULL ,
`g_nation` varchar( 22 ) NOT NULL ,
`g_startdate` varchar( 22 ) NOT NULL ,
`g_enddate` varchar( 22 ) NOT NULL ,
`g_startdate` varchar( 22 ) NOT NULL ,
`g_enddate` varchar( 22 ) NOT NULL ,
`g_suc` int( 10 ) NOT NULL ,
`g_sale1` int( 10 ) NOT NULL ,
`g_sell_option` int( 10 ) NOT NULL ,
`g_tranc` varchar( 10 ) NOT NULL ,
`g_content` text NOT NULL ,
`g_sale` int( 10 ) unsigned NOT NULL ,
`g_hit` int( 10 ) unsigned NOT NULL ,
`g_img1` varchar( 100 ) NOT NULL ,
`g_img2` varchar( 100 ) NOT NULL ,
`g_img3` varchar( 100 ) NOT NULL ,
`g_datetime` datetime NOT NULL ,
PRIMARY KEY ( `idx` ) ) ENGINE = MYISAM DEFAULT CHARSET = euckr AUTO_INCREMENT =3;
MySQL 메시지:
#1060 - Duplicate column name 'g_startdate'
댓글 전체
g_startdate 이 필드가 두개입니다.
`g_startdate` varchar( 22 ) NOT NULL , <=========
`g_enddate` varchar( 22 ) NOT NULL ,
`g_startdate` varchar( 22 ) NOT NULL , <=========
`g_enddate` varchar( 22 ) NOT NULL ,
`g_startdate` varchar( 22 ) NOT NULL , <=========