mysql查询将两列数值相加问题
如图所示:
我希望加一个total_price列,值为price+price2的和,这个应该怎么写SQL;
select * from ims_goods_1 where price!=0 and price2!=0;
奉上SQL文件:
/*
Navicat MySQL Data Transfer
Source Server : car
Source Server Version : 50518
Source Host : wsy19950503.mysql.rds.aliyuncs.com:3306
Source Database : car
Target Server Type : MYSQL
Target Server Version : 50518
File Encoding : 65001
Date: 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为电瓶',</