• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 191
  • Last Modified:

SQL Delete Syntax

I have a column in a MySql table xyz called sys_Id .

How do I remove all records where the sys_Id is 0?  Please provide actualy SQL syntax.
0
pda4me
Asked:
pda4me
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
delete from xyz where sys_id = 0
0
 
pda4meAuthor Commented:
Thanks!
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now