/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 vote261 views1 answer
How to find top 3 salary in sql
SQL
3 votes218 views2 answers
Mysql select database
SQL
3 votes166 views2 answers
Coalesce mysql
SQL
0 vote198 views1 answer
Sql select min
SQL
0 vote209 views1 answer
Sql script to remove default from column
SQL
0 vote203 views1 answer
Value of sold product using having and group by in sql
SQL
1 vote258 views1 answer
Sql query row number group by
SQL
0 vote199 views1 answer
Mysql 8 geo to json
SQL
0 vote224 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
0 vote195 views1 answer
Sql server select record with max id
SQL

Share