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.000823s ]
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.000625s ]
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 130 + 1 AND 130 + 10) [ RunTime:0.000669s ]
UPDATE [CF_USER] SET [nicheng] = '你猜猜' FROM [CF_USER] WHERE [USN] = 82646 [ RunTime:0.000743s ]
UPDATE [CF_USER] SET [nicheng] = 'dad-' FROM [CF_USER] WHERE [USN] = 82644 [ RunTime:0.000605s ]
UPDATE [CF_USER] SET [nicheng] = 'boss' FROM [CF_USER] WHERE [USN] = 82634 [ RunTime:0.000563s ]
UPDATE [CF_USER] SET [nicheng] = '000' FROM [CF_USER] WHERE [USN] = 82635 [ RunTime:0.000583s ]
UPDATE [CF_USER] SET [nicheng] = '吊打666' FROM [CF_USER] WHERE [USN] = 82638 [ RunTime:0.000599s ]
UPDATE [CF_USER] SET [nicheng] = '阿基诺的扩大' FROM [CF_USER] WHERE [USN] = 82639 [ RunTime:0.000558s ]
UPDATE [CF_USER] SET [nicheng] = '陌路' FROM [CF_USER] WHERE [USN] = 82640 [ RunTime:0.000571s ]
UPDATE [CF_USER] SET [nicheng] = '陌路1' FROM [CF_USER] WHERE [USN] = 82641 [ RunTime:0.000667s ]
UPDATE [CF_USER] SET [nicheng] = 'PQKASD' FROM [CF_USER] WHERE [USN] = 82619 [ RunTime:0.000576s ]
UPDATE [CF_USER] SET [nicheng] = '124555566' FROM [CF_USER] WHERE [USN] = 82620 [ RunTime:0.000599s ]