안녕하십니까.. 데이터베이스... 테이블작성이안됩니다.;
글쓴이: rlaanwnd10 / 작성시간: 토, 2013/12/14 - 1:21오전
mysql 5.6 command line client 프로그램사용합니다.
create table ticket(
num int,
price int,
seat_no int,
theater_no int,
movie_no int,
day date,
primary key(num)
);
테이블작성뒤에... 데이터값을넣는데 계속오류가납니다.
insert into ticket
values(1,'8000','56','1','1','2012-11-20')
이런식으로 쭈욱값을 넣고 ; 마무리했는데
오류 1064(42000) 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 values(2,'8000','56','1','1','2012-11-20') values(3,'8000','56','1','1','2012-11-20' at line 3 가나옵니다.
해결법좀알려주세요. 시험을 봐야하는데 되지를않습니다.
Forums:
내용을 갈무리해서 보여주십시오.
내용을 아래와 같이 갈무리해서 보여주시면 도움이 됩니다.
저는 5.5에서 정상적으로 insert 가능했습니다.
dgkim@dbtest:~$ mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 65466 Server version: 5.5.34-0ubuntu0.13.04.1 (Ubuntu) Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use dgkim; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> create table ticket( -> num int, -> price int, -> seat_no int, -> theater_no int, -> movie_no int, -> day date, -> primary key(num) -> ); Query OK, 0 rows affected (0.14 sec) mysql> insert into ticket -> values(1,'8000','56','1','1','2012-11-20'); Query OK, 1 row affected (0.10 sec) mysql> select * from ticket; +-----+-------+---------+------------+----------+------------+ | num | price | seat_no | theater_no | movie_no | day | +-----+-------+---------+------------+----------+------------+ | 1 | 8000 | 56 | 1 | 1 | 2012-11-20 | +-----+-------+---------+------------+----------+------------+ 1 row in set (0.00 sec) mysql>댓글 달기