Question

Write a function named "one_column" that doesn't take any parameters and returns a list. There is a database saved in a file named "sky.db" containing a table named "cluster" with columns "give", "newly", and "aide" each storing integer values. Return a list containing only the "newly" value of each record in the table.

Answer 1

CODE

import MySQLdb

def one_column():

conn = MySQLdb.connect("localhost", "root", "", "sky")

curs = conn.cursor()

print ("Opened database successfully");

#database_conn()

curs.execute("select newly from cluster;")

result = curs.fetchall()

conn.close();

return result