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 by vanithasree
Page 6 of 6
How does comparison operator work with date values in MySQL?
Comparison operator between dates will work in a logical way. In the following example, while comparing two dates, MySQL is simply comparing two numbers or string −mysql> select 20171027 < 20150825; +---------------------------+ | 20171027 < 20150825 | +---------------------------+ | 0 | +---------------------------+ 1 row in set (0.00 sec)The 0 output shows that the result of the above query is FALSE.mysql> select 20171027 > 20150825; +--------------------------+ | 20171027 > 20150825 | +--------------------------+ | 1 | +--------------------------+ 1 row in set (0.00 sec)The output ‘1’ shows that the result of the above query is TRUE.
Read MoreIn MySQL, when VARCHAR data type will use 1-byte and when 2-bytes prefix length along with data?length along with data?
As we know that in MySQL, VARCHAR values are stored as a 1-byte or 2-byte length prefix plus data. This length prefix points out the number of bytes in the value of data. The data value itself will decide that when VARCHAR data type will use 1-byte and when 2-byte prefix length.A column uses 1-byte length if values require no more than 255 bytes.A column uses 2-byte length if values may require more than 255 bytes.
Read MoreHow to create an ALV in docking container in SAP?
Wa_fieldcat is a structure used as a container for the information that has to be added to t_fieldcat.Following Parameters are passed: * pv_field TYPE any for Field * pv_tabname TYPE any for Table Name * pv_coltext TYPE any for Header TextThese variables can’t append under t_fieldcat without putting them in a unified structure.
Read MoreWhat will happen if the MySQL AUTO_INCREMENT column reaches the upper limit of the data type?
When the AUTO_INCREMENT column reaches the upper limit of data type then the subsequent effort to generate the sequence number fails. That is why it is advised to use a large enough integer data type for the AUTO_INCREMENT column to hold the maximum sequence value required by us. For example, if we will use TINYINT then AUTO_INCREMENT would be able to generate only 127 sequence numbers and in case of UNSIGNED TINYINT, this value can be extended up to 255.
Read MoreWhat are the prerequisites for learning Java?
In fact, you can directly start learning Java without any prior knowledge of programming language. But, the syntax in Java is similar to the syntax of the C programming language, therefore, Knowing C language helps to get hold of Java quickly. Having introduced to object-oriented principles before starting Java, also helps in the understanding of the language so, having an idea on object-oriented languages such as C++ also helps. In short, if you know C or C++ it will be a little bit easier to cope with Java technology.
Read MoreWhat is meant by Java being platform-independent?
When you compile Java programs using javac compiler it generates bytecode. We need to execute this bytecode using JVM (Java Virtual machine) Then, JVM translates the Java bytecode to machine understandable code.You can download JVM’s (comes along with JDK or JRE) suitable to your operating system and, once you write a Java program you can run it on any system using JVM.
Read MoreAre there inline functions in Java?
If a function is inline, the compiler places a copy of the code of that function at each point where the function is called at compile time. Any change to an inline function could require all clients of the function to be recompiled because compiler would need to replace all the code once again otherwise it will continue with old functionality. No, Java does not provide inline functions it is typically done by the JVM at execution time.
Read More