Sep 242013
 

I was having trouble getting Virtualbox to run on my Fedora 19. My system isn’t using PAE so I had to modify my /etc/profile.d/kern_dir.sh file to export the correct path.

#kern_dir.sh
KERN_DIR=/usr/src/kernels/`uname -r|sed 's/.PAE//g'`

export KERN_DIR
I installed the latest kernel development files:
yum -y install binutils gcc make patch libgomp glibc-headers glibc-devel kernel-headers kernel-devel dkms

PAE Kernel use this:
yum -y  install binutils gcc make patch libgomp glibc-headers glibc-devel kernel-headers kernel-PAE-devel dkms
Then I updated the OS:
yum -y update

Then I rebooted
Jun 142013
 
create table test (
id int not null auto_increment primary key,
name varchar(50),
age tinyint
) engine = myisam;

insert into test (name) values ('jim'),('john'),('paul'),('mike');

-- The age field is now NULL.
select * from test;

update test
set age =
case
when name = 'jim' then 10
when name = 'paul' then 20
else 30
end;

-- The age field now has data.
select * from test;