chenzhh25的博客

在Mysql数值型的数值和字符串类型的数值，界限是模糊的，比如：字符型的 '1' 和数值型的 1 是相等的

-- 1、方式一select country_nmfrom dw_pub_country_tdwhere country_nm = 'Lao People''s Democratic Republic'-- 2、方式二select country_nmfrom dw_pub_country_tdwhere country_nm = "Lao People's Democratic...

1、实现row_number()select user_nm , login_time , @row_num := @row_num + 1 as rank_numfrom ( select 'zhang' as user_nm, '2019-01-03 12:30:20' as login_time union all select 'zhang' as ...