No. Because the WHERE condition would control both:
SUM(lcreceive.amount_us)
SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8
--- Christensen, Dave [EMAIL PROTECTED]
wrote: SELECT SUM(lcreceive.amount_us),
FROM lcopen, lcreceive
WHERE lcreceive.due_date current_date
AND
ÈçÓÐÐËȤһ±ßÉÏÍøÒ»±ß׬Ǯ
Ç뻨ÉÙÉÙʱ¼ä¿´¿´ÕâƪÎÄÕ£¬ÕâÖ»»á»¨·ÑÄãºÜÉÙʱ¼ä¡£
1Сʱ0.6ÃÀÔ²£¬ÔÚ¼ÒÀïÉÏÍø¿ÉÒÔ²¹ÌùÉÏÍø·ÑÓã¡
ÍøÂç׬ǮÔÚ¹úÍâÒѾÏ൱Æձ飡 Ó¢ÓïÎÒ¿ÉΪ·Òë.
×¢²áÃâ·Ñ׬ȡÃÀ½ð
http://www.cashfiesta.com/php/join.php?ref=airspace
- Original Message -
From: David Angela Ehmer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 04, 2003 11:00 PM
Subject: mysqldump ERROR 1064
Hi
I am having problems generating the mysqldump file. I have tried a range
of
options and carefully studied several
Here is the source code:
?
@MYSQL_CONNECT(localhost, nlopes, testing) or die(Erro 1);
@mysql_select_db(be);
$r=MYSQL_QUERY(SELECT n,u,m,h FROM d WHERE id='$id');
if (mysql_num_rows($r)==0) {
die (Erro);
} else {
$re=mysql_fetch_array($r, MYSQL_NUM);
$nome=$re[0];
$url=$re[1];
$mirrors=$re[2];
Hi,
As of Version 4.0.1 you can use the truncation operator * in boolean mode:
select firstname from contacts where match(firstname,lastname) against
('steff*' in boolean mode);
This will match steff , steffa, steffan, steffane, steffans
But of course not stef unless you use 'stef*' .
Hi,
I have a system running MySQL 3.23.41. I read many times about
InnoDB performance and that it is superior to the MyISAM one. I have a
table 'sessions' in a MyISAM format with about 20 milion records. Its
size is 2.5 GB; the index file is 1.1 GB. In mysql client I entered the
following
Hello Group,
Due to ever increasing traffic I'm converting my site into mod_perl and
quite honestly I'm confused about persistent DB connection and DB connection
pooling.. I know there is tons of info out there on the goggle groups and on
perl.apache.com, I also picked up Mod_Perl Developers
mysqlÄúºÃ:
È«¹ú¶À¼ÒÃâ·ÑÇÀ×¢. cn¶¥¼¶ÓòÃû £¡
±¶ÊܹØ×¢µÄÖйú¹ú¼Ò¶¥¼¶ÓòÃû(.CN), CNNIC½«ÔÚ2003Äê3ÔÂ17ÈÕ¿ª·ÅÖ±½ÓÒÔ.CN½áβµÄ¹úÄÚÓòÃû
Äþ²¨Íø»ùÈí¼þÓÐÏÞ¹«Ë¾ÏÖÔÚÍƳöÈ«¹ú¶À¼ÒÃâ·ÑÇÀ×¢»î¶¯,¸Ï¿ìÇÀ×¢ÄãÐÄÒÇÒѾõÄÓòÃû.
.CN¶¥¼¶ÓòÃûµÄÕýʽע²á¼Û¸ñΪ260Ôª/¸öÿÄê¡£
Hello,
I tried to drop a table with Mysql 4.0.1 alpha nt and I have encountered
the following problem:
ERROR : Error on delete of .'\camcomm.tmpge.MYI'
The problem persists. I don't know the reason of this error.
I ask if a new version of Mysql (the version 4.0.7 i s released) is better.
Description:
A SELECT statement fails if you have table aliases and use
table locking with the LOCK command
How-To-Repeat:
DROP TABLE IF EXISTS CK1;
CREATE TABLE CK1 (
ID INT UNSIGNED NOT NULL,
PRIMARY KEY(ID)
);
LOCK TABLES CK1
Hi MySQL team,
I'm not sure, if this is the right place for bug reports, so, if it
isn't, please forward this to those who are resposible. Running MySQL
4.0.7 on a Windows NT 5.2 RC2 machine and on a Windows NT 5.1 one as
well, I encoutered some bugs:
- After having set up both machines
Try replacing the following line...
@MYSQL_QUERY(UPDATE d SET h='$h' WHERE id='$id'); // this query doesn't
work
With...
$query = UPDATE d SET h='$h' WERE id='$id';
$queryr = mysql_query($query) or die(The sql statement does not execute);
if(mysql_affected_rows() !== 1)
{
die(The sql
I have multiple SQL files that create different tables.
Is there a way for me to create a single SQL file that will call these
other files?
Since I am using phpMyAdmin, I am assuming that call this file from
phpMyAdmin?!
-
Are you sure it would help? MySQL is damn fast at taking connections.
When we converted to mod_perl I made a mental note to switch
to persistent connections. It turns out that it still
ran fast enough even though every hit results in an RDBMS
connection. And at this point we're doing 5M of them
- Original Message -
From: Chris Faust [EMAIL PROTECTED]
To: MySql Mailing List [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 1:55 PM
Subject: mod_perl and mySql
For example I've read
a bunch of posts where people said to do pooling its only a matter of
doing your connect like $db
You mean overall? The move to mod_perl is more because the site is so perl
heavy, its perl that is driving the change more then anything else.
I just figure If I'm going to do it, I want to do as much of it as I can
:)..
Thanks
-Chris
-Original Message-
From: Michael Bacarella
We don't cache connections, either, and the connection overhead appears to
be trivial, connecting to a remote MySQL server over the local Ethernet.
50,000 to 100,000 Apache::ASP pages served per day, some with many rather
complex queries.
Tom Haapanen
[EMAIL PROTECTED]
-Original
At 7:55 -0500 1/5/03, Chris Faust wrote:
Hello Group,
Due to ever increasing traffic I'm converting my site into mod_perl and
quite honestly I'm confused about persistent DB connection and DB connection
pooling.. I know there is tons of info out there on the goggle groups and on
perl.apache.com,
At 14:45 +0100 1/5/03, [EMAIL PROTECTED] wrote:
Description:
A SELECT statement fails if you have table aliases and use
table locking with the LOCK command
This is not a bug. It's documented in the manual that you must lock
all the tables at once that you intend to use, *including* locking
Natale,
It looks like you are looking for some kind of audit trail..
It would show all the changes to the table data, right?
Sorry, I don't have an answer, but I am looking for some thing similar.
If I find something that falls into this category, I will try to post.
What I have seen in some
Am Sonntag, 5. Januar 2003 19:29 schrieb Paul DuBois:
At 14:45 +0100 1/5/03, [EMAIL PROTECTED] wrote:
Description:
A SELECT statement fails if you have table aliases and use
table locking with the LOCK command
This is not a bug. It's documented in the manual that you must
I have multiple SQL files that create different tables.
Is there a way for me to create a single SQL file that will call these
other files?
Since I am using phpMyAdmin, I am assuming that call this file from
phpMyAdmin?!
-
Hi!
I have php files and perl files that create multiple databases and move data
around as needed. . . is this what you mean? You could have many such
files if you wanted (as you mention below) but it would seem easier to set
up some sort of program flow so that under different conditions
Hi!
A second thought is you could issue an SQL command from phpMyAdmin's command
window such as Load Data or Load Data Infile (if you have the privs to do
so).
Cheers!
-warren
- Original Message -
From: Frank Peavy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent:
Warren,
Thank you for your prompt reply.
Actually, I have various ??.sql files that I can execute thru phpMyAdmin
and they all work, but on occasion, there is a need to run all the files at
once. So, I was wondering if I could create a file the would call these
other files and execute them in
Francesco,
ERROR : Error on delete of .'\camcomm.tmpge.MYI'
The problem persists. I don't know the reason of this error.
I ask if a new version of Mysql (the version 4.0.7 i s released) is
better.
Most probably. I had problems like that with 4.0.3 and 4.0.4, but not
yet with 4.0.7 (all under
Anton,
# Starting mysqld daemon with databases from /usr/local/var
030104 23:01:55 mysqld ended
This symptom shows when the privilege tables (i.e. the mysql database)
has not been installed. Under Unix/Linux, there's a script for this. You
can find details here:
Hi!
Sorry Frank, I don't have an example of this. . . however you might try
http://phpmyadmin.sourceforge.net/documentation/ and click on developers
where there are email addresses for the developers. You may find someone
who will have nice suggestions that will advance your project!
Cheers!
Alexander,
- After having set up both machines completely, I installed the Win32
binary distribution of MySQL 4.0.7-gamma. Although I did not upgrade
from an earlier version, the privileges tables still have the old
structure without the new columns introduced with MySQL 4.0.2-beta!
I installed mysql from rpm package on redhat linux 8.0
and it works fine, but next time i reboot the machine
/var/lib/mysql.sock gets deleated and mysql stops
working
PLEASE HELP ITS URGENT..
__
Do you Yahoo!?
Yahoo! Mail Plus -
Hi!
A user of InnoDB Hot Backup just reported a bug. He has 3 InnoDB log files,
each 1 GB in size.
A 32-bit integer overflow can cause InnoDB to write log in a wrong offset.
That can spoil InnoDB recovery.
If you have too big log files, please follow the instructions at
Dear mysql ,
á¹Ð¹Ó¸ØáԨ International e-Business !
àÃÕ¹ÃÙéÇÔ¸Õ¡Ò÷ӧҹ ¸ØáԨ¹Ò¹ÒªÒµÔ º¹ Internet
àÃÕ¹ÃÙéá¼¹¡Ò÷ӧҹà¾ÔèÁÃÒÂä´é¾ÔàÈÉã¹áµèÅÐà´×͹
á¼¹·ÓÃÒÂä´éÍÂèÒ§¨ÃÔ§¨Ñ§áºº·Ó§Ò¹¹Í¡àÇÅÒ
17,000 ¶Ö§ 100,000 ºÒ·/à´×͹
àÇÅÒ·Õèµéͧãªé : 7-14 ªÁ./ÊÑ»´ÒËì
á¼¹·ÓÃÒÂä´éÍÂèÒ§¨ÃÔ§¨Ñ§áºº·Ó§Ò¹àµçÁàÇÅÒ
Anyone know how to run batch queries in phpMyAdmin?
How is it done?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
In the last episode (Jan 05), Smart Guy said:
I installed mysql from rpm package on redhat linux 8.0
and it works fine, but next time i reboot the machine
/var/lib/mysql.sock gets deleated and mysql stops
working
Mysql creates /var/lib/mysql.sock when it starts up. Are you sure you
I have multiple SQL files that create different tables.
Is there a way for me to create a single SQL file that will
call these
other files?
Since I am using phpMyAdmin, I am assuming that call this file from
phpMyAdmin?!
Since phpMyAdmin is a HTTP interfase, I don't think it is
This is wierd. When I run make on mysql 3.23.54 (Source Distro), using
./configure --prefix=/usr/local/mysql, --oh, and I'm running Mandrake Linux
9.0--I always get this:
libmysql.c:1340: warning: passing arg 5 of 'gethostbyname_r' from
incompatible pointer type
libmysql.c:1340: to few
Glad to hear that about MPW; thanks.
Its the truth, those 2 books have really saved my butt more then once - so
it should be me thanking you!!.
Regarding use of persistent connections, I wonder if you really need
them. To give an example from another language, PHP offers
mysql_connect()
Hey everyone I just joined this group today with an error that has been
plaguing me for the past 2 weeks and I can't figure out what's wrong!!
What's happening is I'll start up my perl program and sometimes, for no
apparent reason, I will get the Lost Connection to MySQL Server while
executing
Hi,
I do not know if this is a bug or feature.
We installed MySQL on a test machine with many partitions. The
start of the service crashed with error 1067 if Windows was not
installed on drive C.
The only way to get it up and running was to place the file
'my.cnf' in the root of drive C.
It is
At 9:52 +0800 1/6/03, oceanare pte ltd wrote:
Hi,
I do not know if this is a bug or feature.
One of the screens that the installer presents tells you that if you
want to use a different location than the default of the C: drive,
you'll need to put something like this in your my.cnf or my.ini
Dear all,
How can I change the year of the date field using sql statement?
It means something like:
update table1 set year(f1) = '2002' where year(f1) = '2003';
Thanks for anyone's help.
Regards,
Hakkan Lui
-
Before
Hello,
I am trying to write a process to optimize several tables in a database
by using the OPTIMIZE TABLE command in a query. I have a couple of
questions that I can't get an answer to in the documentation:
1) Do I: Query.ExecSQL or Query.Open to execute the OPTIMIZE TABLE
TableName command?
Good day,
I have read on http://www.mysql.com about the press releases asking all
3.23 users to upgrade to the latest stable version.
How can I do this without uninstalling my current version? I tried to
look for some documentation regarding this or patches but was unable to
find any.
I would
I don't think there is a way to do that. Unless some one says there is(and
tells us how to do it), I guess your only option is to write a script to do
that.
Regards,
Bhavin.
- Original Message -
From: Hakkan Lui [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, January 05, 2003 10:12
At 22:56 -0500 1/5/03, Bhavin Vyas wrote:
I don't think there is a way to do that. Unless some one says there is(and
tells us how to do it), I guess your only option is to write a script to do
that.
Here's one way:
UPDATE table1
SET f1 = CONCAT('2002','-',MONTH(f1),'-',DAYOFMONTH(f1))
WHERE
Good day,
I have read on http://www.mysql.com about the press releases asking all
3.23 users to upgrade to the latest stable version.
How can I do this without uninstalling my current version? I tried to
look for some documentation regarding this or patches but was unable to
find any.
I would
I don't' know if it was right to do, but I just downloaded version
3.23.54a and compiled/installed it
Best Regards, Anton
-Original Message-
From: Peter Teo [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 05, 2003 8:08 PM
To: [EMAIL PROTECTED]
Subject: Upgrading from MySQL 3.23.52 to
Hakkan Lui wrote:
Dear all,
How can I change the year of the date field using sql statement?
It means something like:
update table1 set year(f1) = '2002' where year(f1) = '2003';
If you have a field for _just_ the year, you can use the above statement.
If you have the year embedded in a
- Original Message -
From: Peter Teo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 06, 2003 5:08 AM
Subject: Upgrading from MySQL 3.23.52 to 3.23.54
Good day,
I have read on http://www.mysql.com about the press releases
asking all 3.23 users to upgrade to the latest
when I try to compile the source distro, i get:
sql_udf.cc:57:19: dlfcn.h: No such file or directory
sql_udf.cc: In function `void init_syms(udf_func*)':
sql_udf.cc:88: `dlsym' undeclared (first use this function)
sql_udf.cc:88: (Each undeclared identifier is reported only once for
each
50 matches
Mail list logo