MySQL Database


We create databases to store user data, we create api using php, .net and more her we discuss regarding php based api creations.


Here in the first tutorial we will see the creation of employee table where we will store 

1) Employee ID
2) Employee Name
3) Employee Email ID


Query to create a employee table in database :

CREATE TABLE employee  (id int(10),  name varchar(50),  email varchar(50), PRIMARY KEY (id ));  


Insert into employee table :

Insert into employee values(1,'abhi','abhi@email.com');


Update data in employee table :

Update employee set name='abhishek', email='abhishek@email.com' where id=1; 


Delete data from employee table :

Delete from employee where id=1; 


Read all data from employee table :

Select * from employee; 


Delete / Drop a table :

Drop table employee; 



For real time examples on databases

Refer
http://www.androidcoding.in/?s=database