Home  >  Article  >  Database  >  MYSQL删除表中的指定ID数据_MySQL

MYSQL删除表中的指定ID数据_MySQL

WBOY
WBOYOriginal
2016-06-01 13:23:401290browse

bitsCN.com 删除A表中的ID 中的开头以B* 的数据库。

delete FROM A WHERE id like 'B%'

单独删除 A 表中的ID B

delete FROM A WHERE id = 'B'
bitsCN.com

Statement:
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