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 mac

Re: Re: Procedures

2001-06-13 Thread John Tsangaris
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your

Re: Procedures

2001-06-12 Thread John Tsangaris
in MS SQL 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

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

DB access privaleges

2001-05-21 Thread John Tsangaris
I'm trying to make my mysql a little more secure by restricting certain users to certain databases. Looking at the manual, it appears I do what I need to do via the mysql:db table. I was told by several people that mysql:db should contain a list of all databases in mysql... the problem is tha

Fwd: DBD::mysql

2001-03-06 Thread John Tsangaris
Tried sending this once and it didn't go through. - 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

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 pat

RE: auto_increment

2001-02-26 Thread John Tsangaris
he work to change 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 re

RE: auto_increment

2001-02-26 Thread John Tsangaris
I'm using 3.22.23 :/ I think I may have to implement my own auto_increment to capture deleted id's. Thanx. John -Original Message- From: Atle Veka [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 1:53 PM To: John Tsangaris Cc: [EMAIL PROTECTED] Subject: Re: auto

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: Perl DBI

2001-02-16 Thread John Tsangaris
l without connecting 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

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 h