Database Quaries Bein Stupid

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
+buG
Forum Newbie
Posts: 1
Joined: Sun Mar 16, 2003 5:42 am
Location: Phoenix, AZ

Database Quaries Bein Stupid

Post 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?
craigh
Forum Newbie
Posts: 19
Joined: Sun May 19, 2002 2:50 pm

Re: Database Quaries Bein Stupid

Post 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.
Post Reply