mysql数据库select赋值

2025-03-16 00:39:27

1、登录mysql中,在test数据库新建一个表:CREATETABLE`shoufei`(螬绣囤扮`id`i荏鱿胫协nt(11)NOTNULLAUTO_INCREMENT,`shijian`timestampNOTNULLDEFAULTCURRENT_TIMESTAMP,`xiangmu`varchar(20)NOTNULL,`jiage`floatNOTNULL,`shuliang`int(11)NOTNULL,`jine`floatDEFAULTNULL,PRIMARYKEY(`id`))ENGINE=InnoDBAUTO_INCREMENT=6DEFAULTCHARSET=utf8

mysql数据库select赋值

2、在表中增加一些数据:insert into `shoufei` (`id`, `shijian`, `xiangmu`, `jiage`, `shuliang`, `jine`) values('1','2019-01-28 11:15:52','银翘解毒丸','2','10','20');insert into `shoufei` (`id`, `shijian`, `xiangmu`, `jiage`, `shuliang`, `jine`) values('2','2019-01-28 11:15:59','甘草片','20','2','30');insert into `shoufei` (`id`, `shijian`, `xiangmu`, `jiage`, `shuliang`, `jine`) values('3','2019-01-28 11:16:04','阿莫西林','20','2','40');insert into `shoufei` (`id`, `shijian`, `xiangmu`, `jiage`, `shuliang`, `jine`) values('4','2019-01-28 11:16:08','午时茶','8','1','8');insert into `shoufei` (`id`, `shijian`, `xiangmu`, `jiage`, `shuliang`, `jine`) values('5','2019-01-28 11:16:12','银翘解毒丸','2','10','20');

mysql数据库select赋值

3、把id=2的记录,xiangmu字段值赋值给@xm用户变量,并且显示@xm值;SELECT xiangmu INTO @xm FROM shoufei WHERE id=2;SELECT @xm;

mysql数据库select赋值

4、把id=3的记录,xiangmu、jiage字段值赋值@xm、@jg,并且显示.SELECT xiangmu ,jiage INTO @xm,@jg FROM shoufei WHERE id=3;SELECT @xm,@jg;

mysql数据库select赋值

5、把id=4的记录,计算出金额:SELECT xiangmu ,jiage*shuliang INTO @xm,@je FROM shoufei WHERE id=4;SELECT @xm,@je;

mysql数据库select赋值

6、把id=5的记录,登记时间赋值给 @lr:SELECT CONCAT(shijian,xiangmu) INTO @lr FROM shoufei WHERE id=5;SELECT @lr;

mysql数据库select赋值
声明:本网站引用、摘录或转载内容仅供网站访问者交流或参考,不代表本站立场,如存在版权或非法内容,请联系站长删除,联系邮箱:site.kefu@qq.com。
猜你喜欢