in Undefined

Cara mencari nama kolom di semua tabel di mySQL

SELECT 
table_name
,
column_name
,
data_type
,
ordinal_position

FROM INFORMATION_SCHEMA.COLUMNS

WHERE table_schema = 'myDatabase' --- the database you want to search
AND column_name = 'name' ; --- or: column_name LIKE '%name%'

Write a Comment

Comment