MySQL技术手册要点解析-3
21.mysql默认情况下是autocommit的,如果要修改可以设置SET autocommit = 0或者以START TRANSACTION;起头后面就需要commit了
13.2.2.2. Grouping DML Operations with Transactions
13.2.2.2. Grouping DML Operations with Transactions
SHOW TABLES;
SHOW DATABASES;
desc table_name;
LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet LINES TERMINATED BY '\r\n';
load data infile '/tmp/t0.txt' into table t0 character set gbk fields terminated by ',' enclosed by '"' lines terminated by '\n' (`name`,`age`,`description`) set update_time=current_timestamp;
1.8.2. Selecting SQL Modes
The MySQL server can operate in different SQL modes, and can apply these modes differentially for different clients. This capability
enables each application to tailor the server's operating mode to its own requirements.
SQL modes control aspects of server operation such as what SQL syntax MySQL should support and what kind of data validation