/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

1 vote126 views1 answer
Postgres killing connections on db
SQL
0 vote146 views1 answer
Nodejs sql get one to many relationship as array
SQL
0 vote134 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote139 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote156 views1 answer
Hour differeence in mysql
SQL
0 vote134 views1 answer
Add alternate add column sql
SQL
0 vote122 views1 answer
Get sum sqlite android
SQL
2 votes135 views2 answers
How to add not null constraint in sql
SQL
0 vote144 views1 answer
Sql server roles and users
SQL
4 votes138 views1 answer
Wilayah indonesia sql
SQL