select count(*), type from content group by type

select * from content where 已发=1 and type != '降价促销' order by id ASC

update content set 已发=0 where id<10

/* activate global logging and the logfile path*/
SET GLOBAL general_log = 'ON';
SET GLOBAL general_log_file = '/Users/mathiaspeter/logs/mysql_general.log';

/* deactivate global logging */
SET GLOBAL general_log = 'OFF';

/* show variables  */
SHOW GLOBAL VARIABLES like '%log%';

/* benchmark a sql query  */
SELECT BENCHMARK(100000,(
	SELECT 1
))

SELECT YourColumn, COUNT(*) TotalCount
FROM YourTable
GROUP BY YourColumn
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC