/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

22 votes310 views4 answers
Mysql date format
SQL
1 vote290 views2 answers
Get date from datetime postgresql
SQL
0 vote315 views2 answers
Auto increment column in mysql query results
SQL
0 vote323 views1 answer
Oracle archivelog usage
SQL
0 vote327 views1 answer
Check connections to database postgres
SQL
5 votes319 views1 answer
Commentaire table oracle
SQL
0 vote285 views1 answer
Duplicate foreign key constraint name
SQL
0 vote315 views2 answers
Sql searching via key word
SQL
11 votes338 views5 answers
Update table from another table mysql
SQL
0 vote294 views1 answer
Automate mysql cli query
SQL

Share