title: HOWTO insert TXT content to table
body: <p>CREATE TABLE IF NOT EXISTS <code>trxppl</code> (<br>
    <code>col1</code> int(11) NOT NULL DEFAULT '0',<br>
    <code>col2</code> varchar(30) NOT NULL DEFAULT '',<br>
    <code>col3</code> varchar(255) NOT NULL DEFAULT '',<br>
    <code>col4</code> varchar(255) NOT NULL DEFAULT '',<br>
    <code>col5</code> varchar(255) NOT NULL DEFAULT '',<br>
    <code>col6</code> varchar(255) NOT NULL DEFAULT '',<br>
    <code>col7</code> int(11) DEFAULT NULL,<br>
    <code>col8</code> varchar(255) NOT NULL DEFAULT '',<br>
    <code>col9</code> datetime DEFAULT NULL,<br>
    <code>col10</code> int(11) DEFAULT NULL,<br>
    <code>col11</code> varchar(255) NOT NULL DEFAULT '',<br>
    <code>col12</code> int(11) DEFAULT NULL,<br>
    <code>col13</code> decimal(10,0) DEFAULT NULL,<br>
    <code>col14</code> decimal(10,0) DEFAULT NULL,<br>
    <code>col15</code> int(11) DEFAULT NULL,<br>
    <code>col16</code> int(11) DEFAULT NULL,<br>
    <code>col17</code> int(11) DEFAULT NULL,<br>
    <code>col18</code> int(11) DEFAULT NULL,<br>
    <code>col19</code> int(11) DEFAULT NULL,<br>
    <code>col20</code> datetime DEFAULT NULL,<br>
    <code>col21</code> varchar(255) NOT NULL DEFAULT '',<br>
    <code>col22</code> int(11) DEFAULT NULL<br>
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;</p>
  
  <h2><br></h2>
  
  <p>i want to import this data ( from text file ) with phpmyadmi
  e.g. try.txt
  that file have data :</p>
  
  <p>2|MAIN ROOM|MAIN ROOM FAMILY|HOUSE|HOME|BIKERS|235235234|BUDI1|2015-07-20 14:35:56|234324|DATA|50|106.821210|-6.1956736|234234|01048|45792|24324324|1||2015-07-20||0</p>
  
  <p>2|MAIN ROOM|MAIN ROOM FAMILY|HOUSE|HOME|BIKERS|235235234|JOKO12|2015-07-15 16:08:34|23432423|DATA|100|106.831368|-6.1793116|234234|01019|47478|234234|1||2015-07-15||1</p>
  
  <hr>
  
  <p>can anyone help me to solve this ?</p>