i making a program where I would read data from text files and store them in tables in myslq.
In my program I would create the table with the fields and in these fields I would insert the values from the text file.
My issue is that i don't know how! I would explain you why! In my program I would create table with fields (ID, Name). The values of these fields must be taken from the text file. The form of the text file is the below:
As you can see the ID is in the third row of the file and the Name is in the fifth. Could anyone help me how can I import the values for ID and Name in the table?How can i get these values?