MySQL Forums
Forum List  »  Newbie

Problem with USE statement
Posted by: Rein Man
Date: March 09, 2009 02:42AM

Hello,

I hope i have a simple problem.

I need to import a database which is called traders-nl

the statement: USE traders-nl results in:
SQL-query:

-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 04 Mar 2009 om 11:53
-- Server versie: 4.1.21
-- PHP Versie: 5.0.4
--
-- Database: `Traders`
--
USE counters - nl;

MySQL returnt:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-nl' at line 1

I tried:
USE "traders-nl"
as well as:
USE 'traders-nl'
that didn't work

also my webhost claims they cannot change the name of the database :s

if anyone can help me with this you will make my day :)

grtz,
reinman



Edited 1 time(s). Last edit at 03/09/2009 02:43AM by Rein Man.

Options: ReplyQuote


Subject
Written By
Posted
Problem with USE statement
March 09, 2009 02:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.