SQL Basic Queries

Basically FOUR SQL commands used very often. These four commands are SELECT, INSERT, UPDATE, DELETE
By using these four basic commands you can do a lot of queries.

SELECT
select * from tablename
INSERT
insert into tablename SET col1=”, col2=”
UPDATE
update tablename SET col1=”, col2=” WHERE col3=”
DELETE
delete from tablename WHERE col1=”

Leave a Comment