How to create database in SQlite? Explain with example.

Sure, here are the steps to create a database in SQLite:

1. Install SQLite: Before you create a database, you need to install SQLite. You can download it from the official SQLite website. After downloading, extract the files and install it.

2. Open SQLite: Open the SQLite command line. You can do this by typing sqlite3 in your terminal or command prompt.

3. Create a Database: To create a database, you use the command .open followed by the name of the database you want to create. If the database does not exist, SQLite will create it. For example, if you want to create a database named my_database, you would type .open my_database.db.

Here is an example:

sqlite3
.open my_database.db

4. Create a Table: After creating a database, you need to create a table to store data. You can create a table using the CREATE TABLE statement. For example, to create a table named employees with columns id, name, and salary, you would type:

CREATE TABLE employees(
   id INT PRIMARY KEY     NOT NULL,
   name           TEXT    NOT NULL,
   salary         REAL
);

5. Verify the Table Creation: You can verify if your table has been created successfully using the .tables command. This will list all the tables in your database.

6. Insert Data: You can now insert data into your table using the INSERT INTO statement. For example, to insert data into the employees table, you would type:

INSERT INTO employees (id,name,salary)
VALUES (1, 'John', 10000);

7. View Data: You can view the data in your table using the SELECT statement. For example, to view all data in the employees table, you would type:

SELECT * FROM employees;

Remember to end all your SQL commands with a semicolon.