MYSQL to UPPER CASE and LOWER CASE

By , September 28, 2011 3:09 PM

How to convert MYSQL Columns to Upper Case and Lower Case

SELECT LOWER(name) FROM mytable
SELECT UPPER(name) FROM mytable

UPDATE mytable SET name = LOWER(name);
UPDATE mytable SET name = UPPER(name);

Trixbox VMware

By , September 18, 2011 5:23 PM

you must configure you new VM-ware session as other linux 2,6 kernal whith one SCSI drive off 8Gb and the network bridged.

Might need
The summary is this. You need to add the following options to your linux boot command:

acpi=off noapic nosmp nolapic clock=pit

i.e. edit /boot/grub/grub.conf and make the line beginning with “kernel” look like this:

kernel /vmlinuz-2.6.9-34.0.2.EL ro root=LABEL=/ acpi=off noapic nosmp nolapic clock=pit

(Don’t cut and paste the whole line – you might be running a different rev of the kernel.)

Char and VARCHAR

By , September 5, 2011 8:34 PM

Where the data varies significantly in length from one record to the next with the longest being significantly longer than the average then you need to use a VARCHAR. There is no point in using a CHAR(40) if the average length is only 15 since that will resuult in a lot of wasted space in most records. Using a VARCHAR(40) instead means that you can still fit the leng 40 chharacter values while the average space used will be 15 plus the record length marker overhead.

summary use varchar for variable length fields and use char if you are expecting it to always be the same eg CHAR (ASSS, DASS, FASS, TASS) this is good for a char ie fixed length fields

Thomas Challenger Thomas Challenger