MySQL 起步

1.查看当前数据库版本

mysql>SELECT version();

+---------------------+
| version()           |
+---------------------+
| 5.1.41-3ubuntu12.10 |
+---------------------+

2.在数据库中查看当前日期

mysql>SELECT current_date;

+--------------+
| current_date |
+--------------+
| 2012-03-09   |
+--------------+

3.查看所有数据库

mysql> SHOW databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| baby               |
+--------------------+

4.查看baby库中的所有表

mysql> SHOW tables;
+----------------+
| Tables_in_baby |
+----------------+
| info           |
+----------------+
前提：必须使用某个库

 

5.使用baby这个库

mysql> USE baby;
Database changed

6.创建表

mysql> CREATE TABLE info (name VARCHAR(20),sex CHAR(1));

或 将创建表的命令写到一个文件，然后引用。

mysql> SOURCE /baby_info.sql

 

5.创建用户并授权

mysql> grant select,delete,update,create,alter,drop,insert on baby.* to baby@localhost identified by 'baby';
Query OK, 0 rows affected (0.01 sec)

 

5.查看表中的所有信息

mysql> SELECT * FROM info;
+------+------+
| name | sex  |
+------+------+
| lz   | F    |
+------+------+
1 row in set (0.00 sec)

查看表结构

mysql> DESC info;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name  | varchar(20) | YES  |     | NULL    |       |
| sex   | char(1)     | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.08 sec)

查看某个表所使用的字符集（即查看创建表结构时内容）

mysql>show create table info;

 

查看用户名密码

mysql> select User,Password,Host from user;
+------------------+-------------------------------------------+-----------+
| User             | Password                                  | Host      |
+------------------+-------------------------------------------+-----------+
| root             | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | localhost |
| root             | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | 127.0.0.1 |
| debian-sys-maint | *B901D9CE0D01AA53BBED7AB53C73D8F8BCF4C286 | localhost |
| baby             | *A9E1930EB72840C5CE376770A0BF0681373ECDEB | 127.0.0.1 |
| baby             | *A9E1930EB72840C5CE376770A0BF0681373ECDEB | localhost |
+------------------+-------------------------------------------+-----------+
5 rows in set (0.00 sec)