[DotNetDevelopment] Re: Unable to delete bad data from table

2009-02-16 Thread Raghupathi Kamuni
Use SQL On Mon, Feb 16, 2009 at 9:54 PM, Jon Liu wrote: > Hey, > > I'm deleting mannually through studio...so i do "show table data" and then > select the rows I try to delete. I have tried setting the primary key as > well and it doesn't have any affect on the current scenario... > > Thanks >

[DotNetDevelopment] Re: Unable to delete bad data from table

2009-02-16 Thread Jon Liu
Hey, I'm deleting mannually through studio...so i do "show table data" and then select the rows I try to delete. I have tried setting the primary key as well and it doesn't have any affect on the current scenario... Thanks Jon On Mon, Feb 16, 2009 at 8:20 AM, sallushan wrote: > > Then Simply

[DotNetDevelopment] Re: Unable to delete bad data from table

2009-02-16 Thread sallushan
Then Simply add one. I think: The row you are deleting should be identified uniquely. Which means if any other row exists in the table which contains the same data (i.e. you cannot distinguish the 2 rows) then delete operation may NOT occur. By the way how and from where you are trying to delete

[DotNetDevelopment] Re: Unable to delete bad data from table

2009-02-16 Thread Jon Liu
There was, but when I had a problem inserting because the primaries were all the same( i know..) so I unmarked the primary. So to answer your question, no there is no longer a primary key... On Sun, Feb 15, 2009 at 10:17 PM, Arsalan Tamiz wrote: > Is there any primary key in the Table? > > > On

[DotNetDevelopment] Re: Unable to delete bad data from table

2009-02-15 Thread Arsalan Tamiz
Is there any primary key in the Table? On Sun, Feb 15, 2009 at 11:55 PM, BigJ wrote: > > I nserted some bad data into my table and want to remove it...when I > try to delete the bad data this is the prompt that I recieve: > > Deleting data from existing tables: > No rows were deleted > > A probl