How to insert variable value in mysql insert query?
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);
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
@threatDesc, @rtpcontrol, @trpNon...
- A Linux, Apache, MySQL, PHP (LAMP) stack is a combination of open source software that is typically installed together to enable a server to host dynamic […]
- MySQL is an the most popular open-source database management system, in most of hosting company its has been bundle by LAMP(Linux, Apache, MySQL, PHP/Python/Perl) stack. Another alternative […]
- MySQL is the world’s most popular open-source database. Despite its powerful features, MySQL is simple to set up and easy to use. Below are some instructions […]