In the last episode (Nov 04), Louie Miranda said: > I did create a table and a fieldname of 1 and 2. when i did enter > this query to insert on my sql, it causes error. > > insert into rates_fedex (weight_kg,a,b,c,d,e,f,g,h,1,2) values ** > > error: ERROR 1064: 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 '1,2) values > (".5","10.4","17.33","19.64","21.42","22.58","24.26 > > How do we insert properly something on a field with that the name is > numbers? or that aint right, im wrong.
Put backtics around any table or field name that might be misparsed by mysql. This lets you use numbers, spaces, or even reserved words: insert into rates_fedex (weight_kg,a,b,c,d,e,f,g,h,`1`,`2`) values If you look at the queries generated by myodbc, you'll see this a lot (it plays safe and quotes everything) -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]