Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
Sanskrit is the Holy and Divine language of India, written in Devanagari script which is also known for its clarity and beauty. Sanskrit belongs to the Indo-European languages family. The meaning of the word "Sanskrit" is refined, decorated and produced in perfect form. This is the oldest language ever attested on Earth.Covers A Larger PrecinctThough not for all the languages, Sanskrit is surely the mother of many languages, especially languages spoken in Northern India. Even many words from Dravidian languages are derived from Sanskrit. Almost all of the ancient kinds of literature such as the Vedas, Upanishads, Epics, Shastras, Puranas ... Read More
It won't be surprising for you to hear that mobile phone usage has been increasing day by day. With the launch of modern smartphones hitting the market, much of the population now expect to be able to do many everyday tasks through their mobile phones. As more and more people are using mobile phones over desktop it is clear that the mobile phone is taking over desktops for internet surfing.The fundamental thing for a website is that it should be mobile friendly; it should be designed in such a way that it is equally compatible with mobile phones as well ... Read More
Let’s say we have a database “business” with number of tables. If you want to Get the fields in each constraint, then use the below query.The below query is to get the fields in each one of those constraints −mysql> select * −> from information_schema.key_column_usage −> where constraint_schema = 'business';The following is the output −+--------------------+-------------------+--------------------------+---------------+--------------+------------------------------+--------------+------------------+-------------------------------+-------------------------+-----------------------+------------------------+ | CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | POSITION_IN_UNIQUE_CONSTRAINT | REFERENCED_TABLE_SCHEMA | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME | +--------------------+-------------------+--------------------------+---------------+--------------+------------------------------+--------------+------------------+-------------------------------+-------------------------+-----------------------+------------------------+ | def ... Read More
The Utilitarian ethics was proposed by John Stuart. According to this theory, the happiness or pleasure of the greatest number of people in society is considered as the greatest good. According to this philosophy, an action is morally right if its consequences lead to the happiness of people and wrong if they lead to their unhappiness.An example of this can be the removal of the reservation system in education and government jobs, which can really benefit the talent. But this could endanger the minority rights.Following are two main types of Utilitarianism.Act UtilitarianismRule Utilitarianism.Act UtilitarianismThe Act utilitarianism focuses on each situation ... Read More
MLA (Modern Language Association) is a body that assigns rules and regulations for research paper writing. MLA is popular worldwide and assigns various rules on Selecting a topic, compiling a working bibliography, outlining and writing drafts (to name a few).Selecting A TopicIn order to select a topic, different instructors and different courses offer widely varying degrees of freedom to students selecting topics for research papers. The instructor of a course in a specific discipline may supply a list of topics from which to choose or any, more generally, require that the paper relates to an important aspect of the course. MLA ... Read More
In the vast space around us, there are numerous galaxies present, which are known as large groups filled with stars, dust, and gases all held together due to gravity. All the galaxies are likely to contain stars, planets, moons, comets, asteroids, black holes, nebulae, dust, neutron stars etc.Just like our solar system that lies in the Milky Way galaxy, there are many galaxies in the space. Every galaxy moves at certain speed and exists in a certain shape. Our milky way galaxy is in the spiral shape with a bright bulge at its center.The famous astronomer Edwin Hubble studied the ... Read More
There are lots of ways to select NOT NULL column from two columns. The syntaxes are as follows:Case 1: Use IFNULL() function.The syntax is as follows:SELECT IFNULL(yourColumnName1, yourColumnName2) as anyVariableName from yourTableName;Case 2: Use coalesce() function.The syntax is as follows:SELECT COALESCE(yourColumnName1, yourColumnName2) as anyVariableName from yourTableName;Case 3: Use CASE statement.The syntax is as follows:SELECT CASE WHEN yourColumnName1 IS NOT NULL THEN yourColumnName1 ELSE yourColumnName2 END AS anyVariableName FROM yourTableName;Case 4: Use only IF().The syntax is as follows:SELECT IF (yourColumnName1 ISNULL, yourColumnName2, yourColumnName1) AS NotNULLValue FROM SelectNotNullColumnsDemo;To understand the above syntax, let us create a table. The query to create a ... Read More
To know where MySQL store database files, you can use the variable @@datadir. The query is as follows −mysql> select @@datadir;The following is the output that displays the path −+---------------------------------------------+ | @@datadir | +---------------------------------------------+ | C:\ProgramData\MySQL\MySQL Server 8.0\Data\ | +---------------------------------------------+ 1 row in set (0.00 sec)Here is the snapshot where MySQL store database files i.e. the same path we got above −Now, let us verify whether ... Read More
Getting acquainted with local and foreign languages is opening the doors to plenty of opportunities. Languages like Hindi, Punjabi, Gujarati, Urdu, Tamil, Malayalam, Bengali and many other Indian languages as well as the foreign languages like French, German, Spanish, Arabic, Korean, Japanese, Chinese, Italian, Russian and Persian, etc. not only boost your chances of getting a job but also offer you an opportunity to get to know a completely diverse world with a unique viewpoint.Educational QualificationHowever, there is no educational qualification required to learn any language. You can choose any local or foreign language as a subject during your schooling. ... Read More
To add 30 days to a value in the table, you can use ADDDATE() function with UPDATE command. The syntax is as follows:UPDATE yourTableName SET yourDateColumnName=ADDDATE(yourDateColumnName, INTERVAL 30 DAY);To understand the above syntax, let us create a table. The query to create a table is as follows:mysql> create table Add30DayDemo -> ( -> Id int NOT NULL AUTO_INCREMENT, -> ShippingDate date, -> PRIMARY KEY(ID) -> ); Query OK, 0 rows affected (0.76 sec)Insert some records in the table using insert command. The query is as follows:mysql> insert into Add30DayDemo(ShippingDate) values('2019-02-04'); Query OK, 1 row affected ... Read More