/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

2 votes236 views1 answer
Brew start postgres manual
SQL
3 votes220 views1 answer
Oracle undo tablespace list by user
SQL
1 vote270 views1 answer
Nvl postgres
SQL
0 vote229 views1 answer
Oracle date summer time
SQL
0 vote237 views1 answer
18446744073709551615 mariadb left join order by
SQL
1 vote241 views1 answer
Find a column in all tables postgres
SQL
1 vote231 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
1 vote210 views1 answer
Sql myisam vs innodb
SQL
21 votes237 views4 answers
Oracle add column
SQL
0 vote240 views1 answer
Query params sql insert python f string
SQL

Share