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 vote164 views1 answer
How to get nth number in sql
SQL
0 vote166 views1 answer
No query unable to fetch row sqlite
SQL
4 votes159 views3 answers
Mysql modify foreign key
SQL
8 votes160 views3 answers
SQL column name
SQL
7 votes163 views3 answers
Foreign key oracle
SQL
0 vote154 views1 answer
Sql find gaps in date ranges
SQL
0 vote174 views1 answer
Codigo crear tablas sql server
SQL
2 votes147 views1 answer
How to delete view in sql
SQL
12 votes140 views3 answers
Install sqlite driver ubuntu
SQL
6 votes159 views1 answer
How to count number of rows in sql
SQL