I have just upgraded to mysql 4 to be able to perform delete queries
with join statement. I have a simple query where I would like to delete
a number of rows in tabel t1 depending on id's found in table t2. This
doesn't seem to work and I just don't understand why!?
mysql delete icl from
H...
( mysql, query )
What permissions does a user need to issue:
LOCK TABLES blah WRITE
???
I have a user which I have:
GRANT ALL ON * TO user (blah blah)
...but that user can't lock any tables. Only the mysql root user can...
Version 4.0.2, built from source on RH 7.1.
DSL
--
Paul,
(mysql, query)
It *can* use TCP, but that's just the transport protocol through which
the replication information is processed. Replication can also be
done between two servers on the same host, using a UNIX socket or (on
a Windows box) a named pipe. The replication protocol itself
»ª±±ÆóÒµÃû¼http://www.rqhh.com
µÇ¼»ª±±ÆóÒµÍø£¬Äú¿ÉÒÔ
1.Ãâ·Ñ¼ÓÈëÆóÒµÃû¼
1.Ãâ·Ñ·¢²¼ÆóÒµÐÅÏ¢
2.Ãâ·Ñ·¢²¼¹©ÇóÐÅÏ¢
3.Ãâ·Ñ·¢²¼ÆóÒµÐÂÎÅ
´ËÍ⣬»ª±±ÆóÒµÍø»¹°üÀ¨£ºÊ±Ê±¨µÀ¡¢ÆóÒµ¶¯Ì¬¡¢Õþ²ß·¨¹æ¡¢ÐÅÏ¢²éѯµÈÀ¸Ä¿£¬ÊÇÄú¼°Ê±»ñÈ¡ÐÅÏ¢µÄ×î¼Ñ;¾¶¡£
Hi there,
Haven't been watching the list lately so forgive me if this has already been
discussed here recently. Have any of you seen an issue with MySQL 3.23.52
spiralling out of control after a minute or so of operation? We run a
fairly high-volume db, previously running 3.23.49a and
Christian,
Saturday, August 31, 2002, 11:09:47 AM, you wrote:
CL I have just upgraded to mysql 4 to be able to perform delete queries
CL with join statement. I have a simple query where I would like to delete
CL a number of rows in tabel t1 depending on id's found in table t2. This
CL doesn't
mos,
Friday, August 30, 2002, 7:04:25 PM, you wrote:
m At 07:58 AM 8/30/2002, you wrote:
mos,
Thursday, August 29, 2002, 5:45:05 PM, you wrote:
Start by looking at the MySQL documentation:
http://www.mysql.com/doc/en/Query_Cache.html
Read the entire 6.9 section.
It offers quite a bit of
Christian Longberg wrote:
I have just upgraded to mysql 4 to be able to perform delete queries
with join statement. I have a simple query where I would like to delete
a number of rows in tabel t1 depending on id's found in table t2. This
doesn't seem to work and I just don't understand why!?
Hi,
I have two connections open to a mysql-nt server. I am using one
connection to add a field field to a table using the command
ALTER TABLE testtable ADD testfield int;
Now if I issue any query from the second connection, the mysql-nt daemon
crashes with a Dr.Watson error. The but if
At 10:55 +0200 8/31/02, David Lloyd wrote:
Paul,
(mysql, query)
It *can* use TCP, but that's just the transport protocol through which
the replication information is processed. Replication can also be
done between two servers on the same host, using a UNIX socket or (on
a Windows box)
We experienced a similar problem with 3.23.51 which went away
once we compiled from source. Assume this is Linux 2.4?
-M
On Sat, Aug 31, 2002 at 03:08:10AM -0700, John Stanforth wrote:
Haven't been watching the list lately so forgive me if this has already been
discussed here recently. Have
Hi,
I've looked through the archives of this list but all methods of porting
a ms access db to mysql seem to require installing additional software
under Windows.
Is there a tool available that converts an existing ms access db-file
(*.mdb) into something that can be imported into mysql?
I
you could install MyODBC to write the tables directly from MS A. to MySQL
via ODBC.
Works ok and did a good job for me.
Andy
- Original Message -
From: Mertens Bram [EMAIL PROTECTED]
To: mysql mailing list [EMAIL PROTECTED]
Sent: Saturday, August 31, 2002 4:17 PM
Subject: convert
At 16:17 +0200 8/31/02, Mertens Bram wrote:
Hi,
I've looked through the archives of this list but all methods of porting
a ms access db to mysql seem to require installing additional software
under Windows.
Is there a tool available that converts an existing ms access db-file
(*.mdb) into
Andy,
( mysql, query )
you could install MyODBC to write the tables directly from MS A. to MySQL
via ODBC.
Works ok and did a good job for me.
I've looked through the archives of this list but all methods of porting
a ms access db to mysql seem to require installing additional
On Sat, 2002-08-31 at 17:59, David Lloyd wrote:
( mysql, query )
You have missed his point. He's asking Microsoft to support MySQL as a
native backend.
I'm sorry if I was unclear, I'll try to clarify.
I created a db under Windows using Access, I backed the .mdb files up.
I have upgraded my OS
Wrong Sorting in arabic alphabets
Hi,
This bug is for Arabic alphabets.
I am using mysql 32.23.52
The error is :
When sorting a table ASC it puts the letter (mem ãíã)
in the top.
The letter (mem ãíã) is the 24 alphabets
Example
1 ÌÑíÑ (first letter is jeem Ìíã - number 5 in
the
Michael, what compiler/version did you use?
Thanks,
--jeff
- Original Message -
From: Michael Bacarella [EMAIL PROTECTED]
To: John Stanforth [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, August 31, 2002 6:58 AM
Subject: Re: 3.23.52 hitting system loads of 25+?
We
I can supply a converter that will do this without having Access installed.
Contact my Sales Manager Joy Johnson at [EMAIL PROTECTED] who will let you have
a copy for £30.00 plus VAT (If in the EU)
Michael Johnson
Director
BPEnet Humphrey Consulting Limited
13 Austin Friars London EC2N 2JX
Tel
At 18:16 +0930 8/31/02, David Lloyd wrote:
H...
( mysql, query )
What permissions does a user need to issue:
LOCK TABLES blah WRITE
???
I have a user which I have:
GRANT ALL ON * TO user (blah blah)
...but that user can't lock any tables. Only the mysql root user can...
Version
Hello,
I was trying to create a simple perl program, where my domains where listed
followed by there DNS records.
But It loops once, and then ends with error DBD::mysql::st fetch failed:
fetch() without execute() at test.cgi line 61.
I thougt this was the easyest way to do so. But no.. Does
Hello,
I was trying to create a simple perl program, where my domains where listed
followed by there DNS records.
But It loops once, and then ends with error DBD::mysql::st fetch failed:
fetch() without execute() at test.cgi line 61.
I thougt this was the easyest way to do so. But no.. Does
Here is the evil query:
SELECT DISTINCT * FROM b2posts WHERE 1=1 AND ID = 124 AND ((post_title
LIKE '%%') OR (post_content LIKE '') OR (post_title LIKE '%%') OR
(post_content LIKE '%%')) AND post_date '2002-08-31 14:31:55' AND
post_category 0 ORDER BY post_date DESC
Here's a structure dump of
Just found a new one I really like. Does everything, create tables,
queries, etc. The best part is that you can create really nice formated
reports.
http://www.mysqlstudio.com/feature.php3
Jayne
- Original Message -
From: neal [EMAIL PROTECTED]
To: mySQL [EMAIL PROTECTED]
Sent: Friday,
On Fri, Aug 30, 2002 at 10:24:13PM -0700, Jefferson Cowart wrote:
I just downloaded 3.23.52 from the mysql servers and the version of
mysqlbinlog in there doesn't have the -d option you are talking about.
Yeah, looks like it's in 4.0.2 and later. I may have the patch still
floating around if
At 13:37 -0700 8/31/02, [EMAIL PROTECTED] wrote:
The 4.0.2 manual's mysqldump section says the mysqldump
variables that can be set are listed below, but I can't find them.
Anybody know where they are, or what they are?
Just run mysqldump --help and it will show a list.
Thanks
Peter
[filter
Yes, Redhat's 2.4.18 kernel running on a Redhat 7.2 install.
I was going to try compiling from source, except that MySQL AB seems to warn
against that sort of thing on the releases page (people experiencing data
corruption, etc.) and we also have a support contract with them which seems
to
Wrong Sorting in arabic alphabets
Hi,
This bug is for Arabic alphabets.
I am using mysql 32.23.52 under winxp
The error is :
When sorting a table ASC it puts the letter (mem
ãíã)
in the top.
The letter (mem ãíã) is the 24 alphabets
Example
1 ÌÑíÑ
here a file size limit in my sql
At 18:59 -0400 8/31/02, qlarry wrote:
here a file size limit in my sql
What?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hi everyone,
I am running a FreeBSD server with MySQL 3.23
I want to let my virtual users create/drop tables and limit the size of each
table, and also the number of tables they can create.
Can someone please tell me how I can do this?
Is it possible wit applications such as webmin, or
On Sat, Aug 31, 2002 at 09:58:58AM -0400, Michael Bacarella wrote:
We experienced a similar problem with 3.23.51 which went away
once we compiled from source. Assume this is Linux 2.4?
I've also had good luck with 3.23.51 built from source. I build on a
Debian testing box and run the server
Hey,
You can limit the size of the database by specifying a quota on the
directory created by MySQL for that database.
When you create a database, all MySQL does is create a directory under
the data directory for that database. You can then set a quota on that
directory using whatever tools
Hi all,
does anyone have any experience with running MySQL on Red Hat Linux as a
back end to a web application written in Cold Fusion under VERY heavy load?
We're talking hundreds of thousands of hits per day.
I'm curious about how well the Merant MySQL ODBC driver performs under such
extreme
Hello,
This is my 2nd post, not to sound pushy, just raising the urgency of my
dilemna. My table is crashing way to often (I'd like it to not crash at
all).
I'm not sure what to do, how to trouble shoot, and how to fix my problem. I
will post the structure of the table here, as well as the
Hi,
Perhaps try to upgrade first from 4.0.0 to 4.0.3 to see if the problem still
happens ? (many fixes have been introduced, especially on FT search)
Regards,
Jocelyn
- Original Message -
From: Karl J. Stubsjoen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 01, 2002
I've got a strange problem using VB to connect to a mysql database via ODBC.
The problem isn't with connecting, but rather with one particular control --
the datalist/combo control. In fact, the problem doesn't seem to have
anything to do with databases directly, BUT I figured that there is
Paul et al,
At 18:59 -0400 8/31/02, qlarry wrote:
here a file size limit in my sql
What?
I think that loosely should translate as Where is a file size limit in
MySQL which I would then interpret as Is there a file size limit in
MySQL.
All MyISAM tables are stored on the local file system
I am running version 3.23.51-log (built with -O3) on
FreeBSD-5.0-CURRENT on Alpha. InnoDB is on raw disk.
After a week of uptime it restarted by itself and the
message below was logged.
Looks like it was trying to allocate 4GB+0x1E bytes.
Machine has 2GB of physical memory + 1GB swap.
Database
At 5:19 +0200 9/1/02, David Lloyd wrote:
Paul et al,
At 18:59 -0400 8/31/02, qlarry wrote:
here a file size limit in my sql
What?
I think that loosely should translate as Where is a file size limit in
MySQL which I would then interpret as Is there a file size limit in
MySQL.
All MyISAM
Well I guess the first point to make is that you would not be so off topic
in the MyODBC list. I personally stay away from the data set of controls.
I stick to manually loading recordsets into boxes, and thus avoid problems
such as the one you point out. To do what you are doing, I would manually
-- Forwarded Message
From: John J. Rushford [EMAIL PROTECTED]
Date: Sun, 01 Sep 2002 00:04:08 -0600
To: [EMAIL PROTECTED]
Subject: Mysql 3.23.52 fails compile on OS X 10.2
Greetings,
Downloaded mysql 3.23.52 from the mysql web site and ran into compile
failures in the mysql client, the
42 matches
Mail list logo