DBD::Mysql on Mac OS X

2002-01-31 Thread John Tsangaris
I am trying to install mysql, DBI, and DBD::mysql on MacOS X. My problems are in the DBI and DBD::mysql part. Has anyone successfully installed the DBI and DBD::mysql perl modules on this platform? I'm running into troubles in the fact that, god bless them, whoever decided to put unix on a

Re: Procedures

2001-06-12 Thread John Tsangaris
server or Oracle. The only difference is that those big database systems have built-in facilities that let you write those functions without a help of other programming languages. I hope this helps. Seung-woo Nam John Tsangaris wrote: Do you know exactly what the package name is? I have

Procedures

2001-06-11 Thread John Tsangaris
From the docs, it doesn't look like too much has been done in the area of stored procedures. Are there any resources which would teach me or point me in the right direction to writing procedures for mysql? The manual mentions that it has facility for c++ procedures, but if you want to learn

DBD::mysql

2001-03-05 Thread John Tsangaris
I am trying to install DBD::mysql on a server which does not have mysql on it. ( The script will be accessing a mysql database on another server). The problem is, when I try to install dbd::mysql I am asked several questions.. one of which being: what is the path to mysql? I don't have a

auto_increment

2001-02-26 Thread John Tsangaris
If I turn on auto increment and let it do it's thing and then later on delete a few of the entries (let's say 1, 2, 3) and the current high entry has an id of 45.. why does mysql continue with 46 instead of using up 1, 2, and 3 first? Is there a way to bypass this? John

RE: auto_increment

2001-02-26 Thread John Tsangaris
it. :) Just checking my options. John -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 2:35 PM To: John Tsangaris; Atle Veka Cc: [EMAIL PROTECTED] Subject: RE: auto_increment Just curious, is there a specific business rule that requires you to have

Perl DBI

2001-02-16 Thread John Tsangaris
Is it possible to connect to mysql without connecting directly to a database, check to see if a particular database exists, and if it doesn't exist create it? I have not been able to find a way of connecting to mysql without having a database already (I want perl to be able to make the db.. not

RE: Perl DBI

2001-02-16 Thread John Tsangaris
to a database? John -Original Message- From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 1:21 PM To: John Tsangaris; [EMAIL PROTECTED] Subject: Re: Perl DBI Connect to the mysql database if you have access. It always exists. - Original Message - From: "