Search results

  1. N

    How to Copy a Row from Table to Table

    So I played with this based on theDBguy's feedback on reserved words. It now works if I use[] for all fields (not sure of the logic there, but .....): INSERT INTO notes ([name], [note], [data_size]) SELECT 'newname' AS [name], [note], [data_size] FROM templates WHERE id = 99 Thanks for all...
  2. N

    How to Copy a Row from Table to Table

    newname is the new value of the NAME field that I use for the new row.
  3. N

    How to Copy a Row from Table to Table

    It fails even if I use [name]. The error is "Syntax error in INSERT INTO statement" (very informative isn't it)
  4. N

    How to Copy a Row from Table to Table

    I have 2 simple tables with 3 columns and an autonumber primary key/ID column. One table is a TEMPLATE table from which I copy data into another NOTE table to create a new record. During this copy, I rename the template name field to create the new entry name. In MySql, this was very simple SQL...
Back
Top Bottom