Re: How to do a check to see if I update or insert

2004-01-26 Thread John Jolet
you SURE you want to do that in a shell script? I'd do it in perl On Monday 26 January 2004 11:39 am, Mike Tuller wrote: > I am stuck on this problem, and know there has to be a solution. > > I have a shell script, where I want to check to see if a record exists, and > if it does then update t

Re: Inserting Dates

2004-01-05 Thread John Jolet
Actually, you can insert the date with hyphens, also..so '2003-09-12' will work. and if you're not going to use the time, don't use a datetime datatype...just use date. On Mon, 2004-01-05 at 14:28, Donald Henson wrote: > On Mon, 2004-01-05 at 12:46, Ian O'Rourke wrote: > > I'm very new to MySql a

RE: Unusual date storage requirement

2003-10-27 Thread John Jolet
what about forcing the date to the first of whatever month the sale was in? if it's got a valid date, put that, otherwise, put the first. -Original Message- From: sean peters [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 4:33 PM To: [EMAIL PROTECTED] Subject: Unusual date stor

encryption/authentication

2003-07-16 Thread John Jolet
I need to find out if it's possible to do two things with mysql. The first is external authentication, preferably with kerberos5, but PAM will work as well. Second, encrypting the data stream. Specifically with jdbc connections. -- MySQL General Mailing List For list archives: http://lists.my