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
Which rows are returned while using LIMIT with OFFSET in MySQL?
Suppose the LIMIT is 4 and OFFSET is 6 then it will return the rows from 7 to 10 i.e. will end with row 10. The LIMIT 4 and OFFSET 6 returns row 7, 8, 9, 10.You can understand the above concept by implementing LIMIT and OFFSET. Let us create a table.mysql> create table LimitOffsettable -> ( -> Id int -> ); Query OK, 0 rows affected (0.60 sec)Let us insert some records in the table. The query is as follows −Mysql> insert into LimitOffsettable values(1); Query OK, 1 row affected ...
Read MoreTruncate with condition in MySQL?
In MySQL, there is no way to truncate with condition. You cannot use truncate statement with where clause.If you want the condition, use delete command −DELETE FROM yourTableName WHERE youCondition;The above syntax is fine but if you want a faster solution, then DELETE is not good in comparison to Truncate. The advantage with truncate is that it does not write to the logs.Let us create a table. The query to create a table is as follows −mysql> create table DeleteDemo -> ( -> Id int, -> Name varchar(100) ...
Read MoreWhat are the top digital marketing certification exams?
Digital Marketing is the present day career on a boom. It is a way of advertising that provides many ways of online platforms for your product or service, unlike the traditional ways of advertising.To get established yourself as a digital marketing expert, it is always better to get certified. Google AdWords Certification and HubSpot Inbound Certification are the ones which are available for free. You can even try applying them again if you fail to succeed in your initial attempts.Preparing for the HubSpot Inbound Certification enables you to optimize your website and content, helps in making customers as brand promoters ...
Read MoreMySQL SELECT IF statement with OR?
You can use SELECT IF statement with OR. To understand select with OR, let us create a table. The query to create a table is as follows −mysql> create table EmployeeInformation -> ( -> EmployeeId int, -> EmployeeName varchar(100), -> EmployeeStatus varchar(100) -> ); Query OK, 0 rows affected (0.68 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into EmployeeInformation values(1, 'Sam', 'FullTime'); Query OK, 1 row affected (0.23 sec) mysql> insert into EmployeeInformation values(2, 'Mike', 'PartTime'); Query OK, 1 row affected (0.14 sec) mysql> ...
Read More8085 program to search a number in an array of n numbers
In this program we will see how to search an element in an array of bytes using 8085.Problem StatementWrite 8085 Assembly language program to search a key value in an array of data using linear search technique.DiscussionIn this program the data are stored at location 8002H to 8007H. The 8000H is containing the size of the block, and 8001H is holding the key value to search. After executing this program, it will return the address of the data where the item is found and store the address at location 9000H and9001H. If the item is not found, it will return ...
Read MoreMySQL create user if it does not exist?
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 MoreMySQL Query to find tables modified in the last hour?
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 MoreWhat is the largest earthquake in the world?
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 MoreWhere are iOS simulator screenshots stored?
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 MoreWhat are the advantages and disadvantages of working in a BPO?
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