Professional Web Applications Themes

LOAD DATA is it transactional ? - MySQL

Command LOAD DATA is it transactional ? What's happens if loading 1000 rows, some rows goes in error ? Thank You in advance...

Sponsored Links
  1. #1

    Default LOAD DATA is it transactional ?

    Command LOAD DATA is it transactional ?

    What's happens if loading 1000 rows, some rows goes in error ?

    Thank You in advance


    Sponsored Links
    Tony Guest

  2. #2

    Default Re: LOAD DATA is it transactional ?

    That depends on the backend pluggable DB engine you are using.

    For instance, innodb will cancel the entire transaction. MyISAM can be made
    to keep taking as many rows as it can read.

    HTH.

    ~ Duane Phillips.

    "Tony" <arcucci> wrote in message
    news:I61ef.37634$65.1135673twister1.libero.it...
    > Command LOAD DATA is it transactional ?
    >
    > What's happens if loading 1000 rows, some rows goes in error ?
    >
    > Thank You in advance
    >

    Duane Phillips Guest

  3. #3

    Default Re: LOAD DATA is it transactional ?

    I should also add that you can set additional options on load (depending on
    your version).

    See doentation on Load Data like this:

    "The REPLACE and IGNORE keywords control handling of input records that
    duplicate existing records on unique key values.
    If you specify REPLACE, input rows replace existing rows (in other words,
    rows that have the same value for a primary or unique index as an existing
    row)."

    And...

    "If you specify IGNORE, input rows that duplicate an existing row on a
    unique key value are skipped. If you don't specify either option, the
    behavior depends on whether or not the LOCAL keyword is specified. Without
    LOCAL, an error occurs when a duplicate key value is found, and the rest of
    the text file is ignored. With LOCAL, the default behavior is the same as if
    IGNORE is specified; this is because the server has no way to stop
    transmission of the file in the middle of the operation."


    HTH

    ~ Duane Phillips.

    "Duane Phillips" <askmeaskme.askme> wrote in message
    news:16qdnc6QY4Y-uufenZ2dnUVZ_sOdnZ2dgiganews.com...
    > That depends on the backend pluggable DB engine you are using.
    >
    > For instance, innodb will cancel the entire transaction. MyISAM can be
    > made to keep taking as many rows as it can read.
    >
    > HTH.
    >
    > ~ Duane Phillips.
    >
    > "Tony" <arcucci> wrote in message
    > news:I61ef.37634$65.1135673twister1.libero.it...
    >> Command LOAD DATA is it transactional ?
    >>
    >> What's happens if loading 1000 rows, some rows goes in error ?
    >>
    >> Thank You in advance
    >>
    >
    >

    Duane Phillips Guest

Similar Threads

  1. data txt load
    By ocvs in forum Macromedia Flash Data Integration
    Replies: 2
    Last Post: July 27th, 12:13 PM
  2. Load xml data in sepearate mxml file and Populate data
    By indradapps in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: June 7th, 05:44 AM
  3. MySQL Transactional Examples in PHP
    By Ralph Freshour in forum PHP Development
    Replies: 1
    Last Post: October 19th, 03:26 PM
  4. problem with transactional components in Win2003
    By ted targosz in forum ASP Components
    Replies: 0
    Last Post: August 22nd, 02:02 AM
  5. Cleaning Data for Load
    By Dan Allen in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 11th, 07:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139