Posted by petersprc on 07/05/07 04:21

Backticks can be used to quote mysql identifiers like tables and
columns, but not values like 6.3.

On Jul 4, 11:27 pm, cmk...@hotmail.com wrote:
> Hi
> If i execute mysql_query with this string:
> INSERT INTO `order`
> (`revisionFamily`,`revisionNumber`,`PI_ID`,`invoiceNumber`,`date`,`customerModel`,`country`,`brandname`,`productNumber`,`quantity`,`lorryType`,`deliveryDate`,`FONO`,`PONO`,`ISSUED`,`ISSUED_Department`,`fuseCustomText`,`powerCableText`,`vde`,`socketUL`,`socketCustom`,`socketCustomText`,`waveLengthAM`,`waveLengthMW`,`waveLengthFM`,`waveLengthLW`,`waveLengthSW`,`waveLengthCustom`,`waveText`,`outputW`,`cdYes`,`cdNo`,`remoteYes`,`remoteNo`,`carsetNo`,`cassetAuto`,`cassetAllStop`,`cassetHalfStop`,`cassetSoundNo`,`casset1`,`casset2`,`cassetModNo`,`cassetAC`,`cassetMagnet`,`cd33`,`cd45`,`cd78`,`cdAutoStop`,`cdText`,`led`,`ledText`,`lcd`,`backLightYes`,`backLightNo`,`backLightColor`,`dc`,`phono`,`spkJack`,`beatCut`,`75ohmApproval`,`75ohm2NonApproval`,`mic`,`6.3`,`speaker35`,`aux`,`plugOtherCheckBox`,`speakerStandard`,`speakerCustom`,`speaker1Way`,`speaker2Way`,`speaker3Way`,`speakerText`,`speakerColor`,`speakerOther`,`mainColor`,`packing`,`catalog`,`warrantyCard`,`caution`,`laserClass1`,`thermalFseFitted`,`voltage`,`cablePaper`,`soundCase`,`back`,`paperText`,`dateCode`,`serialNo`,`barcodeNoLabel`,`paperOther`,`paperOtherText`,`spare2Text`,`AQL`,`outerCase`,`qcCompany`,`madeInChina`,`remarksPhoto`,`remarks`,`socketOtherRemarks`,`stockOutPhoto`,`stockOutClosing`,`stockOutETD`,`stockOutETA`,`stockOutVessel`,`stockOutInvoiceNo`,`stockOutMateReceiptDate`,`shipmentWith2Weeks`,`destination`,`LCno`,`LSD`,`ChequeNo`,`qcDate`,`qcConfirm`,`engineNotesPhoto`,`engineNotes`,`marketingNotesPhoto`,`marketingNotes`,`qcNotesPhoto`,`qcNotes`,`tips`,`warrantyCardPhoto`,`plasticBag`,`cdSheet`,`customerConfirm`,`shipHead1`,`shipHead2`,`colorA`,`QtyA`,`colorB`,`QtyB`,`colorC`,`QtyC`,`posted`,`giftBoxAttachment`,`cosmeticAttachment`,`boxAttachment`,`catalogAttachment`)
> select
> `revisionFamily`,`revisionNumber`,`PI_ID`,`invoiceNumber`,`date`,`customerModel`,`country`,`brandname`,`productNumber`,`quantity`,`lorryType`,`deliveryDate`,`FONO`,`PONO`,`ISSUED`,`ISSUED_Department`,`fuseCustomText`,`powerCableText`,`vde`,`socketUL`,`socketCustom`,`socketCustomText`,`waveLengthAM`,`waveLengthMW`,`waveLengthFM`,`waveLengthLW`,`waveLengthSW`,`waveLengthCustom`,`waveText`,`outputW`,`cdYes`,`cdNo`,`remoteYes`,`remoteNo`,`carsetNo`,`cassetAuto`,`cassetAllStop`,`cassetHalfStop`,`cassetSoundNo`,`casset1`,`casset2`,`cassetModNo`,`cassetAC`,`cassetMagnet`,`cd33`,`cd45`,`cd78`,`cdAutoStop`,`cdText`,`led`,`ledText`,`lcd`,`backLightYes`,`backLightNo`,`backLightColor`,`dc`,`phono`,`spkJack`,`beatCut`,`75ohmApproval`,`75ohm2NonApproval`,`mic`,`6.3`,`speaker35`,`aux`,`plugOtherCheckBox`,`speakerStandard`,`speakerCustom`,`speaker1Way`,`speaker2Way`,`speaker3Way`,`speakerText`,`speakerColor`,`speakerOther`,`mainColor`,`packing`,`catalog`,`warrantyCard`,`caution`,`laserClass1`,`thermalFseFitted`,`voltage`,`cablePaper`,`soundCase`,`back`,`paperText`,`dateCode`,`serialNo`,`barcodeNoLabel`,`paperOther`,`paperOtherText`,`spare2Text`,`AQL`,`outerCase`,`qcCompany`,`madeInChina`,`remarksPhoto`,`remarks`,`socketOtherRemarks`,`stockOutPhoto`,`stockOutClosing`,`stockOutETD`,`stockOutETA`,`stockOutVessel`,`stockOutInvoiceNo`,`stockOutMateReceiptDate`,`shipmentWith2Weeks`,`destination`,`LCno`,`LSD`,`ChequeNo`,`qcDate`,`qcConfirm`,`engineNotesPhoto`,`engineNotes`,`marketingNotesPhoto`,`marketingNotes`,`qcNotesPhoto`,`qcNotes`,`tips`,`warrantyCardPhoto`,`plasticBag`,`cdSheet`,`customerConfirm`,`shipHead1`,`shipHead2`,`colorA`,`QtyA`,`colorB`,`QtyB`,`colorC`,`QtyC`,`posted`,`giftBoxAttachment`,`cosmeticAttachment`,`boxAttachment`,`catalogAttachment`
> from `order` where id=1
>
> I got an error, but if i execute it in mysql client, this sql is ok.
> why?
> thanks
> from Peter (cmk...@hotmail.com)

[Back to original message]