•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 397,786 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,359 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 2359 | Replies: 6
•
•
Join Date: May 2005
Posts: 228
Reputation: 
Rep Power: 4
Solved Threads: 0
Posting Whiz in Training
Hey, I'm doing a simple INSERT command, can you tell me what's wrong with it? I won't bother you with the php right now, cause I'm simply trying to get it work in the MySQL command line. Here is the exact command:
As far as I know, this is following syntax perfectly. But I get the following error:
http://www.packerworld.com/nate_personal/sql_error.JPG
Notice how "group", which should be a field in my table, is formatted in the query as if it's a command, instead of a field? I just don't get it!
Maybe I've set the fields in my table up incorrectly? I'm kind of new at MySQL, so maybe my table isn't set up correctly. Here's a screenshot of my table:
http://www.packerworld.com/nate_personal/table.JPG
INSERT INTO Birthdays(ID, firstname, lastname, birthday, group) VALUES('','Sam','Smith','June','Junior')As far as I know, this is following syntax perfectly. But I get the following error:
http://www.packerworld.com/nate_personal/sql_error.JPG
Notice how "group", which should be a field in my table, is formatted in the query as if it's a command, instead of a field? I just don't get it!
Maybe I've set the fields in my table up incorrectly? I'm kind of new at MySQL, so maybe my table isn't set up correctly. Here's a screenshot of my table:
http://www.packerworld.com/nate_personal/table.JPG
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Threaded Mode- mysql DELETE not working (PHP)
- php and mysql insert...where making me tear my hairs out!!! help!!! (PHP)
- mysql UPDATE not working! Why? (PHP)
- new to mySQL (MySQL)
- php wont submit data into the database (PHP)
Other Threads in the MySQL Forum
- Previous Thread: online tutorial
- Next Thread: order by....
