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 61     Previous     Next
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.
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.
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.
Empowering MySQL to Send Batched Statements in a Single Request
by Octavia Anghel
Language: SQL, Expertise: Intermediate - See how to empower MySQL to send batched statements in a single request.
Knowing the Privileges of the Current User in MySQL
by Sridhar M S
Language: SQL, Expertise: Intermediate - See how to figure out what privileges users have in MySQL.
Understanding the Unique Keyword in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how to ensure that a certain combination of column values is unique in a table.
Figure Out the Length of Text in a Column in MySQL
by Sridhar M S
Language: SQL, Expertise: Intermediate - See an easy way to find out the length of the text in a column.
Selecting the Max, Min and Sum of Values from a Table in MySQL
by Sridhar M S
Language: SQL, Level: Intermediate: - Learn how to find the Max, Min and Sum of values from a column in a table in MySQL.
Getting the Current Date and Time in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to use the NOW() function in MySQL to get the current time and date.
1-20 of 61     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date