MySQL常用语句笔记

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