
Using MICROSECOND in MySQL
By default, developers work with time up to the level of seconds, i.e. HOURS, MINUTES and SECONDS. There could be instances in which we may want to work on the
By default, developers work with time up to the level of seconds, i.e. HOURS, MINUTES and SECONDS. There could be instances in which we may want to work on the
With MySQL, we can find out the quarter by providing a date. In the example below, we will look at the current quarter with input as current date. Query: SELECT
You may choose to validate the data that you enter in a table either, at the database level or at the application level. Application level is feasible only if the
MySQL has lot of support for working with date and time. The following is a quick and neat way of converting the current time from Unix format to Readable format.
MySQL supports AUTO_INCREMENT column types where the value of a particular column can be auto incremented as, and when, the records are inserted. Many instances would need the last value
MySQL has abundant functions that support a multitude of application needs. Here, we shall use some Calendar functionality to find in which week a given date belongs. Samples: Considering the
At times, when you want to compute the result of a mathematical formula, you can use MySQL to do the task. It is a great tool for this. Here are
Please understand that this USER named SRIDHAR is created without a password and is also dangerous. CREATE USER SRIDHAR Alternatively, you can use the code below to create with a
NULL is a unique value. It represents a value that is not defined and that is not really equal to BLANK (”). While using it in queries, we need to