Sharon Christine has Published 413 Articles

In MySQL, how can we get the number code of a particular character?

Sharon Christine

Sharon Christine

Updated on 07-Feb-2020 10:45:12

378 Views

With the help of MySQL string function ASCII(), we can get the number code of a particular character. Its syntax is ASCII(str) where, str, the argument of ASCII() function, is the string whose ASCII value of the first character to be retrieved.It will return the number code the left the ... Read More

What is the significant difference between MySQL LIKE and equal to (=) operator?

Sharon Christine

Sharon Christine

Updated on 07-Feb-2020 06:49:34

4K+ Views

We have seen the MySQL SELECT command to fetch data from the MySQL table. We can also use a conditional clause called as the WHERE clause to select the required records.A WHERE clause with the ‘equal to’ sign (=) works fine where we want to do an exact match. Like ... Read More

Most Frequently Used Linux IPTables Rules with Examples

Sharon Christine

Sharon Christine

Updated on 31-Jan-2020 12:34:37

11K+ Views

This article will help you to create IPtables rules that you can directly use for your daily or routine needs, These examples will act as basic templates for you to work on iptables with these rules which suit your specific requirement.Deleting the IPtables or Existing RulesBefore you start building new ... Read More

How can CONCAT_WS() function be used with MySQL WHERE clause?

Sharon Christine

Sharon Christine

Updated on 30-Jan-2020 07:26:58

430 Views

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 ... Read More

How can we use ASCII() function with MySQL WHERE clause?

Sharon Christine

Sharon Christine

Updated on 30-Jan-2020 06:41:04

366 Views

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 ... Read More

How to Install and Configure an NTP Client and Server on Linux?

Sharon Christine

Sharon Christine

Updated on 27-Jan-2020 07:52:33

5K+ Views

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 ... Read More

How to Increase the Size of a Linux LVM by Adding a New Disk?

Sharon Christine

Sharon Christine

Updated on 27-Jan-2020 07:28:35

9K+ Views

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 ... Read More

How to Host Files using GitHub?

Sharon Christine

Sharon Christine

Updated on 27-Jan-2020 07:16:30

1K+ Views

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 ... Read More

How to Get Fare Estimates for Uber Taxi’s on Twitter?

Sharon Christine

Sharon Christine

Updated on 27-Jan-2020 07:09:46

152 Views

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 ... Read More

How To Fix and Protect The Linux Server Against the Dirty COW Vulnerability on Ubuntu

Sharon Christine

Sharon Christine

Updated on 27-Jan-2020 06:57:48

279 Views

In this article, we will learn about how to fix the Dirty Cow Linux Vulnerability. The Dirty Cow Linux Vulnerability was escalated on Oct 19 2016 as it is a privilege escalation vulnerability in the Linux OS on kernel level which was disclosed with the name as Dirty COW as ... Read More

Advertisements