如何从数据库中删除a的第一行 [英] How to delete the first row of a from a database

问题描述

Hello Everyone，

请告诉查询删除数据库中的第一行，其中Product_Name =motherboard

Hello Everyone,
Please tell the query to delete the first row from database where Product_Name="motherboard"

推荐答案

delete top （1）从TableName中Product_Name =motherboard

delete top (1) from TableName where Product_Name="motherboard"

你好，



删除它与id相关:(其中id是你的表ID，它应该是自动递增）



其中Product_Name =主板订单由id ASC限制1

Hello,

delete it related to id :(where the id is your table id and it should be auto increment)

where Product_Name="motherboard" order by id ASC limit 1

这篇关于如何从数据库中删除a的第一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！