Mysql database creation commands and statements

Create database database_name to allow PHP to execute the preceding statement, we must use the mysql_query () function. This function is used to send queries or commands to MySQL connections.

Mysql tutorial create database tutorial commands and statements

Create a database
The create database statement is used to create a database in mysql.

Syntax
Create database database_name to allow the php tutorial to execute the preceding statement, we must use the mysql_query () function. This function is used to send queries or commands to mysql connections.

Method 1: Use cmd to create a database

C: program filesphps tutorial tudymysqlbin> mysql-u root-p
Enter password :****

// Enter the database user name 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; // The database exdb is created successfully.
Query OK, 1 row affected (0.00 sec)

Mysql>

Method 2: Create a database in the 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 ();
}
?>