dcsimg
Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


advertisement
Search the Tips

MySQL

1-20 of 32     Previous     Next
Understanding the INSTR Function
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn more about using the INSTR function in MySQL.
Trimming Decimal Places Using TRUNCATE
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how it is possible to have use cases that result in varying decimal places.
Using MySqlCheck
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn more about this MySQL utility that provides for verifying and taking corrective actions in case of failures.
Understanding Usage of the Position Function
by M S Sridhar
Language: SQL, Expertise: Intermediate - See why POSITION is a powerful function in MySQL.
Improve Performance of Select Queries with LIMIT Keyword in MySQL
by Srinath M S
Language: Enterprise, Expertise: Intermediate - Learn a simple trick to make certain queries perform correctly in MySQL.
Understand Permissions Granted to a User in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to find the permissions available for a given user in MySQL.
Understanding the REPLACE Command in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn more about an easy way to replace full or partial value in a column.
Temporary Tables in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how to use a temporary table in MySQL.
Understanding the DAYOFWEEK Function in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn an easy way to figure out the day of the week for a given date.
Commands to Backup and Restore Data onto a New Database
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to easily backup and restore data to a new database in MySQL.
Understanding the GRANTS for the Current User in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to master the GRANT command to have varied output.
Finding the Difference Between 2 Dates in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See which MySQL function computes the difference between two dates and returns a positive result if the first date is greater than the second date.
Quickly Get a List of Database Tables in MySQL
by Srinath M S
Language: SQL, Expertise: Beginner - Execute this command in MySQL to get a list of all tables in the database.
Connecting to a MySQL Database from the Command Prompt
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn an easy way to connect to a MySQL database from the command prompt.
Create a Table from an Existing Table in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to easily create a new table that includes the indexes of the source table.
Understanding UNION in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to identify unique records in MySQL.
Suppress Errors When Duplicate Data Is Inserted in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how to use INSERT IGNORE in MySQL for cases in which ignoring duplicates might be useful.
Using IFNULL in MySQL
by M S Sridhar
Language: Java, Level: Intermediate: - Check out this MySQL command to handle null effectively in your code.
Identifying all the Index(s) Available on a Table in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn a way to increase performance in MySQL.
Knowing the Version and Supported Engines in MySQL
by M S Sridhar
Language: SQL, Level: Intermediate: - These commands are handy to find out the current version and supported engines in the MySQL.
1-20 of 32     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date