/SQL/Add new column in sql with foreign key

Add new column in sql with foreign key

ALTER TABLE `fb_banners`
ADD `city_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL AFTER `BannerID`,
ADD INDEX `Foreign_city_id_banners` (`city_id`) USING BTREE,
ADD CONSTRAINT `Foreign_city_id_banners` FOREIGN KEY (`city_id`) REFERENCES `foodsafari`.`fb_cities` (`id`) ON UPDATE CASCADE ON DELETE CASCADE;

Similar codes

0 vote118 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote121 views1 answer
Oracle query archivemode
SQL
10 votes114 views3 answers
Sql limit results
SQL
0 vote125 views1 answer
Get null value in sql
SQL
0 vote119 views1 answer
Like sql for second letter of the family name
SQL
1 vote145 views2 answers
One to one and one to many relationship
SQL
1 vote138 views1 answer
Show structure of table in sql
SQL
0 vote148 views2 answers
Sql if empty then
SQL
0 vote125 views1 answer
Can't connect to postgresql mac os
SQL
3 votes85 views4 answers
Mysql delete duplicate rows
SQL