I have mysql on linux on two machines. Both version 4.0.16. On one
machine, it is reported as 4.0.16-standard and on the other machine it is
reported as 4.0.16-log (according to PHPMyAdmin). What is the difference
(obviously something with logging) and how can I change from standard to log
and v
Does anyone know of a good step-by-step document demonstrating moving the
data files of a 3.23.5x installation (5 databases, each with several tables)
to a new partition on the same Linux box. I want to do this before
upgrading to MySQL 4. I think I understand how to do it from reading the
docs,
I use the following function in Oracle
SELECT decode(status,'A','Active','L','Active','Former') FROM Table
What it means is: if table column status = A, return "Active", if status=L, return
"Active", else return "Former" in the select statement.
Decode in mysql has nothing to do with this functio