How do I add data to a table in SQLite Studio? (error occuring)

Question

I am using SQLite Studio version 3.0.7 (which I assume is the latest version) to create a table. I have added 2 columns (name and age), and now I wish to add data into the table (eg. John age 30, Adam age 50).

However, it's not actually letting me add any data into the table. The 'Populate table' icon is grey and won't let me click on it. I have attached a screenshot to show you what I mean. What could be the problem?

enter image description here

score 0 · Accepted Answer · answered Apr 03 '16 at 22:36

0

This is a new table you are creating. After you decided about all columns you want to have in it you need to commit it using green button - on the left from "populate". Then you will be able to populate the table and do other things with it.

answered Apr 03 '16 at 22:36

Googie

5,742
2
19
31

Thanks, works now. Can't believe I didn't figure that out myself, lol! – DinnerPlate Apr 03 '16 at 23:28

How do I add data to a table in SQLite Studio? (error occuring)

1 Answers1