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
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to set global event_scheduler=ON even if MySQL is restarted?
There is a single way by which you can set a global event_scheduler=ON even if MySQL is restarted. You need to set global system variable ON and need to use this system variable even if MySQL restart.For this, I am using system variable @@event_scheduler using select statement. The query is as follows:mysql> select @@event_scheduler;The following is the output:+-------------------+ | @@event_scheduler | +-------------------+ | ON | +-------------------+ 1 row in set (0.00 sec)Now, restart MySQL. The query is as follows:mysql> restart; Query OK, 0 rows affected ...
Read MoreAddition of multi-byte numbers in Z-80
Now, in this section we will see how we can use the Zilog Z-80 Microprocessor to add Multi-byte numbers.In this example, we are using 4-byte numbers (56 2F 7A 89)16 and (21 FB A9 AF)16In the memory, at first, we are storing the byte counts, and then the numbers (from least significant bytes to Most significant bytes) in different segments. So after storing the data, the memory structure will be look like thisAddressValue5000H04H...5050H89H5051H7AH5052H2FH5053H56H...5070HAFH5071HA9H5072HFBH5073H21H...Now, we are writing a program at location 8000H to add these two 4-byte number and store the result at location 5090H onwards.ProgramAddressHex CodesLabelsMnemonicsComments800037SCFSet the carry flag80013FCCFComplement the ...
Read Moreftp_cdup() function in PHP
The ftp_cdup() function changes the current directory to the parent directory.Syntaxftp_cdup(con);Parameterscon − The FTP connectionReturnThe ftp_cdup() function returns TRUE on success or FALSE on failure.ExampleThe following is an example wherein we are updating the current directory to parent directory −
Read MoreExchange of blocks in Z-80
In this section we will see how we can use the Zilog Z-80 Microprocessor to Exchange the contents of each element from two different blocks.The number of items in each block are given at location 5000H, and the blocks are at position 5050H and 5070H.So before swapping the items in the memory is looking like thisAddressValue5000H04H...5050H89H5051H7AH5052H2FH5053H56H...5070HAFH5071HA9H5072HFBH5073H21H...Now, we are writing a program at location 8000H to exchange the block contents.ProgramAddressHex CodesLabelsMnemonicsComments800021 00 50LD HL, 5000HLoad the HL pair with 5000H8003DD 21 50 50LD IX, 5050HSet the index register with 5050H8007DD 7E 00LD A, (IX+00H)Load Acc with IX + 00H800ADD 46 20LD ...
Read MoreWhat points should one keep in mind while dealing with theme writing?
Theme writing is very important under the banner of Academic writing. One must keep it crisp and clear in order to avoid any confusion in it.Things to keep in mind for Theme WritingUnity: All your sentences should work around a central idea. This will happen only when at the beginning itself we know about the keywords and the key sentence in the paragraph. The key sentence in the paragraph defines our field of work or the subject matter of our creative flow of thoughts. We must strategically confine ourselves to eliminate ourselves from any sort of digression from our themeCoherence: ...
Read MoreAs an HR of a company, what kind of attitude should I carry at work?
Human Resource manager or HR of a company holds quite a significant role in the overall functionality of the proceedings carried out in an organization. However, an HR sometimes may appear quite different in the other employees' depiction. So, why does it happen? Plainly because the responsibilities the HR person has to carry. But can it be done without being characterized? Here's the answer:Attitude You Must CarryNot To Be Too Close to Anyone In the Office: Human Resource Manager should be someone who alienates himself/herself in the office. This is because, HR is involved in dealing with leave applications, appraisal ...
Read MoreHow to pass HPE0-S37 Certification exam with flying colors?
To test and certify on one's knowledge about HPE server products and solutions, the HPE0-S37 exam is conducted. By completing the exam and attaining certification, one can increase his/her chances of getting server-related jobs.The question is how to pass the exam with flying colors. Due to the complexity of the course, it is a tough task to pass HPE0-S37. If you know the structure of the exam, you can prepare accordingly and chances of passing will increase. Here is the pattern of questions given during the exam.Foundational server architecture and technology 37%Functions, features, and benefits of HPE server products and ...
Read MoreConvert output of MySQL query to UTF8?
You need to use CAST() or CONVERT() function to convert output of MySQL query to UTF8. Here, I am using MySQL version 8.0.12. Let us first check the version:mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.12 | +-----------+ 1 row in set (0.00 sec)In this if you use utf8 then you will get warning of aliases because it has utf8mb4. Therefore, you can avoid the warning by placing utf8mb4.Note: Never use UTF8. For current versions, use UTF8MB4Here is the syntax to convert output of MySQL query to UTF8:SELECT yourColumnName1, convert(yourColumnName2 USING utf8) as anyVariableName FROM ...
Read MoreHow to echo print statements while executing an SQL script?
To perform echo print statements while executing SQL scripts, use the following syntax.The syntax is as follows −SELECT ‘anyStringValue as’ ‘;The query is as follows −mysql> select 'This is a SQL Script' AS' ';The following is the output −+----------------------+ | | +----------------------+ | This is a SQL Script | +----------------------+ 1 row in set, 1 warning (0.00 sec)You can add dynamic data to your status like insert, update and delete with the help of concat() function. The query is ...
Read MoreWhy do companies focus on customer satisfaction scores?
Every business will have stiff competition from already established businesses and brands. Nowadays whether it is simple chips packet or a luxury car, people have become smart enough to go through the reviews and customer ratings before they buy. People will judge by hearing the name of the brand and make decisions based on other customer's reviews. These trends are seen more in online eCommerce sites.It's clear that customer satisfaction metrics are essential for any business. They impact the decisions of current and potential customers. This is the reason, you should never ignore the importance of customer satisfaction. Online surveys ...
Read More