SQLize | PHPize | SQLtest

CREATE TABLE movies ( id int CONSTRAINT firstkey PRIMARY KEY, title varchar (50), country varchar (50), date_prod date, director varchar(50), type varchar(20) ); INSERT INTO movies VALUES (1, 'The Matrix', 'USA', '1999-03-24', 'The Wachowskis', 'science fiction'); INSERT INTO movies VALUES (2, 'Men In Black', 'USA', '1999-05-18', 'Barry Sonnenfeld', 'science fiction'); INSERT INTO movies VALUES (3, 'Men In Black', 'USA', '1998-05-18', 'Barry Sonnenfeld', 'science fiction'); INSERT INTO movies VALUES (4, 'Men In Black', 'USA', '1997-05-18', 'Barry Sonnenfeld', 'superhero film'); INSERT INTO movies VALUES (5, 'Batman', 'USA', '1996-05-18', 'Barry Sonnenfeld', 'SUPERHERO FILM'); UPDATE movies SET TYPE = 'SUPERHERO FILM' WHERE id=5; UPDATE movies SET TYPE = 'superhero film' WHERE id=4; SELECT * FROM movies WHERE TYPE LIKE 'SUPERHERO%'; SELECT * FROM movies WHERE TYPE ILIKE 'SUPERHERO%'; ALTER TABLE movies ADD COLUMN email varchar (50); ALTER TABLE movies ADD COLUMN phone varchar (50); UPDATE movies SET email = 'truemail@bigcompany.com' where id=1; UPDATE movies SET email = 'truemail@аfalsecompany' where id=2; UPDATE movies SET email = 'nomailsomecompany.com' where id=3; UPDATE movies SET email = 'false@mail@smallcom#pany.com' where id=4; UPDATE movies SET email = 'othermail@smallcompany.com' where id=5; SELECT * FROM movies WHERE email LIKE '%@%';