Professional Web Applications Themes

Import/Export mysql tables in ASCII/text file - PHP Development

Hi!Where I can find the doentations to learn the IMPORT file ASCII/txt into mysql tables and EXPORT mysql tables in file ASCII/txt?? Can you help me? Thanks.. P.S. I hope my english is correct! -- AR...

  1. #1

    Default Import/Export mysql tables in ASCII/text file

    Hi!Where I can find the doentations to learn the IMPORT file
    ASCII/txt into mysql tables and EXPORT mysql tables in file ASCII/txt??
    Can you help me? Thanks..
    P.S. I hope my english is correct!

    --
    AR

    AR Guest

  2. #2

    Default Re: Import/Export mysql tables in ASCII/text file

    Hi,

    To import ASCII to MySQL use 'load data' command. To export MySQL
    use 'select * into outfile' command. Just construct the query and execute
    it in your code. Detail of the statement synatx can be found on MySQL
    doentation.

    Danny Wong

    "AR" <net>
    ???????:net... 


    Danny Guest

  3. #3

    Default Re: Import/Export mysql tables in ASCII/text file

    On Wed, 15 Jun 2005 10:06:57 GMT, "AR" <net> wrote:
     

    http://dev.mysql.com/doc/mysql/en/index.html

    --
    Andy Hassall / <co.uk> / <http://www.andyh.co.uk>
    <http://www.andyhsoftware.co.uk/space> Space: disk usage ysis tool
    Andy Guest

Similar Threads

  1. Export Querries from Flash 8 to MySQL and Import Datafrom MySQL
    By kelebribor in forum Macromedia Flash Data Integration
    Replies: 1
    Last Post: June 4th, 09:35 PM
  2. import from text file to mysql
    By Roime in forum PERL Beginners
    Replies: 5
    Last Post: September 24th, 03:50 AM
  3. import Text file in MySQL table
    By Bob Bedford in forum PHP Programming
    Replies: 8
    Last Post: December 10th, 05:31 PM
  4. Replies: 1
    Last Post: December 6th, 03:59 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