sqliteHow do I store and retrieve float values in SQLite?

Storing and retrieving float values in SQLite is a simple task. To store float values, you can use the REAL data type. For example, the following SQL statement creates a table with a float column:

CREATE TABLE mytable (
    id INTEGER PRIMARY KEY,
    value REAL
);

To insert float values into the table, use the INSERT INTO statement:

INSERT INTO mytable (value) VALUES (3.14);

To retrieve float values from the table, use the SELECT statement:

SELECT * FROM mytable;

The output would look something like this:

id    value
1     3.14

Code explanation

• CREATE TABLE statement - used to create a table with a float column
• INSERT INTO statement - used to insert float values into the table
• SELECT statement - used to retrieve float values from the table

Here are some ## Helpful links

• SQLite Data Types
• SQLite INSERT
• SQLite SELECT

Edit this code on GitHub