리눅스 쉘상태에서 특정파일에 저장된 SQL문 실행하기 : 테이블생성 (mysql 응용편 #3)

[root@file bin]# cat temp3.sql

create table temptable (

 uid mediumint(3) NOT NULL,

 name varchar(12) NOT NULL,

 PRIMARY KEY (uid)

);

[root@file bin]#

[root@file bin]# pwd

/usr/local/mysql/bin

[root@file bin]#

[root@file bin]# ls -l temp3.sql

-rw-r--r--    1 root     root          103  2월 13 16:18 temp3.sql

[root@file bin]#

[root@file bin]# ./mysql -u tempuser -p temp_db2 < ./temp3.sql

Enter password: ********

[root@file bin]#

[root@file bin]# ./mysql -u tempuser -p temp_db2

Enter password: ********

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 23 to server version: 4.0.14

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

mysql> show tables;

+--------------------+

| Tables_in_temp_db2 |

+--------------------+

| temptable          |

+--------------------+

1 row in set (0.00 sec)

mysql> desc temptable;

+-------+--------------+------+-----+---------+-------+

| Field | Type         | Null | Key | Default | Extra |

+-------+--------------+------+-----+---------+-------+

| uid   | mediumint(3) |      | PRI | 0       |       |

| name  | varchar(12)  |      |     |         |       |

+-------+--------------+------+-----+---------+-------+

2 rows in set (0.00 sec)

mysql>

mysql> exit

Bye

[root@file bin]#