sql变量使用实例
SET @tmp=980; SET @co='1468057042'; UPDATE httl_price SET PRICE_PRICE=@tmp WHERE PRICE_GOODS_CODE=@co AND PRICE_YEAR='1'; UPDATE httl_price SET PRICE_PRICE=@tmp*PRICE_YEAR WHERE PRICE_GOODS_CODE=@co AND PRICE_YEAR='2'; UPDATE httl_price SET PRICE_PRICE=@tmp*PRICE_YEAR WHERE PRICE_GOODS_CODE=@co AND PRICE_YEAR='3'; UPDATE httl_price SET PRICE_PRICE=@tmp*PRICE_YEAR WHERE PRICE_GOODS_CODE=@co AND PRICE_YEAR='5'; SELECT * FROM price WHERE PRICE_GOODS_CODE=@co SET @tmp='1468057042'; INSERT INTO httl_price (PRICE_CODE,PRICE_GOODS_CODE,PRICE_YEAR,PRICE_PRICE,PRICE_OLD_PRICE,PRICE_TYPE) VALUES('8208602803',@tmp,1,'56','null','1'); INSERT INTO httl_price (PRICE_CODE,PRICE_GOODS_CODE,PRICE_YEAR,PRICE_PRICE,PRICE_OLD_PRICE,PRICE_TYPE) VALUES('8632475175',@tmp,2,'56','null','1'); INSERT INTO httl_price (PRICE_CODE,PRICE_GOODS_CODE,PRICE_YEAR,PRICE_PRICE,PRICE_OLD_PRICE,PRICE_TYPE) VALUES('7157438427',@tmp,3,'56','null','1'); INSERT INTO httl_price (PRICE_CODE,PRICE_GOODS_CODE,PRICE_YEAR,PRICE_PRICE,PRICE_OLD_PRICE,PRICE_TYPE) VALUES('7773212660',@tmp,5,'56','null','1'); SELECT * FROM price WHERE PRICE_GOODS_CODE=@tmp
如今的编程是一场程序员和上帝的竞赛,程序员要开发出更大更好、傻瓜都会用到软件。而上帝在努力创造出更大更傻的傻瓜。目前为止,上帝是赢的。
QQ:6203142
-----在北京的四川小伙