here’s a screenshot

As the title says, my table books ‘id’ column is returning NULL, when it is set as PRIMARY KEY.

I am still only working with my terminal window, not with actual coding just yet. I just want to get this right before I move further.

For further context, my authors table is working fine. It auto-increments with it’s own PRIMARY KEY.

Did I miss a step?
Still a little new to SQL, please help. I am using sqLite3 as per my CS50 Harvard course suggested.

I’ve set books(id) as PRIMARY KEY expecting that sqLite3 to auto-increment it for me.