MySQL Instruction error
 

Hi !!!, I'm new in MySQL.
So please help me......

The Server is running, but when i want to use :
mysql> SELECT VERSION(), CURRENT_DATE;
the message appear like below statement :
bash : syntax error near unexpected token `('


Regards
Verdi



:confused:

the syntax for select statement is this:

Select <column name1>, .. <columnameN> into <tablename>;

Thanks for your advise, but i got this instruction from MySQL Manual book as follow :

Here's a simple command that asks the server to tell you its version number and the current date. Type it in as shown here following the mysql> prompt and press Enter:

mysql> SELECT VERSION(), CURRENT_DATE;
+--------------+--------------+
| VERSION() | CURRENT_DATE |
+--------------+--------------+
| 3.22.20a-log | 1999-03-19 |
+--------------+--------------+
1 row in set (0.01 sec)
mysql>

Mine is working fine.. are you sure you installed it properly??

Try to exit in mysql and then log in again, then type again the select statement.


:newbie: :Pengy:

verokard, are you sure you're in the mysql program? You need to run "mysql -u <yourusername> -p" to first get into the mysql prompt and then type in your commands. It seems like you're trying to run "SELECT VERSION(), CURRENT_DATE;" from your bash shell.

OK, I'll try
Thanks Ice9