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;
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