Hi,
You can use following query,
CREATE TABLE employee_data
(
emp_id int NOT NULL AUTO_INCREMENT,
f_name varchar(30),
l_name varchar(20),
age int,
salary int,
PRIMARY KEY (emp_id)
)
ALTER TABLE employee_data AUTO_INCREMENT=1;
Insert query will be
INSERT INTO Persons (f_name,l_name,age,salary) VALUES ('Brian','lara',25,5000)
Also you can check last inserted id by
mysql_insert_id()
Hope this will help.