遇到的坑
在進行資料的插入的時候總是資料插不進資料庫,頁面送出表單的時候,頁面一直處于請求中,但就是不跳轉頁面,項目就開始彈出是否進行debug操作,檢測了許久,邏輯代碼和sql語句都沒有問題,實在是讓自己感到難受,在網上查詢了許多的資料,才發現自己的字段使用的是資料庫的保留關鍵字
在網上查閱資料整理的部分内容解釋
關于mysql5.7保留關鍵字和關鍵字,mysql是支援使用關鍵字做字段名的(但不推薦使用),但是針對保留關鍵字是必須要加引用
我自己使用到的是保留關鍵字 describe 和 require 在插入資料庫的時候字段需要加上 ' ' 或者修改字段名字,我自己是修改了字段的名字
下面是最新版的mysql的關鍵字和保留字的表,可以在設計時多查一查,(R)是保留關鍵字
有些人可能還不明白關鍵字和保留字的差別,簡單的說,關鍵字分兩種:非保留和保留,保留關鍵字又有一個特殊類别叫未來保留。
mysql5.7官方文檔位址:https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Table 9.2 Keywords and Reserved Words in MySQL 5.7
(R) | [a] | |
(R) | | |
| | (R) |
(R) | [b] | |
(R) | (R) | |
(R) | (R) | |
(R) | | |
| | |
| (R) | |
(R) | (R) | (R) |
| | (R) |
| | |
(R) | | (R) |
| | (R) |
(R) | | (R) |
| | (R) |
| [c] | (R) |
(R) | | (R) |
| | |
| | |
| (R) | |
(R) | | |
| | |
| | |
| [d] | |
(R) | | |
(R) | | |
| | |
(R) | (R) | |
(R) | (R) | |
| (R) | (R) |
(R) | (R) | (R) |
| | (R) |
(R) | | |
| | (R) |
(R) | (R) | (R) |
| (R) | (R) |
(R) | (R) | |
| (R) | |
(R) | (R) | (R) |
| (R) | |
| | |
| (R) | (R) |
(R) | | (R) |
(R) | (R) | |
| | (R) |
(R) | (R) | |
(R) | [e] | |
| | |
| | |
| (R) | |
| | |
| (R) | (R) |
| | (R) |
| | |
(R) | | |
(R) | | |
[f] | [g] | |
| (R) | (R) |
(R) | | [h] |
(R) | (R) | (R) |
| | (R) |
| (R) | |
| [i] (R) | |
| (R) | |
| (R) | |
(R) | [j] | |
| (R) | |
(R) | | |
| (R) | (R) |
(R) | | (R) |
(R) | | |
(R) | (R) | |
(R) | | (R) |
(R) | (R) | (R) |
| | [k] |
(R) | (R) | (R) |
(R) | (R) | (R) |
(R) | (R) | (R) |
| | (R) |
(R) | | |
(R) | | |
(R) | (R) | [l] |
(R) | (R) | |
(R) | | |
(R) | (R) | |
(R) | | |
(R) | (R) | (R) |
(R) | | |
(R) | | (R) |
(R) | (R) | |
| | (R) |
(R) | (R) | (R) |
(R) | | |
(R) | | |
| | |
| | |
| | |
| | |
| | |
| (R) | [m] |
| (R) | (R) |
| | |
| [n] | |
| | (R) |
(R) | (R) | |
| | |
(R) | | |
(R) | (R) | |
(R) | | (R) |
| | |
| | |
| | |
| (R) | |
| | [o] |
| | |
| [p] | |
(R) | | (R) |
(R) | | (R) |
| | [q] |
(R) | | |
| (R) | [r] (R) |
(R) | (R) | |
(R) | (R) | (R) |
(R) | (R) | |
| | |
[s] | | (R) |
| | |
| | |
| | |
| [t] | (R) |
| | |
(R) | | (R) |
| | |
| (R) | |
| | (R) |
(R) | (R) | |
(R) | (R) | |
| | |
| (R) | (R) |
| | |
| | (R) |
| | (R) |
| | (R) |
| (R) | [u] |
[v] | [w] | [x] |
[y] | [z] | [aa] |
| (R) | |
(R) | | (R) |
| (R) | |
| | (R) |
(R) | (R) | |
| [ab] | |
| | |
| | |
| (R) | (R) |
| | (R) |
| (R) | (R) |
(R) | | |
| | (R) |
| (R) | |
(R) | | |
| | (R) |
| | |
| | |
(R) | (R) | (R) |
(R) | (R) | (R) |
| | |
(R) | | |
(R) | | (R) |
| | |
| | |
| | |
(R) | | |
(R) | | |
| | |
| | [ac] (R) |
(R) | | |
| | |
| | |
| (R) | |
| | |
| | (R) |
| | (R) |
| | |
| (R) | (R) |
(R) | (R) | (R) |
| (R) | |
(R) | | |
| | |
(R) | | |
| | (R) |
(R) | | (R) |
(R) | | (R) |
| (R) | (R) |
| | |
(R) | (R) | (R) |
(R) | [ad] | |
(R) | (R) | (R) |
(R) | | (R) |
| [ae] (R) | |
| | |
(R) | (R) | (R) |
(R) | [af] | |
| (R) | |
| [ag] | |
(R) | | (R) |
(R) | ||
[a] : added in 5.7.6 (nonreserved) [b] : added in 5.7.6 (nonreserved) [c] : added in 5.7.6 (nonreserved) [d] : added in 5.7.8 (nonreserved) [e] : added in 5.7.11 (nonreserved) [f] : added in 5.7.6 (nonreserved) [g] : added in 5.7.3 (nonreserved) [h] : added in 5.7.2 (nonreserved) [i] : added in 5.7.6 (reserved) [j] : added in 5.7.6 (nonreserved) [k] : added in 5.7.11 (nonreserved) [l] : added in 5.7.8 (nonreserved) [m] : added in 5.7.10 (nonreserved) [n] : added in 5.7.4 (nonreserved); removed in 5.7.8 [o] : added in 5.7.4 (nonreserved) [p] : removed in 5.7.6 [q] : removed in 5.7.5 [r] : added in 5.7.5 (reserved) [s] : added in 5.7.6 (reserved); became nonreserved in 5.7.8 [t] : added in 5.7.2 (nonreserved) [u] : added in 5.7.3 (nonreserved) [v] : added in 5.7.3 (nonreserved) [w] : added in 5.7.3 (nonreserved) [x] : added in 5.7.3 (nonreserved) [y] : added in 5.7.3 (nonreserved) [z] : added in 5.7.3 (nonreserved) [aa] : added in 5.7.3 (nonreserved) [ab] : added in 5.7.11 (nonreserved) [ac] : added in 5.7.6 (reserved) [ad] : added in 5.7.5 (nonreserved) [ae] : added in 5.7.6 (reserved) [af] : added in 5.7.5 (nonreserved) [ag] : added in 5.7.5 (nonreserved) |
5.7相比于5.6新增的關鍵字
| | |
| | |
| | (R) |
| | |
| | (R) |
| | |
| | |
| | |
| | (R) |
| (R) | |
|
5.7相比于5.6删除的關鍵字
|