SQL 간단한 질문..
DB에 삽입할때는 INSERT INTO 를 쓰잖습니까...
아래 식이 왜 틀렸는지 설명부탁드리며, 올바른 식을 적어주시면 감사하겠습니다.
INSERT INTO g4_group values
('01', '월요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('02', '화요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('03', '수요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('04', '목요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('05', '금요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('06', '토요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('07', '일요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('08', '커뮤니티', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('09', '고객센터', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
아래 식이 왜 틀렸는지 설명부탁드리며, 올바른 식을 적어주시면 감사하겠습니다.
INSERT INTO g4_group values
('01', '월요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('02', '화요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('03', '수요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('04', '목요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('05', '금요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('06', '토요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('07', '일요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('08', '커뮤니티', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
('09', '고객센터', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
|
댓글을 작성하시려면 로그인이 필요합니다.
댓글 1개
INSERT INTO g4_group values ('02', '화요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '')
따로.. 이렇게 하시면 됩니다...
INSERT INTO g4_group (필드1, 필드2) values ('01', '월요웹툰') 요렇게 하는게 더 간단하겠네요