From 33187832bdcfdf72f741112006ad44ba9055e96e Mon Sep 17 00:00:00 2001
From: Alex Kellner <alexander.kellner@in2code.de>
Date: Wed, 2 Oct 2019 07:25:44 +0000
Subject: [PATCH 1/1]

---
 MysqlXml.txt | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 MysqlXml.txt

diff --git a/MysqlXml.txt b/MysqlXml.txt
new file mode 100644
index 0000000..f84e2d4
--- /dev/null
+++ b/MysqlXml.txt
@@ -0,0 +1,5 @@
+# Read: Show real path in sys_file_storage
+select name, uid, ExtractValue(configuration, '//T3FlexForms/data/sheet[@index="sDEF"]/language/field[@index="basePath"]/value') path from sys_file_storage where uid > 0 
+
+# Write: Set a new value (in this case a detail pid) in FlexForm of a tt_news plugin
+UPDATE tt_content SET pi_flexform = UpdateXML(pi_flexform, '//T3FlexForms/data/sheet[@index="s_misc"]/language/field[@index="PIDitemDisplay"]/value', CONCAT('<value index="vDEF">', 123, '</value>' )) WHERE uid=11107
\ No newline at end of file
-- 
2.30.2