NAVIGATION
[[sql commands]]
Differences
This shows you the differences between two versions of the page.
|
english:technics:database:phpwcms_file:sql-commands [2009/05/12 01:12] Knut Heermann (flip-flop) |
english:technics:database:phpwcms_file:sql-commands [2018/06/03 18:09] (current) |
||
|---|---|---|---|
| Line 15: | Line 15: | ||
| UPDATE phpwcms_file SET f_uid=REPLACE(f_uid, '2', '1'); | UPDATE phpwcms_file SET f_uid=REPLACE(f_uid, '2', '1'); | ||
| </code> | </code> | ||
| + | |||
| + | \\ | ||
| + | **Example 1:** \\ | ||
| + | All files and folders with an ID > 51. | ||
| + | <code sql> | ||
| + | UPDATE phpwcms_file SET f_uid = REPLACE( f_uid, '2', '1' ) WHERE f_id >51; | ||
| + | </code> | ||
| + | \\ | ||
| + | **Example 2:** \\ | ||
| + | All files and folders within the directory with the ID = 66. | ||
| + | <code sql> | ||
| + | UPDATE phpwcms_file SET f_uid = REPLACE( f_uid, '2', '1' ) WHERE f_pid =66; | ||
| + | </code> | ||
| + | |||
| + | |||
| But this is still a placeholder! Imagine, which wonderful (and terrible) things you can do with that command!\\ | But this is still a placeholder! Imagine, which wonderful (and terrible) things you can do with that command!\\ | ||
| And the result of the above? The folder of the second admin is plain empty and you are the winner 8-) | And the result of the above? The folder of the second admin is plain empty and you are the winner 8-) | ||
