dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

MySQL

1-20 of 79     Previous     Next
Using JSON as a Data Type
by Sridhar MS
Language: SQL, Expertise: Intermediate - MySQL is a very robust database that supports JSON as a data type. See how to make this feature work for you.
Types of Engines that Are Supported in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how to use the query in the example to display the list of available engines that are supported in MySQL.
Finding the TAN of a Given Number
by M S Sridhar
Language: SQL, Expertise: Intermediate - MySQL provides numerous mathematical calculations that can be computed with inbuilt functions. Learn how to find the TAN of a number.
Using the SUBSTRING_INDEX in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how to extract a part of the given string using the SUBSTRING_Index in MySQL.
Locking a User Account in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - MySQL provides a mechanism to alter the user properties, thereby allowing you to lock the user account.
Understanding the Behavior of the AUTO_INCREMENT Column in MySQL
by Sridhar M S
Language: MySQL, Expertise: Intermediate - Auto_Increment can be tricky to use in MySQL, learn more about how it works.
Using MICROSECOND in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Developers often work with time in terms of hours, minutes and seconds. Learn how to break it down to the microsecond level.
Finding the Current Quarter in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to use MySQL to find the current financial quarter.
Using ENUM to Pre-define Column Values in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how the values for a particular column can be pre-defined during the table definition. These values will be validated when the records are inserted or updated in the table.
Converting UNIX_TIMESTAMP to Readable Format in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn more about a quick and neat way of converting the current time from Unix format to Readable format.
Getting the Last ID in MySQL
by M S Sridhar
Language: SQL Expertise: Intermediate - Explore how MySQL supports AUTO_INCREMENT column types when many instances require the last value that was inserted to be used in reporting.
Understand the AES Encryption Method
by M S Sridhar
Learn how to understand the AES ENCRYPTION method that is supported by MySQL.
Using the WEEKOFYEAR Function in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to use calendar functionality in MySQL to figure out in which week a given date belongs.
Use MySQL for Calculations
by Sridhar MS
Language: SQL, Expertise: Intermediate - See a few different ways to use MySQL to compute the result of a mathematical formula.
User Creation and Scenarios
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn more about the importance of providing a password during the user creation process itself.
Understanding NULL in MySQL
by Sridhar MS
Language: SQL, Expertise: Intermediate - See how to work with NULL in MySQL. Examine a few examples in which you might be confused with the output unless you are very comfortable using NULL.
Using REGEX Case Sensitively
by Srinath MS
Language: SQL, Expertise: Intermediate - See how to navigate using regex case sensitively in MySQL.
Understanding Checksum Table in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to verify if the related files/contents are not tampered with or corrupted.
Renaming a User in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to change a user name in MySQL, as requirements may be updated along the development process.
Setting Up a PROXY User in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how to set up a proxy user that has the same permissions as the original user.
1-20 of 79     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date