create table query using sqlite

6 次查看(过去 30 天)
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!!

采纳的回答

Walter Roberson
Walter Roberson 2017-8-12
Notice that cur is not returned in the example of creating a table:
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)' );
  2 个评论
nikhil nambiar
nikhil nambiar 2017-8-13
It doesnt work Matlab throws an error: to many output argument
nikhil nambiar
nikhil nambiar 2017-8-13
My apologies !! It does work. Thank you

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Introduction to Installation and Licensing 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by