Create Table statement for (PDO,MYSQLi,MSQL,Mysql)

Create Table Query 

Today i am showing how to add new table in SQL.But in this blog i am attaching php back end language for 

run the query.

following steps are included..

1. open notepad or other text editor .
2. open xampp /wamp 
3. run apache and mysql server
4. than you write connection of database 
5. than you write the following code its and dummy table you can change on your choice                                                                                                                                                                                  
   
   
   
   
   
   
   
   
   
   
   
   
   
   $q= "CREATE TABLE Student ( s_id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, firstname VARCHAR(30) NOT NULL, lastname VARCHAR(30) NOT NULL, email VARCHAR(50), reg_date TIMESTAMP)";
6. Than you required to write 
7. $sql=mysqli_query($q);
8. successfully your table created in your desired database.

if the following blog helpful than write a comment for more blogs.

for further query contact us 

regards

hadiuppal99@gmail.com......