|
[root@linux mysql]# ./bin/mysql MY_DB -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \.
Your MySQL connection id is 21 to server version: 3.22.23b
Type 'help' for help.
mysql> show databases;
+-----------+
| Database |
+-----------+
| COOLBBS |
| MY_DB |
| SEARCH |
| WEBSURVEY |
| WWWDB |
| count |
| mysql |
| test |
+-----------+
8 rows in set (0.01 sec)
mysql> show tables;
Empty set (0.00 sec)
mysql> CREATE TABLE goods (
-> id int(11) DEFAULT '0' NOT NULL auto_increment,
-> org_name varchar(20),
-> number varchar(15),
-> list varchar(20),
-> price int(10),
-> count int(10),
-> tprice int(10),
-> PRIMARY KEY (id)
-> );
Query OK, 0 rows affected (0.01 sec)
mysql> show tables;
+-----------------+
| Tables in MY_DB |
+-----------------+
| goods |
+-----------------+
1 row in set (0.00 sec)
mysql> CREATE TABLE order (
-> id int(11) DEFAULT '0' NOT NULL auto_increment,
-> org_name varchar(20),
-> recip_name varchar(20),
-> org_phone varchar(20),
-> recip_phone varchar(20),
-> recip_addr varchar(60),
-> comment text,
-> reg_date datetime,
-> PRIMARY KEY (id)
-> );
ERROR 1064: 'SQL 구문에 오류가 있습니다.' 에러 같읍니다. ('order (
id int(11) DEFAULT '0' NOT NULL auto_increment,
org_name varchar(2' 명령어 라인 1)
mysql>
|
