my dog learned polymorphism*
The moose likes JDBC and the fly likes mysql dump with WHERE or LIMIT clause Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "mysql dump with WHERE or LIMIT clause" Watch "mysql dump with WHERE or LIMIT clause" New topic
Author

mysql dump with WHERE or LIMIT clause

Duran Harris
Ranch Hand

Joined: Nov 09, 2008
Posts: 598

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??


===>SCJP 1.5(72%)<===
==>SCWCD1.5(76%)<===
Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3817

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?


    SCJP 5 | SCWCD 5
    [How to ask questions] [Twitter]
    Duran Harris
    Ranch Hand

    Joined: Nov 09, 2008
    Posts: 598

    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 :]
     
    I agree. Here's the link: http://aspose.com/file-tools
     
    subject: mysql dump with WHERE or LIMIT clause
     
    Similar Threads
    GET or POST which one is fast ?
    Do Get and Do Post
    What kind of bean?
    JSTL foreach Loops
    MIDI Memory leak