Thread: MySQL Problem
View Single Post
Old May 9th, 2006, 9:30 AM   #3
Infinite Recursion
Programming Guru
 
Infinite Recursion's Avatar
 
Join Date: Jul 2004
Location: United States
Posts: 3,467
Rep Power: 8 Infinite Recursion is on a distinguished road
Send a message via MSN to Infinite Recursion Send a message via Yahoo to Infinite Recursion
Yep, missing the "VALUES"...

Say for instance, I have a table named myTable with fields of: ID and NAME.
Also, since I have values for all fields in my table, there is no need to specify the columns ahead of time. To insert into the table, I would execute this:

INSERT into myTable VALUES ('0001','Infinite Recursion');
COMMIT;

Where "0001" is the ID and "Infinite Recursion" is the NAME.
__________________
http://jasonpowers.net

"There are a thousand hacking at the branches of evil to one who is striking at the root."
Infinite Recursion is offline   Reply With Quote