[TYPO3-dev] Good times with MySQL 5.1

Steffen Kamper info at sk-typo3.de
Sat Dec 13 11:17:56 CET 2008


Hi,

in future it will be possible to parse XML with MySQL, so the door is 
open for parsing templavoila-structure or other flexform structures 
direct in SQL [1].
For example extracting the uids of used contentelements of a page it 
would be possible to use
SELECT ExtractValue(tx_templavoila_flex, 'sDEF/lDEF/vDEF') as 
content_uids from pages

There is also the possibility to Update Records writing single values to 
this XML-structure.

vg Steffen

[1] http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html




More information about the TYPO3-dev mailing list