Add colum in sql

Add column in sql

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;

Add colum in sql

ALTER TABLE Customers
ADD Email varchar(255);

Similar codes

2 votes117 views1 answer
Mysql sysdate
SQL
1 vote123 views1 answer
Postgres power
SQL
0 vote125 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote119 views1 answer
Sql change column in existing table
SQL
6 votes121 views2 answers
Mysql 1 day ago
SQL
0 vote120 views1 answer
Oracle select invalid views
SQL
0 vote121 views1 answer
Postgresql check total storage
SQL
2 votes108 views1 answer
Sql find missing values between two tables
SQL
0 vote129 views1 answer
What is top n result in sql
SQL
0 vote108 views1 answer
Set engine to innodb
SQL