type
status
date
slug
summary
tags
category
icon
password
- mariadb创建schema
create schema aaaautf collate utf8mb4_unicode_ci;- 创建表
- 插入数据
INSERT INTO novel.book (bid, name, author, type, icon, `desc`, updateTime, lastChapter) VALUES ('2', '2', 'aaa', 'aaa', 'aaa', 'aaa', 'aaaa', '{"cid":"1213", "name":"ds1fs"}');- 删除数据
DELETE FROM novel.book WHERE bid = '1';- 查询数据
select * from novel.book where JSON_VALUE(lastChapter, '$.name') = 'ds1fs';- 修改数据
UPDATE novel.book t SET t.type = 'aaa1' WHERE t.bid='2';- json操作
- 创建索引
- 创建主键
- 作者:leiax00
- 链接:https://blog.leiax00.cn/article/mariadb
- 声明:本文采用 CC BY-NC-SA 4.0 许可协议，转载请注明出处。
