Use select query inside the Insert query for the same table name

Question

Hi Friends, Is it possible to use a "select" query inside the "Insert" query, But the condition is i want to use the same table name for both "select" and "Insert" query.
For Example
mysql> insert into sample_elements (name,position,ownerel) values ('Namespace1', select id from sample_elements where name='Namespace1',0);

Please guide me on this.

Answer 1

Change your insert to look like the following :

insert into sample_elements (name,position,ownerel) select 'Namespace1',id,0 from sample_elements where name='Namespace1';

Basically instead of using values only use the select statement and insert the harcoded values as columns

Answer 2

insert into sample_elements
     ( name, position, ownerel )
select 'Namespace1',
       sel.id,
       0
  from sample_elements sel
 where sel.name = "Namespace1";

Answer 3

I think you can do it. You can use:

INSERT INTO table (..fields) SELECT ..fields.. FROM table;

Answer 4

I don't know mysql but can you try the following ?

insert into sample_elements select name, id, 0 from sample_elements where name='Namespace1'

Answer 5

Am not sure , i thing this insert inside select for finding already exist or for what perpose ,

Thanks