Answers for "mysql select all columns"

mysql all columns

-- MySQL
SELECT * 
FROM INFORMATION_SCHEMA.COLUMNS;

Posted by: Guest on May-15-2020

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

Posted by: Guest on May-20-2020

Code answers related to "mysql select all columns"