go监听mysql事件更新_Go语言之进阶篇mysql增 删 改 查

一、mysql操作基本语法

1、创建名称nulige的数据库

CREATE DATABASE nulige DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

use nulige

2、建表，Id自增

create table user_info(

nid int not null auto_increment primary key,

username varchar(20),

departname varchar(20),

create_time timestamp default "0000-00-00 00:00:00"

);

3、往表中插入数据

INSERT INTO user_info (username,departname,create_time) VALUES ("nulige","行政部","2019-1-13 12:23:00");

INSERT INTO user_info (username,departname,create_time) VALUES ("jojo","财务部","2019-1-14 1:23:00");

INSERT INTO user_info (username,departname,create_time) VALUES ("huhui","销售部","2019-1-15 2:23:00");

4、查询表中内容

mysql> select * from user_info;

+-----+----------+------------+---------------------+

| nid | username | departname | create_time |

+-----+----------+------------+---------------------+

| 1 | nulige | 行政部 | 2019-01-13 12:23:00 |

| 2 | jojo | 财务部 | 2019-01-14 01:23:00 |

| 3 | huhui | 销售部 | 2019-01-15 02:23:00 |

+-----+----------+------------+---------------------+

3 rows in set (0.00 sec)

5、删除数据库

mysql> drop data