Deleting ALL Records of Table in MySQL | TRUNCATE TABLE Delete All Entries | Deleting Databases
Deleting ALL Records of Table in MySQL | TRUNCATE TABLE Delete All Entries | Deleting Databases.
In This Tutorial You Will Learn How TO TRUNCATE TABLE with Examples .When you want to delete all data from a table, you use the DELETE statement without the WHERE clause as follows:
DELETE FROM table_name;
For a table with a small number of rows, the DELETE statement does a good job. However, when you have a table with a large number of rows, using the DELETE statement to remove all data is not efficient.
Oracle introduced the TRUNCATE TABLE statement that allows you to delete all rows from a big table.
The following illustrates the syntax of the Oracle TRUNCATE TABLE statement:
TRUNCATE TABLE schema_name.table_name
[CASCADE]
[[ PRESERVE | PURGE] MATERIALIZED VIEW LOG ]]
[[ DROP | REUSE]] STORAGE ]
Chapters:-
00:00-Introduction
00:29-Steps to give TRUNCATE Command in MySQL
01:07-Purpose of TRUNCATE Command in MySQL
stay tune and watch full video .
Don't forget to like ,subscribe to our youtube channel . press the bellicon🔔 so you never miss any update from v2v class .
►Save this playlist and complete Full Course of MySQL :-
• Video
►Click here to subscribe :-
/ @v2vedtechllp
Follow us On Social Media :-
►Website of v2v classes - https://v2vclass.com
►Facebook - / v2vclass
►Instagram - / v2vclass
#v2v #v2vclass #mysql #MySQltutorial