현재 위치

홈 ›› Forums ›› 공부 ›› 프로그래밍 QnA

안녕하십니까.. 데이터베이스... 테이블작성이안됩니다.;

rlaanwnd10의 이미지
글쓴이: 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: 
프로그래밍 QnA
dgkim의 이미지

글쓴이: dgkim / 작성시간: 토, 2013/12/14 - 12:54오후

내용을 아래와 같이 갈무리해서 보여주시면 도움이 됩니다.

저는 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>

둘러보기