CODE EXAMPLE FOR PHP

sql create table with data

#create a table
CREATE TABLE employees( id INT NOT NULL AUTO_INCREMENT, 
                       first_name VARCHAR(30) NOT NULL,
                       last_name VARCHAR(30) NOT NULL, 
                       middle_name VARCHAR(30), 
                       age INTEGER NOT NULL,
                       current_status VARCHAR(100) NOT NULL DEFAULT 'employed',
                       PRIMARY KEY(id)
                      );
#fill the table with data
INSERT INTO employees (first_name, last_name, middle_name, age, current_status)
VALUES ('testname','testlastname','testmiddlename', 23, 'Searching');
#view all the data inside the table
SELECT * FROM employees;