I want to select some rows from my database
SELECT * FROM searches WHERE campaign_id = 49
Then insert all that data (except the autoincrementing id column) back into the database, changing "49" to "50"
is that possible?
Aeterna
0
Newbie Poster
griswolf
304
Veteran Poster
Yes. See for instance this insert...select document (this one is for 5.0 version, but i expect it is much the same for most)
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.