SQLize Online / PHPize Online  /  SQLtest Online

create table sports (student_no int(2) , class int(2) , name varchar(10),game1 varchar(15),grade1 varchar(1),game2 varchar (15), grade2 varchar(1)); insert into sports values (10,7,'sameer','cricket','b','swimming','a'); select * from sports; insert into sports values (11,8,'sujit','tennis','a','skating','c'); insert into sports values (12,7,'kamal','swimming','b','football','b'); insert into sports values (13,7,'vena','tennis','c','tennis','a'); insert into sports values (14,9,'archana','basketball','a','cricket','a'); insert into sports values (15,10,'arpit','cricket','a','athlectics','c'); select name from sports where grade1='c' or grade2='c'; select name from sports where game1=game2 select game1,game2 from sports where name like "a%"; Select game1 , game2 from sports Where name like 'A%' ; select game1 , game2 from sports where name like 'A%'; DESC sports; alter table sports add(date_of_birth date); desc sports; alter table sports add constraint unique (student_no); desc sports; alter table sports add constraint default'c' (grade1); alter table sports add constraint not null (name); alter table sports add constraint primary key (name); desc sports;