/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

6 votes132 views4 answers
Mysql get random row
SQL
0 vote128 views1 answer
Postgres enumerated type
SQL
0 vote126 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
2 votes118 views1 answer
How to get non distinct values in sql
SQL
2 votes118 views1 answer
Delete all value query
SQL
5 votes118 views3 answers
Select tables from mysql database
SQL
0 vote118 views2 answers
Oracle select
SQL
3 votes116 views3 answers
Mysql get table size
SQL
1 vote104 views1 answer
Create procedure with encryption
SQL
0 vote122 views1 answer
Mysql cli output to a file
SQL

Share