WampServer

So now I have WAMP installed, it is running great, but how do I use MySQL? I have even a book here to help me, but it seems like it expects that I already have a database created and selected.

When I give command in MySQL monitor like

mysql> CREATE db_name;

it returns

ERROR 1064 (42000): 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 'db_na
me' at line 1

This is probably very simple thing to answer, I still appreciate any answer.

Have you tried using phpmyadmin it is so much easier to use than mysql monitor? If you must use Mysql monitor then I think the command is:-

CREATE DATABASE databasename;

CREATE TABLE tablename (column1name description, column2name description ...);

Hope this helps.

I can't believe it was so easy...

just use phpmyadmin, it was designed to make administering your mysql server easier than using the console. see my tutorial here:

[forum.wampserver.com]



CyberSpatium
----------------------------
Wamp English Forum Admin