max. number of columns??

[erite]

Hello all,
I am here to know what is the maximum number of columns that an INSERT statement can handle? Actually, i need to insert 15 values in a table.

INSERT INTO myTable (col1, col2, col3,....., col15) VALUES (v1, v2, v3,...., v15).

Actual statement:

"INSERT INTO BillSell (bnumber, stock, qty, price, tprice, seen, bill_id, brokerage, service_tax, brok_st, stt, brok_st_stt, total_cost, total_rate_pu, check) VALUES ('ICICI 06-12-2004 reshma', 'RELIND', 10, 541.7375183271872, 5417.375183271873, 'no', 2402, 40.2375, 4.92507, 45.162569999999995, 6.771718979089841, 51.934288979089835, 5365.0, 536.5, 'check')"


Java program asks me to check the syntax of the statement as follows :

"com.mysql.jdbc.exceptions.MySQLSyntaxErrorExcepti on: 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 'check) VALUES ('ICI -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[gilbert]

"Check" is a reserved word. If you want to use it for a column name, you have to `back-quote` it. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --