mysql查询插入怎么写 mysql中的查询

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

mysql数据库插入、查询操作

插入：insert into 表名 (id,name) values('1','小名');

删除：delete from 表名 where 条件;

相关问答

Q1: mysql 数据库如何用sql语句查询数据后再插入本表？

你好，很高兴回答你的问题。

我理解你的这个需求可以用下面的语句实现。

insert into table_a (m) select 'efg' as m from table_a where m='abc'

其他字段自行补一下。

如果主键不是自增的话，还需要考虑下主键值。

如果有帮助到你，请点击采纳。

Q2: mysql存储过程实现数据查询与插入

INSERT into total_score_tmpD(

DepartmentNameEnd, StaffId,

StaffName,

CountPerHour,

SkillScoreDisCount ,

DealCount ,

ValueCount,

ValueCountDisCount

)

SELECT DepartmentName, StaffId,

StaffName,

3600/(Select DealAvgSeconds from deal_name_type where DealId='121300')*AVG(DealAvgSeconds/WaitSeconds) ,

Round(3600/(Select DealAvgSeconds from deal_name_type where DealId='121300')*avg(DealAvgSeconds/WaitSeconds)/(select Max(SunValue) From total_score_tmp33)*(select CAST(OptionValue as decimal) from sys_info WHERE OptionName='工作技能权重'),2),

count(StaffId),

Sum(DealValue),

Round(Sum(DealValue)/(select Max(SunValue) From total_score_tmp44)*(select CAST(OptionValue as decimal) from sys_info WHERE OptionName='工作效益权重'),2)

From deal_record

where DepartmentName like concat(DepartmentName2,'%') and DealDateTime BETWEEN STARTDealDateTime and endDealDateTime

group by StaffId;

insert into total_score_tmpc(DepartmentName , StaffId,

StaffName,

ClientNum ,

EvaluateScore ,

EvaluateScoreDisCount)

SELECT DepartmentName, StaffId,

StaffName,

count(StaffId),

Sum(EvaluatePrice),

Round((Sum(EvaluatePrice)/(select Max(SunValue) From total_score_tmp22))*(select CAST(OptionValue as decimal) from sys_info WHERE OptionName='服务评价权重'),2)

From evaluate_record

where DepartmentName like concat(DepartmentName2,'%') and EvaluateDateTime BETWEEN STARTDealDateTime and endDealDateTime

group by StaffId;

Q3: mysql如何根据条件从A表中查询数据并插入B表？

执行结果：aaa 为表A bbb为表B

update aaa a,(

SELECT

b.tt,

group_concat(b.ww) ww

FROM

bbb b

GROUP BY