Search
Search

Adding column with foreign key and reference

debugcn Published at Dev
19
Jahangir Shah Rashdi

I am trying following query:

ALTER TABLE `booking` 
ADD  `feedback_id` INT(11) UNSIGNED,
INDEX `b_feedback_fk_idx` (`feedback_id` ASC),
CONSTRAINT `feedback_fk`
    FOREIGN KEY (`feedback_id`)
    REFERENCES feedback(`id`)

but it is giving following error:

Query: ALTER TABLE `booking` ADD `feedback_id` INT(11) UNSIGNED, INDEX `b_feedback_fk_idx` (`feedback_id` ASC), CONSTRAINT `feedback_fk...

Error Code: 1064
Erreur de syntaxe près de '`b_feedback_fk_idx` (`feedback_id` ASC),
CONSTRAINT `feedback_fk`
    FOREIGN ' à la ligne 4
Zamrony P. Juhara

Assuming that you want to add new index and foreign key constraint, you need to use ADD before INDEX and CONSTRAINT.

ALTER TABLE `booking` 
ADD  `feedback_id` INT(11) UNSIGNED,
ADD INDEX `b_feedback_fk_idx` (`feedback_id` ASC),
ADD CONSTRAINT `feedback_fk` 
    FOREIGN KEY (`feedback_id`)
    REFERENCES feedback(`id`)

See MySQL ALTER TABLE syntax documentation.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Adding new column to table as foreign key

From Dev

Sql column without foreign key reference

From Dev

Django shows object reference in foreign key column

From Dev

Specify a foreign key on a non-unique reference column by additional reference

From Java

Adding a column as a foreign key gives ERROR column referenced in foreign key constraint does not exist

From Dev

Column does not exist error when adding Foreign Key Django

From Dev

Django migrate after adding foreign key gives "unknown column" error

From Dev

With a foreign composite key, it possible to reference a column and a fixed value?

From Dev

Multi column foreign key, with hard coded reference value

From Dev

Is it not possible to have a check constraint reference a column that also has a foreign key?

From Dev

set the column code as foreign key on table with a reference to another table

From Dev

Best practices for normalizing a table and converting a nvarchar column to a foreign key reference

From Dev

Django :: Reference foreign key

From Dev

Can a foreign key reference another foreign key

From Dev

Change column to foreign key

From Dev

Error adding foreign_key

From Dev

Adding foreign key Error 150

From Dev

Adding a Foreign Key to an existing Table

From Dev

Error adding Foreign Key Constraint

From Dev

Adding EF object as a foreign key

From Dev

Error adding Foreign Key Constraint

From Dev

adding a foreign key failed on phpMyAdmin

From Dev

Adding foreign key data to serializer?

From Dev

Reference with custom name and foreign key

From Dev

Foreign Key Reference for Django in Admin

From Dev

Reference a foreign key to a different type

From Dev

SQL Server foreign key reference

From Dev

Foreign key reference for two columns

From Dev

get reference table by foreign key

Related Related

  1. 1

    Adding new column to table as foreign key

  2. 2

    Sql column without foreign key reference

  3. 3

    Django shows object reference in foreign key column

  4. 4

    Specify a foreign key on a non-unique reference column by additional reference

  5. 5

    Adding a column as a foreign key gives ERROR column referenced in foreign key constraint does not exist

  6. 6

    Column does not exist error when adding Foreign Key Django

  7. 7

    Django migrate after adding foreign key gives "unknown column" error

  8. 8

    With a foreign composite key, it possible to reference a column and a fixed value?

  9. 9

    Multi column foreign key, with hard coded reference value

  10. 10

    Is it not possible to have a check constraint reference a column that also has a foreign key?

  11. 11

    set the column code as foreign key on table with a reference to another table

  12. 12

    Best practices for normalizing a table and converting a nvarchar column to a foreign key reference

  13. 13

    Django :: Reference foreign key

  14. 14

    Can a foreign key reference another foreign key

  15. 15

    Change column to foreign key

  16. 16

    Error adding foreign_key

  17. 17

    Adding foreign key Error 150

  18. 18

    Adding a Foreign Key to an existing Table

  19. 19

    Error adding Foreign Key Constraint

  20. 20

    Adding EF object as a foreign key

  21. 21

    Error adding Foreign Key Constraint

  22. 22

    adding a foreign key failed on phpMyAdmin

  23. 23

    Adding foreign key data to serializer?

  24. 24

    Reference with custom name and foreign key

  25. 25

    Foreign Key Reference for Django in Admin

  26. 26

    Reference a foreign key to a different type

  27. 27

    SQL Server foreign key reference

  28. 28

    Foreign key reference for two columns

  29. 29

    get reference table by foreign key

HotTag

Archive