当从MySQL中选择所有内容时，我可以重命名特定的字段，而仍然使用*来选择其他所有内容

SELECT *, prof.id AS youth_id FROM time time, profiles prof

<?php
$tables = array (\'table1\',\'table2\',\'table3\');
$NameAliases = array(\'table1.id\'=>\'profid\');

foreach ($tables as $table)
{
    $sql = \"SHOW COLUMNS FROM $table;\";
    $result = mysql_query($sql);

    $columns = array();

    while ($row = mysql_fetch_array($result))
    {
        $search = array_search($table.\'.\'.$row[\"Field\"],$NameAliases);
        if ($search === true)
        {
            $parts = explode(\'.\',$NameAliases[$search]);
            $columns[] = \"$table.{$row[\"Field\"]} AS {$parts[1]}\"; //get the side of the dot
        }
        else
        {
            $columns[] = \"$table.{$row[\"Field\"]}\";
        }
    }
}
$columnstring = implode(\', \',$columns);
$sql = \"SELECT $columnstring FROM \".implode(\', \',$tables).\" WHERE 1=1\";
$result = mysql_query($sql);

while ($row = mysql_fetch_array($result))
{

}
?>

SELECT *, prof.id AS youth_id 
FROM time 
INNER JOIN profiles prof 
   ON time.profile_id = prof.id 
WHERE foo = \'bar\'

SELECT time.*, prof.id AS youth_id, prof.forename, prof.surname 
FROM time 
INNER JOIN profiles prof 
   ON time.profile_id = prof.id 
WHERE foo = \'bar\'