Questions about create table in sqlite3 of python

Question

I am using sqlite3 with Python 2.7. I am learning how to create table in a database, so when I want to see whether it is created or not I use command .tables but that gives me an error:

invalid syntax

Here is the code

import sqlite3
conn = sqlite3.connect('raman.db')
c = conn.cursor()
c.execute("CREATE table new(ID INT NOT NULL)")

There should be a master table in your database containing info on the tables the database contains, the variable types, etc. Try querying that one for names if I remember correctly — Ma0
– Ma0, Commented Jun 6, 2017 at 9:01
So the code that gives you the error is not the code you have posted here. This is a problem. Post the code that fails. — Ma0
– Ma0, Commented Jun 6, 2017 at 9:06
or i will run above commands in python 2.7 and after that if i want to see that it is create or not, i use .tables. THere it gives me invalid syntex — Yashwanth S Prabhu
– Yashwanth S Prabhu, Commented Jun 6, 2017 at 9:06

Tiny.D · Accepted Answer · 2017-06-13 04:49:49Z

1

Just execute:

c.execute("SELECT * FROM sqlite_master WHERE type='table'").fetchall()

It will give you tables infor:

[(u'table', u'new', u'new', 2, u'CREATE TABLE new(ID INT NOT NULL)')]

Update: Put below code in you py file:

import sqlite3
conn = sqlite3.connect('raman.db')
c = conn.cursor()
c.execute("CREATE table new(ID INT NOT NULL)")
print c.execute("SELECT * FROM sqlite_master WHERE type='table'").fetchall()  #check table info new
c.execute("CREATE table Raman(ATOMIC NUMBER INT, SYMBOL TEXT, ROW INT , COLUMN INT)")
c.execute("INSERT INTO Raman VALUES(1,'H',1,'1')")
conn.commit()
print c.execute("select * from Raman").fetchall() #get data from table Raman
conn.close()

Run the py file in your terminal, it will print:

[(u'table', u'new', u'new', 2, u'CREATE TABLE new(ID INT NOT NULL)')]
[(1, u'H', 1, 1)]

edited Jun 13, 2017 at 4:49

answered Jun 6, 2017 at 9:17

Tiny.D

6,5562 gold badges18 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Yashwanth S Prabhu Over a year ago

In terminal if write the codes its working! But when i write this editor and run the file in terminal, it doesnt work. import sqlite3 conn = sqlite3.connect('raman.db') c = conn.cursor() c.execute("SELECT * FROM sqlite_master WHERE type='table'").fetchall() conn.commit() conn.close()

Tiny.D Over a year ago

please note that you have already created the table in raman.db, try with a new db like raman1.db , or drop the table.

Yashwanth S Prabhu Over a year ago

actually it should shoe me the table , as i ryn this command it gives nothing. i am writing in gedit editor.

Yashwanth S Prabhu Over a year ago

Okay. That's perfect. Learned to drop also

Yashwanth S Prabhu Over a year ago

Now I have added 4 columns in my table. c.execute("CREATE table Raman(ATOMIC NUMBER INT, SYMBOL TEXT, ROW INT , COLUMN INT)") and I want to insert values for them in the table so I am writing c.execute("INSERT INTO new VALUES(1,'H',1,'1')"); After this if I print the table its not showing me the inserted values

|

Collectives™ on Stack Overflow

Questions about create table in sqlite3 of python

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related