Overclock.net banner

1 - 6 of 6 Posts

·
:)
Joined
·
854 Posts
Discussion Starter #1
hey guys, need a quick fix to a problem im having with a computing assessment.
iv got to have a look at a simple database and correct any errors that i find.

iv found a record that is an pointless entry and wish to delete it.
but when i select it and try to delete it, it wont let me.
it has a * at the start of the record, what does that mean?!


any help would be great!
cat.
LL
 

·
:)
Joined
·
854 Posts
Discussion Starter #3
ok, but how do i delete the £0.00 in the price column?
 

·
Premium Member
Joined
·
65,162 Posts
Like Linskindom said.... It's not a record. It's just a new line with default values filled in.

If you do "select count(*) from Widgets", you should get 6.
 
  • Rep+
Reactions: catalyst

·
:)
Joined
·
854 Posts
Discussion Starter #6
ah right i get it. thanks a lot guys.
rep+
 
1 - 6 of 6 Posts
Top