오류
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'
댓글 2개
게시글 목록
| 번호 | 제목 |
|---|---|
| 284438 | |
| 284437 | |
| 284435 | |
| 284430 | |
| 284420 | |
| 284417 | |
| 284409 | |
| 284401 | |
| 284399 | |
| 284397 | |
| 284380 | |
| 284378 | |
| 284371 | |
| 284370 | |
| 284366 | |
| 284364 | |
| 284360 | |
| 284357 | |
| 284355 | |
| 284354 |
댓글 작성
댓글을 작성하시려면 로그인이 필요합니다.
로그인하기