mysql笔记

1.进入数据库

mysql -u root -p guesser

guesser为数据库名,然后输入密码,我是以root登录的.

---

2.查看当前的所有数据库

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| guesser            |
| mysql              |
| mysqlo             |
| performance_schema |
+--------------------+
5 rows in set (0.03 sec)

3.连接数据库

mysql> use guesser;
No connection. Trying to reconnect...
Connection id:    8
Current database: *** NONE ***

Database changed

4.显示所有的表

mysql> show tables;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    9
Current database: guesser

+-------------------+
| Tables_in_guesser |
+-------------------+
| albums            |
| followers         |
| opens             |
| profiles          |
| reports           |
| settings          |
| statues           |
| users             |
+-------------------+
10 rows in set (0.00 sec)

5.创建表

create database guesser;

6.插入数据

mysql> insert into settings (name,val,val2,val3) values("ggg",'hi,PHP程序',"HHHHH","GGGGGG");                                                    ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    12
Current database: guesser

Query OK, 1 row affected (0.04 sec)

6.退出

mysql> exit