Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 27-07-2009
Members
 
Join Date: May 2009
Posts: 44
mysqldump where query

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.
Reply With Quote
  #2  
Old 27-07-2009
Member
 
Join Date: Dec 2007
Posts: 93
sql query to delete table portion

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.
Reply With Quote
  #3  
Old 27-07-2009
Member
 
Join Date: Jan 2009
Posts: 91
mysqldump where query

It seems that there is some issue in your query, however you can run the following query
Code:
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "mysqldump where query"
Thread Thread Starter Forum Replies Last Post
Query in SQL v/s Query in Oracle Satchel Software Development 4 29-12-2010 07:19 AM
mysqldump in MySQL database Caden Fernandes Software Development 4 04-03-2010 11:02 PM
Want to make query dependent on another query. MACE Software Development 4 01-02-2010 05:22 PM
MySQL query in a query Rail racer Software Development 3 21-07-2009 07:06 PM
Turn on MySQL query cache to speed up query performance DMA2Superman Software Development 3 07-07-2009 10:26 AM


All times are GMT +5.5. The time now is 12:10 AM.