Thankyou sheeri kritzer
You win an all expenses paid trip around David Launge :-)
hahaha
cheers
Ben
> 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]
