/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

3 votes202 views3 answers
How to set up an auto incrementing id db browser
SQL
1 vote199 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote207 views1 answer
Alter check command
SQL
1 vote236 views1 answer
Mysql return text after a final full stop
SQL
0 vote191 views1 answer
Oarcale list objects
SQL
0 vote201 views1 answer
Change magento database url usimg musql
SQL
1 vote181 views1 answer
Index a database column sql
SQL
0 vote198 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote266 views3 answers
How to find all role in mysql
SQL
0 vote189 views1 answer
Oracle archivelog usage
SQL