how do you set negative integers?

[Kran]

I heard you have to make the integers signed, but I don't know how, in specific I'm trying to make the post count negative. Anyone know how?

[Marco van Herwaarden]

You could try (untested, backup your database first!!!):
ALTER TABLE user CHANGE COLUMN post posts int(10) NOT NULL default 0;

[Kran]

Alright, trying :)

EDIT: I got this :(

An error occurred while attempting to execute your query. The following information was returned.
error number: 1054
error desc: Unknown column 'post' in 'user'

[Marco van Herwaarden]

Oops the first one should have been posts also:
ALTER TABLE user CHANGE COLUMN posts posts int(10) NOT NULL default 0;

[Kran]

trying :)

EDIT: okay, the query worked but when I set my post count to -1 it said post count 0 instead.

[Paul M]

I've got to ask - why do you want negative post counts ?

[Kran]

I've got to ask - why do you want negative post counts ?


Spammers, they don't deserve to be banned, but I don't think 0 is enough of a set back.

[Kran]

bump :)

[Hellcat]

trying :)

EDIT: okay, the query worked but when I set my post count to -1 it said post count 0 instead.
What happens if you set it to.... say "-9"?
Do you still get "0"?

Can you determine of what kind your posts column in the DB is?

I tried this myself a week ago and worked perfectely....

Man, without your bump I would have totally missed this ;)

[Kran]

What happens if you set it to.... say "-9"?
Do you still get "0"?

Can you determine of what kind your posts column in the DB is?

I tried this myself a week ago and worked perfectely....

Man, without your bump I would have totally missed this ;)

same thing if -9...

I can't find the posts column, what's it under?

[Marco van Herwaarden]

Run the following SQL, and copy th eoutput here:
DESCRIBE TABLE user;

[Kran]

Run the following SQL, and copy th eoutput here:
DESCRIBE TABLE user;

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE user' at line 1

[Marco van Herwaarden]

Oops my bad, that was Oracle syntax. Just use:
DESCRIBE user