We need you!

We're working hard on the next version of Developer Fusion. Let us know what you think we should be up to!

Members

Technology Zones

Articles

Hosted By

MaximumASP

Info
Rated
Read 172,225 times
5 comments

Contents

Related Categories

SQL Commands - Deleting Records

James Crowley

Deleting Records

To delete a record, not surprisingly, you use the DELETE statement. Its syntax is very simple. All you specify is the table and a condition. For example,

DELETE FROM Users WHERE UserID = 10

would delete all records in the Users table which had a UserID of 10. Likewise,

DELETE FROM Furniture WHERE Price < 10

would delete all records in the Furniture table which had a price of less than 10.

James first started writing tutorials on Visual Basic in 1999 whilst starting this website (then known as VB Web). Since then, the site has grown rapidly, and James has written numerous tutorials, articles and reviews on VB, PHP, ASP and C#. In October 2003, James formed the company Developer Fusion Ltd, which owns this website, and also offers various development services. In his spare time, he's a 3rd year undergraduate studying Computer Science in the UK. He's also a Visual Basic MVP.

Comments

Read Comments | Post Comment

  • Check for Failed SQL Query

    Posted by zible on 24 Jan 2007

    This seems simple, yet I can't find how you do this. I need to run a query in VB on a very simple database. There is the possibility that the query would be unsuccessfull, and if so I need to do ot...

  • Sql Info

    Posted by darshan on 25 Apr 2005

    you need to fire sql statement like this
    select idno, name, email, return from [table_name] where [your_condition]

    this will return record set lets say "rs" is object of recordset
    then you will n...

  • Another database issue

    Posted by Abzmoh2007 on 11 Mar 2004

    Basically am trying to search a database by getting an input from the users selection on a list.
    the list contains names of countries and when i click that search button, how can i get the result of...

  • Filling Table With Datagrid

    Posted by NightChillz on 23 Dec 2003

    hey, i see how i can fill a datagrid with data from an sql table, but i am having trouble figuring out how to do the exact opposite, take data from a datagrid and fill an sql table with it/overriding ...

  • update data

    Posted by tomoko on 26 Nov 2003

    hi,
    pls help as i'm new in asp. i'm developing the administrative part of a website for my project. i'm having trouble with the "updating data" part. for example, i have done the 'add staff' and "de...