date:20010220

And you tried the web link that appears at the bottom of every e-mail as
well

- Original Message -
From: "Salvador Zarzo" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 20, 2001 17:17
Subject: Problem with list

 Hi list.

 I have tried unsubscribe from this list by sending a message
 to

 [EMAIL PROTECTED]

 but, it don't works.

 If there are someone of list managers reading this list. Please,
 unsubscribe me.

 Bye.

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: BigInt with primary key


Firstly, why do you have quotes around the numbers? I thought you said it
was bigint, not a string?

Secondly, if you are going reply/repost to the list, could you please
simplify it a bit.  Provide field names, etc.  Your insert is very difficult
to figure out especially with unmatched brackets, which doesn't make sense
at all.  I'm surprised the insert even works.

Thirdly, have you tried checktable/myisamcheck?

- Original Message -
From: "chchen" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 20, 2001 18:56
Subject: BigInt with primary key


hi all

i use mysql-3.23.32

my project need to use unsigned Bigint as a primary key.
but when i insert many rows in this table.
sometimes it will error with Duplicate such like

insert into Table
values('9231852172526977164',0,0,52056,0,0,0,0,0,52056,0,0,0,0,0,0,0,11,0,'1
84000','184000',1),'9231898557453533324',0,0,5532,0,0,0,0,0,5532,0,0,0,0,0,0
,0,11,0,'184000','184000',1),'9230422383529723532',147,0,0,0,0,0,0,0,147,0,0
,0,0,0,0,0,91,0,'184000','184000',1) query failed
Duplicate entry '9231898557453533324' for key 1

but actually if i select * from Table where a='9231898557453533324'

it can't find anything.what's wrong with this, bug?

p.s. unsigned Bigint should be from 0 to 18446744073709551615, so
'9231898557453533324' is included in it, right?

regards
Allen






-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

problem with LEFT JOIN function

2001-02-20 Thread SixK


Hello,

Can any of you explain me why, when i do this request :

select count(*)
from OBJET as t1 left join COLLECTION as t2
ON t1.numColl = t2.numColl
where t2.numSupp = 0;

I've got an error saying :  Field numObj not found
note that numObj is the Key of table OBJET...

Thank's

-- 
Best regards,
 SixK  mailto:[EMAIL PROTECTED]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

New sub-version of Win32 version of mysqlgui

2001-02-20 Thread Sinisa Milivojevic




Hi!

Several reported Win32 specific bugs have been fixed and new ZIP file
has been made available on the mysqlgui site.

All those that use Win32 version of mysqlgui are urged to download and
install it.

As I am now VMWare-enabled, please forward me if you hit at some  new
bugs.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: NEW CHINA {YAHOO*} STOCK PICK!

2001-02-20 Thread Freaked Personality


Leave the mailing list alone please.
If not I'll feel forced to ask all the kind hackers here including myself
to track your ass down and make sure you have some expenses.
I'm really really sorry for taking up your time and ya better be sorry ya
took mine.

If you want to mail potential customers setup your own friggin' maillist
and have them subscribe.
And uhm don't hassle people thru other mailinglist, ppl here won't care
bout your stuff.

Kind regards,

Ferry van Steen


On Tue, 20 Feb 2001, [EMAIL PROTECTED] wrote:

 NEW CHINA {"YAHOO"*} STOCK PICK!
 
 FOR IMMEDIATE RELEASE:
 
 THE PENNY STOCK PICKER OFFERS THE HOTTEST INTERNET INVESTMENT OPPORTUNITIES! 
 
 Take Advantage of our Expert's SPECIAL MARKET UPDATES!
 
 Find a stock worth $.30 cents that could be worth $10.00 in just six months - and 
ASK OUR EXPERTS questions with NO obligation!
 
 Join over 150,000 PENNY STOCK PICKER NEWSLETTER Subscribers now SPECIALIZING in 
WORLDWIDE INVESTMENT OPPORTUNITIES! Your first six months trial is absolutely FREE!! 
 
 Visit http://chwt.tripod.com/  NOW to subscribe and receive your FREE copy of the 
The Penny Stock Picker  "THE HEYSEK REPORT" (A FREE $20.00 Value - Yours FREE)!
 
 ***BONUS STOCK PICK - Featuring this Week: "THE HEYSEK REPORT".
 
 This week's Penny Stock Picker Report for your investment consideration is 
 China World Trade Corp ("CHWT": NASDAQ OTCBB).
 CWTC is the first business-to-business portal published in both the Chinese and 
English languages.
 
 China and Asia are expected to be the next boomtown of the Internet World! With 
Broadband Wireless Internet coming fast, China's Billion plus population will explode 
onto the Internet. Just as the US exploded with Internet usage over the last five 
years, Asia will be next. 
 
 20% of the Internet Population will be Chinese by 2003!
 
 * CHWT has entered a co-operative joint-venture, for a period of 20 years with the 
Beijing Wanlong Economic Consultancy Corporation Ltd. This company is a fully owned 
subsidiary of World Trade Center Beijing (WTCB).
 * CHWT has signed a Memorandum of Agreement to take a majority stake in 
Market188.com, a market leader in B2B facilitation of China domestic wholesale trades.
 * Due to BWTCC's affiliation to the World Trade Center Association, it has access to 
over 600,000 members of the WTCA from over 300 cities in 100 countries around the 
world. These members are business people and most of them have strong desire to trade 
with China.
 
 "CHWT" IS A MUST SEE STOCK FOR YOUR EVALUATION! 
 PLUS Receive absolutely FREE "The Heysek Report". Read it FREE and search in the 
areas that inform investors and potential investors about overlooked and 
underfollowed public companies. We believe that investment programs focused on 
specific stocks will ultimately produce above average rates of returns.  So, how does 
one go about finding such overlooked companies?
 
 Read "THE HEYSEK REPORT" and Visit http://chwt.tripod.com/ Now!
 
 
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail 
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

global search and replace

2001-02-20 Thread Matt Davis


I have an MySQL table in which one of the fields is a list of different
catergorys. I want to change that catergory name to some thing else however
it appears in my table just over 900 times. Is there any way I can do some
sort of glabal search and replace  in My SQL?

Mat


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: New sub-version of Win32 version of mysqlgui

2001-02-20 Thread Sinisa Milivojevic


Joris Lambrecht writes:
  to wich version are you referring ? 3.23.33 ?
  


No, mysqlgui 1.7.4.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysqldump problems too


jaco wrote:
 
 I'm having problems with mysqldump too.
 
 I'm trying it on a Suse Linux 6.2 system, from the /usr/bin directory as root, 
typing ./mysqldump --all-databases  backup.sql
 
 as is explained on  http://www.mysql.com/doc/m/y/mysqldump.html
 
 The response is :   ./mysqldump: unrecognized option `--all-databases'
 
 I tried almost all different permutations of the --all-databases option, what am I 
doing wrong?
 
 Thanks in advance
 
 Jaco

Your version is probably so old that it does not yet support
--all-databases.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: New sub-version of Win32 version of mysqlgui

2001-02-20 Thread Joris Lambrecht


oh god, i think i'm in need of a break sorry 'bout that

-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 2:45 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: New sub-version of Win32 version of mysqlgui


Joris Lambrecht writes:
  to wich version are you referring ? 3.23.33 ?
  


No, mysqlgui 1.7.4.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: BigInt with primary key

2001-02-20 Thread chchen


First, i am really sorry about that.

my fields is quite simple.
CREATE TABLE TEST (
   A bigint(20) unsigned DEFAULT '0' NOT NULL,
   C0 bigint(20) unsigned DEFAULT '0' NOT NULL,
   C1 bigint(20) unsigned DEFAULT '0' NOT NULL,
   C2 bigint(20) unsigned DEFAULT '0' NOT NULL,
   C3 bigint(20) unsigned DEFAULT '0' NOT NULL,
   C4 bigint(20) unsigned DEFAULT '0' NOT NULL,
   C5 bigint(20) unsigned DEFAULT '0' NOT NULL,
   C6 bigint(20) unsigned DEFAULT '0' NOT NULL,
   C7 bigint(20) unsigned DEFAULT '0' NOT NULL,
   S1 bigint(20) unsigned DEFAULT '0' NOT NULL,
   S2 bigint(20) unsigned DEFAULT '0' NOT NULL,
   S3 bigint(20) unsigned DEFAULT '0' NOT NULL,
   S4 bigint(20) unsigned DEFAULT '0' NOT NULL,
   S5 bigint(20) unsigned DEFAULT '0' NOT NULL,
   S6 bigint(20) unsigned DEFAULT '0' NOT NULL,
   S7 bigint(20) unsigned DEFAULT '0' NOT NULL,
   Total bigint(20) unsigned DEFAULT '0' NOT NULL,
   sLocation smallint(5) DEFAULT '0' NOT NULL,
   dLocation smallint(5) DEFAULT '0' NOT NULL,
   FirstTime time DEFAULT '00:00:00' NOT NULL,
   LastTime time DEFAULT '00:00:00' NOT NULL,
   Times smallint(5) unsigned DEFAULT '0' NOT NULL,
   PRIMARY KEY (A),
   KEY dLocation (dLocation),
   KEY Total (Total),
   KEY Times (Times)
);

and actually what i use is bigint, it have quotes is because i try many possible reason
still can't find where the problem is, so i add quotes to test if it can 
work.but
unfortunately it still have problem.

and the third question. yes, when problem occur. i thought this first.
but seems not ...isamchk -r, or -f even -c or -e can't find any error.
then, i try delete the table and insert again.

but it still will occur this error.

I summary my question. that is
my table use Bigint as a primary key, i insert/update this table from empty.
then after serveral rows. sometimes it will tell me Duplicate key when insert.
but i can find that row in the table by select.




- Original Message -
Firstly, why do you have quotes around the numbers? I thought you said it
was bigint, not a string?

Secondly, if you are going reply/repost to the list, could you please
simplify it a bit.  Provide field names, etc.  Your insert is very difficult
to figure out especially with unmatched brackets, which doesn't make sense
at all.  I'm surprised the insert even works.

Thirdly, have you tried checktable/myisamcheck?

- Original Message -
From: "chchen" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 20, 2001 18:56
Subject: BigInt with primary key


hi all

i use mysql-3.23.32

my project need to use unsigned Bigint as a primary key.
but when i insert many rows in this table.
sometimes it will error with Duplicate such like

insert into Table
values('9231852172526977164',0,0,52056,0,0,0,0,0,52056,0,0,0,0,0,0,0,11,0,'1
84000','184000',1),'9231898557453533324',0,0,5532,0,0,0,0,0,5532,0,0,0,0,0,0
,0,11,0,'184000','184000',1),'9230422383529723532',147,0,0,0,0,0,0,0,147,0,0
,0,0,0,0,0,91,0,'184000','184000',1) query failed
Duplicate entry '9231898557453533324' for key 1

Re: Compiling


It means you forgot -lz.
You also need libz.so

Evan James Dembskey wrote:
 
 Hi,
 
 While trying to compile a program in C taken from the book Professional
 Linux Programming (Matthew, N.  Stones, R. (2000) 155) using this command
 (also taken from the same book):
 
 [root@evan /usr]# gcc -I/usr/include/mysql
 connect1.c -L/usr/lib/mysql -lmysqlclient -o connect1
 
 I get the following error. What does this mean, and how can I fix it?
 
 /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
 `my_uncompress':
 my_compress.o(.text+0x97): undefined reference to `uncompress'
 /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
 `my_compress_alloc':
 my_compress.o(.text+0x12b): undefined reference to `compress'
 collect2: ld returned 1 exit status
 [root@evan /usr]#
 
 I am running under Mandrake 7.2.
 
 Program
 ---
 
 #include stdlib.h
 #include stdio.h
 
 #include "mysql.h"
 
 int main(int argc, char *argv[])
 {
   MYSQL my_connection;
 
   mysql_init(my_connection);
   if(mysql_real_connect(my_connection,
 "localhost","root","","test",0,NULL,0)){
 printf("Connection success\n");
 mysql_close(my_connection);}
 else{
 fprintf(stderr, "Connection failed\n");
 if (mysql_errno(my_connection)){
   fprintf(stderr, "Connection error %d: %s\n",
 mysql_errno(my_connection),
 mysql_error(my_connection));
 }
 }
 
 return EXIT_SUCCESS;
 
 }
 
 Regards,
 
 Evan
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail 
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQLGUI - error executing query's

2001-02-20 Thread Luis Pedro


Hi,

I'd installed MySQLGUI 1.7.4 sucessufuly. After I connect to a database and
when I try to execute  a query, the program stops and I get the following error:

Segmentation fault 

Can you help me with this?

Thank's
-- 

Luis Pedro
Physics Departement of Unoversity of Lisbon

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: BigInt with primary key

2001-02-20 Thread Fred van Engen

On Tue, Feb 20, 2001 at 06:56:28PM +0800, chchen wrote:
hi all

i use mysql-3.23.32

my project need to use unsigned Bigint as a primary key.
but when i insert many rows in this table.
sometimes it will error with Duplicate such like

insert into Table
values('9231852172526977164',0,0,52056,0,0,0,0,0,52056,0,0,0,0,0,0,0,11,0,'184000','184000',1),'9231898557453533324',0,0,5532,0,0,0,0,0,5532,0,0,0,0,0,0,0,11,0,'184000','184000',1),'9230422383529723532',147,0,0,0,0,0,0,0,147,0,0,0,0,0,0,0,91,0,'184000','184000',1)
query failed
Duplicate entry '9231898557453533324' for key 1

but actually if i select * from Table where a='9231898557453533324'

it can't find anything.what's wrong with this, bug?

p.s. unsigned Bigint should be from 0 to 18446744073709551615, so
'9231898557453533324' is included in it, right?

True, but the manual warns against using UNSIGNED BIGINT for anything
else than bitsets:

! BIGINT[(M)] [UNSIGNED] [ZEROFILL]
! A large integer. The signed range is -9223372036854775808 to
! 9223372036854775807. The unsigned range is 0 to
! 18446744073709551615. Note that all arithmetic is done using signed
! BIGINT or DOUBLE values, so you shouldn't use unsigned big integers
! larger than 9223372036854775807 (63 bits) except with bit functions!
! Note that `-', `+', and `*' will use BIGINT arithmetic when both
! arguments are INTEGER values! This means that if you multiply two
! big integers (or results from functions that return integers) you
! may get unexpected results if the result is larger than
! 9223372036854775807.

I could imagine that this includes using it for indexes, because
this will do some comparisons on BIGINT values. But then, the manual
is not conclusive about this I think.

Can you get away with smaller (i.e. UNSIGNED) BIGINT values? It may
be worth a try then.

Regards,

Fred.

--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands

-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Isamchk

2001-02-20 Thread Lauri Vain


Hello,

Several of my tables are corrupted. I have a Win system.

How can I repair my DB's with isamchk. What would I have to enter to the command
line if I would like to check all DB's and all tables? The help says that I have
to specify the table on the command line - it gives the error "file not found".
Do I have to specify the DB to use somehow as well.

Thanks in advance.

Yours,
Lauri



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

New DBTools version Available

2001-02-20 Thread Crercio Osmaildo da Silva


There is a new version of DBTools (1.0.8) available for download. For a
complete list of changes and download go to http://dbtools.vila.bol.com.br.

- This new version comes with an install script. I'd like to thank all the
3rd part effort to make this happens. 
- Fixed a serious bug in the new mySQL data access object. 
- Added support for updateable queries. The Query Editor will check if you
are using only one table in the query. If you used more than one table in
the same query DBTools won't allow to update or delete records.
- Added support for ENUM/SET column types in the column manager
- Added some more HTML help pages in the HTML Help System
- Added the contributors page to DBTools Website. This is something that
really matters to me. I'd like to thank all the contributions I've got so
far. If I forgot to mention anybody, please, just let me know and I will
provide the fix immediately. If you'd like to help the DBTools project, just
send me an email telling me in what way you would like to help. 
 
[]'s
 
Crercio O. Silva / DBTools Development

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQLGUI - error executing query's

2001-02-20 Thread Sinisa Milivojevic


Luis Pedro writes:
  Hi,
  
  I'd installed MySQLGUI 1.7.4 sucessufuly. After I connect to a database and
  when I try to execute  a query, the program stops and I get the following error:
  
  Segmentation fault 
  
  Can you help me with this?
  
  Thank's
  -- 
  
  Luis Pedro
  Physics Departement of Unoversity of Lisbon


Of course.

Please tell me what OS do you have, what mysql version (binary or
source)  have you downloaded.

Also, send me a CREATE table statement for the table in question and
query that caused SIGSEGV.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Slow Select count(*) - Second Post

2001-02-20 Thread Robin Keech


Thanks for your response,

What benefit would that give me?  Would a combined index be faster? I have
the three columns indexed anyway, and do not really want to dedicate more of
my index file to a duplication . it is getting to the 1G mark already, and I
have a 2G limit for any one file.

I have some more information that may prove useful...

If I do a select count(*) with the date set to 2001-02-10 then the soc_date
index is used and the query runs really quickly

mysql explain select count(*) from log where queue_id = 5 and soc_date =
'2001-02-10';
+---+--++--+-+---+--
-++
| table | type | possible_keys  | key  | key_len | ref   | rows
| Extra  |
+---+--++--+-+---+--
-++
| log   | ref  | soc_date_idx,q_idx | soc_date_idx |   4 | const | 42558
| where used |
+---+--++--+-+---+--
-++
1 row in set (0.00 sec)


However, if I do a select count(*) with the date set to 2001-02-11 then the
q_idx is used and the query runs very slowly.

mysql explain select count(*) from log where queue_id = 5 and soc_date =
'2001-02-11';
+---+--++---+-+---+---+-
---+
| table | type | possible_keys  | key   | key_len | ref   | rows  |
Extra  |
+---+--++---+-+---+---+-
---+
| log   | ref  | soc_date_idx,q_idx | q_idx |   5 | const | 58410 |
where used |
+---+--++---+-+---+---+-
---+
1 row in set (0.00 sec)


Here are the real life results:

mysql select count(*) from log where queue_id = 5 and soc_date =
'2001-02-10';
+--+
| count(*) |
+--+
|   11 |
+--+
1 row in set (0.89 sec)

mysql select count(*) from log where queue_id = 5 and soc_date =
'2001-02-11';
+--+
| count(*) |
+--+
|   17 |
+--+
1 row in set (1 min 52.85 sec)


Here are the results of the explains if the queue_id is taken out of the
where.  The rows estimate is fairly similar.

mysql explain select count(*) from log where soc_date = '2001-02-11';
+---+--+---+--+-+---+---+---
--+
| table | type | possible_keys | key  | key_len | ref   | rows  |
Extra   |
+---+--+---+--+-+---+---+---
--+
| log   | ref  | soc_date_idx  | soc_date_idx |   4 | const | 60410 |
where used; Using index |
+---+--+---+--+-+---+---+---
--+
1 row in set (0.00 sec)


mysql explain select count(*) from log where soc_date = '2001-02-10';
+---+--+---+--+-+---+---+---
--+
| table | type | possible_keys | key  | key_len | ref   | rows  |
Extra   |
+---+--+---+--+-+---+---+---
--+
| log   | ref  | soc_date_idx  | soc_date_idx |   4 | const | 42564 |
where used; Using index |
+---+--+---+--+-+---+---+---
--+
1 row in set (0.00 sec)


Is it just tipping the balance and making the optimiser choose a different
index?
If so, why does the select against the queue_index take so long?

Thanks for your help in advance,

Robin

-Original Message-
From: Patrick FICHE [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2001 14:26
To: Robin Keech
Subject: RE: Slow Select count(*) - Second Post


Hi,

What do you think of creating a combined index containing fro example
 soc_date, server_id, queue_id ) in this order...
It depends of course of your application as the index choice is usually one
of the most difficult tasks when designing a database.

Patrick


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL replication

2001-02-20 Thread Fredrik Kristiansen


Hello,

Is it possible to enable a MySQL replication between 2 or more severs where
I can write and read to all servers?

I know it is possible to install one master who I can do reading and writing
to. And slaves who I only can read from. But I want to write to these slaves
as well, and they must replicate themself with all the other servers.

Can this be done with mysql, or do I have to use Oracle? And what about
PostgreSQL?

- Fredrik


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Software engineer

2001-02-20 Thread Kian Haghdad


Hi:

I have got your email from the Web site and I am very interested in working for your 
company. I 
have a BS in Electrical Engineering and computer science and worked on my Master 
degree 
in Telecommunication engineering (not finished due to the lucrative market!). I have 
also 7++ 
years of experience with software development, Internet development and hardware. I 
have 
worked for many companies both in Iran and in the United States using different 
development 
environments.
I am looking for a position which utilizes my experience. I am open to both Permanent 
position 
or contract to permanent positions.

I am Canadian resident and have permission to work in Canada.
I have attached my resume and sincerely appreciate your attention, thank you.

Sincerely,

Kian Haghdad

Here is my resume:
Kian Haghdad
8 Kingsbridge Crt., Apt. 508 
Toronto, Ontario M2R 1L5
Home: (416) 630-7066
Fax:  (416) 630-7991
Email: [EMAIL PROTECTED]

I have more than 7+ years of experience in application development, Database 
Management, 
Internet development. I have also been involved in hardware design. My software 
development experience is mainly in Visual Basic, Visual C++, Visual J++, Visual 
InterDev, 
COM, DCOM, MFC, SDKs, MS-Access, MS-SQL, FoxPro,
Java script and VB script. Over the years I have been responsible for the 
Development of many applications from design to commercial release.

EDUCATION:

Sharif University OF Technology, Tehran (The best technical school in Iran) 
9/87-6/92
B.S. Degree: Electrical Engineering and computer science
Worked on M.S. degree in Telecommunication engineering

EXPERIENCE:

01Communique, Mississauga, Ontario  12/00-Present
Involved in the development of a web supported version of the communicating Interface
using Active Server Pages, JavaScript, VB Script and browser compatibility, Visual 
C++6.0,
Borland C++, MSMQ, TCP/IP. 
Application increases the Modem compatibility for the wide variety of connections.
It also provides additional capabilities for the desktop version on the web.

American SkySat, Walnut Creek, California   5/00-Present
* Involved in the development of a web application in Visual InterDev 6.0 using Active 
Server 
Pages (ASP), Microsoft E-Commerce, SQL 7.0, XML, Visual C++ 6.0 and Visual Basic 6.0, 
Visual J++ 6.0, COM (ATL), DCOM, JavaScript and VB Script. The web server was 
Microsoft 
Internet Information Server (IIS), Microsoft site server 3.0, with Microsoft 
E-Commerce edition 
3.0 and FrontPage extension running under the NT Server The web application provides 
NT 
related services online. The user can register and buy services and also allows the 
user to 
troubleshoot and configure a system at real time online. The web site also provides 
the 
capability of chatting online, customer support online, statistical analysis online 
and transaction 
online.

* Developed a database management application for a medical health care center, using 
Visual Basic 6.0, SQL 7.0, Crystal report and Access 2000. (Windows 98 and NT)

American Computech, Pleasanton, California  3/98-5/00
Developed different applications using Visual C++, Visual J++, and Access.

* Involved in the development of a CRM (Customer Relation Management)web application 
in 
Visual InterDev 6.0 using Active Server Pages (ASP), Microsoft E-Commerce, SQL 7.0, 
XML, 
Visual Basic 6.0, Visual J++ 6.0, COM, DCOM, JavaScript and VB Script. (Windows 98 and 
NT)

Developed an application in Visual Basic 5.0, Access 97 and Crystal reports (using 
ODBC) for 
financial analyses department of FHP (Concord, California). The application is capable 
of 
importing data from other systems, analyzing and processing the data and generating 
hundreds 
of reports base on the original data.

*Developed an MDI application in Visual C++5,0 and Access 97 for windows called ID 
maker. 
The application is designed to drive a digital camera, capture a picture and generate 
different 
ID cards using OLE (marketing for schools and clubs). The Cannon digital camera is 
controlled 
via DLL functions calls to the camera's driver. The camera is connected via a parallel 
port. I 
have also developed several OCXs for this project.

Developed an application in Visual Basic 5.0, Access 97 and Crystal reports (using 
ODBC). 
The application is a very large information management system for CBI (City Building 
Inc. in 
San Francisco). The application contains 28 relational tables large number of queries 
forms 
and reports.

Tavanir Co., Tehran, Iran   9/95-3/98
*Developed an application in Visual C++ 5.0 intended for network control managements. 
The 
application is able to get information such as voltage, active and reactive power from 
power 
plants and transmission stations and specifies transmission state using power flow 
method after 
a fault occurs on the transmission line. 

* Developed an application for voltage drop on the net. The application was developed 
in 
Visual Basic 5.0 using graphical OCXs.

*

RE: Slow Select count(*) - Second Post

2001-02-20 Thread Patrick FICHE


All of your columns are indexed but in an SQL query, only one index can be
used...
So, if you build an index matching exactly the columns used in your query,
you will parse only the lines that match your query...
So, if I'm not wrong, you will only parse 11 or 17 lines depending on your
query and it should be quite immediate.
The only problem is that you can't build as many indexes as you have queries
in your application or your files will become very large and updates will
take longer...
That's why, you really need to globally analyse your application to see
which fields are often used in WHERE clauses.

Patrick

-Message d'origine-
De : Robin Keech [mailto:[EMAIL PROTECTED]]
Envoy : mardi 20 fvrier 2001 16:15
 : '[EMAIL PROTECTED]'
Objet : RE: Slow Select count(*) - Second Post


Thanks for your response,

What benefit would that give me?  Would a combined index be faster? I have
the three columns indexed anyway, and do not really want to dedicate more of
my index file to a duplication . it is getting to the 1G mark already, and I
have a 2G limit for any one file.

I have some more information that may prove useful...

If I do a select count(*) with the date set to 2001-02-10 then the soc_date
index is used and the query runs really quickly

mysql explain select count(*) from log where queue_id = 5 and soc_date =
'2001-02-10';
+---+--++--+-+---+--
-++
| table | type | possible_keys  | key  | key_len | ref   | rows
| Extra  |
+---+--++--+-+---+--
-++
| log   | ref  | soc_date_idx,q_idx | soc_date_idx |   4 | const | 42558
| where used |
+---+--++--+-+---+--
-++
1 row in set (0.00 sec)


However, if I do a select count(*) with the date set to 2001-02-11 then the
q_idx is used and the query runs very slowly.

mysql explain select count(*) from log where queue_id = 5 and soc_date =
'2001-02-11';
+---+--++---+-+---+---+-
---+
| table | type | possible_keys  | key   | key_len | ref   | rows  |
Extra  |
+---+--++---+-+---+---+-
---+
| log   | ref  | soc_date_idx,q_idx | q_idx |   5 | const | 58410 |
where used |
+---+--++---+-+---+---+-
---+
1 row in set (0.00 sec)


Here are the real life results:

mysql select count(*) from log where queue_id = 5 and soc_date =
'2001-02-10';
+--+
| count(*) |
+--+
|   11 |
+--+
1 row in set (0.89 sec)

mysql select count(*) from log where queue_id = 5 and soc_date =
'2001-02-11';
+--+
| count(*) |
+--+
|   17 |
+--+
1 row in set (1 min 52.85 sec)


Here are the results of the explains if the queue_id is taken out of the
where.  The rows estimate is fairly similar.

mysql explain select count(*) from log where soc_date = '2001-02-11';
+---+--+---+--+-+---+---+---
--+
| table | type | possible_keys | key  | key_len | ref   | rows  |
Extra   |
+---+--+---+--+-+---+---+---
--+
| log   | ref  | soc_date_idx  | soc_date_idx |   4 | const | 60410 |
where used; Using index |
+---+--+---+--+-+---+---+---
--+
1 row in set (0.00 sec)


mysql explain select count(*) from log where soc_date = '2001-02-10';
+---+--+---+--+-+---+---+---
--+
| table | type | possible_keys | key  | key_len | ref   | rows  |
Extra   |
+---+--+---+--+-+---+---+---
--+
| log   | ref  | soc_date_idx  | soc_date_idx |   4 | const | 42564 |
where used; Using index |
+---+--+---+--+-+---+---+---
--+
1 row in set (0.00 sec)


Is it just tipping the balance and making the optimiser choose a different
index?
If so, why does the select against the queue_index take so long?

Thanks for your help in advance,

Robin

-Original Message-
From: Patrick FICHE [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2001 14:26
To: Robin Keech
Subject: RE: Slow Select count(*) - Second Post


Hi,

What do you think of creating a combined index containing fro example
 soc_date, server_id, queue_id ) in this order...
It depends of course of your application as the index choice is usually one
of the most difficult tasks when designing a database.

Patrick


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)

RE: Slow Select count(*) - Second Post

2001-02-20 Thread Robin Keech



Thanks for your replies.

Patrick: I will try the combined index, and see if it takes too much disk
space.  Most queries return within 2 seconds, which is acceptable for me.
Therefore I'm not too concerned about the speed increase in using a combined
index as such.

What I am concerned about is the fact the mysql is so slow when it chooses
the q_idx.  If Jarmo is correct then the q_idx is not a very good index and
the optimiser has got it wrong.  It has chosen an index based upon the
number of rows returned and not paid any attention to the 'quality' of the
index.  I'll try dropping the q_idx and see what that gives me.

Is there any way to re-write SQL to force the optimiser to use a certain
index?

Thanks again

Robin

-Original Message-
From: Jarmo Paavilainen [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2001 15:50
To: Robin Keech
Subject: SV: Slow Select count(*) - Second Post


Hi,

Im maybe just stupid but here I go:

The question is, why does MySQL use "soc_date_idx" in the first query and
then "q_idx" in the second one?

It might be that "q_idx" (that is "queue_id" field) has a lot of identical
rows in it and "soc_date_idx" does not. And thereby the "soc_date_idx" is
better as a query limitator than "q_idx".

If you can, kill the "q_idx" index and try the queries again.

Thats all I could think of, let me know if it helped.

// Jarmo

...
 Can anyone please explain the following?
...
 mysql select count(server_id) from log where server_id = 1 and queue_id =
1 and soc_date = '2001-02-18';
...
 mysql select count(server_id) from log where server_id = 1 and queue_id =
5 and soc_date = '2001-02-18';

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL replication


Read the manual on replication, and pay special attention
to the warnings.

This will not work if you use autoincrement fields, unless you are VERY
careful.
Then it still may not work.

Fredrik Kristiansen wrote:
 
 Hello,
 
 Is it possible to enable a MySQL replication between 2 or more severs where
 I can write and read to all servers?
 
 I know it is possible to install one master who I can do reading and writing
 to. And slaves who I only can read from. But I want to write to these slaves
 as well, and they must replicate themself with all the other servers.
 
 Can this be done with mysql, or do I have to use Oracle? And what about
 PostgreSQL?
 
 - Fredrik
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail 
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Once again... quotas...

2001-02-20 Thread Tristan 'Minty' Colgate


Hi There,

  I have recently been asked to implement per database quotas 
for mysql for a large scale shared webhosting environmnet,
from the lists it seems pretty obvious that mysql cant achieve
this at the moment (without using filesystem quotas), file
system quotaing is pretty awkward with our environment.

  Ive been asked to investigate the possibility of implementing
this and my boss has agreed that we can release the code back
to the community if we decide to do it.

  I found one posting that mentioned that someone at MySQL
had some ideas on how you would like this implemented, if
this is still the case could they post them to me, if it
can fit in our timeframe Id be more than happy to do it.

  It really would be a nice feature.

-- 
Tristan 'Minty' Colgate
[EMAIL PROTECTED] | ICQ #645908
---
  "You can get all you daily vitamins from
43 pints of guinness and a glass of milk"

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Trouble w/ DBI/DBD::MySQL and OSX

2001-02-20 Thread Duncan Hudson


Has anyone been able to sucessfully make DBI and DBD::MySQL work under OSX -
Darwin?  I'm not having  any luck at all.  I'm running Perl v5.6.0 built for
darwin.  And I'm trying to install the MySQL modules version 1.2215, with
DBI version 1.14.0.  My mysql database is version 3.23.28.  When I run make
test on the DBI I get the following:


[localhost:dunc/dbi-1_14_0/dbi-1.14] root# make test
PERL_DL_NONLAZY=1
/usr/bin/perl -Iblib/arch -Iblib/lib -I/System/Library/Perl/da
rwin -I/System/Library/Perl -e 'use Test::Harness qw(runtests $verbose);
$verbo
se=0; runtests @ARGV;' t/*.t
t/basicsok
t/dbidrvok
t/examp.ok
t/meta..ok
t/proxy.ok 4/111Can't call method "ping" on unblessed reference
at t
/proxy.t line 87.
t/proxy.dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-2, 5-111
Failed 109/111 tests, 1.80% okay
t/shell.ok 1/3Use of uninitialized value in pattern match (m//)
at /
System/Library/Perl/Term/Cap.pm line 284.
Use of uninitialized value in pattern match (m//) at
/System/Library/Perl/Term/C
ap.pm line 284.
Use of uninitialized value in pattern match (m//) at
/System/Library/Perl/Term/C
ap.pm line 284.
Use of uninitialized value in pattern match (m//) at
/System/Library/Perl/Term/C
ap.pm line 284.
t/shell.ok
t/subclass..ok
Failed Test  Status Wstat Total Fail  Failed  List of failed

---
t/proxy.t   255 65280   111  109  98.20%  1-2, 5-111
Failed 1/7 test scripts, 85.71% okay. 109/290 subtests failed, 62.41% okay.
make: *** [test_dynamic] Error 2


Anyone have any thoughts / help?  Thanks in advance,


Dunc.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Slow Select count(*) - Second Post

2001-02-20 Thread Robin Keech


Thanks for all your help.

This has got the query time down to 5 seconds from 2 minutes!!

Much appreciated everyone.

Robin

-Original Message-
From: Tibor Simko [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2001 16:46
To: Robin Keech
Cc: '[EMAIL PROTECTED]'
Subject: Re: Slow Select count(*) - Second Post


Hello

 Is there any way to re-write SQL to force the optimiser to use a certain
 index?

SELECT foo FROM bar USE INDEX baz WHERE ...

See the manual at http://www.mysql.com/doc/J/O/JOIN.html.

cheers
-- 
TS

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Two query issues -- need help

2001-02-20 Thread Matteo Dell'Orto


Hi all, I have two little problems:

1.In a query, I get errors when a record's field contains the '
character. In fact the query starts like ! sql query "insert into dbase
values ('@qfield1', '@qfield2'...).

2.I need to split query results in multiple pages (e.g. with a next
button) so that my output is better presented, please give an advice.

Please help me!!! Thanks in advance,
Teo

RE: Two query issues -- need help

2001-02-20 Thread Alan Halls


Here is what our company uses to do the page division on adoptablekids.com I
have used it for a few other applications with minimum changes
This code would give you five per page.


sql detail=rhs pgsize="5"
select * from profile order by id DESC
/sql

perl

return if ({sys:num_pages} = 1);
my $pg;
if ({sys:prevpg_link})
{
wgprint "";
}
for ($pg = 1; $pg = {sys:num_pages}; $pg++)
{
if ($pg == {sys:page_num})
{
print "$pg\n";
}
else
{
print "a href=child.wga?dbpg=$pg\$pg/a\n";
}
}
if ({sys:nextpg_link})
{ print ""; }

/perl

-Original Message-
From: Matteo Dell'Orto [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 20, 2001 10:32 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Two query issues -- need help


Hi all, I have two little problems:

1.In a query, I get errors when a record's field contains the '
character. In fact the query starts like ! sql query "insert into dbase
values ('@qfield1', '@qfield2'...).

2.I need to split query results in multiple pages (e.g. with a next
button) so that my output is better presented, please give an advice.

Please help me!!! Thanks in advance,
Teo


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

DBD::mySQL

2001-02-20 Thread ryan_gamo


Where do I get this DBD::mySQL?

I've been searching for it and can't quite find it.

 Ryan Gamo
   Edwards Lifesciences
  One Edwards Way
 Irvine, CA 92614
 GO Floor 2, Mail Stop 11
   Phone 949.250.3884 Pager 949.203.1004
   E-mail: [EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Compiler error #2

2001-02-20 Thread John Markunas


Hi
Attempting build on Tru64 V4.x using gcc V2.95.2 and gnumake v 3.x

Build mysql is quite troublesome.

The latest error appears to be gnu gcc V2.95.2 error. I am attempting build
number
7,345

The error I get is.

sql_acl.cc in function 'int replace_column_table (GRANT_TABLE *, TABLE *,
  const LEX_USER ,
ListLEX_COLUMN ,
const char *, const char *,
unsigned int, bool ):
sql_acc.cc : 1459 : Internale compiler error in scan_region at except :
2566

Please submit a full bug report.


Any body seen this 


Thank you

John Markunas
Williams College


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: DBD::mySQL



cpan.org


On Tue, 20 Feb 2001 [EMAIL PROTECTED] wrote:

 Where do I get this DBD::mySQL?
 
 I've been searching for it and can't quite find it.
 
  Ryan Gamo
Edwards Lifesciences
   One Edwards Way
  Irvine, CA 92614
  GO Floor 2, Mail Stop 11
Phone 949.250.3884 Pager 949.203.1004
E-mail: [EMAIL PROTECTED]
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: RE: Two query issues -- need help


Alan Halls ([EMAIL PROTECTED]) writes:

 Here is what our company uses to do the page division on adoptablekids.com I
 have used it for a few other applications with minimum changes
 This code would give you five per page.
 
 
   sql detail=rhs pgsize="5"
   select * from profile order by id DESC
   /sql
 
 perl
 
   return if ({sys:num_pages} = 1);  my $pg;
   if ({sys:prevpg_link})
   {
   wgprint "";
   }
   for ($pg = 1; $pg = {sys:num_pages}; $pg++)   {
   if ($pg == {sys:page_num})
   {
   print "$pg\n";
   }

Inefficient.  Better to use LIMIT.

select * from blah limit start,recordcount
--
Ed Carp, N7EKG  [EMAIL PROTECTED]   940/367-2744 cell phone
http://www.pobox.com/~erc   [EMAIL PROTECTED] - text pager

I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Permissions

2001-02-20 Thread Scott Baker


I did the following on my mysql server...

GRANT ALL PRIVILEGES ON database.* TO user@'web.web-ster.com' IDENTIFIED BY 
'password'
FLUSH PRIVILEGES

So I know the privileges are current...  But when I try and access the 
database from this IP it says that "host 13ave.com" is not allowed to 
access the DB server.  I'm trying to run some PHP scripts on it.

Now host 13ave.com resolves to to 12.111.170.18 but the reverse DNS does NOT...

If I change web.web-ster.com to the raw IP that it should be it works, but 
still reports "Aborted connection" in the log.  It's like it tries the 
reverse DNS first, and it fails and falls back to the raw IP and it works.

What I don't understand is why it's finding 13ave.com as the hostname 
because according to my DNS it's NOT.  If I do nslookups from the MYSQL 
server it sees the web.web-ster.com info, so I don't know where mysql is 
getting that info.  Anyone have any problems with this?

Scott



-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]

"Children today are tyrants. They contradict their parents, gobble their 
food, and tyrannize their teachers." - Socrates




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Time between two DATETIMEs

2001-02-20 Thread Duncan Hudson


I have a table that contains two datetime columns, and I need to determine
the time between the two dates.  So, what I've been doing is just
subtracting what I know is the later date from the earlier date.  But that's
obviously not the way to do it as my results don't relate to anything.
Here's what my data looks like:

Datetime_A Datetime_B(Datetime_A - Datetime_B)
2001-02-20 14:09:382001-02-20 14:20:43   18.4167
2001-02-20 14:14:452001-02-20 14:30:35   26.5
2001-02-20 14:22:032001-02-20 14:28:14   10.1833

The differences should be 11 minutes 5 seconds, 15 minutes 50 seconds and 6
minutes 11 seconds respectively - but that's not what I'm getting.  As I'm
obviously doing this wrong, what is the correct means of determining the
time difference between two datetime fields?  Thanks in advance,


Dunc.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Large Numbers problem

2001-02-20 Thread Martin Jeremic


I have inserted 1234567890 in a float field. mySQL server rounded this
to 123457. Then i have inserted 99 in same field, and tis
was rounded to 100. Is this a bug or someyhing else? Field is
declared as "field1 float"

--
Martin Jeremic - JSoft

http://jsoft.webjump.com/
mailto:[EMAIL PROTECTED]



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Permissions

2001-02-20 Thread Scott Baker


Yep that was it!  Yesterday there was a messup with DNS that caused the 
reverse DNS to be 13ave.com

I quickly changed it, but apparently MySQL cached that entry.  It's been 24 
hours, but still.  As soon as I just did a flush-hosts it came right 
up.  Thanks!

At 12:12 PM 2/20/2001 -0800, Atle Veka wrote:

mysql caches hostnames, so perhaps 13ave.com is connecting to your
database server as well?

say for instance:
13ave.com connects, mysql resolves that to
$ host 13ave.com
13ave.com has address 12.111.170.18
web.web-ster.com comes along, mysql sees the reverse and says 'Hey, I've
seen you before, you're 13ave.com'


You can turn this behavior off with --skip-host-caching (or whatever it is
mysql --help). BUT, you want to think what load this will give your
nameservers. Consider redoing your DSN perhaps?


-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]

"Children today are tyrants. They contradict their parents, gobble their 
food, and tyrannize their teachers." - Socrates




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Microsoft SQL Server linking to MySQL

2001-02-20 Thread Aaron Weiker


This doesn't work, gives the same error.

Do we know if Microsoft just doesn't like MySQL?

Aaron Weiker
Programmer
CISP - Changing Internet Speed  Performance

Phone: 419.724.5351 [EMAIL PROTECTED]
Pager: 419.218.0013 http://www.cisp.cc
Cell:419.304.0323   web search:
http://www.allthesites.com 

-Original Message-
From: Ed Carp [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 19, 2001 8:56 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Microsoft SQL Server linking to MySQL


  I'm trying to set up a link to MySQL through Microsoft SQL.
 
  I set up a ODBC DSN using MyODBC and I told Microsoft SQL to link
through
 an
  ODBC Datasource. Everything seems to work except I can't query anything.
 
  This is a statement I try.
 
  SELECT * FROM [MySQL].mysql.db
 
  This is the error message I get
 
  Invalid object name 'MySQL.mysql.db'.

The database name is set up through the Connect statement.  The correct SQL
statement would be "select * from mysql.db" or, more simply, "select * from
db" - after setting the database name in the DSN in the Connect statement.
--
Ed Carp, N7EKG  [EMAIL PROTECTED]   940/367-2744 cell phone
http://www.pobox.com/~erc   [EMAIL PROTECTED] - text pager

I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.

Re: Time between two DATETIMEs



You could use the UNIX_TIMESTAMP() function to easily determine
the difference in seconds between the two dates.

select UNIX_TIMESTAMP( Datetime_A ) ...

and the do the time_a - time_b thing. there might be a simple query that
will work as well, but I don't know the mysql date queries that good :)


.. Atle

On Tue, 20 Feb 2001, Duncan Hudson wrote:

 I have a table that contains two datetime columns, and I need to determine
 the time between the two dates.  So, what I've been doing is just
 subtracting what I know is the later date from the earlier date.  But that's
 obviously not the way to do it as my results don't relate to anything.
 Here's what my data looks like:
 
 Datetime_A Datetime_B(Datetime_A - Datetime_B)
 2001-02-20 14:09:382001-02-20 14:20:43   18.4167
 2001-02-20 14:14:452001-02-20 14:30:35   26.5
 2001-02-20 14:22:032001-02-20 14:28:14   10.1833
 
 The differences should be 11 minutes 5 seconds, 15 minutes 50 seconds and 6
 minutes 11 seconds respectively - but that's not what I'm getting.  As I'm
 obviously doing this wrong, what is the correct means of determining the
 time difference between two datetime fields?  Thanks in advance,
 
 
 Dunc.
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Can this query not be done in MySQL.

2001-02-20 Thread Steve Ruby




Your question was answered already after you posted it on Saturday
by Fred van Engen...

Basicaly you should not be able to do a group by without perfoming an
aggregate function (max, avg, sum, count) on columsn that do not
appear on the "GROUP BY" clause.



Richard Reina wrote:
 
 I posted this question to this list on Saturday.  I realize that not
 everyone on the list knows whether this query is possible using MySQL.
 However, if I could please here back from someone who does know, I would
 appreciate it.  I'm getting flack from informix ( and other DBMS ) users
 on my perl user list who are now doubting whether I can get it to work
 in MySQL.  I have great confidence in MySQL and believe there must be a
 way to get the query to work. I have searched through my MySQL/mSQL
 O'Reilly book and in the user manual (specifically GROUP BY functions
 (section 7.3.12)). Can someone please help me out?

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Large Numbers problem


Martin Jeremic wrote:
 
 I have inserted 1234567890 in a float field. mySQL server rounded this
 to 123457. Then i have inserted 99 in same field, and tis
 was rounded to 100. Is this a bug or someyhing else? Field is
 declared as "field1 float"
 
 --
 Martin Jeremic - JSoft
 
 http://jsoft.webjump.com/
 mailto:[EMAIL PROTECTED]
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail 
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

If you want accuracy, don't use floats.
Use numeric.
It is NOT a bug.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

So, just how long should it take the make install to run?

2001-02-20 Thread Matthew P. Marino


Don't laugh,

Intel PI 166MHZ, 32MB RAM,10GB HD
FreeBSD4
MySQL3.23.33 from .tar.gz distribution

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

followup to lockup in test suite on SGI

2001-02-20 Thread Super-User


Description:

On several occasions I reported problems with MySQL and our Webmail installation
(using the program IMP).  All MySQL processes would lock. No process would be
shown to execute.  The Only thing to correct the problem was to kill MySQL and
restart Apache.

People at MySQL pointed at a faulty lpthread library, but having no access to
the latest SGI bug list, I could not verify.  I try several things as 

- use --skip-locking
- use low-priority-thread
- don't use persistent connections in php.ini
- etc...

Lockups continued.

This was back in december.

Later at the beginning of the year, I decided to try the new versions with
the test suite.  I tried on different SGI boxes we have here.  Not one could
complete the tests.  They would all lock at one point or another, waiting for
a signal.

Recently, I decided to test with a different user than root.  I reported the
results in february (re: lockup in test suite on SGI).  All tests worked without
problem on all servers tried.

It has now been more than a week without any lockup in our production webmail
environment.  I upgraded to MySQL 3.23.33 last week. 

How-To-Repeat:

Start Mysql with root user or with the CAP_SCHED_MGT privilege. Do a high
volume of select/insert/replace/delete (3 or 4 requests per sec).  Eventually
mysqld will lock.  All threads then appear to be locked on the active_sessions
table.  Killing the oldest thread (and the second one some times) clears 
the lock.

This seem to appear on SGI IP19 multiprocessors architecture with 
IRIX 6.5.x system.

Fix:

Run MySQL as a non-root user and DO NOT give it the CAP_SCHED_MGT privilege.

I found that it is true you need the CAP_SCHED_MGT privilege to run mysqld with
the user parameter when launched by safe_mysql as root, but you don't need it
if you run safe_mysql under the "su" command.

The matter is closed for me as this works.  I now found MySQL very stable.

Thanks.

Submitter-Id:  submitter ID
Originator:Super-User
Organization: Universite de Montreal
MySQL support: none
Synopsis:  lockups when root on SGI
Severity:  critical
Priority:  low
Category:  mysql
Class: sw-bug
Release:   mysql-3.23.33 (Source distribution)

Environment: 
System: IRIX64 acces 6.5 04191225 IP19


Some paths:  /usr/sbin/perl /sbin/make /usr/bin/cc

Compilation info: CC='cc'  CFLAGS=''  CXX='CC'  CXXFLAGS=''  LDFLAGS=''
LIBC: 
-r-xr-xr-t1 root sys   2332864 Aug 31 16:10 /lib/libc.so.1
lrwxr-xr-x1 root sys   19 Nov  7 15:09 /usr/lib/libc.so - 
../../lib/libc.so.1
lrwxr-xr-x1 root sys   19 Nov  7 15:12 /usr/lib/libc.so.1 - 
../../lib/libc.so.1
Configure command: ./configure  --prefix=/usr/local/mysql --without-berkeley-db
Perl: This is perl, version 5.004_04 built for irix-n32

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

format masks for a Masked edit control

2001-02-20 Thread Gregg Housh


I am working on an auto-generating form in VB.  Its time to add a mask control, if the 
FieldType is a number.

I need input and display masks for each of the numeric field types. (for the Microsoft 
MaskEdBox control that comes with VB 6).

If anyone is any good at masks, please help me out here.  I just dont seem to be good 
at getting them right.

Gregg

Microsoft Access Error

2001-02-20 Thread Ryan Stout


Hello,
I have setup MySql and MyODBC on an NT4 machine and I have granted access for 
several users to a database called test.  I can open databases with a link table in 
access, but I can't export them or edit the databases in design view.  When I try to 
change the database with design view I get the following error "Table 'ryan' is a 
linked table with some properties that can't be modified."  And when I try to export a 
database to the remote MyODBC sorce I get this error "ODBC -- call failed.

[Microsoft][ODBC Driver Manager (#0)'

I think that the problem involves access since I can edit the database fields and 
stuff from another program I downloaded called urSQL Utility.  Does anyone know what 
the problem is and how to fix it.

Thanks,
Ryan Stout

Re: mysqlimport puzzle



sounds strange, but if you do it this way, you should have no problems:

mysqldump test_database  test_database.dump
mysql test_database  test_database.dump

will import everything in test_database.dump into your database..

somehow, you had selected your database, but that got dropped ?


Atle

On Tue, 20 Feb 2001, John Jensen wrote:

 
 Yesterday, I was having fun writing mysql scripts and importing them. 
 I would do a drop database and re-import, editing the data in the 
 script.
 
 Today, I couldn't for the life of me do an import on a mysql export 
 file, even using commands stored from yesterday, in bash_history.
 I am getting errors like:
 
 ERROR 1046 at line 10: No Database Selected.
 
 Line 10 just says "CREATE TABLE Test (" with only comment preceeding, 
 until I realized that mysqldump was not putting:
 
 CREATE DATABASE Test;
 USE Test;
 
 at the beginning, so mysqlimport was useless where the database did 
 not yet exist. Do I have to manually add those lines to transfer a 
 dump file to a new machine?
 
 
 John Jensen
 520 Goshawk Court
 Bakersfield, CA 93309
 661-833-2858
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysqlimport puzzle

2001-02-20 Thread John Jensen



Yesterday, I was having fun writing mysql scripts and importing them. 
I would do a drop database and re-import, editing the data in the 
script.

Today, I couldn't for the life of me do an import on a mysql export 
file, even using commands stored from yesterday, in bash_history.
I am getting errors like:

ERROR 1046 at line 10: No Database Selected.

Line 10 just says "CREATE TABLE Test (" with only comment preceeding, 
until I realized that mysqldump was not putting:

CREATE DATABASE Test;
USE Test;

at the beginning, so mysqlimport was useless where the database did 
not yet exist. Do I have to manually add those lines to transfer a 
dump file to a new machine?


John Jensen
520 Goshawk Court
Bakersfield, CA 93309
661-833-2858

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Microsoft Access Error

2001-02-20 Thread Miguel Angel Solórzano


At 15:16 20/02/2001 -0700, Ryan Stout wrote:
Hi!
To have an updatable record set on Access, you need to have a
primary key or selected a column as primary key when you
make the linkage of the table.
Regards,
Miguel
Hello,
 I have setup MySql and MyODBC on an NT4 machine and I have granted 
 access for several users to a database called test.  I can open databases 
 with a link table in access, but I can't export them or edit the 
 databases in design view.  When I try to change the database with design 
 view I get the following error "Table 'ryan' is a linked table with some 
 properties that can't be modified."  And when I try to export a database 
 to the remote MyODBC sorce I get this error "ODBC -- call failed.

[Microsoft][ODBC Driver Manager (#0)'

I think that the problem involves access since I can edit the database 
fields and stuff from another program I downloaded called urSQL 
Utility.  Does anyone know what the problem is and how to fix it.

Thanks,
 Ryan Stout

__  ___   __
   /  |/  /_ __/ __/ __ \/ /   http://www.mysql.com/
  / /|_/ / // /\ \/ /_/ / /__  Miguel Solrzano [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/  So Paulo, Brazil
___/  Development Team


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: So, just how long should it take the make install to run?

2001-02-20 Thread Jeremy D. Zawodny


On Tue, Feb 20, 2001 at 04:41:25PM -0500, Matthew P. Marino wrote:
 Don't laugh,
 
 Intel PI 166MHZ, 32MB RAM,10GB HD
 FreeBSD4
 MySQL3.23.33 from .tar.gz distribution

The `make' or the `make install'?

