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.000789s ]
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.000604s ]
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 120 + 1 AND 120 + 10) [ RunTime:0.000598s ]
UPDATE [CF_USER] SET [nicheng] = '123456' FROM [CF_USER] WHERE [USN] = 82604 [ RunTime:0.000586s ]
UPDATE [CF_USER] SET [nicheng] = '来了' FROM [CF_USER] WHERE [USN] = 82623 [ RunTime:0.000709s ]
UPDATE [CF_USER] SET [nicheng] = '空白的空气' FROM [CF_USER] WHERE [USN] = 52459 [ RunTime:0.000581s ]
UPDATE [CF_USER] SET [nicheng] = 'pinoer1' FROM [CF_USER] WHERE [USN] = 62554 [ RunTime:0.000609s ]
UPDATE [CF_USER] SET [nicheng] = '狙狙狙狙狙狙' FROM [CF_USER] WHERE [USN] = 82655 [ RunTime:0.000532s ]
UPDATE [CF_USER] SET [nicheng] = '你才' FROM [CF_USER] WHERE [USN] = 82658 [ RunTime:0.000715s ]
UPDATE [CF_USER] SET [nicheng] = 'asd' FROM [CF_USER] WHERE [USN] = 82659 [ RunTime:0.000626s ]
UPDATE [CF_USER] SET [nicheng] = '758912' FROM [CF_USER] WHERE [USN] = 82666 [ RunTime:0.000587s ]
UPDATE [CF_USER] SET [nicheng] = 'yinaen' FROM [CF_USER] WHERE [USN] = 82667 [ RunTime:0.000582s ]
UPDATE [CF_USER] SET [nicheng] = 'CCTV' FROM [CF_USER] WHERE [USN] = 82668 [ RunTime:0.000483s ]