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

2 votes365 views2 answers
How to create an empty table from an existing table
SQL
22 votes336 views3 answers
Sql cheat sheet
SQL
0 vote347 views1 answer
No suitable driver found for sqlite
SQL
1 vote348 views1 answer
Describe table in sql
SQL
1 vote338 views3 answers
Psql fatal database does not exist
SQL
25 votes401 views1 answer
How to update an attribute in MySQL
SQL
3 votes372 views1 answer
Oracle list privileges
SQL
12 votes392 views6 answers
Distinct in sql server
SQL
1 vote406 views1 answer
Oracle drop temporary table
SQL
0 vote351 views1 answer
Oracle current session details
SQL