摘要: SELECT GROUP_CONCAT(NUMB SEPARATOR '&') FROM ( SELECT @num :=@num + 1 AS NUMB FROM information_schema. TABLES t1, information_schema. TABLE... 阅读全文
posted @ 2019-05-22 23:48 CodingYM 阅读(101) 评论(0) 推荐(0) 编辑
摘要: SET @ROW_NUMBER:=0; select round(avg(LAT_N),4) from ( select @Row_Number := @Row_Number +1 as count_of_group, LAT_N , (SELECT COUNT(*) FROM Station ) AS... 阅读全文
posted @ 2019-05-22 23:10 CodingYM 阅读(238) 评论(0) 推荐(0) 编辑
摘要: Problem Description Analysis: We can use REPEAT function to solve problem. The syntax is REPEAT(str, count), str is the string to repeat and count is 阅读全文
posted @ 2019-05-22 17:24 CodingYM 阅读(128) 评论(0) 推荐(0) 编辑