Upgrade from 3.23 to 4.03
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! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Time caculations
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, Sunil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Formatting data in a query
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! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
