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
fu
- 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
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 i
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 3
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 a
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 YEA
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 1
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 ap
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?
2)
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 postin
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 fi
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
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 quer
>> 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_connec
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 arguments
> 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 p
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
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,
Dear mysql ,
á¹Ð¹Ó¸ØáԨ International e-Business !
àÃÕ¹ÃÙéÇÔ¸Õ¡Ò÷ӧҹ ¸ØáԨ¹Ò¹ÒªÒµÔ º¹ Internet
àÃÕ¹ÃÙéá¼¹¡Ò÷ӧҹà¾ÔèÁÃÒÂä´é¾ÔàÈÉã¹áµèÅÐà´×͹
á¼¹·ÓÃÒÂä´éÍÂèÒ§¨ÃÔ§¨Ñ§áºº·Ó§Ò¹¹Í¡àÇÅÒ
17,000 ¶Ö§ 100,000 ºÒ·/à´×͹
àÇÅÒ·Õèµéͧãªé : 7-14 ªÁ./ÊÑ»´ÒËì
á¼¹·ÓÃÒÂä´éÍÂèÒ§¨ÃÔ§¨Ñ§áºº·Ó§Ò¹àµçÁàÇÅÒ
50,000
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
http://www.innodb.com/ib
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 - Powerful.
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!
> Furt
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!
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:
http://www.mysql.com/doc/en/
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 und
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 s
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]>
S
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 differ
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?!
-
Bef
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 y
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
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
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,
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 Message-
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 [ma
- 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
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 p
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?!
-
Be
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
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 complet
>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
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.
--
mysqlÄúºÃ:
È«¹ú¶À¼ÒÃâ·ÑÇÀ×¢. cn¶¥¼¶ÓòÃû £¡
±¶ÊܹØ×¢µÄÖйú¹ú¼Ò¶¥¼¶ÓòÃû(.CN), CNNIC½«ÔÚ2003Äê3ÔÂ17ÈÕ¿ª·ÅÖ±½ÓÒÔ.CN½áβµÄ¹úÄÚÓòÃû
Äþ²¨Íø»ùÈí¼þÓÐÏÞ¹«Ë¾ÏÖÔÚÍƳöÈ«¹ú¶À¼ÒÃâ·ÑÇÀ×¢»î¶¯,¸Ï¿ìÇÀ×¢ÄãÐÄÒÇÒѾõÄÓòÃû.
.CN¶¥¼¶ÓòÃûµÄÕýʽע²á¼Û¸ñΪ260Ôª/¸öÿÄê¡£
Äþ²¨Íø
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 cook
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 co
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*' .
R
Here is the source code:
Seleccione a localização para o download:Localização Principal";
if ($mirrors) {
echo " Mirrors";
$m=explode("»",$mirrors);
foreach ($m as $v) {
$m2=explode("!",$v);
echo "$m2[0]";
}
echo "Nota: Deve escolher o mirror mais próximo da sua localização,
para acelerar o dowloa
- 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 sever
ÈçÓÐÐËȤһ±ßÉÏÍøÒ»±ß׬Ǯ
Ç뻨ÉÙÉÙʱ¼ä¿´¿´ÕâƪÎÄÕ£¬ÕâÖ»»á»¨·ÑÄãºÜÉÙʱ¼ä¡£
1Сʱ0.6ÃÀÔ²£¬ÔÚ¼ÒÀïÉÏÍø¿ÉÒÔ²¹ÌùÉÏÍø·ÑÓã¡
ÍøÂç׬ǮÔÚ¹úÍâÒѾÏ൱Æձ飡 Ó¢ÓïÎÒ¿ÉΪ·Òë.
> ×¢²áÃâ·Ñ׬ȡÃÀ½ð
> http://www.cashfiesta.com/php/join.php?ref=airspace
> Ö»ÒªÔÚÏ߾ͼÆÊý£¬1Сʱ0.6ÃÀÔ²£¡¾ø¶ÔÕæʵ£¡£¡£¡£¡Ï£ÍûÄ
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 lcopen
50 matches
Mail list logo
