You can also use SQLite for your websites and apps if it doesn’t need to store too much data. SQLite uses less memory, so it is ideal for embedded systems like Android. It does not have any dependencies like other big databases. That means we can use reference value for another table as per requirement.SQLite is a lightweight file based database system. In the above example, we created two different tables and references to each other, as shown in the above example.
Insert into item (item_type, item_id) values (“A”, 1) Now perform the insert operation as follows. End result of the above statement is shown below screenshot as follows.Ĭreate table item (item_type text primary key, item_id integer) Ĭreate table item_price (price integer primary key, item_name text not null, item_type text REFERENCES item (item_type)) In the above example, we use a select statement to print all the product table’s inserted values. Now we need to print inserted records as follows. We set a default value for the product_Type column, which means there is no need to insert that value it automatically sets the default value as per user requirement.
In the above example, we use to insert into the statement to insert records into the product table. Now perform insert operation in the product as follows. End result of the above statement as shown in below screenshot as follows. See here column name product_type has a value A, B, and C same like emu (“A”,” B”, “C”). Also, we set the limit with a default value, product_Version with the text data type, and here we use check constraint, and also we set the limit with a default value and company_id with integer data type with default constraint as shown in the above statement. Also, we set the limit, product_Type with a text data type, and here we use check constraint and here we set a default value is A, product_Field with text data type and here we use check constraint. In the above example, we use create table statement to create a new table name as a product with a different attribute such as product_id with integer data type and primary key constraint, product_Name with text data type and here we use check constraint. Product_Version TEXT CHECK( LENGTH(product_Version) <= 50 ) NULL DEFAULT NULL, Product_Field TEXT CHECK( LENGTH(product_Field) <= 40 ) NULL DEFAULT NULL, Product_Name TEXT CHECK( LENGTH(product_Name) <= 50 ) NOT NULL DEFAULT '', product_Type TEXT CHECK( product_Type IN ('A','B','C') ) NOT NULL DEFAULT 'A', Now let’s see the different examples of SQLite enum as follows.įirst, create a new table by using the following statement as follows. The value does not meet the requirement the then SQLite terminates the statement. When we use a check constraint in a statement, then it allows us to define the specified expression to check whether inserted values are correct or not within a specified column. Sometimes we need to store multiple values in a single column at that, we can use enum data type in MySQL, but in SQLite, we can use a check constraint instead of an enum data type to get the desired outcome as per the requirement. So the above-listed data type we can use in SQLite to implement enum. TEXT (size): it is equivalent to the TEXT data types in the SQLite database, the size parameter is ignored. TINYTEXT (size): it is equivalent to the TEXT data types in the SQLite database, the size parameter is ignored. VARCHAR (size): It is also equivalent to the TEXT data types in the SQLite database, the size parameter is ignored. Text: This class is used to store the string value in the database.īlob: This class is used to store the exact value that we need as input.ĬHAR (size): It is equivalent to the TEXT data types in the SQLite database, the size parameter is ignored. Real: This class is used to store the floating values, and the size of this class is 8 bytes. Integer: it is used to store the integer value in bytes, and it depends on the magnitude of value. Null: This storage is used to store the null value. SQLite has the following data types as follows.
0 kommentar(er)
