sql make a field with multiple values code example

Example 1: add two column values of a datframe into one

df["period"] = df["Year"] + df["quarter"]

Example 2: mysql select all columns and specific fields as

SELECT mytable.*, column20 AS Customer, column11 FROM mytable
-- OR
SELECT column11, column20 AS Customer, mytable.* FROM mytable