title: Why is this MySQL insert query not working?
body: <p>I have the following MySQL query which I am trying to execute in ASP.NET:</p>
  
  <pre><code>INSERT INTO LUIPPS (IPPID, IPPNAME, IPPEMAIL) VALUES ('2', 'AC DC', 'num@ghi.com.pk,aaz@abc.com.pk,asd@def.com.pk')
  </code></pre>
  
  <p>I am using <code>MySql.Data.MySqlClient</code> library. </p>
  
  <p>I am getting the following exception while using the <code>ExecuteNonQuery</code> function:</p>
  
  <pre><code>"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?INSERT INTO LUIPPS (IPPID, IPPNAME, IPPEMAIL) VALUES (2, 'AC DC', 'num@' at line 1"
  </code></pre>
  
  <p>Debug console shows: <code>Exception thrown: 'MySql.Data.MySqlClient.MySqlException' in MySql.Data.dll</code></p>
  
  <p>It's a syntactic error but I can't seem to find it. I have done the debugging as well where I have checked the value of <em>str</em> (which contains the query) in MySqlCommand object.</p>
  
  <pre><code>MySqlCommand cmd = new MySqlCommand(str, CON);
  </code></pre>
  
  <p>Its character to character the same as specified above. In fact, I have copied it from hovering over <code>str</code> while debugging.</p>
  
  <p>I have checked the DB as well which seems fine. The following image is the screenshot of the DB: </p>
  
  <p><a href="https://i.stack.imgur.com/x2jhn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/x2jhn.png" alt="enter image description here"></a></p>
  
  <p>Kindly guide me. Thanks in advance.</p>