Re: ~~Info needed~~

2006-03-11 Thread Mohammed Abdul Azeem
Hi Green & Eugene, Thanks a lot. On Fri, 2006-03-10 at 09:57 -0500, [EMAIL PROTECTED] wrote: > Косов Евгений <[EMAIL PROTECTED]> wrote on 03/10/2006 07:53:37 AM: > > > Hm... It seems to me In MySQL there's no such thing as "database owner". > > > Or am I missing something? > > > > Mohammed A

Re: ~~Info needed~~

2006-03-10 Thread SGreen
Косов Евгений <[EMAIL PROTECTED]> wrote on 03/10/2006 07:53:37 AM: > Hm... It seems to me In MySQL there's no such thing as "database owner". > Or am I missing something? > > Mohammed Abdul Azeem пишет: > > Hi, > > > > How to check for the database owner for a particular database ? The way >

Re: ~~Info needed~~

2006-03-10 Thread Косов Евгений
Hm... It seems to me In MySQL there's no such thing as "database owner". Or am I missing something? Mohammed Abdul Azeem пишет: Hi, How to check for the database owner for a particular database ? The way "show procedure status" command lists the "definer" column, Is there a command that shows

~~Info needed~~

2006-03-10 Thread Mohammed Abdul Azeem
Hi, How to check for the database owner for a particular database ? The way "show procedure status" command lists the "definer" column, Is there a command that shows the database owner. Similarly, what is the command to see the owner of a table in a database ? Thanks in advance, Abdul.

RE: RE: Info Needed to Promote MySQL!!

