insert into

how can I appedn the data to table

INSERT INTO `delete12` (`name`, `username`, `password`, `firstname`) VALUES ('vamsi', 'krishna123', '12546', 'narayana');

how can I insert data of one table to anohter table

INSERT INTO table2

SELECT * FROM table1

WHERE condition;

INSERT INTO table2 (column1, column2, column3, ...)

SELECT column1, column2, column3, ...

FROM table1

WHERE condition;

INSERT INTO Customers (CustomerName, City, Country)

SELECT SupplierName, City, Country FROM Suppliers;

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)

SELECT SupplierName, ContactName, Address, City, PostalCode, Country FROM Suppliers;

INSERT INTO Customers (CustomerName, City, Country)

SELECT SupplierName, City, Country FROM Suppliers

WHERE Country='Germany';