【MySQL5】

use mydb2;
-- 创建商品表
create table product(
id int primary key auto_increment,
name varchar(20) not null,
price double,
category_id varchar(20)
);
-- 添加数据
insert into product values(null,'海尔冰箱',5000,'c001');
insert into product values(null,'美的冰箱',3000,'c001');
insert into product values(null,'格力空调',5000,'c001');
insert into product values(null,'九阳电饭煲',5000,'c001');

insert into product values(null,'啄木鸟衬衣',300,'c002');
insert into product values(null,'恒源祥西裤',800,'c002');
insert into product values(null,'花花公子夹克',440,'c002');
insert into product values(null,'劲霸休闲裤',266,'c002');
insert into product values(null,'海澜之家卫衣',180,'c002');
insert into product values(null,'杰克琼斯运动裤',430,'c002');

insert into product values(null,'兰蔻面霜',300,'c003');
insert into product values(null,'雅诗兰黛精华水',200,'c003');
insert into product values(null,'香奈儿香水',350,'c003');
insert into product values(null,'sk-II神仙水',350,'c003');
insert into product values(null,'资生堂粉底液',180,'c003');

insert into product values(null,'老北京方便面',56,'c004');
insert into product values(null,'良品铺子海带丝',17,'c004');
insert into product values(null,'三字松鼠坚果',88,null);

-- 查询
-- 1、查询所有商品
select id,name,price,category_id from product;
select * from product;-- 简洁版
-- 2、查询商品名和商品价格
select name,price from product;
-- 3、别名查询，使用关键字as(as也可以省略),主要用于多表查询
-- 3.1、表别名
select * from product as p;
select * from product p;
-- 3.1、列别名
select name as '商品名',price '商品价格' from product;
-- 4、去掉重复值
select distinct price from product;--
select distinct * from product;-- 去掉重复某行
-- 5、查询结果为表达式（运算查询）
select name,price+10 new_price from product;
select name,price+10 from product;