摘要: sql生成随机数 select rand() as 随机数 select cast(floor(rand()*10) as int) as 随机数 update语句结合case when 语句 UPDATE mytable SET myfield = CASE id WHEN 1 THEN 'val 阅读全文
posted @ 2020-10-21 11:22 wiggin 阅读(1603) 评论(0) 推荐(0) 编辑