Nss_6478的博客

CONCAT(UNIX_TIMESTAMP(NOW()), RIGHT(NOW(3), 3)),

比如有一张user表  有字段username（用户名），status（状态）   表中有三条数据 username = "张三" status = 1，username = "李四" status = 0， username = "王五" status = 1现在要将username更新为拼音,sql如下UPDATE USERSET username = ( CASE username W...