/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 vote142 views1 answer
Bidirectional outer join sql
SQL
0 vote159 views1 answer
Trigger stock phpmyadmin
SQL
5 votes144 views2 answers
Get number of columns sql
SQL
0 vote147 views1 answer
Mysql date time string format for marshmellow field schema
SQL
0 vote142 views1 answer
Basic structure of sql expression having clause
SQL
0 vote148 views3 answers
Duplicate row mysql
SQL
0 vote142 views5 answers
Mode sql course
SQL
0 vote140 views1 answer
Sql column as header
SQL
-1 vote157 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote134 views1 answer
How to count null values in sql
SQL

Share