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
How to find MySQL my.cnf on my windows computer?
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.
Read More8085 Assembly language program to find largest number in an array
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 MoreWhat is the difference between a Secured Loan and Unsecured Loan given by Banks?
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 MoreHow to become a Chartered Accountant?
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 More8085 program for bubble sort
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 MoreHow to part DATE and TIME from DATETIME in MySQL?
To part DATE and TIME from DATETIME, you can use the DATE_FORMAT() method from MySQL. The syntax is as follows −SELECT DATE_FORMAT(yourColumnName, '%Y-%m-%d') VariableName, DATE_FORMAT(yourColumnName, '%H:%i:%s') VariableName from yourTableName;To understand the above method DATE_FORMAT(), let us create a table with data type “datetime”.Creating a table −mysql> create table DateAndTimePartDemo -> ( -> YourDateandtime datetime -> ); Query OK, 0 rows affected (0.56 sec)Now, I am inserting current date and time using now(). The query is as follows −mysql> insert into DateAndTimePartDemo values(now()); Query OK, 1 row affected (0.37 sec)Display the record ...
Read MoreHow to check for duplicates in MySQL table over multiple columns?
To check for duplicates in MySQL, you can use group by having clause. The syntax is as follows.select yourColumnName1, yourColumnName2, ......N, count(*) as anyVariableName from yourTableName group by yourColumnName1, yourColumnName2 having count(*) > 1;To understand the above syntax, let us create a table. The query to create a table is as follows.mysql> create table DuplicateDemo -> ( -> StudentId int not null, -> StudentFirstName varchar(100), -> StudentLastName varchar(100), -> Primary Key(StudentId) -> ); Query OK, 0 rows affected (0.50 sec)Insert some records in the table using insert command. The query is as follows.mysql> insert into DuplicateDemo values(1, 'John', 'Smith'); Query ...
Read MoreHow to compare two NSDates in iPhone/iOS?
In this article we'll see how to compare two NSDates in swift. First of all we'll need to create two NSDates.We'll do it in playground instead of simulator this time.First Let's create two different dates.let dateOne = NSDateComponents() dateOne.day = 5 dateOne.month = 6 dateOne.year = 1993 let dateTwo = NSDateComponents() dateTwo.day = 4 dateTwo.month = 2 dateTwo.year = 1995Using these date components we'll create dates and then compare themlet cal = NSCalendar.current let FirstDate = cal.date(from: dateOne as DateComponents) let secondDate = cal.date(from: dateTwo as DateComponents)Now to compare them we'll use a if condition.if secondDate!.compare(firstDate!) == .orderedAscending { ...
Read MoreWhen and why artillery invented?
The class of large military weapons that are used to fire ammunition, are called as Artillery. These are used to target far ranges than the small arms can handle. The artillery includes Field and Infantry guns, Muzzle-loaded guns, Howitzers, Anti-aircraft and Anti-tank guns, heavy and Infantry mortars, Cannons and Autocannons, other large projectile weapons etc.When perfectly aimed, it could destroy the enemy trenches, can kill a group of soldiers or infantry, can destroy their ammunition and communication systems as well.China’s Song DynastyIt was during the middle ages, the artillery especially Cannons were introduced. Cannons which were widely used in wars, ...
Read MoreWhat are plagiarism tools and which is best to use?
Plagiarism is the process of infringement which means presenting other’s work as one’s own. This is mostly done in the content field. The information from web pages, articles, blogs, books etc. is often copied by some to present it as their own work. As the process of content publishing online is increasing day-by-day there are many chances of having copied content, which can be either video, text or images.Google itPlagiarism tools help us identify that copied content. Usually, when we check on google to know whether this is genuine content, the copied part is immediately highlighted with the pages displaying ...
Read More