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循环求助 关于ltrim()函数 还是一个关于session的问题,贴出来php.ini,帮我看看哪里有错 大家有没发现图片热区问题? 急。。。PHP图片验证码的问题 php里面怎么用Cookie实现页面跳转? 如果我想储存时间,那么这个字段用什么型 我的ultraedit怎么改不了字体啊? 只知道部分文件名,咋迅速判断出该文件是否存在——稚嫩的问题 我准备下一步自己干 表单提交 刚刚学习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)