表的第一列..就好像 SELECT ... FORM ... ORDER BY 1 DESC;
解决方案 »
- C# 连接MYSQL的问题
- 重置MYSQL数据库密码以后APPSERV不能启动了
- mysql里面的date怎么才能只取年月日
- mysql查询:如果将记录按时间段分组
- mysql_real_connect()连接后,获取的MYSQL结构体内容错位。
- 各位老大,请帮我个忙,如何抽取MYSQL数据库其中一个字段中重复的数据.
- 高分求教: 在win2k怎么安装mysql?
- 請問在Linux下copy出來的mySQL文檔可不可以直接在Window2000下使用
- 紧急:mysql被黑,求批量替换关键字的sql语句!
- mysql如何将字符串和函数结果拼接在一起??
- 请教查询问题
- 请问哪有mysql for jdbc的driver?
`a` mediumint(4) NOT NULL auto_increment,
`b` varchar(20) NOT NULL default '',
`c` varchar(20) NOT NULL default '',
`d` tinyint(2) NOT NULL default '1',
`e` varchar(50) default NULL,
PRIMARY KEY (`a`),
UNIQUE KEY `a` (`a`)
) TYPE=MyISAMselect count(1) from table1 == select count(a) from table1 !!
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| usernumber | varchar(15) | YES | MUL | NULL | |
+------------+-------------+------+-----+---------+-------+
1 row in set (0.41 sec)mysql> select count(1) from logoff;
+----------+
| count(1) |
+----------+
| 1461742 |
+----------+
1 row in set (0.03 sec)mysql> select count(1000) from logoff;
+-------------+
| count(1000) |
+-------------+
| 1461742 |
+-------------+
1 row in set (0.00 sec)mysql> select count(0) from logoff;
+----------+
| count(0) |
+----------+
| 1461742 |
+----------+
1 row in set (0.00 sec)mysql> select count(-1) from logoff;
+-----------+
| count(-1) |
+-----------+
| 1461742 |
+-----------+
1 row in set (0.00 sec)
是的.就好像分组后 COUNT(*) = COUNT(Col1) 一样.
参数已没有什么实际意义了.