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 vote281 views2 answers
Homebrew nysql launch
SQL
5 votes261 views1 answer
How to use rank function in sql
SQL
2 votes290 views3 answers
How to check current user in mySQL
SQL
0 vote283 views1 answer
T sql dynamic top n query
SQL
3 votes265 views2 answers
How to load files in mysql
SQL
19 votes277 views6 answers
Sql drop table if exists
SQL
0 vote292 views1 answer
Oracle insert single quote in string
SQL
2 votes261 views1 answer
Sql create database
SQL
4 votes239 views1 answer
Mac install mysql
SQL
1 vote260 views1 answer
Lpad function in sql oracle
SQL