SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE players( player_id int, name varchar(25), date_of_birth varchar(25), batting_hand varchar(25), country varchar(25) ); CREATE TABLE teams( team_id int, team_name varchar(40) ); CREATE TABLE matches( match_id int, season varchar(40), city varchar(40), team1 varchar(40), team2 varchar(40), winner varchar(40) ); INSERT INTO players(player_id,name,date_of_birth,batting_hand,country) VALUES (1,'A Kumble',1970-10-17,'Right Hand','India'); INSERT INTO players(player_id,name,date_of_birth,batting_hand,country) VALUES (2,'G Gambhir',1981-10-14,'Right Hand','India'); INSERT INTO players(player_id,name,date_of_birth,batting_hand,country) VALUES (3,'Harbhajan Singh',1980-07-03,'Right Hand','India'); INSERT INTO players(player_id,name,date_of_birth,batting_hand,country) VALUES (4,'A K H Pandya',1991-03-24,'Left Hand','India'); INSERT INTO players(player_id,name,date_of_birth,batting_hand,country) VALUES (5,'AB de Villiers',1984-02-17,'Right Hand','South Africa'); INSERT INTO teams (team_id,team_name) VALUES (1,'Pune Warriors'); INSERT INTO teams (team_id,team_name) VALUES (2,'Chenai Super Kings'); INSERT INTO teams (team_id,team_name) VALUES (3,'Mubai Indians'); INSERT INTO teams (team_id,team_name) VALUES (4,'Royal Challengers Bangalore'); INSERT INTO matches(match_id,season,city,team1,team2,winner) VALUES (1,'IPL-2019','Delhi','Mumai indians','Delhi Capitals','Mumbai Indians'); INSERT INTO matches(match_id,season,city,team1,team2,winner) VALUES (2,'IPL-2019','Chennai','mumbai indians','Chennai Super King','Mumbai Indians'); INSERT INTO matches(match_id,season,city,team1,team2,winner) VALUES (3,'IPL-2019','Bangalore','Royal Challenger Bangalore','Delhi Capitals','Delhi Capitals'); INSERT INTO matches(match_id,season,city,team1,team2,winner) VALUES (4,'IPL-2019','Chennai','Chennai Super King','Raiasthan Royals','Chennai Super King'); SELECT * FROM players; SELECT * FROM teams; SELECT * FROM matches; SELECT name FROM players; SELECT name,batting_hand FROM players WHERE batting_hand='Left Hand'; SELECT team_id,team_name FROM teams WHERE team_id=5; SELECT team1,team2 FROM matches WHERE winner='Mubbai Indians'; SELECT winner,season FROM matches WHERE city='Delhi'; UPDATE players SET batting_hand='Left Hand'WHERE name='G Gambhir'; UPDATE matches SET city='Bangalore'WHERE match_id=1; ALTER TABLE teams ADD team_size int; ALTER TABLE teams DROP COLUMN team_size; DELETE FROM teams WHERE team_id=5;