mysqldump where query

[Tungesh]

I am facing an issue with mysql where i need to delete some part of table where i am using mysqldump table query for that i am using the following query for it.

mysqldump -u user -p database="MYDATABASE" Query="SELECT * FROM
TABLE WHERE State='NV';

I don't have any idea about it . Can anyone help me out with this issue. Thanks in Advance.

[Ameya]

For deleting any portion of table you need to use the following query

alter table TABLE_NAME DROP column ONE, DROP column TWO, DROP column THREE;

If you want to drop all columns this will not work if you want to drop it then you need to use DROP TABLE.

[Naval]

It seems that there is some issue in your query, however you can run the following query

mysqldump -p -u username databasename tablename tablename.sql

to take backup. When you will run this query it will ask you for password and then you would be able to delete it.