MySQL CREATE DATABASE commands and statements

MySQL tutorial Creating a database Tutorial commands and statements

Creating a Database
The CREATE DATABASE statement is used for creating databases in MySQL.

Grammar
CREATE DATABASE database_name In order for the PHP tutorial to execute the above statement, we must use the mysql_query () function. This function is used to send a query or command to a MySQL connection.

Method One, use cmd form to create a database

c:program Filesphps Tutorial Tudymysqlbin>mysql-u root-p
Enter Password: * * *

Enter database username and password

Welcome to the MySQL Monitor. Commands end with; or G.
Your MySQL connection ID is 235
Server version:5.0.51b-community-nt MySQL Community Edition (GPL)

Type ' help, ' or ' h ' for help. Type ' C ' to clear the buffer.

mysql> CREATE DATABASE Exdb; Create DATABASE Exdb Successful
Query OK, 1 row affected (0.00 sec)

Mysql>

Method Two, creating a database in a PHP program

?
$CN = mysql_connect (' localhost ', ' root ', ' root ') or Die (' MySQL connect fail ');
if (mysql_query ("CREATE Database Exdb", $CN))
{
echo "Database created";
}
Else
{
echo "Error creating database:". Mysql_error ();
}
?>