SQLize | PHPize | SQLtest

create database sailor__database; use sailor__database; create table sailors(sid int, sname varchar(20), age int, rating int); desc sailors; insert into sailors value (701,'yash',19,7); insert into sailors value (702,'sam',18,8); insert into sailors value (703,'karthik',19,7); insert into sailors value (704,'sai',18,8); select * from sailors; create table boats(bid int,bname varchar(50),bcolour varchar(50)); desc boats; insert into boats value(50,'encore','red'); insert into boats value(51,'titanic','pink'); select * from boats; create table reserved (sid int,bid int,day_ date); desc reserved; insert into reserved value(720,111,'2024-12-24'); insert into reserved value(721,112,'2024-12-15'); insert into reserved value(722,113,'2024-12-25'); select * from reserved; delete from reserved where sid='721'; select * from reserved; alter table boats add constraints primary key(); delete from boats where bname='encore'; alter table boats add constraint primary key(bid); insert into boats values(50,'vignesh','brown'); select * from boats; insert into boats values(113,'vignesh','brown'); insert into boats values(112,'sri','yellow'); insert into sailors values(702,'Mahi',22,7); alter table reserved add constraint fk1 foreign key(sid) references sailors(sid); alter table reserved add constraint fk2 foreign key(bid) references boats(bid);