MySQL Query for Crud function in any Programming Languages

 Accessing MySQL database requires a basic knowledge in Queries. SELECT, INSERT, DELETE, and UPDATE are the most common queries used in most of the application today.

Load Records

SELECT * FROM tablename

Insert Records

INSERT INTO tablename (name,address,contact) VALUES('Marjohn','Mati City','0909')

Update Records

UPDATE tablename SET 
name='Bebeloni',
address='Bobon',
contact='0965' 
WHERE id='1'

Delete Records

DELETE FROM tablename 
WHERE id='1'

The above list of queries are the basic usage in MySQl. If you want to learn advance Queries, you can visit on MySQL official.