Basically DELETE TABLE is logged operation and every row deleted is logged. Therefore the process is usually slow. TRUNCATE TABLE also deletes rows in a table but it will not log any of the rows deleted.
The process is faster in comparison.
TRUNCATE TABLE can be rolled back and is functionally similar to the DELETE statement using no WHERE clause.
What is CodeIgniter 4? CodeIgniter 4 is an Web Application development framework. We can develop projects much faster as well as... read more
include(): Using this method we can include an external file into the current file. If the specified file is not... read more
Implode(): Using this method we can convert an array into string example <?php $array = array('lastname', 'email', 'phone'); $comma_separated = implode(",", $array);echo $comma_separated; // lastname,email,phone ?> explode(): Using this method we can convert... read more
isset(): using this method we can check whether the variable is set with value or not. If variable is set... read more
array_search(): Using this method we can search for an element in an array. If element founds, this method will... read more
A Query String is a combination of key and values pairs of data, which is always appended in URL followed... read more
An array is a collection of values with different data types An array can be created using the array() language construct.... read more
SELECT MAX(salary) AS salary FROM emp WHERE salary < (SELECT MAX(salary) FROM emp); read more