Category: MySQL


Feb
2022

What is Software Testing Life Cycle (STLC)?

categories: jQuery, Laravel, Mautic, MySQL, PHP, Wordpress, YII

Software Testing Life Cycle (STLC) is a sequence of different activities performed during the software testing process.

Phases of STLC:

  1. Requirement Analysis:
    Requirement Analysis is the first step of Software Testing Life Cycle (STLC). In this phase quality assurance team understands the requirements like what is to be tested. If anything is missing or not understandable then quality assurance team meets with the stakeholders to better understand the detail knowledge of requirement.
  2. Test Planning:
    Test Planning is most efficient phase of software testing life cycle where all testing plans are defined. In this phase manager of the testing team calculates estimated effort and cost for the testing work. This phase gets started once the requirement gathering phase is completed.
  3. Test Case Development:
    The test case development phase gets started once the test planning phase is completed. In this phase testing team note down the detailed test cases. Testing team also prepare the required test data for the testing. When the test cases are prepared then they are reviewed by quality assurance team.
  4. Test Environment Setup:
    Test environment setup is the vital part of the STLC. Basically test environment decides the conditions on which software is tested. This is independent activity and can be started along with test case development. In this process the testing team is not involved. either the developer or the customer creates the testing environment.
  5. Test Execution:
    After the test case development and test environment setup test execution phase gets started. In this phase testing team start executing test cases based on prepared test cases in the earlier step.
  6. Test Closure:
    This is the last stage of STLC in which the process of testing is analyzed.

Dec
2020

What is SQL? What are the types available in SQL?

categories: MySQL, PHP

Structured Query Language, or SQL, is the standard language used to communicate with a database, and or change records and user privileges, and perform queries. The Language, which became an ANSI standard in 1989, is currently used by almost all of today’s commercial RDBMS.

Types of SQL

  • Data Definition Language(DDL)
  • Data Manipulation Language(DML)
  • Data Control Language(DCL)

Feb
2020

What is the difference between BLOB AND TEXT in MySQL?

categories: MySQL, PHP

A BLOB is a binary large object that can hold a variable amount of data. There are four types of BLOB

  • TINYBLOB
  • BLOB
  • MEDIUMBLOB and
  • LONGBLOB

They all differ only in the maximum length of the values they can hold.

A TEXT is a case-insensitive BLOB. The four TEXT types

  • TINYTEXT
  • TEXT
  • MEDIUMTEXT and
  • LONGTEXT

They all correspond to the four BLOB types and have the same maximum lengths and storage requirements.

The only difference between BLOB and TEXT types is that sorting and comparison is performed in case-sensitive for BLOB values and case-insensitive for TEXT values.


Feb
2020

Difference between CHAR and VARCHAR?

categories: MySQL, PHP

Following are the differences between CHAR and VARCHAR:

  • CHAR and VARCHAR types differ in storage and retrieval
  • CHAR column length is fixed to the length that is declared while creating table. The length value ranges from 1 and 255
  • When CHAR values are stored then they are right padded using spaces to specific length. Trailing spaces are removed when CHAR values are retrieved.