Read a text file and transfer contents to mysql database table using python
===

I am new to data base handling using python programming.  
                  By using python programming ,i want to read raw text file which consist of STUDEN T_NAME,STUDENT_MARKS. Which are separated by pipe symbol(given as below Example),I want to push this data into student table consists of 2 columns (STUDENT_NAME,STUDENT_MARKS) with respective data values.

  input data file will be like this(it consists of some thousands of records like this) ::  
> records    STUDENT_NAME| jack | STUDENT_MARKS|200| STUDENT_NAME| clark
> |STUDENT_MARKS|200| STUDENT_NAME| Ajkir | STUDENT_MARKS|30| 
> STUDENT_NAME| Aqqm | STUDENT_MARKS|200| STUDENT_NAME| jone | 
> STUDENT_MARKS|200| STUDENT_NAME| jake | STUDENT_MARKS|100|

  
Output mysql table table::

> STUDENT_NAME| STUDENT_MARKS
> ---------------------------
>      jack   |   200
>      clark  |   200
.......

please advice me to read file&push data in efficient way.
I would be so grateful if someone could give me script to achieve this.

Thanks,

hema klinton