Matlab Database QueryDb error

Question

I need to insert some data into a mysql database. Db is connected and working. I am running the following code :

a = sprintf('%s',hashedStr); 
sqlQueryStr = 'insert into products (security_code) values (a)'
QueryDB(sqlQueryStr);

I have a database called test and a table named products with 2 fields id and security_code.

When I run this, I get :

Unknown column 'a' in fieldlist ...

Why is this happening ? i dont have and dont need this column ...

Any help ?

dani herrera · Accepted Answer · 2011-12-02 12:39:07Z

1

Try with:

sqlQueryStr = sprintf('insert into products (security_code) values ("%s")',hashedStr); 
QueryDB(sqlQueryStr);

problem is that you are not replacing "a" variable into sql expression

answered Dec 2, 2011 at 12:39

dani herrera

52k11 gold badges133 silver badges188 bronze badges

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

1 Answer 1