INSERT INTO from same table

[johnaregan]

Hello
I want to insert rows selected from the same table using the INSERT INTO... SELECT... statement. The only difference is one column containing the user name, so I need to replace the user name with a new one that i specify. Can this be done without creating a temporary table?

Thanks in advance for any suggestions
John

 

[stessie]

Do you just want to update the username?
If so why not just use if they are all going to have the same username
UPDATE tablename SET USERNAME = 'xxx'

 

[Cagliostro]

insert into tableX(columnX, columnXX)
select X, XX from TableY John Fill

ivfmd@mail.md

 

[johnaregan]

What i want to do is to do the SQL equivelent of copyig a set of rows, reinserting them into the same table from which they came but changing the username to another.
the table format is something like:
Table name USERS
username col1
Bob AX
Bob BX
Bob CX

i want to be able to get this from 1 SQL statement
username col1
Bob AX
Bob BX
Bob CX
Bill AX
Bill BX
Bill CX

 

[tlbroadbent]

You can insert into the same table.

Insert Users (UserName, col1)
Select "Bill", col1
From Users
Where UserName='bob' Terry

;-) USER, n.: The word computer professionals use when they mean "idiot." -Dave Barry

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm