执行语句
示例:
//新增数据表字段
private function addIt(){
$sql = '';
$sql = "ALTER TABLE seo_class ADD gb_class_id INT(8) default 0 COMMENT '行业id';";
$query = $this->db->query($sql);
$sql = "ALTER TABLE seo_class ADD gb_class_name VARCHAR(100) default ‘’ COMMENT '行业名称';";
$query = $this->db->query($sql);
$sql = "ALTER TABLE seo_class ADD gb_pclass_id INT(8) default 0 COMMENT '父类行业id';";
$query = $this->db->query($sql);
$sql = "ALTER TABLE seo_class ADD gb_pclass_name VARCHAR(100) default ‘’ COMMENT '父类行业名称';";
$query = $this->db->query($sql);
return $query;
}
- CI框架中的sql语句要逐条执行;
- int型字段默认值0,varchar型字段默认值’’