Re: why wont this work? - Ben - com.mysql.lists.mysql

5 messages in com.mysql.lists.mysqlRe: why wont this work?

From	Sent On	Attachments
Ben	28 Oct 2005 08:57
Ben	28 Oct 2005 11:01
Ben	28 Oct 2005 11:05
gerald_clark	28 Oct 2005 11:09
sheeri kritzer	28 Oct 2005 11:10

Subject:	Re: why wont this work?
From:	Ben (dads...@ihug.co.nz)
Date:	10/28/2005 11:05:02 AM
List:	com.mysql.lists.mysql

Thankyou sheeri kritzer You win an all expenses paid trip around David Launge :-) hahaha

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',. . .

On 10/28/05, Ben <dads...@ihug.co.nz> 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

:')