java技术博客

/** * 位运算的运用-权限控制,add,query,modify,del */ public class Permission { private static final int ALLOW_SELECT = 1<<0; private static final int ALLOW_INSERT = 1<<1; private static final int ALLOW_UPDATE = 1<<2; private sta..

(double)(Math.ceil(price*100)/100) 原来价格为9.9 * 1 UPDATE ewj_market.`market_wd_sku` SET `price`= price*1.05 WHERE `goods_id`=10180553

SET @x = 121; SET @y = 30; -- SET @point = CONCAT('POINT(',@x,' ',@y,')'); set @point= Point(@x,@y); set @geometry=ST_GeomFromText('POLYGON((121 30, 121 30, ..., 121 30, 121 30))'); SELECT ST_Contains(@geometry,@point);//面包含点 SELECT ST_Within(@point,..