/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

4 votes141 views4 answers
Oracle tablespace tables list
SQL
0 vote129 views1 answer
Python mysql query where
SQL
0 vote164 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote147 views1 answer
Custom row number
SQL
0 vote146 views1 answer
Sqlalchemy get ids
SQL
0 vote150 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote149 views1 answer
Psql generate id in existing database
SQL
0 vote150 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
2 votes171 views3 answers
How to replace null values in sql
SQL
10 votes93 views1 answer
Oracle view dependencies
SQL