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.000675s ]
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.000558s ]
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 20 + 1 AND 20 + 10) [ RunTime:0.000508s ]
UPDATE [CF_USER] SET [nicheng] = 'YiYa' FROM [CF_USER] WHERE [USN] = 52349 [ RunTime:0.000573s ]
UPDATE [CF_USER] SET [nicheng] = '黑色玫瑰' FROM [CF_USER] WHERE [USN] = 52482 [ RunTime:0.000597s ]
UPDATE [CF_USER] SET [nicheng] = 'Jujubefruit' FROM [CF_USER] WHERE [USN] = 52512 [ RunTime:0.000607s ]
UPDATE [CF_USER] SET [nicheng] = 'Dissss' FROM [CF_USER] WHERE [USN] = 52387 [ RunTime:0.000523s ]
UPDATE [CF_USER] SET [nicheng] = '大鸡巴' FROM [CF_USER] WHERE [USN] = 52378 [ RunTime:0.000539s ]
UPDATE [CF_USER] SET [nicheng] = '晨晨' FROM [CF_USER] WHERE [USN] = 52415 [ RunTime:0.000555s ]
UPDATE [CF_USER] SET [nicheng] = 'wolaiye' FROM [CF_USER] WHERE [USN] = 52478 [ RunTime:0.000592s ]
UPDATE [CF_USER] SET [nicheng] = '溷恒啊' FROM [CF_USER] WHERE [USN] = 62513 [ RunTime:0.000604s ]
UPDATE [CF_USER] SET [nicheng] = 'xind' FROM [CF_USER] WHERE [USN] = 52418 [ RunTime:0.000562s ]
UPDATE [CF_USER] SET [nicheng] = '乖乖' FROM [CF_USER] WHERE [USN] = 52384 [ RunTime:0.000598s ]