要计算列上的唯一值,您需要使用关键字DISTINCT。要了解它是如何完成的,让我们创建一个表。创建表的查询如下-mysql> create table UniqueCountByIPAddress
-> (
-> Id int NOT NULL AUTO_INCREMENT,
-> UserHits int,
-> UserIPAddress varchar(50),
-> PRIMARY KEY(Id)
-> );
使用insert命令在表中插入一些记录。查询如下-mysql> insert into UniqueCountByIPAddress(UserHits,UserIPAddress) values(10,'127.0.0.1');
mysql> insert into UniqueCountByIPAddress(UserHits,UserIPAddress) values(10,'127.0.0.1');
mysql> insert into UniqueCountByIPAddress(UserHits,UserIPAddress) values(20,'127.0.0.1');
mysql> insert into UniqueCountByIPAddress(UserHits,UserIPAddress) values(20,'127.0.0.1');
mysql> insert into UniqueCountByIPAddress(UserHits,UserIPAddress) values(20,'127.0.0.2');
mysql> insert into UniqueCountByIPAddress(UserHits,UserIPAddress) values(20,&#