database has a semicolon

#1

I have a database in MYSQL that has a semicolon on the end. ie:

Quote:

show databases;
....

db1
db2
mytestdb;
db3
....

Quote:

I can't seem to drop this database, since the semicolon is part of the
name. I've tried escaping it and passing the database name as a
quoted string, neither of which worked. Does anyone know the syntax
I'd need to drop this database?

Thanks!
b

#2

On Mon, 07 Jan 2008 15:42:11 +0100, Reacher <brandon.g.jones (AT) gmail (DOT) com>
wrote:

Quote:

I have a database in MYSQL that has a semicolon on the end. ie:

show databases;
...
db1
db2
mytestdb;
db3
...

I can't seem to drop this database, since the semicolon is part of the
name. I've tried escaping it and passing the database name as a
quoted string, neither of which worked. Does anyone know the syntax
I'd need to drop this database?

DROP DATABASE `mytestdb;`;

Notice the backticks (`) instead of single quotes (').
--
Rik Wasmus

#3

"Reacher" <brandon.g.jones (AT) gmail (DOT) com> schreef in bericht
news:d5996c0a-c3dd-4a8f-8415-7ed06f109457 (AT) c4g2000hsg (DOT) googlegroups.com...

Quote:

I have a database in MYSQL that has a semicolon on the end. ie:

show databases;
...
db1
db2
mytestdb;
db3
...

I can't seem to drop this database, since the semicolon is part of the
name. I've tried escaping it and passing the database name as a
quoted string, neither of which worked. Does anyone know the syntax
I'd need to drop this database?

Thanks!
b

drop datavase `testdb;`;

#4

On Jan 7, 8:46*am, "Rik Wasmus" <luiheidsgoe... (AT) hotmail (DOT) com> wrote:

Quote:

On Mon, 07 Jan 2008 15:42:11 +0100, Reacher <brandon.g.jo... (AT) gmail (DOT) com> *
wrote:

I have a database in MYSQL that has a semicolon on the end. *ie:

show databases;
...
db1
db2
mytestdb;
db3
...

I can't seem to drop this database, since the semicolon is part of the
name. *I've tried escaping it and passing the database name as a
quoted string, neither of which worked. *Does anyone know the syntax
I'd need to drop this database?

DROP DATABASE `mytestdb;`;

Notice the backticks (`) instead of single quotes (').
--
Rik Wasmus

Thanks! Rails actually put the semicolon in there in the first place
(someone had them in the YAML file)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

database has a semicolon

comp.databases.mysql comp.databases.mysql

database has a semicolon - 01-07-2008 , 09:42 AM

Re: database has a semicolon - 01-07-2008 , 09:46 AM

Re: database has a semicolon - 01-07-2008 , 09:49 AM

Re: database has a semicolon - 01-07-2008 , 09:50 AM