/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 vote238 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote215 views1 answer
Postgresql regular expression special characters
SQL
0 vote258 views1 answer
Psql initialization
SQL
0 vote228 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
14 votes238 views3 answers
Trim sql
SQL
0 vote234 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote227 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote227 views1 answer
Datagrip go to line
SQL
-1 vote241 views3 answers
How to restart mysql in linux
SQL
0 vote221 views1 answer
Number(10 2) in sql means
SQL

Share