Yes, you need to add a second close parenthesis at the end -- you
close the parenthesis for password('guestbook') but not for the
values('localhost',. . .
-Sheeri
On 10/28/05, Ben <[EMAIL PROTECTED]> wrote:
> hey,
> Could you tell me someone please why this simple setup wont work!
> I am using SuSE9.3 and trying to set this up:
>
> $ mysql -uroot -e"insert into user(Host,User,Password)
> values('localhost','guestbook',password('guestbook')" mysql -p
>
> this is the error:
>
> $ ERROR 1064 (42000) at line 1: 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 '' at line 1
>
> could someone please shed some light on this, Maybe the answer is so obvious I
> cant see it?
>
> Thankyou very much
>
> Ben
> :')
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
