PHP和Mysql多次更新 - allowMultiQueries等效

Question

I have just started working with Laravel and I was wondering if there was an equivalent of the allowMultiQueries connection string parameter that I would use in java.

Is there way to do multiple updates in the same call or do they have to be done in succession?

DB::update('DROP TABLE IF EXISTS tablename; CREATE TABLE tablename(...);');

instead of

DB::update('DROP TABLE IF EXISTS tablename;'); 
DB::update('CREATE TABLE tablename(...);');

Answer 1

You can do it fluently the Laravel way using Schema Builder like so

use Illuminate\Database\Schema\Blueprint;

...

if (Schema::hasTable('tablename')) {
    Schema::drop('tablename');
}
Schema::create('tablename', function(Blueprint $table) {
    $table->increments('id');
    $table->string('name', 64);
    $table->timestamps();
    $table->index('name');
});

But if you for some reason want to execute raw queries you can use unprepared() method in Query Builder

DB::unprepared('DROP TABLE IF EXISTS tablename; CREATE TABLE tablename (id INT ...)');    

but at least make sure you're using the proper syntax

DROP TABLE IF EXISTS tablename
           ^^^^^^^^^

instead of

DROP TABLE tablename IF EXISTS