/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

7 votes199 views1 answer
Query delete duplicates
SQL
0 vote183 views3 answers
Between keyword sql
SQL
5 votes187 views6 answers
In operator sql
SQL
0 vote178 views1 answer
Check duplicate values plsql
SQL
4 votes180 views1 answer
Find tables with column name in sql
SQL
0 vote185 views2 answers
Oracle sql for each row
SQL
12 votes225 views6 answers
How to install sqlite3 in python
SQL
19 votes185 views6 answers
What is mySQL
SQL
1 vote178 views1 answer
Cross schema query oracle 2 users
SQL
0 vote198 views2 answers
Sql stored procedure for access frontend
SQL