On Mon, Sep 12, 2011 at 12:50 AM, Roland Bouman <[email protected]> wrote: > I see now that the documentation at > http://docs.drizzle.org/join.html#different-kinds-of-sql-joins indeed > only mentions this case requiring a WHERE (or an ON, which is puzzling > - I'm pretty sure FROM t1,t2 ON .. is not valid standard SQL). If > one's currently allowed to leave out the ON clause for INNER, LEFT and > RIGHT JOIN, then I think it'd be good to change that behaviour to > align it with the standard. > >>> A DELETE or UPDATE without a WHERE is valid SQL. With great power >> comes great responsibility. >> >> Power isn't affected, safety is. > > Fair point, but in that case, IMO it makes much more sense to set > autocommit off by default.
That affects (usability of) all write queries, is it really better than just affecting deletes/updates without where? Olaf _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
