1 mysql初步体验

1. 登陆 mysql

ywx@ywx:~/yu/mysql$ mysql -u root -p
Enter password:
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

2. 一个简单mysql 操作

2.1  show databases; //显示存在的数据库
   

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test2              |
+--------------------+
3 rows in set (0.00 sec)

mysql>

2.2 create database test3;建立一个数据库

mysql> create database test3;
Query OK, 1 row affected (0.00 sec)

2.3 use test3; 进入数据库

mysql> use test3;
Database changed

2.4  create table t 新建表

mysql> create table t(id int, name varchar(20));
Query OK, 0 rows affected (0.01 sec)

2.5 desc t；显示表

mysql> desc t;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(11)     | YES  |     | NULL    |       |
| name  | varchar(20) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

2.6 insert to t values(1,'bbk'); 插入表

mysql> insert into t values(1,'bbk');
Query OK, 1 row affected (0.00 sec)

2.7 select * from t;查询表

mysql> select * from t;
+------+------+
| id   | name |
+------+------+
|    1 | bbk  |
+------+------+
1 row in set (0.00 sec)

2.8 delete from t; 删除表

mysql> delete from t;
Query OK, 1 row affected (0.00 sec)

2.9 显示表， 现在什么都没有了

mysql> select * from t;
Empty set (0.00 sec)

3.0 退出 mysql

mysql> exit
Bye
ywx@ywx:~/yu/mysql$

到这里，体验sql 结束了