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.000689s ]
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.000516s ]
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 170 + 1 AND 170 + 10) [ RunTime:0.000668s ]
UPDATE [CF_USER] SET [nicheng] = 'W23' FROM [CF_USER] WHERE [USN] = 52474 [ RunTime:0.000631s ]
UPDATE [CF_USER] SET [nicheng] = 'huanshen' FROM [CF_USER] WHERE [USN] = 52468 [ RunTime:0.000595s ]
UPDATE [CF_USER] SET [nicheng] = 'Nan' FROM [CF_USER] WHERE [USN] = 52495 [ RunTime:0.000624s ]
UPDATE [CF_USER] SET [nicheng] = '奶龙' FROM [CF_USER] WHERE [USN] = 52492 [ RunTime:0.000644s ]
UPDATE [CF_USER] SET [nicheng] = '墨青' FROM [CF_USER] WHERE [USN] = 52489 [ RunTime:0.000612s ]
UPDATE [CF_USER] SET [nicheng] = 'sss' FROM [CF_USER] WHERE [USN] = 62527 [ RunTime:0.000565s ]
UPDATE [CF_USER] SET [nicheng] = '恋爱吗' FROM [CF_USER] WHERE [USN] = 62522 [ RunTime:0.000677s ]
UPDATE [CF_USER] SET [nicheng] = 'cheat' FROM [CF_USER] WHERE [USN] = 62523 [ RunTime:0.000554s ]
UPDATE [CF_USER] SET [nicheng] = '0.0' FROM [CF_USER] WHERE [USN] = 62524 [ RunTime:0.000597s ]
UPDATE [CF_USER] SET [nicheng] = 'aaaaaaaa' FROM [CF_USER] WHERE [USN] = 62542 [ RunTime:0.000568s ]