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 by karthikeya Boyini
Page 104 of 143
Why should we not use group functions with non-group fields without GROUP BY clause in MySQL SELECT query?
It is because without GROUP BY clause the output returned by MySQL can mislead. We are giving following example on the ‘Student’ table given below, to demonstrate it −mysql> Select * from Student; +------+---------+---------+-----------+ | Id | Name | Address | Subject | +------+---------+---------+-----------+ | 1 | Gaurav | Delhi | Computers | | 2 | Aarav | Mumbai | History | | 15 | Harshit | Delhi | Commerce | | 20 | Gaurav | Jaipur | Computers | +------+---------+---------+-----------+ 4 rows in set (0.00 sec) mysql> ...
Read MoreHow can we create a new MySQL table by selecting specific column/s from another existing table?
As we know that we can copy the data and structure from an existing table by CTAS script. If we want to select some specific column/s from another table then we need to mention them after SELECT. Consider the following example in which we have created a table named EMP_BACKUP1 by selecting a specific column ‘name’ from already existing table ‘Employee’ −mysql> Create table EMP_BACKUP1 AS Select name from employee; Query OK, 3 rows affected (0.25 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql> Select * from EMP_BACKUP1; +--------+ | name | +--------+ | Ram | | ...
Read MoreWhat happens if I will delete a row from MySQL parent table?
While deleting the row from the parent table, if the data of that row is used in the child table then MySQL will throw an error because of the failure of FOREIGN KEY constraint. It can be understood with the example of two tables named ‘customer’ and ‘orders’. Here, ‘customer’ is the parent table and ‘orders’ is the child table. We cannot delete a row, that is used in child table ‘orders’, from the ‘customer’ table. It can be demonstrated by deleting the values from the parent table as follows −mysql> Select * from Customer; +----+--------+ | id | name ...
Read MoreHow to Install a Software on Linux Using Yum Command?
In this article, we will learn about “how to use the Yum command” for installing the packages. Also note that, the repositories on the Cent OS 6.7 YUM (Yellowdog Update Modified) is a tool used to develop by Redhat. You can use this materials for learning the YUM.Managing Software with YUMUse the yum utility to install or modify the software on your system in the following ways –New software installation from repositories.Installing software from an individual package file.Updating the existing software on your system.Removing unwanted software from your system.Installing Software from a Package FileThe yum commands used in this is ...
Read MoreHow to Increase Swap Space on Linux Ubuntu?
In this article, we will learn how to increase the swap space, which will solve the memory errors in applications. This will cover how to add a swap file to an Ubuntu Linux.Anyway, this is recommended to utilize the spinning hard disk drivers for swap as SSD can cause issues with hardware degradation over time. Due to this reason, do not enable swap on Cloud where the SSD storage is provided.What is Swap file?The Swap is a place where the OS can store temporary data as it can no longer holds in RAM. Basically, this will increase the ability of ...
Read MoreHow to go from Zero to Internet Hero using IFTTT Technology?
Isn’t it great to receive an advance notification to pack your umbrella, as it will rain tomorrow? Or else, remind yourself to silence your phone, when you get to work? If you will understand this, then that will reboot your life with a kick start. In short, we are talking about IFTTT (If This, Then That) technology. Confused? Well, it is a super tool that works as a coordinator for your apps and produce results based on your “if” logic. Let’s simplify it further.Suppose you want to auto update a status on Facebook as soon as you post a picture ...
Read MoreHow to Find your Dream Job in Tech Field
Are you tired of searching for a job through online mode, you may be wondering, is there any better way, to find your dream job in the field of technology. To make your job of shortlisting useful job portals, we are listing out one of the famous sites.DiceIn Dice, a leading US based job tech site, you can find thousands of job openings, posted each day. You can filter by location, employment by type and company name. You can also view job description without creating an account, for that, you must get yourself registered in order to apply. Once you ...
Read MoreWWDC 2017- What is Coming From Apple
In the recently concluded Apple’s Worldwide Developer Conference (WWDC), the technology giant revealed its upcoming versions and products that can create a rave in the market once released. The prime focus was on the upgrades of its existing products with higher performance that can enhance ultimate user experience. It has updates for almost all its existing products, be it iPhone, Mac laptop, Watches, TVs to IPad Pro and also the brand new Siri-enabled Homepod.The WWDC event of Apple is a yearly event which lasts for a week. That is the platform where Apple announces its upcoming technology which many of ...
Read MoreWhy Training Doesn't Help Your Organization!
The first day of any employee, be a fresher or an experienced person, will always start off with a training session. The day long training completes with numerous amount of information, but does so much effort made by the Organization is worth the money invested in the training.We all agree training is the key to a well-motivated, knowledgeable and efficient staff. However, here we are going to discuss the top reasons on why the training sessions do not help your employees, and why this whole expenditure on training is not fruitful. We will check out the conditions because of which ...
Read MoreWhy Should You Care About Machine Learning?
When I say machine learning, it reminds me a subject for the B.Tech Mechanical stream. No this is not a session of machine learning or it’s not related to your regular subject knowledge. The topic remains the same but it’s still different. So before we go to the point why should we be bothered about what is machine learning. We should now see what is machine learning actually.What is Machine Learning?Machine learning is a subcategory or to a say, a type of artificial intelligence (AI) which gives computers, a privilege to learn without being explicitly programmed. It mainly focuses on ...
Read More