My Blog

Author: admin

  • Features

    —

    by

    admin
    in

    MySQL is a type of relational database that stores and manages the data based on Structured Query Language (SQL) queries. Thus, making it a structured database, i.e., the data stored in this relational databases is in the form of tables. It is a fast, easy-to-use RDBMS being used for many small and big businesses, it…

  • Introduction

    —

    by

    admin
    in

    What is a Database? A database is used to store a collection of data (which can either be structured or unstructured). Each database has one or more distinct APIs for creating, accessing, managing, searching and replicating the data it holds. Other kinds of data storages can also be used to manage data, such as files…

  • MySQL Tutorial

    —

    by

    admin
    in

    MySQL Tutorial MySQL is the most popular and a free Open Source Relational Database Management System (RDBMS). An RDBMS system stores the data in the form of tables that might be related to each other. MySQL uses Structured Query Language (SQL) to store, manage and retrieve data, and control the accessibility to the data. It…

  • SQLite Expressions

    —

    by

    admin
    in

    SQLite Expressions are the combination of one or more values, operators and SQL functions. These expressions are used to evaluate a value. SQLite expressions are written in query language and used with SELECT statement. Syntax: There are mainly three types of SQLite expressions: 1) SQLite Boolean Expression SQLite Boolean expressions are used to fetch the…

  • SQLite Operators

    —

    by

    admin
    in

    SQLite operators are reserved words or characters used in SQLite statements when we use WHERE clause to perform operations like comparisons and arithmetic operations. Operators can be used to specify conditions and as conjunction for multiple conditions in SQLite statements. There are mainly 4 type of operators in SQLite: SQLite Arithmetic Operators The following table…

  • SQLite Data Types

    —

    by

    admin
    in

    SQLite data types are used to specify type of data of any object. Each column, variable and expression has related data type in SQLite. These data types are used while creating table. SQLite uses a more general dynamic type system. In SQLite, the datatype of a value is associated with the value itself, not with…

  • SQLite Commands

    —

    by

    admin
    in

    SQLite commands are similar to SQL commands. There are three types of SQLite commands: Data Definition Language There are three commands in this group: CREATE: This command is used to create a table, a view of a table or other object in the database. ALTER: It is used to modify an existing database object like a table.…

  • SQLite Installation

    —

    by

    admin
    in

    Install SQLite on Windows Follow the steps given below: AD The above method facilitates you a permanent way to create database, attach database and detach database. There is another way to execute CRUD operation in SQLite. In this method, there is no need to set a path. You can execute the SQLite query here. But…

  • SQLite Advantages

    —

    by

    admin
    in

    SQLite is a very popular database which has been successfully used with on disk file format for desktop applications like version control systems, financial analysis tools, media cataloging and editing suites, CAD packages, record keeping programs etc. There are a lot of advantages to use SQLite as an application file format: 1) Lightweight 2) Better…

  • SQLite Features/ Why to use SQLite

    —

    by

    admin
    in

    Following is a list of features which makes SQLite popular among other lightweight databases: