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
Frequently Used Examples of 'Fuser' Command in Linux
The fuser utility in Linux is a very smart Unix utility. As the name suggests, it offers knowledge about file user or the process that is currently utilizing the file or directory. This article explains about – Frequently used examples of ‘fuser’ Command in Linux.To get the more information about fuser, use the following command –$ fuserThe sample output should be like this –Usage: fuser [-fMuvw] [-a|-s] [-4|-6] [-c|-m|-n SPACE] [-k [-i] [-SIGNAL]] NAME... fuser -l fuser -V Show which processes use the named files, sockets, or filesystems. -a, --all display unused files ...
Read MoreHow MySQL use YEAR data type to store year value in a table?
MySQL permits to declare a column YEAR type, with the help of which we can store year values in that column.mysql> Create table year1 (Year_Copyright YEAR); Query OK, 0 rows affected (0.21 sec) mysql> Insert into year1(Year_Copyright) values (2017); Query OK, 1 row affected (0.08 sec) mysql> Select * from year1; +----------------+ | Year_Copyright | +----------------+ | 2017 | +----------------+ 1 row in set (0.00 sec)
Read MoreHow can we insert current year automatically in a YEAR type column of MySQL table?
It can be done by using either CURDATE() or NOW() in MySQL query as follows −mysql> Insert into year1(Year_Copyright) values (CURDATE()); Query OK, 1 row affected, 1 warning (0.06 sec) mysql> Select * from year1; +----------------+ | Year_Copyright | +----------------+ | 2017 | | 2017 | +----------------+ 2 rows in set (0.00 sec) mysql> Insert into year1(Year_Copyright) values (NOW()); Query OK, 1 row affected, 1 warning (0.06 sec) mysql> Select * from year1; +----------------+ | Year_Copyright | +----------------+ | 2017 | | 2017 | | 2017 | +----------------+ 1 rows in set (0.00 sec)
Read MoreIs there a naming convention for tables in MySQL?
No, MySQL does not have a preferred naming convention standard. If the name we have chosen is logical and consistent then it would be ok.Two major points need to be remembered, one is that no two tales/databases can have the same name and second we can choose any of the reserved words as the name of table/database.
Read MoreHow to get the first day of the current month in MySQL?
With the help of following MySQL query, we can get the first day of the current month −mysql> SELECT DATE_SUB(LAST_DAY(NOW()),INTERVAL DAY(LAST_DAY(NOW()))- 1 DAY) AS 'FIRST DAY OF CURRENT MONTH'; +----------------------------+ | FIRST DAY OF CURRENT MONTH | +----------------------------+ | 2017-10-01 | +----------------------------+ 1 row in set (0.00 sec)
Read MoreGadget Updates of the Week 3-16
The New Oppo F1 SmartphoneDual SIM, Lollipop OS 5.1, 13 Megapixel camera, 2500 mAh Li-Po battery, 16GB internal storage, all packed in this powerhouse of an Oppo phone is its first in the F series that, as per the company, will focus on photography.Known for its camera advancements, Oppo is a powerful machine and is all set in a slim aluminium body.Set to release in India this month, let’s wish it is all the promised good features and beyond.Polaroid Snap + Instant Print CameraPolaroid proper is no more, but its brand-name and uniqueness are still around in various reanimated forms. ...
Read MoreGetting Ready for Analytics
In today’s rapidly changing business world, it is critical for business leaders to have the right insight and data to make the right calls at the right time. Finding the right blend of what, why and how to use this enormous amount of data is something that needs attention in present day competitive business environment.Business strategies and operational decisions are being undertaken based on the analysis provided by past operational data. Hence it is tremendously important for global business entities to equip themselves with the emerging technologies like business analytics software for better decision making and forecasting.Business Decisions + Analytics ...
Read MoreGoogle Duo – A Revolutionary Video Calling App
The world has been chatting; sharing all the way from the day Facebook has entered the digital world. Then came the biggest revolution of WhatsApp, which has taken the world by surprise when it made easy for users by removing the registration process and made texting a daily habit replacing SMS. Sharing your favorite pictures, videos just through a click from your mobile or tablet has become a pastime for many. This was indeed a digital revolution when it comes to social networking.Moments turn into memories when there are dear ones around. As it is said, maybe in distance but ...
Read MoreGoogle Updates for the Month
Google is known well for attempting many new platforms and it is reportedly working on a new kind of artificial intelligence-based messaging service. It will try to directly compete with Facebook’s WhatsApp and Messenger. Google will integrate chatbots, which answers user’s queries through a messaging app which is within the program after searching the Web for information. This will answer queries without having to exit that conversation.“All users care about is a convenient way to find what they are looking for and if Google isn’t in front of the consumer that is a problem for them, ” said Scott Stanford, ...
Read MoreHow are Emerging Markets Challenging Silicon Valley
Silicon Valley has now become a new home for new techies. The past few years have seen a blast of job opportunities, be it for starters or the techie geeks opting for the Silicon Valley. It has become a home for all kinds of emerging markets, but there are major challenges which the market has to face with this boom.Africa’s ‘Silicon Valley lures new tech start-ups and is witnessing investment from big capital firms. In fact, all the biggies like Google, Intel, Microsoft, and IBM have their tower block and innovation center in Africa.As 60% land of Africa is uncultivated, ...
Read More