Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
What is sharing, blogging and publishing?
The advancement of social media has introduced many terms to us. Some of those terms are sharing, blogging and publishing. Let us understand what do they mean.BloggingBlogging is one of them. Blogs are the pages where you can create the content and can share with the world. Writing your content in blogs is called Blogging. This content can be anything like stories, experiences, reviews, opinions, criticisms, explanations, etc. whichever you want to share with the world. The famous blogging site is blogspot.comPublishingPublishing is posting the content on to your blog page. By clicking this Publish, you are finalizing your content ...
Read MoreHow was the writing style of Wordsworth different from Coleridge?
Both, Wordsworth and Coleridge were famous poets of their time, but both received praise for their own distinct writing styles.ColeridgeSamuel Taylor Coleridge is a popular name among Romantic poets who were influenced by the French Revolution. He was a leader of the British Romantic movement and was born on October 21, 1772, in Devonshire, England.Features of Coleridge’s PoetryTreatment of the Supernatural: He treats the supernatural in such a manner that it becomes convincing and at the same time, in some sense, a criticism of life.Suspension of Disbelief: The way in which Coleridge has achieved the willing suspension of disbelief has ...
Read MoreWhat are the other expressions for the word 'Amazing'?
Stop using ‘Amazing’ and end up being considered an amateur! Rather, try these expressions instead and get labelled as seasoned.AdorableAlluringAmbrosialAstonishingAstoundingAwe-InspiringAwesomeBeauteousBeautifulBewitchingBeyond WordsBlue-ribbonBonnyBreathtakingBrilliantCapitalCaptivatingCharmingClassyDarlingDauntingDazzlingDelectableDelicateDeliciousDelightfulDevineElegantEnchantingEnthrallingEnticingEtherealExaltedExcellentExceptionalExhilaratingExquisiteExtraordinaryFabulous (absolutely, dahling!)FantasticFascinatingFearsomeFetchingFirst-classFirst-rateGloriousGorgeousGracefulGrandHeavenlyIdealImpressiveIncomparableInconceivable (for my fellow Princess Bride fans)IncredibleIndescribableIneffableInspiringIrresistibleLovelyLusciousMagneticMagnificentMajesticMarvelousMesmerizingOutstandingProdigiousRadiantRapturousRavishingRefinedResplendentSavoryScrumptiousSensualSexyShockingSpectacularSplendidStaggeringStrikingStunningStupefyingSublimeSuperbSupremeSurprisingTantalizingThrillingTop-notchTranscendentTremendousUnbelievableUnearthlyUnutterableUpliftingWonderfulWondrousYummyAnd, if you totally amazed then this one.... (+_ +)Amazeballs
Read MoreWhat kind of tragedy is depicted in the book King Lear?
Shakespeare is one of the greatest of all writers. He is the one who is remembered for only the magnanimity and grandeur of his works. The works of Shakespeare can be divided into three stages - historical, comedies, and tragedies. Out of the tragedies, King Lear is a melancholic tragedy written in 1605.Features of TragedyThe hero has a terrible flaw.The mood of foreboding follows the play.Hero has experiences of providence not favoring him.The end is usually the death of one or more people as a part of the play.If not death, there is a downfall of the hero which may ...
Read MoreCan we update MySQL with if condition?
You can update MySQL with IF condition as well as CASE statement. For this purpose, let us first create a table. The query to create a table −mysql> create table UpdateWithIfCondition −> ( −> BookId int, −> BookName varchar(200) −> ); Query OK, 0 rows affected (0.60 sec)Now you can insert records in the table using insert command. The query is as follows −mysql> insert into UpdateWithIfCondition values(1000, 'C in Depth'); Query OK, 1 row affected (0.12 sec) mysql> insert into UpdateWithIfCondition values(1001, 'Introduction to Java'); Query OK, 1 row affected (0.14 sec)Display all records ...
Read MoreWhat actually made Apple a trillion dollar company?
It’s been now 42 years when Steve Jobs, Steve Wozniak, and Ronald Wayne founded Apple Inc with a promise to keep revolutionizing lives and they have kept their promise too brilliantly until now. This is why they have done what other companies only wish to achieve. Congratulations Apple for setting another benchmark and bringing a significant change to the society through cutting-edge tech inventions.However, it was never easy. Check out the story of infinite passion, nerve-wracking struggle, and the never yielding self-will.Many people believe that Apple was founded only by Steve. Well, the reality is here. Apple was founded by ...
Read MoreHow to deal with 'Boolean' values in PHP & MySQL?
We are using MySQL version 8.0.12. Let us first check the MySQL version:mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.12 | +-----------+ 1 row in set (0.00 sec)To deal with Boolean in MySQL, you can use BOOL or BOOLEAN or TINYINT(1). If you use BOOL or BOOLEAN, then MySQL internally converts it into TINYINT(1).In BOOL or BOOLEAN data type, if you use true literal then MySQL represents it as 1 and false literal as 0 like in PHP/ C/ C++ language.To proof that MySQL convert the BOOL or BOOLEAN to TINYINT(1), let us create a table with ...
Read MoreHow to display the value of a variable on command line in MySQL?
To display the value of a variable, you can use select statement. The syntax is follows −SELECT @yourVariableName;Let us first create a variable. This can be done using SET command. The following is the syntax to create a variable −SET @yourVariableName = yourValue;Let us check the above syntax to create a variable and display the value of created variable.The following is the query to create a variable −mysql> set @FirstName = 'Bob'; Query OK, 0 rows affected (0.04 sec)Now you can display the value of a variable using select statement. The query is as follows −mysql> select @FirstName;The following is ...
Read MoreHow can I describe all tables in the database through a single statement in MySQL?
You can use INFORMATION_SCHEMA.COLUMNS to describe all tables in database through a single statement. The syntax is as follows.SELECT *FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA=’yourDatabaseName’\GHere I am using my database sample with two tables.The table names are as follows −mytableyourtableImplement the above syntax for your database. The query is as follows −mysql> select * FROM information_schema.columns WHERE table_schema = 'sample'\GThe following is the output describing the two tables in our database.*************************** 1. row *************************** TABLE_CATALOG: def TABLE_SCHEMA: sample TABLE_NAME: mytable COLUMN_NAME: id ORDINAL_POSITION: 1 COLUMN_DEFAULT: NULL IS_NULLABLE: YES DATA_TYPE: int CHARACTER_MAXIMUM_LENGTH: NULL CHARACTER_OCTET_LENGTH: NULL NUMERIC_PRECISION: 10 NUMERIC_SCALE: 0 DATETIME_PRECISION: NULL CHARACTER_SET_NAME: NULL ...
Read MoreMySQL query to extract first word from a field?
To extract first word from a field, use in-built SUBSTRING_INDEX() function. The syntax is as follows −SELECT SUBSTRING_INDEX(yourColumnName, ’ ‘, 1) as anyVariableName from yourTableName;In the above query, if you use -1 in place of 1 then you will get the last word. To understand the above concept, let us create a table. The following is the query to create a table.mysql> create table FirstWordDemo −> ( −> AllWords longtext −> ); Query OK, 0 rows affected (0.83 sec)Now insert some words in the table using insert command. The query is ...
Read More