File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

mysql dump with WHERE or LIMIT clause

 
Duran Harris
Ranch Hand
Posts: 608
Eclipse IDE Spring Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I'd like to dump an existing table and it's data but only selected rows of data should be included..
Is there a WHERE or LIMIT syntax available for this??
 
Vijitha Kumara
Bartender
Posts: 3908
9
Chrome Fedora Hibernate
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Duran Harris wrote:I'd like to dump an existing table and it's data but only selected rows of data should be included..


Are you using something like .....

  • SELECT * INTO OUTFILE ......
  • ?

    Then you can use the where clause. Is this what you want?

     
    Duran Harris
    Ranch Hand
    Posts: 608
    Eclipse IDE Spring Ubuntu
    • 0
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Ah no not SELECT INTO I don't know how to do that.But it's okay,I've been shown how to do mysqldump with a WHERE clause now :]
     
    It is sorta covered in the JavaRanch Style Guide.
    • Post Reply
    • Bookmark Topic Watch Topic
    • New Topic