/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 vote201 views1 answer
Mysql query problems and solutions
SQL
0 vote202 views1 answer
Mysql DDL
SQL
5 votes183 views1 answer
Sql first day of current year
SQL
1 vote219 views1 answer
Mysql find most common value
SQL
2 votes193 views1 answer
Date conversion in mysql column
SQL
1 vote198 views1 answer
Sql alchemy with azuresql server
SQL
5 votes219 views1 answer
Oracle get ddl
SQL
0 vote187 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote187 views1 answer
Events not working db
SQL
1 vote195 views1 answer
Lpad function in sql oracle
SQL

Share