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
> >
> >
>
