Truncate delete and drop in mysql on one click Truncate, Delete

Description

Truncate delete and drop in mysql Truncate, Delete and Drop in a database SQL, Oracle and MySQL Drop will delete a table from the database. Drop difference between delete and truncate in sql server difference between drop and truncate in sql truncate vs delete mysql delete vs truncate

Difference between TRUNCATE, DELETE and DROP ...

Truncate removes all the rows from a table on one click

<?php

 

if(isset($_POST['delete'])){

$query = "TRUNCATE TABLE `student` "; // replace yourTable with one to delete

$result = mysql_query($query)

or die('Error deleting table.');

 

$list = "Empty Table";

 

}

else {

//echo "Sorry";

}

 

?>

 

 <form method="post" action="adminstudentcsvfileupdate.php">

<input type="submit" id='delete' class='delete' name="delete" value='Totel Data Delete (Empaty)' style="color:#FFFFFF; background-color:#FF0000"></input>

</form>