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.
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
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;
This is what you're looking for:
INSERT INTO sycle
(
name
,password
)
SELECT name
,NULL -- password
FROM name_table
-- password altogether.give this a try
insert into sycle select name,'name' from name_table
