如何命名sql foreign key constraint on create two tables columns into a relationship table

t40tm48m 于 2021-06-17 发布在 Mysql

关注(0)|答案(1)|浏览(421)

我只是想知道是否有一种方法可以命名create表上的外键

FOREIGN KEY (uuid) REFERENCES employee(uuid));

我试图这样做，并命名我的外键为fk1，但我有语法错误

FOREIGN KEY fk1 (uuid) REFERENCES employee(uuid));

错误

org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is com.jda.cloudsql.common.MigrationException: org.flywaydb.core.internal.dbsupport.FlywaySqlScriptException:

  FOREIGN KEY FK1[*] (UUID) REFERENCES EMPLOYEE(UUID)) "; expected "("; SQL statement:

sql mysql foreign-keys tablecolumn

来源：https://stackoverflow.com/questions/53717665/how-to-name-sql-foreign-key-constraint-on-create-two-tables-columns-into-a-relat

1条答案

按热度按时间

egmofgnx1#

你可以写：

ADD CONSTRAINT `customized_foreign_key_name` FOREIGN KEY (`uuid`) REFERENCES `employee` (`uuid`)

赞(0）回复(0）举报 2021-06-18

我来回答

如何命名sql foreign key constraint on create two tables columns into a relationship table

1条答案

相关问题

热门标签

最新问答