Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
#!C:\Python26\python.exe print "Content-Type: text/html" print import MySQLdb import cgi, cgitb cgitb.enable() DB_HOST = 'localhost' DB_USER = 'root' DB_PASSWORD = 'rootpass' DB_DATABASE = 'ccs' DB_PORT = 3307 db = MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE, DB_PORT) artist = unicode("artist").encode('utf-8') album = unicode("album").encode('utf-8') c=db.cursor() c.execute("CREATE TABLE musicfiles ( artist TEXT NOT NULL, album TEXT, albumid INT(25) NOT NULL ) CHARSET 'utf8' COLLATE 'utf8_general_ci'") query = 'SELECT albumid FROM musicfiles WHERE (artist, album) = (\'' + artist + '\',\'' + album + '\')' print query c.execute(query)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|I have many tables and one main one, how can I take there column names from the main one?||3||52|
|Difference between List and Array in Python||5||114|
|Using PhpMyAdmin (or Mysql) for a find and replace operation||11||40|
|BIG DATA Question: Path to migrate current "Document Management" system||13||39|