SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'CF_USER' [ RunTime:0.000776s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS think_count FROM [CF_USER] WHERE [NICK] NOT LIKE '%[GM]%') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000541s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [EXP] DESC) AS ROW_NUMBER FROM (SELECT [NICK],[LEV],[EXP],[GAME_POINT],[LAST_PLAY_DATE],[USN],[nicheng] FROM [CF_USER] WHERE [NICK] NOT LIKE '%[GM]%') AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 100 + 1 AND 100 + 10) [ RunTime:0.000540s ]
UPDATE [CF_USER] SET [nicheng] = '放大发生' FROM [CF_USER] WHERE [USN] = 62549 [ RunTime:0.000738s ]
UPDATE [CF_USER] SET [nicheng] = 'xiaoyu123' FROM [CF_USER] WHERE [USN] = 82652 [ RunTime:0.000583s ]
UPDATE [CF_USER] SET [nicheng] = 'Nepr' FROM [CF_USER] WHERE [USN] = 82643 [ RunTime:0.000617s ]
UPDATE [CF_USER] SET [nicheng] = '晴晴暖暖' FROM [CF_USER] WHERE [USN] = 52485 [ RunTime:0.000572s ]
UPDATE [CF_USER] SET [nicheng] = 'qqaa' FROM [CF_USER] WHERE [USN] = 62534 [ RunTime:0.000591s ]
UPDATE [CF_USER] SET [nicheng] = 'waitwind' FROM [CF_USER] WHERE [USN] = 82587 [ RunTime:0.000577s ]
UPDATE [CF_USER] SET [nicheng] = '爱鹿' FROM [CF_USER] WHERE [USN] = 62541 [ RunTime:0.000578s ]
UPDATE [CF_USER] SET [nicheng] = 'Special' FROM [CF_USER] WHERE [USN] = 82664 [ RunTime:0.000581s ]
UPDATE [CF_USER] SET [nicheng] = 'anovice' FROM [CF_USER] WHERE [USN] = 62567 [ RunTime:0.000529s ]
UPDATE [CF_USER] SET [nicheng] = 'ACE.' FROM [CF_USER] WHERE [USN] = 62517 [ RunTime:0.000680s ]