TrulyUnusualdotcom wrote:
> First off I am an extreme newbie and I'm following a book to do this. This
> is what to book calls for and I have searched all over for the proper syntax
> if this is incorrect with no luck.
>
> I'm using PHPMyAdmin to create this field in the pet table.
> ALTER TABLE `pet` ADD `price` DECIMAL( 9.2 ) NOT NULL
>
> I'm using MySQL 4.0.25 and phpMyAdmin 2.6.4-pl2
> I'm also using PHP 5 if that matters.
>
> here is what I get.
>
> SQL query:
> ALTER TABLE `pet` ADD `price` DECIMAL( 9.2 ) NOT NULL
> MySQL said:
> #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
> '9.2) NOT NULL' at line 1
>
> Just looking for the reasoning behind the error and what I'm missing. Maybe
> a good reference for minor syntax items like this would be good. I had a
> hell of a time finding anything related at phpmyadmin or php sites.
>
> Thanks in advance.
> Jaks
>
>
Jaks,
That should be (9,2) not (9.2). Comma separator instead of decimal point.
It's hard to tell the difference in the manual.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================