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 67     Previous     Next
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.
Disabling Binary Logs in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Sometimes there are just too many logs available to sift through efficiently. Learn how to disable the binary logs in MySQL to cut down on the clutter.
How to Change the Storage Engine in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to change the storage engine used in MySQL to improve application performance.
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.
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.
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.
How to Use the Show ProcessList in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to list all of the processes that hold a valid connection to the database.
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 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 the Insert on Duplicate Key Update in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn more about the insert on duplicate key update and how to use it in MySQL.
Understanding the AVG Function in MySQL
by Sridhar M S
Language: SQL, Expertise: Intermediate - Learn how to use the AVG function to calculate the average in MySQL.
1-20 of 67     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date