Скачать или смотреть 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 :-
   • Видео  

►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