×
Home
Jobs
Tools
Coding Ground
Current Affairs
UPSC Notes
Online Tutors
Whiteboard
Net Meeting
Tutorix
Login
Packages
Categories
Java
JSP
iOS
HTML
Android
Python
C Programming
C++ Programming
C#
PHP
CSS
Javascript
jQuery
SAP
SAP HANA
Data Structure
RDBMS
MySQL
Mathematics
8085 Microprocessor
Operating System
Digital Electronics
Analysis of Algorithms
Mobile Development
Front End
Web Development
Selenium
MongoDB
Computer Network
General Topics
Library
Videos
Q/A
eBooks
Login
Library
Videos
eBooks
Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Selected Reading
UPSC IAS Exams Notes
Developer's Best Practices
Questions and Answers
Effective Resume Writing
HR Interview Questions
Computer Glossary
Who is Who
Mkotla
has Published
118
Answers
How can I use MySQL INTERVAL keyword while extracting the part of the date?
MySQL
MySQLi
Database
mkotla
Published on 19-Feb-2018 14:52:58
With the help of following example we can understand that how we can use MySQL INTERVAL keyword with EXTRACT() function −mysql> Select StudentName, RegDate, EXTRACT(YEAR from RegDate+INTERVAL 2 year) AS 'Two Year Interval' from testing where StudentName = 'Gaurav'; +-------------+---------------------+-------------------+ | StudentName | RegDate ...
Read More
Why I got output 0(Zero) on converting date like ‘1965-05-15’ to TIMESTAMP?
MySQL
MySQLi
Database
mkotla
Published on 19-Feb-2018 11:28:02
As we know that with the help of MySQL UNIX_TIMESTAMP function, we can produce the number of seconds from given date/DateTime. But when we try to convert a date like ‘1965-05-15’ it would give 0(Zero) as output because the range of TIMESTAMP is between ‘1970-01-01 00:00:01’ to ‘2038-01-19 08:44:07’. Hence, ...
Read More
What is the difference between CHAR and NCHAR in MySQL?
MySQL
MySQLi
Database
mkotla
Published on 19-Feb-2018 10:18:27
Both CHAR and NCHAR are fixed length string data types. They have the following differences −CHAR Data TypeNCHAR Data TypeIts full name is CHARACTER.Its full name is NATIONAL CHARACTERIt uses ASCII character setIt uses Unicode character set and data is stored in UTF8 formatIt occupies 1-byte of space for each ...
Read More
What is onmouseup event in JavaScript?
Javascript
Web Development
Front End Technology
mkotla
Published on 16-Feb-2018 15:08:30
The onmouseup event triggers when a mouse button is released.ExampleYou can try to run the following code to learn how to work with onmouseup event in JavaScript −<html> <head> <script> <!-- function sayHello() { ...
Read More
What are regular expressions in JavaScript?
Javascript
Web Development
Front End Technology
mkotla
Published on 16-Feb-2018 12:14:55
A regular expression is an object that describes a pattern of characters. The JavaScript RegExp class represents regular expressions, and both String and RegExp define methods that use regular expressions to perform powerful pattern-matching and search-and-replace functions on the text.A regular expression could be defined with the RegExp () constructor, as ...
Read More
How to get the smallest integer greater than or equal to a number in JavaScript?
Javascript
Web Development
Front End Technology
mkotla
Published on 16-Feb-2018 11:23:25
To get the smallest integer greater than or equal to a number, use the JavaScript Math.ceil() method. This method returns the smallest integer greater than or equal to a number.ExampleYou can try to run the following code to get the smallest integer greater than or equal to a number −<html> ...
Read More
How to use the submit button in HTML forms?
Javascript
Web Development
Front End Scripts
mkotla
Published on 07-Feb-2018 12:21:46
Submit button automatically submits a form on click. Using HTML forms, you can easily take user input. The <form> tag is used to get user input, by adding the form elements. Different types of form elements include text input, radio button input, submit button, etc.Let’s learn about how to use ...
Read More
How to take user input using HTML forms?
Javascript
Web Development
Front End Scripts
mkotla
Published on 07-Feb-2018 11:27:23
Using HTML forms, you can easily take user input. The <form> tag is used to get user input, by adding the form elements. Different types of form elements include text input, radio button input, submit button, etc.Let’s learn about the <input> tag, which helps you to take user input using ...
Read More
How can I clear or empty a StringBuilder in Java.
Java 8
Object Oriented Programming
Programming
mkotla
Published on 06-Feb-2018 14:58:42
You can either setLength to be 0 or create a new StringBuilder() instance. See the example below −Examplepublic class Tester { public static void main(String[] args) { StringBuilder builder = new StringBuilder(); builder.append("sample"); System.out.println(builder.toString()); builder.setLength(0); ...
Read More
How to concatenate byte array in java?
Java 8
Object Oriented Programming
Programming
mkotla
Published on 06-Feb-2018 12:50:35
You ByteArrayOutputStream to write byte arrays and get the result using its toByteArray() method.import java.io.ByteArrayOutputStream; import java.io.IOException; public class Tester { public static void main(String[] args) throws IOException { byte[] a = { 1, 2, 3}; ...
Read More
Previous
1
...
4
5
6
7
8
9
10
...
12
Next
Advertisements
Print
Add Notes
Bookmark this page
Report Error
Suggestions
Save
Close
Dashboard
Logout