The TIMESTAMP data type is the only way to have MySQL automatically set the time when a row was inserted and/or updated. DATETIME columns can’t do this. TIMESTAMP columns are identical to DATETIME columns with one important exception — they can be set to take the current time value when a row is created or [...]

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

There are 5 different integer columns, each hold integer values of different sizes. Moreover, each can be signed or unsigned. If your value can’t ever be negative (for example, for an index), then you should probably make your values unsigned. DROP TABLE `foo`.`example_03`; CREATE TABLE IF NOT EXISTS `foo`.`example_03` ( f_01 TINYINT, — from -128 [...]

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

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 [...]

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` DATETIME ); Notice that the ‘back tic’s on each column definition (the little ` characters) are optional in most cases. I use them for reasons I’ll discuss later on. Also, for most [...]

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 [...]

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 [...]

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