List:General Discussion« Previous MessageNext Message »
From:Gabriel-Dumitrel MOSCALU Date:May 11 2003 9:49pm
Subject:Re: Know the current database ?
View as plain text  
I forgot,

Also you could check out the following URL:
http://www.mysql.com/doc/en/Miscellaneous_functions.html

Cheers
Gabriel

----- Original Message ----- 
From: "Gabriel Moscalu" <gabriel.moscalu@stripped>
To: "David Yahoo" <david_devidal@stripped>
Cc: <mysql@stripped>
Sent: Sunday, May 11, 2003 11:44 PM
Subject: Re: Know the current database ?


> Hi David,
>
> After logging in, type
>
>         SHOW DATABASES        to see available databases
>         STATUS                             to see your current login,
host,
> server version and database
>         SHOW TABLES                to see available tables into current
> database
>
>
> But if you would just read the  MySQL basic documentation, you would have
> found the answers to this question.
>
> The queries you were trying do not exist on MySQL (as far as I know)
>
> Good Luck
> Gabriel
>
> ----- Original Message ----- 
> From: "David Yahoo" <david_devidal@stripped>
> To: <mysql@stripped>
> Sent: Saturday, May 10, 2003 6:39 PM
> Subject: Know the current database ?
>
>
> > Is there a keyword that allow to retrieve the name of the current
database
> ?
> >
> > It could be good for queries like :
> >
> > select DATABASE_NAME,*  from db1.t1
> > union
> > select DATABASE_NAME,*  from db2.t1
> >
> > Not very sample but.
> > Is this keyword exists ?
> >
> > Thanks.
> >
> >
> >
> > Mysql.
> >
> > -- 
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
> >
> >
>

Thread
Inherited a db with unknown username/passwordChristine Bryan10 May
  • re: Inherited a db with unknown username/passwordEgor Egorov10 May
    • Know the current database ?David Yahoo10 May
      • re: Know the current database ?Victoria Reznichenko12 May
    • Re: Know the current database ?Gabriel-Dumitrel MOSCALU13 May
    • Re: Know the current database ?Salam Baker Shanawa13 May
    • Re: problemBecoming Digital14 May
  • Re: Inherited a db with unknown username/passwordFred van Engen11 May
Re: Know the current database ?Gabriel-Dumitrel MOSCALU13 May