Mysql insert with foreign key

Add column mysql with foreign key

ALTER TABLE `TABLE_NAME`
ADD COLUMN `COLUMN_NAME` BIGINT(20) UNSIGNED NULL DEFAULT NULL AFTER `AFTER_COLUMN_NAME`, 
ADD FOREIGN KEY `FOREIGN_RELATION_NAME`(`COLUMN_NAME`) REFERENCES `FOREIGN_TABLE`(`FOREIGN_COLUMN`)  ON UPDATE SET NULL ON DELETE SET NULL

Source: grepper.com

Similar codes

0 vote181 views4 answers
How to connect form to database
SQL
0 vote146 views1 answer
Mysql offset from bottom
SQL
2 votes182 views3 answers
Postgresql reset auto increment
SQL
3 votes217 views2 answers
Search text in all sql server stored procedure
SQL
6 votes225 views1 answer
Identify primary key in oracle table
SQL
0 vote186 views1 answer
Linked server delete openquery
SQL
0 vote186 views1 answer
Mysql terminal run sql file
SQL
5 votes196 views1 answer
Mysql where one year ago
SQL
1 vote193 views1 answer
How to see all table partition in oracle
SQL
0 vote228 views1 answer
Original Query
SQL