/SQL/Mysql alter add foreign key

Mysql alter add foreign key

Alter table add foreign key mysql

ALTER TABLE orders
ADD 
FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;

9

Mysql alter add foreign key

ALTER TABLE ordenes ADD ticket VARCHAR(50) NOT NULL;
ALTER TABLE ordenes ADD CONSTRAINT fk_ticket FOREIGN KEY (ticket) REFERENCES tickets(ticket);

1

Source: es.stackoverflow.com

Similar codes

0 vote121 views2 answers
Sql last updated
SQL
1 vote94 views2 answers
Procedure pl/sql
SQL
1 vote130 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote139 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote134 views1 answer
Drop CHECK constraint sql
SQL
0 vote137 views2 answers
How to drop mili second in sql
SQL
0 vote154 views1 answer
Mysql date without time
SQL
0 vote236 views1 answer
Sqlite woth cmake
SQL
0 vote140 views2 answers
Mysql missin expression near on
SQL
0 vote99 views1 answer
Sql table to store status
SQL

Share