Version: 3.23.33
I'm experiencing a problem... Whenever I use LEFT JOIN in my SELECT
statement, it no longer appears to use the index to sort, hence making the
query slow.
I have two tables: "files" (~3000 rows) and "folders" (~500 rows). In the
tables, the "id" columns are the primary keys,
I am compileing MySQL 3.23.33 with the following options:
--prefix=/usr/local
--with-berkeley-db=/disks/eradicator/i686/BerkeleyDB
--with-berkeley-db-includes=/disks/eradicator/i686/BerkeleyDB/include/
--with-berkeley-db-libs=/disks/eradicator/i686/BerkeleyDB/lib/
I have BerkeleyDB 3.2.9, and
Jeremy Huddleston wrote:
Has anyone had similar problems or know a way around other than just not
using BerkeleyDB?
That's not a valid problem. And it's not MySQL's fault either that no one
reads the README and/or INSTALL files that come with the product.
You need to download the
Hi,
I am using mysql-3.22.32 with php4.
I have a little problem with the uppercase.
I wanted to display a user input field in CAPS.
This is what I did and it did not work.
$userfield = upper('$userfield');
echo "User Field - $userfield";
Errors (tried both ucase and upper)
Call to undefined
yesss, i got the solution from Vladislav Shulgin -- thanx very much...
he wrote:
Try this:
select pilote.name from pilote, flight flight, flight flight1
where
flight.id_pilote=pilote.id and
flight1.id_pilote=pilote.id and
fligth.id_flight=1 and
fligth1.id_flight=3
Funtion name is strtoupper()
See PHP4 manual, function reference, string functions.
Regards
JC
- Original Message -
From: "Hoo Kok Mun" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 11, 2001 11:00 AM
Subject: upper and ucase
Hi,
I am using mysql-3.22.32 with php4.
I tried. It doesn't work. It sais "Table 'absences' is read-only". I
checked the files absences.* and owner is user mysql and permissions are
644.
Any ideas?
On Sat, 10 Mar 2001, Siim Einfeldt aka Itpunk wrote:
Try REPAIR TABLE absences; This should do the trick:-)
Hy!
I have a
Thanks Maes,
It works like a charm.
At 12:14 PM 11-03-01 +0100, Maes Jean-Claude wrote:
Funtion name is strtoupper()
See PHP4 manual, function reference, string functions.
Regards
JC
- Original Message -
From: "Hoo Kok Mun" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March
Shen Yingshuo writes:
Hello,
I have been trying to install MySQLGUI but I have not been so
lucky. I am running on SUN Solaris 7 Sparc... but after I downloaded
your static binary of MySQLGUI1.6... I
could not install it... any suggestion and help will be greatly
welcome...
Hi,
Having a problem running safe_mysqld from my init scripts.
I use simpleinit, and i simply call /usr/local/mysqld/bin/safe_mysqld from
my rc file.
This works for all other services, however, mysqld ends immediately. The
.err file shows:
010312 07:51:43 mysqld started
Justin writes:
What is your key buffer size? In my case, key buffer size is set
to 384mb .. and mysqld starts out small, perhaps 18mb and grows
within a day to 100mb, and within a few days to pretty much 300+mb
..so it is doing what one would expect it to.
The other mem parameters
[EMAIL PROTECTED] writes:
Description:
It appears that if a column generated by a select is
a sum of variables generated in other columns of the
select (see example below!), the column will have a
bogus result if the select is 'DISTINCT'. If the
DISTINCT
Hi!
I have a strange problem with my MySQL database!!
mysql show databases;
+--+
| Database |
+--+
| |
| |
| |
| |
| |
| |
| |
+--+
7 rows in set (0.00 sec)
Using mysql version 3.23.32 on Red Hat 7
Anyone
Hello,
I wrote my own C code which is using MySQL C API to connect to
MySQL server. I compile with follow line:
gcc -I/usr/local/include/mysql -L/usr/local/lib/mysql mysql_auth.c -o
mysql_auth -lm -lmysqlclient
My Free BSD 4.0 writes me:
: No such file or
Description:
Database:
total: about 500Mb now
mostly used table: about 300Mb data, about 150Mb index, about 6,7 millions of records,
two indexes(primary key contains 3 fields, and other index contains 2 fields)
other tables is negligible (U see)
How-To-Repeat:
we repeating
Hi!
As it has been posted to this mailinglist, you have to upgrade your
system to 4.2 STABLE.
Then, please use a contributed 3.23.33 binary for 4.2 stable from 3.23
download page.
And what do you use MySQL for in your esteemed Institute ??
Regards,
Sinisa
__ _ _
Can anyone tell me how to UNSUBSCRIBE from this list. I have sent numerous mails to
the [EMAIL PROTECTED] but theres no action take
I would appreciate if someone can exactly tell me how to unsubscribe
Thx in adv.
__
Get your
dear sir:
I use mysql 3.22 for a long time, it seems ok on our native language
traditional chinese, charset big5.
I use '--with-charset=big5' as the only one configure parameter, but
when I use it on 3.23.32, the client will yield this error message:
--
File
hi,
just take a look at http://www.mysql.com/documentation/lists.html or send an empty
mail from your accout to mailto:[EMAIL PROTECTED]
Greetings
Andreas
Can anyone tell me how to UNSUBSCRIBE from this list. I have sent numerous mails to
the [EMAIL PROTECTED] but theres no action take
Hi,
I need mysql (under linux) tool's -q (--quick "don't cache result, print it row by
row") in myodbc.
How can I configure the myodbc??
I have been using MyODBC 2.50.36 and I'm connecting to MySQL Server at Linux (Red Hat
7.0 2.2.16-22) under MS Win98.
Thanks.
h.
On Sun, Mar 11, 2001 at 06:16:22PM +0100, Rick Jansen - Tweakers.net wrote:
Hi there,
I'm trying to set up replication. But it's not working, for some
strange reason. This is the error out of the slave log: 010311
18:11:25 Slave thread: error connecting to master:Access denied for
user:
Justin wrote:
What is your key buffer size?
mysql show variables;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:47881
Current database: *** NO ONE ***
|
| key_buffer_size |
How can I, from the mysql-client command line, insert a local binary fil
(i.e. an image) into a blob column in a table - using a standard insert
query?
For reference: Tablename = "pictures", Columnname(type
mediumblob)="picture",Localfile="/tmp/test.gif"
- Erling Paulsen
Dear Sir or Madam,
Re: Installation MySQL version 3.23.22-beta.
I am awfully sorry to bother you with some basics. I am a novice. I am trying to use
the above on my PC which is running on Windows 98. In WinMySQLAdmin, my.ini set up
appears complete. I have looked at the starting tutorial
- Original Message -
From: "Ren Tegel" [EMAIL PROTECTED]
To: "Thomas Morton" [EMAIL PROTECTED]
Sent: Sunday, March 11, 2001 8:42 PM
Subject: Re: May I ask for your assistance?
Thomas,
as far as i know, i didn't notice _any_ difference in the behaviour if
mysql
on linux or win32. i
Thanks for your time.
I disabled replication (slave stop), removed the master.info file (it did
contain a wrong/old password), stopped the mysqld (mysqladmin -p shutdown),
and restarted it (safe_mysqld ).
The information in master.info is correct now, but still it gets an access
denied. The
On Sun, Mar 11, 2001 at 09:02:57PM +0100, Rick Jansen - Tweakers.net wrote:
Thanks for your time.
I disabled replication (slave stop), removed the master.info file
(it did contain a wrong/old password), stopped the mysqld
(mysqladmin -p shutdown), and restarted it (safe_mysqld ). The
No, nothing concerning the replication user that is.
I do get this error alot (ie, every second):
010311 21:38:37 Aborted connection 2318 to db: 'gotforum' user: 'mysql'
host: `aphrodite' (Got an error reading communication packets)
010311 21:38:38 Aborted connection 4700 to db: 'gotforum'
Thank you Sinisa,
I actually did try the upgade, but rapidly reverted due to errors
such as these:
mysqld got signal 11;
stack range sanity check, ok, backtrace follows
0x812cfea
0x809f541
0x809da87
:
:
etc
AND...
read_const: Got error 127 when reading table ./
read_next_with_key: Got
Greetings,
The configure process fails on attempting to compile and link the executable
conftest. Below is some of the output generated by configdebug.
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from
This has been discussed to death,
DO NOT RUN GCC 2.96 TO COMPILE MySQL IT IS FAR TO BUGGY
Please check the mailing list archives _BEFORE_ posting
Lyman Neuschaefer wrote:
Greetings,
The configure process fails on attempting to compile and link the executable
conftest. Below is
Sir, if you look through the documentation on the PHP site, you will
find the strtoupper function, and a number of PHP mail lists where
PHP related questions can be posted. If you have any MySQL related
questions, the contributors to this MySQL mail list will be happy to
try and help you.
Hi!
MySQL 3.23.34 is now finally released. It took a little extra time to
do this as we added Berkeley DB and Innobase to the MySQL
source distribution. In MySQL 3.23.35 we will probably also add
GEMINI tables.
The reason for adding the table handlers in 3.23 and not in 4.0 is that
the table
Are you always this hospitable to others?
Charles
- Original Message -
From: "Colin Faber" [EMAIL PROTECTED]
To: "Lyman Neuschaefer" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, March 11, 2001 4:46 PM
Subject: Re: configure fails on linux-2.2.14 (Redhat 7.0), mysql-3.23.33
Yes always. :p
"Charles L. Hagen" wrote:
Are you always this hospitable to others?
Charles
- Original Message -
From: "Colin Faber" [EMAIL PROTECTED]
To: "Lyman Neuschaefer" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, March 11, 2001 4:46 PM
Subject: Re: configure
Dear Sir or Madam,
Re: Installation MySQL version 3.23.22-beta.
I am awfully sorry to bother you with some basics. I am a novice.
I am trying to use the above on my PC which is running on Windows
98. In WinMySQLAdmin, my.ini set up appears complete. I have
looked at the starting tutorial
Subject: [Missing files in 3.23.34 and .33 -- .34 patch]
Description:
Theses (innobase) files are not being included,
and thus compiles fail (all are /innobase/):
mem/mem0dbg.c
pars/pars0grm.h
How-To-Repeat:
compile with --with-innobase
Hi,
We have had a lot of trouble with M$Access2k as a frontend to
MySQL... even if we've installed SR1, SP2 and M$ Jet 4 SP 5!!!
(using the latest MyODBC driver and MySQL 3.22.32 over Debian
GNU/Linux)
I've read M$Access2k has problems even with M$ SQL Server, so the big
questions here are:
Description:
the *tab* auto-completion does not work if tablename has 1st 2 chars uppercase.
How-To-Repeat:
Open mysql command line. "Create table BLahblahblah(ID integer);"
Then try to tab-complete it on a SELECT statement. (SELECT * from B..)
Fix:
No fix known,
Hi All,
I've been lurking around on this list for a few days, and searching archives and
darn near anything else I can get my hands on. What I'm curious to find out is,
how many people are using MySQL for logging Squid/Aapache (more Squid) and how
did you go about doing it.
I've already
I checked the known bugs in replication, and I've found a situation where it
definitely does not propogate changes. I'd just like to know if this is normal or
not.
Say you have two databases (call them data1 and data2) on your master server. Only
data1 is being replicated.
Within the
Hello:
I am attempting to teach myself SQL. In pursuit of this, I want to install mySQL on
my home PC. I downloaded the file "mysql-3.23.34-win.zip". After unzipping this file
I couldn't find the "setup.exe" that the instructions state I need to run.
Am I doing something wrong? Is it
I installed the MySQL 3.23.34-1 rpm on my redhat 7 box. It all seemed to
work fine, but suddenly i got this error in numerous of my php scripts. it
happens only on update and insert statements. The data however might have
been stored in the db.
Warning: MySQL: Unable to save result set in
I've used both Visual FoxPro and PHP without a problem.
Cal
http://www.calevans.com
-Original Message-
From: Roberto Meyer [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 11, 2001 9:28 PM
To: [EMAIL PROTECTED]
Subject: Replace Axess as frontend
Hi,
We have had a lot of trouble with
Hello ,
I am developing front end applications with backend mysql server in
vc++. Can anyone tell how to connect to mysql server using odbc. Where is
that specific api documentation is found. I badly need it for my project.
satish.
I log all page requests to a rotating table name based on day of
week. Logging image requests is probably a bridge too far. This
gives me 7 days grace to archive off old tables to an analysis
database.
Originally it was done to one table, but this idea didnt work too
well because a purge based
46 matches
Mail list logo