如图所示:
我希望加一个total_price列，值为price+price2的和,这个应该怎么写sql；
select * from ims_goods_1 where price!=0 and price2!=0;
奉上sql文件:
/*navicat mysql data transfersource server : carsource server version : 50518source host : wsy19950503.mysql.rds.aliyuncs.com:3306source database : cartarget server type : mysqltarget server version : 50518file encoding : 65001date: 2015-06-11 15:40:28*/set foreign_key_checks=0;-- ------------------------------ table structure for `ims_goods_1`-- ----------------------------drop table if exists `ims_goods_1`;create table `ims_goods_1` ( `id` int(4) not null auto_increment, `type` tinyint(1) not null comment '1为小保养,2为电瓶', `name` varchar(255) not null default '' comment '商品名称', `price` int(4) not null comment '产品价格', `price2` int(4) not null, primary key (`id`)) engine=myisam auto_increment=14 default charset=utf8;-- ------------------------------ records of ims_goods_1-- ----------------------------insert into `ims_goods_1` values ('1', '1', '曼牌mann', '70', '0');insert into `ims_goods_1` values ('2', '1', '马勒', '29', '0');insert into `ims_goods_1` values ('13', '1', '汉格斯特hengsr', '68', '0');insert into `ims_goods_1` values ('4', '2', '嘉实多 金嘉护sn 10w-40', '152', '0');insert into `ims_goods_1` values ('5', '2', '嘉实多 磁护sn 5w-40', '248', '110');insert into `ims_goods_1` values ('6', '2', '嘉实多 极护sn 0w-40', '376', '125');insert into `ims_goods_1` values ('7', '2', '壳牌 黄喜力hx5 10w-40', '138', '0');insert into `ims_goods_1` values ('8', '2', '壳牌 灰喜力ultra 5w-40', '380', '0');insert into `ims_goods_1` values ('10', '2', '美孚 美孚1号 0w-40', '368', '113');

回复内容： 如图所示:
我希望加一个total_price列，值为price+price2的和,这个应该怎么写sql；
select * from ims_goods_1 where price!=0 and price2!=0;
奉上sql文件:
/*navicat mysql data transfersource server : carsource server version : 50518source host : wsy19950503.mysql.rds.aliyuncs.com:3306source database : cartarget server type : mysqltarget server version : 50518file encoding : 65001date: 2015-06-11 15:40:28*/set foreign_key_checks=0;-- ------------------------------ table structure for `ims_goods_1`-- ----------------------------drop table if exists `ims_goods_1`;create table `ims_goods_1` ( `id` int(4) not null auto_increment, `type` tinyint(1) not null comment '1为小保养,2为电瓶', `name` varchar(255) not null default '' comment '商品名称', `price` int(4) not null comment '产品价格', `price2` int(4) not null, primary key (`id`)) engine=myisam auto_increment=14 default charset=utf8;-- ------------------------------ records of ims_goods_1-- ----------------------------insert into `ims_goods_1` values ('1', '1', '曼牌mann', '70', '0');insert into `ims_goods_1` values ('2', '1', '马勒', '29', '0');insert into `ims_goods_1` values ('13', '1', '汉格斯特hengsr', '68', '0');insert into `ims_goods_1` values ('4', '2', '嘉实多 金嘉护sn 10w-40', '152', '0');insert into `ims_goods_1` values ('5', '2', '嘉实多 磁护sn 5w-40', '248', '110');insert into `ims_goods_1` values ('6', '2', '嘉实多 极护sn 0w-40', '376', '125');insert into `ims_goods_1` values ('7', '2', '壳牌 黄喜力hx5 10w-40', '138', '0');insert into `ims_goods_1` values ('8', '2', '壳牌 灰喜力ultra 5w-40', '380', '0');insert into `ims_goods_1` values ('10', '2', '美孚 美孚1号 0w-40', '368', '113');

select t.*,price+price2 as total_price from ims_goods_1 t where price!=0 and price2!=0;
如果这里的+换成一个比较复杂的运算，比如求这两个数的阶乘的和作为新的列，这个该怎么弄