How can you create Table B in SQL (MySQL) using the records in Table A as its field names

Question

I have gone through all the various suggestions but none seems to matches the requirement. This is NOT a Pivot Table. The first table (Course_table) has a list of course, about 1,200. I want to create a second table (marksheet_table) which has as its columns the rows of the first table. How can you create the marksheet_table in PHP and SQL (MySQL) using the records in the first Table as its field names e.g.

Course_table    
 |  Subject |   unit    |   staff   |
--------------------------------------------------
 |  Math    |   3       |   Mr James    |   
 |  Econs   |   1       |   Dr Smith    |   
 |  Chem    |   2       |   Mrs Aisha   |       



Marksheet_table    
StudentID | Math    |   Econs   |   Chem    |
--------------------------------------------------
10001     | 10      |     20    |     30    |
10045     | 11      |     09    |     45    |


<?php
include 'config.php'; 
        mysql_select_db("DB_Subject", $conn);
        $Select_sql = mysql_query(" SELECT DISTINCT subject FROM Course_table");   
        while($row= mysql_fetch_array($Select_sql)) 
        { $CourseCode   = $row["CourseCode"] ;
            $Create_sql = mysql_query(" CREATE TABLE Marksheet_table (  
                                    id INT(5) UNSIGNED ATO_INCREMENT PRIMARY KEY,
                                    regno INT(8) NOT NULL,
                                    $subject DECIMAL(4,2),
                                    ");     
                }
          mysql_fetch_array($Create_sql) ;
    mysql_close($conn); 

?>