53Pgyx5L

1drop database if exists movies;
2create database movies;
3use movies;
4
5create table movies(
6id int primary key auto_increment not null,
7title varchar(100) not null,
8m_year year not null,
9lenght int not null,
10budget double not null
11);
12
13insert into movies(title,m_year,lenght, budget) 
14values("One", 1997 , 120 , 9.5);
15insert into movies(title,m_year,lenght, budget) 
16values("Two", 2000 , 180 , 12.5);
17insert into movies(title,m_year,lenght, budget) 
18values("Three", 2016 , 90 , 10);
19
20select * from movies;