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 detect which iOS version is running on the device?
When working on iOS applications, we sometimes need to know the version that's running on an iPhone device. In this article we'll learn how to find the iOS version being used, using an iOS Application.Create an iOS application and in it's viewController's view did load function write the following code.print(" System version - ",UIDevice.current.systemVersion)This will return the iOS version of the device currently in use. Like current version of my simulator is iOS 12.0 hence the result comes asSystem Version – 12.0
Read MoreHow to change collation to utf8_bin in a single line?
You need to use ALTER command to change collation to utf8_bin. The syntax is as follows:ALTER TABLE yourTableName COLLATE utf8_general_ci;To understand the above syntax, let us create a table. The query to create a table is as follows:mysql> create table CollateDemo -> ( -> Id int NOT NULL AUTO_INCREMENT, -> Name varchar(20), -> Age int, -> PRIMARY KEY(Id) -> ); Query OK, 0 rows affected (0.98 sec)Check the DDL of the table. The syntax is as follows:SHOW CREATE TABLE yourTableName;Let us now check the DDL of our table:mysql> show create table CollateDemo;The following is ...
Read MoreHow do I show a MySQL warning that just happened?
To show a MySQL warning, you can use the below syntax −SHOW WARNINGS;The above syntax only displays the immediate warning from MySQL prompt. Suppose you run another query between them or you have lost the MySQL connection, then SHOW WARNINGS will not work.Here is the query to display warnings −mysql> SHOW WARNINGS;Here is the output that displays immediate warning −+-------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Level | Code | Message ...
Read MoreWhat is the difference between SQL and MySQL?
SQLSQL is a type of language that can be used to utilize your database. It is a base language for databases like MySQL, SQL Server, Oracle etc. SQL stands for Structure Query Language and it can be used to utilize the relational database management system.This can also be used for accessing, manipulating and updating data in the database using some commands. The SQL commands are as follows −SELECTUPDATE, etc.SQL can also be used in the creation of schema as well as controlling the data access.MySQLMySQL is a relational database management system that utilizes the SQL command. MySQL provides the tools ...
Read MoreWhat would happen if Earth started to rotate in the opposite direction?
Earth rotates around its own axis which is tilted at 23.5 degrees, from the plane of its orbit around the sun, in the eastward direction. It takes almost 24 hours to complete one rotation. The Earth rotates at a speed of 460 m/s, that is approximately 1650 km/hr at the equator. The angular velocity of the Earth decreases as we keep moving toward the poles.The Earth's rotational speed is slowing down with time. According to atomic clocks, the present day is 1.7 milliseconds slower than a century ago. It is not a big issue as it will take more than ...
Read MoreWhich out of linkedIn and Naukri.com is better?
Are you crazy to get your dream job and find it difficult to chose between Naukri.com and LinkedIn? Before I give any verdict, let's first have a look at the features of both the platforms:Naukri.comNaukri.com is a mass driven platform. There are recruiters who range from small to large firms but here you find most of the recruiters are from the small units.The profiles of users are not easily comparable.The profiles of users are accessible.The provision of referrals and recommendations does not associate itself to Naukri.comThere is no provision to track an individual, who is actively looking for a job ...
Read MoreIs New Technology a boon or bane?
Technology Symbolizes the Advancement of Human Knowledge. It is truly a boon. The advantages are many and the list can go on and on and on.They are:Chemotherapy can help cure cancer.It has made the world a global village. Emails, Whatsapp, and other social media have connected people sitting miles away.We can easily communicate sitting anywhere, anytime.One can use the camera to save memories of important events.Food can be cooked faster in Microwave ovens and electric cookers.The mixer grinders help in the easy grinding of food, and juicers help in extracting juice out of fruits and vegetables.Cell phones are certainly the ...
Read MoreSetup the format of DATETIME to 'DDMM- YYYY HH:MM:SS' with MySQL SELECT?
Whenever you retrieve datetime from a table, the datetime gives ‘YYYY-MM-DD’ format. If you want to change the output, then you need to use in-built date_format() from MySQL.The syntax is as follows −SELECT DATE_FORMAT(yourDatetimeColumnName, yourFormat) as anyVariableName from yourTableName;To understand the above syntax, let us first create a table. The query to create a table is as follows −mysql> create table UserDateFormat -> ( -> ProductId int, -> ProductDeliverDate datetime -> ); Query OK, 0 rows affected (0.93 sec)Insert some records in the table using insert command. The ...
Read MoreWhat is the difference between CDSL and NSDL?
CDSL stands for Central Depository Services India Ltd and NSDL stands for National Securities Depository Ltd. Depository refers to an organization which holds the stocks of investors and shareholders. NSDL and CDSL are the two apex depositories in India. Just like banks take care of cash and deposits, they hold bonds, stocks etc for the shareholders in electronic form.Functioning of CDSL and NSDLWe need not send share certificates physically for transfers like in the old days, the NSDL and CDSL help to convert and hold shares in the Demat form. Since their establishment, we received huge contributions from both these ...
Read MoreHas technology made us stay isolated?
Technology is the application of scientific knowledge for practical purposes, especially in industry. It may be also called as the "advances in computer science.” This technology has actually tamed us. It was thought as a matrix allowing us to connect to the world. But, it has made us the lone ranger.Let Us Look at Some General Terms and FactsNomophobia: The feeling of not having cell phones with you, but still one feels that he carries a phone and this is called Nomophobia. Now, it happens with all of us! We feel that we own a phone every now and then.The ...
Read More