我有两个数据库名称为"Employee",其中一个表为"users",第二个数据库为"customer"。我想使用codeigner将所有数据从Employee->users表导入到customer->cust_users表。我该怎么做??客户数据库将是主数据库我有一个查询
"Create TABLE mytest AS (SELECT * FROM user)"
我添加了类似->的配置
主数据库这将是主要客户数据库
$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'customer';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;
用户数据库配置第二个Emp数据库
$db['emp']['hostname'] = 'localhost';
$db['Emp']['username'] = 'root';
$db['emp']['password'] = '';
$db['emp']['database'] = 'employee';
$db['emp']['dbdriver'] = 'mysql';
$db['emp']['dbprefix'] = '';
$db['empr']['pconnect'] = TRUE;
$db['emp']['db_debug'] = TRUE;
$db['emp']['cache_on'] = FALSE;
$db['emp']['cachedir'] = '';
$db['emp']['char_set'] = 'utf8';
$db['emp']['dbcollat'] = 'utf8_general_ci';
$db['emp']['swap_pre'] = '';
$db['emp']['autoinit'] = TRUE;
$db['emp']['stricton'] = FALSE;
$this->load->database();
$users_db=$this->load->database('emp', TRUE);
$this->db->query("Create TABLE cust_users AS (SELECT * FROM employee)");
但这在员工数据库中创建了一个表,而不是在客户数据库中。我应该如何在客户数据库中创建表。
您可以通过显式添加指定要创建的数据库:
$this->db->query("CREATE TABLE customer_db.cust_users AS (SELECT * FROM employee)");