如何避免用作列名称的保留字? MySQL /创建表 [英] How do I escape reserved words used as column names? MySQL/Create Table
本文介绍了如何避免用作列名称的保留字? MySQL /创建表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
key
这是一个保留的MySQL关键字。如何在create table语句中避免它? (注意:下面的另一个问题是文本必须是一个固定的索引/唯一的大小) 创建表如果不存在misc_info (
id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
key TEXT UNIQUE NOT NULL,
value TEXT NOT NULL)ENGINE = INNODB;
解决方案
CREATE TABLE IF NOT EXISTS misc_info
(
id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
keyTEXT UNIQUE NOT NULL,
值TEXT NOT NULL
)
ENGINE = INNODB;
或其他专有的back tick转义。 (在哪里可以找到各种键盘布局的`
字符在此答案)
CREATE TABLE IF NOT EXISTS misc_info
(
id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL ,
`key` TEXT UNIQUE NOT NULL,
value TEXT NOT NULL
)
ENGINE = INNODB;
(来源: MySQL参考手册,9.3保留字)
I am generating tables from classes in .NET and one problem is a class may have a field name key
which is a reserved MySQL keyword. How do I escape it in a create table statement? (Note: The other problem below is text must be a fixed size to be indexed/unique)
create table if not exists misc_info (
id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
key TEXT UNIQUE NOT NULL,
value TEXT NOT NULL)ENGINE=INNODB;
解决方案
You can use double quotes if ANSI SQL mode is enabled
CREATE TABLE IF NOT EXISTS misc_info
(
id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
"key" TEXT UNIQUE NOT NULL,
value TEXT NOT NULL
)
ENGINE=INNODB;
or the proprietary back tick escaping otherwise. (Where to find the `
character on various keyboard layouts is covered in this answer)
CREATE TABLE IF NOT EXISTS misc_info
(
id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
`key` TEXT UNIQUE NOT NULL,
value TEXT NOT NULL
)
ENGINE=INNODB;
(Source: MySQL Reference Manual, 9.3 Reserved Words)
这篇关于如何避免用作列名称的保留字? MySQL /创建表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文