mysql> CREATE DATABASE hibernate_first; DROP DATABASE hibernate_first;
mysql> USE hibernate_first; --> db name
mysql> SHOW TABLES;
mysql> SHOW DATABASES;
mysql> DESC user; --> table name
mysql> DROP TABLE user;
mysql> \. c:\\mysql_script\\mydata.sql
mysql> INSERT INTO dept VALUES (10, 'A', 'A');
mysql> COMMIT;
mysql> SELECT * FROM dept ORDER BY deptno DESC LIMIT 3, 2 -- 取第三条往后的两条
mysql> CREATE TABLE dept
-> (
-> deptno int primary key auto_increment,
-> dname varchar(14),
-> Ico varchar(13)
-> );
mysql> SELECT now();
mysql> SELECT date_format(now(), '%Y-%m-%d %H:%i:%s');
mysql>
mysql>
6. SELECT @@tx_isolation;
7. SET TRANSACTION isolation level read uncommitted;