A database table has its name and contains columns and rows. create a contact_us table that has the id, email, subject and message fields.
CREATE TABLE `contact_us` ( `id` int(11) AUTO_INCREMENT PRIMARY KEY, `name` varchar(150) NOT NULL, `email` varchar(150) NOT NULL, `subject` varchar(200) NOT NULL, `msg` text NOT NULL );
NOT NULL: the individual row must contain a value
AUTOINCREMENT: MySQL automatically increases the value of the field by 1 whenever new data is stored.
PRIMARY KEY: unique identification and is generally used with AUTO_INCREMENT
Loading, please wait...