# MySQL Syntax Error

**URL:** <https://forum.kirupa.com/t/mysql-syntax-error/272828>\
**Category:** programming\
**Created:** [October 8, 2008, 6:54pm UTC](https://forum.kirupa.com/t/mysql-syntax-error/272828 "2008-10-08T18:54:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kajico](https://avatars.discourse-cdn.com/v4/letter/k/3d9bf3/32.png) [@Kajico](https://forum.kirupa.com/u/Kajico)\
**Post date:** [October 8, 2008, 6:54pm UTC](https://forum.kirupa.com/t/mysql-syntax-error/272828/1 "2008-10-08T18:54:29Z")

</div>

I get the following error, and maybe I’m blind but I just don’t see what’s causing it

> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OR,TABCOUNT,CID) VALUES (“ORMISA10009”,“1”,"fontsel = Arial,fontsize = 8,Line1 =’ at line 1

this is the SQL query

```auto
Insert into tabs (OID,TABSETNO,T1,T2,T3,T4,T5,T6,T7,T8,OR,TABCOUNT,CID) VALUES 
("ORMISA10009",
"1",
"fontsel = Arial,fontsize = 8,Line1 = ,Line2 = ,Line3 = ,color = Yellow,L1B = ,L1I = ,L1U = ,L2B = ,L2I = ,L1U = ,L3B = ,L2I = ,L1U = ",
"fontsel = Arial,fontsize = 8,Line1 = ,Line2 = ,Line3 = ,color = Clear,L1B = ,L1I = ,L1U = ,L2B = ,L2I = ,L1U = ,L3B = ,L2I = ,L1U = ",
"fontsel = Arial,fontsize = 8,Line1 = ,Line2 = ,Line3 = ,color = Clear,L1B = ,L1I = ,L1U = ,L2B = ,L2I = ,L1U = ,L3B = ,L2I = ,L1U = ",
"fontsel = Arial,fontsize = 8,Line1 = ,Line2 = ,Line3 = ,color = Clear,L1B = ,L1I = ,L1U = ,L2B = ,L2I = ,L1U = ,L3B = ,L2I = ,L1U = ",
"",
"",
"",
"",
"LR",
"4",
"CID10005")

```

The SQL query is automatically generated and works with my other DB Queries, cept for this one, the only difference between this one and the other queries is that I don’t have these lines

```auto
 
"fontsel = Arial,fontsize = 8,Line1 = ,Line2 = ,Line3 = ,color = Clear,L1B = ,L1I = ,L1U = ,L2B = ,L2I = ,L1U = ,L3B = ,L2I = ,L1U = "

```

Appreciate any help…

P.S. The code does not originally break up into lines, I did that so it could be easier to read…