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> CREAT E TABLE mytable (

-> name VARCHAR(20) ,

-> genda CHAR(1),

-> birth DATE ,

-> addr VARCHAR(20)

-> ) ;

mysql> SHOW COLUMNS FROM mytable ;

mysql> DESCRIBE mytable;

mysql> SELECT * FR OM mytable;

mysql> INSERT INTO mytable

-> VALUES (

-> 'cook',

-> 'M',

-> '1991-02-07' ,

-> 'China'

-> );

mysql > SELECT name // 排序后 输出第四个名字

-> FROM mytable

-> ORDER BY name DESC

-> LIMIT 3 1

查看更多关于MySQL常用语句笔记的详细内容...