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 create JSON format with group-concat in MySQL?
You can create JSON format using group_concat() function from MySQL. The syntax is as follows −SELECT yourColumnName1, GROUP_CONCAT(CONCAT('{anytName:"', yourColumnName, '", anyName:"', yourColunName, '"}')) anyVariableName from yourTableName group by yourColumnName1;To understand the above syntax, let us first create a table. The query to create a table is as follows −mysql> create table JsonFormatDemo -> ( -> UserId int, -> UserName varchar(100), -> UserEmail varchar(100) -> ); Query OK, 0 rows affected (0.99 sec)Insert some records in the table using insert ...
Read MoreWhat is a robonaut? Can it replace astronauts in the future?
Robonaut is a NASA robot, which is designed as a humanoid. The artificial intelligence makes it easier for Robonaut to do the same jobs as a human. Robonaut could help with anything from working on the International Space Station to exploring other worlds. The core idea behind the Robonaut series is to have a humanoid machine work alongside astronauts. Its form factor and dexterity are designed such that Robonaut can use space tools and work in similar environments suited to astronauts.These new space explorers won’t need space suits or oxygen to survive outside of the spacecraft. Thus they might help ...
Read MoreNon-Programmable 8-Bit I/O Port
There are two types of Input Output ports. They are Programmable Input Output ports and Non-Programmable Input Output ports. Since the functions of Programmable Input Output ports changed by software they became more popular. We don't need to change the wiring rather the hardware of the I/O port to change the function. Intel 8255 is a popular Input Output chip based on port. Whereas the I/O ports which are non-programmable needs to change the wiring or the hardware to change its complete function. We will see in later that the connection needs to be changed when 8212 works like an ...
Read MoreHow to delete last record (on condition) from a table in MySQL?
To delete last record (on condition) from a table, you need to use ORDER BY DESC with LIMIT 1. The syntax is as follows:DELETE FROM yourTableName WHERE yourColumnName1=yourValue ORDER BY yourColumnName2 DESC LIMIT 1;The above syntax will delete last record (on condition) from a table. It sorts the column in descending order and choose the first element to delete.To understand the above syntax, let us create a table. The query to create a table is as follows:mysql> create table UserLoginTable -> ( -> Id int NOT NULL AUTO_INCREMENT, -> UserId int, -> UserLoginDateTime datetime, -> PRIMARY ...
Read MoreHow to get a list of MySQL user hosts?
Firstly, get a list of MySQL user accounts, using MySQL.user table. You can use select user column from MySQL.user table to get a list of MySQL user accounts.The query is as follows −mysql> select user from MySQL.user;The following output displays all the users −+------------------+ | user | +------------------+ | Manish | | mysql.infoschema | | mysql.session | | mysql.sys | | root | | am | +------------------+ 6 rows in set (0.06 ...
Read MoreWhich is the coldest planet in the solar system?
Neptune is the coldest planet in the solar system as Pluto has been excluded as it was regarded as a dwarf planet. It is the eighth and farthest known planet from the Sun. It has 17 times the mass of Earth and is the fourth largest planet in the solar system. It takes 164.8 years for Neptune to finish one revolution around the sun and the elliptical orbit of Neptune is inclined 1.77° compared to that of Earth.Voyager 2 is the only spacecraft that visited Neptune. It analyzed Neptune's rotation, tilt, weather conditions and also its moons and ring systems.Physical ...
Read MoreWorking of 8212
There are two types of Input Output ports. They are Programmable Input Output ports and Non-Programmable Input Output ports. Since the functions of Programmable Input Output ports changed by software they became more popular. We don't need to change the wiring rather the hardware of the I/O port to change the function. Intel 8255 is a popular Input Output chip based on port. Whereas the I/O ports which are non-programmable needs to change the wiring or the hardware to change its complete function. We will see in later that the connection needs to be changed when 8212 works like an ...
Read MoreHow does the commodity trade market work in India?
Commodity trading is trading in derivatives and commodity spot. There are two different categories of commodities we have to trade: Agricultural commodities and non-agricultural commoditiesAgricultural Commodities: These include grains and oilseeds (soybean, chana, corn, groundnut etc.), livestock, dairy products, bio-fuels etc.Non-Agricultural Commodities: These include Metals like gold, silver, copper etc.Also, there are 24 commodity exchanges in India and three national level commodity exchanges to trade in all permitted commodities.They are Multi Commodity Exchange of India Ltd, Mumbai (MCX), National Multi Commodity Exchange of India Ltd, Ahmedabad (NMCE) and National Commodity and Derivative Exchange, Mumbai (NCDEX)How Does It Work?When you buy ...
Read MoreCan you recommend a free light-weight MySQL GUI for Linux?
You can use phpMyAdmin, since it is one of the best free tools. This can be used for every system with PHP and MySQL. It is a free and open source administration tool for MySQL and MariaDB. PHPMYADMINHere is the URL to download −https://www.phpmyadmin.net/downloads/The following are the features of phpMyAdmin −Open source toolMySQL and MariaDB database management.One of the most popular MySQL administration toolsEasily Import data from CSV and SQLExport data to various formats. These include : CSV, SQL, XML, PDF, Word, Excel, LaTeX, etc.Administering multiple serversYou can also use EMMA. This is also a light-weight application.
Read MoreRetrieve first 40 characters of a text field in MySQL?
To get the first 40 characters from a text field, use LEFT() function from MySQL. The syntax is as follows −SELECT LEFT(yourColumnName, 40) as anyVariableName from yourTableName;To understand the above concept, let us create a table. The query to create a table is as follows −mysql> create table retrieveFirst40Characters −> ( −> AllWords text −> ); Query OK, 0 rows affected (0.59 sec)Now you can insert some record in the table with the help of insert command. The query is as follows −mysql> insert into retrieveFirst40Characters values('This is a query demo ...
Read More