mysql创建外键问题 alter table ads_category_info add constraint fkadd foreign key(name)references ads_url_field_info (title);这段代码哪里有错误?执行不了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 alter table ads_category_info add constraint foreign key(name) references ads_url_field_info (title); 类似语法问题,可以直接参考一下MYSQL官方免费手册中的语法说明。12.1.6. ALTER TABLE SyntaxALTER [ONLINE | OFFLINE] [IGNORE] TABLE tbl_name alter_specification [, alter_specification] ...alter_specification: table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name ] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX|KEY} [index_name] [index_type] (index_col_name,...) [index_option] ... | ADD [CONSTRAINT [symbol]] PRIMARY KEY [index_type] (index_col_name,...) [index_option] ... | ADD [CONSTRAINT [symbol]] UNIQUE [INDEX|KEY] [index_name] [index_type] (index_col_name,...) [index_option] ... | ADD FULLTEXT [INDEX|KEY] [index_name] (index_col_name,...) [index_option] ... | ADD SPATIAL [INDEX|KEY] [index_name] (index_col_name,...) [index_option] ... | ADD [CONSTRAINT [symbol]] FOREIGN KEY [index_name] (index_col_name,...) reference_definition alter table ads_category_info add constraint fk foreign key(name) references ads_url_field_info (title);你在foreign key(name)之前多写了一个add alter table ads_category_info add constraint foreign key(name) references ads_url_field_info (title) on update cascade; 查询语句 求高手赐教 存储过程报错,不知道错在哪里?求指教 mysql配置小问题 想知道大家在生产环境中innodb的数据文件,日志文件,表空间怎么管理的 关于MySQL在Linux中的问题 哪里可以下载开源的最新版MySql? 批处理文件问题 几条简单的SQL语句,会写的帮忙咯 linux下mysql安装菜鸟问题,急!马上给分 mysql 主从同步的几个疑问 数据库的几个基本术语 概念有点混乱,请高手指教 sql-front能建立外键吗?
ALTER [ONLINE | OFFLINE] [IGNORE] TABLE tbl_name
alter_specification [, alter_specification] ...alter_specification:
table_options
| ADD [COLUMN] col_name column_definition
[FIRST | AFTER col_name ]
| ADD [COLUMN] (col_name column_definition,...)
| ADD {INDEX|KEY} [index_name]
[index_type] (index_col_name,...) [index_option] ...
| ADD [CONSTRAINT [symbol]] PRIMARY KEY
[index_type] (index_col_name,...) [index_option] ...
| ADD [CONSTRAINT [symbol]]
UNIQUE [INDEX|KEY] [index_name]
[index_type] (index_col_name,...) [index_option] ...
| ADD FULLTEXT [INDEX|KEY] [index_name]
(index_col_name,...) [index_option] ...
| ADD SPATIAL [INDEX|KEY] [index_name]
(index_col_name,...) [index_option] ...
| ADD [CONSTRAINT [symbol]]
FOREIGN KEY [index_name] (index_col_name,...)
reference_definition