Monday, March 30, 2015

SQL Syntax

select columnnames from tablename where condition;
Eg:
SELECT empid,empname,email,salary FROM employee WHERE empid=1;

insert into tablename(col1,col2...) values(val1,val2,...)
Eg:
INSERT INTO employee(empid,empname,email,salary) VALUES(1,'xxxx','xxx@gmail.com',10000);


delete from tablename where condition;
Eg:
DELETE FROM employee WHERE empid=1;


update employee set empname='cccc' where empid=1;

No comments:

Post a Comment