i have one csv file which contains library group and it's data...
group consider as sheet and for each sheet contains phrase name and phrase value...
I want to insert this csv data to two different table using mysql how can i ?
suppose i have 2 table like
phrase_library_group
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| GROUP_ID | bigint(20) | NO | PRI | NULL | auto_increment |
| GROUP_NAME | varchar(100) | NO | | NULL | |
| ------------+--------------+------+-----+---------+----------------+
phrase_list
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| PHRASE_ID | bigint(20) | NO | PRI | NULL | auto_increment |
| PHRASE_NAME | varchar(100) | NO | | NULL | |
| PHRASE_DESC | varchar(500) | NO | | NULL | |
| GROUP_ID | bigint(20) | NO | MUL | NULL | |
| ------------+--------------+------+-----+---------+----------------+
here in image Additional_meds/Antibiotic Warnings/... are groups
and each group contains different phrases..like Additional_meds contains total 12 records as see below.
csv like
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)