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;
comment on a column from two tables in a mysql?
Moderator: General Moderators
- aceconcepts
- DevNet Resident
- Posts: 1424
- Joined: Mon Feb 06, 2006 11:26 am
- Location: London
Re: comment on a column from two tables in a mysql?
Code: Select all
SELECT * FROM table1, table2Re: comment on a column from two tables in a mysql?
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?
//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?
- aceconcepts
- DevNet Resident
- Posts: 1424
- Joined: Mon Feb 06, 2006 11:26 am
- Location: London
Re: comment on a column from two tables in a mysql?
Try,
Code: Select all
SELECT * FROM user_col_comments WHERE table_name = 'your_table_name'