mysql 和sqlserver 的不同

sqlserver: isnull
mysql    : ifnull

sqlserver:select top 1 * from tablename order by ID
mysql    :select * from tablename order by ID limit 1

sqlserver：ISNULL(login_time,'1999-01-01 00:00:00') login_time

mysql:COALESCE(login_time, date('1990-01-01 00:00:00')) as login_time

sqlserver：DELETE  SYSTEM_USER_INFO where user_id = 999

mysql:        DELETE  FROM SYSTEM_USER_INFO where user_id = 999