Title: Update CSV to a mysqldb Ignoring the IDs which has no entries
Tags: mysql;sql;python-2.7;phpmyadmin
Question: I'm new to work on mysqlDB.

I have a table that looks like 

```id,A,B,C,D,E,F,G,H
```

Now,I have ```CSV``` file with approximately 11000 entries which look like

```1,
2,Q,R,X,Y,Z
3,X,Y,Z
4,Q,R
100,R,X
5000,X,Q
200,
7000,
10000,
.....
```

My question is,How do i import the ```CSV``` to update the data only to the table column ```H``` where by ignoring the ```ID``` which has no entries present ? Any advice on this would be really great.

Expected Query Result for the Column ```H```

```ID           H
1
2         Q,R,X,Y,Z
3         X,Y,Z
4         Q,R
100       R,X
5000      X,Q
200
7000
10000
.....
```

Comment: @Vatev Yes,Buddy ! i have only two columns in CSV for Example A&B where A has ID and B might have multiple values in a cell !

Comment: How many columns does the csv have? Do they all go in the H column in the table?

Comment: Well there aren't any quotes or escapes there, any csv parser will interpret those as separate cells.



{'source': 'StackExchangeDataset', 'subset': 'stackoverflow.com', 'metadata': {'AnswerCount': 0, 'CommentCount': 3, 'ContentLicense': 'CC BY-SA 3.0', 'CreationDate': '2015:00:07/24/15', 'FavoriteCount': None, 'PostTypeId': 1, 'Tags': '<mysql><sql><python-2.7><phpmyadmin>', 'Title': 'Update CSV to a mysqldb Ignoring the IDs which has no entries', 'ViewCount': 23, 'id': 31603294, 'user_AboutMe': "<p>Arun is pursuing his career in Information security and working in Netskope, One of a leading CASB as a Cloud Security Researcher &amp; Developer from past 5.5 +  years at Bangalore,India.</p>\n\n<p>His role is to do security analysis of cloud apps,vulnerability research,assessing cloud apps &amp; its risks , threat research.</p>\n\n<p>Before turning to security researcher at Netskope and IT Administrator,He did his Masters of Science in Advanced Computer Network @ Glasgow Caledonian University,Glasgow,Scotland and Bachelors of Technology in Information Technology from Anna University,Chennai. He is also a certified CCNA ( Cisco Certified Network Associate Certificate),ITIL Foundation Certified and he is a CCIE R&amp;S(Written) personnel too. His specialization in programming language includes Python,Shell scripting,SQL &amp; MongoDB Basics. </p>\n\n<p>He is pursuing and aiming to obtain his ISC^2 CISSP certification with in end of 2019.</p>\n\n<p>His interests include malware analysis, vulnerability research and threat intelligence. He likes to meet new people and love to share his ideology and like to know more into information security &amp; threat space in-order to diagnose and deliver effective solutions for complex problems. </p>\n\n<p><strong><em>At Netskope ,He does work on</em></strong> </p>\n\n<p>►Developing internal frame works for data collection &amp; reporting using Python/Shell scripting.</p>\n\n<p>►Vulnerability and Security Research &amp; Analysis on Cloud Apps.</p>\n\n<p>►Basic Malware Analysis ( Static &amp; Dynamic ) and Writing signatures to hunt them.</p>\n\n<p>►Ransomware Behavioral Analysis ( Automated way of replicating ransomware and gathering intelligence Using open source Cuckoo Sandbox ) and Hunting for new variants of them daily from various resources.</p>\n\n<p>►Keeping track of new vulnerabilities/Malware that poses significant risk from SaaS Apps.</p>\n\n<p>► Netskope's Threat Detection Capabilities ( Sandbox , Heuristic Engines , File Decomposers etc ) QA.</p>\n\n<p>►Threat ( Ex: End-Point-Response Services like ( Carbon Black EDR ) , Cylance , Juniper Threat Protection , Farsight pDNS( Passive DNS ) and NOD ( Newly Observed Domains and More etc. ) Product Evaluation &amp; Integration and Testing. </p>\n\n<p>► Developing new vulnerability scanning framework &amp; Conducting vulnerability scans on SaaS apps on a routine or ad-hoc basis.</p>\n\n<p>►Blogging on identified vulnerabilities on SaaS Apps.</p>\n\n<p>► Creating a ‘Malware Lab’ on an isolated network and Collected &amp; Maintaining around 2 \n Million + Malware Artifacts from various resources and managing them using open source Malware \n Management framework called VIPER.</p>\n\n<p>►In-house malware processing framework using various Dynamic &amp; Static Analysis Engines which can process/replicate the malicious samples in a daily manner and gives a complete verdict of each file sample analyzed. </p>\n\n<p>► Developed a robust blacklist threat Intelligence content generation ( Domain , URL , IP , File Hash ) framework.</p>\n", 'user_AccountId': 6592170.0, 'user_DisplayName': 'Arun', 'user_Reputation': 1110.0, 'user_Views': 110.0, 'user_id': 5093018.0}}