MySQL语句示例

-- 创建数据库
create database study;

-- 删除数据库
drop database study;

-- 创建数据库
create database time_management;
-- 选择数据库
use time_management;

-- 创建数据表
CREATE TABLE `time_management`.`time_management_config` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `uid` int NOT NULL DEFAULT '0' COMMENT '用户id',
  `operator` varchar(45) NOT NULL DEFAULT '' COMMENT '操作者',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '标题',
  `content` varchar(1024) NOT NULL DEFAULT '' COMMENT '内容',
  `type` int NOT NULL DEFAULT '0' COMMENT '类型',
  `state` int NOT NULL DEFAULT '0' COMMENT '状态',
  `btime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '开始时间',
  `etime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '结束时间',
  `ctime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `mtime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  `note` varchar(100) NOT NULL DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='时间管理信息配置表';

-- 删除数据表
drop table `time_management`.`time_management_config`;

-- 插入语句
insert into `time_management`.`time_management_config` 
(uid, operator, title, content, type, state)
values
(10000, "ltqthu", "休息闹钟", "起来走走，泡杯茶", 1, 1);

-- 查询语句
select * from `time_management`.`time_management_config`
where id=1;

-- 更新语句
update `time_management`.`time_management_config` 
set content=to_base64("起来走走，泡杯茶，要加油哦😊")
where id=1;

-- 查询语句
select convert(from_base64(content), char) from `time_management`.`time_management_config`
where id=1;