![](https://img-blog.csdnimg.cn/20190918140158853.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
2.数据库
数据库
徒伤
真正的勇气在极端的胆怯和鲁莽之间
展开
-
唯一索引的删除和新增
--表user_info--索引名UNIQ_ID_LOG--查询索引SHOW INDEX FROMuser_info;--删除索引ALTER TABLE user_info DROP INDEX UNIQ_ID_LOG;DROP INDEX UNIQ_ID_LOG ON user_info ;--添加索引ALTER TABLE user_info ADD UNIQUE UNIQ_ID_LOG(`id`,`name`,`age`);...原创 2021-01-22 18:15:48 · 253 阅读 · 0 评论 -
JAVA代码连接Redis时连不上
https://www.jianshu.com/p/2fa4622fc1d3转载 2020-05-04 11:02:33 · 758 阅读 · 0 评论 -
JDBC连接各种数据库
https://blog.csdn.net/Mrs_Yu/article/details/81461005原创 2020-04-24 22:52:53 · 374 阅读 · 0 评论 -
postgreSQL在windows系统下安装
1. postgreSQL下载地址:https://www.enterprisedb.com/downloads/postgres-postgresql-downloads2. 下载界面3.c盘新建文件夹postgresql并安装(注:安装报错。这个错误是因为用户权限不够,不是超级管理员)4. 解决上述权限问题4.1 找到文...原创 2020-03-22 21:08:34 · 1031 阅读 · 0 评论 -
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘INSERT INTO room VALUES(DEFAULT,‘豪华间’,‘300’,‘好’,‘2’)INSERT INTO ...原创 2019-11-04 19:13:24 · 137 阅读 · 0 评论 -
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘,‘上海’,‘12233311’)’ at line 1INSERT INTO hotel VALUES(DEFAULT,'汉庭...原创 2019-11-04 19:07:40 · 200 阅读 · 0 评论