Keep Server Online
If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.
or
A donation makes a contribution towards the costs, the time and effort that's going in this site and building.
Thank You! Steffen
Your donations will help to keep this site alive and well, and continuing building binaries. Apache Lounge is not sponsored.
| |
|
 Topic: MySQL Queries Doesn't Work |
|
| Author |
|
Aznsilvrboy
Joined: 06 Jul 2006
Posts: 11
|
 Posted: Thu 27 Jul '06 18:27 Post subject: MySQL Queries Doesn't Work |
 |
|
I'm using MySQL Server 5 with Apache 2.2.2 and PHP 5.1.4 on Windows XP Professional. So I run MySQL Command Line Client (Monitor). Entered my password, everything's fine. Then I try to submit a query such as:
CREATE DATABASE databasename
There's no error messages, i clear the buffer, so i type in another query:
SHOW DATABASES
no error messages...nothing shows..i clear the buffer and enter:
USE databasename
and I get this error:
ERROR 1049 <42000>: Unknown Database 'databasename'
What's going on here...? Thanks. |
|
| Back to top |
|
pnllan
Joined: 05 Dec 2005
Posts: 221
|
| Posted: Thu 27 Jul '06 18:43 Post subject: |
|
|
You are doing everything right, EXCEPT you have to end the query with a semi-colon for it to execute.
Example:
mysql>CREATE DATABASE databasename; then hit the Enter Key |
|
| Back to top |
|
|
|
|
|
|
