MySQL常用操作

1，建表

CREATE TABLE person (
number INT(11),
name VARCHAR(255),
birthday DATE
);

2，插入数据

insert into person_test values (123,’fupeng’,’2015-01-01’);

3， 删除用户

1， 用root账户登录mysql -u root -p2，mysql>Delete FROM user Where User='test' and Host='localhost';3，mysql>flush privileges;

4 在客户端上，修改字符集

set names utf8

5 连接时，选定字符集

增加 这个命令行选项 –default-character-set=utf8

6 命令行 使用事务

使用start transaction;或begin;显示的开启一个事务mysql> start transaction;Query OK, 0 rows affected (0.00 sec)mysql> begin;Query OK, 0 rows affected (0.00 sec)mysql> insert into t1 values (51, 3000);Query OK, 1 row affected (0.00 sec)mysql> select * from t1;+----+------+| a  | b    |+----+------+| 51 | 3000 |+----+------+1 row in set (0.00 sec)mysql> rollback;Query OK, 0 rows affected (0.04 sec)mysql> select * from t1;Empty set (0.00 sec)mysql> commit;Query OK, 0 rows affected (0.00 sec)mysql> select * from t1;Empty set (0.00 sec)