help with simple sql statement

sekelsenmat · 08-06-2005, 09:27 AM

Hi,

I set up a mysql on my PC, created a table and now I want to add data to it, but mysql keeps complaining that my statement is wrong, but it doesn't provice any information about what is wrong.

Here is my table's description on the command line:

Code:

mysql> describe Acessos;
+----------------+-------------+------+-----+-------------------+-------+
| Field          | Type        | Null | Key | Default           | Extra |
+----------------+-------------+------+-----+-------------------+-------+
| ip             | varchar(50) | YES  |     | NULL              |       |
| pais           | varchar(5)  | YES  |     | NULL              |       |
| horario        | timestamp   | YES  |     | CURRENT_TIMESTAMP |       |
| navegador      | varchar(20) | YES  |     | NULL              |       |
| plataforma     | varchar(20) | YES  |     | NULL              |       |
| resolucao      | varchar(10) | YES  |     | NULL              |       |
| cores          | int(11)     | YES  |     | NULL              |       |
| listadeplugins | varchar(20) | YES  |     | NULL              |       |
+----------------+-------------+------+-----+-------------------+-------+
8 rows in set (0,00 sec)

And now my SQL statement:

mysql> INSERT INTO Acessos ('100.100.0.0','br','','Firefox','Linux','800x500', 256 , '' );

This will give me the error: 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 ''100.100.0.0','br','','Firefox','Linux','800x500', 256 , '' )' at line 1

Does anyone know what I am doing wrong? I think this could be on the TIMESTAMP value, but I tryed many values and it won't work...

Better yet, does anyone know a (free) SQL statement checker that will acctually give me a hint about what I am doing wrong?

thanks,

Felipe

Nylex · 08-06-2005, 09:34 AM

If you're not putting anything into the horario and listadeplugins columns yourself, maybe you should use

INSERT INTO Acessos(ip, pais, navegador, plataforma, resolucao, cores) VALUES('100.100.0.0','br','Firefox','Linux','800x500', 256);

sekelsenmat · 08-06-2005, 09:50 AM

Thanks!

The "VALUES" was missing...

I'm just learning SQL, and it would be much better if it gave me reasonable error messages instead of "check you sql statement" =/

thanks again,

Nylex · 08-06-2005, 09:57 AM

Agreed, that message is a pain in the rear end

. Have you seen the SQL guide at www.w3schools.com? If not, it's pretty good.

vharishankar · 08-06-2005, 10:54 AM

If you're into MySQL, you might find these links a great help:

http://dev.mysql.com/doc/mysql/en/index.html
http://dev.mysql.com/doc/mysql/en/da...ipulation.html
http://dev.mysql.com/doc/mysql/en/data-definition.html

sekelsenmat · 08-06-2005, 11:39 AM

Quote:

Originally posted by Harishankar
If you're into MySQL, you might find these links a great help:

http://dev.mysql.com/doc/mysql/en/index.html
http://dev.mysql.com/doc/mysql/en/da...ipulation.html
http://dev.mysql.com/doc/mysql/en/data-definition.html

Thanks, I'm setting my first Apache+PHP+MySQL server. The SQL code will acctually belong inside a php file.

sundialsvcs · 08-06-2005, 12:01 PM

Unfortunately, the SQL grammar that is used by MySQL still has no decent error-messages. It simply spits out a fragment of text beginning approximately where the parse failed, and tells you to find the problem. Curiously, quite a few SQL engines are like that.