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
Articles by Sharon Christine
Page 14 of 34
How can CONCAT_WS() function be used with MySQL WHERE clause?
When we use CONCAT_WS() function with WHERE clause then the output would be based upon the condition provided in WHERE clause. It can be understood from the example of ‘Student’ table as followsExamplemysql> Select CONCAT_WS(' ',Name, Last_name, 'Resident of', Address, 'is studying', Subject)AS 'Student Detail' from student WHERE id = 20; +----------------------------------------------------------------+ | Student Detail | +----------------------------------------------------------------+ | Gaurav Rathore Resident of Jaipur is studying Computers | +----------------------------------------------------------------+ 1 row in set (0.00 sec)
Read MoreHow can we use ASCII() function with MySQL WHERE clause?
While using the ASCII() function with WHERE clause, the output returns by it will depend upon the condition given in WHERE clause. For example, suppose we have a table named ‘Student’ and we want to get the number code, higher than 65, of the first characters of the names of the students. The query for this can be written as follows −mysql> Select * from student; +------+---------+---------+-----------+ | Id | Name | Address | Subject | +------+---------+---------+-----------+ | 1 | Gaurav | Delhi | Computers | | 2 | Aarav | Mumbai | ...
Read MoreHow to Install and Configure an NTP Client and Server on Linux?
This article will help to know how to configure an NTP (Network Time Protocol) server and client on RHEL/Cent OS Linux to manage the system clock with to help of an NTP server.NTP (Network Time Protocol)NPT is used to synchronize a computer’s machine’s time with another time source. In RHEL / CentOS Linux we can use NTP or OpenNTPD server, which provides client and server software for time synchronization.Installing NTP SoftwareThe NTP package have utilities and daemons that will synchronize the machine time to Coordinated Universal Time (UTC) via the NTP protocol. The NTP package has ntpdate (Which updates the ...
Read MoreHow to Increase the Size of a Linux LVM by Adding a New Disk?
This article helps us to add a new disk to LVM ( Logical Volume Manager), the very best advantage of LVM over normal disk partitions is its support for “dynamic partitions”; you can create and resize (expand or shrink) LVM volumes dynamically as we needed. There is no limit of the physical disk boundary in LVM logical volumes, so you can create a large LVM volume that spans across multiple smaller physical disks. This flexibility partitioning allows you to manage storage space more efficiently as disk usage change from time to time.If you want to add new disks to an ...
Read MoreHow to Host Files using GitHub?
Before GitHub existed, all the companies have managed the programming source code in private. It was first introduced as a collaborative platform for developers and now almost all of the storage space online is shared here for collective work. Irrespective of major or minor companies, you will find and can also access all their GitHub accounts and download as well. It can be otherwise termed as a dump store of human knowledge.A common misconception that prevails is that, it is a development tool that is used only for coding and compiling computer languages. But the fact is far from it. ...
Read MoreHow to Get Fare Estimates for Uber Taxi’s on Twitter?
Uber is a private car hire service which is one of the most taxi popular provider which presently operates in more than 500 cities worldwide. Everyone who wishes to use uber Taxi service is usually interested to know about how much will be the cost if they hire Uber taxi from one point to another. That’s simple, all you require to do is, type the command as to send it to @WhatTheFare and the bot would help you know approximately how much would be the fare in a minute or less.What is the Advantage?The bot, @WhatTheFare not only ...
Read MoreKey Points on Automation
Automation is one of the hot domain in the Information and Technology, which has become predominant topic of discussion among the IT professionals. In general, automation can be defined as the process of involving software robots or hardware robots to solve the human problems (requirements). Due to this automation, it is said that ¼th of the job will be lost in the market. But people still prefer automation for (top) 7 reasons, which is discussed in this article.Cost SavingsCost is one of the major factor in the software development cycle, which predominantly comes into picture right from the planning phase. ...
Read MoreIs Fully Autonomous Driving possible through TESLA AUTOPILOT?
Fully self-driving cars may soon be a reality with Tesla cars. But Tesla still has a long way to completely set its autopilot suite of self-governing technologies in place. Autonomous driving refers to driving cars without the need of any human involvement. As of now, Tesla cars are semi-autonomous i.e. features that assist drivers on highways.The Tesla Autopilot SystemThe Tesla autopilot is a semi-autonomous system. It was rolled out in October 2014 in Tesla Model S cars. But it was only in 2015, that the Tesla Autopilot system (Tesla Version 7.0) rolled out. It allowed the car to adjust its ...
Read MoreImportant MYSQL Performance Tuning and Settings after Installation
In this article, we will learn and discuss some important performance tuning settings for MySQL which we need to implement after the MySQL Installation better and speedy performance.Pre-requisitesAssuming that we have already installed the MySQL, I am providing some tips before we start to know about Performance tuning settings for MySQL.Even experienced IT persons may make some mistakes which will lead to many problems, so before we apply any recommendations which are shown in this article, we will keep the below items in mind to avoid issues or problems.We will apply only one setting at a time so that we ...
Read MoreHow To Turn Your TV Into Smart TV
Instead of shopping for an expensive smart TV, you’ll be able to convert your existing TV into a web-enabled entertainment center by just spending a few thousands of rupees. With this, you’ll have access to everything the Web, the PC and the Google Play store have to offer.Here are some helpful gadgets which will facilitate your recent TV work like a smart TV –Portable Media PlayersIf you’re working on a tight budget, you might want to consider an ultra-portable media player. These thumb-sized sticks, which resemble USB pen drives, are capable of streaming content – pictures, music, videos – wirelessly ...
Read More