Professional Web Applications Themes

can't import TIME type w/mysqlimport - MySQL

Hi - I'm using server 5.0.19 on kernel 2.6.9.11. I was trying to use mysqlimport to import from a local file into a table. It kept barfing on a time field. So just to isolate the problem, i reformatted the file to contain only records as follows: 2006-03-13,09:13:26 2006-03-13,10:16:02 when i select * from the table i can see that only the dates were imported, but not the time. this is the SQL command I used to create the table: CREATE TABLE datetime (date DATE, time TIME, INDEX(date), INDEX(time)); any suggestions?...

  1. #1

    Default can't import TIME type w/mysqlimport

    Hi -

    I'm using server 5.0.19 on kernel 2.6.9.11.

    I was trying to use mysqlimport to import from a local file into a
    table. It kept barfing on a time field. So just to isolate the problem,
    i reformatted the file to contain only records as follows:

    2006-03-13,09:13:26
    2006-03-13,10:16:02

    when i select * from the table i can see that only the dates were
    imported, but not the time.

    this is the SQL command I used to create the table:
    CREATE TABLE datetime (date DATE, time TIME, INDEX(date), INDEX(time));

    any suggestions?

    cartine@gmail.com Guest

  2. #2

    Default Re: can't import TIME type w/mysqlimport

    <cartine> wrote in message
    news:1142522190.019797.284630i39g2000cwa.googlegr oups.com...
    > I was trying to use mysqlimport to import from a local file into a
    > table. It kept barfing on a time field. So just to isolate the problem,
    > i reformatted the file to contain only records as follows:
    >
    > 2006-03-13,09:13:26
    > 2006-03-13,10:16:02
    This worked for me:
    mysqlimport -u root -p --fields-terminated-by=, -v test datetime.txt

    This was using MySQL 5.0.18 on Windows XP Pro, executing mysqlimport from a
    DOS command shell.

    Can you be more specific regarding the failure? Was there any error
    message, or did it just silently fail to insert some values? Is your file
    in DOS format (newlines terminated by \r\n)?

    Regards,
    Bill K.


    Bill Karwin Guest

Similar Threads

  1. re-import all members one time
    By Carlos Gonçalves in forum Macromedia Director Basics
    Replies: 5
    Last Post: November 11th, 05:35 PM
  2. movie type to import?
    By itsrainin in forum Macromedia Director Basics
    Replies: 0
    Last Post: November 6th, 02:55 PM
  3. Type effects wont import into corel 10
    By Randall Priester in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 2
    Last Post: August 5th, 10:35 PM
  4. Import File and MIME Type
    By Lasse Brandt in forum Macromedia Director Lingo
    Replies: 0
    Last Post: July 14th, 02:04 PM
  5. Filemaker ODBC Constant Or Just One Time Import ??
    By J. Squeed in forum FileMaker
    Replies: 2
    Last Post: July 6th, 09:17 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