Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL can not write the data keyword conflicts     - FreeRadius installation process record (Linux)

- Android realize RippleEffect water (Programming)

- Commonly used Linux system camouflage method (Linux)

- High-performance JavaScript loops and flow control (Programming)

- MySQL concat function is SQL injection (Linux)

- Understanding the Linux load average on other UNIX-Like systems (Linux)

- Installation Enpass secure password manager on Ubuntu (Linux)

- How to use the on-screen keyboard in Linux (Linux)

- Simple Linux file system - df, du, ln (Linux)

- Ubuntu 14.04 Configuring cuda-convnet (Linux)

- Nginx Installation and Configuration (Server)

- Local port forwarding using iptables under linux (Server)

- The Rabbitmq installation under CentOS 6.4 (Linux)

- Linux kernel panic (because glibc result) Repair (Linux)

- To get Java class / jar package path (Programming)

- Programmer editor Vim (Linux)

- Linux maximum number of threads and limit the number of queries the current thread (Linux)

- Linux device driver development small example --LED lights (Programming)

- Lua study notes under ubuntu (Linux)

- MySQL dual master configuration (Database)

 
         
  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:      
 
- Depth Java Singleton (Programming)
- The Java way to stop a thread of execution (Programming)
- Linux disk partition batch format mount script (Linux)
- PHP 7.0 Upgrade Notes (Linux)
- Linux kernel TCP / IP parameters analysis and tuning (Linux)
- Linux awk text analysis tool (Linux)
- Oracle user lock how to know what causes (Database)
- Security Knowledge: How to hide a backdoor PHP file tips (Linux)
- Effective Java - lazy initialization (Programming)
- Simple configuration shell scripts virtual machine environment experiment (Linux)
- Introduction and MongoDB CRUD (Database)
- How to use Monit to deploy a server to monitor the system (Server)
- Linux cron job (Linux)
- Ubuntu deployed under regular tasks with crontab (Linux)
- Ubuntu iptables prevent IP attacks (Linux)
- Using Python to find a particular file extension directory (Programming)
- Use NTFS-3G to mount NTFS partitions under Linux U disk and removable hard disk (Linux)
- Linux, Chrome browser font settings beautification (Linux)
- Depth understanding of DB2 table space (Tablespace) (Database)
- Linux and Windows virtual machine shared folders ---- Linux install VMware tools (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.