I have been using perl and Mysql together but have
decided to try python and Mysql together.
I download and extracted MYSQLdb 0.35-1 from Andy Dustman's page.
The module does not seen to have instructions for use. Can anyone point
me to intructions or examples.
My purpose is a user friendly
My sense is that it's not as popular for use with MySQL as PHP or
Perl, but yes, there are people using it. A few of the MySQL books
out there have descriptions of how to use the Python interface for
MySQL, and (shameless plug) it's one of the 4 languages covered in
the upcoming MySQL
Michael Widenius wrote:
Hi!
R == R Talbot [EMAIL PROTECTED] writes:
R Hi!
rjtalbo == rjtalbo [EMAIL PROTECTED] writes:
rjtalbo I am using Mysql 3.23.40 on Linux kernel 2.2.14 Caldera..
cut
R Thanks for the response.
R I did discover .. mysql-test-run --force in the manual after
Please solve the problems
#
# groupadd mysql
# useradd -g mysql mysql
# cd /export/home0
# gunzip mysql-3.23.33.tar.gz | tar xvf -
# cd mysql-3.23.33
# ./configure --prefix=/usr/local/mysql
# make
make all-recursive
I have compiled 3.22.32, ...3.23.40.. 3.23.42
All on Linux w/ kernel 2.2.10
I obviously missed something because I have installed MySQL
many times but this time MySQL GUI would not except localhost in
MySQL GUI Options.. but it would work with the actual Host name.
Note same versions of all the above with the same Linux kernel
work on two other installs.. All have
R Talbot wrote:
R Talbot wrote:
Still having compile problems and GNU binary
produces the following info
Michael Widenius wrote:
The problem is probably that your tar
program doesn't use user-names
but user-ids, in which case the files may
be owned by 'anyone.
What output do
R Talbot wrote:
R Talbot wrote:
Michael Widenius wrote:
The problem is probably that your tar program doesn't use user-names
but user-ids, in which case the files may be owned by 'anyone.
What output do you get for:
ldd bin/mysqld
[root@thinkpad]# ls -l /bin
R Talbot wrote:
R Talbot wrote:
R Talbot wrote:
Michael Widenius wrote:
The problem is probably that your tar program doesn't use user-names
but user-ids, in which case the files may be owned by 'anyone.
What output do you get for:
ldd bin/mysqld
mysql
Subject: Help - I'm completely locked out of mysql
From: Derek Fage [EMAIL PROTECTED]
Date: 2001-09-22 14:36:08
[Download message RAW]
Hi there,
If your forgot yout root password try
#/bin/mysql -Skip-grant
use mysql;
Michael Widenius wrote:
Hi!
R == R Talbot [EMAIL PROTECTED] writes:
R Monty,
R Took your advice and downloaded
R mysql-3.23.42-pc-linux-gnu-i686.tar.gz
R Placed it in /usr/local
R Renamed /usr/local/mysql to /usr/local/mysql-old
R unpacked with
R tar -zxvf mysql-3.23.42-pc-linux
Derek Fage wrote:
Hi Bob,
Sorry to appear a bit dense, but how do I use the -Skip-grant?
I don't see a -Skip-grant option in mysql (mysql --help)
Thanks,
Derek...
-Original Message-
From: R Talbot [mailto:[EMAIL PROTECTED]]
Sent: 22 September 2001 11:57
To: [EMAIL PROTECTED
Michael Widenius wrote:
The problem is probably that your tar program doesn't use user-names
but user-ids, in which case the files may be owned by 'anyone.
What output do you get for:
ldd bin/mysqld
[root@thinkpad]# ls -l /bin/mysqld
-rwxr-xr-x 1 root root 1832912 Sep 21
R Talbot wrote:
Michael Widenius wrote:
The problem is probably that your tar program doesn't use user-names
but user-ids, in which case the files may be owned by 'anyone.
What output do you get for:
ldd bin/mysqld
[root@thinkpad]# ls -l /bin/mysqld
-rwxr-xr-x 1 root
My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1
being too old but how muc trouble is it to upgrade.the LIB
V. 3.23.40 is running but with 12 failed tests including bigint is
this an install I want to develop with.
Please advise
MYSQLBUG
SEND-PR: -*- send-pr -*-
Sasha Pachev wrote:
On Thursday 20 September 2001 20:37, R Talbot wrote:
My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1
being too old but how muc trouble is it to upgrade.the LIB
V. 3.23.40 is running but with 12 failed tests including bigint is
this an install I
Sasha Pachev wrote:
On Thursday 20 September 2001 20:37, R Talbot
wrote:
My problem is probably my lib-2.1.2.so and
GNU Make v. 3.78.1
being too old but how muc trouble is it
to upgrade.the LIB
V. 3.23.40 is running but with 12 failed
tests including bigint is
this an install
R Talbot wrote:
Michael Widenius wrote:
Hi!
R == R Talbot [EMAIL PROTECTED] writes:
R Sasha Pachev wrote:
On Thursday 20 September 2001 20:37, R Talbot wrote:
My problem is probably my lib-2.1.2.so and GNU Make v. 3.78.1
being too old but how muc trouble
R Talbot wrote:
Boyd Lynn Gerber wrote:
What version of Caldera are you running? I may be able to help next week.
tt,
--
Boyd Gerber [EMAIL PROTECTED]
ZENEZ 3748 Valley Forge Road, Magna Utah 84044
Office 801-250-0795 FAX 801-250-7975
Hi...
I am a Caldera user since
Monty,
Took your advice and downloaded
mysql-3.23.42-pc-linux-gnu-i686.tar.gz
Placed it in /usr/local
Renamed /usr/local/mysql to /usr/local/mysql-old
unpacked with
tar -zxvf mysql-3.23.42-pc-linux-gnu-i686.tar.gz
which made /usr/local/mysql-3.23.42-pc-linux-gnu-i686
I checked out the dir
I have deleted the Mysql 3.22.32 install and compiled
source for and installed Mysql 3.23.40.
The new installation resides at /usr/local/mysql.
Make Test did fail onlymerge
From the command line The daemon starts perfectly with either
mysql.server startor
safe
I currently use MySQL 3.22.32-log
I compiled the source code to use with Caldera 2.3..
Does my version support the use of the @variable syntax..
When I attempt to use this I get error Error 1064 ..
I find that this also would not work set @min_price=min(shop.price);
P.S What is the log
I am spending considerable time working with
MySQL...DB2...Sybase..PostgreSQL
I am deciding on Project development tools..
Each RDBMS has some short coming for me..
Addressing MySQL which I like very much..
I use v. 3.22.32 because there is not a binary RPM
for Caldera 2.3 and 2.4
Jorge
When I issue your suggested commands here are the resulted rows..
mysql SELECT price
-FROM shop
-HAVING price=MAX(price);
Empty set (0.01 sec)
But when I issue...
mysql select price from shop order by price desc;
+---+
| price |
+---+
| 19.95 |
| 10.99 |
| 3.99 |
Following the Tutorial
Creating and populating the table Shop in the db Test..
Why won't the following syntax work?
mysql select price
- from shop
- where price=Max(price) ;
ERROR : Invalid use of group function
Bob T
Hi Jake,
Your problem appears similar to a problem I had but...
you aren't providing quite enough information..
Are you working as a user on the same local host or
are connecting across a network?
To eliminate a MySQL problem ( so you can concentrate
your efforts on PHP code) try to connect
As a long time DB2.. Sybase.. Postgresql user upon turning to MySQL
I find only some functionalities not intuitive.
1. What command syntax to use and connect to a database on another
host.
( where I have granted permissions in mysql tables User..Host..and
..DB )
( have been
Re: How many Mysql PIDs ?
Date:
Thu, 7 Jun 2001 15:42:15 -0700
From:
Jeremy Zawodny [EMAIL PROTECTED]
Reply-To:
[EMAIL PROTECTED]
To:
R Talbot [EMAIL PROTECTED]
CC:
[EMAIL PROTECTED]
On Thu, Jun 07, 2001
Jeremy.. Apoligies
I shot off an email to you 3 seconds before I saw this one.
Please read both..this email and that email..
Jeremy Zawodny wrote:
On Thu, Jun 07, 2001 at 07:36:54PM -0400, R Talbot wrote:
Jeremy
So what your pointing out is I am seeing several threads
generated
Please explain why I get multiple Daemon process
when I start mysql.server..Such as
1075 pts/0S 0:00 sh /usr/local/mysql/bin/safe_mysqld
--user=root --pid
1093 pts/0SN 0:00 /usr/local/mysql/libexec/mysqld
--basedir=/usr/local/
1095 pts/0SN 0:00
Jeremy
So what your pointing out is I am seeing several threads
generated by mysqld...
But that does not answer as to why the rpm installation
start with one thread??
Both installations which I compiled from source start
with multiple threads.. ( diffrent machines Caldera 2.3)
30 matches
Mail list logo
