PHP-MySQL Lesson – Create Table

Creating a  Table

In this lesson we are going to write a PHP script that will create a table in our MySQL database.

To create a table in MySQL, use the command CREATE TABLE tablename. In PHP,mysql_query() function is used to execute CREATE TABLE command and other SQL query.

Here is an example script:

<?php
//including the database connection file
include("mysql_connect.php");
// Create table
mysql_select_db("employee", $con);
$sql = "CREATE TABLE Persons
(
id int unsigned not null auto_increment primary key,
f_name varchar(20),
l_name varchar(20),
position varchar(30),
age int,
salary int,
email varchar(60)
)";
// Execute query
mysql_query($sql);
?>

In the above code we have created a employee_record table in our employee database. The table consists of id, l_name, f_name, position, age, salary and email.

Note: Select first the database where you want to create your table. The database is selected with the mysql_select_db() function.

, , , ,

Post navigation

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.