HOME
MYSQL
MYSQL
Introduction
MYSQL
Table Create
MYSQL
Retrive
MYSQL Insert
MYSQL Delete
MYSQL Update
MYSQL Sort
|
MYSQL Delete
To delete (remove) data from a table, the delete statement is used. Delete can be used in two ways.
To delete specific rows forma a table
To delete all rows from table
The following statement delete is a single row from the student table
DELETER FROM students where id=’100’;
THIS STATEMENT IS SELF EXPLANTORY. Delete form requires that you specify the name of the table form which the data is to be deleted. The WHERE Clause filters which rows are to be deleted. In this example only student whose id is 100 will be deleted. If the WHERE clause were omitted, this statement would be deleted every customer in the table.
Delete takes no columns names or wildcard characters. Delete deletes entire rows not columns
What is SQL?
SQL is an abbreviation for Structured Query Language. SQL is a language designed mainly for communicating with databases. SQL is easy to learn. The statements are all made up of descriptive English word. SQL is designed to do only one work that is communicating with database in a simple and efficient way.
|
|
|