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 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.
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 the
Косов Евгений [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
show
, September 24, 2001 6:08 PM
To: venu; turner; mysql
Cc: adouglas
Subject: RE: RE: Info Needed to Promote MySQL!!
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
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
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 it
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
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 recently
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 found
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
--
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 change
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
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.
I had
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 had to
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
On Mon, Sep 24, 2001 at 02:34:30PM -0700, Venu wrote:
Hi Douglas
___/ 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 Needed to Promote MySQL!!
Now I've found when I do changes
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 bug from
-mail)
Subject: RE: RE: Info Needed to Promote MySQL!!
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
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 Tools
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 Tools
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 to
();
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() returns false means, the connection
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
: 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 get the desired
RESULTSET in java(sql package
25 matches
Mail list logo
