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 87     Previous     Next
Using COMPRESS in MySQL
by Sridhar MS
Language: SQL, Expertise: Intermediate: See how to easily encrypt text in MySQL with the compress method.
Understanding INSERT IGNORE in MySQL
by Sridhar MS
Language: SQL, Expertise: Intermediate: MySQL supports something named IGNORE along with INSERT, which captures the error as a WARNING. See it in action.
Using REPEAT in MySQL
by Sridhar MS
Language: SQL, Expertise: Intermediate: See how to repeat a particular string a defined number of times.
Understanding UNCOMPRESSED_LENGTH in MySQL
by Sridhar MS
Language: SQL, Expertise: Intermediate: Learn how to get the compressed text results to be the exact length of the original text.
Understanding sql_mode in MySQL
by Sridhar MS
Language: SQL, Expertise: Intermediate - See how to use sql_mode to set values in MySQL.
Understanding FULLTEXT Searches
by Sridhar MS
Language: SQL, Expertise: Intermediate - In MySQL, there is a provision to search based on natural mode. Follow this example to understand the process in detail.
Understanding MAX_USER_CONNECTIONS in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to restrict the number of connections made from a user to the database.
Using CAST for Explicit Conversion in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - MySQL allows you to explicitly convert a number to a string with the help of CAST function. See an example of how to use this feature.
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.
1-20 of 87     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date