rearrange columns in mysql

Suppose I have a table with:

id int(11) auto_increment,
date datetime,
created_at datetime

and want’s to have this arrangement:

id int(11) auto_increment,
created_at datetim,
date datetime

This will be the command to do just that.

ALTER table test.date MODIFY COLUMN created_at date AFTER id

am i a programmer?

Here’s a cool test of what you possibly can be:

 http://www.eggheadcafe.com/articles/mb/default.asp

This is my   test result:

E=3 Extraversion
I=8 Introversion
S=8 Sensing
N=12 iNtuition
T=16 Thinking
F=3 Feeling
J=13 Judging
P=6 Perceiving
You are an INTJ

INTJ - Scientists, engineers, professors, teachers, medical doctors, dentists, corporate strategists, organization founders, business administrators, managers, military, lawyers, judges, computer programmers, system analysts, computer specialists, psychologists, photographers, research department managers, researchers, university instructors, chess players. They have a particular skill at grasping difficult, complex concepts and building strategies.

136 post and goin past it

There have been many readings in for my blog especially the one’s concerning phpMyAdmin, xampp  and virtualization. I have had hit 136 reads yesterday and very much thankful for the support(or accidental click on the results of google/wordpress search :) ).

Thank you very much and I will still continue taking notes and have it presented in the easily comprehensible format that everyone of us loves.

Keep reading :)

installing yum in bayanihan linux server 2006

I recently installed bayanihan linux server on a virtual machine since I don’t have a spare box last time. But last week I have got a box (headless) to mingle with.

Then deployed BLS 2006 as a file, local mail, local web host to use with the current servers that we have here at work. The good thing about centos (since I have recently played with it and installed xfce4-will post about this one) is that you can easily update the whole system by using “yum update” but sadly BLS 2006 wont allow you to do just that…

Next step would be to ask for help(Note: never cross post in community boards to have your question answered quickly once is enough).

Not getting the answer I have to create it :)

Bayanihan Server 2006 is based on CEntOS 4 (mind you that’s the correct cap/lowercaps of the OS). CEntOS is based on RHEL4 .

I have to install yum first. What I have is only rpm to manage the installations so I have to install a yum*.rpm package. Found one at:

http://centos.cs.ucr.edu/centos/4/os/i386/CentOS/RPMS/

But. Before that I have installed the GPG keys for the packages.

http://mirror.centos.org/centos/RPM-GPG-KEY-CentOS-4

Installation. Installing yum-2.4.3-1.c4.noarch.rpm would just ask for more dependencies. It will ask for the following:

libxml2-python is needed by yum-2.4.3-1.c4.noarch
python-elementtree is needed by yum-2.4.3-1.c4.noarch
python-sqlite is needed by yum-2.4.3-1.c4.noarch
urlgrabber is needed by yum-2.4.3-1.c4.noarch
yumconf is needed by yum-2.4.3-1.c4.noarch

to be installed which is of course can be found in the above mentioned repository. It is constantly updated so mentioning the version number is probably not worth it.. but I will. :)

-rw-r–r– 1 root root 3656 Dec 19 01:17 centos-yumconf-4-4.5.noarch.rpm
-rw-r–r– 1 root root 449577 Dec 19 00:57 libxml2-python-2.6.16-6.i386.rpm
-rw-r–r– 1 root root 78639 Dec 19 00:52 python-elementtree-1.2.6-4.2.1.i386.rpm
-rw-r–r– 1 root root 38368 Dec 19 00:52 python-sqlite-1.1.7-1.2.i386.rpm
-rw-r–r– 1 root root 120787 Dec 19 00:51 python-urlgrabber-2.9.8-2.noarch.rpm
-rw-r–r– 1 root root 194136 Dec 19 00:54 sqlite-3.3.3-1.2.i386.rpm
-rw-r–r– 1 root root 393768 Dec 19 00:54 yum-2.4.3-1.c4.noarch.rpm

Another but. yumconf is not on the repository so i have to manually check the net for the yumconf*.rpm which brought me here.

Completed. I have downloaded all of the needed dependency on one directory so I have to issue one command left for the magic to begin.

rpm -Uvh *rpm

which as you know will install all the rpm’s in the folder :)

Snapshot.

apple lisa the old s-cool desktop

Here’s a cool clip of Apple Lisa with a long introduction. Old school desktop computing at it’s best.

http://www.youtube.com/watch?v=a4BlmsN4q2I