MySQL Performance: MySQL => Strange create table/drop table problem.

Members

Help

Home

Home » Performance » MySQL » Strange create table/drop table problem.

Show: Today's Messages :: Show Polls :: Message Navigator

Strange create table/drop table problem. [message #3767]

Fri, 05 December 2008 08:14

gothgod
Messages: 2
Registered: December 2008

Junior Member

I created a table with the name "test.tableName". I thought it would go into the database "test" but didn't. It was actually named "test.tableName"... However if I try to drop the table "test.tableName" it says that there are no table named "tableName" in the database "test".

Really irritating, I can't get rid of it! Any suggestions?

[Updated on: Fri, 05 December 2008 08:19]

Report message to a moderator

Re: Strange create table/drop table problem. [message #3768 is a reply to message #3767 ]

Fri, 05 December 2008 08:29

gothgod
Messages: 2
Registered: December 2008

Junior Member

Ok, found the solution myself... =)
I just had to put the name between those ` things.

Report message to a moderator

Previous Topic:	iostat shows large amount of activity
Next Topic:	Realtime bulk imports on large table with keys

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 10 01:56:20 EDT 2009

Total time taken to generate the page: 0.14684 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.