How to delete a table in the database in mysql
Mysql method to delete tables in the database: 1. Use the "USE database name;" statement to select and enter the database where the table needs to be deleted; 2. Use "DROP TABLE [IF EXISTS]
[ ,
,
…];” statement deletes one or more data tables in the database.
The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.
In the MySQL database, we can delete the data tables from the database that are no longer needed. Let's take a look at how to delete data tables in the MySQL database.
Basic syntax
When you need to delete a table, you can use the DROP TABLE statement to complete it. The syntax format is as follows:
DROP TABLE [IF EXISTS] <表名1> [ , <表名2> , <表名3> …];Copy after loginThe syntax is as follows:
: The name of the deleted table. The DROP TABLE statement can delete multiple tables at the same time, and the user must have permission for this command.
When the table is deleted, all table data and table definitions will be canceled, so be careful when using this statement.
When a table is deleted, the user's permissions on the table will not be automatically deleted.
The parameter IF EXISTS is used to determine whether the deleted table exists before deletion. After adding this parameter, when deleting the table, if the table does not exist, the SQL statement can be executed smoothly. But a warning will be issued.
Note: When deleting a table, the structure of the table and all the data in the table will be deleted. Therefore, it is best to back up the data table before deleting it to avoid irreparable losses. .
Example:
mysql> USE test_db; Database changed mysql> CREATE TABLE tb_emp3 -> ( -> id INT(11), -> name VARCHAR(25), -> deptId INT(11), -> salary FLOAT -> ); Query OK, 0 rows affected (0.27 sec) mysql> SHOW TABLES; +--------------------+ | Tables_in_test_db | +--------------------+ | tb_emp2 | | tb_emp3 | +--------------------+ 2 rows in set (0.00 sec)Copy after loginDelete the data table tb_emp3. The input SQL statement and running results are as follows.
mysql> DROP TABLE tb_emp3; Query OK, 0 rows affected (0.22 sec) mysql> SHOW TABLES; +--------------------+ | Tables_in_test_db | +--------------------+ | tb_emp2 | +--------------------+ 1 rows in set (0.00 sec)Copy after loginThe execution results show that the table named tb_emp3 no longer exists in the data table list of the test_db database, and the deletion operation was successful.
The above is the detailed content of How to delete a table in the database in mysql. For more information, please follow other related articles on the PHP Chinese website!
Statement of this WebsiteThe content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
How to fix KB5055612 fails to install in Windows 10?4 weeks ago By DDDRoblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌Roblox: Grow A Garden - Complete Mutation Guide3 weeks ago By DDDNordhold: Fusion System, Explained4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Java Tutorial1672
14
CakePHP TutorialLaravel TutorialPHP TutorialC# TutorialSee all articlesLaravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.
MySQL and phpMyAdmin are powerful database management tools. 1) MySQL is used to create databases and tables, and to execute DML and SQL queries. 2) phpMyAdmin provides an intuitive interface for database management, table structure management, data operations and user permission management.
Compared with other programming languages, MySQL is mainly used to store and manage data, while other languages such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages have advantages in their respective fields such as data analytics, enterprise applications, and system programming.
Article summary: This article provides detailed step-by-step instructions to guide readers on how to easily install the Laravel framework. Laravel is a powerful PHP framework that speeds up the development process of web applications. This tutorial covers the installation process from system requirements to configuring databases and setting up routing. By following these steps, readers can quickly and efficiently lay a solid foundation for their Laravel project.
In MySQL, the function of foreign keys is to establish the relationship between tables and ensure the consistency and integrity of the data. Foreign keys maintain the effectiveness of data through reference integrity checks and cascading operations. Pay attention to performance optimization and avoid common errors when using them.
The main difference between MySQL and MariaDB is performance, functionality and license: 1. MySQL is developed by Oracle, and MariaDB is its fork. 2. MariaDB may perform better in high load environments. 3.MariaDB provides more storage engines and functions. 4.MySQL adopts a dual license, and MariaDB is completely open source. The existing infrastructure, performance requirements, functional requirements and license costs should be taken into account when choosing.
SQL is a standard language for managing relational databases, while MySQL is a database management system that uses SQL. SQL defines ways to interact with a database, including CRUD operations, while MySQL implements the SQL standard and provides additional features such as stored procedures and triggers.
MySQL and phpMyAdmin can be effectively managed through the following steps: 1. Create and delete database: Just click in phpMyAdmin to complete. 2. Manage tables: You can create tables, modify structures, and add indexes. 3. Data operation: Supports inserting, updating, deleting data and executing SQL queries. 4. Import and export data: Supports SQL, CSV, XML and other formats. 5. Optimization and monitoring: Use the OPTIMIZETABLE command to optimize tables and use query analyzers and monitoring tools to solve performance problems.
