- При помощи SQL создай и заполни следующую таблицу.
Sql Server
- Создание таблицы
create table Movies(
Id int primary key identity(1,1),
Title varchar(40) unique,
Director varchar(40) not null,
Year int not null,
Length_minutes int not null)
--Заполнение--
insert into Movies(Title, Director, Year, Length_minutes)
Values('Toy Story','John Lasseter', 1995, 81);
insert into Movies(Title, Director, Year, Length_minutes)
Values('A Bug’s Life','John Lasseter', 1998, 95);
insert into Movies(Title, Director, Year, Length_minutes)
Values('Toy Story 2','John Lasseter', 1999, 93);
insert into Movies(Title, Director, Year, Length_minutes)
Values('Monsters, Inc.','Pete Docter', 2001, 92);
insert into Movies(Title, Director, Year, Length_minutes)
Values('Finding Nemo','Andrew Stanton', 2003, 107);
insert into Movies(Title, Director, Year, Length_minutes)
Values('The Incredibles','Brad Bird', 2004, 116);
insert into Movies(Title, Director, Year, Length_minutes)
Values('Cars','John Lasseter', 2006, 117);
insert into Movies(Title, Director, Year, Length_minutes)
Values('Ratatouille','Brad Bird', 2007, 115);
insert into Movies(Title, Director, Year, Length_minutes)
Values('WALL-E','Andrew Stanton', 2008, 104);
insert into Movies(Title, Director, Year, Length_minutes)
Values('Up','Pete Docter', 2009, 101);
2. При помощи SELECT запроса найди все фильмы продолжительностью от 100 мин до 120 мин
select * from Movies
where Length_minutes > 100 and Length_minutes < 120
3. При помощи SELECT запроса найди все фильмы, начинающиеся на букву T и на букву W
select * from Movies
where Title like 'W%' or Title like 'T%'
4. Обнови таблицу при помощи UPDATE, вместо режисера Pete Docter надо писать Ivanov
Update Movies
Set Director = 'Ivanov'
where Director = 'Pete Docter';
select * from Movies
LocalHost
- Создание таблицы
create table Movies(
Id int primary key AUTO_INCREMENT,
Title varchar(40) unique,
Director varchar(40) not null,
Year int not null,
Length_minutes int not null)
--Заполнение--
insert into Movies(Title, Director, Year, Length_minutes)
Values('Toy Story','John Lasseter', 1995, 81);
insert into Movies(Title, Director, Year, Length_minutes)
Values('A Bug’s Life','John Lasseter', 1998, 95);
insert into Movies(Title, Director, Year, Length_minutes)
Values('Toy Story 2','John Lasseter', 1999, 93);
insert into Movies(Title, Director, Year, Length_minutes)
Values('Monsters, Inc.','Pete Docter', 2001, 92);
insert into Movies(Title, Director, Year, Length_minutes)
Values('Finding Nemo','Andrew Stanton', 2003, 107);
insert into Movies(Title, Director, Year, Length_minutes)
Values('The Incredibles','Brad Bird', 2004, 116);
insert into Movies(Title, Director, Year, Length_minutes)
Values('Cars','John Lasseter', 2006, 117);
insert into Movies(Title, Director, Year, Length_minutes)
Values('Ratatouille','Brad Bird', 2007, 115);
insert into Movies(Title, Director, Year, Length_minutes)
Values('WALL-E','Andrew Stanton', 2008, 104);
insert into Movies(Title, Director, Year, Length_minutes)
Values('Up','Pete Docter', 2009, 101);
2. При помощи SELECT запроса найди все фильмы продолжительностью от 100 мин до 120 мин
select * from Movies
where Length_minutes > 100 and Length_minutes < 120
3. При помощи SELECT запроса найди все фильмы, начинающиеся на букву T и на букву W
select * from Movies
where Title like 'W%' or Title like 'T%'
4. Обнови таблицу при помощи UPDATE, вместо режисера Pete Docter надо писать Ivanov
Update Movies
Set Director = 'Ivanov'
where Director = 'Pete Docter';
select * from Movies
