mysql select where to all columns code example
Example 1: mysql all columns
-- MySQL
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS;
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