Practice Yourself - MySQL INSERT SELECT

Code Editor sql

-- Select all columns
SELECT * FROM customers;

-- Select specific columns
SELECT first_name, last_name, email
FROM customers;

-- Select with alias
SELECT first_name AS name,
       CONCAT(city, ', ', country) AS location
FROM customers;

Result

Click "Run" to execute the code...