Hello all, is it possible to select only a certain
number of characters from a field when running a query
in MySQL? For example I would like to select the
password and then the first 6 characters of the
username in the username field (which is of type
varchar). Thanks in advance!
---
Hello all, I am trying to write a delete statement in
which a record is deleted if the time a user logged in
is more than 15 minutes. As a result I would need to
compare login times to the current time. Is there a way
in MySQL to do this? Can the current time be calculated
by SQL?
thanks,
S
I saw the information for upgrading MySQL 3.23 to 4.03
regarding altering table types, etc. If I am using the
Windows release can I just install the binaries etc.
over the existing installation? Will the new install
wipe out the data directory?
Thanks in advance!