Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
Kubla Khan is one of the most famous poems written by Samuel Taylor Coleridge. Coleridge who was a Romantic poet and became immortal after writing this unique poem.Summary of 'Kubla Khan'The speaker starts by describing the setting of Emperor Kubla Khan's palace as a "pleasure dome." He tells us about a river that runs across the land and then flows through caves into the sea. He also describes the fertile land surrounding the palace. There is a vivid description of a nearby area all covered in streams, trees, and beautiful forests. He also describes how a river leaps and smashes ... Read More
This is not true that everyone leaves a job in frenzy. Sometimes things in personal and professional life go asymmetrical and one has to leave a job. However, champions know how and when to leave a job. Let’s know about it:The Gallop Poll happened in 2014 reveals that 68% of employees are not actively attached to their workplace. You will be surprised to know that many companies including MNCs have dissatisfied employees. Is being unhappy at work a reason to quit a job? Or Don't you consider leaving a job a personal failure?Seth Godin in his book ‘The Dip’ mentions, ... Read More
If your table name or column name are any reserved words then you need to use quotes around table name and column name in a MySQL query. You need to use backticks around table name and column name. The syntax is as follows:SELECT *FROM `table` where `where`=condition;Here is the query to create a table without quotes with reserved words. You will get an error since they are predefined reserved words. The error is as follows:mysql> create table table -> ( -> where int -> ); ERROR 1064 (42000): You have an error in your SQL syntax; check ... Read More
To load an image in table view cell we’ll go through a series of steps.Create a table view, table view cell and add an Image view to it.Assign a custom class to the cell we created.In the cell for row at method write the following lines of code.let cell = tblView.dequeueReusableCell(withIdentifier: "CustomCell") as! CustomCell return cellTo download the image we’ll create a function and embed that into an extension.func setImageFromUrl(ImageURL :String) { URLSession.shared.dataTask( with: NSURL(string:ImageURL)! as URL, completionHandler: { (data, response, error) -> Void in DispatchQueue.main.async { if let ... Read More
This example demonstrates how to verify enter number is phone number or not, using regex in android.Step 1 - Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 - Add the following code to res/layout/activity_main.xml. In the above code, we have taken Edit text and text view. when the user clicks on text view, it will take data from edit text and valid the data.Step 3 - Add the following code to src/MainActivity.javapackage com.example.andy.myapplication; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; ... Read More
Clauses are defined as the words, consisting of a subject and a finite form of a verb. Every complete sentence is made up of at least one clause.There are Two Major Types of ClausesIndependent clausesDependent clausesLet us have a look at the sentences belowMia bought a new computer. (One sentence, one clause)Mia bought a new computer, but she still has the old one. (One sentence, two clauses)A Dependent Clause (or subordinate clause) does not make sense by itself because it does not express a complete thought.“But she still has his old one”. (a dependent clause is a sentence fragment.)An Independent Clause ... Read More
You need to use GROUP BY command with aggregate function count(*) from MySQL to achieve this. The syntax is as follows:SELECT yourColumnName, COUNT(*) AS anyVariableNameFROM yourTableName GROUP BY yourColumnName;To understand the above syntax, let us create a table. The query to create a table is as follows:mysql> create table selectDistinct_CountDemo -> ( -> Id int NOT NULL AUTO_INCREMENT, -> Name varchar(10), -> AppearanceId int, -> PRIMARY KEY(Id) -> ); Query OK, 0 rows affected (0.63 sec)Insert some records in the table using insert command. The query is as follows:mysql> insert into selectDistinct_CountDemo(Name, AppearanceId) values('Larry', ... Read More
To select domain name from email address, you can use in-built SUBSTRING_INDEX() function from MySQL.To understand the concept, let us create a table. The following is the query to create a table.mysql> create table selectDomainNameOnly −> ( −> UserEmailAddress varchar(200) −> ); Query OK, 0 rows affected (0.52 sec)Insert records in the table using insert command. The record will have email-ids from which we need to fetch the domain name. The query is as follows −mysql> insert into selectDomainNameOnly values('John123@yahoo.com'); Query OK, 1 row affected (0.10 sec) mysql> insert into selectDomainNameOnly ... Read More
Recently, India beat Bangladesh by three wickets in the final of Asia Cup and clinched the Asia Cup title once again. However, do you know when this tournament first occurred? Let's dig out the history.Actually, when the Asia Cricket Council was formed in 1983, the council came up with this idea, which was conceptualized in 1984 and the first Asia Cup occurred in Sharjah where Asia Cricket Council has its headquarter and remained there till 1995.Initially, Asia Cup was only an ODI tournament and used to happen in every two years, but now it takes place in both ODI and ... Read More
A number system is a set of symbols used to represent values derived from a common base or radix. In a number, the value of each digit can be determined using digit, position of the digit in the number, and the base of the number system. The base is defined as the total number of digits are available in the number system. This is known as positional number system.Number SystemBaseDigit UsedBinary20, 1Octal80, 1, 2, 3, 4, 5, 6, 7Decimal100, 1, 2, 3, 4, 5, 6, 7, 8, 9Hexadecimal160, 1, 2, 3, 4, 5, 6, 7, 8, 9, A, B, C, D, ... Read More