[Solved]: MySQL Query Question [Solved]: MySQL Query Question
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

[Solved]: MySQL Query Question

Started by Superficial Gallery, April 18, 2009, 09:00:51 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

Superficial Gallery

April 18, 2009, 09:00:51 PM Last Edit: April 18, 2009, 10:56:06 PM by Nibbler
Hi!

So I have a ton of pics in my installation.  Most of them get added by batch add, which means that I don't have any titles or captions on the pics.  I would like to be able to update them album by album using mysql (phpadmin) but I don't know the syntax.  Like, I want to change all the captions in album 1 to X (they would all be the same) and the same with the titles.

Anyone know the sql code?  I am pretty sure this is the right forum for this - thanks!

Nibbler

#1
April 18, 2009, 09:42:57 PM
Fairly simple:

Code Select
UPDATE cpg_pictures SET caption = 'X' WHERE aid = 1
Code Select
UPDATE cpg_pictures SET title = 'Y' WHERE aid = 1

change the cpg_ to the prefix you chose during installation. Make a backup of your db before running any manual queries.

Superficial Gallery

#2
April 18, 2009, 10:16:43 PM
You rock more than mount everest.  Thanks!
Print
Go Up Pages1
User actions