xfy18317776108的博客

Cast(列名 as 转换的类型 )，其中类型可以为： CHAR[(N)] 字符型  DATE  日期型 DATETIME  日期和时间型 DECIMAL  float型 SIGNED  int TIME  时间型 转载： https://blog.youkuaiyun.com/m0_37450089/article/details/80750994...

1.SELECT it.item_id itemId, it.item_code itemCode, it.image image, it.item_name itemName,it.person person,sh.shops_name shopsName,(select if(max(CAST(sales_price AS SIGNED)) = min(CAST(sales_price AS ...