Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

I want to delete particular row data in my table

samymssamyms Member Posts: 5
[b][red]This message was edited by samyms at 2006-2-28 2:38:51[/red][/b][hr]
I want to delete particular row data in my table


Comments

  • infidelinfidel Member Posts: 2,900
    : I want to delete particular row in my table

    use a DELETE statement.


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

    [code]
    $ select * from users where clue > 0
    no rows returned
    [/code]

  • tanveer haidertanveer haider Member Posts: 37
    To delete a particular row you should have a unique identifier for this row,like primary key or any unique attribute.

    delete from table-name
    where pk(column name)=123;

    only row having pk=123 will delete

Sign In or Register to comment.