/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

1 vote178 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote180 views1 answer
Oracle job class
SQL
1 vote219 views2 answers
Copy table in sql
SQL
11 votes200 views5 answers
Sql server reset identity
SQL
1 vote210 views1 answer
Increase date by one day in sql oracle
SQL
2 votes185 views1 answer
Mysql clear screen
SQL
0 vote197 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote209 views1 answer
Sql create and grant user access to database
SQL
0 vote204 views1 answer
Sql select min row
SQL
0 vote203 views1 answer
Oracle string length
SQL

Share