Using CREATE DATABASE
xxxxxxxxxx
CREATE DATABASE dbname;
xxxxxxxxxx
CREATE TABLE example (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(50) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);
xxxxxxxxxx
Creates a new database.
Example: Creates a new database named ‘websitesetup’.
CREATE DATABASE websitesetup;
xxxxxxxxxx
use Illuminate\Support\Facades\DB;
// Connection name = `mysql` for me, adjust as suits for you
DB::connection('mysql')->statement("CREATE DATABASE ?", [$this->database]);
// Simply written
DB::connection('mysql')->statement("CREATE DATABASE my_new_db");