/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 vote325 views2 answers
Sql update from two different database
SQL
0 vote389 views1 answer
Sql injection payload list github
SQL
0 vote446 views1 answer
Play framework connection via windows sql server
SQL
0 vote305 views1 answer
Kannst du deine finger trainieren
SQL
0 vote377 views1 answer
Mysql config address
SQL
3 votes343 views1 answer
Oracle user privileges
SQL
23 votes377 views6 answers
How to create table in sql
SQL
0 vote350 views1 answer
Export partttion and import in oracle
SQL
0 vote351 views1 answer
Postgresql default value boolean
SQL
1 vote293 views1 answer
Prevent duplicate rows in postgres
SQL

Share