Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > body text

MYSQL删除表中的指定ID数据

WBOY
Release： 2016-06-07 17:55:17
Original
1390 people have browsed it

有些时候我们需要删除表中指定ID数据，主要是接下模糊删除，需要的朋友可以参考下

删除A表中的ID 中的开头以B* 的数据库。
代码如下:
delete FROM A WHERE id like 'B%'

单独删除 A 表中的ID B
代码如下:
delete FROM A WHERE id = 'B'
Related labels：
MYSQL删除数据
source：php.cn
Previous article：mysql load data infile 的用法(40w数据 用了3-5秒导进mysql) Next article：mysql中explain用法详解
Statement of this Website
The 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
Latest Articles by Author
Latest Issues
How to group and count in MySQL? I'm trying to write a query that extracts the total number of undeleted messages sent to f...
From 2024-04-06 18:30:17
0
1
353
MySQL gets data from multiple tables I have a eg_design table which contains the following columns: and eg_domains table which ...
From 2024-04-06 18:42:44
0
2
479
Group MySQL results by ID for looping over I have a table with flight data in mysql. I'm writing a php code that will group and displ...
From 2024-04-06 17:27:56
0
1
406
MySqlConnector: MySqlBulkLoader class. Upload empty data from csv to MySQL table From MySqlConnector.MySQLBulkLoader class I want to convert csv to MySQL table keeping nul...
From 2024-04-06 14:35:18
0
1
527
Possibility to store ASP Classic code as string in MYSQL database Is it possible to store asp classic code into a MySQL database and have it execute the cod...
From 2024-04-06 13:38:43
0
1
358
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template