Hi lingers,
Replace with below query.
INSERT INTO Customers (CustomerName,CustomerEmail,CustomerCity,Dater,Datea,quantity,regno,Age,Height)
SELECT (CustomerName +' '+ 'copy'),CustomerEmail,CustomerCity,Dater,Datea,quantity,regno,Age,Height
FROM Customers WHERE id ='1'
Check this example.
Database
I have made use of the following table Customers with the schema as follows.
I have already inserted few records in the table.
You can download the database table SQL by clicking the download link below.
Download SQL file
SQL
INSERT INTO Customers (Name,Country)
SELECT Name +' '+ 'copy',Country
FROM Customers WHERE CustomerId ='1'
SELECT * FROM Customers
Output
| CustomerId |
Name |
Country |
| 1 |
John Hammond |
United States |
| 2 |
Mudassar Khan |
India |
| 3 |
Suzanne Mathews |
France |
| 4 |
Robert Schidner |
Russia |
| 5 |
John Hammond copy |
United States |
