MySQL Instruction error

verokard · 07-10-2003, 11:16 PM

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

ann_tulip18 · 07-10-2003, 11:42 PM

the syntax for select statement is this:

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

verokard · 07-11-2003, 01:31 AM

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>

ann_tulip18 · 07-11-2003, 01:56 AM

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.

IceNineJon · 07-11-2003, 02:14 AM

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.

verokard · 07-11-2003, 04:28 AM

OK, I'll try
Thanks Ice9