【澳门新萄京娱乐场】世界的尽头只是一块布景

作者:观影指南

如果世界的尽头,只是一块布景,
如果亲人与朋友,只是一群演员,
那么地球上的人类,又是谁安排的真人秀大片?
谁又能扬帆远航乘风破浪去戳破那纸糊的蓝天?
如果不能再相见,
如果要说句赠言,
那么"good afternoon good evening and good night~"

good!!!!!!!!good!!!!!!!!!good good good good good good good good good good good good good good good good good good good good good good good good good good good

SELECT * FROM ecs_goods WHERE goods_id = 1;
SELECT goods_id, goods_name FROM ecs_goods WHERE goods_id = 1;
SELECT goods_id,cat_id,goods_name FROM ecs_goods WHERE cat_id != 3;
SELECT goods_id,cat_id,goods_name FROM ecs_goods WHERE cat_id <> 3;
SELECT goods_id,cat_id,goods_name,shop_price FROM ecs_goods WHERE shop_price > 3000;
SELECT goods_id,cat_id,goods_name,shop_price FROM ecs_goods WHERE shop_price <= 100;

SELECT goods_id,cat_id,goods_name,shop_price FROM ecs_goods WHERE cat_id = 4 OR cat_id = 3;
SELECT goods_id,cat_id,goods_name,shop_price FROM ecs_goods WHERE cat_id IN( 3, 4 );

SELECT goods_id,cat_id,goods_name,shop_price FROM ecs_goods WHERE shop_price BETWEEN 100 AND 858;

SELECT goods_id,cat_id,goods_name,shop_price FROM ecs_goods WHERE cat_id != 3 AND cat_id != 4
SELECT goods_id,cat_id,goods_name,shop_price FROM ecs_goods WHERE cat_id NOT IN( 3, 4 );
SELECT goods_id,cat_id,goods_name,shop_price FROM ecs_goods WHERE cat_id NOT BETWEEN 3 AND 4

SELECT goods_id,cat_id,goods_name,shop_price FROM ecs_goods WHERE ( shop_price > 100 AND shop_price < 300 )
OR ( shop_price > 1000 AND shop_price < 3000 );

SELECT goods_id,cat_id,goods_name,shop_price,click_count FROM ecs_goods WHERE (cat_id = 3 ) AND ( shop_price >= 1000 AND shop_price <= 3000 )
AND ( click_count > 5 )

 

SELECT * FROM ecs_goods WHERE cat_id IN ( 2, 3, 4, 5 )

SELECT goods_id,cat_id,goods_name FROM ecs_goods WHERE goods_name LIKE '诺基亚%'

 

 #把表中字段num取值范围为20~29之间的值变成20【注:ecshop2.7.3没有这个ecs_mian1这个表,可以自己创建一个,他就一个字段num, int类型,然后填充一些测试数据】

UPDATE ecs_mian1 SET num = ( FLOOR( num / 10 ) * 10 ) WHERE num >= 20 AND num <= 29

 #把表中字段num取值范围为30~39之间的值变成30

UPDATE ecs_mian1 SET num = ( FLOOR( num / 10 ) * 10 ) WHERE num BETWEEN 30 AND 39

 

#以”诺基亚"开头的商品

SELECT goods_id, goods_name FROM ecs_goods WHERE goods_name LIKE '诺基亚%';

#截取"诺基亚"后面的商品名称,并用"小米"开始 连接起来
SELECT goods_id, CONCAT( '小米', SUBSTRING( goods_name, 4 ) ) FROM ecs_goods WHERE goods_name LIKE '诺基亚%';

#截取"诺基亚"后面的商品名称,并用"小米"开始 连接起来后更新
UPDATE ecs_goods SET goods_name = CONCAT( '小米', SUBSTRING( goods_name, 4 ) ) WHERE goods_name LIKE '诺基亚%'

#以上面的语句相反
UPDATE ecs_goods SET goods_name = CONCAT( '诺基亚', SUBSTRING( goods_name, 4 ) ) WHERE goods_name LIKE '小米%'

本文由澳门新萄京娱乐场发布,转载请注明来源

关键词: