title: How to print ALL columns of MySQL table in Python?
body: <p>Here I want to print every column present in the MySQL table <strong>(PASSENGER)</strong>, but this code only gives 4-5 columns.</p>
  <p>The code:</p>
  <pre><code>import pandas as pd
  import mysql.connector as myq
  d = myq.connect(host=&quot;localhost&quot;, user=&quot;root&quot;, passwd=&quot;admin&quot;, database=&quot;air&quot;)
  df = pd.read_sql(&quot;select * from Passengers&quot;, d)
  print(df)
  </code></pre>
  <p>Output:</p>
  <pre><code>      Ticket_Number       Date   Passenger  ...        Class       Stat Announcement
  0              1          1              1  ...            1          1            1
  1         184784          1              1  ...            1          1            1
  2         184785          1              1  ...            1          1         None
  3         184787  9:12:2020     Jeet        ...  FIRST CLASS  CONFIRMED         None
  4         184789  9:12:2020     Jeet        ...  FIRST CLASS  CONFIRMED         None
  5         184790  9:12:2021     Jeet        ...  FIRST CLASS  CONFIRMED         None
  </code></pre>
  <p>This is what Python is returning to my code. Here I want all 12 columns.</p>
  <p>Desired output:</p>
  <pre><code>Ticket_Number   Date    Passenger      Flight_Code         Airline      Departs_From         Arrives_TO    Departs    Arrives      Class          Stat    Announcement 
          1        1          1               1                1                1                   1          1          1           1            1              1      
     184784        1          1               1                1                1                   1          1          1           1            1              1            
     184785        1          1               1                1                1                   1          1          1           1            1           none         
     184787  9:12:2020     Jeet           CX131    Cathay Pacific       London,UK     Ahemdabad,India   04:40:00   18:20:00  FIRST CLASS   CONFIRMED           none         
     184789  9:12:2020     Jeet           CX131    Cathay Pacific       London,UK     Ahemdabad,India   04:40:00   18:20:00  FIRST CLASS   CONFIRMED           none         
     184790  9:12:2021     Jeet           QF248    Quantas              London,UK     Ahemdabad,India   23:50:00   13:50:00  FIRST CLASS   CONFIRMED           none    
  </code></pre>