PHP Prepared Statements
Creates a users table with column names "userId", "firstName", "lastName", "email" and "registeredOn"Basic
<?php
CREATE TABLE users (
userId INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstName VARCHAR(30) NOT NULL,
lastName VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)
?>