2001-09-26 Thread Adam Douglas
e least limit your control. > -Original Message- > From: mysql-digest-help [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 24, 2001 6:08 PM > To: venu; turner; mysql > Cc: adouglas > Subject: RE: RE: Info Needed to Promote MySQL!! > > > > As a quick note

RE: RE: Info Needed to Promote MySQL!! - Solved

2001-09-25 Thread Adam Douglas
> What I did to handle global changes was have one access file on the > fileserver that everyone had a shortcut to. That way the updates > were global since they were all to the same file. How is the speed of running Queries, Forms and Reports from Access using linked tables to MySQL? I've found

Re: Info Needed to Promote MySQL!!

2001-09-25 Thread Frank Fisher
Adam Douglas wrote: > 1. Replication between 2 sites via the internet over a VPN or just using a > secure connection. Chapter 11 in the manual (p. 354 of the PDF). You're set. SSH will get you the secure connection. > 2. Transaction processing capabilities with the ability to roll-back a >

Re: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread David Turner
What I did to handle global changes was have one access file on the fileserver that everyone had a shortcut to. That way the updates were global since they were all to the same file. Dave On Mon, Sep 24, 2001 at 04:19:55PM -0600, Adam Douglas wrote: > > Another small research in Access made me t

RE: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread Adam Douglas
> Another small research in Access made me to see the changed > table structure > completely. Please use this procedure to view or to refresh > links when the > structure or location of a linked table has changed. > > 1. Open the database in access that contains links to tables. > 2. On the Too

RE: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread Adam Douglas
> Another small research in Access made me to see the changed > table structure > completely. Please use this procedure to view or to refresh > links when the > structure or location of a linked table has changed. > > 1. Open the database in access that contains links to tables. > 2. On the Too

Re: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread David Turner
uglas [mailto:[EMAIL PROTECTED]] > > Sent: Monday, September 24, 2001 2:43 PM > > To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com > > (E-mail) > > Subject: RE: RE: Info Needed to Promote MySQL!! > > > > > > > >

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Adam Douglas
> As a quick note, I tried the same with MS SQL Server through > its latest ODBC > driver by adding the new column, and I couldn't see any changes in the > linked tables from Access 2002. > > So it shows clearly that, its some thing related to MS > Access, not with the > driver. It might be a b

RE: RE: Info Needed to Promote MySQL!! - Solved

2001-09-24 Thread Venu
California, USA <___/ www.mysql.com > -Original Message- > From: Adam Douglas [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 24, 2001 2:43 PM > To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com > (E-mail) > Subject: RE: RE: Info Nee

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Venu
s. Mysql. Com (E-mail); David Turner > Subject: Re: RE: Info Needed to Promote MySQL!! > > > I was never able to see the changes in table structure with > Access and Oracle unless I manually added the column to linked > table in Access after I had added it in Oracle. > > Dave &

Re: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread David Turner
I was never able to see the changes in table structure with Access and Oracle unless I manually added the column to linked table in Access after I had added it in Oracle. Dave On Mon, Sep 24, 2001 at 02:34:30PM -0700, Venu wrote: > Hi Douglas and David !! > > > I have the following setup... > >

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Adam Douglas
> > Now I've found when I do changes to a table schema the > changes are not > > entirely at least reflected in a the same table linked in Access. > > I had once > > case where I changed a data type on one of the columns and > that data type > > was not changed on the linked table in Access. I h

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Venu
Hi Douglas and David !! > I have the following setup... > > - MySQL 3.22.32 on OpenBSD v2.9 > - MyODBC on Windows '98 SE > - MS Access 2000 > Cool !!! > Now I've found when I do changes to a table schema the changes are not > entirely at least reflected in a the same table linked in Access.

Re: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread David Turner
I've had the same issues. I have really avoided the dev side of things for some time so I'm not sure whether there's a way around it. Mainly just devoting myself to administration. Funny though I'm starting to write jsp stuff to monitor the databases more effectively. I agree with you on the MYO

RE: RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Adam Douglas
> What type of schema do mean here ? Because as you know, MySQL doesn't > explicitly supports any schema's except the catalogs( in MySQL term > 'database'). If you can elaborate what exactly the problem > you are facing, > then we can provide a rapid solution. > > Also, as for as I know, when I

Re: Info Needed to Promote MySQL!!

2001-09-24 Thread Sergei Golubchik
Hi! On Sep 24, Adam Douglas wrote: > > my main concern is to find a Windows MySQL GUI Client that will do everything > in a similar fashion as Access. If I'm not mistaken you can just continue to use Access as a GUI and for rapid prototyping, connecting it to MySQL via ODBC. Regards, Sergei -

RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Adam Douglas
>> Now I have quite a bit of information on all these questions.. my >> main concern is to find a Windows MySQL GUI Client that will do everything >> in a similar fashion as Access. I believe we would need the >> basics but also >> including visual query builder and reports. I've recently fou

RE: Info Needed to Promote MySQL!!

2001-09-24 Thread Venu
Hi > Now I have quite a bit of information on all these questions.. my > main concern is to find a Windows MySQL GUI Client that will do everything > in a similar fashion as Access. I believe we would need the > basics but also > including visual query builder and reports. I've recentl

Info Needed to Promote MySQL!!

2001-09-24 Thread Adam Douglas
Hi. I'm looking for any support/help that one is willing to give to assist me in convincing the company I work for to switch over to MySQL as there sole database system. We currently use MS Access which we all know is a some what to be desired database. I have to answer the following quest

Re: Info needed! -- urgent!!

2001-07-19 Thread Asha Ramaiah
Connection(); stmt = con.createStatement(); rs = stmt.executeQuery(sqlQuery); } - Original Message - From: Venu Anuganti <[EMAIL PROTECTED]> To: Asha Ramaiah <[EMAIL PROTECTED]> Sent: Thursday, July 19, 2001 11:55 AM Subject: Re: Info needed! > If Connection.isClosed()

Re: Info needed!

2001-07-18 Thread Venu Anuganti
gt; To: <[EMAIL PROTECTED]> Sent: Wednesday, July 18, 2001 10:32 PM Subject: Info needed! I need to run a query from a java program to : 1) get the list of tables in a particular db] 2) get the desc of each table in the list I get Can I use the show tables; and desc tablename as a query to ge

Info needed!

2001-07-18 Thread Asha Ramaiah
I need to run a query from a java program to : 1) get the list of tables in a particular db] 2) get the desc of each table in the list I get Can I use the show tables; and desc tablename as a query to get the desired RESULTSET in java(sql package) ?? Plz do respond at hte earliest! Thanks and re