PHP MySQL creates database and table examples

if (mysql_query("CREATE D ATABASE my_db", $con))

{ bbs.it-home.org

echo "Database created";

}

else

{

e cho "Error creating database : " . mysql_error();

}

mysql_close($con);

?>

2, create table CREATE TABLE is used to create a database table in MySQL.

Grammar CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, column_name3 data_type, ....... ) In order to execute this command, I have to add a CREATE TABLE statement to the mysql_query() function.

Example, create a table named "Persons" with three columns. The column names are "FirstName", "LastName" and "Age":

Note: When you create a database field of varchar type, you must specify the maximum length of the field, for example: varchar(15).

$sql = "CREATE TABLE Persons