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