There are plenty of commands in MySQL that are supported for particular types of storage engines. We can use the following command to know the ENGINE type. SHOW TABLE STATUS
The following statement shows the indices on a table in MySQL. SHOW INDEX FROM ‘LogMaster’
Consider the following table that already exists: CREATE TABLE ‘NUMBERS_TABLE’ (‘ONE’ INT(11) NULL DEFAULT NULL,’THREE’ INT(11) NULL DEFAULT NULL,’FIVE’ INT(11) NULL DEFAULT NULL)COLLATE=’utf8_bin’ENGINE=InnoDB; And we want to add a new
MySQL provides a schema named information_schema. This has a table named TABLES that has detailed information on the available tables, their record count, etc. The query below helps you with
There is plenty of data in tables that could be the same data available for multiple records. We may want to know these details and perform some action. Considering the
MySQL is very powerful with a lot of in-built features. Today we are analyzing the INSTR function. Syntax: INSTR (String, subString) Result: Returns the first index of the subString in
Use cases where we need to have the result with varying decimal places are possible. You can change the value in the resulting field using the TRUNCATE function. Consider the
MySQL provides many utilities for verifying and taking corrective actions in case of failures. One such tool is mysqlcheck Usage: [root@mypc]# mysqlcheck -h -u -p –analyze –databases ; The above
Often, we have queries where we are interested to see if there is a record for the particular where?condition or the first record. These kinds of queries are used in