WampServer

Hi Guys.

sorry to disturb you this evening.
but i have a problems, i have installed wamp on my machine in c: drive
everythin works and php works when i want to write code wicked perfect.
but now i went to MySQL and i get pull up menu gives me a list of option, i then go to Mysql console
then it gives me password to type, i just pressed enter works ok , dunno if tht wat i hve to press entered, as i have neva setup my sql account, how do i do it?

ok

now i want to create a table in mySql

this is what i did
-------------------------------------------------------------------------------------------------------------------
mysql> CREATE DATABASE jokes; then entered
mysql> USE jokes; then pressed entered ( its says database changed)

mysql> CREATE TABLE table_name(
-> column_1_name column_1_type column_1_details,
-> column_2_name column_2_type column_2_details,
-> ...
->;
-------------------------------------------------------------------------------------------------------------------
when i press enter i get error message saying:-

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
' table (
column_1_name column_1_type column_1_details,
column_2_name column_2_typ' at line 1

-------------------------------------------------------------------------------------------------------------------

please help me

Look forward to hear from you soon
From Bhavesh

Check this post for setup mysql user and password

[forum.wampserver.com]

and you should use phpmyadmin to work on mysql. it's way more easier than using console