Page 1 of 1
comment on a column from two tables in a mysql?
Posted: Wed Aug 12, 2009 9:21 pm
by sobha
How to select comment on a column from two tables in a mysql?
I tried this.But it shows error.What is the syntax to be used?
SHOW FULL COLUMNS FROM table1 , table2;
Re: comment on a column from two tables in a mysql?
Posted: Wed Aug 12, 2009 10:24 pm
by aceconcepts
Re: comment on a column from two tables in a mysql?
Posted: Wed Aug 12, 2009 10:35 pm
by sobha
i mean retreiving the comment field from 2 tables
//in case of single table
$sql1 = mysql_query("SHOW FULL COLUMNS FROM members",$link);
while($r1=mysql_fetch_assoc($sql1))
{
$result2=$r1['Comment'];
}
How to write the querry in case of 2 tables?
Re: comment on a column from two tables in a mysql?
Posted: Wed Aug 12, 2009 11:06 pm
by aceconcepts
Try,
Code: Select all
SELECT * FROM user_col_comments WHERE table_name = 'your_table_name'