Direct input to Mysql

Help
Orso
2008-10-08
2013-05-30
  • Orso

    Orso - 2008-10-08

    Hi,

    how should be the data input to add several books (~600) directly to theĀ  openbiblio mysql database? How are the bibliographic data written to the mysql db?

    Kind regards, Orso

     
    • Nobody/Anonymous

      I did it yesterday by loading csv file into biblio table. something like that:

      LOAD DATA INFILE 'titles.csv' INTO TABLE biblio
      FIELDS TERMINATED BY ';'
      OPTIONALLY ENCLOSED BY '"'
      LINES TERMINATED BY '\n';

      I loaded up to 3000 registers in a second...

      Hope it helps...

       

Anonymous
Anonymous

Cancel  Add attachments