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: 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 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

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

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

(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

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

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

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 (

delete syntax

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 (0.00 sec) mysql> select user,host from mysql.user where user='mail_admin'; ++---+ | u

Re: DELETE syntax

multiple-table DELETE. The first multiple-table DELETE syntax is supported starting from MySQL 4.0.0. The second is supported starting from MySQL 4.0.2. The table_references part lists the tables involved in the join. Its syntax is described in Section 13.2.7.1, “JOIN Syntax”. That's fo MyISA

DELETE syntax

Hi, I need to know the syntax I can use for a certain delete statement. This is the idea: - A table with users, which has at least these fields, a user id field and a field containing its status (active, disabled, review). - A table that links certain users to each other, containing at least t

Re: multiple table delete syntax question

I have no problem understanding the syntax, or how to do what I want (at least after my first mistake). It is more about if this is a consistant grammar. For example, unix commands have the form " ", except for "ln -s" (IMO). >From a lexical view, I do not think the two forms are parallel. My que

Re: multiple table delete syntax question

[EMAIL PROTECTED] wrote: I have a question about the multiple table delete syntax. First the documentation on the website is very clear. My question is why not how. The 'delete from using' is not ambiguous (to me). My question is about the form: delete t1 from t1,t2 where ... I would

multiple table delete syntax question

I have a question about the multiple table delete syntax. First the documentation on the website is very clear. My question is why not how. The 'delete from using' is not ambiguous (to me). My question is about the form: delete t1 from t1,t2 where ... I would take this to mean remov

Re: DELETE SYNTAX - [QUICK] option

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

DELETE SYNTAX - [QUICK] option

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 be so kind to enlighten me ? I guess it i

Re: 'delete' syntax

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

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_

'delete' syntax

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; (the above version of the query pops up a Java-applet alert as

re: Delete syntax

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'

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

DELETE syntax and auto_increment 'reset'

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.? any ideas? Jule -- |\/\__/\/| |

Re: delete syntax - forms processing problem

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)

delete syntax - forms processing problem

Hi there, I've been struggling with this & the mysql documentation doesn't seem to be helping much. I'll try to make this as short as possible... 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 m