Kuris INSERT INTO sakinys įterpia duomenis iš vienos lentelės į kitą?

Question

Kuris  INSERT INTO  sakinys įterpia duomenis iš vienos lentelės į kitą?

Accepted Answer

INSERT INTO Employees_Backup (first_name, last_name, salary) SELECT first_name, last_name, salary FROM Employees;

Answer

INSERT Employees_Backup INTO (first_name, last_name, salary) SELECT FROM Employees (first_name, last_name, salary);

Answer

ADD INTO Employees_Backup (first_name, last_name, salary) SELECT first_name, last_name, salary FROM Employees;

Answer

INSERT INTO Employees_Backup VALUES (first_name, last_name, salary) FROM Employees;

Crowdly