Bug #61664 ERROR 1054 (42S22): Unknown column 'CNC Machining Center (VT1055, 1000x560)' in
Submitted: 27 Jun 2011 22:46 Modified: 28 Jul 2011 7:38
Reporter: Kirill Zrazhevskiy Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.54-1ubuntu4 (Ubuntu) OS:Linux (Ubuntu 11.04)
Assigned to: CPU Architecture:Any

[27 Jun 2011 22:46] Kirill Zrazhevskiy 
Description:
Logical of this code is to put "CNC Machining Center (VT1055, 1000x560)" into `Name` field of database but it returns an unepected error instead. Please advice me any way to cross it over.

How to repeat:
mysql> CREATE TABLE IF NOT EXISTS CNC (Name Varchar(40),Packing VARCHAR(40),ModelNO VARCHAR(40),Standard VARCHAR(40),Productivity VARCHAR(40),UnitPricePayment VARCHAR(40),HSCode VARCHAR(40),Trademark VARCHAR(40),Origin VARCHAR(40),MinOrder VARCHAR(40),Transportation VARCHAR(40),ControllingMode VARCHAR(40),Type VARCHAR(40),AutomaticGrade VARCHAR(40),Controller VARCHAR(40),ExportMarkets VARCHAR(40), Other VARCHAR(40));

mysql> INSERT INTO CNC (`Name`, `Packing`, `ModelNO`, `Standard`, `Productivity`, `UnitPricePayment`, `HSCode`, `Trademark`, `Origin`, `MinOrder`, `Transportation`, `ControllingMode`, `Type`, `AutomaticGrade`, `Controller`, `ExportMarkets`, `Other`) VALUES (`CNC Machining Center (VT1055, 1000x560)`,`fully enclosed wooden case`,`VT1055`,`Ge, ISO`,`300 Sets/Per Year`,`L/C, TT`,`8457101000`,`Datian`,`made in China`,`1 set`,`by sea`,`CNC`,`Heavy-Duty Machine Tool`,`Automatic`,`Fanuc`,`North America, South America, Southeast Asia, Mid East, Eastern Asia, Western Europe`,` :  :  Precision:High Precision XYZAxisTravelMm:1000*560*610 WorktableSizeMm:1000*560 GuideRail:Box Type Guide Rails`);

ERROR 1054 (42S22): Unknown column 'CNC Machining Center (VT1055, 1000x560)' in 'field list'
[28 Jun 2011 7:38] Valeriy Kravchuk 
You should use singe quotes ('like this') or double quotes ("like this") to quote strings. Backticks (`column name`) can be used only to quote identifiers. Please, check.
[28 Jul 2011 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".