Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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 More
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 More
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 More
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 More
What is Bus Arbitration?A device that initiates data transfers on the bus at any given time is called a bus master.In a computer system, there may be more than one bus master such as a DMA controller or a processor etc.These devices share the system bus and when a current master bus relinquishes another bus can acquire the control of the processor.Bus arbitration is a process by which next device becomes the bus controller by transferring bus mastership to another bus.Types of Bus ArbitrationThere are two types of bus arbitration namelyCentralised Arbitration.Distributed Arbitration.Only single bus arbiter performs the required arbitration ... Read More
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 More
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
In this program we will see how to add a blocks of data using 8085 microprocessor.Problem StatementWrite 8085 Assembly language program to add N 1-byte numbers. The value of N is provided.DiscussionIn this problem we are using location 8000H to hold the length of the block. The main block is stored from address 8010H. We are storing the result at location 9000H and 9001H. The 9000H holding the lower byte, and 9001H is holding the upper byte.Repeatedly we are taking the number from the memory, then adding it with accumulator and increase the register E content when carry flag is ... Read More
To add a submit button at the end of a table view, we can make use of table view footers. Let’s see this with help of an example where we’ll add a footer view to our table, and inside the table, we will add code for adding button at the bottom of the table view.Create a new project first, then inside the view controller add the following code which will initialize the table, add a section and a few rows to the table.func initTableView() { let tableView = UITableView() tableView.frame = self.view.frame tableView.dataSource = self tableView.delegate ... Read More
Python pickle module is used for serializing and de-serializing python object structures. The process to converts any kind of python objects (list, dict, etc.) into byte streams (0s and 1s) is called pickling or serialization or flattening or marshalling. We can converts the byte stream (generated through pickling) back into python objects by a process called as unpickling.Why Pickle?: In real world sceanario, the use pickling and unpickling are widespread as they allow us to easily transfer data from one server/system to another and then store it in a file or database.Precaution: It is advisable not to unpickle data received ... Read More