Re: DELETE with LIMIT (or my first hack)
| От | Mario Weilguni |
|---|---|
| Тема | Re: DELETE with LIMIT (or my first hack) |
| Дата | |
| Msg-id | 4CF660F7.3080106@gmx.at обсуждение исходный текст |
| Ответ на | Re: DELETE with LIMIT (or my first hack) (Rob Wultsch <wultsch@gmail.com>) |
| Ответы |
Re: DELETE with LIMIT (or my first hack)
|
| Список | pgsql-hackers |
Am 01.12.2010 15:37, schrieb Rob Wultsch: > "For beginners, a useful startup option is --safe-updates (or > --i-am-a-dummy, which has the same effect). This option was introduced > in MySQL 3.23.11. It is helpful for cases when you might have issued a > DELETE FROM tbl_name statement but forgotten the WHERE clause. > Normally, such a statement deletes all rows from the table. With > --safe-updates, you can delete rows only by specifying the key values > that identify them. This helps prevent accidents. Is it really up to the database to decide what queries are ok? It's the task of the developers to test their applikations.
В списке pgsql-hackers по дате отправления: