Is it possible to import/procees queries on data files of an ASCII format ?
Thanks !

    Of course.

    I assume you have an ascii file that contains data that you want to place in your mysql database. How you do this, depends greatly on the format of your data, and how you want to place it in your database.

    One way to go, would be the LOAD DATA INFILE function in MySQL. It allows you to load data from a text-file into a mysql table, specifying delimiters and such. You can read more about it on the mysql webpage, http://www.mysql.com/doc/

    However, if your data is not structured with one entry per line, and you want the data into several tables, possibly with relations etc, you'll have to modify your ASCII file. I'd say the best way to go is to first create a structure in mysql (tables etc), and then modify your ascii data to a set of SQL statements. Perl is an excellent tool for this kind of operations, although you might want to use sed, awk, or similar tools. If you need more help, please post info on how you want it to be stored in your database, how the data is currently formatted etc. 🙂

      Sorry for my late response.
      I needed this information very much, hence i'm gratefull to you !

        Write a Reply...