return [
'class' => 'yii\db\Connection',
'dsn' => 'mysql:host=localhost;dbname=mydatabase',
'username' => 'root',
'password' => '',
'charset' => 'utf8',
'enableSchemaCache' => true,
];
Yii::$app->db->createCommand()->insert('user', [
'name' => $name,
'email' => $email,
'password' => $password,
])->execute();
Yii::$app->db->createCommand()
->batchInsert('user', ['name', 'email', 'password'], [
[$name1, $email1, $password1],
[$name2, $email2, $password2],
[$name3, $email3, $password3],
])->execute();
通过上述方法,可以较大程度地提高数据保存到MySQL的速度。
上一篇:保存到活动文档路径时名称不正确
下一篇:保存到Raven时出现异常。