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 exposes a virtual schema called information_schema that describes every database, table, and column on the server. One of its most useful tables is TABLES, which includes a table_rows column
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