Answer My Searches

These are links associated with recent searches I’ve done. They’re not difficult enough to warrant to their own posts but still super useful.

Tags: Bookmarklet, Email, Extension, Firefox, Ftp, Gmail, Linux, Mediawiki, Search, Textarea, Ubuntu, Vmware, Wiki

It’s called IFNULL and it works like this:

IFNULL(expr1,expr2)

If expr1 is not NULL, IFNULL() returns expr1; otherwise it returns expr2. IFNULL() returns a numeric or string value, depending on the context in which it is used.

My search terms:

1. mysql null into blank
2. mysql null into blank function

I got to wondering if there was a maximum length for a Python variable name. I decided to take an empirical approach:

>>> for i in range(1,100000000):
...     varname='a'*i
...     exec('%s=1' % varname)
...     if i % 10000 == 0:
...             print i

It made it up to 50,000 before hitting a memory error. In the meantime my keyboard stopped working, and all of my windows stopped responding … I had to restart the whole computer!

So I guess the answer is your variable names can be as long as you have memory for. Does anyone have a different answer, or any critiques on my approach?

My search terms:

1. python max size for variable name

These are links associated with recent searches I’ve done. They’re not difficult enough to warrant to their own posts but still super useful.

Tags: Bookmarklet, Cover, Database, Javascript, Kayak, Logging, Moving, Sql, Work

These are links associated with recent searches I’ve done. They’re not difficult enough to warrant to their own posts but still super useful.

Tags: Crud, Free, Freesoftware, Generator, Gpl, Icon, Icons, Jhu, Mysql, Numbers, Openoffice, Opensource, Page, Php, Publicdomain, Python, Searchengine, Website, Work, Xml