SQL DELETE Statement
In this tutorial we know about the SQL DELETE statement, first talking on delete query, must read Introduction to SQL For Beginners and also know what is SQL Syntax. Also know about the SELECT Statement. We learnt Select, Insert, Update statement till now, now the time to learn DELETE query in SQL database. We can perform all this query on table.
As we know INSERT INTO statement for insert records or save data in database. After save records if we need to changes records then we use SQL UPDATE STATEMENT. UPDATE statement update the tables records . Table contains rows and columns for save records. DELETE STATEMENT is used for delete records from database.
SQL SELECT DISTINCT statement used for fetch different records. Select statement is also used with where clause and order by statement for conditional and sort the data result set. SQL stands for Structure query language in Relational Database Management System (RDBMS). SQL Syntax is the format in which data save, update, insert with the SQL commands.
What is SQL DELETE statement?
First of all we discuss about database, A database contain table objects, there are many tables or one table in the database. Tables contains data in the form of records in the format of rows and also contains fields called columns. SQL INSERT INTO statement is always used for insert the records in database’s table object. Records is stored in table by rows and columns. New records insert in table with the insert query. When we need to changes records or data in database then use UPDATE STATEMENT. We can change one and many fields by the Update query.
DELETE STATEMENT is used for delete records in database. Delete query is used with WHERE statement for delete existing records in database. SQL DELETE STATEMENT syntax is given below.
SQL DELETE statement Syntax:
DELETE FROM table_name WHERE condition;
In this syntax of SQL Delete query, we use table_name as our actual table name and delete data from columns with values w.r.t column. Data always depend on the type of column we used in our table structure. Mainly we use delete statement for delete records, delete particular fields with WHERE SQL statement.
You Must Read Also: