sql insert query with subquery input and additional parameter

Question

insert into sycle(name,password) values(select name from name_table,'name');

i am having problem in inserting additional value with the parameter received from the select subquery.

it can be done in two query, but i want to kn ow if it can be done in a single query.

Answer 1

insert into sycle(name,password)
select name, password from name_table

or if password is a variable:

insert into sycle(name,password)
select name, @password from name_table

if password is 'name' then:

insert into sycle(name,password)
select name, 'name' from name_table

Answer 2

Try:

  INSERT INTO sycle(name,password) VALUES (SELECT name, 'name' FROM name_table);

although this will take only single name from name_table. If you want to get a whole bunch of values do:

  INSERT INTO sycle(name,password) SELECT name, 'name' FROM name_table;

Answer 3

This is what you're looking for:

INSERT INTO sycle
(
   name
   ,password
)
SELECT  name
        ,NULL -- password
FROM    name_table

Answer 4

give this a try

insert into sycle select name,'name' from name_table