Usefull script for querring all columns from table
SELECT GROUP_CONCAT(COLUMN_NAME) as columns
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'customer'
SELECT GROUP_CONCAT(COLUMN_NAME) as columns
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'customer'
No comments:
Post a Comment