re: why wont this work?

2005-10-28 Thread Ben 
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 -einsert 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]

Re: why wont this work?

2005-10-28 Thread gerald_clark 

Ben 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 -einsert into user(Host,User,Password) 
values('localhost','guestbook',password('guestbook') mysql -p
 



$  mysql -uroot -einsert 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]

Re: why wont this work?

2005-10-28 Thread sheeri kritzer 
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 -einsert 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]

Re: why wont this work?

2005-10-28 Thread 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 -einsert 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]

Re: why wont this work?

2005-10-28 Thread Ben 
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 -einsert 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]