SQL语句查询问题 一条SQL语句我做的是个搜索既要搜索出 得到的内容 就要计算搜索的结果的其中的credit字段的总和请问有一条 SQL语句能达到这样的效果吗? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我又想得到所有字段的内容 又想得到credit字段的总和 用一句SQL解决 就是想得到所有字段的内容 同时得到credit字段里值得总和 这个意思?select *,(select sum(credit) from a) from a; #例:表数据mysql> select * from csdn_test3;+-----+---------+--------+----------+------+----------+--------+| vid | content | detail | username | uid | dateline | credit |+-----+---------+--------+----------+------+----------+--------+| 1 | cont1 | det1 | name1 | 43 | 20120702 | 2 || 2 | cont2 | det2 | name1 | 43 | 20120701 | 1 || 3 | cont3 | det3 | name3 | 11 | 20120702 | 8 |+-----+---------+--------+----------+------+----------+--------+3 rows in set (0.00 sec)#sqlmysql> SELECT *, (SELECT SUM(credit) FROM csdn_test3) AS SUM FROM csdn_test3;+-----+---------+--------+----------+------+----------+--------+------+| vid | content | detail | username | uid | dateline | credit | SUM |+-----+---------+--------+----------+------+----------+--------+------+| 1 | cont1 | det1 | name1 | 43 | 20120702 | 2 | 11 || 2 | cont2 | det2 | name1 | 43 | 20120701 | 1 | 11 || 3 | cont3 | det3 | name3 | 11 | 20120702 | 8 | 11 |+-----+---------+--------+----------+------+----------+--------+------+3 rows in set (0.00 sec) php 绝对路径问题 PHPCMS的问题 PHP实现文件下载,但使用迅雷时总是PHP文件被下载 ODBC 驱动程序管理器未发现数据源名称并且未指定默认驱动程序 高分求网站安全扫描软件 求助一个PHP的网站程序,达到的效果请看文章说明 php+mysql生成动态树型菜单 跪求一段登陆的php代码!!!紧急!!!谢谢啦! unexpected $end error why? SQL 问题:更新数据库...... 表单提交 刚刚学习PHP,安装时遇到了问题
就是想得到所有字段的内容 同时得到credit字段里值得总和
select *,(select sum(credit) from a) from a;
#例:表数据
mysql> select * from csdn_test3;
+-----+---------+--------+----------+------+----------+--------+
| vid | content | detail | username | uid | dateline | credit |
+-----+---------+--------+----------+------+----------+--------+
| 1 | cont1 | det1 | name1 | 43 | 20120702 | 2 |
| 2 | cont2 | det2 | name1 | 43 | 20120701 | 1 |
| 3 | cont3 | det3 | name3 | 11 | 20120702 | 8 |
+-----+---------+--------+----------+------+----------+--------+
3 rows in set (0.00 sec)#sql
mysql> SELECT *, (SELECT SUM(credit) FROM csdn_test3) AS SUM FROM csdn_test3;
+-----+---------+--------+----------+------+----------+--------+------+
| vid | content | detail | username | uid | dateline | credit | SUM |
+-----+---------+--------+----------+------+----------+--------+------+
| 1 | cont1 | det1 | name1 | 43 | 20120702 | 2 | 11 |
| 2 | cont2 | det2 | name1 | 43 | 20120701 | 1 | 11 |
| 3 | cont3 | det3 | name3 | 11 | 20120702 | 8 | 11 |
+-----+---------+--------+----------+------+----------+--------+------+
3 rows in set (0.00 sec)