Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 2)
2.
The command to remove rows from a table 'CUSTOMER' is:
Discussion:
29 comments Page 3 of 3.
Hitendra Dineshbhai Pansuriya said:
1 decade ago
Delete is used to delete row and drop is used delete whole table.
Hitendra Dineshbhai Pansuriya said:
1 decade ago
After is used to change data in row and update is used to change structure of table like add and drop of column and index's.
Vijju said:
1 decade ago
How can we delete null values or a row from a table?
Harsha said:
10 years ago
This statement is used to delete records in a table.
By using where statement we can specify which regard to be deleted. Or else whole will be deleted.
By using where statement we can specify which regard to be deleted. Or else whole will be deleted.
Harsha said:
10 years ago
DELETE FROM <Table_Name> WHERE <Col_Name> IS NULL;
Mounika Pallapu said:
10 years ago
DELETE is used for delete one or more than one records but not table.
(1)
Kanimozhi said:
9 years ago
To remove rows from table: DELETE FROM "table_name" where "condition";.
(1)
Rithy said:
9 years ago
What is the difference between truncate and delete command? Because both commands are used to delete rows in a table. Which one is preferable?
Thanks in advance!
Thanks in advance!
(1)
Shik said:
7 years ago
Truncate -- if we truncate a table, the structure of the table remains same and the data inside the table will be deleted.
BUT IN, Delete --- whole table or particular row is deleted. Here the structure of the table is also deleted.
BUT IN, Delete --- whole table or particular row is deleted. Here the structure of the table is also deleted.
(2)
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers