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 Daniol Thomas
Page 8 of 13
How can we drop a MySQL stored procedure?
If we have ALTER ROUTINE privileges for the procedure then with the help of DROP PROCEDURE statement we can drop a MySQL stored procedure. To demonstrate it, we are dropping a stored procedure named ‘coursedetails’ as follows −mysql> DROP PROCEDURE coursedetails; Query OK, 0 rows affected (0.68 sec)The above query will drop the procedure named ‘coursedetails’. It can be confirmed by running the statement SHOW CREATE PROCEDURE which will return an error because the procedure does not exist.
Read MoreWhy is it not good practice to use date values with two-digits years in MySQL?
As we know that, YEAR(2) stores a year in 2-digit format. For example, we can write 69 to store 1969 as a year. In YEAR (2), the year can be specified from 1970 to 2069 (70 to 69).MySQL interprets 2-digit year values with the help of following rules −Year values in the range 00-69 are converted to 2000-2069. Year values in the range 70-99 are converted to 1970-1999.We must not store date values as a 2-digit format because values stored in this format becomes vague as the century is unknown.It can be understood more clearly with the help of following ...
Read MoreHow many DATE data types are supported by MySQL?
MySQL supports following 5 types of DATE data type −DATE - A date is in the range between 1000-01-01 and 9999-12-31. “YYYY-MM-DD” is the default DATE format. For example, January 17th, 1984 would be stored as 1984-01-17.DATETIME − This data type supports a date along with time in the range between 1000-01-01 00:00:00 and 9999-12-31 23:59:59. “YYYY-MM-DD HH:MM:SS” is the default DATETIME format. For example, 2:20 in the afternoon on January 17th, 1984 would be stored as 1984-01-17 14:20:00.TIMESTAMP − A timestamp data type supports a date along with time in the range between ‘1970-01-01 00:00:01’ to ‘2038-01-19 08:44:07’. It ...
Read MoreHow can I alter the color of an HTML5 canvas element using jQuery?
To alter the color of an HTML5 canvas, use −document.getElementById("ID").style.background = red;You can also try the following −var ctx = canvas.getContext('2d'); ctx.fillStyle = "#FF0000"; ctx.fill();
Read MoreBest book to learn Java programming for beginners
Following books are on top from popularity and content wise and are a good resource to learn java programming from beginner to advance level.
Read MoreWhich is the best tool to debug JavaScript/jQuery code?
The following are some of the best browser-based debugging tools for JavaScript −FireBugFireBug is a Firefox addon, widely used to inspect the code. Edit, debug and monitor CSS, HTML, and JavaScript live in any web page.Credit− FirebugDragonFlyDragonFly is a fully-featured suite of developer tools. It supports cross-device and remote debugging, which makes the work of developers easy.Credit − DragonFly
Read MoreHow to Get Started with C++ Programming?
So you've decided to learn how to program in C++ but don't know where to start. Here's a brief overview of how you can get started.Get a C++ CompilerThis is the first step you'd want to do before starting learning to program in C++. There are good free C++ compilers available for all major OS platforms. Download one that suits your platform or you can use the tutorialspoint.com's online compiler on https://www.tutorialspoint.com/compile_cpp_online.phpGCC − GCC is the GNU Compiler chain that is basically a collection of a bunch of different compilers created by GNU. You can download and install this compiler ...
Read MoreHow MySQL evaluates if we export the data to CSV file from a table which contains a NULL value(s)?
If we export the data from a table having NULL values then MySQL will store \N in CSV file for the record MySQL table having NULL values. It can be illustrated with the help of the following example −ExampleSuppose if we want to export the values of the table ‘student_info’ having the following data −mysql> Select * from Student_info; +------+---------+------------+------------+ | id | Name | Address | Subject | +------+---------+------------+------------+ | 101 | YashPal | Amritsar | History | | 105 | Gaurav | Chandigarh | Literature | | 125 | Raman | ...
Read MoreJava Program to retrieve a Stream from a List
Let us first create a List:List list = Arrays.asList(25, 50, 100, 200, 250, 300, 400, 500);Now, create a stream from the List:Stream stream = list.stream(); Arrays.toString(stream.toArray()));The following is an example to retrieve a Stream from a ListExampleimport java.util.Arrays; import java.util.List; import java.util.stream.Stream; public class Demo { public static void main(String[] args) { List list = Arrays.asList(25, 50, 100, 200, 250, 300, 400, 500); System.out.println("List elements..."); for (int res : list) { System.out.println(res); } Stream stream = list.stream(); System.out.println("Stream = "+Arrays.toString(stream.toArray())); } }OutputList elements... 25 50 100 200 250 300 400 500 Stream = [25, 50, 100, 200, 250, 300, 400, 500]
Read MoreJava Program to convert Stream to List
Declare and initialize an Integer array:Integer[] arr = {50, 100, 150, 200, 300, 400, 500, 600, 700, 800, 1000};Now, create a stream with the above elements:Stream stream = Arrays.stream(arr);To convert the above stream to list, use Collectors.toList():stream.collect(Collectors.toList()The following is an example to convert Stream to List:Exampleimport java.util.Arrays; import java.util.stream.Collectors; import java.util.stream.Stream; public class Demo { public static void main(String[] args) { Integer[] arr = {50, 100, 150, 200, 300, 400, 500, 600, 700, 800, 1000}; Stream stream = Arrays.stream(arr); System.out.println("Stream = "+stream.collect(Collectors.toList())); } }OutputStream = [50, 100, 150, 200, 300, 400, 500, 600, 700, 800, 1000]
Read More