MATLAB: Create table query using sqlite

Question

Hi,

I need to know how can I create table in sqlite database using exec. I have created connection object

con=sqlite('dbname.db','create');

I tried exec to create table for above database

curs=exec(conn,create table Atable('sno int primary key,xyz long, adb long'));

matlab throws an error with:

curs=exec(conn,create table R&DE('sno int primary key,latitude long, longitude long'));
                       ↑
Error: Unexpected MATLAB expression.

Next I tried doing

curs=exec(con,['create table R&DE(sno int primary key,latitude long, longitude long)']);
Error using sqlite/exec
Too many output arguments.

A solution or advice to this will be valuable

Thank you!!

Answer 1

Notice that cur is not returned in the example of creating a table:

https://www.mathworks.com/help/database/ug/exec.html#bu536by

exec(con, 'create table R&DE(sno int primary key,latitude long, longitude long)' );

Note: you might need to quote that table name:

exec(con, 'create table "R&DE"(sno int primary key,latitude long, longitude long)' );