python - Table is not creating

Question

I am making little project with sqlite3, but table is not creating.

import sqlite3

conn = sqlite3.connect("test.sqlite")
c = conn.cursor()

c.execute('''CREATE TABLE students
             (rollno real, name text, class real)''')
            
        
conn.commit()
#close the connection
conn.close()

see photo

question from:https://stackoverflow.com/questions/65646434/table-is-not-creating

Answer 1

This is not a code error.

Please navigate to where you have the python file running/saved in the DB browser. File -> Open Database and select the test.sqlite file. You will then see something like this:

Code used:

import sqlite3

conn = sqlite3.connect("test.sqlite")
c = conn.cursor()

c.execute('''CREATE TABLE students
             (rollno real, name text, class real)''')
            
        
conn.commit()
#close the connection
conn.close()