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.
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.