On Thu, Jan 20, 2005 at 08:58:18AM -0600, Jay Blanchard wrote:
> [snip]
> I get very nervous when I log onto my database via SSH and type in
> queries
> manually. Take the following query for example:
>
> Delete FROM Users WHERE User_ID = 5;
>
> If I hit return before I start typing WHERE then things would be
> disastorous! Is there any type of undo function with MySQL?
> [/snip]
>
> You'll want to read this....
>
> http://dev.mysql.com/doc/mysql/en/COMMIT.html
And try:
$ mysql --i-am-a-dummy
that makes it refuse deletes without 'where'
Good luck,
Harmen
--
The Moon is Waxing Gibbous (81% of Full)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
