$ yarn
$ yarn startThis is a starter template for Learn Next.js.
// 添加了一张图片到 public/me.png 路径，则以下代码就能访问到此图片：
import Image from 'next/image'
function Avatar() {
return <Image src="/me.png" alt="me" width="64" height="64" />
}
export default Avatar查看分词长度：
- SHOW VARIABLES LIKE 'ft_min_word_len';
- SHOW VARIABLES LIKE 'ngram_token_size';查看 mysql 配置在哪：
mysql --help | grep 'Default options' -A 1如果没有配置文件则新建：/etc/my.cnf，从 mysql 的安装路径下复制并改名一份 .cnf 后缀的文件：
# 添加并重启服务
ft_min_word_len = 2
ngram_token_size = 2全文检索 sql：
# 检索：包含 “内容”，或 “测试”
select title,content, MATCH (content) AGAINST ('测试 内容') as score from art_page where MATCH (content) AGAINST ('测试 内容' IN BOOLEAN MODE);
# 检索：包含 “内容”，及 “测试”
select title,content, MATCH (content) AGAINST ('+测试 +内容') as score from art_page where MATCH (content) AGAINST ('+测试 +内容' IN BOOLEAN MODE);
# 检索：包含 “内容”，但不包含 “测试”
select title,content, MATCH (content) AGAINST ('-测试 +内容') as score from art_page where MATCH (content) AGAINST ('-测试 +内容' IN BOOLEAN MODE);CREATE TABLE `art_page` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增 id',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT '标题',
`desc` varchar(512) NOT NULL DEFAULT '' COMMENT '描述',
`cover` varchar(255) NOT NULL DEFAULT '' COMMENT '图片地址',
`tags` varchar(255) NOT NULL DEFAULT '' COMMENT '标签',
`pid` bigint unsigned NOT NULL DEFAULT '0' COMMENT '父节点 id',
`content` mediumtext NOT NULL COMMENT '内容',
`ctime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`mtime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`state` tinyint NOT NULL DEFAULT '1' COMMENT '-1 删除，1 已发布，2 草稿',
`level` tinyint NOT NULL DEFAULT '0',
`extra` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '额外字段，不对前端暴露',
PRIMARY KEY (`id`),
KEY `idx_mtime` (`mtime`),
KEY `idx_title` (`title`),
KEY `idx_pid` (`pid`) USING BTREE,
KEY `idx_level` (`level`) USING BTREE,
KEY `idx_tags` (`tags`) USING BTREE,
FULLTEXT KEY `idx_content` (`content`) /*!50100 WITH PARSER `ngram` */ ,
FULLTEXT KEY `ix_title_content` (`content`,`title`) /*!50100 WITH PARSER `ngram` */
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3 COMMENT='小说脑图列表';- winston global.logger
- cookie/session
- ts 类型检查
- 配置
- 路由的合理利用