Hackvertor

You are not logged in. You can still view everyone's public tags but you need to register to create tags and save urls.

No comments found.

Code
By	garethheyes (Root)
Tag Name	find_table_from_col
Param1	column
Param2	false
Param3
Help	Finds the table name from the column name, 1st param is the column name. 2nd param performs a like query true\|false

(function(){ if(params[1] == 'false') { return "SELECT table_name FROM information_schema.columns WHERE column_name = '"+params[0]+"'"; } else { return "SELECT table_name FROM information_schema.columns WHERE column_name LIKE '%"+params[0]+"%'"; } })();

No revisions found.

Code

Created

Source