MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:kalle volkov Date:March 18 1999 9:17am
Subject:Re: Need help with insert user values
View as plain text  

u have to first select database u want to insert into...

# bin/mysql mysql
mysql> insert into user ... ;
# bin/mysql
mysql> use mysql
mysql> insert into user ... ;


Robert D. Lang CEO wrote:
> Dear Mysql Users:  I need help with the command line for inserting user
> values to the mysql database, user table.
> I have typed the below and as you can see from the telnet log, I have
> failed. (I have initiated the mysql monitor first of course).
> Can someone please tell me what I am doing wrong here and what the
> correct command is?
> mysql> insert into user values ('localhost', 'nobody', '',
> 'Y','Y','Y','Y','N','N','N','N','N','N')\g
> ERROR 1046: No Database Selected
> mysql> mysql
>     -> insert into user values ('localhost', 'nobody', '',
> Y,'Y','Y','Y','N','N','N','N','N','N')\g
> ERROR 1064: parse error near 'mysql
> insert into user values ('localhost', 'nobody', '',
> 'Y','Y','Y','Y','N','N' at line 1
> --
> Sincerely, Robert D. Lang
> RDL Communications Inc.
> Speak To Us: rdlcom@stripped   See Us:
> ---------------------------------------------------------------------
> To request this thread, e-mail mysql-thread469@stripped
> To unsubscribe, e-mail the address shown in the
> List-Unsubscribe header of this message.
> For additional commands, e-mail: mysql-help@stripped
Need help with insert user valuesRobert D. Lang CEO18 Mar
  • Re: Need help with insert user valueskalle volkov18 Mar
  • Re: Problems with synchronisation master -> slaveDominik Klein20 Jul
Re: Need help with insert user valuesEd Carp18 Mar