Sorry for the intrusion...
EasySQL is a meta-language for MySQL that provides a more sophisticated environment
for pure-SQL coding than MySQL provides on its own, eliminating the need for external
languages such as Perl in many instances.
The first version of EasySQL features iteration across
Hi,
AFAIK, date is *not* a reserved keyword, not need to backtick it :)
Regards,
Jocelyn Fournier
www.presence-pc.com
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: fgmmoribe [EMAIL PROTECTED]
Cc: mysql [EMAIL PROTECTED]
Sent: Tuesday, July 27, 2004 7:11 AM
Just recently post a problem on how can i see all max(dateposted) on
all of my records by doing this..
select datacount,office,filename,status, max(dateposted) from dCOPY
group by office;
now, i was wondering if i can use max() on update to update all my
current records only..
i tried this:
mysql update dCOPY set status = '1' where dateposted = max(dateposted);
ERROR : Invalid use of group function
mysql
not working.. :(
o btw.. i just opened another email topic, so it will be divided by
topic already.
thanks
On Tue, 27 Jul 2004 08:04:01 +0100, Lester Caine [EMAIL PROTECTED]
Hi!
That method will not work. InnoDB must be quiet long enough so that it has
time to flush all the contents of the buffer pool to the data files.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB
Hello,
We're proud to announce the release of the microOLAP Database Designer
for MySQL - visual development system intended for database design,
modeling, creation, modification, reverse engineering, and
import/export data from/to various data sources.
Direct download link:
Hello,
I'll try to explain correctly my idea.
I need to develop a on-line sale's website. For that, I have some dough's on how to
create the table basket.
Client
- IDclie (PK)
- ...
Produts
- IDprod (PK)
- ...
Basket
- IDbask (PK)
- IDprod (FK)
- IDClie (FK)
- qt
- date
Sale
-
If you want to know how many sales were made to a give client (e.g. where IDclie =
99), this should see you right:
SELECT count(*)
FROM Sale, Basket
WHERE Sale.idbask = Basket.IDbask
AND Basket.IDClie = 99
Paul Vincent
DBA
University of Central England
-Original Message-
From:
In article [EMAIL PROTECTED],
Adaikalavan Ramasamy [EMAIL PROTECTED] writes:
This seems more like the solution I want. I am using perl-DBI and when
there is an error (i.e. duplicate insert), the rest of the scrip it not
executed. But this is gives me the following error. What am I doing
wrong
In article [EMAIL PROTECTED],
Michael Stassen [EMAIL PROTECTED] writes:
Richard Mixon (qwest) wrote:
I run some mysql command files (just SQL statements in a file I read
from standard input) and need to place some annotiations/comments in the
output.
If I place standard SQL comments (--
§ÃENMï-ÒêD±Ì~~Vþá´¶|OØ[¹a¦ÓÙ°u¦eþÂh¸wú\?©¿oEú»±Gþ-M¡±0
Ôü\£·¿G%;,\RºÕ!wø~iÃ]ûy´òTØÀ¸Y¤dh3£¡vÛöz£hÒÕÚ¶{q$L2þ)³Û4L÷ýW_ézõ]÷®Þ
Z¨
9É)òP£bÍm¹ùôܾ[æU®ahq¦)wÇÆÁJí¶ÃoÞø*ìB»JÐ_ïbs±êê¯Ó
v³Êiºþ¶·ÎÇcæsEíµÛCFcÎÊ9¥µ*Õ!3¤[#ä«àgwgÎ .4bô`#,}úxÊùN\òh
ì*
Hd _ʽ âJO:Ë
[snip]
Debian is our first choice, but on the Debian/AMD64 howto, it is stated
that
the port is still in beta stage. Does anyone have experiences with
debian/amd64 + mysql? I would love to know if mysql will run on it before
giving it a try..
[snip]
AFAIK, Debian is now voting on whether to
Paul DuBois wrote:
At 8:20 -0500 7/26/04, Victor Pendleton wrote:
Have you tried using the last insert id function instead?
SET @backup_id = last_insert_id()
That'll give him the same result. I suspect the problem might be
that user variables are not replicated well in MySQL 4.0.x.
Yes, same
Hi
I'm using mysqldump in windows
and importing the tables in unix
the tables are all dumped in lowercase although they had mixed case... can i tell
mysqldump to dump with case sensitive on windows?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi list,
At the moment we're using MySQL 4.0.20 and PHP 4.3.8 to build a new website
frame work which should support various languages and various browser
encodings. Upgrading to MySQL 4.1.x and PHP 5.x is not possible in the near
future, because a number of webservers and a couple of MySQL
I'm having trouble with character set changes on 4.0.18.
I have a database that contains text in multiple languages and I need to
be able to select the character set on the fly.
For some reason SET CHARACTER SET x always returns Unknown character
set: 'x'. The only exception to this is SET
Hi,
I have designed a application (written in visual basic) to visualize
projects in a treeview and to attach all kinds of information to those
treenodes (for example hours used, budget avail, pictures of
manufactoring parts/ bought-out parts etc).
After using microsoft access for a short time,
Hi,
How can I set a timeout in MySQL (mysqld-nt) not to run a query more than X
minutes? some of queries (when I am testing), make the CPU 100% busy for a
long time and I cannot kill the process, even when I go to winmysqladmin and
under process I kill the process but MySQL doesn't care.
thanks,
Ugly, but you could try using a temp table to store the last_insert_id().
-Original Message-
From: Philippe Poelvoorde
To: '[EMAIL PROTECTED] '
Sent: 7/27/04 5:54 AM
Subject: Re: Replication script pb
Paul DuBois wrote:
At 8:20 -0500 7/26/04, Victor Pendleton wrote:
Have you tried
Hi,
I've installed MySQL-4.0.20 on Linux Fedora 1 as rpm from the download
area of www.mysql.com. The server starts and runs.
But I cannot configure some options in /etc/my.cnf:
- with 'err-log' the server doesn't start
- 'pid-file' and 'log-bin' will be ignored
- some other I must try in the
You can not limit connections per minute but you can limit connections per
hour for a user. Can the process not be stopped during your testing phase?
Can the queries not be optimized?
-Original Message-
From: Mojtaba Faridzad
To: [EMAIL PROTECTED]
Sent: 7/27/04 6:52 AM
Subject: how to set
At 11:54 +0100 7/27/04, Philippe Poelvoorde wrote:
Paul DuBois wrote:
At 8:20 -0500 7/26/04, Victor Pendleton wrote:
Have you tried using the last insert id function instead?
SET @backup_id = last_insert_id()
That'll give him the same result. I suspect the problem might be
that user variables
You may need to user lower_case_names = 0 to turn off the case sensitivity
on the unix system since windows is not case sensitive.
-Original Message-
From: Ben David, Tomer
To: [EMAIL PROTECTED]
Sent: 7/27/04 5:56 AM
Subject: dump case sensitive windows
Hi
I'm using mysqldump in windows
At 12:34 +0100 7/27/04, Chris Wright wrote:
I'm having trouble with character set changes on 4.0.18.
I have a database that contains text in multiple languages and I need to
be able to select the character set on the fly.
For some reason SET CHARACTER SET x always returns Unknown character
set:
Hi,
I was able to solve this by calling sync command, as my previous mail say.
Do you mean to say this will not work regardless of the whether we sync or not?? which
implies binary backup/restore for innodb is impossible?? We actually started with
mysqldump for backup, but that was slow when we
Hi!
sync will not help.
You can run SHOW INNODB STATUS\G to monitor when InnoDB has flushed its
buffer pool.
Best regards,
Heikki
Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
To get the one record with the MAX() value in a field, I would do:
SELECT @maxcod:=max(cod) from #temp;
SELECT * from #temp where cod = @maxcod;
To get all of the records with the max(cod) value for each idtable value,
I would use a temp table:
create temporary table tmpMax
SELECT idtable,
Thanks Victor! when a process is running, I cannot stop it. before finding
the optimized query, I may run some queries which stop server to give the
service to the other users.
usually I find slow query when I have LEFT JOIN on a big table. I try not to
use left join by temporary tables or by
Using MySQL: 4.23.46
The select query below returns a grouped list of all featured artists. Their images
are listed in a random order within each artist group.
Is it possible to still return *all* featured artists (there are 6) but only a random
selection of no greater than 2 images from
Using MySQL: 3.23.46 (Correction)
The select query below returns a grouped list of all featured artists. Their images
are listed in a random order within each artist group.
Is it possible to still return *all* featured artists (there are 6) but only a random
selection of no greater than 2
Here's how I handle these situations. If I need all of the data from the
row that contains the maximum of an unindexed column:
SELECT @maxval := MAX(column_name) FROM tablename;
SELECT * FROM tablename WHERE column_name = @maxval;
For the same thing but for an indexed column
SELECT * FROM
In article [EMAIL PROTECTED],
Sp.Raja [EMAIL PROTECTED] writes:
Hi,
I was able to solve this by calling sync command, as my previous mail say.
Do you mean to say this will not work regardless of the whether we
sync or not??
If it happens to work, then only by incident. I wouldn't rely on
Jigal van Hemert [EMAIL PROTECTED] wrote:
At the moment we're using MySQL 4.0.20 and PHP 4.3.8 to build a new website
frame work which should support various languages and various browser
encodings. Upgrading to MySQL 4.1.x and PHP 5.x is not possible in the near
future, because a number of
bad corn [EMAIL PROTECTED] wrote:
Recently our company has purchased a dual amd64 opteron machine for mysql
server purpose.
Whatever Linux you choose please better run MySQL officialy built binaries. Due
to some known glibc/gcc issues the officially built binary performs better that
custom
Shannon R. [EMAIL PROTECTED] wrote:
i'll be moving from a RedHat server to a Debian server very soon. despite the
different linux distributions, is it ok to transfer my entire mysql database by just
copying everything in /var/lib/mysql of the RedHat system to the Debian system? has
anyone
[snip]
| SQLExpress is not MSDE, it looks like it though. SQLExpress
| has a 4Gb limit/database and I don't recall a user limit, but a
| concurrent-load limit of 5. That is, many can connect, but only
| 5 concurrent batches (select/insert/script) can be ran at the
| same time. This is
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
Michael Stassen [EMAIL PROTECTED] writes:
Richard Mixon (qwest) wrote:
I run some mysql command files (just SQL statements in a file I read
from standard input) and need to place some annotiations/comments
in the output. If I place standard
But I cannot configure some options in /etc/my.cnf:
- with 'err-log' the server doesn't start
- 'pid-file' and 'log-bin' will be ignored
sorry, it was a mistake of me: I'd used an option group [safe_mysqld]
instead of [mysqld_safe]
perhaps the starting procedure should inform me that there is
Thanks for your replies.
Now I have three ways to go
1. replication
2. innodb hot backup tool
3. Make sure that no one is writing in to the database and start backup when
modified db pages in BUFFER POOL AND MEMORY becomes zero
#FLUSH TABLES WITH READ LOCK
still_to_flush=1
I feed the table with :
INSERT INTO table ( SELECT @backup_id, col1. col2 FROM table_to_backup)
How can i do with a temp table ?
Victor Pendleton wrote:
Ugly, but you could try using a temp table to store the last_insert_id().
-Original Message-
From: Philippe Poelvoorde
To: '[EMAIL
Hello,
currently I recive mails from [EMAIL PROTECTED] that say that I have to
validate my email at Spamcease. Looking at the mail header mail seems to
come from tgpnexus.com?
Anybody else getting this type of emails?
Alexander Newald
--
MySQL General Mailing List
For list archives:
This was just a suggestion to store the insert id
TRUNCATE TABLE table_name;
...
insert into insert_id (insert_id) select last_insert_id();
...
insert into new_table
select t.*, i.insert_id
from table1 t, insert_id i
where table1 condition is met
-Original Message-
From: Philippe
On Tuesday 27 July 2004 16:00, Alexander Newald might have typed:
Hello,
currently I recive mails from [EMAIL PROTECTED] that say that I have to
validate my email at Spamcease. Looking at the mail header mail seems to
come from tgpnexus.com?
Anybody else getting this type of emails?
Yes,
You're absolutely right, date is not a reserved word. Don't know what I was
thinking.
Michael
Jocelyn Fournier wrote:
Hi,
AFAIK, date is *not* a reserved keyword, not need to backtick it :)
Regards,
Jocelyn Fournier
www.presence-pc.com
- Original Message -
From: Michael Stassen
Hi Richard,
not exactly sure what you want but try using \G at the end of the select
statements.
Also try using UNION.
e.g.
select Put your comment here, UNION select field1, field2 from table1
group by field 1 \G
You may get something that will work for you by messing with these
options
I got 5 of them, one for the list and one for each reciepient I CC'ed,
including 2 'from' a recipient I posted to twice. All timestamped 9:40
AM. Looks like a s[c/p]am to me.
On Tue, 2004-07-27 at 11:00, Alexander Newald wrote:
Hello,
currently I recive mails from [EMAIL PROTECTED] that say
Hi,
that makes things clear, I'll try with that.
Thanks !
Victor Pendleton wrote:
This was just a suggestion to store the insert id
TRUNCATE TABLE table_name;
..
insert into insert_id (insert_id) select last_insert_id();
..
insert into new_table
select t.*, i.insert_id
from table1 t, insert_id i
Richard Mixon (qwest) wrote:
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
Michael Stassen [EMAIL PROTECTED] writes:
Richard Mixon (qwest) wrote:
I run some mysql command files (just SQL statements in a file I read
from standard input) and need to place some annotiations/comments
in the
I would like to do something like this in the mysql client
Select CourseId
Into @CourseId
From Course
Where CourseCd='ENGL';
I also tried
@CourseId = select CourseId from Course where CourseCd = 'ENGL';
Neither syntax works. So I am wondering if there is a way to assign
values using SQL in
One more thought: Your mention of echo jogged my memory. You can use SYSTEM
to pass what follows to the system and display the result. So,
SYSTEM echo ## The following output should only contain two rows.;
results in
## The following output should only contain two rows.
assuming echo is a
You have the wrong syntax. You need
SELECT @CourseId:= CourseId FROM Course WHERE CourseId='ENGL';
See the manual http://dev.mysql.com/doc/mysql/en/Variables.html for more.
Michael
Boyd E. Hemphill wrote:
I would like to do something like this in the mysql client
Select CourseId
Into @CourseId
Hi,
I have installed mysql 4.1.3-beta and using the mysql-connector-java-3.1.3-beta.But
the database is not getting connected.
Has somebody tried this ? or Do someone know which connector is compatible with mysql
4.1.3 beta
-
Do you Yahoo!?
I'm using 4.0.20. System is a mysql client command (i.e., not SQL). See
http://dev.mysql.com/doc/mysql/en/mysql_Commands.html for the list of
mysql client commands, or enter 'help' or '?' at the mysql prompt.
Michael
Markus Grossrieder wrote:
Michael,
which version are you using ? I didn't
Michael,
Great idea, I can get it to work on SuSE Linux (SLES8 for AMD64) just
fine:
mysql SYSTEM echo Some comments ;
Some comments
But on Windows XP (where my user is running that needs this function):
mysql SYSTEM echo Some comments ;
--
SYSTEM echo Some comments
Michael,
which version are you using ? I didn't find SYSTEM in the manual ...
Thanks, Markus
- Original Message -
From: Michael Stassen [EMAIL PROTECTED]
To: Richard Mixon (qwest) [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 27, 2004 6:09 PM
Subject: Re: How to show
Hi,
I got them too. A few days ago.
I bounced the msg to spamcop directly.
No matter...
If I were a bettin man, and Ive been known to partake
from time to time...I'd guess that there is a harvester
address in the list.
That would be one guess.
M i l e s
+++
President
Rodney,
Did you EVER get a response to your question ?
Im keenly interested to know the answer.
M i l e s
+++
President Toolbox Architect
MagicMiles Software
(413) 374 - 5161
PO Box 414, Northampton, MA 01060
http://www.magicmiles.com/
[EMAIL PROTECTED]
aim/yahoo/msn:
Hello,
I'm running a development build of 4.1.3 and trying to set up of chain
of replication servers. The first level of replication works
beautifully but every effort to establish slaves on that first slave
have been met with failure.
here is the setup (log-bin is enabled on all 3
[EMAIL PROTECTED] wrote:
Hi Richard,
not exactly sure what you want but try using \G at the end of
the select
statements.
Also try using UNION.
e.g.
select Put your comment here, UNION select field1, field2
from table1
group by field 1 \G
You may get something that will work for you
could someone please tell me which versions of mysql support SSL
connections for both clients and replication slaves?
thank you.
--
- michael dykman
- [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Sorry me again! I haven't had any success with this thread :( But could
someone at least tell me the best way to debug this please? Are there any
options I can provide to increase the logging detail?
Thanks,
JS.
Does anyone know what goes on (system wise) during the CREATE INDEX ? I can
see
At 14:31 -0400 7/27/04, Michael Dykman wrote:
Hello,
I'm running a development build of 4.1.3 and trying to set up of chain
of replication servers. The first level of replication works
beautifully but every effort to establish slaves on that first slave
have been met with failure.
here is
I have a webapp that runs from a slave (read-only) database. Sometimes the
slave database is unable to connect to the master and the data becomes
stale. Is there a way to query out the time of last replication (or the
time elapsed since last replication) so that I can warn the user of the
Gerald Taylor wrote:
I totally recommend Paul Dubois's book.
Excellent book I own the first edition.
I bet the second edition is just
as good and more up to date.
Paul DuBois wrote:
At 1:55 +0200 7/26/04, Schalk Neethling wrote:
Can anyone suggest o great book to learn MySQL inside out? I am
Its not documented in my version 4.0.18 manual on Windows XP either. I
checked the Linux machine but cannot seem to find the manual.html
file.
The SYSTEM command DOES work in 4.0.18 on SuSE Linux, DOES NOT work on
4.0.18 under Windows.
- Richard
-Original Message-
From: Markus
First, I should point out that I've never used mysql on Windows.
The manual makes no mention that I can see of system not being supported on
the Windows mysql client. On the other hand, Windows is so different that I
wouldn't be surprised if system is not supported. A simple test would be to
Hi all,
I am using MySQL ver. 4.1.3-beta on Windows 2000 pro and I found that,
whenever i try to export data using the into outfile clause of the select
command the server hangs and i need to restart the service. Has anyone faced
the same problem, and if it is, how have you resolve it?
I
Hi folks,
Just installed MySQL 4 on my Fedora Core 2 box (that didn't have any mysql on
it initially.) Three questions.
I'm reading through the doc (gasp!) on the mysql.com site, specifically, 2.4
Unix Post Installation Procedures:
http://dev.mysql.com/doc/mysql/en/Unix_post-installation.html
Whil Hentzen wrote:
Hi folks,
Just installed MySQL 4 on my Fedora Core 2 box (that didn't have any mysql on
it initially.) Three questions.
I'm reading through the doc (gasp!) on the mysql.com site, specifically, 2.4
Unix Post Installation Procedures:
I'm having a little bit of a trouble with the use of the SQL function...
What I have here is a webpage that show the row of data, the web user
get to click on the field to sort the row by the field name. So, when I
use order by char(field_name), the data doesn't turned out right in
alpha-numeric
We've got a really high-load MySQL server and are planning to get a new server.
Has anyone seen tests comparing performance of MySQL on AMD64 versus Xeon CPUs?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Miles Keaton wrote:
We've got a really high-load MySQL server and are planning to get a
new server.
Has anyone seen tests comparing performance of MySQL on AMD64
versus Xeon CPUs?
These tests are about a year old, but showed the Opteron was usually 50
to 100 percent faster in most often run
I tested both platforms on a SAN every day for 26 days 18 hours a day
straight.
I came to this conclusion. The kernel does make a huge difference in the two
platforms. Especially on the chipset patches and the disk IO subsystem.
If you go with AMD do not use 2.6.7 or ext3. EXT3 has a bug in it
I've checked the archives but still need help on this.
I installed MySQL (Standard), production version 4.0.20d on a Win2K (Service
Pack 4) system, using the binary install. Also, I initiated the install
while logged onto Win2k with administrator-level privileges. After the
install completed the
mysql Digest of: thread107823
Re: Verizon.net auto
107823 by: Salada, Duncan
107826 by: Jay Blanchard
107831 by: Joseph Bueno
107836 by: Svensson, B.A.T. (HKG)
Administrivia:
--- Administrative commands for the mysql list ---
I can handle administrative
Hi, i was able to try your suggestion. But error seems to show up when
updating already...
+---++--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---++--+-+-+---+
|
Is anyone else getting this? Is this for real or someone sending SPAM
or viruses?
Thanks - Richard
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 27, 2004 8:21 PM
To: [EMAIL PROTECTED]
Subject: IMPORTANT: Please Verify Your Message
Hello [EMAIL
At 15:57 -0400 7/27/04, Michael Stassen wrote:
First, I should point out that I've never used mysql on Windows.
The manual makes no mention that I can see of system not being
supported on the Windows mysql client. On the other hand, Windows
is so different that I
Hi, may I know of the current MySQL python library supports MySQL cluster or not?
Regards,
- Wong
At 15:35 -0500 7/27/04, Whil Hentzen wrote:
Hi folks,
Just installed MySQL 4 on my Fedora Core 2 box (that didn't have any mysql on
it initially.) Three questions.
I'm reading through the doc (gasp!) on the mysql.com site, specifically, 2.4
Unix Post Installation Procedures:
Paul DuBois wrote:
At 15:57 -0400 7/27/04, Michael Stassen wrote:
First, I should point out that I've never used mysql on Windows.
The manual makes no mention that I can see of system not being
supported on the Windows mysql client. On the other hand, Windows is
so different that I
Hi,
I use MySQL 4.0.20 on my replication (slave) server. I noticed that when
I use kernel 2.4.26 SMP, the slave runs very slow (it can't catch up
with master). My machine has dual CPUs with HT. But if I change to
kernel 2.6.6 SMP, everything just runs fine, the slave can catch up
easily with
82 matches
Mail list logo