mysql order by/group by 优化
explain select im.item_id from property_value p left join item i on p.id = i.value left join
item_message im on i.item_id = im.item_id where ( p.value like '%餐饮%' or p.value like '%拉%' ) and im.class = 1 and im.status = 0 and p.`property_id` in (SELECT id from
`property` WHERE `key_p` = 1) LIMIT 24 , 8
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY im ref class,item_id class 4 const 9096 Using where
1 PRIMARY i ref value,item_id item_id 4 fenlei.im.item_id 8 Using where
1 PRIMARY p eq_ref PRIMARY PRIMARY 4 fenlei.i.value 1 Using where
2 DEPENDENT SUBQUERY property unique_subquery PRIMARY PRIMARY 4 func 1 Using where
explain select count(im.item_id), im.item_id from property_value p left join item i on p.id = i.value left join
item_message im on i.item_id = im.item_id where ( p.value like '%餐饮%' or p.value like '%拉%' ) and im.class = 1 and im.status = 0 and p.`property_id` in (SELECT id from
`property` WHERE `key_p` = 1) group by im.item_id LIMIT 20 , 8
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY im index class,item_id item_id 4 NULL 3 Using where
1 PRIMARY i ref value,item_id item_id 4 fenlei.im.item_id 8 Us
相关问答：
我是用mysql自带的C API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("数据库连接失败") ......
我以前安装了一次，后来卸载了，现在再安装的时候，提示错误：Error 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
� ......
有个winform程序,使用c#+mysql,需要在一个窗体设置mysql自动删除功能,包括自动删除多少天之前的数据以及是否开启自动删除功能,我程序退出后,还怎么控制Mysql自己删除啊?是不是要用mysql的event来实现?c#可以调用mysq ......
SQL code:
create PROCEDURE aa(SqlCMD1 varchar(8000),SqlCMD2 varchar(8000),SqlCMD3 varchar(8000))
begin
declare exit handler for sqlexception rollback;
start TRANSACTION;
EXECUTE SqlCMD1;
EXE ......
