*edit* I misunderstood your post, sorry.

You probably could run an update after each delete that would look something like:

UPDATE number1 SET number = number-1 where number > *deleted name id num*

and just set the *deleted name id...

You should be able to do a group by on the state and then select the max of the counts of names.

It'd be something like:

select max(totalnames) as highest_total from ( select state,...

Hi,

You can do something similar to what I did below.

update products set p_price = p_price * 1.10 WHERE p_code LIKE 'ffc%' or p_code LIKE 'dcc%';

To clarify a little, you are getting a password prompt because you are specifying -p which is normally used as -p[password] but you are not supplying a password after the -p so it prompts you for...

If you want to do all the math through just SQL, you can do something similiar to the following:

SELECT session, SUM((markup/100.0* price + price)* amount * units) AS total FROM cart, fruit WHERE...