View Single Post
  #10 (permalink)  
Old June 17th, 2004, 01:05 PM
happygv happygv is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

You haven't used SPACE after TABLENAME "user" and before "(" I believe.

It works perfectly for me.

Code:
INSERT INTO user ( host, user, PASSWORD , select_priv ) 
VALUES ('localhost', 'poll', password( 'polldb' ) , 'Y');
Cheers!

_________________________
-Vijay G
Strive for Perfection
Reply With Quote