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 vote207 views1 answer
Add a new column into table
SQL
0 vote207 views1 answer
Postgresql isnull with max
SQL
0 vote209 views2 answers
Postgresql get long running queries
SQL
44 votes274 views6 answers
Rename command in sql
SQL
0 vote196 views1 answer
Run sql script file and changes db name in this file using c#
SQL
8 votes260 views1 answer
Database backup in mysql server recovery
SQL
2 votes312 views2 answers
How to DROP a table in mysql
SQL
0 vote207 views1 answer
Rabbitmq ui not working
SQL
0 vote200 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
1 vote214 views1 answer
Apex select list ORA-20999
SQL