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
Why is social reputation necessary for the scientific community people?
Social reputation is a common desire for every human being. Having lived in a society, any person acquires some reputation depending on the behavior, etiquettes, profession, maintenance, nature etc. from the people around him. When we refer to a group of people who belong to a certain community, they usually form societies and communities and plan activities as we witness in social media daily, to increase their social reputation. Such activities often involve social causes.Scientific Community PeoplePeople who took science as their profession, especially Scientists, researchers, scholars etc. can be referred to as Scientific Community people. Unlike normal people, they ...
Read MoreWhat is personification in English?
Personification is the attributing of human characteristics, thoughts, or emotions to something that is non-human. It is a rhetoric device that is used to convey something more than a literary meaning of a sentence.Example: The heavens wept at the incident.Now, in this sentence, heavens cannot weep but the idea of emotions and weeping is produced through “wept”. Heaven is non-living and it is weeping just like humans do. Hence, the sentence features personification.Example: The thunder clapped angrily from a distance.Definitely, the thunder cannot clap. It is a non-living thing but the writer wants to convey the intensity of clapping by ...
Read MoreCheck if a user exists in MySQL and drop it?
To check how many users are present in MySQL, use MySQL.user table. The syntax is as follows to check how many users are present.mysql> SELECT User FROM mysql.user;The following output displays the users −+------------------+ | User | +------------------+ | Mac | | Manish | | mysql.infoschema | | mysql.session | | mysql.sys | | root ...
Read MoreHow to get battery level and state in Android?
This example demonstrates how to get battery level and state in Android.Step 1 - Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 - Add the following code to res/layout/activity_main.xml. In the above code, we have taken a text view. it contains battery percentage.Step 3 - Add the following code to src/MainActivity.javapackage com.example.andy.myapplication; import android.os.BatteryManager; import android.os.Build; import android.os.Bundle; import android.support.annotation.RequiresApi; import android.support.v7.app.AppCompatActivity; import android.widget.TextView; public class MainActivity extends AppCompatActivity { int view = R.layout.activity_main; TextView text; @RequiresApi(api = ...
Read MoreHow to front pad zip code with "0" in MySQL?
To front pad zip code with 0, use LPAD() function in MySQL. The syntax is as follows −SELECT LPAD(yourColumnName, columnWidth+1, '0') as anyVariableName from yourTableName;To understand the above concept of LPAD() to add front pad zip code with 0, let us create a table. One of the columns of the table is Zip Code. The following is the query to create a table.mysql> create table ZipCodePadWithZeroDemo −> ( −> Name varchar(200), −> YourZipCode int(6) −> ); Query OK, 0 rows affected (0.44 sec)Insert some records in the table. The query to insert records is as follows ...
Read MoreWho are the three musketeers in the historical novel written by Alexandre Dumas?
Alexandre Dumas was the French author who wrote “The Three Musketeers” historical novel in 1844. This novel got popular because of the adventures, plot and the then political scenario consisting of the issues between Monarchists and Republicans that were discussed. The war between France and England during the time of King Louis XIV was also mentioned in this novel.The Three MusketeersThe three musketeers are actually four, with the protagonist who is the young man named d’Artagnan. He befriends three musketeers named Athos, Porthos and Aramis before joining the elite corps in Paris. This is a well-written novel involving loyalty, betrayal, ...
Read MoreHow do I get the creation date of a MySQL table?
To get the creation date of MySQL table, use the information_schema. The syntax is as follows −SELECT create_time FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'yourDatabaseName’ AND table_name = 'yourTableName';Apply the above syntax for your database and the table name. Here I am using the database ‘business’ and table name is ‘student’. The query is as follows −mysql> SELECT create_time FROM INFORMATION_SCHEMA.TABLES -> WHERE table_schema = 'business' -> AND table_name = 'student';The following is the output displaying the creation time of a table −+---------------------+ | CREATE_TIME ...
Read MoreGet the difference between two timestamps in seconds in MySQL?
To get difference between two timestamps in seconds, use two in-built functions TIME_TO_SEC() and TIMEDIFF() in MySQL. The syntax is as follows −select time_to_sec(timediff(yourCoulnName1, yourCoulnName2)) as anyVariableName from yourTableName;To understand the above concept, let us first create a table. The query to create a table.mysql> create table TimeToSecond −> ( −> MyTime timestamp, −> YourTime timestamp −> ); Query OK, 0 rows affected (0.48 sec)Now you can insert some datetime values in the table. The query is as follows −mysql> insert into TimeToSecond values('2016-05-10 10:02:00', '2016-05-10 10:00:00'); Query ...
Read MoreWhat are the codes of Engineering ethics?
The engineering societies such as AAES, ABET, NSPE, IEEE, and AICTE have framed these codes of ethics which are helpful to engineers to strengthen the moral issues on their work. The codes of ethics play at least eight important roles such as the following.Serving and Protecting the PublicEngineers are in a responsible position where trust and trustworthiness, both are essential. A code of ethics functions as a commitment to the profession as a whole that engineers will serve the public health, safety, and welfare. All the remaining ones contribute to this function in some or other way.GuidanceCodes are written in ...
Read MoreWhat is the purpose of any research?
When a new product developed, the Research and Development department initiate and perform an intensive study and get the details to support the project. Research and Development departments help corporations stay ahead of the competition, utilize new technology, and produce goods more efficiently. This is just the purpose of any research.Research PhaseThe research phase includes determining product specifications, production costs, and a production timeline.It contributes to the development, as a scientist or inventor in the field of Science and Technology. The research plan is a map for one’s career as a research science professional.In the medical field, research enables us ...
Read More