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.000815s ]
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.000613s ]
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 180 + 1 AND 180 + 10) [ RunTime:0.000636s ]
UPDATE [CF_USER] SET [nicheng] = 'aka123' FROM [CF_USER] WHERE [USN] = 62536 [ RunTime:0.000662s ]
UPDATE [CF_USER] SET [nicheng] = 'suibian' FROM [CF_USER] WHERE [USN] = 52504 [ RunTime:0.000545s ]
UPDATE [CF_USER] SET [nicheng] = '方法' FROM [CF_USER] WHERE [USN] = 52497 [ RunTime:0.000620s ]
UPDATE [CF_USER] SET [nicheng] = '奸夫' FROM [CF_USER] WHERE [USN] = 52499 [ RunTime:0.000616s ]
UPDATE [CF_USER] SET [nicheng] = 'xiaodouya' FROM [CF_USER] WHERE [USN] = 52507 [ RunTime:0.000615s ]
UPDATE [CF_USER] SET [nicheng] = 'dadada' FROM [CF_USER] WHERE [USN] = 52509 [ RunTime:0.000608s ]
UPDATE [CF_USER] SET [nicheng] = 'story' FROM [CF_USER] WHERE [USN] = 52510 [ RunTime:0.000634s ]
UPDATE [CF_USER] SET [nicheng] = '好烦好烦刚刚' FROM [CF_USER] WHERE [USN] = 52347 [ RunTime:0.000580s ]
UPDATE [CF_USER] SET [nicheng] = '温言' FROM [CF_USER] WHERE [USN] = 52364 [ RunTime:0.000587s ]
UPDATE [CF_USER] SET [nicheng] = '6﨩' FROM [CF_USER] WHERE [USN] = 52370 [ RunTime:0.000612s ]