The `make install' shouldn't take more than a few minutes, but the
initial `make' will take quite a while...

Jeremy
-- 
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: So, just how long should it take the make install to run?

2001-02-20 Thread Dan Nelson


In the last episode (Feb 20), Jeremy D. Zawodny said:
 On Tue, Feb 20, 2001 at 04:41:25PM -0500, Matthew P. Marino wrote:
  Don't laugh,
  
  Intel PI 166MHZ, 32MB RAM,10GB HD
  FreeBSD4
  MySQL3.23.33 from .tar.gz distribution
 
 The `make' or the `make install'?
 
 The `make install' shouldn't take more than a few minutes, but the
 initial `make' will take quite a while...

.. espscially if you don't add --with-low-memory.  A 32MB machine will
swap pretty heavily even with it, and I doubt you would want to wait
for it to finish without it.

-- 
Dan Nelson
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: How secure is MySQL?

2001-02-20 Thread Jason Brooke


Like pretty much all software, it quite possibly has security flaws.

A big bonus though, is that it binds port 3306 by default so you don't need
to run it as root. Create a completely seperate user and group for it and
run it under that uid/gid. Ensure none of your root system scripts interact
with files that mysql can create. Make sure you understand the way it
handles login permissions using the 'mysql' database - documented in the
online manual at http://www.mysql.com. Make your mysql login permissions as
strict as possible. The built-in permission system allows for very
fine-grained permission configuration, so take advantage of it.

