MySQL Command Line

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;