SQLite – CREATE Table SQLite CREATE TABLE statement is used to create a new table in any of the given database. Creating a basic table involves naming the table and defining its columns and each column”s data type. Syntax Following is the basic syntax of CREATE TABLE statement. CREATE TABLE database_name.table_name( column1 datatype PRIMARY KEY(one […]
Category Archives: sqlite
SQLite – Quick Guide SQLite – Overview This chapter helps you understand what is SQLite, how it differs from SQL, why it is needed and the way in which it handles the applications Database. SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is one of the fastest-growing […]
SQLite – Date & Time SQLite supports five date and time functions as follows − Sr.No. Function Example 1 date(timestring, modifiers…) This returns the date in this format: YYYY-MM-DD 2 time(timestring, modifiers…) This returns the time as HH:MM:SS 3 datetime(timestring, modifiers…) This returns YYYY-MM-DD HH:MM:SS 4 julianday(timestring, modifiers…) This returns the number of days since […]