Copying data from one table to another

[Mark Schonewille]

Danke für die Antwort, Trixi. I would like to provide my customer with 
syntax that can be executed repeatedly safely. If I use INSERT, multiple 
data may be added to the table, but if I use REPLACE INTO, the table 
would be updated if the records already exist and no duplicate records 
would be created.

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553

Installer Maker for LiveCode:
http://qery.us/468

Buy my new book "Programming LiveCode for the Real Beginner" 
http://qery.us/3fi

LiveCode on Facebook:
https://www.facebook.com/groups/runrev/

On 8/21/2015 16:04, Beatrix Willius wrote:
> Try INSERT instead of replace. RELACE is a string function.
>
> Mit freundlichen Grüßen/Regards
>
> Trixi Willius
>
> http://www.mothsoftware.com <http://www.mothsoftware.com/>
> Mail Archiver X: The email archiving solution for professionals
>
>
>
>> Am 21.08.2015 um 15:48 schrieb Mark Schonewille
>> <m.schonewille at economy-x-talk.com
>> <mailto:m.schonewille at economy-x-talk.com>>:
>>
>> Because I don't get anywhere modifying my table2, I have decided to
>> create a new table table3 and to copy the data from table2 to table3.
>> I have created the table and now I execute
>>
>> REPLACE INTO table3 (field1,key1,field2,field3)
>>  SELECT field1,key1,field2,field3 from table2;
>>
>> As you will probably expect, it doesn't work. I do this all the time
>> in MySQL. In Valentina, I get error 0x71000 (ERR_SQL_PARSER_ERROR).
>> What are possible reasons for this to happen?
>