Delete Gold

07/16/2013 09:57 TRTeta#1
I know I'm asking a lot of questions. How can i delete character gold from character table ?

I'm trying to like this :
Quote:
USE [telecaster]
GO

UPDATE [dbo].[Character]
SET [gold] = '0'
WHERE gold< 0
GO
But says 0 rows affected. How should I write code ?
07/16/2013 10:22 Ne0@NCarbon#2
set gold=0 where gold<0 lolll maybe where gold>0 don't you think ?
take care, this will set gold=0 to all character in dbo.character
07/16/2013 10:25 TRTeta#3
I've tried it. It did not.
07/16/2013 10:30 Ne0@NCarbon#4
Code:
USE [telecaster]
GO

UPDATE [dbo].[Character]
SET [gold] = '0'
WHERE [gold] > 0
GO
07/16/2013 10:32 TRTeta#5
work, thx bro

can you add me on facebook , and how can i fix guild icon , you tell me
07/16/2013 12:11 c1ph3r#6
Could you please start to use the helpthread for questions like that. Creating a new thread for every of your question will mess up the forum.

The helpthread was created for people like you...
07/16/2013 15:29 Trustly#7
[Only registered and activated users can see links. Click Here To Register...]

al oç al
07/16/2013 21:56 Xijezu#8
Quote:
Originally Posted by c1ph3r View Post
Could you please start to use the helpthread for questions like that. Creating a new thread for every of your question will mess up the forum.

The helpthread was created for people like you...
^this
[Only registered and activated users can see links. Click Here To Register...]
#closed