/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

19 votes298 views6 answers
What is mySQL
SQL
1 vote283 views1 answer
Delete row mssql
SQL
0 vote319 views1 answer
Reindex mssql table
SQL
1 vote330 views1 answer
Floor function in sql oracle
SQL
6 votes285 views4 answers
Sqlite drop table
SQL
0 vote299 views2 answers
How covert into int in maria db
SQL
4 votes289 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
11 votes335 views1 answer
Oracle insert from select
SQL
2 votes308 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
4 votes309 views2 answers
Dbms output
SQL

Share