Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Voice over long-term evolution or Voice-over LTE (VoLTE) are the standards in all-IP networks for voice communication as well as data communication over 4G LTE networks. VoLTE offers services like creating, provisioning and managing high-speed voice, data, multimedia and messaging services on a 4G wireless network for mobile and portable devices. It uses the IP multimedia subsystem (IMS) to deliver the services. It transmits everything through only packets and thus supports only packet switching. So, all data from any circuit-switched networks like GSM need to be converted to packets before they are transmitted by VoLTE. The communication is depicted ... Read More
To return Sum as ‘0’ if no values are found, use IFNULL or COALESCE commands. The following is the syntax for IFNULL. SELECT IFNULL(SUM(NULL), 0) AS aliasName; Let us now implement the above syntax in the following query. mysql> SELECT IFNULL(SUM(NULL), 0) AS SUMOFTWO; The following is the output of the above query, which returns 0. +----------+ | SUMOFTWO | +----------+ | 0 | +----------+ 1 row in set (0.00 sec) Here is the syntax for COALESCE. mysql> SELECT COALESCE(SUM(NULL),0) as SUMOFTWO; The following is the output that returns 0 using the SUM() function. +----------+ | SUMOFTWO | +----------+ | 0 | +----------+ 1 row in set (0.00 sec)
We can set the now() function as a default value with the help of dynamic default. First, we will create a table with data type” datetime”. After that, we will set now() as the default value for column “MyTime” as shown below. Creating a table. mysql> create table DefaultDateTimeDemo -> ( -> MyTime datetime default CURRENT_TIMESTAMP -> ); Query OK, 0 rows affected (0.59 sec) After creating the above table, we won’t insert any value while using the insert command. This is done so that we can get the ... Read More
The C# equivalent for Java System.exit(0) is − Environment.Exit(exitCode); The Environment.Exit() method terminates this process and returns an exit code to the operating system. Above, use exitCode as 0 (zero) to show that the process completed successfully. Use exitCode as a non-zero number to show an error, for example − Environment.Exit(1) Return a value 1 to show that the file you want is not present Environment.Exit(2)exit Return a value 2 to indicate that the file is in an incorrect format.
Let us see an example to get the count of each distinct value in a column. Firstly, we will create a table. The CREATE command is used to create a table. mysql> create table DistinctDemo1 - > ( - > id int, - > name varchar(100) - > ); Query OK, 0 rows affected (0.43 sec) Inserting records mysql> insert into DistinctDemo1 values(1, 'John'); Query OK, 1 row affected (0.34 sec) mysql> insert into DistinctDemo1 values(2, 'John'); Query OK, 1 row affected (0.20 sec) ... Read More
In 8085 Instruction set, this instruction MOV M, r will copy 8-bit value from the register r to the memory location as pointed by HL register pair.This instruction uses register addressing for specifying the data. As “r” can have any one of the seven values − r = A, B, C, D, E, H, or L Thus there are seven opcodes for this type of instruction. It occupies only 1-Byte in memory. Mnemonics, Operand Opcode(in HEX) Bytes MOV M, A 77 1 MOV M, B 70 1 MOV M, C ... Read More
Cable television is a popular television system that delivers television programming services through cables. This is different from terrestrial television (where radio waves are transmitted over air and received by antennas) and satellite television (where signals are sent by communication satellites and received by satellite dish). Types of cables used in cable TV coaxial cables through which radio-frequency signals are transmitted fiber optic cables through which light pulses are sent Services offered by Cable TV Originally used for broadcasting television services, the functionalities of cable TV has now been extended for providing different services of computer ... Read More
In the 8085 Instruction set there are four instructions, which belong to the type LXI rp, d16. These instructions are used to load the 16-bit address into the register pair. We can use this instruction to load data from memory location using the memory address, which is stored in the register pair rp. For an example, if the instruction is LXI H, FE50. It means that the FE50 is loaded into the HL register pair. The rp can be BC, DE, HL or SP. The LXI instructions and their Hex-codes are as follows. Mnemonics, Operand Opcode (in HEX) ... Read More
The shortcoming of mysql_real_escape_string is as follows − It has main shortcoming in the modern API while we are making prepared statement. This has another shortcoming for every possible attack when you will typecast. Let us see the typecast syntax in MySQL − (TypeCast)mysql_real_escape_string($_REQUEST['anyColumnName'])); In the above syntax, we are typecasting, but in this case, it is not safer for every possible attack. The other cases include the following − It is not type safe. It is not for injection attack.
Cable television in their early days were called Community Antenna Television (CATV) or sometimes as Community Access Television. It was originally conceived as a method to provide cable TV services to rural areas and hilly terrains. The subscribers who want to avail the cable TV services need to pay a specified monthly subscription charge as well as an initial establishment charge. System Layout The system comprises of a big sized community antenna, installed on a hilltop that can receive broadcast signals from communication satellites. The signals received are amplified, corrected and strengthened by a device attached to the antenna, popularly ... Read More