Create table

[gmgunderground]

Hi, how to create a table in LightDB Studio? CREATE Table doesn't work. What are the SQL commands supported?

Best regards GMG

[mbdavid]

Hi @gmgunderground, there is no create table. You can insert data into a new collection that will auto create this collection. Use:

INSERT INTO mycoll VALUES {_id:1, name: 'John'};

-- with auto-id int
INSERT INTO mycoll:INT VALUES {name:'John'}, {name:'Carlos'}

I'm working on LiteDB SQL documentation

[gmgunderground]

Very good! It's working. Thanks

[icodeintx]

I love this tool. I would like to see more documentation on script like mentioned above.