The CREATE DATABASE statement is using to create a database table in MySQL.
The following example creates a database named “my_db”:
CREATE DATABASE
<?php
$con=mysqli_connect(“example.com”,”user01″,”password”);
// Check connection
if (mysqli_connect_errno())
{
echo “Failed to connect to MySQL: ” . mysqli_connect_error();
}
// Create database
$sql=”CREATE DATABASE my_db”;
if (mysqli_query($con,$sql))
{
echo “Database my_db created successfully”;
}
else
{
echo “Error creating database: ” . mysqli_error($con);
}
?>
