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:    8Current database: *** NONE ***Database changed

4.显示所有的表

mysql> show tables;ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect...Connection id:    9Current 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 awayNo connection. Trying to reconnect...Connection id:    12Current database: guesserQuery OK, 1 row affected (0.04 sec)

6.退出

mysql> exit