How to insert variable value in mysql insert query?

Question

I have written aa insert query in a stored procedure...

   INSERT INTO `ascencom_soa2`.`rardata` (`threatDescription`,`rtpControlObjective`,
  `rtpNonTechnical`,`rtpISOControl`,
  `rtpWorkInstructions`,`VulnerabilityDescription`,
  `assetname`,`companyid`,`assetid`)

  VALUES (threatDesc,rtpcontrol,
  rtpNon,rtpISO,
  rtpWork,rtpvulnarabilityDesc,
  idAsset,idCompany,idAssetType);

Here threatDesc, rtpcontrol, trpNon.... are variables and are initialized before the insert query is executed...

but it is give me error...

1054 : Unknown column 'threatDesc' in 'field list'

please help me with this problem

Are you trying to do this from within a MySQL client, or via PHP? — Tieson T.
– Tieson T., Commented Mar 9, 2012 at 5:37

Peter Kiss · Accepted Answer · 2012-03-09 05:37:38Z

2

@threatDesc, @rtpcontrol, @trpNon...

answered Mar 9, 2012 at 5:37

Peter Kiss

9,3292 gold badges25 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Robert Martin · Accepted Answer · 2012-03-09 05:38:53Z

0

It means there is no column threatDesc so you can't assign it as a value. My guess is that you either meant to put quotes around that and save it as a string, OR you are trying to assign from another table and you need to say tableName.threatDesc OR something else entirely.

answered Mar 9, 2012 at 5:38

Robert Martin

17.3k17 gold badges64 silver badges89 bronze badges

Collectives™ on Stack Overflow

How to insert variable value in mysql insert query?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related