Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Sigi05

    Import txt-file to mysql DB

    Great guys, it worked. Thx very much to all! The following command was the right one LOAD DATA LOCAL INFILE '/home/sigi/tmp/sql.txt' INTO TABLE tt_news FIELDS TERMINATED BY '|' (headline,text,author) Thx again for helping me!
  2. Sigi05

    Import txt-file to mysql DB

    First of all, thx for all your answers. I'm using phpMyAdmin atm and was trying the LOAD DATA step. I typed LOAD DATA INFILE '/home/sigi/tmp/sql.txt' INTO TABLE tt_news FIELDS TERMINATED BY '|' (headline,text,author) into the SQL-section of PhpMyAdmin and uploadad the file with the txt-file...
  3. Sigi05

    Import txt-file to mysql DB

    Hello, first of all, i want to say that i am new to sql-programming, so this might be an easy one for you. On the one hand i have a mysql-table called "news". It has 4 fields, "uid" (with auto_increment attribute), "headline", "text", "author". On the other hand i have a txt-file in the...

Part and Inventory Search

Back
Top