sql "insert into" question

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 373,100 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,771 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.

Join our community!

Please support our MySQL advertiser:

sql "insert into" question

•

Join Date: Jul 2007

Posts: 33

Reputation: linux0id is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

linux0id

Offline

Light Poster

sql "insert into" question

Mar 26th, 2008

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 -

Help with Code Tags

(Toggle Plain Text)

"insert into albums (cover_path) values ('%s') WHERE albumID=%d"

but it sais that theres an error at WHERE. How can I do this? I am using sqlite3 and C++. Thanks!

Forum Highlights

Related Features

DANIWEB FEATURE INDEX

Statistics

Members: 373,100

Users Online Now: 3,771

Active IRC Users: 19

Forum Threads: 123,356

Forum Posts: 638,491

Code Snippets: 849

Blogs: 139

Blog Entries: 1,948

Directory Links: 563

DaniWeb Home > Forums > Web Development > Databases > MySQL > sql "insert...

sql "insert into" question

sql "insert into" question

sql "insert into" question