SQL statement: CREATE TABLE EMP(id int, FirstName varchar(32), LastName varchar(32), dept int)Įxample 2 – Creating a table in a persistent SQLite database: Tables available in the in-memory database(main): Print("Name of the database object: %s"%(table)) Print("Listing tables from SQLite_master:") Print("Tables available in the in-memory database(main):") tables command will not work as it is not SQL.hence querying the SQLite_masterĬursorObject.execute("select * from SQLite_master where type=\"table\"") # Create a table in the in-memory databaseĬreateTable = "CREATE TABLE EMP(id int, FirstName varchar(32), LastName varchar(32), dept int)" # Create database connection to an in-memory databaseĬonnectionObject = nnect(":memory:") # -Example Python Program to create tables in-memory databases. Example Python programs are given that create tables in in-memory databases and disk file based databases.Įxample 1 – Creating a table in an in-memory SQLite database:.Once a database connection is obtained to an SQLite database, CREATE TABLE statement can be executed through a cursor object obtained using the connection object.A temp database is an in-memory SQLite database that will have one or more temporary tables.Regardless of the classification of in-memory and disk file based databases SQLite will have only one database as the main database and one database as the temp database.In-memory databases can me made and connected to by specifying the argument to the connect() function as “:memory:” instead of a file name.Databases present in other disk files can be attached to the database connection using the ATTACH statement, supported by the SQLite.This database will act as the main database. Using the connect() method of sqlite3 module a database connection can be created by specifying the name of the database file.
The sqlite3 module provides the interface for connecting to the SQLite database.In SQLite, tables can be created in the in-memory databases as well.Creating a table in SQLite involves first selecting a database file and loading it.
0 kommentar(er)
