728x90 2018/12/172 파티셔닝 Partitioning create table BusinessCard(id int not null, name varchar(255), address varchar(255), telephone varchar(255), createtime date) partition by range(year(createtime))( partition p0 values less than (2013), partition p1 values less than (2014), partition p2 values less than (2015), partition p3 values less than MAXVALUE); show create table BusinessCard\G insert into BusinessCard values (1, 'kim','seou.. 2018. 12. 17. mysql dbdriver call store procedure in codeigniter(ci) mysql dbdriver call store procedure in codeigniter(ci) $sql = "CALL .sp(@out1);"; $this->db->query($sql); $query = $this->db->query("SELECT @out1"); $result_temp = array(); if($query->num_rows() > 0) $result_temp = $query->result_array(); CREATE DEFINER=`id`@`ip` PROCEDURE `sp`( OUT `last_id` INT ) BEGIN SET last_id = "test"; END$$ DELIMITER ; /** * "Count All Results" query * * Generates a plat.. 2018. 12. 17. 이전 1 다음 728x90