My Blog

Author: admin

  • Installation

    —

    by

    admin
    in

    All downloads for MySQL are located at MySQL Downloads. Pick the version number of MySQL Community Server which is required along with the platform you will be running it on. Installing MySQL on Windows In this tutorial, we are installing the latest version of MySQL (8.0.34) on Windows 11. Follow the given steps to do so − Step…

  • Variables

    —

    by

    admin
    in

    In general, variables are the containers that store some information in a program. The value of a variable can be changed as many times as required. Each variable has a datatype specifying the type of data we can store in it such as integer, string, float etc. Variables in MySQL The main purpose of a…

  • Versions

    —

    by

    admin
    in

    Versions are introduced in any product to upgrade by adding extra features and removing unnecessary ones, fixing the bugs etc. The process of versioning is actually important to make the product more efficient with growing technology. A product is generally released after performing phases of testing: alpha testing, beta testing, gamma testing, and then it…

  • 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…

  • DISTINCT Keyword

    —

    by

    admin
    in

    SQLite DISTINCT keyword is used in conjunction with SELECT statement to eliminate all the duplicate records and fetching only the unique records. There may be a situation when you have multiple duplicate records in a table. While fetching such records, it makes more sense to fetch only unique records instead of fetching duplicate records. Syntax Following is…

  • HAVING Clause

    —

    by

    admin
    in

    HAVING clause enables you to specify conditions that filter which group results appear in the final results. The WHERE clause places conditions on the selected columns, whereas the HAVING clause places conditions on groups created by GROUP BY clause. Syntax Following is the position of HAVING clause in a SELECT query. HAVING clause must follow…

  •  GROUP BY Clause

    —

    by

    admin
    in

    SQLite GROUP BY clause is used in collaboration with the SELECT statement to arrange identical data into groups. GROUP BY clause follows the WHERE clause in a SELECT statement and precedes the ORDER BY clause. Syntax Following is the basic syntax of GROUP BY clause. GROUP BY clause must follow the conditions in the WHERE clause and…

  • ORDER BY Clause

    —

    by

    admin
    in

    SQLite ORDER BY clause is used to sort the data in an ascending or descending order, based on one or more columns. Syntax Following is the basic syntax of ORDER BY clause. You can use more than one column in the ORDER BY clause. Make sure whatever column you are using to sort, that column should be…

  • LIMIT Clause

    —

    by

    admin
    in

    SQLite LIMIT clause is used to limit the data amount returned by the SELECT statement. Syntax Following is the basic syntax of SELECT statement with LIMIT clause. Following is the syntax of LIMIT clause when it is used along with OFFSET clause.SELECT column1, column2, columnN FROM table_name LIMIT [no of rows] OFFSET [row num] SQLite engine will…