The following URL Points to the Python MySQl interface. Also Zope is a
web applications server written in python which has the ability to
connect to MySQL.
http://dustman.net/andy/python/MySQLdb/
±i¸Î¯q wrote:
> Dear Guys,
>
> Is there any API or modules to connect MySQL from Python??
>
> --
>
I do not think that this can be solved using only SQL. Your system design my
require you to use one query for the display and another
for edit checking in order to achieve your goal.
Chris Toth wrote:
> Kentj
>
> Ok, I understand. I thought DISTINCT only worked on the field listed
&
Your query selects eight fields. Your Display shows five fields. The distinct verb
works on all eight fields and
apparently some of the fields not displayed are different. Limit the query for the
display to the five fields displayed
and the distinct verb should eliminate the duplicates from the d
It looks like the addition of the distinct verb should do the job if in fact your
query only showed the fields on the display.
>From your Sql however you are selecting more fields than are displayed and some
of those are different which distinct
will still display.
Chris Toth wrote:
> Ok, I've b
An RPM installation indicates that you might be installing on some
version of Linux. Could you specify the platform, the operating system,
the Mysql release Number so
that people with the experiece that you need will able to respond. My
experiece is with SusE Linux 7.0 and release Mysql-3.23.32-1
Is there an archive for this mailing list?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECT
If my memory serves me correctly this was solved by fixing the rpms in 3.23.32-1.
You mightr try the current version.
Rus Rasmussen wrote:
> Hello,
>
> I am trying to install the MySQL-client and MySQL-shard RPMs. I am not very
> bright with this stuff so go easy on me.
>
> This is the error I
I linked the mysql tables into my access database and did a cut and paste of the
access tables into the mysql tables. This was
an intranet setup though.
Rolf Hopkins wrote:
> - Original Message -
> From: "Joe and Nancy M" <[EMAIL PROTECTED]>
> To: "Rolf Hopkins" <[EMAIL PROTECTED]>
> Sen
I have an Access 2000 Db on a Win98 system with tables linked to a MySql23.32-1
database on Suse Linux 7.0
using the latest MyODBC with a System DSN specifying anyname.dsn, the IP of
192.168.2.5 for the host, the
database name of "metrics" and port 3306. I had to setup the privileges very
carefull
I believe so. I was trying that and was missing something because I could
not get it to work.
Dave Hodgkinson wrote:
> kentj <[EMAIL PROTECTED]> writes:
>
> > I have been reading the mysql book by Dubois and trying to figure out
> > how to implement his restart methods
I have been reading the mysql book by Dubois and trying to figure out
how to implement his restart methods
on a SUSE Linux 7.0 Box. Has anyone done this and can give me
information how to do it?
-
Before posting, please check:
Actually I got "A connection could not be made using the data source parameters
entered. Save non-verified file DSN?
"(Mr) Pekka Gaiser" wrote:
> Hi,
> I got no solution, just a few ideas, probably you have checked them already.
> - Windows DSN name doesn't matter. Type in anything you want.
> -
Suse 7.0 when I ran rpm -Uhv MySql*3.23.32-1.i386.rpm against the sever, the
client and the
shared rpms.It ran without error and created the appropriate files on a 10 gig
/var/lib/mysql.
I moved the contents of mysql to /dbshare and created a symbolic link in /var/lib
called mysql which pointed
ysql directory in /dbshare owned by mysql ?
> Are the permissions 775 ?
> Does mysql own the files in /dbshare/mysql ?
>
> kentj wrote:
> >
> > dbshare is owned by mysql with group deamon
> > and I have run install_db
> >
> > "Gerald L. Clark" wr
I have read that IBM has concluded that Linux is ready for the big time.
That may be true for Linux but I would doubt that the same could be said
for MySQL. For example the missing host.frm has been in threads in the
archive for a long time, I have been
bitten by the beast with no success yet in s
to the server, it
> won't let me in. Do you think I should do that first?
>
> Thanks for your time
>
> Joel
> - Original Message -
> From: kentj <[EMAIL PROTECTED]>
> To: Joel Holtzman <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, Fe
A gui that works on the linux box is kmysql.
Joel Holtzman wrote:
> Hello, I always wanted a gui interface to use on my win 98 pc to connect
> to mysql, and create/edit tables. However, i always get an access denied
> error, saying I'm not allowed to connect to the mysql server.
>
> However,
dbshare is owned by mysql with group deamon
and I have run install_db
Jody Williams wrote:
> Did you run the script, mysql_install_db?
>
> kentj wrote:
> >
> > Platform Suse 7.0,
> > AMD 450 KIII+,
> > 128MB Ram
> >
> > Linux on 10 Gig system hardd
dbshare is owned by mysql with group deamon
and I have run install_db
"Gerald L. Clark" wrote:
> kentj wrote:
> >
> > Platform Suse 7.0,
> > AMD 450 KIII+,
> > 128MB Ram
> >
> > Linux on 10 Gig system harddrive
> > with 45 Gig additio
dbshare is owned by mysql with group deamon
and I have run install_db
"Gerald L. Clark" wrote:
> kentj wrote:
> >
> > Platform Suse 7.0,
> > AMD 450 KIII+,
> > 128MB Ram
> >
> > Linux on 10 Gig system harddrive
> > with 45 Gig additio
What is host.frm and why can host.frm not be located where I want to
be?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Platform Suse 7.0,
AMD 450 KIII+,
128MB Ram
Linux on 10 Gig system harddrive
with 45 Gig additional drive mounted as /dbshare.
I have created a symbolic link in /var/lib of mysql-> /dbshare.
then
RPM -Uhv --force MySQL*-3.23.32-1.i386.rpm to install the files
from
MySQL-3.23.32-1.i386.rpm
M
Platform Suse 7.0,
AMD 450 KIII+,
128MB Ram
Linux on 10 Gig system harddrive
with 45 Gig additional drive mounted as /dbshare.
MySQL needs to keep its database files in dbshare but I have not been
able to make it work.
>From what I have read in this maillist it would appear that some
combination
I am running SuSe 7.0 and have had the same experience. I think that I
remember reading in the SuSE manual about some standard Linux directory
structure which they are using. I wonder if this is a recent Linux standard
and MYSql.RPm has not
been updated to use this structure. I do not find the fil
24 matches
Mail list logo