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 |