Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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 More
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
Change Management is an approach to transitioning organizations, teams and individuals from their current state to a new desired state for the future. The purpose of Change Management is to establish standardized procedures for the handling of IT-related change requests and facilitates the assessment, scheduling, coordination, documentation and evaluation of all changes.A Change can be initiated both from within the organization and from external forces. Externally, competition may drive an organization to change a product. Internally, a problem may be identified and change management is seen as the process by which a solution can be implemented with the organization.Change Management ... Read More
When we try to do such kind of operations with date values stored in the table then MySQL is assuming the date values as the number and perform the arithmetic.Suppose we have a table named ‘example’ having a date value in ‘orderdate’ column then following arithmetic operation will clarify the above −mysql> select * from example; +------------+ | orderdate | +------------+ | 2017-05-25 | +------------+ 1 row in set (0.00 sec) mysql> select orderdate+10 from example; +--------------+ | orderdate+10 | +--------------+ | 20170535 | +--------------+ 1 row in set (0.00 sec) mysql> select orderdate*10 from example; ... Read More
The following statement shows the list of two tables having a column ‘email’ in Sample database −mysql> SELECT DISTINCT TABLE_NAME -> FROM INFORMATION_SCHEMA.COLUMNS -> WHERE COLUMN_NAME IN('EMAIL') -> AND TABLE_SCHEMA = 'SAMPLE'; +---------------+ | TABLE_NAME | +---------------+ | employee | | new_student | +---------------+ 2 rows in set (0.04 sec)
As the name suggests CURDATE() function will return the current date. In simple words, we can say that it would return only the date not time.mysql> select CURDATE(); +------------+ | CURDATE() | +------------+ | 2017-10-28 | +------------+ 1 row in set (0.00 sec)In contrast, NOW() function will return current date and time.mysql> Select NOW(); +---------------------+ | NOW() | +---------------------+ | 2017-10-28 09:10:16 | +---------------------+ 1 row in set (0.00 sec)
We can check the size of all MySQL databases with the help of the following statementmysql> SELECT table_schema "Database", -> SUM(data_length + index_length)/1024/1024 "Size in MB" -> FROM information_schema.TABLES GROUP BY table_schema; +--------------------+----------------+ | Database | Size in MB | +--------------------+----------------+ | gaurav | 1.04785156 | | information_schema | 0.00878906 | | mysql | 0.68551350 | | performance_schema | 0.00000000 | | sample | 0.04687500 | | tutorial | 0.03125000 | +--------------------+----------------+ 6 rows in set, 1 warning (0.33 sec)
It is raining discounts and offers on all shopping websites. Online shopping is an activity wherein customers use Internet to order a product or a service at any moment of time and the product is delivered at their doorsteps.Online stores have made shopping easy with the usage of mobile devices, tablets, or laptops that aid most of the online shopping apps. You can enjoy all the products and services just by a click from the comfort of your drawing room or while you are on the go. Online shopping is winning the hearts of shopaholics all over India.Why would Anyone ... Read More
As we have checked the size of the MySQL database, similarly we can also check the size of tables in a particular database. It can be done as follows −mysql> SELECT -> table_name AS "Table", -> round(((data_length + index_length) / 1024 / 1024), 2) as SIZE -> FROM information_schema.TABLES -> WHERE table_schema = "SAMPLE" -> ORDER BY SIZE; +-------------+-------+ | Table | SIZE | +-------------+-------+ | employee | 0.02 | | student | 0.02 | | new_student | 0.02 | +-------------+-------+ 3 rows in set (0.00 sec)Here this output gives the size of three tables in the Sample database.
As we know that CURDATE() only returns the date unit so it would be ambiguous to use INTERVAL of time unit with CURDATE(). MySQL always represents current date with ‘00:00:00’ time hence when we use INTERVAL of time unit with CURDATE() then such kind of time arithmetic would take this time into consideration. Following examples will clarify it −mysql> Select CURDATE() + INTERVAL 0 hour; +-----------------------------+ | curdate() + Interval 0 hour | +-----------------------------+ | 2017-10-28 00:00:00 | +-----------------------------+ 1 row in set (0.00 sec) mysql> select CURDATE() + INTERVAL 1 hour; +-----------------------------+ | curdate() ... Read More