Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL can not write the data keyword conflicts     - Simple RPM package production (Linux)

- PF_RING 6.0.2 compiled and installed on Redhat 6.3 x86_64 (Linux)

- Simple security measures to reinforce the Linux kernel (Linux)

- Achieve camera preview by ffplay (Linux)

- Ubuntu installation 2.10.x version of Scala (Linux)

- 10 really interesting Linux command (Linux)

- Use Makeself Create installation file (Linux)

- CentOS install expect (Linux)

- How to use the command line to obtain Freely RSS source on Linux (Linux)

- Unix system security configuration (Linux)

- FastDFS installation and deployment (Server)

- CentOS 6.6 x64 Oracle Database 11gR2 RAC automated installation scripts (Database)

- PPA on Ubuntu Linux installation Plank 0.8.0 (Linux)

- Effective Java - lazy initialization (Programming)

- shell script: a key to install LAMP, LNMP script (Server)

- Shell Scripting early experience (Programming)

- Management DB2 logs (Database)

- Java implementation chain store binary tree (Programming)

- Oracle to create an external table (Database)

- secureCRT remote login Linux must first open the connection protocol (Linux)

 
         
  MySQL can not write the data keyword conflicts
     
  Add Date : 2018-11-21      
         
         
         
  Problem Description: Today, the use of a new MySQL table. When inserting data, reported syntax error. The use of the mabits automatic code generation tools, and that he did not rewrite one of the sql statement. So sure, sql statement should not be part of possible wrong. Therefore, immediately realized that the field inside the table may be a problem. Then see the table inside the field, we found a field and desc keywords in descending order of the MySQL conflict. Then shoving this field has become a rewrite describe. Here, I thought that the problem should be solved. Hiatus, and conflict. MySQL also describe keywords. So the Internet search MySQL keyword table.

The following is a MySQL keyword table

MySQL 5.5 reserved keyword

ACCESSIBLE ADD ALL
ALTER ANALYZE AND
AS ASC ASENSITIVE
BEFORE BETWEEN BIGINT
BINARY BLOB BOTH
BY CALL CASCADE
CASE CHANGE CHAR
CHARACTER CHECK COLLATE
COLUMN CONDITION CONSTRAINT
CONTINUE CONVERT CREATE
CROSS CURRENT_DATE CURRENT_TIME
CURRENT_TIMESTAMP CURRENT_USER CURSOR
DATABASE DATABASES DAY_HOUR
DAY_MICROSECOND DAY_MINUTE DAY_SECOND
DEC DECIMAL DECLARE
DEFAULT DELAYED DELETE
DESC DESCRIBE DETERMINISTIC
DISTINCT DISTINCTROW DIV
DOUBLE DROP DUAL
EACH ELSE ELSEIF
ENCLOSED ESCAPED EXISTS
EXIT EXPLAIN FALSE
FETCH FLOAT FLOAT4
FLOAT8 FOR FORCE
FOREIGN FROM FULLTEXT
GRANT GROUP HAVING
HIGH_PRIORITY HOUR_MICROSECOND HOUR_MINUTE
HOUR_SECOND IF IGNORE
IN INDEX INFILE
INNER INOUT INSENSITIVE
INSERT INT INT1
INT2 INT3 INT4
INT8 INTEGER INTERVAL
INTO IS ITERATE
JOIN KEY KEYS
KILL LEADING LEAVE
LEFT LIKE LIMIT
LINEAR LINES LOAD
LOCALTIME LOCALTIMESTAMP LOCK
LONG LONGBLOB LONGTEXT
LOOP LOW_PRIORITY MASTER_SSL_VERIFY_SERVER_CERT
MATCH MAXVALUE MEDIUMBLOB
MEDIUMINT MEDIUMTEXT MIDDLEINT
MINUTE_MICROSECOND MINUTE_SECOND MOD
MODIFIES NATURAL NOT
NO_WRITE_TO_BINLOG NULL NUMERIC
ON OPTIMIZE OPTION
OPTIONALLY OR ORDER
OUT OUTER OUTFILE
PRECISION PRIMARY PROCEDURE
PURGE RANGE READ
READS READ_WRITE REAL
REFERENCES REGEXP RELEASE
RENAME REPEAT REPLACE
REQUIRE RESIGNAL RESTRICT
RETURN REVOKE RIGHT
RLIKE SCHEMA SCHEMAS
SECOND_MICROSECOND SELECT SENSITIVE
SEPARATOR SET SHOW
SIGNAL SMALLINT SPATIAL
SPECIFIC SQL SQLEXCEPTION
SQLSTATE SQLWARNING SQL_BIG_RESULT
SQL_CALC_FOUND_ROWS SQL_SMALL_RESULT SSL
STARTING STRAIGHT_JOIN TABLE
TERMINATED THEN TINYBLOB
TINYINT TINYTEXT TO
TRAILING TRIGGER TRUE
UNDO UNION UNIQUE
UNLOCK UNSIGNED UPDATE
USAGE USE USING
UTC_DATE UTC_TIME UTC_TIMESTAMP
VALUES VARBINARY VARCHAR
VARCHARACTER VARYING WHEN
WHERE WHILE WITH
WRITE XOR YEAR_MONTH
ZEROFILL
MySQL 5.5 new reserved keywords

GENERAL IGNORE_SERVER_IDS MASTER_HEARTBEAT_PERIOD
MAXVALUE RESIGNAL SIGNAL
SLOW
MySQL allows some keywords that we used to use English `No. quotes, such as:

ACTION
BIT
DATE
ENUM
NO
TEXT
TIME
TIMESTAMP
In the above table keywords in the database design, you should try to avoid unnecessary conflicts.

Problem Solving: the keywords replaced with non-keyword.

Experience: When program operation of the database by, mysql parses your code sql statement, if the operation of the field containing the keywords you write sql statement could be misinterpreted, sql statement is also wrong. Database types, or more. More or less a little keyword, each version is also slightly different. In the design of the database table, field names should be designed little special, try a little longer, and avoid keyword conflicts.
     
         
         
         
  More:      
 
- Axel install plug under CentOS 5/6 acceleration yum downloads (Linux)
- Ubuntu install OpenMPI (Linux)
- Zabbix monitors Nginx status (Server)
- Ten SCP transfer command example (Linux)
- MySQL uses Federate engine mapping table to achieve operation of the local remote operation table (Database)
- Linux shell scripts bubble sort (Programming)
- LVM Disk Manager Application (Linux)
- Check the Linux server performance with ten or so commands in a minute (Server)
- Struts2 form of non-use component tags (Programming)
- Use Docker containers (Linux)
- Quagga use authentication on strengthening BGP session security (Linux)
- Linux Live CD lets your PC is no longer secure (Linux)
- ASP.NET 5 is connected with the Redis server on the Linux platform (Server)
- Struts2 Result Types (Programming)
- Linux Network Programming - raw socket can do (Programming)
- Linux systems for entry-learning - Install Go language in Linux (Linux)
- 11G ASM disk group does not automatically handle MOUNT (Database)
- Multi-core CPU, multi-threading and parallel computation (Linux)
- Oracle data files deleted recover after physical (Database)
- Android Studio Personalization (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.