Re: delete syntax

2011-12-02 Thread Govinda
>> >>> 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

2011-12-02 Thread Reindl Harald
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-02 Thread 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 maintained only using the designated commands. You cannot

Re: delete syntax

2011-12-01 Thread 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 DROP USER is the only SINGLE COMMAND as long as you do not use table/column-privileges there are exactly two relevant

Re: delete syntax

2011-12-01 Thread Stdranwl
DROP USER command is the only command to remove any user and its association from all other tables. Cheers On Fri, Dec 2, 2011 at 8:22 AM, Reindl Harald wrote: > ALWAYS > start with "select * from mysql.user where user='mail_admin' and host like > '\%';" > and look what records are affected

Re: delete syntax

2011-12-01 Thread Reindl Harald
ALWAYS start with "select * from mysql.user where user='mail_admin' and host like '\%';" and look what records are affected to make sure the were-statement works as expected and then use "CURSOR UP" and edit the last command to "delete from" not only doing this while unsure with escapes protects

Re: delete syntax

2011-12-01 Thread Shiva
(0.00 sec) > > > sorry for not including enough information last time. > > best > tim > > - Original Message - > From: "Krishna Chandra Prajapati" > To: "Tim Dunphy" > Cc: mysql@lists.mysql.com > Sent: Thursday, December 1, 2011 9:03:46 PM

Re: delete syntax

2011-12-01 Thread Keith Keller
On 2011-12-02, Tim Dunphy wrote: > > Thanks but I probably should have noted that I only want to delete the > wildcard user. There are other users I would prefer to not delete. > > mysql> select user,host from mysql.user where user='mail_admin'; > ++---+ >| user

Re: delete syntax

2011-12-01 Thread Tim Dunphy
luding enough information last time. best tim - Original Message - From: "Krishna Chandra Prajapati" To: "Tim Dunphy" Cc: mysql@lists.mysql.com Sent: Thursday, December 1, 2011 9:03:46 PM Subject: Re: delete syntax delete from mysql.user where user='mail_admin'

Re: delete syntax

2011-12-01 Thread Krishna Chandra Prajapati
delete from mysql.user where user='mail_admin'; Krishna On Fri, Dec 2, 2011 at 7:23 AM, Tim Dunphy wrote: > hello list, > > I am attempting to delete a user from the mysql.user table without > success. > > mysql> delete from mysql.user where user='mail_admin@%'; > Query OK, 0 rows affected (

Re: DELETE syntax

2005-10-10 Thread Remo Tex
http://dev.mysql.com/doc/mysql/en/delete.html ... Multiple-table syntax: DELETE [LOW_PRIORITY] [QUICK] [IGNORE] tbl_name[.*] [, tbl_name[.*] ...] FROM table_references [WHERE where_definition] Or: DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name[.*] [, tbl_name[

Re: DELETE SYNTAX - [QUICK] option

2003-06-26 Thread Paul DuBois
At 16:22 +0900 6/26/03, Nils Valentin wrote: Hi MySQL Fans ;-); Does anybody understand what the QUICK option is doing when used with the DELETE command ? It says in the manual "..no MERGEing of INDEX leaves during delete". Sorry, but I could not make any sense out of this. Could somebody please b

Re: 'delete' syntax

2003-03-31 Thread Fred van Engen
Hi, On Mon, Mar 31, 2003 at 03:40:03PM +0100, warm-fusion wrote: > Hi, I'm just wondering what the right syntax for using the delete > statement is? I'm trying to write a simple garbage collection/deletion > query similar to the queries below. > > delete from 'item' where 'quantity_of_item_in_s

Re: 'delete' syntax

2003-03-31 Thread gerald_clark
warm-fusion wrote: Hi, I'm just wondering what the right syntax for using the delete statement is? I'm trying to write a simple garbage collection/deletion query similar to the queries below. delete from 'item' where 'quantity_of_item_in_stock' <= 10; delete from item where quantity_of_item_

re: Delete syntax

2002-09-17 Thread Victoria Reznichenko
smudholkar, Tuesday, September 17, 2002, 12:26:05 AM, you wrote: saadc> I am trying to write a delete query that will remove saadc> records from one table based on information from saadc> another table. In this example, there is a table called saadc> accounting which contains two fields: usern

Re: DELETE syntax and auto_increment 'reset'

2002-05-22 Thread Paul DuBois
At 18:29 -0400 5/22/02, Jule wrote: >Hey guys, >when i delete a row using the query DELETE FROM $table WHERE id = "3" LIMIT 1; > >how can i make it that the id column (auto_increment) starts over from 1 and >build up to however many rows there are without counting 1 2 4 5 6 etc.? If you're asking

Re: delete syntax - forms processing problem

2002-02-28 Thread DL Neil
Hi Andrea, > I have a phone directory that allows a user to search > the database by name & the results.php page has two > forms in it. one form allows the user to modify the > entry & submit changes to the database - this works > fine. the other form allows the user to delete the > entry (row)