Using Wildcard in Bash Shell

Wildcard characters are used to define the pattern for searching or matching text on string data in the bash shell. It is also used to create regular expressions. They are the special characters used as part of glob patterns. To use such a wildcard successfully, it must be outside of [...]

2021-07-30T19:13:18+05:30Categories: Programming|Tags: |

Use of final Keyword in C++

final keyword specifies that a virtual function cannot be overridden in a derived class. It also specifies that a class cannot be inherited from. It ensures that the function is virtual, otherwise a compile-time error is generated. Similarly when used in a class definition, it ensures that class cannot be [...]

2021-07-30T18:05:32+05:30Categories: Programming|Tags: |

Case Statement in Bash Script

case statement in bash shell is similar to switch statement in C++. It can be used to test simple values like integers and characters. Bash shell checks the condition, and controls the flow of the program. The case construct also allows us to test strings against patterns that can contain [...]

2021-07-28T20:40:00+05:30Categories: Programming|Tags: |

Create Virtual Environments in Python

Introduction With one Python installation, it may not be possible to meet the requirements of every application. One application may needs version 1.0 of a particular module but other application may needs version 2.0 of this module. In this case requirements are in conflict and installing either version 1.0 or [...]

2021-07-07T19:34:05+05:30Categories: Programming|

Basics of Vim Text Editor

Vim text editor is used for creating, editing and perform other operations in a text file. Common modes in Vim i.e. Normal Mode : Hit the Esc key to enter Normal mode.Command Mode : Type colon ( : ) in the normal mode to go to this mode.Insert Mode : [...]

2021-07-06T17:06:49+05:30Categories: Programming|

Comparison Between MySQL and SQLite

Relational Database Management Systems (RDBMS) are based on the relational model invented by Edgar F. Codd. They store data in the form of tables, and allow the data to be linked by establishing a relationship between the tables. MySQL and SQLite are both based on the relational database management system [...]

2020-10-02T22:45:39+05:30Categories: Programming|Tags: |

What is Schema in SQL ?

A schema is a collection of database objects (tables, views, functions, indexes ,etc) associated with one particular database username. This username is called the schema owner. A database can have one or multiple schemas. An object within a schema is qualified using the schema_name.object_name format. Say a user's database username [...]

2020-09-30T13:14:36+05:30Categories: Programming|Tags: , |


TRUNCATE TABLE statement empties a table completely. Logically, it is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. Syntax Following is the syntax of TRUNCATE TABLE statement: TRUNCATE [TABLE] table_name; It will delete all data in a table table_name. [...]

2020-09-29T17:09:25+05:30Categories: Programming|Tags: |

Create Database in MySQL

A database is a directory that contains all files which correspond to tables in the database. To create a new database in MySQL, use following syntax: CREATE DATABASE [IF NOT EXISTS] database_name [CHARACTER SET charset_name] [COLLATE collation_name] It will create a new database, where database_name : Name of the database. [...]

2020-09-29T15:24:30+05:30Categories: Programming|Tags: , |
Go to Top