dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

MySQL - Page 3

41-60 of 77     Previous     Next
Learn the Storage Engine Type of a Table in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - There are plenty of commands in MySQL that are supported for particular types of storage engines. Use this command to know the engine type.
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.
41-60 of 77     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date