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 [...]
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 [...]
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 [...]
Print function name in C printf("%s", __func__); Print line number and file name in C/C++ #define print(a, args...) printf("%s(%s:%d) " a, __func__,__FILE__, __LINE__, ##args)
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 : [...]
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 [...]
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 [...]
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. [...]
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. [...]
Views in SQL are the virtual tables. They have rows and columns like they are present in the normal database tables. But it fetches selective portion of the data from one or more tables. A view is a named query stored in the database catalog. Creating View To create a [...]