MySQL日常操作

1、指定UTF8编码

CREATE DATABASE `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

2、指定GBK编码

CREATE DATABASE `mydb` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;

3、建表

CREATE TABLE `table_name` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `col1` varchar(90) NOT NULL,
  `col2` varchar(90) NOT NULL,
  `col3` varchar(90) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

带自增字段

4、插入数据

INSERT INTO tbl_name (col1,col2) VALUES('xx','xx');

5、授权

#赋权
grant all privileges on db_name.db_table to 'user'@'ip range'  identified by 'passwd'；
#刷新权限
flush privileges ;