MySQL command operations in Linux

Create databases/tables in batches using Linux shell

The Shell script is as follows:

1. # Create database and table
2. HOST ='Localhost'
3. PORT ='123'
4. USER ='Root'
5. PWD =''
6. DBNAME ='Top123'
7. TABLENAME ='Gametop800'
9. Mysql_login =''
10. Mysql_create_db =''
11. Mysql_create_table =''
14. Function mysql_create (){
15. Echo"Login mysql $ HOST: $ PORT ..."
16. Mysql_login ="Sudo mysql-h $ HOST-P $ PORT-u $ USER"# Mysql-h host-P port-u root-p pwd
17. Echo | $ {mysql_login}
18. If[$? -Ne0]; Then
19. Echo"Login mysql $ {HOST }:$ {PORT} failed .."
20. Exit1
21. Fi
23. Echo"Create database $ DBNAME ..."
24. Mysql_create_db ="Create database if not exists $ DBNAME"
25. Echo $ {mysql_create_db} | $ {mysql_login}
26. If[$? -Ne0]; Then
27. Echo"Create db $ {DBNAME} failed .."
28. Exit1
29. Fi
31. Echo"Create table $ TABLENAME ..."
32. Mysql_create_table = "create table $ TABLENAME (
33. Id char (50)NotNull,
34. Top int,
35. Name char (100),
36. Category char (50),
37. Rating float,
38. Ratingcount char (20),
39. Download char (30),
40. Price char (20),
41. Publishdate char (20),
42. Version char (40),
43. Filesize char (40),
44. RequireAndroid char (40),
45. Contentrating char (40),
46. Country char (10),
47. Dtime datetimeNotNull,
48. Primary key (id, dtime)
49. )"
51. Echo $ {mysql_create_table} | $ {mysql_login }$ {DBNAME}
52. If[$? -Ne0]; Then
53. Echo"Create table $ {TABLENAME} fail ..."
54. Exit1
55. Fi
57. Echo"Create table $ {TABLENAME} success! "
58. }

After the script is executed, the result is as follows:

MySQL slave common operation commands:

Show Database

ShowDatabases;

Switch Database
UseTop123;

Show database tables

ShowTables;

Modify primary key

Alter table gametop800 add primary key (Id);

Delete primary key

Alter table gametop800DropPrimary key;

Add composite primary key

Alter table gametop800 add primary key (Id, dtime);

If you are interested, you can use more complex syntaxes such as awk, cut, paste, regular expressions, and database operations to complete MySQL database operations.

The following describes how to capture webpages, extract features, extract information, summarize results, and insert data into databases in batches for permanent storage.

Example: