2023年4月21日
摘要: SELECT UNIX_TIMESTAMP(); SELECT NOW(); SELECT DATE_FORMAT(NOW(),'%Y-%m-%d %H:%i:%s') AS TIME; select FROM_UNIXTIME(UNIX_TIMESTAMP(),'%Y-%m-%d %H:%i:%S 阅读全文
posted @ 2023-04-21 09:38 boye169 阅读(166) 评论(0) 推荐(0) 编辑
摘要: SELECT * FROM student; SELECT `name`,`subject`,`score`,(@i:=@i+1) AS '序号' FROM student,(SELECT @i:=0) AS itable; 阅读全文
posted @ 2023-04-21 09:31 boye169 阅读(23) 评论(0) 推荐(0) 编辑