MySQL command operations in Linux

The Shell script for batch creation of database tables in Linuxshell is as follows: # createdatabaseandtableHOST

The Linux shell batch create database/table Shell script is as follows: # create database and table HOST =

Create databases/tables in batches using Linux shell

The Shell script is as follows:

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: