Are you an Oracle-related blogger? Are you attending Oracle OpenWorld this year? If you answered yes to both questions, then you are invited to attend the yearly blogger meetup at the ThirstyBear Restaurant and Brewery, Sunday September 21 at 7:00 PM.
Mark Rittman has been the person organizing the blogger meetup events for the past few […]
Monthly Archives: December 2008
Blogger Meetup - Oracle OpenWorld 2008
Comments (1)
MySQL Pop Quiz #26
I’m still looking for new entries. I get quite a few suggestions, but not all of them make it into quiz questions. Do send in your suggestions!
Today’s quiz question, which subsequently became three, comes courtesy of Janek Bogucki.
Since questions 2 and 3 contain hints on the other questions, they are embedded within the answers to […]
Homeblock
Free plan features
Data Storage :1000MB Disk Space
Data Transfer : 5GB (They advertise it as 7gb on the main page, but the value in the control panel is 5000MB)
Database :
3 Mysql Databases
Mysql Version: 5.0.27Domain Hosting : Yes (+ a subdomain) (more…)
beware of table alias in LEFT JOIN
when mixing standard selects containing table aliases with LEFT JOIN’s you need be aware of a critical change as of mysql 5… if you reference a table alias in an ON clause the same way you might have in verison 4, mysql may report an ‘unknown column’ error.
so, a query of the form:
SELECT a.id FROM […]
Problem with using AND, OR for single column values
I have a MySql database table as shown in image . Where table has thousands of records with any integer and varchar values in id1 and id2.
I want to select values where id1=(1 and (2 or 3)). Which will result in id2=a,b,c.
Result may be several hundred records for real table and I will be using […]
Geek-Speak Observations
By this time tomorrow, I’ll be winging my way to the Bay Area for OpenWorld.
One of the first things I need to do tomorrow is race to the Unconference onsite signups in Moscone West and move my Essential Geek-Speak session to a better time, like say one that doesn’t overlap with Larry’s keynote.
You may recall […]
Rules of Thumb Database
Rules of Thumb.Org. ‘A rule of thumb is a homemade recipe for making a guess. It is an easy-to-remember guide that falls somewhere between a mathematical formula and a shot in the dark. A farmer, for instance, knows to plant his corn when oak leaves are the size of squirrels’ ears. An economics professor knows […]
Simple Tips to Quickly Find Answers to Your Oracle-Related Questions and Keep Your Oracle Skills Up to Date
I am one of the lucky 25 winners of the first ever Oracle OpenWorld Suggest a Session on Mix. I would like to thank everyone who voted for my session which is now live on the Schedule Builder. Here are the details:
Session ID: S3301711
Title: Simple Tips to Quickly Find Answers to Your Oracle-Related Questions and […]
Magento Installation Guide for Dreamhost
I’ve been watching the Magento e-commerce project for about the last month and a half - since Ben sent me a link to it. It’s an open-source e-commerce package, that primarily aims to pickup and improve where OSCommerce, Joomla + VirtueMart, and ZenCart have left off - streamlining a CMS (Content Management Sytem) and E-commerce […]
Working with PHP 5 in Mac OS X 10.5 (Leopard)
Mac OS X is a great development platform for working with PHP. Leopard comes with Apache, PHP and many other development tools, such as subversion already installed. Leopard brings a much needed upgrade from Tiger’s tired PHP 4 to a very modern version of PHP 5.2.4. This is a guide for setting […]