MariaDB Tutorial
MariaDB Useful Resources
Selected Reading
- MariaDB - Useful Functions
- MariaDB - Backup Loading Methods
- MariaDB - Backup Methods
- MariaDB - SQL Injection Protection
- MariaDB - Managing Duplicates
- MariaDB - Sequences
- MariaDB - Table Cloning
- MariaDB - Temporary Tables
- Indexes & Statistics Tables
- MariaDB - Alter Command
- MariaDB - Transactions
- MariaDB - Regular Expression
- MariaDB - Null Values
- MariaDB - Join
- MariaDB - Order By Clause
- MariaDB - Like Clause
- MariaDB - Delete Query
- MariaDB - Update Query
- MariaDB - Where Clause
- MariaDB - Select Query
- MariaDB - Insert Query
- MariaDB - Drop Tables
- MariaDB - Create Tables
- MariaDB - Data Types
- MariaDB - Select Database
- MariaDB - Drop Database
- MariaDB - Create Database
- MariaDB - Connection
- MariaDB - PHP Syntax
- MariaDB - Administration
- MariaDB - Installation
- MariaDB - Introduction
- MariaDB - Home
MariaDB Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
MariaDB - Drop Tables
MariaDB - Drop Tables
In this chapter, we will learn to delete tables.
Table deletion is very easy, but remember all deleted tables are irrecoverable. The general syntax for table deletion is as follows −
DROP TABLE table_name ;
Two options exist for performing a table drop: use the command prompt or a PHP script.
The Command Prompt
At the command prompt, simply use the DROP TABLE SQL command −
root@host# mysql -u root -p Enter password:******* mysql> use PRODUCTS; Database changed mysql> DROP TABLE products_tbl mysql> SELECT * from products_tbl ERROR 1146 (42S02): Table products_tbl doesn t exist
PHP Drop Table Script
PHP provides mysql_query() for dropping tables. Simply pass its second argument the appropriate SQL command −
<html>
<head>
<title>Create a MariaDB Table</title>
</head>
<body>
<?php
$dbhost = localhost:3036 ;
$dbuser = root ;
$dbpass = rootpassword ;
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn ) {
die( Could not connect: . mysql_error());
}
echo Connected successfully<br /> ;
$sql = "DROP TABLE products_tbl";
mysql_select_db( PRODUCTS );
$retval = mysql_query( $sql, $conn );
if(! $retval ) {
die( Could not delete table: . mysql_error());
}
echo "Table deleted successfully
";
mysql_close($conn);
?>
</body>
</html>
On successful table deletion, you will see the following output −
mysql> Table deleted successfullyAdvertisements