View Categories

MySQL Delete Data

1 min read

Delete Data From a MySQL Table Using MySQLi and PDO #

MySQL болон PDO ашиглан MySQL хүснэгтээс өгөгдлийг устгах #

The DELETE statement is used to delete records from a table:

DELETE хэллэгийг хүснэгтээс бичлэг устгахад ашигладаг.

DELETE FROM table_name
WHERE some_column = some_value

Notice the WHERE clause in the DELETE syntax: The WHERE clause specifies which record or records that should be deleted. If you omit the WHERE clause, all records will be deleted!

DELETE синтакс дахь WHERE үгэнд анхаарлаа хандуулаарай: WHERE үгэнд аль бичлэг эсвэл бичлэгийг устгахыг зааж өгсөн болно. Хэрэв та WHERE гэсэн үгийг орхисон бол бүх бүртгэл устах болно!

To learn more about SQL, please visit our SQL tutorial.

SQL-ийн талаар илүү ихийг мэдэхийг хүсвэл манай SQL заавраар зочилно уу.

Let’s look at the “MyGuests” table:

“MyGuests” хүснэгтийг харцгаая:

id firstname lastname email reg_date
1 John Doe john@example.com 2014-10-22 14:26:15
2 Mary Moe mary@example.com 2014-10-23 10:22:30
3 Julie Dooley julie@example.com 2014-10-26 10:48:23

The following examples delete the record with id=3 in the “MyGuests” table:

Дараах жишээнүүд нь “MyGuests” хүснэгтийн id = 3 тэмдэглэлийг устгана.

Example Жишээ #

(MySQLi Object-oriented) #

<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "myDB"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } // sql to delete a record $sql = "DELETE FROM MyGuests WHERE id=3"; if ($conn->query($sql) === TRUE) { echo "Record deleted successfully"; } else { echo "Error deleting record: " . $conn->error; } $conn->close(); ?>

Example (MySQLi Procedural) #

<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "myDB"; // Create connection $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } // sql to delete a record $sql = "DELETE FROM MyGuests WHERE id=3"; if (mysqli_query($conn, $sql)) { echo "Record deleted successfully"; } else { echo "Error deleting record: " . mysqli_error($conn); } mysqli_close($conn); ?>

Example (PDO) #

<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "myDBPDO"; try { $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // sql to delete a record $sql = "DELETE FROM MyGuests WHERE id=3"; // use exec() because no results are returned $conn->exec($sql); echo "Record deleted successfully"; } catch(PDOException $e) { echo $sql . "<br>" . $e->getMessage(); } $conn = null; ?>

After the record is deleted, the table will look like this:

Бичлэгийг устгасны дараа хүснэгт дараах байдалтай байна.

id firstname lastname email reg_date
1 John Doe john@example.com 2014-10-22 14:26:15
2 Mary Moe mary@example.com 2014-10-23 10:22:30

Powered by BetterDocs

Leave a Reply