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 88     Previous     Next
Understanding What Grants a User Has in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to view what permissions a given user has been granted.
Adjusting Views to Reduce Visibility of Data in MySQL
by Sridhar M S
Language: MySQL, Expertise: Intermediate - See how to make it so that tables with sensitive information are not viewable by all.
Using Find_in_Set in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to search for, or look up, a given string.
Using AUTO_INCREMENT in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to set AUTO_INCREMENT values when they need to start from a number of your choice or as per some other criteria.
Using the Locate Command in MySQL
by Sridhar M S
Language: MySQL, Expertise: Intermediate - Finding a particular string in a large data set can be extremely tedious. Fortunately, MySQL has a command called locate to help you find what you need.
Finding the Current User in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how MySQL provides a mechanism to find the current user.
Employing DROP USER in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn to how to properly use the drop user command in MySQL.
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.
1-20 of 88     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date