/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 vote200 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote218 views1 answer
Plsql check how much space all databases are consuming
SQL
16 votes233 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
1 vote193 views1 answer
How to get alternate records from a table in sql
SQL
2 votes185 views1 answer
Sql select min value from multiple columns
SQL
0 vote217 views4 answers
First max salary in sql
SQL
0 vote204 views1 answer
Xampp increame mysql speed
SQL
20 votes232 views4 answers
Sql count if
SQL
0 vote204 views1 answer
SQL authentication error
SQL
0 vote209 views1 answer
Sql server create constraint
SQL

Share