#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2002
    Posts
    1
    Rep Power
    0

    Unhappy How to enter genbank data into mysql/postgresql database


    How does one enter data from a Genbank file into a database?
  2. #2
  3. Wiking
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Sep 2000
    Location
    Sweden
    Posts
    3,608
    Rep Power
    26
    Not that I know what a Genbank file is, but to insert the contents of a file into a table in Postgresql use COPY FROM -> http://www.postgresql.org/idocs/index.php?sql-copy.html
    And to do it in MySQL use LOAD DATA INFILE -> http://www.mysql.com/doc/L/O/LOAD_DATA.html

    //NoXcuz
    UN*X is sexy!
    who | grep -i blonde | date; cd ~; unzip; touch; strip; finger; mount; gasp; yes; uptime; umount; sleep
  4. #3
  5. Introspective
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Nov 2001
    Location
    London, UK
    Posts
    3,317
    Rep Power
    110
    What's this got to do with Algorithms?
    This is me: http://chris.uk.com

IMN logo majestic logo threadwatch logo seochat tools logo