리눅스 쉘상태에서 특정파일에 저장된 SQL문 실행하기 : 테이블생성

[root@RockyLinux ~]# cat temp3.sql

create table temptable (

uid mediumint(3) NOT NULL,

name varchar(12) NOT NULL,

PRIMARY KEY (uid)

);

[root@RockyLinux ~]#

[root@RockyLinux ~]# ls -l temp3.sql

-rw-r--r-- 1 root root 100  7월 11 14:05 temp3.sql

[root@RockyLinux ~]#

[root@RockyLinux ~]# mysql -u root -p temp_db < ./temp3.sql

Enter password:

[root@RockyLinux ~]#

[root@RockyLinux ~]# mysql -u root -p temp_db

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 MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 7

Server version: 10.5.16-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [temp_db]>

MariaDB [temp_db]>

MariaDB [temp_db]> show tables;

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

| Tables_in_temp_db |

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

| temptable         |

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

1 row in set (0.000 sec)

MariaDB [temp_db]>

MariaDB [temp_db]> desc temptable;

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

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

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

| uid   | mediumint(3) | NO   | PRI | NULL    |       |

| name  | varchar(12)  | NO   |     | NULL    |       |

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

2 rows in set (0.001 sec)

MariaDB [temp_db]>

MariaDB [temp_db]> exit

Bye

[root@RockyLinux ~]#