×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

SQL to Create a table

0
0
 
0
Language: PHP
Posted by: Lee Laing
Added: Apr 5, 2018 10:57 AM
Modified: Apr 9, 2018 5:56 AM
Views: 2954
Tags: no tags
  1. // sql to create table
  2. // Make sure you are connected to the intended DB
  3. $sql = "CREATE TABLE EnterTableNameHere (
  4. id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  5. firstname VARCHAR(30) NOT NULL,
  6. lastname VARCHAR(30) NOT NULL,
  7. email VARCHAR(50),
  8. reg_date TIMESTAMP
  9. )";

Write a comment

To post comments, please log in or register.