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

0 vote226 views1 answer
Postgresql print sessions using the database
SQL
0 vote197 views1 answer
How to select only id where is not in column mysql
SQL
0 vote199 views1 answer
Sql insert from excel
SQL
0 vote282 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
9 votes204 views5 answers
Sql limit
SQL
0 vote191 views1 answer
Mod function example
SQL
3 votes238 views2 answers
Check data in table mysql
SQL
1 vote194 views1 answer
Display total number of tables in mysql
SQL
0 vote268 views1 answer
Oracle calculate statistics on partition
SQL
0 vote209 views1 answer
Sql last 3 rows
SQL