--查询数据并赋值

WITH brandid AS (
SELECT
id
FROM brand
WHERE code='bb'
)

--SELECT * FROM brandid;

--插入数据
insert into game(brand,game_code,attributes,category,supported_platform,create_at,update_at)
SELECT id,'gamecode',0,'gamecatetory','platform',
'2023-07-24 12:24:51.477876','2023-07-24 12:24:51.477876'  FROM brandid;

--按赋值的条件查询数据

select * from game where brand=(select id from brandid);