Don't run it as root.

jason


 Hi,

 I am not familiar with the current state of MySQL
 security. I know there were serious problems with
 previous versions, but that was a year ago.

 I am planning to install a program that use MySQL as
 backend on our external server. There are other
 important database server running on the server too.
 Does anyone know how secure the MySQL is? My program
 is using MySQL3.22. Are there advisories out on MySQL?

 Thanks.

 =
 Abby




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql daemon problem

2001-02-20 Thread Hyup Cho(Etec)


Hi mysql support,

I got the following error message whenever I tried to run mysqld
daemon.
It worked before but it's something wrong about getting passwd, I
think.
What caused this error ?
My system is Linux i686 system.

mysqld ended on  Fri Feb 9 11:44:06 GMT 2001
mysqld started on  Fri Feb 9 11:44:48 GMT 2001
010209 11:44:48  getpwnam: No such file or directory
010209 11:44:48  Aborting

Thanks for your support in advance.

Hyup

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: So, just how long should it take the make install to run?

2001-02-20 Thread Noel Clarkson


I've done it on a 486 with 64Mb memory and it took about an hour or an hour 
and a half or so (it was a long time and I went off and did other things 
while it was happening so my timing is not precise (oh that's make time for 
the main part, make install much quicker)  - and it was a few versions ago 
- 3.23.25 about.

cheers,

noel

On Wednesday, February 21, 2001 8:41 AM, Matthew P. Marino 
[SMTP:[EMAIL PROTECTED]] wrote:
 Don't laugh,

 Intel PI 166MHZ, 32MB RAM,10GB HD
 FreeBSD4
 MySQL3.23.33 from .tar.gz distribution

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail 
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Permissions



mysql caches hostnames, so perhaps 13ave.com is connecting to your
database server as well?

say for instance:
13ave.com connects, mysql resolves that to
$ host 13ave.com
13ave.com has address 12.111.170.18
web.web-ster.com comes along, mysql sees the reverse and says 'Hey, I've
seen you before, you're 13ave.com'


You can turn this behavior off with --skip-host-caching (or whatever it is
mysql --help). BUT, you want to think what load this will give your
nameservers. Consider redoing your DSN perhaps?


Hope this helps.
Atle

On Tue, 20 Feb 2001, Scott Baker wrote:

 I did the following on my mysql server...
 
 GRANT ALL PRIVILEGES ON database.* TO user@'web.web-ster.com' IDENTIFIED BY 
 'password'
 FLUSH PRIVILEGES
 
 So I know the privileges are current...  But when I try and access the 
 database from this IP it says that "host 13ave.com" is not allowed to 
 access the DB server.  I'm trying to run some PHP scripts on it.
 
 Now host 13ave.com resolves to to 12.111.170.18 but the reverse DNS does NOT...
 
 If I change web.web-ster.com to the raw IP that it should be it works, but 
 still reports "Aborted connection" in the log.  It's like it tries the 
 reverse DNS first, and it fails and falls back to the raw IP and it works.
 
 What I don't understand is why it's finding 13ave.com as the hostname 
 because according to my DNS it's NOT.  If I do nslookups from the MYSQL 
 server it sees the web.web-ster.com info, so I don't know where mysql is 
 getting that info.  Anyone have any problems with this?
 
 Scott
 
 
 
 -
 Scott Baker - Webster Internet - Network Technician
 503.266.8253 - [EMAIL PROTECTED]
 
 "Children today are tyrants. They contradict their parents, gobble their 
 food, and tyrannize their teachers." - Socrates
 
 
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

WEALTH ON THE WEB!

2001-02-20 Thread Noel Hadfield


Get a FREE copy of the exciting 48-page booklet "Inside Secrets to Wealth 
on the Web".

Just hit Reply and send a blank message with "Inside Secrets" on the 
Subject line.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

I NEED YOUR URGENT HELP!

2001-02-20 Thread CK74


I have big problem,

i have installed 3.22.23-1 for linux (cobalt server)

mysql works, mysqladmin works but i have a meassage in IE:
Warning: MySQL Connection Failed: Can't connect to local MySQL server through 
socket '/tmp/mysql.sock' (111) in /home/sites/site2/web/tepekoy.php on line 28

then checked mysqladmin and i get:
UNIX SOCKET: /var/lib/mysql/mysql.sock

then i wanted to change mysql.sock address as:
./configure --with-unix-socket-path=/var/lib/mysql/mysql.sock

then i get NO such FILE or directory
but in directory /var/lib/mysql/, PWD says it is there!

WHAT I HAVE TO DO
--- i checked below commands at least 10 times---

please i need urgent help!!!
cem

---
The Fastest Browser on Earth now for FREE!!
Download Opera 5 for Windows now! Get it at
http://www.opera.com/download/
---


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

How secure is MySQL?

2001-02-20 Thread Abby Jiang


Hi,

I am not familiar with the current state of MySQL
security. I know there were serious problems with
previous versions, but that was a year ago. 

I am planning to install a program that use MySQL as
backend on our external server. There are other
important database server running on the server too.
Does anyone know how secure the MySQL is? My program
is using MySQL3.22. Are there advisories out on MySQL?

Thanks. 

=
Abby

__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Comment field of a table

2001-02-20 Thread Fethiye Akbulut



I would like to see if all the tables in my database have the "comment" 
field equal to a given value. I understand that "show table status" command 
is able to show us the "comment" field's value. I was wondering how we can 
extract only this field when we do conduct our queries from a mysql client 
or a program written in tcl/tk and/or perl?

Thanks,
Fethiye
_
Get your FREE download of MSN Explorer at http://explorer.msn.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

need help to set mysql up

2001-02-20 Thread Mehmet agar




i am a very  beginner level and i tried to set mysql up but i failed.
i downloaded the software from mysql.com but i couldnot find any setup icon.
what kind of  compiler do i need?
i wonder to know whether you can send me some information how to set mysql 
up.


thank you for your interest.

From: Kian Haghdad [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Software engineer
Date: Tue, 20 Feb 2001 10:39:45 -0500

Hi:

I have got your email from the Web site and I am very interested in working 
for your company. I
have a BS in Electrical Engineering and computer science and worked on my 
Master degree
in Telecommunication engineering (not finished due to the lucrative 
market!). I have also 7++
years of experience with software development, Internet development and 
hardware. I have
worked for many companies both in Iran and in the United States using 
different development
environments.
I am looking for a position which utilizes my experience. I am open to both 
Permanent position
or contract to permanent positions.

I am Canadian resident and have permission to work in Canada.
I have attached my resume and sincerely appreciate your attention, thank 
you.

Sincerely,

Kian Haghdad

Here is my resume:
Kian Haghdad
8 Kingsbridge Crt., Apt. 508
Toronto, Ontario M2R 1L5
Home: (416) 630-7066
Fax:  (416) 630-7991
Email: [EMAIL PROTECTED]

I have more than 7+ years of experience in application development, 
Database Management,
Internet development. I have also been involved in hardware design. My 
software
development experience is mainly in Visual Basic, Visual C++, Visual J++, 
Visual InterDev,
COM, DCOM, MFC, SDKs, MS-Access, MS-SQL, FoxPro,
Java script and VB script. Over the years I have been responsible for the
Development of many applications from design to commercial release.

EDUCATION:

Sharif University OF Technology, Tehran (The best technical school in 
Iran)  9/87-6/92
B.S. Degree: Electrical Engineering and computer science
Worked on M.S. degree in Telecommunication engineering

EXPERIENCE:

01Communique, Mississauga, Ontario 12/00-Present
Involved in the development of a web supported version of the communicating 
Interface
using Active Server Pages, JavaScript, VB Script and browser compatibility, 
Visual C++6.0,
Borland C++, MSMQ, TCP/IP.
Application increases the Modem compatibility for the wide variety of 
connections.
It also provides additional capabilities for the desktop version on the 
web.

American SkySat, Walnut Creek, California  5/00-Present
* Involved in the development of a web application in Visual InterDev 6.0 
using Active Server
Pages (ASP), Microsoft E-Commerce, SQL 7.0, XML, Visual C++ 6.0 and Visual 
Basic 6.0,
Visual J++ 6.0, COM (ATL), DCOM, JavaScript and VB Script. The web server 
was Microsoft
Internet Information Server (IIS), Microsoft site server 3.0, with 
Microsoft E-Commerce edition
3.0 and FrontPage extension running under the NT Server The web application 
provides NT
related services online. The user can register and buy services and also 
allows the user to
troubleshoot and configure a system at real time online. The web site also 
provides the
capability of chatting online, customer support online, statistical 
analysis online and transaction
online.

* Developed a database management application for a medical health care 
center, using
Visual Basic 6.0, SQL 7.0, Crystal report and Access 2000. (Windows 98 and 
NT)

American Computech, Pleasanton, California 3/98-5/00
Developed different applications using Visual C++, Visual J++, and Access.

* Involved in the development of a CRM (Customer Relation Management)web 
application in
Visual InterDev 6.0 using Active Server Pages (ASP), Microsoft E-Commerce, 
SQL 7.0, XML,
Visual Basic 6.0, Visual J++ 6.0, COM, DCOM, JavaScript and VB Script. 
(Windows 98 and
NT)

Developed an application in Visual Basic 5.0, Access 97 and Crystal reports 
(using ODBC) for
financial analyses department of FHP (Concord, California). The application 
is capable of
importing data from other systems, analyzing and processing the data and 
generating hundreds
of reports base on the original data.

*Developed an MDI application in Visual C++5,0 and Access 97 for windows 
called ID maker.
The application is designed to drive a digital camera, capture a picture 
and generate different
ID cards using OLE (marketing for schools and clubs). The Cannon digital 
camera is controlled
via DLL functions calls to the camera's driver. The camera is connected via 
a parallel port. I
have also developed several OCXs for this project.

Developed an application in Visual Basic 5.0, Access 97 and Crystal reports 
(using ODBC).
The application is a very large information management system for CBI (City 
Building Inc. in
San Francisco). The application contains 28 relational tables large number 
of queries forms
and reports.

Tavanir Co., Tehran, Iran  9/95-3/98
*Developed an application in Visual C++ 5.0 intended for network control

Re: need help to set mysql up

From what you've written, I'm guessing that you're using windoze so,
firstly, are you sure you downloaded the Windoze version and not the Unix
version?  The other is, mysql has a very good manual on their website which
describes how to install.

- Original Message -
From: "Mehmet agar" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 21, 2001 8:57
Subject: need help to set mysql up

 i am a very  beginner level and i tried to set mysql up but i failed.
 i downloaded the software from mysql.com but i couldnot find any setup
icon.
 what kind of  compiler do i need?
 i wonder to know whether you can send me some information how to set mysql
 up.

 thank you for your interest.

 From: Kian Haghdad [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Subject: Software engineer
 Date: Tue, 20 Feb 2001 10:39:45 -0500

 Hi:

 I have got your email from the Web site and I am very interested in
working
 for your company. I
 have a BS in Electrical Engineering and computer science and worked on my
 Master degree
 in Telecommunication engineering (not finished due to the lucrative
 market!). I have also 7++
 years of experience with software development, Internet development and
 hardware. I have
 worked for many companies both in Iran and in the United States using
 different development
 environments.
 I am looking for a position which utilizes my experience. I am open to
both
 Permanent position
 or contract to permanent positions.

 I am Canadian resident and have permission to work in Canada.
 I have attached my resume and sincerely appreciate your attention, thank
 you.

 Sincerely,

 Kian Haghdad

 Here is my resume:
 Kian Haghdad
 8 Kingsbridge Crt., Apt. 508
 Toronto, Ontario M2R 1L5
 Home: (416) 630-7066
 Fax:  (416) 630-7991
 Email: [EMAIL PROTECTED]

 I have more than 7+ years of experience in application development,
 Database Management,
 Internet development. I have also been involved in hardware design. My
 software
 development experience is mainly in Visual Basic, Visual C++, Visual J++,
 Visual InterDev,
 COM, DCOM, MFC, SDKs, MS-Access, MS-SQL, FoxPro,
 Java script and VB script. Over the years I have been responsible for the
 Development of many applications from design to commercial release.

 EDUCATION:

 Sharif University OF Technology, Tehran (The best technical school in
 Iran) 9/87-6/92
 B.S. Degree: Electrical Engineering and computer science
 Worked on M.S. degree in Telecommunication engineering

 EXPERIENCE:

 01Communique, Mississauga, Ontario 12/00-Present
 Involved in the development of a web supported version of the
communicating
 Interface
 using Active Server Pages, JavaScript, VB Script and browser
compatibility,
 Visual C++6.0,
 Borland C++, MSMQ, TCP/IP.
 Application increases the Modem compatibility for the wide variety of
 connections.
 It also provides additional capabilities for the desktop version on the
 web.

 American SkySat, Walnut Creek, California 5/00-Present
 * Involved in the development of a web application in Visual InterDev 6.0
 using Active Server
 Pages (ASP), Microsoft E-Commerce, SQL 7.0, XML, Visual C++ 6.0 and
Visual
 Basic 6.0,
 Visual J++ 6.0, COM (ATL), DCOM, JavaScript and VB Script. The web server
 was Microsoft
 Internet Information Server (IIS), Microsoft site server 3.0, with
 Microsoft E-Commerce edition
 3.0 and FrontPage extension running under the NT Server The web
application
 provides NT
 related services online. The user can register and buy services and also
 allows the user to
 troubleshoot and configure a system at real time online. The web site
also
 provides the
 capability of chatting online, customer support online, statistical
 analysis online and transaction
 online.

 * Developed a database management application for a medical health care
 center, using
 Visual Basic 6.0, SQL 7.0, Crystal report and Access 2000. (Windows 98
and
 NT)

 American Computech, Pleasanton, California 3/98-5/00
 Developed different applications using Visual C++, Visual J++, and
Access.

 * Involved in the development of a CRM (Customer Relation Management)web
 application in
 Visual InterDev 6.0 using Active Server Pages (ASP), Microsoft
E-Commerce,
 SQL 7.0, XML,
 Visual Basic 6.0, Visual J++ 6.0, COM, DCOM, JavaScript and VB Script.
 (Windows 98 and
 NT)

 Developed an application in Visual Basic 5.0, Access 97 and Crystal
reports
 (using ODBC) for
 financial analyses department of FHP (Concord, California). The
application
 is capable of
 importing data from other systems, analyzing and processing the data and
 generating hundreds
 of reports base on the original data.

 *Developed an MDI application in Visual C++5,0 and Access 97 for windows
 called ID maker.
 The application is designed to drive a digital camera, capture a picture
 and generate different
 ID cards using OLE (marketing for schools and clubs). The Cannon digital
 camera is controlled
 via DLL functions calls to the camera's driver. The camera is

inserting special characters

2001-02-20 Thread efreyre


Dear Sirs :

Please I would want to konw How I can insert special 
characters into a table, 

Since the " and ' chars are used for delimiting values into 
an insert statement I don´t know how I can put these as part 
the string that I inserting.

I got this putting the data into a file, and then using the 
load data infile... statement, So all has been loaded 
correctly (including the " symbol). But I would want get it 
from the command line with an insert statement directly.

Can someone help me ??

Thank you in advance

Best Regards.
Ernesto







-
Este mensaje fue enviado a través de Qnet
http://www.qnet.com.pe



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: inserting special characters

Add \ in front of special chars.  eg 'I can\'t do this'.  This is explained
in the manual.  Also, some programs have a function that will add it for
you, such as PHP.

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, February 21, 2001 9:24
Subject: inserting special characters

 Dear Sirs :

 Please I would want to konw How I can insert special
 characters into a table,

 Since the " and ' chars are used for delimiting values into
 an insert statement I dont know how I can put these as part
 the string that I inserting.

 I got this putting the data into a file, and then using the
 load data infile... statement, So all has been loaded
 correctly (including the " symbol). But I would want get it
 from the command line with an insert statement directly.

 Can someone help me ??

 Thank you in advance

 Best Regards.
 Ernesto

 -
 Este mensaje fue enviado a travs de Qnet
 http://www.qnet.com.pe

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Compile problems with 3.23.33 on Tru64 4.0G

2001-02-20 Thread Ann Cantelow [EMAIL PROTECTED]


Description:
Two compile problems.  The second one has me stumped.  I am pasting in error
info on both at the end of this form.
Problem #1: snprintf error in client/sql_string.cc.  I substituted sprintf,
hope it's safe.
Problem #2: myisam/mi_open.c has parse error.  I can't find the reason, my C 
skills are poor.

How-To-Repeat:
gnu-make
Fix:
I do not really know if my fix to #1 is safe.  I can't find a fix for #2.

Submitter-Id:  License #7307
Originator:Ann Cantelow, System Admin
Organization:  CSD Internet - www.csd.net
 
MySQL support: Basic licence for ISP's
Synopsis:  2 compile problems for 3.23.33 on Tru64 v4.0G (no patches)
Severity:  critical
Priority:  medium
Category:  mysql
Class: support
Release:   mysql-3.23.33 (Source distribution)
Server: Compile not successful  (Previous: /usr/local/bin/mysqladmin  Ver 7.11 
Distrib 3.22.27, for dec-osf4.0d on alphaev5)
TCX Datakonsult AB, by Monty

Server version  3.22.30-log  ---  I'm trying to replace this with 3.23.33.
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 10 days 1 hour 7 min 22 sec

Threads: 25  Questions: 2970644  Slow queries: 152  Opens: 585  Flush tables: 1  Open 
tables: 63
Environment:

System: OSF1 hermes.csd.net Tru64 V4.0G(no patches) 1530 alpha
Machine: alpha
Some paths:  /usr/local/bin/perl /usr/bin/make /usr/local/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/alphaev56-dec-osf4.0d/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Wrong -- Compilation info: CC='cc -pthread -std1'  CFLAGS='-I./include 
-DDONT_USE_THR_ALARM'  CXX='gcc'  CXXFLAGS='-O3 -DDONT_USE_THR_ALARM'  LDFLAGS= ''
Wrong -- Configure command: ./configure  --with-low-memory 
'--with-named-thread-libs=-lpthread -lmach -lexc'

Above is the 3.22.30-patched version I'm trying to replace.  Current info:

Configure command: ./configure --localstatedir=/usr/local/var/mysql 
--with-unix-socket-path=/usr/var/mysql/tmp/mysql.sock
Compilation info:  How to get this?  These are in Top level Makefile:
CC = gcc
CFLAGS = -O6 -DDBUG_OFF
CPP = gcc -E
CXX = c++ 
CXXFLAGS = -O3 -DDBUG_OFF   -fno-implicit-templates
CXXLDFLAGS =

  Do you need anything else?

Perl: This is perl, version 5.004_04 built for alpha-dec_osf



1) --- in client/sql_string compile 
--
c++ -DUNDEF_THREADS_HACK -I./../include -I../include 
-I./.. -I..-I..-O3 -DDBUG_OFF
   -fno-implicit-templates -c sql_string.cc
In file included from ../include/global.h:186,
 from sql_string.cc:24:
/usr/include/alloca.h:68: warning: declaration of `void * alloca(int)'
/usr/include/alloca.h:68: warning: conflicts with built-in declaration `void * 
alloca(long unsigned int)'
sql_string.cc: In method `bool String::set(double, unsigned int = 2)':
sql_string.cc:182: implicit declaration of function `int snprintf(...)'
gnu-make: *** [sql_string.o] Error 1

    Solution?  This seems to work: -
   Change this:
---
ifdef HAVE_SNPRINTF
  buff[sizeof(buff)-1]=0;   // Safety
  snprintf(buff,sizeof(buff)-1, "%.*f",(int) decimals,num);
#else
---
   To this:
---
ifdef HAVE_SNPRINTF
  buff[sizeof(buff)-1]=0;   // Safety
  sprintf(buff, "%.*f",(int) decimals,num);
#else
---
  
  Looks safe to me because of "Safety" line-- ?

2) - in myisam/mi_open.c compile 

hermes.csd.net gnu-make
gcc -DMAP_TO_USE_RAID -I./../include -I../include -O6 -DDBUG_OFF   -c mi_open.c
In file included from 
/usr/local/lib/gcc-lib/alphaev56-dec-osf4.0d/2.95.2/include/stdarg.h:36,
 from ../include/my_sys.h:42,
 from ../include/my_base.h:29,
 from ../include/myisam.h:27,
 from myisamdef.h:20,
 from fulltext.h:21,
 from mi_open.c:19:
/usr/local/lib/gcc-lib/alphaev56-dec-osf4.0d/2.95.2/include/va-alpha.h:36: warning: 
redefinition of `va_list'
/usr/local/lib/gcc-lib/alphaev56-dec-osf4.0d/2.95.2/include/va_list.h:7: warning: 
`va_list' previously declared here
In file included from fulltext.h:21,
 from mi_open.c:19:
myisamdef.h:202: parse error before `pthread_rwlock_t'
myisamdef.h:202: warning: no semicolon at end of struct or union
myisamdef.h:204: warning: data definition has no type or storage class
myisamdef.h:218: parse error before `MYISAM_SHARE'
myisamdef.h:218: warning: no semicolon at end of struct or union
myisamdef.h:234: `checksum' redeclared as different kind of symbol
../include/my_sys.h:576: previous declaration of

Re: inserting special characters

2001-02-20 Thread Paul DuBois


At 1:24 AM + 2/21/01, [EMAIL PROTECTED] wrote:
Dear Sirs :

Please I would want to konw How I can insert special
characters into a table,

Since the " and ' chars are used for delimiting values into
an insert statement I dont know how I can put these as part
the string that I inserting.

Put a backslash in front of them.

http://www.mysql.com/doc/S/t/String_syntax.html


I got this putting the data into a file, and then using the
load data infile... statement, So all has been loaded
correctly (including the " symbol). But I would want get it
from the command line with an insert statement directly.

Can someone help me ??

Thank you in advance

Best Regards.
Ernesto


--
Paul DuBois, [EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

LOAD_FILE /TEXT

2001-02-20 Thread Richard Vibert


Hi,

I'm storing a text file in a TEXT column using the LOAD_FILE function like 
this:
INSERT ... text_col=LOAD_FILE('filename')

Each line of the orig file ends with char 10.

When I SELECT it like
SELECT text_col INTO OUTFILE 'out_filename' ...


I find that each line has an extra "\" (char 92) inserted as the second 
last char, the last char being char 10.

I've searched through the manual and can't find mention of this, am I 
missing something??

Richard


===
Richard Vibert
[EMAIL PROTECTED]
Tatura Mitre10
===


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: need mysql sample to accomplish existing asp function

- Original Message -
From: "Joe and Nancy M" [EMAIL PROTECTED]
To: "Rolf Hopkins" [EMAIL PROTECTED]
Sent: Tuesday, February 20, 2001 21:04
Subject: Re: need mysql sample to accomplish existing asp function

 Rolf,

 Sorry I worded that email in a confusing manner.

You most certainly were!  Now I get your meaning.

O  |  O
\/

 My ISP told me they supported asp, so I had a friend of mine set up the
asp
 code for me and he tested it on his server.  When I put the code in my
 pages, it did not work.  I called my ISP back and found out the first
person
 was wrong.  They run Unix and DO NOT support asp.

They need to fire the first person you talked to or was he/she just a
secretary and if so, why is he/she answering tech questions?  To not even
know what your own machine is set up with/capable of, geesh!

I'm not surprised that many ISPs don't support asp.  Someone correct me if
I'm wrong, but Chillisoft, the only program I know of that let's you run asp
on unix, costs something like US$1000.

 So, yes... I have to use mysql.  I have no familiarity with mysql and was
 hoping someone could give me a sample chunk of code that makes the
 connection, queries the file and displays the results on the page.
 Something similar to the asp code I showed in my message.

Well now, that depends on what you want to use.  You can use java, php, or
perl and there are others but make sure your ISP supports the language you
choose.  I recommend php as it is the easiest of the three.  Their web site
is www.php.net and www.devshed.com have plenty of examples.  And don't
worry, if you were able to set up a connection in asp, I think you'll find
php a little easier.  That's connection only.

Have you programmed in C before?  If not, you'll get your first taste of C
and you should read the php manual carefully.  For example, if statements
are not as easy as you think and you should take note of the double equal
sign.  A common error for newbies.

 Sorry for the confusion!
 Joe.

 - Original Message -
 From: "Rolf Hopkins" [EMAIL PROTECTED]
 To: "Joe and Nancy" [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Sent: Tuesday, February 20, 2001 12:23 AM
 Subject: Re: need mysql sample to accomplish existing asp function

  I'm confused. You say you are in a time crunch to get mysql working on
 your
  site but you have no mysql connection/code.  You say you coded and
tested
 on
  another site and it works.  If I'm right, that other site had the
Windoze
 OS
  as their web site which of course it work fine...

  ... unlesss ...

  does anyone know if a Microsoft Excel ODBC Driver exists for unix
systems?
  Hahahahaha

  I don't see how Microsoft would even dream of creating such a thing.
Your
  new ISP is probably unix just like the majority of web servers on this
  planet and doesn't know about Microsoft Excel ODBC Drivers.

  My suggestion is that you start looking at MySQL if that's what you are
  going to do or ask your ISP if they have Windoze servers and move across
 to
  that.  They will, of course, need the Microsoft Excel ODBC Drivers.

  Cheers,

  Rolf

  Your mouse has moved.

  Windows NT must be restarted for the change to take effect.

  Reboot now?  [OK]

  - Original Message -
  From: "Joe and Nancy" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, February 20, 2001 12:15
  Subject: need mysql sample to accomplish existing asp function

   I am in a time crunch to get mysql working on my site.  I export
 inventory
   records out of my Peachtree software into Excel and planned to use
that
  .xls
   table to show product pricing and availability on my web pages.  Below
 is
   sample asp code that works.  My ISP had told me they support asp, but
  after
   coding and testing (at another site), I found that my ISP really
doesn't
   support asp.  Can anyone provide a sample chunk of mysql code that
would
  do
   what this asp code does...

   --

   At the top of the page, setting the connection to the .xls (would be
   slightly different for a database connection):

   %@ Language=VBScript %
   %Option Explicit%
   %
'Declare Variables
Dim cnnExcel, rsProduct, strSQL
'Connection Object
set cnnExcel = server.createobject("ADODB.Connection")
cnnExcel.Open "DRIVER={Microsoft Excel Driver (*.xls)};DBQ=" 
   server.MapPath("../catalog.xls")  ";"
'RecordObject
set rsProduct = server.CreateObject("ADODB.recordset")
   %

   Next to each product is this code, it shows the price and qty from the
  file
   and an image with a hyperlink if qty  0:

   %
   'Code for checking inventory
   'SQL
   strSQl = "SELECT * FROM [Sheet1$] WHERE ((([Sheet1$].[Product
   Code])='blizzard'))"
'Open Recordset
   rsProduct.Open strSQl, cnnExcel
   if not rsProduct.EOF then
 Response.Write "Price: $"  rsProduct.Fields("Price").Value 
 "brbr"
 Response.Write "Quantity on Hand: "  rsProduct.Fields("Qty in
   Stock").Value

Newbie Starting MySql

2001-02-20 Thread Weber, Jeff


Having problems starting mysql on my linux box. I think I've tried just
about everything in the manual within reason. Please help out if anyone has
an idea.

The other day, mysql died on my system for no apparent reason. When I reboot
the machine, based on the script in /etc/rc.d/init.d/mysql, mysql should
start up and it does --somewhat. 

Here's the message I get:

[root@myserver mysql]# /etc/rc.d/init.d/mysql start
[root@myserver mysql]# Starting mysqld daemon with databases from
/usr/var/mysql

And it shows up in the process list below...
root  5340  0.0  0.3  1668  828 pts/0S21:23   0:00 sh
/usr/bin/safe_
mysql 5365  0.0  0.4  3308 1176 pts/0S21:23   0:00
/usr/sbin/mysqld
mysql 5366  0.0  0.4  3308 1176 pts/0S21:23   0:00
/usr/sbin/mysqld
mysql 5367  0.0  0.4  3308 1176 pts/0S21:23   0:00
/usr/sbin/mysqld

And it logs it to my /usr/var/mysql/server.log as:

/usr/sbin/mysqld, Version: 3.23.21-beta-log, started with:
Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
Time Id CommandArgument

But any commands I send to mysql or mysqladmin hangup and nothing ever
happens. I then have to kill -9 to force it to stop.

So now I manually go in and start it, as root with safe_mysqld. Here's what
I get:

[root@myserver mysql]# safe_mysqld
kill 4212: No such process
Starting mysqld daemon with databases from /usr/var/mysql
mysqld daemon ended

It tries to kill a process, but there is no process in the list!

This seems to start it, but then, any commands I send to it just hang the
app. I know that the socket is being created (I've seen the zero K file).

If I just try to run mysql from command line I get this:

[root@myserver mysql]# mysql
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/m
ysql.sock' (111)

One thing I have to consider is some recent DNS work I did. Is it possible
DNS could cause these problems?

I'm really at a loss here. Any help is greatly appreciated.

Thanks,

Jeff


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem in a particular Query

2001-02-20 Thread anirban roy


we have two tables
1. servicecntr_nm
 comp_cod int(11)
 service_nm varchar(70)
 city_cod varchar(13)
 addr varchar(100)
 pin int(11)
 contact varchar(70)
 serv_cod varchar(30)
2.service_prod_index
 serv_cod varchar(30)
 prod_no varchar(20)
 

now our aim is to find out all the service_nm that
have
match the city_cod of table 1 and all those all those 
serv_cod that have a particular prod_no of  table2

we tried this query:
select servicecntr_nm.service_nm from servicecntr_nm
t1,service_prod_index t2 where (t1.serv_cod=(select
t2.serv_cod from t2 where t2.prod_no=11) and
(t1.city_cod='in000501');
the error message is 1064 syntax error in the nested
sql query

hope you would help,
Regards,
Anirban Roy




__
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: need mysql sample to accomplish existing asp function


Rolf Hopkins ([EMAIL PROTECTED]) writes:

 Well now, that depends on what you want to use.  You can use java, php, or
 perl and there are others but make sure your ISP supports the language you
 choose.  I recommend php as it is the easiest of the three.  Their web site
 is www.php.net and www.devshed.com have plenty of examples.  And don't
 worry, if you were able to set up a connection in asp, I think you'll find
 php a little easier.  That's connection only.

plug
Escapade is *much* easier to learn than PHP.  Drop the engine in your cgi-bin, and 
you're ready to rock and roll.
/plug


--
Ed Carp, N7EKG  [EMAIL PROTECTED]   940/367-2744 cell phone
http://www.pobox.com/~erc   [EMAIL PROTECTED] - text pager

I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Comment field of a table


Fethiye Akbulut ([EMAIL PROTECTED]) writes:

 I would like to see if all the tables in my database have the "comment" 
 field equal to a given value. I understand that "show table status" command 
 is able to show us the "comment" field's value. I was wondering how we can 
 extract only this field when we do conduct our queries from a mysql client 
 or a program written in tcl/tk and/or perl?

If you play with it a little, you'll find that running "show columns from table" 
returns a recordset, just like a select statement, and you can search for your 
comments that way.  Very convenient :)

--
Ed Carp, N7EKG  [EMAIL PROTECTED]   940/367-2744 cell phone
http://www.pobox.com/~erc   [EMAIL PROTECTED] - text pager

I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Broken Select/Join


Johnny Withers ([EMAIL PROTECTED]) writes:

 I have recently upgraded from MySQL 3.22.27 to 3.23.33.
 I'm running Redhat Linux 6.1 on a p2 300 w/128MB of ram.
 
 The following select statement worked fine in mysql 3.22.27:
 
 SELECT supplier.id,subcatsicbond.sub_catid,subcatsicbond.siccode
 FROM subcatsicbond
 LEFT JOIN suppliersiclink ON subcatsicbond.siccode=suppliersiclink.sic_code
 LEFT JOIN supplier ON suppliersiclink.sup_id=supplier.id
 WHERE ((subcatsicbond.sub_catid=20) AND (supplier.max_latitude=32.99) AND
 (supplier.min_latitude=31.55) AND (supplier.min_longitude=89.25) AND
 (supplier.max_longitude=90.97))
 ORDER BY supplier.company_name ASC LIMIT 0,10;

FWIW, I had the same problem - I just re-wrote my queries: "select blah from table1, 
table2, table3 where table1.field=table2.field ..."

I'm sure I'm doing something wrong, but I haven't had time to dig in and figure it out.
--
Ed Carp, N7EKG  [EMAIL PROTECTED]   940/367-2744 cell phone
http://www.pobox.com/~erc   [EMAIL PROTECTED] - text pager

I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

how to define the space of mysql user?

2001-02-20 Thread yindu


since mysql have no limit with database.i can only limit the space in Filesystem 
quotas.
but i didn't know the filesysterm about mysql database.where are them?is there any 
documents about this?

Connection errors

2001-02-20 Thread Higgins, Kyle


010220 19:27:11  Aborted connection 21199 to db: 'vlndb' user: 'root' (Got
an error reading communication packets))

Has anyone experienced this error in MySQL and do you know what it means?


Kyle Higgins
USCO Logistics
UNIX Manager
Email:  [EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Problem in a particular Query


Sub selects are not yet supported.  Please read the manual.  A normal query
should also do the trick as well.

 select t1.service_nm from servicecntr_nm
 t1,service_prod_index t2 where t1.serv_cod=t2.serv_cod and t2.prod_no=11
and
 t1.city_cod='in000501';

- Original Message -
From: "anirban roy" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 21, 2001 10:43
Subject: Problem in a particular Query


 we have two tables
 1. servicecntr_nm
  comp_cod int(11)
  service_nm varchar(70)
  city_cod varchar(13)
  addr varchar(100)
  pin int(11)
  contact varchar(70)
  serv_cod varchar(30)
 2.service_prod_index
  serv_cod varchar(30)
  prod_no varchar(20)


 now our aim is to find out all the service_nm that
 have
 match the city_cod of table 1 and all those all those
 serv_cod that have a particular prod_no of  table2

 we tried this query:
 select servicecntr_nm.service_nm from servicecntr_nm
 t1,service_prod_index t2 where (t1.serv_cod=(select
 t2.serv_cod from t2 where t2.prod_no=11) and
 (t1.city_cod='in000501');
 the error message is 1064 syntax error in the nested
 sql query

 hope you would help,
 Regards,
 Anirban Roy




 __
 Do You Yahoo!?
 Yahoo! Auctions - Buy the things you want at great prices!
http://auctions.yahoo.com/

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: LOAD_FILE /TEXT

Yes, you have missed something.  Somewhere into chapter 7 of the manual,
can't remember exactly where off the top of my head, it talks about adding
backslashes.  It is to do with inserting text.  It is required for special
characters.

- Original Message -
From: "Richard Vibert" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 21, 2001 9:53
Subject: LOAD_FILE /TEXT

 Hi,

 I'm storing a text file in a TEXT column using the LOAD_FILE function like
 this:
 INSERT ... text_col=LOAD_FILE('filename')

 Each line of the orig file ends with char 10.

 When I SELECT it like
 SELECT text_col INTO OUTFILE 'out_filename' ...

 I find that each line has an extra "\" (char 92) inserted as the second
 last char, the last char being char 10.

 I've searched through the manual and can't find mention of this, am I
 missing something??

 Richard

 ===
 Richard Vibert
 [EMAIL PROTECTED]
 Tatura Mitre10
 ===

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: importing access db to mysql


Rolf Hopkins ([EMAIL PROTECTED]) writes:

 Try http://www.accessmysql.com/

Oh.  Yet another person trying to sell you something that can be downloaded freely 
elsewhere.  yawn

Try http://www.mysql.com/downloads/gui-clients.html

Oh, sorry, that didn't answer the original poster's question, but I don't think 
http://www.accessmysql.com does, either (no offense intended, Rolf!).  Hmmm... try 
http://www.mysql.com/downloads/contrib.html - I'm sure you'll find more than one 
package that will fit your needs.

Actually, the easiest thing I've found is to use ExportSQL (free) to generate MySQL 
statements, then feed the resulting file to MySQL.
--
Ed Carp, N7EKG  [EMAIL PROTECTED]   940/367-2744 cell phone
http://www.pobox.com/~erc   [EMAIL PROTECTED] - text pager

I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: ranking album plays by city, help me beat Oracle

2001-02-20 Thread S A



 Huh? You got it 7 times faster by only extracting that query from the

 for loop and changing it to a group by? Or did you do anything else?


Sorry there were some other unnecessary queries that were mistakenly in the 
measurement.. 


Here is the missing EXPLAIN.

mysql EXPLAIN SELECT same_album_id, SUM(td_num) FROM album_by_metro
- WHERE metro = 'Atlanta' AND rpt_dt = '2001-01-01' AND
- rpt_dt = '2001-02-14'
- GROUP BY same_album_id HAVING SUM(td_num)  500
- ;
++---++-+---
--+--+--+-+
| table  | type  | possible_keys  | key | ke
y_len | ref  | rows | Extra   |
++---++-+---
--+--+--+-+
| album_by_metro | range | rpt_dt,album_by_metro_idx2 | album_by_metro_idx2 |
  103 | NULL | 8925 | where used; Using temporary |
++---++-+---
--+--+--+-+
1 row in set (0.00 sec)

Sorry I tried the below suggested query but it it is much slower at 1min 30 secs 
probably because it ranks all albums for all metros rather than just working on the 
rank of one album over the metros.

SELECT metro, same_album_id, SUM(td_num) AS played
FROM album_by_metro
WHERE rpt_dt = '$BeginDate' AND rpt_dt = '$EndDate'
GROUP BY metro, same_album_id
HAVING SUM(td_num)  $MIN_SUM
ORDER BY metro, same_album_id, played DESC

Here is the explain for the above query :

 

mysql EXPLAIN SELECT metro, same_album_id, SUM(td_num) AS played
- FROM album_by_metro
- WHERE rpt_dt = '2001-01-01' AND rpt_dt = '2001-02-14'
- GROUP BY metro, same_album_id
- HAVING SUM(td_num)  1000
- ORDER BY metro, same_album_id, played DESC;
++---+---++-+--++---
---+
| table  | type  | possible_keys | key| key_len | ref  | rows   | Ex
tra|
++---+---++-+--++---
---+
| album_by_metro | index | rpt_dt| rpt_dt | 161 | NULL | 716943 | wh
ere used; Using index; Using temporary; Using filesort |
++---+---++-+--++---
--+


Can this faster approach below which in a loop queries the # of albums with  sums be 
optimized to be a single query. ?

 foreach ($metros as $metro)
 {
  $V_SUM = $V_SUMS[$metro];

  $query = "SELECT same_album_id, SUM(td_num) FROM album_by_metro
WHERE  metro = '$metro' AND rpt_dt = '$BeginDate' AND rpt_dt = '$EndDate'
  GROUP BY same_album_id HAVING SUM(td_num)  $V_SUM";
}

Thanks for all your help  interest.

- Sam.

  Benjamin Pflugmann [EMAIL PROTECTED] wrote: 
Hello.

On Fri, Feb 16, 2001 at 03:58:20PM -0800, [EMAIL PROTECTED] wrote:
 
 This is the latest approach we're using now. It turns out that the
 query to get Total Plays for an Album per City can be taken out of
 the City for loop  done only once as a GROUP BY. The worst case
 time for MySQL is now 16 seconds compared to Oracle's 8 seconds.

Huh? You got it 7 times faster by only extracting that query from the
for loop and changing it to a group by? Or did you do anything else?

Well, because the column "range" is not used in any of both queries,
normally only the indexes "album_by_metro_idx1/2" are used. As I said
last time, maybe the indexes could be more specific for the query.
Your change now uses idx2 and has the advantage, that all metros it
matches are really used, therefore the index is now okay for the new
query. Before, it was reading all metros in, although it was only
using one.

If you want to try, it would be interesting, what the time for the old
query in the for loop is, when you have an index on
(same_album_id,metro,rpt_dt). Anyhow, your new solution surely is
faster (avoiding communition overhead for about 100 queries).

 $query = "SELECT metro, sum(td_num) FROM album_by_metro
 WHERE same_album_id = $album
 AND rpt_dt = '$BeginDate' AND rpt_dt = '$EndDate'
 GROUP BY metro"; 
 $start = time(); 
 $result = mysql_query($query) or die ("Can't get $query" . mysql_error()); 
 
 while ($row = mysql_fetch_array($result)) 
 { 
 $metro = $row[0]; 
 $metros[] = $metro; 
 $V_SUMS[$metro] = $row[1];
 }
 // while 
 mysql_free_result($result); 
 // 
 foreach ($metros as $metro)
 {
 $V_SUM = $V_SUMS[$metro]; 
 $query = "SELECT same_album_id, SUM(td_num) FROM album_by_metro
 WHERE metro = '$metro' AND rpt_dt = '$BeginDate' AND rpt_dt = '$EndDate'
 GROUP BY same_album_id HAVING SUM(td_num)  $V_SUM";

This will use index album_by_metro_idx2, which already should be the
best

Re: MySQL Tables

I think you'll get better results if you don't quote your numbers.  Quotes
should be used for text and dates (depending) but not numbers.

- Original Message -
From: "Arturo Busleiman" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 21, 2001 11:54
Subject: MySQL Tables

 These are the commands I'm currently using to build the MySQL tables
 used/needed by a program I'm doing:

 What is wrong here that an INSERT ('2','2','1','test',NULL)
 generates:

 | 33554432 | 33554432 |   1 | test| 20171221080222 |

 the 33554432 shouldn't be 2's? anything other than INT works WELL (and the
 3rd column's a TINYINT, whereas the other two are INT's)

 why the third column is OK?

 CREATE TABLE msg (
 f INT UNSIGNED,
 t INT UNSIGNED,
 mt TINYINT UNSIGNED,
 md BLOB,
 mdt TIMESTAMP,
 INDEX (t)
 );

 * MP3's EN VIVO de INFUSION: http://members.xoom.com/sysfork/
 * MP OnLine? EL BBS? FeedBack? - System Fork!!! 4799-2510 TLD 24hs
 * El sexo es como el Hacking. Entras, salis y esperas no haber dejado
 * nada por lo que puedan rastrearte.
 * Panic? My kernel doesn't panic! We are doomed! DustDustDust

  Yahoo! Groups Sponsor -~-~
 eGroups is now Yahoo! Groups
 Click here for more details
 http://us.click.yahoo.com/kWP7PD/pYNCAA/4ihDAA/stAVlB/TM
 -_-

 To unsubscribe from this group, send an email to:
 [EMAIL PROTECTED]

 Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)

 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
[EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL Tables

2001-02-20 Thread Arturo Busleiman


On Wed, 21 Feb 2001, Rolf Hopkins wrote:

 I think you'll get better results if you don't quote your numbers.  Quotes
 should be used for text and dates (depending) but not numbers.
tried, but same results.


* MP3's EN VIVO de INFUSION: http://members.xoom.com/sysfork/
* MP OnLine? EL BBS? FeedBack? - System Fork!!! 4799-2510 TLD 24hs
* El sexo es como el Hacking. Entras, salis y esperas no haber dejado
* nada por lo que puedan rastrearte.
* Panic? My kernel doesn't panic! We are doomed! DustDustDust


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

BDB Tables

2001-02-20 Thread Cory Whitesell


I am experimenting with MySQL for both Linux and Windows 2000. The trouble is, I do 
not Have Visual C to compile the BDB code under Windows 2K. Is there any place to 
download them for Windows 2000 in a binary form? Or is there somebody who can compile 
them for me?

Re: MySQL Tables