CRUD operation means create read update delete operation in a table.
In this, we can create a table by the same method which we discuss above to create table.
In this we can read data inserted in a table .this process is the same as the select statement.
For read Where clause
The where clause is used to filter records. It means that suppose we need to search all details or single detail from the table then we use this respectively.
select * from table_name;
Select * from table_name where column_name = details need to search from selected column ;
The update statement use to modify the existing record in a table.
updated table_name set coloumn_name = new_data where coloumn_name= old_data;
The delete statement is used to delete existing records in a table.
This is used to delete an existing record from a table.
Delete from table_name where column_name = data ;
Delete from table_name ;
drop table table_name;