Require pair of fields to be unique?

2003-07-22 Thread Greg Macek
r_id and job_id paired up paired together more than once. Maybe I'm missing a better way to setup this table. If I am, please let me know. Thanks. -- Greg Macek | Senior IT Manager Marketing Resources, Inc. [EMAIL PROTECTED] | http://www.mrichi.com -- MySQL General Mailing List For

Re: upgrade from mysql 3.23 to 4.1

2004-11-29 Thread Greg Macek
On Wed, 2004-11-24 at 09:15 -0600, Jeff Smelser wrote: > On Wednesday 24 November 2004 07:32 am, Hristo Chernev wrote: > > How to upgrade from 3.23.58 to 4.1.7? Which is the easiest way with minimal > > risk and downtime? > > Yeah right.. ;) > > > Background: Heavy loaded mysql server, only one

Re: upgrade from mysql 3.23 to 4.1

2004-11-29 Thread Greg Macek
On Mon, 2004-11-29 at 13:11 -0600, Paul DuBois wrote: > At 12:57 -0600 11/29/04, Jeff Smelser wrote: > >On Monday 29 November 2004 09:01 am, Greg Macek wrote: > > > >> I am actually in the process of planning a similar upgrade for our > >> database server. None o

Re: upgrade from mysql 3.23 to 4.1

2004-11-30 Thread Greg Macek
On Tue, 2004-11-30 at 11:50 -0600, Jeff Smelser wrote: > On Monday 29 November 2004 11:35 pm, Greg Macek wrote: > > I was thinking about this as well, but was hoping to minimize the amount > > of work I would have to do. However, if this makes the most sense for > > upgrading,

Converting table types

2004-06-09 Thread Greg Macek
ocation changes with this. -- Greg Macek | Senior IT Manager Marketing Resources, Inc. Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

INSERT INTO ... SELECT question

2002-11-14 Thread Greg Macek
Hello, I recently stumbled upon the INSERT INTO..SELECT abilities. Basically what I'm doing is archiving records into another table before deleting them (inventory information). However, I'd like to have the archive table to have one more field than the original table: a date_archived function. So

Re: INSERT INTO ... SELECT question

2002-11-14 Thread Greg Macek
Well, amazingly enough, it works great! I found a test box to try it on first before implementing this on the production box. This will definitely make life easier... On Thu, 2002-11-14 at 10:14, gerald_clark wrote: > Did you try it? > Did it work? > > Greg Macek wrote: > >

Re: INSERT INTO ... SELECT question

2002-11-14 Thread Greg Macek
ally. > > Thanks, > > Matt > > Matthew P Baranowski > Data Manager, Office of Educational Assessment > University of Washington > > - Original Message - > From: Greg Macek <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, N

Disappearing records?

2002-11-18 Thread Greg Macek
Hello, I have a problem that I could use some help with. We're running a mysql/php intranet site for time sheets (home grown solution). However from time to time a user will tell me hours from the previous week are just "gone". I go to look and sure enough, no hours have been entered. I have not b

Re: Disappearing records?

2002-11-18 Thread Greg Macek
n the system? On Mon, 2002-11-18 at 10:37, Dan Nelson wrote: > In the last episode (Nov 18), Greg Macek said: > > Hello, > > > > I have a problem that I could use some help with. We're running a > > mysql/php intranet site for time sheets (home grown solution). However &

Re: Disappearing records?

2002-11-18 Thread Greg Macek
all the indexes for now and keep a watch on things. The table is still small (< 5000 records) so reporting speed isn't too much of a problem right now. On Mon, 2002-11-18 at 10:52, Dan Nelson wrote: > In the last episode (Nov 18), Greg Macek said: > > That's the weird part of

Upgrading mysql with mysql binary vs. compiling

2002-11-18 Thread Greg Macek
Is there any reason I should use my MySQL supplies binaries to upgrade my currently installed version? I compile the running version (3.23.49). Is there any difficulty in doing this? Any pitfalls to watch out for, or should I just continue to compile my own and upgrade via that path? - Greg --