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 91     Previous     Next
Converting TIME to SECONDS in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate: MySQL provides an inbuilt function named TIME_TO_SEC, that accepts time as a parameter. See an example of how to use it.
Understanding the SPACE Function in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate: While the data is being fetched from the database, you may need to append space in some cases. MySQL provides the SPACE function that can help achieve this.
Understanding INSERT in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate: Learn how to use the override insert function in MySQL.
Understanding the TRIM Function in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate: In MySQL, the TRIM function has additional implementations other than just trimming spaces. See what else you can do.
Understanding Least and Greatest in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate: Explore the least and greatest functions in MySQL.
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.
1-20 of 91     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date