OMG,
Very sorry for my stupidness
I new it would be something stupid, it was cut and pasted from a website so I
dont have
to take all the blame as it should have just worked, aye...............aye?
lol, thankyou very much
Ben
;-)
> 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]
