Create database tables in batches using Shell in CentOS

Create database tables in batches using Shell in CentOS

This article continues to explore the combination of Shell and MySQL. I don't know how to quickly create a database table and add the corresponding basic data after a database is designed, I currently know how to use Shell and SQL scripts to achieve my goal-Quickly, multiple times, and reusable database tables.

Create an SQL script for a database table:

[Cpp] view plaincopy

1. /*************************************** *********************
2. # Author: chisj
3. # Date: 2015.7.22
4. # Describe: CreateDatabase 'smartcare' Table 'sct _ Province'
5. **************************************** *********************/
7. USESmartCare;
9. DROPTABLEIFEXISTS 'sct _ Province ';
11. CREATETABLE 'sct _ Province '(
12. 'Provinceid' int (11) unsignedNOTNULLAUTO_INCREMENT,
13. 'Provincecode' varchar (11) DEFAULTNULL,
14. 'Parentid' varchar (11) DEFAULTNULL,
15. 'Vincename' varchar (50) DEFAULTNULL,
16. 'Level' tinyint (1) DEFAULTNULL,
17. PRIMARYKEY ('primaryid ')
18. ) ENGINE = MyISAMAUTO_INCREMENT = 1 DEFAULTCHARSET = utf8;

Execute Shell scripts for all SQL scripts (Multiple SQL scripts in the specified directory) in the specified directory:

[Plain] view plaincopy

1. #! /Bin/bash
3. # Author: chisj
4. # Time: 2015.7.22
5. # Describe: CreateDatabaseTable
7. # Theusernameofmysqldatabase
8. USER = "root"
10. # Thepasswordofmysqldatabase
11. PASS = "dragonwake"
13. # Thedatebasenamewillbecreated
14. DATABASE = "SmartCare"
16. LOCATION =$ {PWD}
17. CREATE_TABLE_SCT = create_table_sct _
19. Fortable_namein 'ls $ {LOCATION}/$ {CREATE_TABLE_SCT }*'
20. Do
22. Mysql-u $ USER-p $ PASS <EOF>/dev/null
24. SOURCE $ {table_name };
26. EOF
28. If [$? -Eq0]; then
30. Echo "CreateTable $ {table_name} Success! "
32. Fi
34. Done

In fact, there are many ways to create data tables in batches using Shell. I have seen it before. Unfortunately, I did not remember 0.0. It is obvious that records are very important.

So I made it again according to my ideas: First, it is necessary to write the SQL script for creating a data table, and write all the data into one (I personally think it is not good ), you can also write an SQL script according to a table (this method is currently used in our city). Then, traverse the SQL script name in the specified directory and find an SQL script for creating a database table, then run the command once.

It also provides the CSDN: Shell to create a MySQL DATA table.