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 Abhinanda Shri
Page 4 of 5
What is the use of ALLOW_INVALID_DATES SQL mode?
As the name suggests, enabling ALLOW_INVALID_DATES SQL mode will allow us to store invalid dates in the table. The example is given below to understand it −Examplemysql> SET sql_mode = ALLOW_INVALID_DATES; Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> Insert Into detail_bday(Name, Birth_Date) values('Sonia', '1993-11-31'); Query OK, 1 row affected (0.09 sec) mysql> Insert Into detail_bday(Name, Birth_Date) values('Ram', '0000-00-00'); Query OK, 1 row affected (0.10 sec) mysql> Select * from detail_bday; +----+---------+------------+ | Sr | Name | Birth_Date | +----+---------+------------+ | 1 | Saurabh | 1990-05-12 | | 2 | Raman | 1993-06-11 ...
Read MoreHow can I use INTERVAL keyword with MySQL NOW() and CURDATE() functions?
INTERVAL keyword with NOW() and CURDATE() MySQL functions can be used in similar fashion as it can be used with time, date or datetime units of a date value.ExampleUsing INTERVAL with MySQL NOW()mysql> Select NOW() + INTERVAL 2 day; +------------------------+ | NOW() + INTERVAL 2 day | +------------------------+ | 2017-10-30 09:19:31 | +------------------------+ 1 row in set (0.00 sec) mysql> Select NOW() - INTERVAL 2 day; +------------------------+ | NOW() - INTERVAL 2 day | +------------------------+ | 2017-10-26 09:19:45 | +------------------------+ 1 row in set (0.00 sec) mysql> Select NOW() - INTERVAL 2 hour; +-------------------------+ | NOW() ...
Read MoreHow to create a multi-resolution favicon with GIMP?
Favicons are generally 16x16, but these days we can multi-resolution favicons also. To create a multi-resolution favicon, first, you need to create the highest-resolution version of the favicon, with an image of 256 × 256 px. Reduce the size of multiple resolutions and export, 16x16, 32x32.Open GIMP and from the File menu, open the 32x32 version of the Favicon. After that rightclick on the image and Open the other Favicon icons as layers,After that Export the image as Favicon, with extension .ico and add it to the website using the following code −
Read MoreWhat does the method set(int, obj o) do in java?
The set() method of the ArrayList class replaces the element at the specified position in this list with the specified element.Exampleimport java.util.ArrayList; public class Sample { public static void main(String args[]) { ArrayList al = new ArrayList(); System.out.println("Initial size of al: " + al.size()); al.add("C"); al.add("A"); al.add("E"); al.add(1, "A2"); System.out.println("Size of al after additions: " + al.size()); System.out.println("Contents of al: " + al); System.out.println("Size of al after deletions: " + al.size()); ...
Read MoreWhat does the method size() do in java?
The size() method of the class java.util.ArrayList returns the number of elements in this list i.e. the size of the list.Exampleimport java.util.ArrayList; public class ArrayListDemo { public static void main(String[] args) { ArrayList arrlist = new ArrayList(5); arrlist.add(15); arrlist.add(20); arrlist.add(25); arrlist.add(22); for (Integer number : arrlist) { System.out.println("Number = " + number); } int retval = arrlist.size(); System.out.println("Size of list = " + retval); } }OutputNumber = 15 Number = 20 Number = 25 Number = 22 Size of list = 4
Read MoreAccessing Source code of SAP Transport without using SAP system
I don’t think it is possible to check source code without SAP system until you understand SAP Binary code. The format in which the data are stored in the data file is AFAIK, an SAP own format and you can use R3trans to read code using the command.R3trans -l [-w ] [-v ]To know more about R3trans, you can refer to this link −https://archive.sap.com/discussions/thread/1277788
Read MoreInteracting SAP and Navision using 3rd party applications
There are many middleware tools that work as middleware for integrating different applications. There exists a vast variety of them but choosing a correct one is based on the applications being integrated.For integrating the third-party application with either SAP or Navision, you can use Apache Camel. Also, SAP provides a framework - SAP PI - SAP NetWeaver Process Integration.Lately, SAP Business One has emerged as the preferred choice for integration of third-party applications with SAP. It is highly preferred by developers as it provides vast options for handling various use cases. Its working is based on either of the two ...
Read MoreWhy do we use restrict qualifier in C++?
There's no such keyword in C++. List of C++ keywords can be found in section 2.11/1 of C++ language standard. restrict is a keyword in the C99 version of C language and not in C++.In C, A restrict-qualified pointer (or reference) is basically a promise to the compiler that for the scope of the pointer, the target of the pointer will only be accessed through that pointer (and pointers copied from it).C++ compilers also support this definition for optimization purposes, but it is not a part of the official language specification.
Read MoreDifference between undefined, unspecified, and implementation-defined behavior in C and C++?
Undefined behavior is simply behavior that is not defined by the C++ specification. For example, if you have multiple unary increment/decrement operations in an expression like i++ + ++i, they result in behavior that is not defined. This is simply due to the fact that some language constructs are syntactically valid but you can't predict the behavior when the code is run. Another example is the expression: u = (u++);Implementation-defined behavior is behavior unspecified by the specification and left for the implementor to decide and document how the choice is made. In this case, the choice that is made must ...
Read More