Problem with Insert Statement.

[Alex1646]

SQL Server Verison: 5.1.5.3

Raw SQL statement:

INSERT INTO pm(to, from, message, date) VALUES('alex', 'alex', 'Bored!', '2011-03-30 04:30')

Error statement:  

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 'to, from, message, date) VALUES('alex', 'alex', 'Bored!', '2011-03-30 04:30')' at line 1

I also went into the SQL demo in W3Schools (http://www.w3schools.com/sql/sql_tryit.asp) thinking it will give me more information.  And I got this error message.

Operation must use an updateable query.

 

SQL structer:

The table name is pm

        id int(11)

to varchar(15)

from varchar(15)

message longtext

date(datetime)

I would like it to not give me a error message.

 

Ive tried removing  single quotes.

 

Cant think of anything else to do.

 

HELP!

[trq]

Both to and from have special meaning in SQL, you should rename your fields to something better.

 

Or, as a hack your can surround them in `backticks`, be aware however that this will only work with MySql.

[lilnow]

INSERT INTO test.pm (`to`, `from`, `message`, `date`) VALUES ('alex', 'alex', 'Bored!', '2011-03-30 04:30:00')

 

I agree with Thorpe, your table names could be better.

[Alex1646]

Thanks for the help. I have my private messaging system up and running now.