Creating multiple databases in a single query string

Question

Is there a way to create multiple databases in a single query string?

Something like that:

$sql="CREATE DATABASE `db1` AND/,/./etc `db2` AND/,/./etc `db3`"; $mysql_query=($sql,$con); 

Answer 1

Other options: create an SQL file, for example:

/*myFile.sql*/ CREATE DATABASE db1; CREATE DATABASE db2;

Then run:

mysql -u user -p < myFile.sql

If you absolutely need to have it on one console, you can do:

mysql -u user -p -e "CREATE DATABASE db3; CREATE DATABASE db4; ..."

Answer 2

I'm not sure, but it should only work with a semicolon separated; You may try

 mysqli_multi_query 

but you must be connected to the database using mysqli_connect, not mysql_connect :(