MyISAM tables report the exact number of rows in a table in the output of SHOW TABLE STATUS so don't prefix the row count with '~'.

2 files changed, 5 insertions, 1 deletions

diff --git a/Source/SPExtendedTableInfo.m b/Source/SPExtendedTableInfo.m
index 2f38fe5e..1bea535a 100644
--- a/Source/SPExtendedTableInfo.m
+++ b/Source/SPExtendedTableInfo.m
@@ -368,6 +368,10 @@
 			
 			value = [dateFormatter stringFromDate:[NSDate dateWithNaturalLanguageString:value]];						
 		}
+		// Prefix number of rows with '~' if this is not a MyISAM table. Only MyISAM tables report the exact row count.
+		else if (([key isEqualToString:@"Rows"]) && (![[infoDict objectForKey:@"Engine"] isEqualToString:@"MyISAM"])) {
+			value = [@"~" stringByAppendingString:value];
+		}
 	}
 		
 	return [NSString stringWithFormat:@"%@: %@", label, ([value length] > 0) ? value : @"Not available"];
diff --git a/Source/SPTableInfo.m b/Source/SPTableInfo.m
index 9295aa38..3a2b67b8 100644
--- a/Source/SPTableInfo.m
+++ b/Source/SPTableInfo.m
@@ -131,7 +131,7 @@
 			
 			// Check for 'Rows' == NULL - information_schema database doesn't report row count for it's tables
 			if (![[tableStatus objectForKey:@"Rows"] isNSNull]) {
-				[info addObject:[NSString stringWithFormat:@"rows: ~%@", [tableStatus objectForKey:@"Rows"]]];
+				[info addObject:[NSString stringWithFormat:([[tableStatus objectForKey:@"Engine"] isEqualToString:@"MyISAM"]) ? @"rows: %@" : @"rows: ~%@", [tableStatus objectForKey:@"Rows"]]];
 			} 
 						
 			[info addObject:[NSString stringWithFormat:@"size: %@", [NSString stringForByteSize:[[tableStatus objectForKey:@"Data_length"] intValue]]]];