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!!
0 个评论
采纳的回答
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)' );
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File 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!