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
Convert output of MySQL query to UTF8?
You need to use CAST() or CONVERT() function to convert output of MySQL query to UTF8. Here, I am using MySQL version 8.0.12. Let us first check the version:mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.12 | +-----------+ 1 row in set (0.00 sec)In this if you use utf8 then you will get warning of aliases because it has utf8mb4. Therefore, you can avoid the warning by placing utf8mb4.Note: Never use UTF8. For current versions, use UTF8MB4Here is the syntax to convert output of MySQL query to UTF8:SELECT yourColumnName1, convert(yourColumnName2 USING utf8) as anyVariableName FROM ...
Read MoreHow to echo print statements while executing an SQL script?
To perform echo print statements while executing SQL scripts, use the following syntax.The syntax is as follows −SELECT ‘anyStringValue as’ ‘;The query is as follows −mysql> select 'This is a SQL Script' AS' ';The following is the output −+----------------------+ | | +----------------------+ | This is a SQL Script | +----------------------+ 1 row in set, 1 warning (0.00 sec)You can add dynamic data to your status like insert, update and delete with the help of concat() function. The query is ...
Read MoreWhy do companies focus on customer satisfaction scores?
Every business will have stiff competition from already established businesses and brands. Nowadays whether it is simple chips packet or a luxury car, people have become smart enough to go through the reviews and customer ratings before they buy. People will judge by hearing the name of the brand and make decisions based on other customer's reviews. These trends are seen more in online eCommerce sites.It's clear that customer satisfaction metrics are essential for any business. They impact the decisions of current and potential customers. This is the reason, you should never ignore the importance of customer satisfaction. Online surveys ...
Read MoreWhat is called "Angle of Banking"?
The occurrence of lifting the outer border of the curved road over the inner border is to give necessary combining force to the vehicles to take a guarded turn and the curved road is termed as Banking of Roads. When a vehicle prevails around a curved road, it needs some combining force.While moving around the curve, the wheels of the vehicle have a propensity to leave the curved path and recover the straight line path. Force of friction between wheels and the roads goes against this propensity of the wheels. This force of friction accordingly acts towards the middle of ...
Read MoreWhat is the way to practice verbal ability for SSC Bank PO examination?
Bank PO, SSC examinations are some of the popular competitive examinations taken by aspirants who wish to step into a good government job. The syllabus includes questions on Quantitative Aptitude, Logical Reasoning, Verbal Ability, and General Knowledge.How to Prepare for Verbal Ability?Go through the complete syllabus of the particular exam you are planning to take.Purchase verbal ability books available in the market. You may also get it from someone, or get second-hand books from the market if you do not wish to buy new copies.Practice each and every concept from these books, and practice those concepts which you find difficult ...
Read MoreHow to adjust display settings of MySQL command line?
To adjust display settings of MySQL command line, use the /G at the end of MySQL queries instead of semicolon(;).The syntax is as follows −SELECT *FROM yourTableName \GThe above syntax adjusts the display settings. Here we will display records in row format from our sample ‘studenttable’ table which we created using CREATE −mysql> create table StudentTable −> ( −> Id int, −> Name varchar(100) −> ); Query OK, 0 rows affected (0.65 sec)To get all the records −mysql> select *from StudentTable;The following displays the records −+------+---------+ | Id | Name | +------+---------+ | ...
Read MoreHow to match one character in MySQL in place of %?
To match only one character in MySQL, you can use underscore(_) in place of %. The syntax is as follows:SELECT *FROM yourTableName WHERE yourColumnName LIKE ‘yourString_’;To understand the above syntax, let us create a table. The query to create a table is as follows:mysql> create table OneCharactermatchDemo -> ( -> Id int NOT NULL AUTO_INCREMENT, -> PassoutYear year, -> 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 OneCharactermatchDemo(PassoutYear) values('2008'); Query OK, 1 row affected (0.14 sec) mysql> ...
Read MoreList of C++ IDEs for Linux
The following are some of C++ IDEs for linux − Eclipse Galileo with CDT Plugin Eclipse is a well-known open source and cross platform IDE. It provides full functional C/C++ IDE with the following features − Code editor with support for syntax highlighting Support for folding and hyperlink navigation Source code refactoring plus code generation Tools for visual debugging such as memory, registers etc. NetBeans IDE NetBeans is free, open source and popular IDE for C/C++. These are some of its features − Support for automatic packaging of compiled application into .tar, .zip and many more archive ...
Read MorePython program to count unset bits in a range.
Given a positive a number and the range of the bits. Our task is to count unset bits in a range. Input : n = 50, starting address = 2, ending address = 5 Output : 2 There are '2' unset bits in the range 2 to 5. Algorithm Step 1 : convert n into its binary using bin(). Step 2 : remove first two characters. Step 3 : reverse string. Step 4 : count all unset bit '0' starting from index l-1 to r, where r is exclusive. Example Code # ...
Read MorePython Unicode Database
The unicodedata module is used to access all of the Unicode characters using Unicode character databases. In this database, there are character properties of all characters. To use this modules, we need to import the unicodedata module in our code. import unicodedata Unicode Database Methods Some modules of the unicodedata module are described here. Module (unicodedata.lookup(name)) − This method is used to lookup the characters by name. When the name is valid, it should return the character. Otherwise it will raise the KeyError. Module (unicodedata.name(chr[, default]))− This method is used to return the name of the given ...
Read More