CRUD operation means create read update delete operation in a table.
1) Create operation
In this, we can create a table by the same method which we discuss above to create table.
2) Read operation
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 ;
3) Update Operation
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;
4) Delete Operation
The delete statement is used to delete existing records in a table.
- Delete an existing record
This is used to delete an existing record from a table.
Delete from table_name where column_name = data ;
- Detele all data from a table This is used to delete the entire data from a table.
Delete from table_name ;
drop table table_name;