Answers for "how to select all fields in a table mysql command line"

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

mysql select all table that have field names

SELECT DISTINCT
	TABLE_NAME
FROM
	INFORMATION_SCHEMA.COLUMNS
WHERE
	COLUMN_NAME IN('column1', 'column2')
	AND TABLE_SCHEMA = 'schema_name';

Posted by: Guest on November-12-2020

Code answers related to "how to select all fields in a table mysql command line"