create table x(
id tinyint(5) unsigned not null auto_increment,
name char(25) not null default '',
price DECIMAL(4,2) unsigned not null default '0',
primary key(id),
unique key name(name)
)engine=myisam default charset=utf8
insert into x(id,name,price)values(null,'冰红茶',3.5);
insert into x(id,name,price)values(null,'电饭锅',99);
create table y(
id tinyint(5) unsigned not null auto_increment,
individual tinyint(5) unsigned not null,
primary key(id)
)engine=myisam default charset=utf8
insert into y(id,individual)values(null,4);
insert into y(id,individual)values(null,2);
查询输出结果要这样:212 = 14+198
解决方案 »
- mysql 的limit 问题 非常简单
- mysql分表问题
- (救急)mysql连接报错:ERROR 2013 (HY000): Lost connection to MySQL server during query
- mysql 位运算 怎么处理? 在线等!
- 一个关于Group by与外键选择数据的问题
- MYSQL如何根据字段删除2个表结果不相同的数据?
- 插入mysql 繁体字时,程序报错,急,急
- 难题求解:往100万条数据中插入1万条,有什么好的办法提高效率?
- mysql-front 2.5 安装问题?解决问题马上结分!谢谢!
- 如何在php中使用下列mysql语句?
- mysqldump 怎么写的
- 面试之sql,大家进来看看怎么做?
from x,y
where x.id=y.id
+---------------------------------------------------------------------------------------------+
| concat(sum(x.price*y.individual),'=',x.price,'*',y.individual,'+',x.price,'*',y.individual) |
+---------------------------------------------------------------------------------------------+
| 212.00=3.50*4+3.50*4 |
+---------------------------------------------------------------------------------------------+