MySQL使用手册1.0

创建数据库

mysql> create database testDB;

进入数据库

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

查看user表中的数据

mysql> select host,user,authentication_string from user;
+-----------+-----------+-------------------------------------------+
| host      | user      | authentication_string                     |
+-----------+-----------+-------------------------------------------+
| localhost | root      | *19D5FB7B00222F3EA3A9032E5C1AEDCC69F08A91 |
| localhost | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| %         | huang     |                                           |
| localhost | huang     | *19D5FB7B00222F3EA3A9032E5C1AEDCC69F08A91 |
+-----------+-----------+-------------------------------------------+
4 rows in set (0.01 sec)

将数据库 testDB 的所有权限 赋予用户 Huang

mysql> grant all on testDB.* to huang;

列出数据库列表

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| testDB             |
+--------------------+

查看表的信息

mysql> select * from user;

建立Student表

mysql> create table Student
    -> (Sno char(9) primary key,
    -> Sname char(20) unique,
    -> Ssex char(2),
    -> Sage smallint,
    -> Sdept char(20)
    -> );

查看表

mysql> show tables；
+------------------+
| Tables_in_testdb |
+------------------+
| Student          |
+------------------+

显示表的构造信息

mysql> show create table Student;
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table   | Create Table                                                                                                                                                                                                                                                                        |
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Student | CREATE TABLE `Student` (
  `Sno` char(9) NOT NULL,
  `Sname` char(20) DEFAULT NULL,
  `Ssex` char(2) DEFAULT NULL,
  `Sage` smallint(6) DEFAULT NULL,
  `Sdept` char(20) DEFAULT NULL,
  PRIMARY KEY (`Sno`),
  UNIQUE KEY `Sname` (`Sname`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)