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.000762s ]
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.000493s ]
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 60 + 1 AND 60 + 10) [ RunTime:0.000493s ]
UPDATE [CF_USER] SET [nicheng] = '77777' FROM [CF_USER] WHERE [USN] = 52477 [ RunTime:0.000580s ]
UPDATE [CF_USER] SET [nicheng] = '龙少' FROM [CF_USER] WHERE [USN] = 52484 [ RunTime:0.000573s ]
UPDATE [CF_USER] SET [nicheng] = '99VA' FROM [CF_USER] WHERE [USN] = 82589 [ RunTime:0.000553s ]
UPDATE [CF_USER] SET [nicheng] = 'Fan' FROM [CF_USER] WHERE [USN] = 82609 [ RunTime:0.000625s ]
UPDATE [CF_USER] SET [nicheng] = '恐龙' FROM [CF_USER] WHERE [USN] = 52406 [ RunTime:0.000678s ]
UPDATE [CF_USER] SET [nicheng] = '八口' FROM [CF_USER] WHERE [USN] = 62563 [ RunTime:0.000596s ]
UPDATE [CF_USER] SET [nicheng] = '老麻陪聊' FROM [CF_USER] WHERE [USN] = 52515 [ RunTime:0.000626s ]
UPDATE [CF_USER] SET [nicheng] = '桥本' FROM [CF_USER] WHERE [USN] = 52355 [ RunTime:0.000580s ]
UPDATE [CF_USER] SET [nicheng] = 'Zdwff' FROM [CF_USER] WHERE [USN] = 82606 [ RunTime:0.000630s ]
UPDATE [CF_USER] SET [nicheng] = '看可' FROM [CF_USER] WHERE [USN] = 52470 [ RunTime:0.000578s ]