MySQL常用语句笔记

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