Difference between revisions of "Move tiddlers to different space"

From knowledgebase
Jump to navigation Jump to search
(Replaced content with "Move tiddlers to different space Category:log")
Tag: Replaced
 
Line 1: Line 1:
−
Move tiddlers to different space
+
update revision set bag_name = 'marketing_public' where number in (select revision_number from tag where tag = 'M8');# 146 row(s) affected.
 +
 
 +
update tiddler set bag_name = 'marketing_public' where revision_number in (select revision_number from tag where tag = 'M8');# 96 row(s) affected.
 +
 
 +
 
 +
update revision set bag_name = 'marketing_public' where tiddler_title LIKE "M8%";# 31 row(s) affected.
 +
 
 +
update tiddler set bag_name = 'marketing_public' where title LIKE "M8%";# 15 row(s) affected.
 +
 
 
[[Category:log]]
 
[[Category:log]]

Latest revision as of 19:43, 27 August 2020

update revision set bag_name = 'marketing_public' where number in (select revision_number from tag where tag = 'M8');# 146 row(s) affected.

update tiddler set bag_name = 'marketing_public' where revision_number in (select revision_number from tag where tag = 'M8');# 96 row(s) affected.


update revision set bag_name = 'marketing_public' where tiddler_title LIKE "M8%";# 31 row(s) affected.

update tiddler set bag_name = 'marketing_public' where title LIKE "M8%";# 15 row(s) affected.