/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 vote281 views1 answer
Mariadb date equals to current_date plus days
SQL
1 vote198 views2 answers
Sql where keyword
SQL
0 vote208 views1 answer
Mysql replication change database name
SQL
1 vote237 views2 answers
Limit sqlserver
SQL
0 vote185 views1 answer
How to find sql server installation folder
SQL
11 votes203 views4 answers
Update row in mysql
SQL
0 vote206 views1 answer
Postgresql regular expression special characters
SQL
0 vote166 views1 answer
Hangfire clean script
SQL
0 vote194 views1 answer
Get the previous column of a table in mysql
SQL
1 vote236 views1 answer
Wherein mysql
SQL

Share