Re: delete syntax

>> >>> well, i am using delete/insert-statements since 10 years to maintain >>> users since you only have to know the tables in the database "mysql" >>> and use "flush privileges" after changes >>> >>> The privileges should be maintained only using the designated commands. >> You cannot rely on

Re: delete syntax

Am 02.12.2011 21:59, schrieb Claudio Nanni: > 2011/12/2 Reindl Harald > >> well, i am using delete/insert-statements since 10 years to maintain >> users since you only have to know the tables in the database "mysql" >> and use "flush privileges" after changes >> >> The privileges should be main

Re: delete syntax

2011/12/2 Reindl Harald > well, i am using delete/insert-statements since 10 years to maintain > users since you only have to know the tables in the database "mysql" > and use "flush privileges" after changes > > The privileges should be maintained only using the designated commands. You cannot

Re: Question about deleting data and the undo log

> Does "drop table" use the undo log (rollback segment) to temporarily store > records to be purged later, the way "delete from table" does? As 'DROP TABLE' causes an implicit commit (http://dev.mysql.com/doc/refman/5.5/en/implicit-commit.html), I would highly suspect that it doesnt. You cannot