Duplicate all rows in sql database table

Question

I have a table which contains house details called property. I am creating a localised application, and I have a db table called propertylocalised. In this table is held duplicates of the data and culture column e.g.

key  culture propertyname

1     en       helloproperty

1     fr       bonjourproperty

At the moment I have all my en culture inserted but I want to duplicate all of those rows and then for every other row insert fr into culture.

I obviously only want to do this once, for the purpose of setting up the localisation.

Thanks

Andy

dkretz · Accepted Answer · 2010-04-21 06:56:23Z

8

INSERT INTO table 
SELECT 'fr', propertyname
FROM table

assuming you want to duplicate all the existing records which are all 'en'

answered Apr 21, 2010 at 6:56

dkretz

37.6k13 gold badges84 silver badges140 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

stacker · Accepted Answer · 2010-04-21 06:57:58Z

2

insert into propertylocalised select key,'fr'propertyname from propertylocalised  where culture = 'en'

answered Apr 21, 2010 at 6:57

stacker

69.1k29 gold badges143 silver badges214 bronze badges

3 Comments

dkretz Over a year ago

If 'id' is an autoincrement key, you don't want to insert it.

stacker Over a year ago

@le dorfier as listed in the OP the key is for both languages the same (1). Therefore I would rather expect the same key.

weaveoftheride Over a year ago

there are duplicate keys which relate to the property. Cheers everyone will try this later. Andy

Collectives™ on Stack Overflow

Duplicate all rows in sql database table

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related