Several SQL statements that are relatively uncommon in MySQL

// Input the txt file to the database
Load data infile 'data.txt 'into table table2
Fields terminated ',';

// Export the empty database table structure
Mysqldump-d-u xxx-p resin_log>/temp/dump. SQL

// View the MYSQL configuration. The information is generally static.
Show variables;
// View the MYSQL status. The information is generally dynamic.
Show status
// Modify the original attributes of a field
Alter table ind_day_scale modify column avg_pv double unsigned not null default '0' COMMENT 'add PV/Add UUV'
// Change the partial score of a field
UPDATE day_resinlog_2012_06_12 SET access_time = REPLACE (access_time, '2017-06-12 ', '2017-06-14 ')