Insert,Update and Delete Query In MySql





SUMMARY 


INSERT ,UPDATE and DELETE Query in MySQL | In this tutorial we will learn how to insert value in MySQL using insert query,update value in MySQL using update query,delete row in MySQL using delete query.

CONCEPT OF INSERT QUERY

Insert query in mySql is very important staff for an administrator in an organization when a employee join an organization his or her record has to be maintained by an organization or a student got admission to school his or her has to be maintained in that place insert query is required.

CONCEPT OF UPDATE QUERY

Update query in MySQL is also very important for a database admin when an employee promoted then as per his designation record should be updated. In that place update query is required. To update record into mysql table we use “update” command.

CONCEPT OF DELETE QUERY

Delete query is also very important for a database admin when an employee leave the organization or a student leave from school ,in that case delete query is required. To delete record from the mysql table using delete query we use”DELETE FROM”command

SUMMARISED CONCEPT

To insert value into mysql table we use “insert into” command. To update value into mysql table we use “update” command. To delete value into mysql table we use “delete” command.

CONCLUSION

In this tutorial we have learned how to insert value in MySQL using insert query,update value in MySQL using update query,delete row in MySQL using delete query.
For more details please visit our website : techrideradmin.blogspot.com