Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
You can create user if it does not exist with the help of “create user” command. The command will work on MySQL version 5.7.6 and above. The syntax is as follows −mysql> CREATE USER IF NOT EXISTS 'yourUserName'@'localhost' IDENTIFIED BY 'yourPassword';Apply the above syntax to create a user if it does not exist. The query is as follows −mysql> CREATE USER IF NOT EXISTS 'Smith'@'localhost' IDENTIFIED BY 'Smith123456'; Query OK, 0 rows affected (0.29 sec)To check the new user is created or not, use the below query −mysql> SELECT User FROM mysql.user;The following is the output −+------------------+ | User ... Read More
You can achieve this with the help of INFORMATION_SCHEMA.TABLES. Use the date_sub() with interval. The syntax is as follows −SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE DATE_SUB(NOW(), INTERVAL -1HOUR) < ‘UPDATE_TIME’;Now you can check the above syntax. Here is the query to find the tables modified in the last hour −mysql> select table_name from `INFORMATION_SCHEMA`.`TABLES` -> WHERE -> DATE_SUB(NOW(), INTERVAL 1 HOUR) < `UPDATE_TIME`;Output+---------------------+ | TABLE_NAME | +---------------------+ | innodb_table_stats | | innodb_index_stats | | employeeinformation | +---------------------+ 3 rows in set (0.37 sec)The above query selects only table name. If you want information like table schema, table ... Read More
An earthquake is defined as the sudden shaking of the Earth's surface. Earthquakes are caused by the collision of tectonic plates in the Earth's crust. These plates ride over each other when instability is created in the crust due to the release of energy from the Earth's core.There are large earthquakes and small earthquakes. Earthquakes are measured using an instrument called Seismometer. The magnitude of an earthquake is represented on the Richter scale. On the scale, 3 or less is scarcely noticeable, and magnitude 7 or more causes damage over a wide area.The Great Chilean earthquake also known as the ... Read More
The screenshots taken on an simulator are stored usually on desktop of the system that you are using.There are multiple scenarios in which screenshots could have been taken, some of them are mentioned below.When the images are taken using "Command" + S, or from File menu's New Screenshot option, They are usually stored by name similar to "Simulator Screen Shot - iPhone 7 Plus - 2018-12-26 at 18.18.14" which consists of Simulator running currently followed by date in YYYY-MM-DD at HH:MM:SS format.If they are taken with mac's "Command + shift +3" or "command + shift + 4" buttons, they are ... Read More
Business Process Outsourcing (BPO) is a subset of Outsourcing which involves contracting some of the Business processes like operations or other responsibilities to a third party service provider. Basically, this outsourcing is providing many jobs to fresh graduates and has become a booming industry.Here are some of the advantages of working in a BPOSalariesBPOs in the country of India gives good starting salaries with periodical raises yearly. The average income of a person working in a BPO in India can range anywhere between 15, 000 rupees to 30, 000 rupees or in some cases it may be even higher. This ... Read More
To find my.cnf on Windows system, first open the command prompt with the help of shortcut key Windows + R (run). The snapshot is as follows −Type “services.msc” on command prompt and press ENTER as shown in the following screenshot −Now, a new wizard will open. The snapshot is as follows −Now, search for MySQL. The snapshot is as follows −Right click on “MySQL80” and select “Properties” as in the following screenshot −As you can see in the above screenshot, “Path to executable” tells about the location of my.cnf on Windows.
In this program we will see how to find the largest number from a block of bytes using 8085.Problem StatementWrite 8085 Assembly language program to find the largest number from a block of bytes.DiscussionIn this program the data are stored at location 8001H onwards. The 8000H is containing the size of the block. After executing this program, it will return the largest number and store it at location 9000H.Logic is simple, we are taking the first number at register B to start the job. In each iteration we are getting the number from memory and storing it into register A. ... Read More
People take bank loans for many purposes, like purchasing houses, purchasing vehicles, educational purposes, or to meet the unforeseen personal expenses. Banks provide short term and long term loans at fixed or variable interests, to be repaid in a fixed period of time.Banks provide both secured and unsecured loans. Let us see what are they.Secured loanSecured loans are those types of loans that can be protected by using an asset or a collateral of some kind. The type of item that is being purchased by the person, then collateral such as his car or house can he used to keep ... Read More
Chartered Accountant (CA) is one of the best career paths and can be chosen by anyone who is good with numbers. A student who is opting for CA course can be from any background like sciences, economics, and history. It is one of the toughest courses to complete in a single attempt, but when one successfully completes it, will have a bright career ahead.Levels in a CA courseCPT(Common Proficiency Test).IPCC/IPCE (Integrated Professional Competency course).Three years of article ship under a C.A who is practicing.CA final exam.CPTUsually, this exam is given after 12th class but one can take coaching in their ... Read More
In this program we will see how to sort a block of bytes using bubble sorting technique.Problem StatementWrite 8085 Assembly language program to sort numbers in ascending order where n number of numbers are stored in consecutive memory locations starting from 8041H and the value of n is available in memory location 8040H (Using BUBBLE sort).DiscussionIn this program we will arrange the numbers in bubble sorting technique. In this sorting technique, it will be executed in different pass. In each pass the largest number is stored at the end of the list. Here we are taking the numbers from location ... Read More