Delete From [yourtable] Where [yourCondition] 比如: delete from UserList Where Name='Wingsun' delete from UserList Where Name<>'Wingsun' delete from UserList Where Name like 'Wing%'
Query1.SQL.Add('DELETE FROM YOURTABLE WHERE 条件'); Query1.ExecSQL;具体看帮助,注意一定要用ExecSQL,不能用Open或Active。
Query1.SQL.Clear; Query1.SQL.Add('DELETE FROM YOURTABLE WHERE 条件'); Query1.ExecSQL;具体看帮助,注意一定要用ExecSQL,不能用Open或Active。
比如:
delete from UserList Where Name='Wingsun'
delete from UserList Where Name<>'Wingsun'
delete from UserList Where Name like 'Wing%'
Query1.ExecSQL;具体看帮助,注意一定要用ExecSQL,不能用Open或Active。
Query1.SQL.Add('DELETE FROM YOURTABLE WHERE 条件');
Query1.ExecSQL;具体看帮助,注意一定要用ExecSQL,不能用Open或Active。