Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
A shell script is a list of commands in a computer program that is run by the Unix shell which is a command line interpreter. A shell script usually has comments that describe the steps. The different operations performed by shell scripts are program execution, file manipulation and text printing. A wrapper is also a kind of shell script that creates the program environment, runs the program etc.Types of ShellsThere are two major types of shells in Unix. These are:Bourne ShellThis is the default shell for version 7 Unix. The character $ is the default prompt for the bourne shell. ... Read More
As we know that \G option sends the command to MySQL server for execution and with the help of Semicolon (;) MySQL determines the end of the statement. It is also known that both of them have a different format of the result set.Now, if we will use both of those in MySQL statement then the output would be produced on the basis that which of them is encountered first by MySQL. For others, MySQL will produce an error. It can be understood with the help of the following example −mysql> Select CURDATE();\G +------------+ | CURDATE() | +------------+ | 2017-11-06 ... Read More
As we know that built-in-commands (\G and \g) send the command to MySQL server for execution and with the help of Semicolon (;) MySQL determines the end of the statement. It is also known that both of them have different format of the result set. For combining them and getting the result without error, we need to write two queries, one query with either \G or \g and other with a semicolon (;) at the end, in a single statement.ExampleCombining \G and Semicolon (;) −mysql> Select * from student\G select * from ratelist; *************************** 1. row *************************** Name: Gaurav ... Read More
An Application Programming Interface (API) contains software building tools, subroutine definitions as well as communication protocols that facilitate interaction between systems. An API may be for a database system, operating system, computer hardware or a web-based system.An Application Programming Interface makes it simpler to use certain technologies to build applications for the programmers. API can include specifications for data structures, variables, routines, object classes, remote calls etc.A diagram that shows the API in the system is as follows −Uses of Application Programming InterfacesAPI’s are useful in many scenarios. Some of these are given in detail as follows −Operating SystemsThe interface ... Read More
A command line interpreter allows the user to interact with a program using commands in the form of text lines. It was frequently used till the 1970’s. However, in modern times many command line interpreters are replaced by graphical user interfaces and menu-driven interfaces.Usage of Command Line InterpretersCommand line interpreters are more useful than graphical user interfaces in some cases. Details about these cases are given as follows:Command line interpreters have a large range of commands and queries available for different operations. Also, it is much faster to type than to click as is done using graphical user interfaces.There are ... Read More
Clustered systems are similar to parallel systems as they both have multiple CPUs. However a major difference is that clustered systems are created by two or more individual computer systems merged together. Basically, they have independent computer systems with a common storage and the systems work together.A diagram to better illustrate this is −The clustered systems are a combination of hardware clusters and software clusters. The hardware clusters help in sharing of high performance disks between the systems. The software clusters makes all the systems work together .Each node in the clustered systems contains the cluster software. This software monitors ... Read More
Clustered systems are similar to parallel systems as they both have multiple CPUs. However a major difference is that clustered systems are created by two or more individual computer systems merged together. Basically, they have independent computer systems with a common storage and the systems work together.Clustered System StructureThe structure of a clustered system is given as follows −Some details about the above structure are −The clustered system contains tightly couples individual nodes. However, the degree of coupling in the system may vary. Some jobs may require constant communication between the nodes while there are also jobs that may only ... Read More
Computer Storage contains many computer components that are used to store data. It is traditionally divided into primary storage, secondary storage and tertiary storage. Details about these storage types and devices used in them are as follows −Primary StoragePrimary storage is also known as the main memory and is the memory directly accessible by the CPU. Some primary storage devices are −ROMROM is read only memory. This memory cannot be changed, it can only be read as required. Since ROM is unchangeable memory, it is used by data and programs that are frequently required and seldom changed, like the system ... Read More
With the help of the MySQL SUM() function, we can get the total value by category in one output row. For example in table ‘ratelist’ if we want to get the total value of category ‘price’ then we can use SUM() on price as follows −mysql> select SUM(price) as totalprice from ratelist; +------------+ | totalprice | +------------+ | 3237 | +------------+ 1 row in set (0.00 sec)The query above returns the total value of price in one output row.
MySQL can manage the behavior of a transaction with the help of the following two modes −Autocommit OnIt is the default mode. In this mode, each MySQL statement (within a transaction or not) is considered as a complete transaction and committed by default when it finishes. It can be started by setting the session variable AUTOCOMMIT to 1 as follows −SET AUTOCOMMIT = 1 mysql> SET AUTOCOMMIT = 1; Query OK, 0 rows affected (0.07 sec)Autocommit OffIt is not the default mode. In this mode, the subsequent series of MySQL statements act like a transaction, and no activities are committed ... Read More