Maybe it has something to do with the MySql version and OS i'm using:
I'm running 3.23.42-max-nt on a Win2000 system, using BDB tables. Nuno A. S. Gonçalves [EMAIL PROTECTED] ----- Original Message ----- From: "Javier Armendáriz" <[EMAIL PROTECTED]> To: "Mailing list MySql" <[EMAIL PROTECTED]> Sent: Tuesday, January 15, 2002 3:28 PM Subject: RE: MySQL can't tell the difference between two databases??? > I really don´t undarstand > > My Linux is working fine in a situation like yours. I´ve simulated your > situation > > > mysql> use db2; > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Database changed > mysql> select * from tab1; > +----+--------+ > | id | name | > +----+--------+ > | 1 | javier | > +----+--------+ > 1 row in set (0.00 sec) > > > mysql> use db1; > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Database changed > mysql> select * from tab1; > Empty set (0.00 sec) > > > My database and table description: > > ysql> use db1; > Database changed > mysql> show tables; > +---------------+ > | Tables_in_db1 | > +---------------+ > | tab1 | > +---------------+ > 1 row in set (0.01 sec) > > mysql> describe tab1; > +-------+-------------+------+-----+---------+----------------+ > | Field | Type | Null | Key | Default | Extra | > +-------+-------------+------+-----+---------+----------------+ > | id | int(11) | | PRI | NULL | auto_increment | > | name | varchar(10) | YES | | NULL | | > +-------+-------------+------+-----+---------+----------------+ > 2 rows in set (0.00 sec) > > mysql> select * from tab1; > Empty set (0.01 sec) > > > > > > > mysql> use db2 > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Database changed > mysql> show tables; > +---------------+ > | Tables_in_db2 | > +---------------+ > | tab1 | > +---------------+ > 1 row in set (0.00 sec) > > mysql> describe tab1; > +-------+-------------+------+-----+---------+----------------+ > | Field | Type | Null | Key | Default | Extra | > +-------+-------------+------+-----+---------+----------------+ > | id | int(11) | | PRI | NULL | auto_increment | > | name | varchar(10) | YES | | NULL | | > +-------+-------------+------+-----+---------+----------------+ > 2 rows in set (0.00 sec) > > mysql> select * from tab1; > +----+--------+ > | id | name | > +----+--------+ > | 1 | javier | > +----+--------+ > 1 row in set (0.01 sec) > > And finally my server and sistem data: > > mysql> status; > -------------- > mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686) > > Connection id: 6 > Current database: db1 > Current user: [EMAIL PROTECTED] > Current pager: stdout > Using outfile: '' > Server version: 3.23.44 > Protocol version: 10 > Connection: linux2 via TCP/IP > Client characterset: latin1 > Server characterset: latin1 > TCP port: 3306 > Uptime: 7 hours 27 min 52 sec > > > Red Hat Linux release 7.0 (Guinness) > Kernel 2.2.16-22 on an i586 > > > > -----Mensaje original----- > > De: Gerald Clark [mailto:[EMAIL PROTECTED]] > > Enviado el: martes, 15 de enero de 2002 15:35 > > Para: Nuno Gonçalves > > CC: Mailing list MySql > > Asunto: Re: MySQL can't tell the difference between two databases??? > > > > > > Is db2 a symlink to db1? > > > > If it was deleting one database or table must delete de another one. > > > ________________________________ > Javier Armendáriz > [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php