Mysql insert select

Databases
1

Generally mysql does

INSERT INTO user (id, name, email, passwd, site) SELECT idm, user_name, email, pass, site_url FROM members WHERE id>100 AND id<200

But I want a query where site column of user table will insert a static string fixed my me, not from members table

something like
(just for easy to understand)

INSERT INTO user (id, name, email, passwd) SELECT idm, user_name, email, pass FROM members WHERE id>100 AND id<200, SET site='my fixed site url'
2 

insert into user (id, name, email, passwd,site) 
select idm, user_name, email, pass, 'my fixed site url'
  from members 
 where id > 100
   and id < 200
3

It’s easier than you think :slight_smile:


INSERT INTO user (id, name, email, passwd, site) 
SELECT 
    idm
  , user_name
  , email
  , pass
  , 'my fixed site url'
FROM members 
WHERE id>100 
AND id<200

Swampboogie was quicker… :smiley: