Object Oriented Style

  $stmt = $maindb->prepare("DELETE FROM some_table WHERE email_address = ? ");
  $stmt->bind_param("s", $MyColumn1 );
  $MyColumn1 = "abc";
  $stmt->execute();
  $stmt->close();

Procedural Style

  mysqli_query($dblink, "DELETE FROM some_table WHERE email_address = '$email'");
Delete old records by date
  mysqli_query($dblink, "DELETE FROM messages_sent WHERE created_date < DATE_SUB(NOW(), INTERVAL 30 DAY)");

  //Also:
  //INTERVAL 1 MONTH
  //INTERVAL 1 HOUR
  //etc
Delete table

Truncate is the fastest method to delete all data in a table as the table is dropped and re-creaed.

  mysqli_query($dblink, "TRUNCATE TABLE all_songs");
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.

Comments

Your email address will not be published. Required fields are marked *