Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

select into

what would be the syntax to select from the same table and insert
the same id lets say id  377, but all storenumbers with the same id 377 within this one table.


select storenumbers from users1
insert into users1 (storenumbers , '377')
0
Seven price
Asked:
Seven price
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
this should do:

insert into users1 (storenumbers , id) 
select storenumbers , '377' 
from users1 

Open in new window

0
 
LowfatspreadCommented:
insert into users1 (id,storenumbers)
select distinct 377,storenumbers
from users1
0
 
Seven priceFull StackAuthor Commented:
tks
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now