4. How to create database table using PHPMyAdmin?

Steps
1. On your web browser, please type http://localhost/phpmyadmin/
2. Select SQL tab
3. Please type these scripts:
CREATE DATABASE bizjobfinder_db;
USE bizjobfinder_db;
CREATE TABLE jobseekers
(
id int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
firstname varchar(50),
mi varchar(2),
lastname varchar(50),
street_barangay varchar(50),
town_city varchar(50),
province varchar(50)
)
4. Please click Go button (at the lower right) to execute the script
5. Please check at the left side of the phpmyadmin, there should be somewhat like this:
bizjobfinder_db(1)

Previous | Next