Can't Connect From Script

sort of permissions might be wrong there. Any ideas? Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this th

Date Field + Time Field = Datetime Field?

ng? I'd really appreciate any hints you could give. FYI, I'm running MySQL 3.23.37. Thanks, Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Time Weirdness

I was using float...but even when I changed it to time, MySQL still gave me odd values on those rows. What type should I use? Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php (the manual

Time Weirdness

start & finish. Is this a bug in MySQL 3.23.37? Could it have something to do with my OS (OpenBSD 2.9)? Or am I doing something wrong with the statement "update time_worked set total = start - finish;"? Thanks, Alex Kirk --

Re: Time Difference Function

urs worked on a particular project, where I'm entering in start and end times; if there's a function like period_diff for time, that'd be perfect. Thanks in advance for your help. Alex Kirk - Before

Search & Replace

What is the best way to do a search & replace on a MySQL database? I just want to wipe a particular character from each field it occurs in; the REPLACE command, at least in the documentation on www.mysql.com, doesn't appear to be the best bet for doing this. Thanks,

Selecting unknown columns

them. How would I go about selecting out these fields? Even if I can only get those with one answer, I'd be immensley appreciative. Thanks, Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php

Re: users@localhost problems

how up with equivalent resutls. Hmmm...that seems OK to me...but then again, I can't really say much, since I don't really know. Any further tests I should run? Thanks, Alex Kirk - Before posting, please check:

users@localhost problems

w | root | +---++ 7 rows in set (0.00 sec) Also, if I try to connect to any databases as a non-root user, MySQL sees me solely as '@localhost' -- i.e., it doesn't see my UNIX user name. What's up with that? Thanks in advance. Alex Kirk -

Addendum: DBI Handle Has No Magic

about the wrong version when I first tried this). Is there any way I can just delete everything associated with DBI and start fresh? I really need to get Perl to interface with MySQL. Alex Kirk - Before posting, please check

DBI Handle Has No Magic

d DBI 1.15; ran 'make uninstall', and then installed DBI 1.20 * OpenBSD 2.9 Any ideas what I might to do correct this? Alex Kirk - Before posting, please check: http://www.mysql.com/manual.php (the

Selling MySQL to Government

). Since I'm sure this sort of thing has come up before, I'm wondering if you can point me to any good resources, particularly as they might relate to the US Gov't, banks, or direct mailing agencies. Thanks in advance for any help you can provide. Alex Kirk -