Hi folks,


I mistakenly entered "dbPerdition" on db table of MySQL


mysql> SHOW tables;

+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| columns_priv              |
| db                        |
| func                      |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| host                      |
| proc                      |
| procs_priv                |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| user                      |
+---------------------------+
17 rows in set (0.00 sec)

mysql> SELECT * from db;

+-----------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
| Host      | Db          | User      | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Execute_priv |
+-----------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
| localhost | maildb      | mail      | Y           | Y           | Y           | Y           | Y           | Y         | N          | N               | N          | N          | N                     | N                | N                | N              | N                   | N                  | N            |
| %         | maildb      | mail      | Y           | Y           | Y           | Y           | Y           | Y         | N          | N               | N          | N          | N                     | N                | N                | N              | N                   | N                  | N            |
| localhost | dbPerdition | perdition | Y           | Y           | Y           | Y           | Y           | Y         | N          | N               | N          | N          | N                     | N                | N                | N              | N                   | N                  | N            |
| %         | dbPerdition | perdition | Y           | Y           | Y           | Y           | Y           | Y         | N          | N               | N          | N          | N                     | N                | N                | N              | N                   | N                  | N            |
+-----------+-------------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+
4 rows in set (0.00 sec)

Please advise how to drop it. TIA


B.R.
satimis

First thing, take 30 minutes to educate yourself with this simple and concise sql primer. http://blog.dmbcllc.com/2008/09/18/b...r-programmers/








and then only:

 delete from db where Db='dbPerdition' and user='perdition'

Originally Posted by tripy

First thing, take 30 minutes to educate yourself with this simple and concise sql primer. http://blog.dmbcllc.com/2008/09/18/b...r-programmers/

and then only:

 delete from db where Db='dbPerdition' and user='perdition'

Noted with thanks.


B.R.
satimis

As others said.

A good place would be to goto www.mysql.com as they explain all of that

Originally Posted by GixxerPC

As others said.

A good place would be to goto www.mysql.com as they explain all of that

Hi GixxerPC,


Thanks for your link.


Previously googling brought me many mysql doc.,

such as;
http://dev.mysql.com/doc/refman/5.0/en/update.html

I'm not well understood some expression.

E.G.
{expr1|DEFAULT}
where_condition
table_references

etc.


Are there example links? TIA


B.R.
satimis

I'm not well understood some expression.

E.G.
{expr1|DEFAULT}
where_condition
table_references

etc.


Are there example links? TIA

That, I can understand, let take an example:

UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ...
[WHERE where_condition]
[ORDER BY ...]
[LIMIT row_count]

For the conventions, in almost every programming doc I have seen, what is contained between [ and ] is optionnal.
What is contained bewteen { and } denote that you have a choice, and each choices is delimited by |

Something like

[, col_name2={expr2|DEFAULT}] ...

should be read "separate each column to be updated by a comma, and add as much as you need to the query".
As they are between [], it means that it's not mandatory, which is logical.

The WHERE clause is the filter. It's where you will tell to the sql engine what conditions should the rows have to be elected to be updated.

And the LIMIT statement is pretty self explanatory, it allows you to apply that update to the x first elements only.
That one is generally used with the ORDER BY statement, to ensure that the order of the rows is known.
Otherwise, you cannot be assured of the rows order.

So, in this example, it means that the smallest query that you can write is

UPDATE tbl_name
SET col_name1=value1

But you could end up with

UPDATE LOW_PRIORITY tbl_name
SET col_name1=value1, col_name2=value2, col_name3=value3, col_name4=value4, col_name5=DEFAULT, col_name6=value7
WHERE enabled=1 
AND creation_date between '2006-01-01' and '2006-03-01'
AND EXISTS (
  SELECT 1
  FROM other_table
  WHERE id=tbl_name.id 
  AND status='paid'
)

Which, will being more complex, is still pretty understandable, I think.