What are CRUD Operations and how is it used in SQL?

Question

What are CRUD Operations and how is it used in SQL?

Answer 1

CRUD stands for Create, Read, Update, and Delete. In SQL, the CRUD Operations are used in the following way:

• Create: To create a table, the command is ‘CREATE TABLE tablename (column datatype)’
• Read: To read data from a particular table, the command is ‘SELECT * from tablename’
• Update: In order to make changes and update the data available in a table, the command is ‘UPDATE tablename set column1 = new_value where column2 = value’
• Delete: To delete data from a particular column in the table, the command is ‘DELETE from tablename where column=value’

To learn in detail about SQL commands and operations and become a professional in it, watch: