how to delete a row from a table which contains only NULL values?

[NithyaJai]

hai,

I'm having table like this,

Example:

Usename userid password
aaaa 1 123
ssss 2 456
null null null

how to delete the last row fully??????????

help me plz.........

[Mahesh83]

hai,

I'm having table like this,

Example:

Usename userid password
aaaa 1 123
ssss 2 456
null null null

how to delete the last row fully??????????

help me plz.........

Hi
What you do is make another column and make it as Primary key and and make that column as auto increment
so in Vb.net you just use that column no. for example
"delete from tablename where newcolumn = column no."
Let check if this helps you.....


Cheers
Mahesh