You need to use the use command
Mysql> \u [databasename]
Now you may run the query
Mysql> select * FROM dbname.table;
-Original Message-
From: David yahoo [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 4:25 PM
Cc: [EMAIL PROTECTED]
Subject: pb while querying in stra
we have to escape name
select * from `db-name`.`table-name`;
works.
great mysql.!
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
Bef
Hi all,
I ve got a database with the name
db-name
when making :
select * from db-name.table;
I get a error.
something is wrong in your syntex near : -name ...
How can I tell mysql that db-name is a database name ?
Thanks.
_
Do You
