creating table with foreign key constraint




create table seventh(
id int(5),
code varchar(20),
primary key(code),
constraint foreign key(code) references first(code)
on delete restrict
on update cascade
)engine=innodb;

No comments:

Post a Comment

using avrdude with AVR studio(for windows 10 only)

Requirements 1. arduino-1.6.5-r2-windows.exe 2. as6installer-6.0.1843.exe When I try to configure avrdude in avr studio 6 then wina...