python - How can I get column types width MySQLdb? -

July 15, 2013

How do I get text descriptions for column types with MySQLdb?

I know that there is a number in cursor .description that shows the type of column and FIELD_TYPE in it. * such as FIELD_TYPE.ENUM = 247

For example, if I know this is '3', how do I get the column type name?

Read here for a list of column types:

< P> and then make a dictionary from the provided list:

field_type = {0: 'DECIMAL', 1: 'tiny', 2: 'short', 3: 'long' 4: 'float', 5: 'double', 6: 'null', 7: 'timestamp', 8: 'longlong' 9: 'INT24', 10: 'DATE', 11: 'TIME', 12: ' DATETIME ', 13:' Year ', 14:' Renewal ', 15:' VARCHAR ', 16:' BIT ', 246:' Nudecimal ', 247:' Interval ', 248:' SET ', 24 9:' TINIBOLB ', 250:' MDIUMOBOB ', 251:' Long BLOBB ', 252:' BLOB ', 253:' VAR_STRING ', 254:' STR Ng ', 255' Gimetry '}

Comments

Post a Comment

Popular Posts

IronPython in C#: No module named xmlrpclib -

I am trying to create a web application with an interactive console for IronPython. When I try to import xmlrpclib into the General console of IronPython, it works. However, if I use IronPython inside my C # code, then it does not put an exception "a module named xmlrpclib", is it a known issue? Any solution to solve this issue? Here is the code: var testcode = @ "import xmlrpclib; apiarver = xmlrpclib.ServerProxy ('address', allow_none = true); print APIServer.Hello () ; "; Mystream str = newest Mystream (); ScriptEngine Engine = Python. Cretegenine (); Engine. Retyme.io asset output (str, system text encoding. ASCII); Engine. Serial.io.setuperoutput (str, systemtext.edcoding.aspx); ScriptScope scope = engine.CreateScope (); ScriptSource src = engine.CreateScriptSourceFromString (testCode); Src.Execute (scope); Sorry for the silly question, it has come to know that there is a path used by IronPathon inside me. The C # code was not correct. I ...

qt creator - QtCreator importing makefile projects -

Have you ever tried importing Classic C ++ / project into Qt Creator? Say that I wanted to use some libraries in my GUI project, which must be created. how can I do this? In Qt Creator 2.0.1 you can import projects using only * * Cmake, * .creator, * .pro or * .qmlproject Then switch to cmake and you can import the project into Qt builder (Welcome tab -> Open project ...). Alex

php - cURL Cookie and 307 redirect issue -

I currently have a script that loads my client using curls on another server Currently, the settings curl_setopt ($ CH, CURLOPT_RETURNTRANSFER, 1); Curl_setopt ($ CH, CURLOPT_FOLLOWLOCATION, TRUE); Curl_setopt ($ ch, CURLOPT_AUTOREFERER, true); Curl_setopt ($ ch, CURLOPT_USERAGENT, $ UserAgent); Curl_setopt ($ CH, CURLOPT_HEADER, 0); $ Usecookie = ROOT_PATH "/public_html/football_parser/cookie.txt"; If ($ usecookie) {if (! Is_writable ($ usecookie)) {return "$ usecookie can not write cookie file, change the file's permission to 777 or read only for windows."; } Curl_setopt ($ ch, CURLOPT_COOKIEJAR, $ usecookie); Curl_setopt ($ ch, CURLOPT_COOKIEFILE, $ usecookie); } $ Output = curl_xac ($ ch); I'm trying to load two example URLs statto.com/football/teams/newcastle-united/2005-2006/results and statto.com/football/teams/newcastle-united/2008-2009/results Without a second load without any problems curl_setopt ($ ch, CURLOPT_FOLLOWLOCATION, TR...

Pat wiki

Search This Blog

python - How can I get column types width MySQLdb? -

Comments

Post a Comment