I'm using vtiger CRM, I used this query to find which tables contain column accountid or account_id so that I can understand the relationship among them.
SELECT * FROM information_schema.columns
WHERE column_name LIKE 'account_id'
OR column_name LIKE 'accountid'
Saturday, January 9, 2010
Find tables contain 'accountid' or 'account_id'
at 12:56 AM
Labels: MySQL, MySQL Query
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment