Summary of several uncommon SQL statements in MYSQL _ MySQL

Summary of several SQL statements that are uncommon in MYSQL: bitsCN. comMYSQL is a summary of several uncommon SQL statements // The txt file is loaded INTO the database LOAD DATA INFILE 'data.txt 'INTO TABLE table2FIELDS TERMINATED ','; // export the empty library 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, this information is generally a dynamic show status // MODIFY the original attribute of the field alter table ind_day_scale modify column avg_pv double unsigned not null default '0' comment' add PV/add UV '// change one UPDATE day_resinlog_2012_06_12 SET access_time = REPLACE (access_time, '2017-06-12 ', '2017-06-14') by lovemelovemycodebitsCN.com