mysql SHOW DATABASES; mysql CREATE DATABASE mydb; mysql USE mydb; mysql SHOW TABLES; mysql CREAT E TABLE mytable ( - name VARCHAR(20) , - genda CHAR(1), - birth DATE , - addr VARCHAR(20) - ) ; mysql SHOW COLUMNS FROM mytable ; mysql DESCRI
mysql> SHOW DATABASES;
mysql> CREATE DATABASE mydb;
mysql> USE mydb;
mysql> SHOW TABLES;
mysql> CREATE TABLE mytable (
-> name VARCHAR(20),
-> genda CHAR(1),
-> birth DATE,
-> addr VARCHAR(20)
-> );
mysql> SHOW COLUMNS FROM mytable;
mysql> DESCRIBE mytable;
mysql> SELECT * FROM mytable;
mysql> INSERT INTO mytable
-> VALUES (
-> 'cook',
-> 'M',
-> '1991-02-07',
-> 'China'
-> );
mysql> SELECT name //
排序后输出第四个名字
-> FROM mytable
-> ORDER BY name DESC
->
LIMIT 3 1
