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
Is simplicity an inspiration for writing?
“Life is not complex. We are complex. Life is simple, and the simple thing is the right thing.” — Oscar Wilde.When I read such amazing quotations about simplicity, I feel like step out and explore the meaning and vastness of simplicity. In fact, William Hazlitt in his prose piece, On familiar style is scornful of the writers whose writing style is pedantic, with affectation and pretense, showy and gaudy, and thus it lacks a familiar style and even common sense too.How Can It Be Achieved?Simplicity can only be harvested from within, through hard work, engagement, and insight. This is even ...
Read MoreHow to implement ternary conditional operator in MySQL?
A ternary conditional operator looks like ?: in programming language like C, C++, Java etc. The syntax is as follows −(yourCondition) ? statement1:statement2;In the above syntax, if yourCondition becomes true then statement1 will evaluate and if yourCondition becomes false then statement2 will evaluate.But the above syntax does not work in MySQL. We can use IF() function from MySQL for the same purpose.Let us see an example −Case 1mysql> select if(3 > 5, 'Condition is true', 'Condition is not true') as ConditionalResult;The following is the output in which second statement evaluates since is 3 isn’t more than 5 −+-----------------------+ | ConditionalResult ...
Read MoreWhat are the new English words you have learned today?
Ragtag: A group of people perceived as disreputable or undesirable.Lynch: (of a mob) kill (someone), especially by hanging, for an alleged offence with or without a legal trial.Gimcrack: A cheap and showy ornament; a knickknack or flimsy or poorly made but deceptively attractive.Vogie: Conceited, proud, cheerfulCarte Blanche: Unconditional authority; full discretionary power.Tummler: Any lively, prankish, or mischievous man.Hoity-Toity: Assuming airs; pretentious; haughty.Magisterial: Authoritative, weighty; of importance or consequence; of, relating to, or befitting a master: a magisterial pronouncement by the director of the board.Coeval: Of the same age, date, or duration; equally old: Analysis has proved that this manuscript is ...
Read MoreHow does an FM radio set work?
The FM receiver is the whole unit which takes the modulated signal as input and outputs the original audio signal. Radio amateurs are the initial radio receivers. They had got drawbacks such as poor sensitivity and selectivity.Selectivity is the selection of a particular signal while rejecting the others. Sensitivity is the capacity of detecting RF signal and demodulating it, while at the lowest power level. Both Selectivity and Sensitivity should be high for an FM receiver. To overcome these drawbacks of the ordinary receiver, the superheterodyne receiver was invented. This FM receiver consists of 5 main stages.RF Tuner SectionThe modulated ...
Read MoreCalculate age based on date of birth in MySQL?
Calculate Age based on date of birth with the help of DATE_FORMAT() method in MySQL. Firstly, get the current date time with the help of now() method and you can place your date of birth in DATE_FORMAT().The syntax is as follows −SELECT DATE_FORMAT(FROM_DAYS(DATEDIFF(now(), 'yourDateofbirth')), '%Y')+0 AS anyVariableName;Apply the above syntax to calculate age from yourDateofbirth. In the above syntax, replace yourDateofbirth with your date of birth. The query is as follows −SELECT DATE_FORMAT(FROM_DAYS(DATEDIFF(now(), '2010-11-25')), '%Y')+0 AS Age;The following is the output −+------+ | Age | +------+ | 8 | +------+ 1 row in set (0.00 sec)Let ...
Read MoreMySQL command line client for Windows?
In order to install MySQL command line client for Windows, you need to visit the following URL to get the download link https://dev.mysql.com/downloads/mysql/ −The snapshot is as follows −After that you need to select operating system. The snapshot is as follows −You need to choose Windows (x86, 32/64-bit) and download the installer.
Read MoreWhat to do if the librarian of my college refuses to issue books not available in multiple copies?
This is a common issue that has been faced by us once or more in our college and school time. The appropriate resolution for this differs as to which university or organization one studies in. Still, the below solutions could help.1. If carrying a mobile phone is allowed in your library, click a picture of the important topics you wished to study from the book you want to get issued.2. You may also get these books issued on the card of any other student. We used to have the books issued through identity cards in our school and college. In ...
Read MoreMySQL Server port number?
If you will install MySQL on your system, then you will get the default MySQL server port number i.e. 3306.To know the MySQL server port number, you can use the following query. Here, we have used the SHOW VARIABLES command. The query is as follows −mysql> SHOW VARIABLES WHERE Variable_Name = 'port';The following is the output −+---------------+-------+ | Variable_Name | Value | +---------------+-------+ | port | 3306 | +---------------+-------+ 1 row in set (0.04 sec)
Read MoreHow to change the default charset of a MySQL table?
To change the default charset of a MySQL table, you can use the below syntax. The syntax is as follows −alter table yourTableName convert to character set yourCharsetName;Let us create a table and apply the above syntax to change the default charset. The query to create a table −mysql> create table CharsetDemo -> ( -> Id int, -> Name varchar(200), -> Age int -> ); Query OK, 0 rows affected (0.73 sec)Now you can change the charset of a table. The following is the query ...
Read MoreDo a select in MySQL based only on month and year?
To select MySQL based on month and year, use in-built function YEAR() and MONTH(). The syntax is as follows −select *from yourTableName where YEAR(yourColumnName) = YearValue AND MONTH(yourColumnName) = monthValue;To understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table selectDataOnYearandMonthDemo −> ( −> BookId int, −> BookName varchar(100), −> BookDueDate datetime −> ); Query OK, 0 rows affected (0.57 sec)Now you can insert some records in the table. The query is as ...
Read More