Computer scienceFundamentalsSQL and DatabasesBasics SQLData Modification Language

Inserting selected rows

New job

Report a typo

Copy the data about John Marley from the table sellers:

name surname seller_email
Tom Smith [email protected]
John Marley [email protected]

to the table managers:

name surname manager_email
Ann Tomas [email protected]

You should copy name VARCHAR(20), surname VARCHAR(20) and seller_email VARCHAR(40) to name VARCHAR(20), surname VARCHAR(20) and manager_email VARCHAR(50) respectively.

Write an SQL statement





___

Create a free account to access the full topic