/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

10 votes355 views2 answers
Sql merge statement
SQL
0 vote379 views1 answer
Mysql 1 hour ago
SQL
1 vote356 views1 answer
Sql try catch
SQL
2 votes382 views2 answers
Sqlalchemy filter or
SQL
5 votes370 views1 answer
Oracle sysdate - 1 month
SQL
2 votes388 views1 answer
Rails execute sql
SQL
0 vote384 views1 answer
Second Step in installing SQL workbench
SQL
1 vote371 views1 answer
Size of all tables in a schema oracle
SQL
1 vote364 views1 answer
Mysql how to truncate table with foreign keys
SQL
2 votes347 views1 answer
Sqlite indexes
SQL

Share