学习内容:
SQL第13课:插入行
表1:Movies
表2:Boxoffice
Exercise 13 — Tasks
- Add the studio's new production, Toy Story 4 to the list of movies (you can use any director)
- Toy Story 4 has been released to critical acclaim! It had a rating of 8.7, and made 340 million domestically and 270 million internationally. Add the record to the
BoxOffice
table.
用到的SQL语句:
插入包含所有列值的语句
INSERT INTO mytable VALUES (value_or_expr, another_value_or_expr, …), (value_or_expr_2, another_value_or_expr_2, …), …;
插入包含特定列的语句
INSERTINTO mytable (column, another_column, …) VALUES (value_or_expr, another_value_or_expr, …), (value_or_expr_2, another_value_or_expr_2, …), …;
示例使用表达式插入语句
INSERTINTO boxoffice (movie_id, rating, sales_in_millions)VALUES (1, 9.9, 283742034 / 1000000);
主要学习的是不改变数据库结构的情况下插入数值。在互联网运营中,SQL使用插入功能使用的较少,用户在下订单,浏览页面,留下足迹的过程中,往往是在“主动”地向数据库中插入数据,但是这些海量数据需要进行清洗,筛除空值变换等才能成为有用的数据。
输出结果:
1.insert into Movies (ID,title, director, year, length_minutes )
values (4,"Toy Story 4","Pete Docter",1976,76)
其他参考答案:
INSERT INTO movies VALUES (4, "Toy Story 4", "El Directore", 2015, 90);
2.参考答案:
INSERT INTO boxoffice VALUES (4, 8.7, 340000000, 270000000);
有误语句
insert into Boxoffice (Movie_id,Rating,Domestic_sales,nternational_sales)
values (4,8.7,340000000,270000000)
注意:插入纯数值数据和字符串数据之间的SQL语句区别。