This example shows how to set default values for each column — as well as how to allow (or not allow) NULL values in the column. By default, any column can contain NULL values.
(Note that we’re also using “CREATE TABLE IF NOT EXISTS” so an error doesn’t get thrown if the table already exists when [...]

If you enjoy our post, feel free to subscribes to our rss feeds

Here’s a basic example of a MySQL CREATE TABLE command.

CREATE TABLE `foo`.`example_01` (
`field_1` VARCHAR(255),
`field_2` CHAR(10),
`field_3` INT(10),
`field_4` BIGINT(20),
`field_5` [...]

If you enjoy our post, feel free to subscribes to our rss feeds

Save to delicious.
Sometimes when using Active Record you may want to create a database connection to a database other than the default database specified in your database.yml file.
When this happens, the easiest way to do it is to use the Class-level convenience method on ActiveRecord::Base. Like this:
Imagine your database.yml entry looks like this:
development_foo:
adapter: [...]

If you enjoy our post, feel free to subscribes to our rss feeds

I recently ran across an Information Week article called The Future of Programming that forecasts a drop in the demand for programmers along with a drop in their stature withing companies. They described off-shoring and the fall-off of the Internet Boom as reasons for the decline.
I’ve been programming for a long time. Most recently I [...]

If you enjoy our post, feel free to subscribes to our rss feeds

(Save this to Del.icio.us!)
What is a cursor and when should you use one?
A ‘cursor’ in MySQL is essentially just the result set that’s returned from a query. Using a cursor allows you to iterate, or step through, the results of a query and perform certain operations on each row that’s returned.
Think of them like holders [...]

If you enjoy our post, feel free to subscribes to our rss feeds

I recently got some grief for using a mac — because it was a bit more expensive than using a PC.
Personally, given the software that comes included on it, I think that it’s probably not much — if any — more expensive at all.
But none-the-less, I wrote out some of the reasons I like it [...]

If you enjoy our post, feel free to subscribes to our rss feeds

Yes, it was me.
I created the redswingline stapler twitter bot almost two years ago as a way of experimenting with Twitter and its API. I had been watching the movie Office Space a lot and thought it would be fun to create a twitter avatar of the red swingline stapler that was on Milton’s desk.
Anyway, [...]

If you enjoy our post, feel free to subscribes to our rss feeds

Well – I’m relaunching kbedell.com. Again. Again again.
This site has been my personal site since about 1995 and it’s looked a bunch of different ways. I’ve been on a variety of different Wordpress versions (and moveable type, radio — and even plain HTML).
I’ve been doing a whole bunch of interesting things with ruby/rails, mysql, twitter, [...]

If you enjoy our post, feel free to subscribes to our rss feeds