is able to accommodate multiple data type in one column?

Posted by Jothi on Stack Overflow See other posts from Stack Overflow or by Jothi
Published on 2010-03-18T06:46:43Z Indexed on 2010/03/18 6:51 UTC
Read the original article Hit count: 223

Filed under:

mysqldb

hi,

i have one problem that, i have to change type of data in column based on foreign key stored in that row.

unit_id   unit_name
1          String
2          Float
3          Date
4          Int


Id      spec value   unit id
1         "A"         1
2         30.90       2
3         null        3
4         100         4

now i should achieve the above codition. how do i achieve it? please help me.

Related posts about mysqldb

Python MySQLdb placeholders syntax

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to use placeholders as seen in this example: cursor.execute (""" UPDATE animal SET name = %s WHERE name = %s """, ("snake", "turtle")) Except I'd like to have the query be its own variable as I need to insert a query into multiple databases, as in: query = """UPDATE animal… >>> More
warning in python with MySQLdb

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, when I use MySQLdb get this message: /var/lib/python-support/python2.6/MySQLdb/init.py:34: DeprecationWarning: the sets module is deprecated from sets import ImmutableSet I try filter the warning with import warnings warnings.filterwarnings("ignore", message="the sets module is deprecated… >>> More
python MySQLdb got invalid syntax when trying to INSERT INTO table

as seen on Stack Overflow - Search for 'Stack Overflow'
## COMMENT OUT below just for reference "" cursor.execute (""" CREATE TABLE yellowpages ( business_id BIGINT(20) NOT NULL AUTO_INCREMENT, categories_name VARCHAR(255), business_name VARCHAR(500) NOT NULL, business_address1 VARCHAR(500)… >>> More
Lost connection to MySQL server during query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a huge table and I need to process all rows in it. I'm always getting this Lost connection message and I'm not able to reconnect and restore the cursor to the last position it was. This is basically the code I have here: # import MySQLdb class DB: conn = None def connect(self): self… >>> More
Question about MySQLdb, OS X 10.5, and authentication

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm a noob at Python and have been having problems with MySQLdb and OS X Leopard 10.5. I have a php app that is doing db access just fine with pdo but also want to access with Python. When I use the same credentials with MySQLdb as php, I get the following error: File "build/bdist.macosx-10.5-i386/egg/MySQLdb/connections… >>> More

Developer IT

is able to accommodate multiple data type in one column? - Developer IT

is able to accommodate multiple data type in one column?

mysqldb

Related posts about mysqldb

Python MySQLdb placeholders syntax

warning in python with MySQLdb

python MySQLdb got invalid syntax when trying to INSERT INTO table

Lost connection to MySQL server during query

Question about MySQLdb, OS X 10.5, and authentication

Categories cloud