FilesExpand file tree

 master

/

RemSQL.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

24 lines (22 loc) · 770 Bytes

 master

/

RemSQL.py

Copy path

Top

File metadata and controls

• Code
• Blame

24 lines (22 loc) · 770 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

#!/usr/bin/python

import MySQLdb

import prettytable

from prettytable import from_db_cursor

# Get database information and assign to variables for easier use

host = raw_input('Enter host name ')

user = raw_input('Enter username ')

passwd = raw_input('Enter password ')

database = raw_input('Enter DB name ')

db = MySQLdb.connect(host, # your host, usually localhost

user, # your username

passwd, # your password

database) # name of the data base)

# Create a Cursor object

cur = db.cursor()

col = raw_input('Enter Column Name')

table = raw_input('Enter Table name')

#columns = map(col, col.split())

cur.execute("SELECT "+col+" FROM "+database+ "."+table+"")

pt = from_db_cursor(cur)

print pt

cur.close()