Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database Naming Problem

Status
Not open for further replies.

barryp

Programmer
Jan 30, 2002
48
0
0
GB
I've an SQL script which initialises my databases as required. This has been working fine. Now I have to create & use a database called 'Home+Away'
My script now fails

The lines in my sql file are

DROP DATABASE IF EXISTS `Home+Away`;
CREATE DATABASE `Home+Away`;
USE `Home+Away`;

The USE fails with the error

Unknown database "`Home+Away`"
I can see the database has been created by using phpMyAdmin.

Any suggestions welcome !

Barry

What is wrong ?
I have tried escaping the '+' with backslash to no avail.
 
Barry,

I'll try over lunch time on my pc, but I got to ask you, why put a + into the name, it's asking for grief !!

kevin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top