At 11:24 AM -0800 2000-02-25, sasha@stripped wrote:
>Glenn Becker wrote:
>>
>> Hi,
>>
>> I am working my way through the book PHP3: Programming Browser-Based
>> Applications by David Medinets. Most of the book has to do with MySQL
> <-->
>> PHP interactions ... I am new to both.
>>
>> I've got MySQL 3.22.32 installed on a P120/48MB running Slackware Linux
>> 7.0. I crawled through the first 25+ pages of the book, getting everything
>> installed correctly ...
>>
>> ... and now that I am beginning to work with MySQL, I am running into
>> new problems. Specifically, I am using the following SQL:
>>
>> INSERT INTO
>> user
>> (
>> Host
>> .User
>> .Password
>> .Select_priv
>> .Insert_priv
>> .Update_priv
>> .Delete_priv
>> )
>> VALUES (
>> '%'
>> ,'kris'
>> ,''
>> ,'Y','Y','Y','Y'
>> )
>>
>> to modify the user table of the mysql database. This is copied directly
>> from the book (there is some indenting in the book example, however). When
>> I send it into MySQL, I get an "Error 1064" ... an error in MySQL syntax.
>>
>> What is wrong with this? How do I find out what's wrong with it? I
>> apologize for the newbieness of the questions - I didn't know where to go
>> in the documentation to find an answer, or how to use MySQL itself
>> to troubleshoot. Thanks in advance for any pointers to what I *might* be
>> doing wrong.
>>
>> Glenn
>>
>> _________________________________________________________________________
>> |
>> // G l e n n B e c k e r |
>> |
>> // "I've chewed and swallowed my pride, and don't want seconds. Thanks." |
>> |
>> // glenn@stripped |
>
>Looks like the book publisher did a bad job on the printing.
>(host.user.password... needs to be (host,user,password,...
>
>--
>Sasha Pachev
The book has quite a number of typographical errors, but this isn't
one of them. The book has commas in the example.
--
Paul DuBois, paul@stripped