My Blog

Author: admin

  • Tutorial

    —

    by

    admin
    in

    Twitter Bootstrap is the most popular front end framework in the recent time. It is sleek, intuitive, and powerful mobile first front-end framework for faster and easier web development. It uses HTML, CSS and Javascript. This tutorial will teach you the basics of Bootstrap 5 Framework using which you can create web projects with ease.…

  • MySQL HAVING Clause

    —

    by

    admin
    in

    MySQL HAVING Clause is used with GROUP BY clause. It always returns the rows where condition is TRUE. Syntax: Parameters aggregate_function: It specifies any one of the aggregate function such as SUM, COUNT, MIN, MAX, or AVG. expression1, expression2, … expression_n: It specifies the expressions that are not encapsulated within an aggregate function and must be included…

  • MySQL GROUP BY Clause

    —

    by

    admin
    in

    The MYSQL GROUP BY Clause is used to collect data from multiple records and group the result by one or more column. It is generally used in a SELECT statement. You can also use some aggregate functions like COUNT, SUM, MIN, MAX, AVG etc. on the grouped column. Syntax: Parameters expression1, expression2, … expression_n: It specifies…

  • MySQL ORDER BY Clause

    —

    by

    admin
    in

    The MYSQL ORDER BY Clause is used to sort the records in ascending or descending order. Syntax: Parameters expressions: It specifies the columns that you want to retrieve. tables: It specifies the tables, from where you want to retrieve records. There must be at least one table listed in the FROM clause. WHERE conditions: It is optional. It…

  • MySQL FROM Clause

    —

    by

    admin
    in

    The MySQL FROM Clause is used to select some records from a table. It can also be used to retrieve records from multiple tables using JOIN condition. Syntax: Parameters table1 and table2: specify tables used in the MySQL statement. The two tables are joined based on table1.column1 = table2.column1. Note: MySQL FROM Clause: Retrieve data from…

  • MySQL Distinct Clause

    —

    by

    admin
    in

    MySQL DISTINCT clause is used to remove duplicate records from the table and fetch only the unique records. The DISTINCT clause is only used with the SELECT statement. Syntax: Parameters expressions: specify the columns or calculations that you want to retrieve. tables: specify the name of the tables from where you retrieve records. There must be at…

  • MySQL WHERE Clause

    —

    by

    admin
    in

    MySQL WHERE Clause is used with SELECT, INSERT, UPDATE and DELETE clause to filter the results. It specifies a specific position where you have to do the operation. Syntax: Parameter: conditions: It specifies the conditions that must be fulfilled for records to be selected. MySQL WHERE Clause with single condition Let’s take an example to…

  • Difference between MySQL Clustered and Non-Clustered Index

    —

    by

    admin
    in

    The difference between clustered and non-clustered index is the most famous question in the database related interviews. Both indexes have the same physical structure and are stored as a BTREE structure in the MySQL server database. In this section, we are going to explain the most popular differences between them. Indexing in MySQL is a…

  • MySQL Clustered Index

    —

    by

    admin
    in

    An index is a separate data structure that allows us to add indexes in the existing table. It enables you to improve the faster retrieval of records on a database table. It creates an entry for each value of the indexed columns. A clustered index is actually a table where the data for the rows…

  • MySQL UNIQUE INDEX

    —

    by

    admin
    in

    Indexing is a process to find an unordered list into an ordered list that allows us to retrieve records faster. It creates an entry for each value that appears in the index columns. It helps in maximizing the query’s efficiency while searching on tables in MySQL. Without indexing, we need to scan the whole table to…