Bega: Typo3 Users Group

These pages are the collaborative effort of a number of people involved in the development, administration and promotion of the typo3 content management system. The collaborators are a group of like minded people living in the Bega Valley Shire on the south coast of NSW, Australia.

The mailing list forum below will be the main repository of our collective experiences whilst learning typo3. You can send a message to the list by sending an email to typo3 (at) thebegavalley.com. Messages from non members are moderated before posting to the list. If you would like to become a a member of our mailing list go to http://lists.thebegavalley.com/mailman/listinfo/typo3 .

If you are a regular user of the list interested in helping to moderate and tidy up the forum into coherent threads of information, send a message to the list expressing your interest.

Back

[Typo3] migrating database information

06-12-2005 02:49 by Steve Ryan, stever(at)syntithenai.com

I needed to update a field value based on a combination of fields in the
same record and values in joined records

1. Write a query that generates update queries. Run this in the sql tab of
phpmyadmin against the relevant table (dont use the global sql query feature
of phpmyadmin)
SELECT concat('update tx_debortollidata_award set awardtitle="',a.awardyear,'
- ',p.title,'" where uid=',a.uid) FROM ` tx_debortollidata_award`
a,tt_products p WHERE a.product_id=p.uid and 1

2. Export (see link at bottom of page) in csv format with field quotation
disabled and lines terminated by ;/n
Sample export output looks like
update tx_debortollidata_award set awardtitle="2000 - Deen Chardonnay 1999"
where uid=1;
update tx_debortollidata_award set awardtitle="2000 - Deen Shiraz 1999"
where uid=2;
update tx_debortollidata_award set awardtitle="2000 - Gulf Station Shiraz
1999" where uid=3;

3. Copy the exported text, go to the sql tab of the table and paste the
generated queries.

--
Steve Ryan
Software Engineer
stever(at)syntithenai.com
http://it.thebegavalley.com
phone (work) 02 64920610 (mob) 0402190670
260 Spring Creek Road Buckajo 2550

Back

Site Menu

About

Typo3 Mailing List Forum

[Typo3] migrating database information

Typo3 core developer speaks on local radio

Typo3 Links