创建索引

最新推荐文章于 2024-03-04 11:43:18 发布

weixin_33888907

最新推荐文章于 2024-03-04 11:43:18 发布

阅读量68

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/simadongyang/p/8391210.html

//新增字段
private function create_field($tbl,$field)
{
$sql = "alter table {$tbl} add {$field}";
dd($sql,'',1);
$res = M()->execute($sql);
dd($res,'');
}
private function update_sql($tbl,$update)
{
$sql = "update {$tbl} set {$update}";
dd($sql,'',1);
//$res = M()->query($sql);
//dd($res,'');
}
//删除索引
private function drop_index($tbl,$index)
{
$sql ="alter table {$tbl} drop index {$index}" ;
dd($sql,'');
$res = M()->execute($sql);
dd($res,'');
}
//增加索引
private function create_index($tbl,$field)
{
$sql ="alter table {$tbl} add index index_time ($field)";
dd($sql,'');
$res = M()->execute($sql);
dd($res,'');
}