테스트 사이트 - 개발 중인 베타 버전입니다

SQL 간단한 질문..

· 14년 전 · 742 · 1
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, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

댓글 작성

댓글을 작성하시려면 로그인이 필요합니다.

로그인하기

댓글 1개

INSERT INTO g4_group values ('01', '월요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '')
INSERT INTO g4_group values ('02', '화요웹툰', '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '')

따로.. 이렇게 하시면 됩니다...
INSERT INTO g4_group (필드1, 필드2) values ('01', '월요웹툰') 요렇게 하는게 더 간단하겠네요

게시글 목록

번호 제목
284438
284437
284435
284430
284420
284417
284409
284401
284399
284397
284380
284378
284371
284370
284366
284364
284360
284357
284355
284354