dcsimg
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 36     Previous     Next
Find Indices on a Table in MySQL
by Srinath M S
Language: Enterprise, Expertise: Intermediate - Find the indices on a table in MySQL.
Adding a New Column in a Specific Position
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to specify the location of a new column, rather than just adding it to the end of the current table.
Get Detailed Information on Tables in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how to get detailed information on available tables, record counts, etc., in MySQL.
Finding Duplicate Data Available for Multiple Records
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to find data available for multiple records with MySQL.
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.
1-20 of 36     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date