Yes, that's just what I did. Thanks. -----Original Message----- From: Angus Lees [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 10:52 AM To: [EMAIL PROTECTED] Cc: Alexandru Deva; Keith Watanabe Subject: Re: session records bulding up
At Tue, 14 Jan 2003 20:49:56 +0100, Gerald Richter wrote: > >One more way which is probably evil but better overall, imo, is to > >add a > field to the session table with the timestamp > > Adding a field should work. Mysql can use a default value on insert. > If you set the default to now() mysql should automaticly insert the > date and time and you should be done if i remember mysql correctly, there's a "timestamp" data type. if you create a column with that type it will automatically have the time that row was last modified. -- - Gus ------------------------------------------------------------------------------- The content of this communication is classified as Mobifon SA Romania Confidential and Proprietary Information.The content of this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this communication then delete it from your system. We appreciate your assistance in preserving the confidentiality of our correspondence. Thank you. Prezentul mesaj constituie o Informatie confidentiala si este proprietatea exclusiva a MobiFon S.A.. Mesajul se adreseaza numai persoanei fizice sau juridice mentionata ca destinatara, precum si altor persoane autorizate sa-l primeasca. In cazul in care nu sunteti destinatarul vizat, va aducem la cunostinta ca dezvaluirea, copierea, distribuirea sau initierea unor actiuni pe baza prezentei informatii sunt strict interzise si atrag raspunderea civila si penala. Daca ati primit acest mesaj dintr-o eroare, va rugam sa ne anuntati imediat, ca raspuns la mesajul de fata, si sa-l stergeti apoi din sistemul dvs. Apreciem si va multumim pentru sprijinul acordat in pastrarea confidentialitatii corespondentei noastre. ------------------------------------------------------------------------------- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
