Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
Poems are different and similar in the manner and matter they possess. The manner in which a poet expresses his ideas deal with literary devices such as simile, metaphor, hyperbole, contrast, repetition, imagery etc. Both simile and metaphor are used as comparative literary devices.Comparison Between Simile and MetaphorSimile - Similes are used to compare attributes of two objects or persons using words like or as. It must be noted that use of like or as always does not imply the presence of a simile. What is important is a direct comparison taking place.For Example, Her cheeks are red as a rose.In ... Read More
To update values incrementally in MySQL, you need to create a variable with the help of SET command. The syntax to create a variable is as follows −set @anyVariableName := 0;To update value, you need to use UPDATE command. Let us begin with creating a table. The query to create a table −mysql> create table UpdateValueIncrementally −> ( −> ProductId int −> ); Query OK, 0 rows affected (0.90 sec)Insert records in the table with the help of select statement. The query is as follows −mysql> insert into UpdateValueIncrementally values(10); Query ... Read More
First, determine the type of MySQL database i.e. whether its engine is InnoDB or MyISAM. To achieve this, use engine column from the information_schema.columns.tables.The syntax is as follows.SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ’yourDatabaseName’ AND TABLE_NAME = ’yourTableName’;Here, I have a table with the name ‘StudentInformations’ −mysql> create table StudentInformations -> ( -> StudentId int not null auto_increment, -> StudentFirstName varchar(20), -> StudentLastName varchar(20), -> Primary Key(StudentId) -> ); Query OK, 0 rows affected (0.57 sec)Now you can know the table is using InnoDB or MyISAM using the implementation of above syntax. Our ... Read More
Simulation and EmulationEmulation is the process of the replica of the visible behavior in order to match the existing target. The inner state of this mechanism does not need to reflect the internal state of the target precisely. The emulator is used in order to emulate.Simulation, in fact, involves modeling the inner state of the target to which stimulation is done. The end result of a noble simulation is that this mechanism will emulate the target that it is simulating. A simulator does this process.Except for the actual definition, the other points of difference between the Simulator and an Emulator ... Read More
You need to use LOCATE() along with SUBSTR(). The below syntax will find the word after delimiter. Here, delimiter is colon(:), you can use another i.e. it is up to you. The syntax is as follows −SELECT SUBSTR(yourColumnName, LOCATE(':', yourColumnName)+1, (CHAR_LENGTH(yourColumnName) - LOCATE(':', REVERSE(yourColumnName)) - LOCATE(':', yourColumnName))) AS anyAliasName FROM yourTableName;To understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table SearchTextBetweenDelimitersDemo -> ( -> ... Read More
Religion today has taken a much-institutionalized form. Its origin has always been debated and discussed today by various scholars. In sociological terms, ‘Religion is a system of sacred belief and practices both in the tangible and intangible form’. Religion can serve the dual role of ideology as well as institution. Today, religion has assumed a more narrow-minded approach. However, understanding religion in the broad sense highlights the following important points about it in society:Cultural IdentityReligion plays a crucial role for a person in giving a cultural identity. Each religion has festivals, traditions, mythologies which form a part of the tangible ... Read More
You can use WHERE clause and OR operator to show table with multiple LIKE. The syntax is as follows:show table from yourDatabaseName where tables_in_yourDatabaseName Like ‘%anyTableName%’ or tables_in_yourDatabaseName Like ‘%anyTableName2%’ or tables_in_yourDatabaseName Like ‘%anyTableName3%’ . . . . or tables_in_yourDatabaseName Like ‘%anyTableNameN%’In the above syntax, only the table name in the database is displayed.Here the database ‘test’ and the tables in the same database is considered. The query to show tables with multiple LIKE is as follows -mysql> show tables from test -> where tables_in_test like '%userrole%' -> or tables_in_test like '%view_student%' -> or tables_in_test like '%wholewordmatchdemo%';The following is the ... Read More
Select non-empty column values using NOT IS NULL and TRIM() function. The syntax is as follows.SELECT * FROM yourTableName WHERE yourColumnName IS NOT NULL AND TRIM(yourColumnName) ' ';You can select non-empty value as well as whitespace from column using the same TRIM() function.To understand the syntax we discussed above, let us create a table. The query to create a table is as follows −mysql> create table SelectNonEmptyValues -> ( -> Id int not null auto_increment, -> Name varchar(30), -> PRIMARY KEY(Id) -> ); Query OK, 0 rows affected (0.62 sec)Insert records in the table ... Read More
Literary Devices are the peculiar structures used by writers in their works in order to convey their messages in a simple manner to the readers.The various literary devices used in English Literature areAlliteration, Analogy, Allegory, Anaphora, Metaphor, Simile, Aphorism, Oxymoron, Onomatopoeia, Eulogy, Elegy, and others.Alliteration: It is the device in which a number of words, having the same first consonant sound, occur close together in a series.Example- He had a haunting hat.Analogy: It is the comparison of an idea or a thing with another. Metaphors and similes are used to draw analogies. A metaphor is an implied comparison while a ... Read More
Water is a very important resource not only for us but also for our future generations. We should; therefore, save it in order to provide the maximum benefit to others. Water is necessary for our lives. So, if we save water, we save life.However, one must either not be aware of the ways to conserve it or may be reluctant thinking that such work will require a lot of toil. Let's talk about the ways in which water can be conserved.Turn off the Tap Post Use: While we brush our teeth, water keeps spilling out. It is necessary to close ... Read More