MYSQL Basic Queries

Increase your technical knowledge through our FSH Infotech Blog section.

We add various blog categories that is related to IT technologies.

You can find more blogs added by our administrator by using the below link. Click here for more blogs

MYSQL Basic Queries
Here are some of the important and MYSQL Basic Queries to insert, select, update and delete records from the database.

INSERT :
Insert is used to insert records in database table
Query : INSERT INTO tablename (col1,col2) VALUES ('val1','val2');

SELECT :
Select is used to select the records from the database table
Query:  SELECT * FROM tablename;

UPDATE :
The update is used to update the table records
Query: UPDATE tablename SET col1=val1 WHERE col2=val2;

DELETE :
Delete is used to delete the table record from a database
Query: DELETE FROM tablename WHERE col=somevalue;