创建数据库
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)