如何将查询结果插入一列mysql [英] How to insert a query result into a column mysql

问题描述

好的，所以我执行这个 mysql 命令:

ok so I do this mysql command:

SELECT CONCAT(SUBSTRING(Familenaam,1,4),SUBSTRING(Voornaam,1,4)) AS `Login` FROM tblusers

这给了我 johny cowbell -_> johncowb (=loginname) 的结果，但这是在查询中.

This gives me the result for johny cowbell -_> johncowb (=loginname) but this is in a query.

我希望在登录"列中的表 tblusers 中得到该结果.我该怎么做?

I want that result in my table tblusers in the column "Login". How do I do this?

推荐答案

您可以使用 INSERT INTO .. SELECT 像这样:

You can use INSERT INTO .. SELECT like so:

INSERT INTO tblusers(login)
SELECT 
  CONCAT(SUBSTRING(Familenaam, 1 ,4), SUBSTRING(Voornaam,1,4)) 
FROM tblusers

如果你想更新，你可以这样做:

If you want to update, you can do this:

UPDATE tblusers t1
INNER JOIN
(
   SELECT 
     userid,
     CONCAT(SUBSTRING(Familenaam, 1 ,4), SUBSTRING(Voornaam,1,4)) login
   FROM tblusers
) t2 ON t1.userid = t2.userid
SET t1.login = t2.login

这篇关于如何将查询结果插入一列mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！