Getting count of rows in MySQL

Asked Mar 26 '16 at 11:19

Active Mar 26 '16 at 11:27

Viewed 30 times

If I run the query in phpMyAdmin:

SELECT COUNT(*) FROM ResultTable;

I get the warning (5.5.45 - MySQL Community Server):

This table does not contain unique column. Changing the grid of the show, editing, copying, and deleting is not available.

Then I make an existing field result_id as Unique:

ALTER TABLE ResultTable ADD UNIQUE (result_id);

Nevertheless I get the same warning after select query, so where the trouble lies?

edited Mar 26 '16 at 11:27

asked Mar 26 '16 at 11:19

rozerro

It might help to re-login into phpMyAdmin – Alex Shesterov Mar 26 '16 at 11:26
@AlexShesterov Re-login does not make changes. – rozerro Mar 26 '16 at 11:30
2

Take a look at this http://stackoverflow.com/questions/18922503/resolution-this-table-does-not-contain-a-unique-column-grid-edit-checkbox-ed – Mustafa Shujaie Mar 26 '16 at 11:36
1

@MustafaShujaie that completely explains the issue – rozerro Mar 26 '16 at 11:40

0 Answers0