mysql数据库select赋值

1、登录mysql中，在test数据库新建一个表：CREATETABLE`shoufei`(`id`int(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

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

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