In [1]:

    

import MySQLdb


db = MySQLdb.connect(
    "db.fastcamp.us",
    "root",
    "dkstncks",
    "world",
    charset='utf8',
)

cursor = db.cursor()


    

In [2]:

    

import pandas as pd


    

In [3]:

    

# SQL Perspective - COUNT

SQL_QUERY = """
    SELECT COUNT(*)
    FROM Country
    ;
"""

pd.read_sql(SQL_QUERY, db)


    

    
Out[3]:






  

    

      

      
COUNT(*)
    
  
  

    

      
0
      
239
    
  

In [4]:

    

# Pandas Perspective - len OR

SQL_QUERY = """
    SELECT *
    FROM Country
    ;
"""

df = pd.read_sql(SQL_QUERY, db)


    

In [5]:

    

len(df)


    

    
Out[5]:





239