Page 1 of 1

Database Quaries Bein Stupid

Posted: Sun Mar 16, 2003 5:42 am
by +buG
Herro, this is my my first post here. I decided after looking thru some of the threads that this place would be the best place to submit my question :)

I'm running phpMyAdmin 2.2.0 off my server. I don't know whether it's the prehistoric version of phpMyadmin or what but when I go to add somthing like this:

Code: Select all

ALTER TABLE `forum` ADD `minviewposts` SMALLINT(5) DEFAULT '0' NOT NULL
I get this in return:

Code: Select all

You have an error in your SQL syntax near '''0'' NOT NULL' at line 1

I tried the same line on a different phpMyAdmin on my other server and it worked..

For some reason, a \ appears after every ' Anybody know how to fix this?

Re: Database Quaries Bein Stupid

Posted: Tue Mar 18, 2003 4:27 pm
by craigh
try this:

Code: Select all

ALTER TABLE forum ADD minviewposts SMALLINT(5) DEFAULT 0 NOT NULL
you don't need the quotes to make it work I don't think.