[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

sql help



hiya.  can anyone assist me in finding out what's wrong with the ff:

mysql -uroot -e"insert into user(Host,User,Password)
values('localhost','guestbook',password('guestbook')" mysql


that's what i type from the bash prompt and it gives me a syntax error
and the following error message:

ERROR 1064 at line 1; You have an error in your SQL syntax near
'user(Host,User,Password)
values('localhost','guestbook',password('guestbook')' at line 1


i'm still new to sql and i can't seem to find how to go about
troubleshooting this.


cheers,

-- 


--------------------------------------------------------------------
Key fingerprint = 9DE1 5825 77B4 FF45 7485  D3EB DCCF DE48 09B6 4426
--------------------------------------------------------------------

"Who's watching the watchmen?"

Attachment: pgpHzrjldl2vc.pgp
Description: PGP signature


Reply to: