•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 391,821 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 3,625 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: 536 | Replies: 4 | Solved
 |
•
•
Join Date: Jul 2007
Posts: 37
Reputation: 
Rep Power: 2
Solved Threads: 0
Light Poster
Hello everyone!
I am writing a music database, and I need to insert into album table the path to its cover. However, not every album has a cover in its directory, so I've made an algorithm that only gets the albumID that has a cover. My question is - how can I insert value into one column in a row with a specific ID (or name)? I have tried this -
but it sais that theres an error at WHERE. How can I do this? I am using sqlite3 and C++. Thanks!
I am writing a music database, and I need to insert into album table the path to its cover. However, not every album has a cover in its directory, so I've made an algorithm that only gets the albumID that has a cover. My question is - how can I insert value into one column in a row with a specific ID (or name)? I have tried this -
"insert into albums (cover_path) values ('%s') WHERE albumID=%d"
•
•
Join Date: Oct 2007
Location: South Africa
Posts: 59
Reputation:
Rep Power: 1
Solved Threads: 6
Junior Poster in Training
It sounds like you need to UPDATE rather than insert. Insert is used when the row doesn't exist at all. Update is used when you want to change the value of one or more columns in an existing row.
Hope that helps.
UPDATE albums SET cover_path = Your_Path WHERE albumID = Your_Album_Id
Hope that helps.
•
•
Join Date: Oct 2007
Location: South Africa
Posts: 59
Reputation:
Rep Power: 1
Solved Threads: 6
Junior Poster in Training
Maybe I missed the picture ...
You want to insert into table albums ...
Maybe?
You want to insert into table albums ...
insert into albums (albumID, cover_path) values ('%s', %d)Maybe?
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
- Previous Thread: i need help
- Next Thread: Recommended books?
