date:20030208

Re: Is it my English or does this sound bad?

2003-02-08 Thread Michael T. Babcock

Zak Greant wrote:


 Heh. There are still some gems like this in the manual.:)

 I have let our documentation team know about the awkward wording.
 


Just use the term gender instead of sex and everyone will be happy :-)

(Esp. the people searching for 'animal sex' on Google ...)

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd. SQL.
http://www.fibrespeed.net/~mbabcock



-
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: hang then resume....

2003-02-08 Thread pazenko

bump?

The content of this email when sent is as full as practical. Due to the
settling of the words the contents might not appear as full as it was but
the weight remains the same. The contents is being sent by weight and not by
volume.
- Original Message -
From: pazenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 05, 2003 7:27 AM
Subject: Re: hang then resume

the whole program halts by itself, this is how my software work

* form loads, then i open a connection, then i close connection but not
terminating it to be use later
* the user click the 'add' button, all related textbox will be enabled.
* the user type in all the details, while typing the the user experience a
temporary halt of the program for about 2secs then it resumes(random)
* the user click the button save, i open the connection then execute
'Insert' command then the record is save, then i close the connection.
* upon exit of the program i terminate the connection

before and after halt of the program i'm not requesting any large query from
the db server

lewell

The content of this email when sent is as full as practical. Due to the
settling of the words the contents might not appear as full as it was but
the weight remains the same. The contents is being sent by weight and not by
volume.
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
To: 'pazenko' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, February 05, 2003 7:12 AM
Subject: RE: hang then resume

What type of 'hang' are you reporting? Have you checked the processlist to
see if the connection is processing a request? Are you returning a large
result set that needs to be displayed?

-Original Message-
From: pazenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 04, 2003 7:43 AM
To: [EMAIL PROTECTED]
Subject: hang then resume

i'm currently developing a software using vb6 and mysql 4.0 the problem is
i'm getting a random hang from the software i develop, the hang last for
about 2 seconds or more and then it resumes again. my test environment is
win98se and the production environment is also win98. the hang symptoms also
appear on the production evironment. does anyone have experience this kind
of behaviour?

lewell

The content of this email when sent is as full as practical. Due to the
settling of the words the contents might not appear as full as it was but
the weight remains the same. The contents is being sent by weight and not by
volume.

-
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

-
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 help with GROUP BY

2003-02-08 Thread Paul DuBois

At 9:24 -0600 2/5/03, Jaime Teng wrote:

I have a MySQL table:

++--+--+-+-++
| Field  | Type | Null | Key | Default | Extra  |
++--+--+-+-++
| id | int(10) unsigned |  | PRI | NULL| auto_increment |
| account| varchar(10)  |  | MUL | ||
| detail | text | YES  | | NULL||
++--+--+-+-++


I would like to perform a search,

SELECT id,account FROM tablename WHERE detail LIKE '%pattern%';

However, this would produce several hits for a single account.
I'd like it to produce only one hit *per* account and give me
id where '%pattern%' was found and account where it was found on.
It should only return *one* result per account.


Hmm...

Either I am not understanding what you are saying, or what you are
saying makes no sense: If there are two id values for a given account
that have detail values matching the pattern, which id do you want
it to display?



regards,
Jaime


sql, query

-
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: Using SET in the INSERT statement

2003-02-08 Thread Paul DuBois

At 14:19 +1000 2/5/03, boclair wrote:

I notice some of my colleagues using SET in INSERT statements.

DuBois makes a short reference on  p565, DoorStop1.


The reference is short because there isn't much to say about it. :-)
The SET clause consists of col_name=value assignments, separated
by comma if there is more than one assignment.  That's all.

Other examples are on pp 40-41 (Doorstop I) or p48 (Doorstop II).



The Manual has some mention in http://www.mysql.com/doc/en/SET.html

I sort of get it  but I am looking for a fuller explanation.

Louise



-
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

A query construction problem

2003-02-08 Thread Blaster

I can't think of a way to do this, any help is appreciated =)

Imagine the following tables

table usr (holds all users)
id (int) | name (varchar)

table clanlist (holds all clans)
id (int) | name (varchar)

table clanmembers (holds all members of all clans)
uid (int, points to a user in usr) | cid (int, points to a clan in 
clanlist)

You might wonder why I don't simply add a clan field to the user table, and 
I can't
since a user can be in any number of clans at the same time.

table tour_competitors
id (int) | cid (points to a clan in clanlist) |

table tour_players
pid (int, points to a tour_competitors row) | uid (points to a row in 
table usr)

Now, the problem:

I want to select each row from table tour_players and get the following info:

tour_players.pid | usr.name | clanlist.name

clanlist.name relates to usr.name via

tour_players.pid = tour_competitors.id and tour_competitors.cid = clanlist.id

I've worked with this problem a loong time now, mysql only returns 0 rows 
on my queries, so I'm doing something
veeery wrong. If any of you have a thought on how to restructure these 
table for easier use, any suggestion is
welcome, however i can't possibly think of a layout which will provide me 
with the same flexibility.

thanks in advance!




-
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: apostrophe and comma error on submit

2003-02-08 Thread Bryant Hester

You need to delimit them:

INSERT INTO table VALUES ('value','Don\'t know','');

If you're inserting via PHP, you need to add a backslash before
apostrophes or commas in the post data, as apostrophes and commas are
used by MySQL to delimit fields on INSERT statements.

It's also in the manual, somewhere

HTH,
Bryant Hester

Mysql, query

-Original Message-
From: ahimsa [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 05, 2003 11:43 AM
To: [EMAIL PROTECTED]
Subject: apostrophe and comma error on submit


Does anyone know about an error that occurs when you try to submit into
mysql. 
Whever i try to imput any text with a  comma in it or an appostrophe, i
get an error until i remove it. 
Any suggestions. .. anyone...? Im using php  and submiting via post,
when i get the error. Thank you so much for your time. Leeann

-
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

converting MS SQL to MySQL

2003-02-08 Thread Hawk



Hi,

I am new to SQL.  I am attempting to create a database that was created in 
MS SQL to MySQL.  The below SQL statements works with MS SQL.

I am executing the following:

CREATE TABLE 'Accounting'(
'Username' VARCHAR(254) NULL,
'CallerID' VARCHAR(128) NULL,
'Addr' VARCHAR(128) NULL,
'NAS' VARCHAR(128) NULL,
'Port' VARCHAR(128) NULL,
'Start' DATETIME NULL,
'Stop' DATETIME NULL,
'SessionTime' INTEGER DEFAULT 0,
'ExtraTime' INTEGER DEFAULT 0,
'TimeLeft' INTEGER DEFAULT 0,
'KBytesIn' INTEGER DEFAULT 0,
'KBytesOut' INTEGER DEFAULT 0,
'SessionKB' INTEGER DEFAULT 0,
'ExtraKB' INTEGER DEFAULT 0,
'KBytesLeft' INTEGER DEFAULT 0,
)
GO

CREATE INDEX IX_Username ON Accounting(Username)  MySQL will 
not take this command
GO

CREATE TABLE 'ActiveUsers'(
'UserID' VARCHAR(254) PRIMARY KEY,
'NAS' VARCHAR(128) NULL,
'Port' VARCHAR(128) NULL,
'Username' VARCHAR(254) NULL,
'CallerID' VARCHAR(128) NULL,
'Address' VARCHAR(128) NULL,
'LoginTime' DATETIME NULL,
)
GO

CREATE TABLE 'TAC_GRP'(
'TAC_ID' VARCHAR(254) NOT NULL,
'TAC_Attr' VARCHAR(64) NOT NULL,
'TAC_Val' TEXT NULL
)
GO

CREATE UNIQUE INDEX IX_TAC_ID ON TAC_GRP(TAC_ID, TAC_Attr)   MySQL 
will not take this command
GO

CREATE TABLE 'TAC_USR'(
'TAC_ID' VARCHAR(254) NOT NULL,
'TAC_Attr' VARCHAR(64) NOT NULL,
'TAC_Val' TEXT NULL
)
GO

CREATE UNIQUE INDEX IX_TAC_ID ON TAC_USR(TAC_ID, TAC_Attr)  MySQL will 
not take this command
GO


Thanks in advance. 

---
[This E-mail scanned for viruses by Friend.ly.net.]


-
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: Data being not inserted in the table inspite of success from mysql

2003-02-08 Thread Dan Nelson

In the last episode (Feb 05), [EMAIL PROTECTED] said:
 create  table if not exists CBI (date DATE not null, close DECIMAL(10,2), high 
DECIMAL(10,2), low DECIMAL(10,2), volume MEDIUMINT, yest DECIMAL(10,2), PRIMARY KEY 
date (date))
  Query OK, 0 rows affected (0.00 sec)

 insert ignore into CBI 
Values('2003-02-05','31.2000','31.3500','31.0500','350','31.3500')
  Query OK, 1 row affected (0.02 sec) == 1 row is added

 select * from   CBI where date='2003-02-05'
  Empty set (0.00 sec)

Works for me on mysql 4.0.9.  What does select * from CBI print?

-- 
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: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)

2003-02-08 Thread Aman Raheja

HINT:
I have used PERL to generate random numbers and then do a SELECT on the
auto_increment field in the mysql table, thus generating random picks from
my tables;
I'll be glad to bet informed of better ways around, though :)

Thanks
Aman Raheja
AGF Inc.

- Original Message -
From: Tue Tønning [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 05, 2003 1:38 PM
Subject: RAND() Problems in mysql version 3.23.54 and 3.23.55 (linux)


 Hey,

 I have discovered a strange error in the mysql versions mentioned in subj.

 Example.
 A table with 10 entries ...i want to draw 3 randomly
 = select fieldName from tableName order by RAND() limit 3

 this have worked for the last year or so.but after upgrading our
redhat
 7.2 with mysql version 3.23.54 it stopped to work. It always chooses the
 same 3 entires.

 using a Seed doesnt make it perfect either (i know that the manual says
that
 RAND() isnt perfect - but now it doesnt work at all).

 A quick search on google says me that im not the only one having the
 problem. I can also see on some Danish messageboards that other have the
 same problems with the new version.

 So my question is .What to do ?
 I cant imagine that you have removed the functionality of RAND from mysql
 again ?
 i know its only been in there since early ~3.23

 I work professionally as a webdevolper (CEO of a firm) and we need to find
a
 solution to this problem badly.

 I hope you can guide me to a solution. Cause i would hate to change all
the
 sql calls in the projects we have coded the last 1½ year and it would
be
 nice to know if we would be able to use RAND() in the future.

 Ohh, yeah - we code in PHP..and i have talked today with 3 other
 webdevelopment companies that have been struggeling with the same error
 after upgrading.

 Med venlig hilsen / Best regards

 Tue Tønning
 
 AT-Orbital I/S
 Helsingforsgade 27, 1
 DK-8200 Aarhus N
 Denmark
 Phone +45 8942 5860
 Web   www.atorbital.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

InnoDB foreign keys bug

2003-02-08 Thread Scott Wong


Version: Mysql  4.0.10-gamma

Description: Innodb fails to follow the foreign key rules after alter table.
This bug can be done in several ways.

How to repeat

These variations gives same errors.
1st bug example:

drop table if exists parent;
drop table if exists child;
CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id),
 FOREIGN KEY (parent_id) REFERENCES parent(id)
 ON UPDATE CASCADE
) TYPE=INNODB;
insert into parent set id = 1;
insert into child set id=1, parent_id=1;
alter table child add   FOREIGN KEY (`parent_id`) REFERENCES `test.parent` (`id`)  ON 
DELETE CASCADE ;
update parent set id=2 where id=1;
gives :ERROR 1217: Cannot delete or update a parent row: a foreign key constraint fails

end 1st bug.

Variations of this bug :

drop table if exists parent;
drop table if exists child;
CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id),
 FOREIGN KEY (parent_id) REFERENCES parent(id)
 ON DELETE CASCADE
 ON UPDATE CASCADE
) TYPE=INNODB;
insert into parent set id = 1;
insert into child set id=1, parent_id=1;
alter table child add   FOREIGN KEY (`parent_id`) REFERENCES `test.parent` (`id`)  ON 
UPDATE CASCADE ;
update parent set id=2 where id=1;
ERROR 1217: Cannot delete or update a parent row: a foreign key constraint fails
delete from parent;

The intesting thing is this :

show create table child;
  FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON UPDATE CASCADE,
  FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON DELETE CASCADE ON UPDATE 
CASCADE


fix
?


Thank you for your time

Scott Wong
Meiko America, INC






-
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

[] .....???

2003-02-08 Thread





[±¤°í] ³¿»õ ¶§¹®¿¡ ºÒÆíÇÑ.???
 
¾ÇÃëÁ¦°Å. °õÆÎÀÌ±Õ ¹ß»ýÁ¦°Å. °¢Á¾ ¼¼±Õ ¾ïÁ¦. ½Å¼±µµ Áö¼ÓÀû À¯Áö. ÀÎÃ¼¿¡´Â ÀüÇô ¹«ÇØÇÑ 
Ãµ¿¬ Ç×±Õ ¾ÇÃë Á¦°ÅÁ¦.
  
1.  ½Ç³» ´ã¹è ³¿»õ ¹× ¼ú ³¿»õ ±âÅ¸ À½½Ä ¸ðµç³¿»õ.
2.  ³ÃÀå°í ³¿»õÁ¦°Å ¹× ½ÄÇ° ½Å¼±µµ Áö¼Ó À¯Áö.
3.  ¿ÊÀå ¼Ó¿¡ °õÆÎÀÌ ³¿»õ Á¦°Å ¹× °õÆÎÀÌ ±Õ Á¦°Å  ¾ïÁ¦.
4.  ÁÖ¹æ »ý¼± Æ¢±è ³¿»õ. µÈÀå ¹× Ã»±¹Àå ³¿»õ Áï½Ã Á¦°Å ¹× °¢Á¾ ¼¼±Õ Á¦°Å  
¾ïÁ¦.
5.  ÈÀå½Ç ³¿»õ Á¦°Å ¹× °õÆÎÀÌ ±Õ Á¦°Å  ¾ïÁ¦..
6.  ½Å¹ßÀå ¾ÇÃë Á¦°Å ¹× ¹ß³¿»õ Á¦°Å ¹«Á»±Õ. Á¦°Å ¹× ¾ïÁ¦...
 
  
  È¨ ÆäÀÌÁö : www.89894.com
 
  
7.  ½Ç³» °¢Á¾ ¾ÇÃëÁ¦°Å ¹× ¶¡³¿»õ. ÄûÄûÇÑ ³¿»õ Á¦°Å.  °õÆÎÀÌ ±Õ Á¦°Å ¹× ¾ïÁ¦..
8.  °íÃþ°Ç¹°ÀÇ °øÁ¶±â ´ÚÆ®³»ÀÇ ¾ÇÃëÁ¦°Å ¹× °¢Á¾ °õÆÎÀÌ ±Õ Á¦°Å  ¾ïÁ¦.
9.  °¢Á¾ µ¿¹°ÀÇ ºÐ´¢ ³¿»õ ¹×  ¾ÇÃëÁ¦°Å  ³¿»õ Á¦°Å..

¿Í»çºñ ¿ø¾× ¹× ÈÖµçÄ¡µå ¼ººÐÀº ¼ø¼ö Ãµ¿¬ÀÚ¿¬ ¿ø·á·Î¼ »ç¶÷¿¡°Ô ÀÚ¿¬ Ä£ÈÀû Á¦Ç°À¸·Î 
ÀÎÃ¼¿¡´Â ÇØ°¡ ÀüÇô¾ø½À´Ï´Ù¡¦
 
»ó¼¼ÇÑ Á¤º¸¿Í Á¦Ç°Àº ±ÍÇÏÀÇ °Ç°À» È®½ÇÇÏ°Ô ÁöÄÑµå¸±°ÍÀÔ´Ï´Ù..
  
 ¹®´Ü¼Ó °èÀý,
 
¸î°¡Áö¸¸ ÁØºñÇÏ¸é ÄèÀûÇÑ »ýÈ° È¯°æÀ» ¾ðÁ¦³ª À¯ÁöÇÒ ¼ö ÀÖ½À´Ï´Ù...
 
  
»çÀÌÆ® :  www.89894.com   
 
   ³¿»õ/¾ÇÃë¾ø´Â³ª¶ó   ±â´Éº° ³ª´®ÀÌ   ¼ø¼ö ÀÚ¿¬»ê Ãµ¿¬ ¿ø·á Á¦Ç° 
¾È¿¡ ±×¸°¿¡¾î  Áê´Ï¾î ÈÑ¹Ð¸®, ÀÚµ¿¼¾¼ ½ºÇÁ·¹ÀÌ ±â°è(¿Í»è½º)µîµî
  
Ãß»ç  : Á¦Ç°À» ±¸¸ÅÇÏ½ÅºÐÀº ¹«ÇÑµ¿·Â »çÀÌÆ®(cafe/daumnnet/106030)¿¡¼ Ä«Å×°í¸® ¶õ¿¡ 
À¯·áÈ¸¿ø À» Å¬¸¯ÇÏ½Ã°í 1¹øÇ×À» º¸½Å´ÙÀ½ À¯·áÈ¸¿øÀ» µî·ÏÇØÁÖ½Ã¸é ÈÄÀÏ ¹«ÇÑ 
µ¿·Â °³¹ß ¿Ï·áÈÄ Ã¢¾÷½Ã Ã¢¾÷ ÁÖÁÖ·Î µî·Ï ÇÏ½Ç¼öÀÖ´Â ¿ì¼±±ÇÀÇ ±âÈ¸¸¦ µå¸³´Ï´Ù¡¦.. 
  
»óÈ£  :  ¼îÇÎ¸ô
 
È¨ ÆäÀÌÁö : www.89894.com
 
e-mail : [EMAIL PROTECTED]
 
   hp : 011-281-1434
  
 
°¨»çÇÕ´Ï´Ù
 
   ^^**^^   ²Ù ~ ¹÷  ^^**^^
 
 



_
±ÍÇÏÀÇ ÀÌ¸ÞÀÏÁÖ¼Ò´Â ÀÎÅÍ³Ý¼ÇÎÁß(http://www.mysql.com) ¾Ë°ÔµÇ¾úÀ¸¸ç, ¸ÞÀÏÁÖ¼ÒÀÌ¿ÜÀÇ 
¾î¶°ÇÑ Á¤º¸µµ °¡Áö°í ÀÖÁö ¾Ê½À´Ï´Ù. ¸ÞÀÏ¼ö½ÅÀ» ¿øÇÏÁö ¾ÊÀ»°æ¿ì ¾Æ·¡¸¦ Å¬¸¯ÇÏ¿© ¸ÞÀÏÀ» 
º¸³» ÁÖ½Ê½Ã¿ä.. °¨»ç ÇÕ´Ï´Ù. If you feel that this information is not what you want, 
please click below to send email me requesting to be removed. Thank you, and we 
apologize for any inconvenience.
mailto:[EMAIL PROTECTED]?subject=REMOVEbody=Remove:[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: Applications for creating reports for MySQL

2003-02-08 Thread Octavian Rasnita

I want to create reports that can be printed to a printer, select a font and
a size for each field, etc.
Perl and PHP can't do that.

Well, perl could do that if using a post script printer... but I don't have
such a printer and it is very hard to do it anyway.

Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]

- Original Message -
From: Joshua J.Kugler [EMAIL PROTECTED]
To: Octavian Rasnita [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED]
Sent: Thursday, February 06, 2003 12:08 AM
Subject: Re: Applications for creating reports for MySQL


 How much work do you want done for you?  Perl and Python are great apps
for
 writing MySQL reports, and you can output all the report to a text file,
 which would be great for a reader.  But as report applications, can't
help
 you there.

 Sorry.

 j- k-

 On Tuesday 04 February 2003 09:10, Octavian Rasnita wrote:
  Hi all,
 
  Does anyone know a program for Windows that can create reports for MySQL
  databases?
 
  If you know more, please tell me more, because I need to check which of
  them are accessible for the blind.

 --
 Joshua Kugler, Information Services Director
 Associated Students of the University of Alaska Fairbanks
 [EMAIL PROTECTED], 907-474-7601



-
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: Applications for creating reports for MySQL

2003-02-08 Thread Octavian Rasnita

Yes I have a question regarding Crystal Reports, but ... I don't know if you
can help me.
I am blind and I would like to know if this program has an interface
accessible for a screen reader.

Thank you.

Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]

- Original Message -
From: Scott Pippin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, February 06, 2003 5:42 PM
Subject: Re: Applications for creating reports for MySQL


 Does anyone know a program for Windows that can create reports for
 MySQL databases?

 Check out Crystal Reports
 http://www.crystaldecisions.com
 or
 ReportMill
 http://www.reportmill.com

 hope these help.  We use Crystal Reports.  If you have any questions
 about crystal please let me know.
 (query, sql)

 Scott Pippin
 [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: InnoDB foreign keys bug

2003-02-08 Thread Heikki Tuuri

Scott,

I would like to declare this as a 'feature'. You should not define multiple
foreign key constraints on the same foreign key/referenced key pair.

I could, of course, add an error message if someone tries to do that.

The algorithm in ON UPDATE CASCADE and ON DELETE CASCADE is this: InnoDB
takes a single declared constraint, tries to update or delete child rows as
instructed in that constraint, and checks that other constraints are
satisfied.

Also, I recommend not to define contradictory ON UPDATE actions. The
following is an example of such:

CREATE TABLE t (a INT NOT NULL, PRIMARY KEY (a),
   FOREIGN KEY (a) REFERENCES t2 (a) ON UPDATE CASCADE,
   FOREIGN KEY (a) REFERENCES t2 (b) ON UPDATE CASCADE) TYPE =
InnoDB;

Now if someone UPDATEs both a and b in t2, what should we do?

Regards,

Heikki
Innobase Oy

sql query


.

Subject: InnoDB foreign keys bug
From: Scott Wong
Date: Thu, 6 Feb 2003 15:25:12 -0800






Version: Mysql  4.0.10-gamma

Description: Innodb fails to follow the foreign key rules after alter table.
This bug can be done in several ways.

How to repeat

These variations gives same errors.
1st bug example:

drop table if exists parent;
drop table if exists child;
CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent id INT, INDEX par ind (parent id),
 FOREIGN KEY (parent id) REFERENCES parent(id)
 ON UPDATE CASCADE
) TYPE=INNODB;
insert into parent set id = 1;
insert into child set id=1, parent id=1;
alter table child add   FOREIGN KEY (`parent id`) REFERENCES `test.parent`
(`id`)
 ON DELETE CASCADE ;
update parent set id=2 where id=1;
gives :ERROR 1217: Cannot delete or update a parent row: a foreign key
constraint
fails

end 1st bug.

Variations of this bug :

drop table if exists parent;
drop table if exists child;
CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent id INT, INDEX par ind (parent id),
 FOREIGN KEY (parent id) REFERENCES parent(id)
 ON DELETE CASCADE
 ON UPDATE CASCADE
) TYPE=INNODB;
insert into parent set id = 1;
insert into child set id=1, parent id=1;
alter table child add   FOREIGN KEY (`parent id`) REFERENCES `test.parent`
(`id`)
 ON UPDATE CASCADE ;
update parent set id=2 where id=1;
ERROR 1217: Cannot delete or update a parent row: a foreign key constraint
fails
delete from parent;

The intesting thing is this :

show create table child;
  FOREIGN KEY (`parent id`) REFERENCES `parent` (`id`) ON UPDATE CASCADE,
  FOREIGN KEY (`parent id`) REFERENCES `parent` (`id`) ON DELETE CASCADE ON
UPDATE
CASCADE


fix
?


Thank you for your time

Scott Wong
Meiko America, INC




-
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

Test

2003-02-08 Thread Adam Randall

I'm not getting mail, so I'm seeing if I can send.  If you get this, 
plesae disregard.

Adam.

sql query

---
Adam Randall  http://www.xaren.net/
[EMAIL PROTECTED]   http://nt.xaren.net/
[EMAIL PROTECTED]AIM/iChat:  blitz574

Macintosh users are a special case. They care passionately about the
Mac OS and would rewire their own bodies to run on Mac OS X if such a
thing were possible. -- Peter H. Lewis

-
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

BUG: InnoDB ORDER BY DESC may hang in 4.0.10

2003-02-08 Thread Heikki Tuuri

Hi!

A rather serious bug was introduced to 4.0.10 in connection of another bug
fix.

If you have a composite key (col1, col2) in an InnoDB table, then a query of
type

SELECT ...
FROM ...
WHERE col1 = x ORDER BY col2 DESC;

may hang in an infinite loop.

The fix is in 4.0.11.

Best regards,

Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com

sql query




-
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 build Relay Replication system ?

2003-02-08 Thread Heo, Jungsu

Hello!

I have a following system.

Server A : a master for server B. MySQL 4.0.9
Server B : a slave for server A, a master for server C. MySQL 4.0.10
Server C : a slave for server B. MySQL 4.0.10

and I wanna that if update occurs on A, it forwarded to B and B forward it to C
But I don't know how to.

I had setted up all necessary options.

Replication A-B works well. Replication B-C works well too.
but A's update queries is not forwarded to C.

I think the problem is that C does not read Relay log of B.
so, I execute command SLAVE START SQL_THREAD on C.

but A's update query does not relay to C.

I found Relay_Master_Log_File in C's 'SHOW SLAVE STATUS' does
not match Relay_Log_File in B's 'SHOW SLAVE STATUS'

Here are some Replication related status.

# Server A ( Master for B ) #

mysql SHOW MASTER STATUS ;
+---+--+--+--+
| File  | Position | Binlog_do_db | Binlog_ignore_db |
+---+--+--+--+
| localhost-bin.001 | 1522 | repli_test   |  |
+---+--+--+--+


# Server B ( Slave for A, Master for C ) #

mysql SHOW SLAVE STATUS \G
*** 1. row ***
  Master_Host: 203.xx.xx.147
  Master_User: repl
  Master_Port: 3306
Connect_retry: 10
  Master_Log_File: localhost-bin.001
  Read_Master_Log_Pos: 1522
   Relay_Log_File: test42-relay-bin.003   = ??
Relay_Log_Pos: 146
Relay_Master_Log_File: localhost-bin.001
 Slave_IO_Running: Yes
Slave_SQL_Running: Yes
  Replicate_do_db:
  Replicate_ignore_db:
   Last_errno: 0
   Last_error:
 Skip_counter: 0
  Exec_master_log_pos: 1522
  Relay_log_space: 150

mysql SHOW MASTER STATUS ;
++--+--+--+
| File   | Position | Binlog_do_db | Binlog_ignore_db |
++--+--+--+
| test42-bin.002 | 207  | repli_test   |  |
++--+--+--+

# C ( Slave for B ) #

mysql SHOW SLAVE STATUS \G
*** 1. row ***
  Master_Host: 203.xx.xx.42
  Master_User: repl
  Master_Port: 3306
Connect_retry: 10
  Master_Log_File: test42-bin.002
  Read_Master_Log_Pos: 207
   Relay_Log_File: localhost-relay-bin.002
Relay_Log_Pos: 383
Relay_Master_Log_File: test42-bin.002  = should be 'test42-relay-bin.003' ?
 Slave_IO_Running: No
Slave_SQL_Running: Yes
  Replicate_do_db:
  Replicate_ignore_db:
   Last_errno: 0
   Last_error:
 Skip_counter: 0
  Exec_master_log_pos: 207
  Relay_log_space: 387

# end

thank you for read !
Any suggestion will please me.

##
Heo, Jungsu Mr.
SimpleX Internet. http://www.simplexi.com

Filter : sql



-
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 mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

kind of recursive SQLstr

2003-02-08 Thread Bart Goormans

Dear listers,

can anyone shine a light on this one...

I have some HTML page-titles which i'd like to put in a dropdown menu. Least
load for server is when just using a server-cursor. And going trough the
results just once.

So best thing is to order the titles in the right way when recieving them
from
the database:
-
pagesetup
-
pgID
pgMemberOf
pgName
hasMembers
-

like this:

1.HomePage (hasMembers  0, pgMemberOf = 0)
   1.1. Products
1.1.1 Toys  Tools (hasMembers = 0)
1.1.2 Shoestrings
   1.2. Services
1.2.1 Pinball repair
 1.2.1.1 New Balls
 1.2.1.2 Empty your machine
1.2.2 We tie your shoes
 1.2.2.2 Left Feet Ties
  1.2.2.2.1 Untying A Knot
 1.2.2.2 Right Feet Ties
   1.3. Links
   1.4.. you get the picture ..
-


So far, I've made a recursive function which returns
all data as a string HTML:

-pseudo-CODE-

buildTree(HomepageID)

function buildTree(myPgID)

  mySQL = getSQL(myPgID)
  myObjRS = getRecordset(mySQL)

  Loop Trough records (myObjRS)

If this page(pgID) has Members

  strReturn = ...

*!Recursive!-!*
  strReturn += buildTree(pgID)

else

  strReturn = ...

end if

  Loop

  close recordset
  return strReturn

end function

-END-pseudo-CODE---


Bad thing about this function is that it opens
up lots of recordsets (for each sub of a sub,...)
Positive: it works !!

Now, I was wondering if it couldn't be done in the
mySQL-database itself. ???
( MyISAM tables / MySQL 3.23.54 )


I tried out this one ...
-SQLstring--

SELECT
ps2.pgID As parentID,
ps2.pgName AS parentPage,
ps1.pgID,
ps1.pgName,
CONCAT_WS(  '.' ,
LPAD(  ps5.pgNr ,2,  '0'   ),
LPAD(  ps4.pgNr ,2 , '0'   ),
LPAD(  ps3.pgNr ,2 , '0'   ),
LPAD(  ps2.pgNr ,2 , '0'   ),
LPAD(  ps1.pgNr ,2 , '0'   )
)AS myOrder
FROM
pagesetup AS ps1
LEFT OUTER JOIN pagesetup AS ps2
  ON ps1.pgMemberOf = ps2.pgID
LEFT OUTER JOIN pagesetup AS ps3
  ON ps2.pgMemberOf = ps3.pgID
LEFT OUTER JOIN pagesetup AS ps4
  ON ps3.pgMemberOf = ps4.pgID
LEFT OUTER JOIN pagesetup AS ps5
  ON ps4.pgMemberOf = ps5.pgID
ORDER BY myOrder;

like in:
http://lists.hampshire.edu/pipermail/computerscience/2001-September/003304.h
tml


As you can see, this is limited to just 5 sub-levels (ps5)
and 99 pages on each level(LPAD-2). Again, it works ;) but
couldn't there perhaps be a more elegant and 'open' method
to use? What way would you guys tackle this recursiveness
in MySQL?


cheers,
and Tx for staying this far down  ;)


Bart




-
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: Using SET in the INSERT statement

2003-02-08 Thread boclair

- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: boclair [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, February 07, 2003 8:47 AM
Subject: Re: Using SET in the INSERT statement

: At 14:19 +1000 2/5/03, boclair wrote:
: I notice some of my colleagues using SET in INSERT statements.
: 
: DuBois makes a short reference on  p565, DoorStop1.
:
: The reference is short because there isn't much to say about it. :-)
: The SET clause consists of col_name=value assignments, separated
: by comma if there is more than one assignment.  That's all.
:
: Other examples are on pp 40-41 (Doorstop I) or p48 (Doorstop II).
:
I know this is so basic that I should understand, but in that case (p40)
 INSERT INTO member SET last_name='Stein' ,first_name='Waldo';
why not use that form always instead of (also p40)
INSERT INTO member (last_name,first_name) VALUES('Stein' , 'Waldo');

On the surface it seems a simpler syntax and is similar, in this
respect, to the syntax for UPDATE.

I see that http://www.mysql.com/doc/en/INSERT.html provides that SET is
an alternative to the VALUES syntax but the explanation that follows,
apart from being a model of simplicity, only mentions the use of SET in
relation to unique columns.

BTW, many thanks for your excellent book.  Invaluable (and it opens
flat)

Louise

-
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: Using SET in the INSERT statement

2003-02-08 Thread boclair

Jennifer,

It is the third alternative syntax.

or  INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name
SET col_name=(expression | DEFAULT), ...
[ ON DUPLICATE KEY UPDATE col_name=expression, ... ]

Louise

- Original Message -
From: Jennifer Goodie [EMAIL PROTECTED]
To: boclair [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, February 06, 2003 6:17 AM
Subject: RE: Using SET in the INSERT statement


: Are you referring to the data type SET or the Command SET?  The manual
page
: you point to is talking about the data type, but usually when seen in
an
: insert it is the Command.  I can't recall seeing the datatype referred
to in
: an INSERT, but maybe my brain isn't fully on yet today.
: http://www.mysql.com/doc/en/INSERT.html
:
:
:
: -Original Message-
: From: boclair [mailto:[EMAIL PROTECTED]]
: Sent: Tuesday, February 04, 2003 8:19 PM
: To: [EMAIL PROTECTED]
: Subject: Using SET in the INSERT statement
:
:
: I notice some of my colleagues using SET in INSERT statements.
:
: DuBois makes a short reference on  p565, DoorStop1.
:
: The Manual has some mention in http://www.mysql.com/doc/en/SET.html
:
: I sort of get it  but I am looking for a fuller explanation.
:
: Louise
:
:
:
:
:
: -
: 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
:


-
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: Using SET in the INSERT statement

2003-02-08 Thread boclair

- Original Message -
From: Keith C. Ivey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 06, 2003 6:47 AM
Subject: Re: Using SET in the INSERT statement

: On 5 Feb 2003, at 14:19, boclair wrote:
:
:  I notice some of my colleagues using SET in INSERT statements.
: 
:  DuBois makes a short reference on  p565, DoorStop1.
: 
:  The Manual has some mention in http://www.mysql.com/doc/en/SET.html
:
: You seem to be confusing two unrelated meanings of SET.  The SET in
: INSERT statements is mentioned here:
:
:http://www.mysql.com/doc/en/INSERT.html
:
: It's just an alternative syntax so that an INSERT query can look like
: an UPDATE query.
:
: The SET from the manual page you mention is a column type and would
: be used in creating a table.

Thanks, I had not seen the alternate syntax used before, and I was
confusing the different usages of SET.

Louise

-
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: Off Topic - PHP/Mysql Development company

2003-02-08 Thread David T-G

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Richard --

...and then Richard Morton said...
% 
% Hi,

Hi!


% 
% I am sorry this is a bit off topic.
% 
% I am looking for recommendations of MySQL / PHP / HTML / Javascript development 
% companies. 

What about independents and freelaners?


% 
% Companies which you have previously worked and found to be very good at what 
% they do and good value.

I've worked extensively with myself and found me to be quite good and an
excellent value ;-)


% 
% They need to be English speaking. I am especially looking for companies in 
% south of the UK.
% 
% I have previously used a company in India and I am not averse to trying this 
% again.
% 
% Suggestions anybody...

HTH  HAND


% 
% Thanks to all.
% 
% Richard
% 
% SQL


mysql query,
:-D
- -- 
David T-G  * There is too much animal courage in 
(play) [EMAIL PROTECTED] * society and not sufficient moral courage.
(work) [EMAIL PROTECTED]  -- Mary Baker Eddy, Science and Health
http://justpickone.org/davidtg/  Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE+QxRmGb7uCXufRwARAmlUAKCZZWxnufdC/uKkJkHR2Wq9QGtlpACeOOIe
k8cadQMs7uDAM6BoeC3S1OE=
=0gMJ
-END PGP SIGNATURE-

-
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

[BUG] Seg fault on REPLACE into large table

2003-02-08 Thread Chris Wilson

Description:

Running a particular query, a REPLACE into a very large table (~2Gb)
causes MySQL to crash with a segmentation fault. I don't know whether the
destination table is corrupt, but myisamchk doesn't think so.

The query is rather long, I'm afraid, so I've elided some fields (also in 
the interests of privacy):

REPLACE DELAYED INTO sAll
SELECT  YEAR(  FROM_UNIXTIME(time)) AS YearNum,
MONTH( FROM_UNIXTIME(time)) AS MonthNum,
DAYOFMONTH(FROM_UNIXTIME(time)) AS DayOfMonth,
WEEK(  FROM_UNIXTIME(time)) AS WeekNum,
DAYOFWEEK( FROM_UNIXTIME(time)) AS DayOfWeek,
IFNULL(Category, 'NULL'),
HOUR(FROM_UNIXTIME(time)),
[... various fields ...]
FROMpages200302,sessions200302,users200302
WHERE   sessions200302.sessionid = pages200302.sessionid 
AND users200302.uid = sessions200302.uid
AND time = UNIX_TIMESTAMP('2003-02-05') 
AND time   UNIX_TIMESTAMP('2003-02-07') 
GROUP BY sAllHash

The table has abourt 4,400,000 rows, and is a MyISAM table. myisamchk does
not detect any errors even with the -e (extended-check) option. I'm
waiting for myisamchk -r to finish so that I can try this query on the
resulting table, but it takes 12 hours to repair.

I have reproduced this with the following MySQL versions:

3.23.55
4.0.10-gamma
4.0.10-gamma-debug-debug
(and 4.0.3 and 4.0.4, I think)

on two different ix86 (Athlons), running Red Hat 7.2 and 7.3 respectively, 
both machines well tested and reliable.

How-To-Repeat:

I have a tarball of the necessary files to repeat this. However, it's 1.6 Gb
in size and contains a lot of private data, so I can't distribute it. I'd 
be happy to apply patches and follow any steps anyone can suggest to 
isolate this.

Stack trace of the segfault:

[root@chris mysql-debug-4.0.10-gamma-pc-linux-i686]# bin/resolve_stack_dump -s 
bin/mysqld.sym -n stackdump
0x80720da handle_segfault + 450
0x8295a58 pthread_sighandler + 184
0x806eda5 copy__6StringRC6String + 69
0x804afff copy__16Item_copy_string + 47
0x80a604f copy_fields__FP15TMP_TABLE_PARAM + 67
0x80a2a68 end_send_group__FP4JOINP13st_join_tableb + 676
0x80a14e6 sub_select__FP4JOINP13st_join_tableb + 258
0x80a1193 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 651
0x80990f0 
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UlP13select_result
 + 7744
0x8097276 handle_select__FP3THDP6st_lexP13select_result + 102
0x807efb6 mysql_execute_command__Fv + 7870
0x8081316 mysql_parse__FP3THDPcUi + 214
0x807c52a dispatch_command__F19enum_server_commandP3THDPcUi + 1594
0x807bee4 do_command__FP3THD + 420
0x807b54e handle_one_connection + 698
0x829320c pthread_start_thread + 220
0x82c8b1a thread_start + 4

GDB session:

/tmp/mysql-debug-4.0.10-gamma-pc-linux-i686/bin/mysqld: ready for connections.
Version: '4.0.10-gamma-debug-debug'  socket: '/tmp/mysql.sock'  port: 3306
---Type return to continue, or q return to quit---

Program received signal SIGSEGV, Segmentation fault.
String::copy (this=0x8908ff0, str=@0x88deba8) at sql_string.cc:202
202 sql_string.cc: No such file or directory.
in sql_string.cc
Current language:  auto; currently c++
(gdb) info local
this = (String *) 0x35353331
str = (String ) @0x88d2c31: {Ptr = 0x0, str_length = 0, Alloced_length = 0,
  alloced = false}
(gdb) up
#1  0x0804afff in Item_copy_string::copy (this=0x8908ff0) at item.cc:294
294 str_value.copy(*res);
(gdb) p item
Cannot access memory at address 0x998abe2
(gdb) info local
this = (Item_copy_string *) 0x8908ff0
res = (class String *) 0xbfffeb2c
(gdb) p *res
$2 = {Ptr = 0x33383331 Address 0x33383331 out of bounds,
  str_length = 858860596, Alloced_length = 741619761, alloced = 49}
(gdb) p *this
Cannot access memory at address 0x998abe2
(gdb) up
#2  0x080a604f in copy_fields (param=0xb29c) at sql_select.cc:6981
6981item-copy();
(gdb) info local
param = (TMP_TABLE_PARAM *) 0xb29c
ptr = (class Copy_field *) 0xb2b0
end = (Copy_field *) 0x8902444
it = (List_iterator_fastItem ) @0xb2b0: {base_list_iterator = {
list = 0xb2a0, el = 0x8909024, prev = 0x0,
current = 0x0}, No data fields}
item = (class Item_copy_string *) 0xbfffeb2c
(gdb) up
#3  0x080a2a68 in end_send_group (join=0xbfffee1c, join_tab=0x88ff644,
end_of_records=false) at sql_select.cc:5237
5237  copy_fields(join-tmp_table_param);
(gdb) bt
#0  String::copy (this=0x8908ff0, str=@0x88deba8) at sql_string.cc:202
#1  0x0804afff in Item_copy_string::copy (this=0x8908ff0) at item.cc:294
#2  0x080a604f in copy_fields (param=0xb29c) at sql_select.cc:6981
#3  0x080a2a68 in end_send_group (join=0xbfffee1c, join_tab=0x88ff644,
end_of_records=false) at sql_select.cc:5237
#4  0x080a14e6 in sub_select (join=0xbfffee1c, join_tab=0x88ff528,
end_of_records=false) at sql_select.cc:4550
#5  0x080a1193 in do_select (join=0xbfffee1c, fields=0x88e69d4, table=0x0,
procedure=0x0) at sql_select.cc:4443
#6  0x080990f0 in

MySQL and Windows XP (Pro)

2003-02-08 Thread Dan Cumpian

I have an application that works just fine on a local MySQL database
when it is running on W2K or Windows XP Home.  However, on Windows XP
Pro, the application has problems keeping its connection to the server. 
Has anyone else seen this and is there a known cause or fix?
 
Weve tried this on more than one XP Pro setup and have seen the same
results.
 
MySQL versions: 3.23.52, 3.23.53, 3.23.54
 
Database connection is using Zeos Database Objects through a Delphi
application.  The application has five separate database connections
each in individual threads.
 
Thank you,
Dan Cumpian
 
 
 


-
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 4 production quality

2003-02-08 Thread Jeremy Zawodny

On Wed, Feb 05, 2003 at 09:24:22PM +1100, Dan Rossi wrote:
 hi there i was wondering if mysql 4 will become production quality soon ? i
 would like to convince work to start using it, so i can start using the
 transactions, sub selects and query cache

We've been using various builds of 4.0.x in production at Yahoo! for
several months now.
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED]  |  http://jeremy.zawodny.com/

MySQL 4.0.8: up 3 days, processed 127,257,873 queries (403/sec. avg)

-
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

Reading fixed column format file

2003-02-08 Thread TyagiAnupam

Hi! 
this is a beginner's question about MySQL. I have looked at the online MySQL 
documentation and have not found an answer.

I am looking for suggestions to read a fixed-column format file into a 
MySQL database with about 50,000 observations and 400 variables (fields). 
Each 
variable is in 2--5 colums of a text file with no column delimiters and 
blanks for missing values. Also, how do I create field names and labels for 
the values in each field? This will be used for creating subsets for 
statistical analysis.  Also, which table type is good for this purpose?  I 
will be thankful for any suggestion on this.

anupam.


-
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

Upgrade

2003-02-08 Thread Chris Kay


I am about to upgrade mysql to version 4

My question is, is there a simple rollback method in case it fails, 
I will be doing it on a production server via rpm's and I don't wish for
it

To be killed for a long period of time...

Any comments would be nice

- 
Chris Kay 
Techex Communications 
Website: www.techex.com.au Email: [EMAIL PROTECTED] 
Telephone: 1300 88 111 2 - Fax: 1300 882 221 
-  


-
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 Archive and restore the data in MySQL database.

2003-02-08 Thread Prasad Budim Ram

Hi,
 Can any of you give me links about Archiving and restoring the data in
MySQL database. Are there any utilities for the same?
Thanks in advance,
Ram

-
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

natural left join

2003-02-08 Thread Varshavchick Alexander

Hello,

If it's a documented feature which I've missed - please excuse, but after
upgrading from 4.0.2 to 4.0.7 the following sql statement started to
behave differently then before:

   select Sections.ReportName, Creatives.Name,
   from HourlyStats natural left join Sections
   left join Creatives on HourlyStats.CreativeID=Creatives.CreativeID
   where HourlyStats.CreativeID=185;

Instead of returning only rows existing in BOTH tables, it now returns
rows which exist at least in one table. To make this statement working
correctly, the brackets have to be inserted:

   select Sections.ReportName, Creatives.Name,
   from (HourlyStats natural left join Sections)
   left join Creatives on HourlyStats.CreativeID=Creatives.CreativeID
   where HourlyStats.CreativeID=185;

Are the brackets here required by sql standart and was it a bug in the
4.0.2 which permitted working correctly even without them? Or how can it
be explained?

Thanks


Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)




-
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: Problems with INNODB in MySQL 4.0.6-gamma

2003-02-08 Thread Varshavchick Alexander

On Tue, 4 Feb 2003, Kees Hoekzema wrote:

 I had the same problem, it went on until I had 44G of InnoDB space, with only
 4G free. After getting tired of having to increase the number of files every
 week, I decided to dump all data with mysqldump, remove the files+ logs and
 recreate them. After that there was more than 24G free, and the database was
 a bit faster too :) (it took me more than 12 hours to dump  restore, but it
 was worth the effort).

 In your case I think you should do the same only if you are running out of
 space every week or something. I too noticed that innodb won't give up it
 space, so this was the only solution that came to my mind, maybe there is a
 better way, but i haven't seen any tools to defragment an innodb database.


What if making this procedure one database or table at a time, will it
bring the effect, or does the _whole_ database file need to be recreated?



Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)



-
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 4 production quality

2003-02-08 Thread Dan Rossi

yes i am aware that sub selects are in 4.1, i'm pretty sure  i have it
running @ home, there are some large traffic sites i would like to lighten
up and make a bit faster code wise with query caching and sub selects, but i
havent been told what gamma means ?

-Original Message-
From: Josh Trutwin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 2:16 PM
To: [EMAIL PROTECTED]
Subject: Re: Mysql 4 production quality

 hi there i was wondering if mysql 4 will become production quality soon
 ? i would like to convince work to start using it, so i can start using
 the transactions, sub selects and query cache

I don't think MySQL 4.0 has sub-selects, that's 4.1.

I've been using 4.0 on two different ISPs for a few months without
incident, but the apps are not very complicated...

Josh

-
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 as an Embedded Java Database

2003-02-08 Thread Lucia Sheehan

I am creating a java application and am using tomcat.   I would like to be
able to use mySQL in embedded mode, is this possible?  you mentioned in
this thread that it could be made linkable in a java application, can you
tell me what needs to be done to achieve this?

Regards

Lucia


-
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 book TOC

2003-02-08 Thread Vikram Vaswani

Hello all,

My name is Vikram Vaswani, and I'm currently working on the outline for a
MySQL reference book. This is supposed to be a comprehensive reference to
MySQL 4, covering all aspects of the software, including the new
transaction/subquery features.

I have put together a draft table of contents (TOC), but am a little
hesitant about some aspects of it. I have a nagging feeling that I'm
missing out on a lot of things here, and also that it might bs structured
better. Specifically, I was hoping that this list would help me in
evaluating the structure and content of Section 2 below. 

Since I'm not that experienced with MySQL, I thought I'd open this up to
the list and see if you guys could help me figure out what's bugging me :)
I'd appreciate as much feedback as possible, since my aim here is to
produce something that would hopefully be useful to you in your usage of
MySQL (and also stand out from the crowd of other MySQL books in the market)

Thanks! I look forward to hearing back.

Vikram Vaswani

--
TOC

Section 1: Installation

1.Introduction to MySQL 
What is MySQL?
History
Features
Future development

2. Installing
Linux
Windows

Section 2: Usage

3.Introduction to Databases and SQL 
What is SQL?
SQL variants
SQL features
SQL syntax
A sample SQL session

4.MySQL Data Types
Basic data types
String and string variants
Integer and integer variants
Date and time types
Boolean types
Null type
Advanced data types
Enum (choice) type
Binary object type


5.MySQL Syntax (Working With Databases) - CREATE, DROP, SHOW
Understanding how databases are stored on the file system
Creating a database
Viewing available databases
Deleting a database

Do I need to add info on the InnoDB/Berkelet/MyISAM types here? And
how/when to select each?

6.MySQL Syntax (Working With Tables) - DESCRIBE, SELECT, INSERT, UPDATE,
DELETE, APPEND, joins
Understanding how tables are stored on the file system 
MySQL table types
Creating a table
Viewing available tables
Creating table columns
Inserting records
Viewing table records
Editing (updating) table records
Joining tables
Erasing records
Altering columns
Erasing columns
Erasing tables

What have I missed here?

7.MySQL Syntax (Working With Tables - Advanced) - Indices, transactions and
sub-queries 
Advanced joins
Sub-queries 
Indices
Transactions
Stored procedures

Do you think I need a separate chapter for each of the above?

What have I missed here?

Section 3: Administration

Section 4: Development
--
--
Luke: I don't believe it!
Yoda: That, is why you fail.
--Star Wars: The Empire Strikes Back

-
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

Creating a table in mysql via a php script

2003-02-08 Thread Scott

Ok, trying to create a table in a mysql database via  php script.

heres the code:-

?
$user=username;
$password=password;
$database=database;
mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( Unable to select database);
$query=CREATE TABLE contacts (id int(6) NOT NULL auto_increment,first
varchar(15) NOT NULL,last varchar(15) NOT NULL,phone varchar(20) NOT
NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30)
NOT NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2
(id));
mysql_query($query);
mysql_close();
?

I have added the username, apssword and database in the top 3 lines, saged
the script into a file called create_table.php and gave it permissions of
777 to be safe.

What have I missed as its not creating the table.

Scott




-
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 MySQL work on Windows XP?

2003-02-08 Thread Stefan Hinz

Marg,

MB The start up looks good: when I use the Run function
MB C:\mysql\bin\mysqld-shareware.exe, the black DOS box comes and goes, but 
MB I'm getting this error when using the  MySQL test script (See below):

I didn't know MySQL was shareware, well ... The problem you describe
is caused by mysqld (the MySQL server) not running. If it's not
running, you can't connect to it, of course.

MB Has anyone in this discussion group had success getting MySQL to work on
MB Windows XP?

No problem at all. I suggest you get the MySQL distribution from the
MySQL web site (http://mysql.com), and install it under c:\mysql (this
is the setup default). After installation (this is all done by simply
clicking setup.exe, but make sure you have the appropriate privileges
under XP), cd to c:\mysql\bin (Win Explorer or DOS windows, as you
like) and start winmysqladmin.exe. This will place a traffic light
icon in the system tray. Clicking this, you can choose WinNT 
Install the service, and then WinNT  Start the service. This will
set up a service named Mysql that starts automatically at system
start.

To test if mysqld is up and running, cd to c:\mysql\bin and start
mysql.exe. This should give you a prompt mysql . If the DOS window
keeps disappearing, it means your mysqld is still not running. In this
case, you should cd in a DOS window to c:\mysql\bin and issue:

mysqld --console --standalone

This will show you any errors that occur during mysqld start so you
can find out what the problem is.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3


-
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: comparision of performance b/w mysql and db2

2003-02-08 Thread Stefan Hinz

Anirudha,

AK could anybody please send me some details showing the performance of the
AK mysql server usder varying loads as compared to db2 server

Take a look: http://www.mysql.com/doc/en/MySQL_Benchmarks.html

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3


-
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 mysql execute this ? how can i do this ?

2003-02-08 Thread Stefan Hinz

Narciso,

NMR select nome from categorias  where id_categoria in (select id_categoria
NMR from categoriamembro where id_membro=1807)

MySQL supports subselects starting with version 4.1. AFAIK there are
no binary distributions available for 4.1, so you either have to
compile it yourself or wait a couple of weeks.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3


-
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

natural left join

2003-02-08 Thread Varshavchick Alexander

Hello,

If it's a documented feature which I've missed - please excuse, but after
upgrading from 4.0.2 to 4.0.7 the following sql statement started to
behave differently then before:

   select Sections.ReportName, Creatives.Name,
   from HourlyStats natural left join Sections
   left join Creatives on HourlyStats.CreativeID=Creatives.CreativeID
   where HourlyStats.CreativeID=185;

Instead of returning only rows existing in BOTH tables, it now returns
rows which exist at least in one table. To make this statement working
correctly, the brackets have to be inserted:

   select Sections.ReportName, Creatives.Name,
   from (HourlyStats natural left join Sections)
   left join Creatives on HourlyStats.CreativeID=Creatives.CreativeID
   where HourlyStats.CreativeID=185;

Are the brackets here required by sql standart and was it a bug in the
4.0.2 which permitted working correctly even without them? Or how can it
be explained?

Thanks

mysql, query

Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)





-
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: Applications for creating reports for MySQL

2003-02-08 Thread Shamit Verma

Any ODBC compliant reporting tool should work with MySQL.
Have you tried using Crytal Reports???

Regards,
Shamit Verma
- Original Message -
From: Octavian Rasnita [EMAIL PROTECTED]
To: MySQL [EMAIL PROTECTED]
Sent: Tuesday, February 04, 2003 11:40 PM
Subject: Applications for creating reports for MySQL

 Hi all,

 Does anyone know a program for Windows that can create reports for MySQL
 databases?

 If you know more, please tell me more, because I need to check which of
them
 are accessible for the blind.

 Thank you.

 Teddy,
 Teddy's Center: http://teddy.fcc.ro/
 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

-
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 strings containing only spaces fails?

2003-02-08 Thread Stefano Bruno Grenci

Hi All,

I had the same problem on MySql server 3.23.43 on
Solaris platform but, so far, I don't know how 
to solve it. Can you help me?

Thanks in advance. Regards.

Stefano Bruno Grenci


-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Stefano Bruno Grenci ([EMAIL PROTECTED])
Ion Trading System s.r.l.
Corso Italia 178, 56125 Pisa (Italy)
Tel. +39 050 916271

-
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 MySQL work on Windows XP?

2003-02-08 Thread Martin Hudec

I was using Mysql on win XP downloaded from www.mysql.com site. All was 
working good. Hmmm from that error message I assume you don't have Mysql 
running...did u start it? Hmm sorry i don't remember right exe file to 
execute in windows to start mysql...i am working on linux mandrake now :(..

Martin


On Thu February 6 2003 17:30, Marg Brazil wrote:
   Hello,
  Can anyone tell me if MySQL will work on Windows XP Home Ed.?
 I have MySQL installed according to the instructions on the CreateASite
 web page.

 I tried contacted CreateASite with this description of the problem:

 The start up looks good: when I use the Run function
 C:\mysql\bin\mysqld-shareware.exe, the black DOS box comes and goes, but
 I'm getting this error when using the  MySQL test script (See below):
 Warning: mysql_connect() [function.mysql-connect]: Can't connect to
 MySQL server on 'localhost' (10061) in c:\usr\htdocs\mysql_test.php on
 line 7
 Couldn't Connect
 I have followed the instructions for installing IndigoPerl,
 CreateASite,  PHP, and for MySQL on www.createafreewebsite.net/mysql.html.
 Apache was running well at the time, and the perl and php test scripts
 were A-OK.
 Should MySQL show in WindowsXP task manager? I can only see 2
 Apache.exe' s and HTMel30.exe. There's no
 C:\mysql\bin\mysqld-shareware.exe listed. 

  CreateASite response was:

 I worked with a guy from Germany for 2 days trying to get the mysql
 package you are using to work on XP.   No luck.  I should probably put
 that on the site.
 I'm not saying you can't get the present package to work.  Just saying I
 didn't on XP.  

 Has anyone in this discussion group had success getting MySQL to work on
 Windows XP?

 Thanks!

 MB



 MySQL test script:

 html
 head
 titleMySQL Test/title
 /head
 body
 ?
 $link = mysql_connect(localhost);
 if (! $link)
 die (Couldn't Connect);
 $db_res = mysql_list_dbs($link);
 $num = mysql_num_rows($db_res);
 for($x=0;$x  $num; $x++)
 print mysql_tablename( $db_res,$x).br;
 mysql_close($link);
 ?
 /body
 /html




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

sql

-- 
Martin Hudec
===
:m:+421 907 303 393
:@:[EMAIL PROTECTED]
:w: http://www.corwin.sk

In google non est, ergo non est.
- unknown IRC operator

-
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[2]: MySQL 4.0.10 is released

2003-02-08 Thread Stefan Hinz

Dan,

DR this is exactly what i am asking , when u say new gamma development
DR release  (use this for new development)  what does it all mean , is it
DR stable for production use ? i would like to know to convince work to start
DR using it ?

This discussion is in the list archives a couple of times. Anywhere,
here it is again:

Stable = Millions of users are using this version for development and
production purposes. This version is known to have no serious bugs at
all, under all conditions, operating systems, and high load.

Gamma = Very stable as well, and running in production environments,
too, but not tested by millions of users, but rather by some ten
thousand (at least for production).

Beta = Stable enough to be used in production, too, but recommended
for this purpose only to experienced users.

Alpha = Contains no bugs known to the developers. Tested by a lot of
people, and some of the more experienced users also use Alpha for
production.

Developer = Not available as binary dist, but you have to compile it
yourself. Not thoroughly tested in all aspects, so this should not be
used for production purposes.

MySQL 4.1.0 is GAMMA, so you regard it as stable as rock. If work
wants more than this, let's say they want a different level of support
than the one you get through this list, they can buy support from
MySQL AB, the company behind MySQL.

Regards,
--
  Stefan Hinz [EMAIL PROTECTED]
  iConnect GmbH http://iConnect.de
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3


-
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@lists.mysql.com

2003-02-08 Thread

mysql:ÄúºÃ!

×ð¾´µÄÅóÓÑ,¹ýÄêºÃ! 

Ê×ÏÈ±±¶·ÐÇ¹¤×÷ÊÒÔÚ´ËÏòÄúÖ£ÖØÉùÃ÷£ºÈç¹ûÄúÊÇÒ»¸öÖ¤È¯Í¶×ÊÕß,Õâ¸öÓÊ¼þ¶ÔÄúÀ´½²¾ø²»ÊÇÀ¬»øÓÊ¼þ¡£
ÓµÓÐÊ®ÄêÊµÕ½¿´ÅÌ¾ÑéµÄÖ°ÒµÍ¶×ÊÈË¿ª·¢µÄ¡¢Á¢×ãÓÚÖÐ¹ú¹ÉÊÐÊµÕ½µÄ¡¶±±¶·ÐÇ¹¤×÷ÊÒ¡·ÍøÕ¾ 
http://www.21cnstock.com 
ÓÚ2ÔÂ1ÈÕÕýÊ½¿ªÍ¨,±¾ÍøÕ¾Í¬Ê±Ò²ÊÇ¹úÄÚÎ¨Ò»µÄ¸ÒÓÚÒÔ×Ô´´·ÖÎöÏµÍ³Í¼±íÕ¹Ê¾´óÅÌ·ÖÎö¼°Ñ¡¹ÉµÄÍ¼±íÊ½ÍøÕ¾,ºÁ²»¿äÕÅµØËµ,¡¶±±¶·ÐÇ¹¤×÷ÊÒ¡·µÄÑÐ¾¿³É¹û½«»á¸Ä±äÄúÒ»ÉúµÄÍ¶×ÊÉúÑÄ,ÏòÍ¶×Ê¿÷ËðÓÀÔ¶¸æ±ð¡£

ÎÒÃÇµÄÑÐ¾¿³É¹ûÖÐ°üÀ¨ÁËÎÈ½¡ÐÍ¡¢¼¤½øÐÍ¡¢ÖÐÏß¡¢¶ÌÏßµÈÊÊºÏÓÚ²»Í¬·ç¸ñÍ¶×ÊÕßµÄ²Ù×÷ÀíÄîÓëÑ¡¹É·½·¨¡£

ÎÒÃÇ¼áÐÅ,Ö»ÒªÄúÄÜ¹»¿´ÍêÎÒÃÇÍøÕ¾µÄËùÓÐÑÐ¾¿³É¹ûºÍÖ¸±êÏµÍ³Ö®ºó,Äú½«»á·¢ÏÖ,ÆäÊµ³´¹É×¬Ç®ÕæµÄºÜÈÝÒ×¡£Í¬Ê±ÎÒÃÇÌá¹©µÄ·þÎñÖÐ¡°±ØÓÐÄúËùÐè¡±
 ,ÎÒÃÇµÄ×îÖÕ×ÚÖ¼ÊÇ£º¸æ±ð¿÷Ëð¡¢°Ñ¹ÉÊÐ±ä³ÉÓÀÔ¶µÄÌá¿î»ú¡£

2ÔÂ10ÈÕ¿ªÊ¼µÄAÀà»áÔ±Ê¾·¶ÕÊ»§,½«ÏòÄúÕ¹Ê¾2000ÄêºÍ2001Äê·2±¶¡¢2002ÄêÔÚ´óÅÌÏÂµø½ü20%Çé¿öÏÂÈÔ»ñÀû77%µÄ¡¶´Þ±ó¹ßÐÔÍ¶×Ê·¨¡·²Ù×÷¹æÔòºÍÑ¡¹É¼¼Êõ¡£
   
   Èç¹ûÄúÓÐÒâÊÔÓÃÎÒÃÇµÄÑÐ¾¿³É¹û,¿É»ØÐÅ¸ø [EMAIL PROTECTED]  »ò [EMAIL PROTECTED] 
ÓÊÏäÉêÇë,ÎÒÃÇ½«Ãâ·ÑÎªÄúÃ¿ÈÕ·¢ËÍ³É¹¦ÂÊ¸ß´ï88%ÒÔÉÏµÄ 
¡¶±±¶·ÐÇ¹¤×÷ÊÒ¡·×Ô´´µÄ·ÖÎöÏµÍ³Í¼±í¿´ÅÌ·ÖÎöÌáÊ¾¡£

   ±±¶·ÐÇ¹¤×÷ÊÒÕæ³Ï·îÉÏ

ÖÂ
Àñ!
   ±±¶·ÐÇÈí¼þ
   [EMAIL PROTECTED]
   2003-02-07

-
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 mysql execute this ? how can i do this ?

2003-02-08 Thread Anderson Pereira Ataides

If you have id_categoria in both tables why don't you use join?
Try this:

select nome from categorias inner join categoriamembro
on categorias.id_categoria=categoriamembro.id_categoria
where id_membro=1807

[]s
Anderson Pereira Ataides
Em Qui 06 Fev 2003 00:31, you wrote:

 Is this possible

 select nome from categorias  where id_categoria in (select id_categoria
 from categoriamembro where id_membro=1807)

 in MySQL


 Thks

 [MsR]


 -
 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: Regular Expressions

2003-02-08 Thread Dobromir Velev

Hi,
I use it in queries like

SELECT * FROM table WHERE field REGEXP patern;

It is the same as using the LIKE operator wit more complex patterns

Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com




- Original Message -
From: Darren Young [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 06, 2003 00:02
Subject: Regular Expressions


 I've looked through the mysql manual for information on regualar
 expressions, and all that it seems to have are references such as:

 SELECT fo\nfo REGEXP ^fo$;

 How can the REGEXP be applied to a 'SELECT field FROM table' kind of
 statement?

 Thanks,

 Darren Young

 mysql,query


 -
 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: sql_big_selects

2003-02-08 Thread Dobromir Velev

Hi,
Isn't there a way to reduce the number of rows that are scanned based on an
index - for example
the query

SELECT * FROM email WHERE id100 AND subject = 'RE: TEST EMAIL' ORDER BY
`id` DESC LIMIT 0,25;

will be significantly faster (it will scan less rows) and will most probably
return the same results. Using the EXPLAIN command will give you an estimate
of how many rows the query will scan before returning a result.
Check http://www.mysql.com/doc/en/EXPLAIN.html for more iinformation

If you plan to run this query often you should consider indexing the subject
field or every time you'll have to wait long time before the query executes.

Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/



- Original Message -
From: Dallas Engelken [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 05, 2003 17:30
Subject: sql_big_selects


i have a datbase of about 1.5 million log entries that i want to search
based on subject (not indexed because it's seldom used).  when i try, i get
a fatal warning that i cant seem to kick.  i have rtfm, and changed
max_join_size=200 in my.cnf to hopefully make it run without the fatal
warning... that didnt work.

if i set sql_big_selects=1 and run the query, it takes 10 minutes to return
any data.

mysql SELECT * FROM email WHERE 1 AND subject = 'RE: TEST EMAIL' ORDER BY
`id` DESC LIMIT 0,25;
ERROR 1104: The SELECT would examine too many records and probably take a
very long time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the
SELECT is ok

can someone offer some advice to help make this query work.  btw, the order
by `id` is the primary key.

thanks,
dallas

-
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 limitations

2003-02-08 Thread Cedric Gavage

Martin Hudec wrote:

Hello,

I would like to know what are limitations for mysql in number of records, size 
of records, size of tables etc.

Can anyone help me please?


You could see information about it on:
http://www.mysql.com/doc/en/Features.html
http://www.mysql.com/doc/en/Table_size.html

--
 Cedric Gavage [EMAIL PROTECTED] - Niddle@IRC
 http://unixtech.be - http://gavage.com - OpenPGP: 0xED325C64



-
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: innodb

2003-02-08 Thread keith . jones


Are you running mysql or mysql-max? InnoDB is not supported in standard
mysql. If you are running max then are there any error messages?




Extranet
[EMAIL PROTECTED] - 05/02/2003 17:17

To:mysql

cc:


Subject:innodb


I have a small probleme with MySQL in 3.23.55.
I do not manage to create my tables under the format InnoDB by specifying
the
type of creation at the end of the command.
Thank you in advance

-
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








This message and any attachments (the message) is
intended solely for the addressees and is confidential. 
If you receive this message in error, please delete it and 
immediately notify the sender. Any use not in accord with 
its purpose, any dissemination or disclosure, either whole 
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message. 
BNP PARIBAS (and its subsidiaries) shall (will) not 
therefore be liable for the message if modified. 

-

Ce message et toutes les pieces jointes (ci-apres le 
message) sont etablis a l'intention exclusive de ses 
destinataires et sont confidentiels. Si vous recevez ce 
message par erreur, merci de le detruire et d'en avertir 
immediatement l'expediteur. Toute utilisation de ce 
message non conforme a sa destination, toute diffusion 
ou toute publication, totale ou partielle, est interdite, sauf 
autorisation expresse. L'internet ne permettant pas 
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce 
message, dans l'hypothese ou il aurait ete modifie.


-
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 mysql execute this ? how can i do this ?

2003-02-08 Thread keith . jones


Sadly MySQL does not support sub-selects yet. Take a look at the manual for
suggestions of ways around it.

Keith




Extranet
[EMAIL PROTECTED] - 06/02/2003 02:31

To:mysql

cc:


Subject:Can mysql execute this ? how can i do this ?


Is this possible

select nome from categorias  where id_categoria in (select id_categoria
from categoriamembro where id_membro=1807)

in MySQL


Thks

[MsR]


-
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








This message and any attachments (the message) is
intended solely for the addressees and is confidential. 
If you receive this message in error, please delete it and 
immediately notify the sender. Any use not in accord with 
its purpose, any dissemination or disclosure, either whole 
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message. 
BNP PARIBAS (and its subsidiaries) shall (will) not 
therefore be liable for the message if modified. 

-

Ce message et toutes les pieces jointes (ci-apres le 
message) sont etablis a l'intention exclusive de ses 
destinataires et sont confidentiels. Si vous recevez ce 
message par erreur, merci de le detruire et d'en avertir 
immediatement l'expediteur. Toute utilisation de ce 
message non conforme a sa destination, toute diffusion 
ou toute publication, totale ou partielle, est interdite, sauf 
autorisation expresse. L'internet ne permettant pas 
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce 
message, dans l'hypothese ou il aurait ete modifie.


-
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

Webyog Releases SQLyog 3.02

2003-02-08 Thread Insanely Great

SQLyog v3.02 - The definitive Windows Front End for MySQL, has been
released. It is a superfast, compact and easy to use Front End for MySQL. A
must for MySQL developers. SQLyog is FREE!

Some of the new features added in SQLyog 3.02 are -

-- ODBC Import. The simplest and the most powerful tool to import data from
any ODBC compliant database to MySQL.
-- Database Synchronization Tool. Bring your remote databases in Sync with a
single mouseclick.
-- Connection Manager.
-- Manage relationships on InnoDB tables. All other options fully InnoDB
compliant.
-- Column Reordering.
-- Copy databases between two MySQL hosts.
-- Insert/Update on the Resultset of a query.
-- Fully updated keyword list for syntax highlighting.
-- Picklist for Enum/Set values in Insert/Update Dialog.
-- Improved datagrid. Allows multiple row deletion.
-- Option to add column name while exporting data in CSV.
-- Multi selection of tables in export as SQL Scripts dialog.
-- Empty a database with a single click.
-- Show/Hide edit window.
-- Improved error messages.
-- Lot of bugfixes and enhancements.

You can download the new SQLyog at
http://www.webyog.com/sqlyog/download.html.

Send your comments, suggestions, feature request through their NEW
discussion board at http://www.webyog.com/forums/index.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

java.sql.Exception: Communication link failure on FreeBSD

2003-02-08 Thread Benjamin Hart

Hi,

I've seen there's a problem with the mysql binaries on linux, does anyone
know if this also affects FreeBSD?

I cannot get access to the database via jdbc. I am using the
mysql-connector-java-2.0.14-bin.jar, mysql version 3.29.49, on freebsd 4.5,
and get the following stacktrace:

java.sql.SQLException: Communication link failure: java.io.IOException
at
at
at com.mysql.jdbc.Driver.connect(Unknown Source)
at
at java.sql.DriverManager.getConnection(DriverManager.java, Compiled
Code)
at yo.main(yo.java, Compiled Code)

Cheers,

Ben


-
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 limitations

2003-02-08 Thread Jerry

http://www.mysql.com/doc/en/Table_size.html

More lightly to be file system than dB I think depending on the version.

Jerry

Apps-RD
Cable and Wireless


- Original Message -
From: Martin Hudec [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 06, 2003 2:12 PM
Subject: mysql limitations


 Hello,

 I would like to know what are limitations for mysql in number of records,
size
 of records, size of tables etc.

 Can anyone help me please?

 --
 Martin Hudec
 ===
 :m:+421 907 303 393
 :@:[EMAIL PROTECTED]
 :w: http://www.corwin.sk

 In google non est, ergo non est.
 - unknown IRC operator

 -
 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 limitations

2003-02-08 Thread Martin Hudec

Oh yes thank you Jerry this is what i was looking for. Hmmm as far as for 
maximum number of rows, it can be defined it seems by MAX_ROWS parameter 
while CREATE TABLE :).

Thanks

On Fri February 7 2003 14:38, Jerry wrote:
 http://www.mysql.com/doc/en/Table_size.html

 More lightly to be file system than dB I think depending on the version.

 Jerry
 
 Apps-RD
 Cable and Wireless
 

-- 
Martin Hudec
===
:m:+421 907 303 393
:@:[EMAIL PROTECTED]
:w: http://www.corwin.sk

In google non est, ergo non est.
- unknown IRC operator

-
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

C API for mysql

2003-02-08 Thread Qin Lu

Hello,

I'd like to practice my C application for using mysql.

Do you know where can I find some examples?
Which header files should I include in my code?
And which lib.a should I link to?

Many Thanks.

Qin



This E-Mail and any attachment is intended only for the person or entity for
which it is addressed and may contain confidential material. If you are not
the addressee or have received this E-Mail in error, please inform the
sender immediately and delete it from your computer. In addition, if you are
not the addressee or have received this E-Mail in error, any disclosure,
copying, distribution or any action taken or omitted to be taken in reliance
upon it is prohibited and may be unlawful.
If this E-Mail has been transmitted outside the ordinary course of its
business, the company for which the sender works accepts no liability for
any loss or damage suffered by any person arising from any use of or
reliance on information contained in this E-Mail, and any opinion expressed
in this E-Mail is personal to the sender and may not reflect the opinion of
such company. Although the network operator makes every reasonable effort to
keep its network free from viruses, neither the network operator nor the
sender or the company for which the sender works accepts any responsibility
for computer viruses transmitted through this E-Mail or any attachments; it
is your responsibility to virus scan this E-Mail and any attachments. Any
E-Mail reply to this address may be subject to interception or monitoring
for operational reasons or for lawful business practices.




-
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

Segmentation fault

2003-02-08 Thread Pierre-Yves Saumont

Hello,

I am using Version : 3.23.40 under Linux and 3.23.51-Max under Windows XP

I get the following error message while dumping my database. The 
segmentation fault is caused by the -c option. (It also occurs under 
Windows XP).

Pierre-Yves Saumont

Red Hat Linux release 6.2 (Zoot)
Kernel 2.2.14-5.0smp on a 2-processor i686
login: volga
Password:
Last login: Fri Feb  7 06:11:45 from 
ASte-Genev-Bois-105-1-1-116.abo.wanadoo.fr
[volga@s5 volga]$ mysqldump -uvolga -p -c volga_volga 
volga_volga_20030207_1520.sql
Enter password:
Segmentation fault (core dumped)



-
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 limitations

2003-02-08 Thread Michael T. Babcock

Martin Hudec wrote:


I would like to know what are limitations for mysql in number of records, size 
of records, size of tables etc.
 


Check the free online user-commented manual first, ask any questions you 
still have afterward.

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
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

Replication comment

2003-02-08 Thread Michael T. Babcock

Just out of comment ... couldn't (shouldn't?) MySQL's replication been 
set up as a seperate process altogether from the server process? 
Replication *could* be done in its present form (afaict) by running 
something like:

tail --follow=name --retry -n0 query_log | grep -v SELECT | mysql 
{servername}

Correct?

If setting up a semi-automated version of this pipe is all it requires 
to do replication (a few greps and pipes), then writing such a program 
would allow for multi-to-multi replication (for example).

--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.fibrespeed.net/~mbabcock



-
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

Is there a better way?

2003-02-08 Thread James E Hicks III

Below is a little PHP code snippet which works great(returns results quickly)
for single
queries. However when I put this code into a loop incrementing the order_index
and line,
my application can take as long as 2 minutes to return results. Is there any
other way
to execute this series of queries more effeciently to come up with
$order_line_due?

The only steps I have taken so far to decrease query time was to verify that
there were
indexes set on the order_index and line fields in each table queried.

mysql_select_db(orders);

$query  = select order_quantity ;
$query .= from order_lines where (order_index = '$order_index');
$query .= and (line = $line);
@extract(mysql_fetch_array(mysql_query($query)));

$linequery  = select sum(quantity) as already_received ;
$linequery .=  from receiving_lines ;
$linequery .=  where ( order_index = '$order_index' ) ;
$linequery .=  and( line = $line ) ;
@extract(mysql_fetch_array(mysql_query($linequery)));

$linequery  = select sum(quantity) as adjust_receive ;
$linequery .=  from receiving_line_adjustments ;
$linequery .=  where ( order_index = '$order_index' ) ;
$linequery .=  and( line = $line ) ;
@extract(mysql_fetch_array(mysql_query($linequery)));

  $order_line_due = $order_quantity - $already_received + adjust_receive;


I hope the PHP code is not to hard for the MySQL gurus to decipher in order to
help!


James E Hicks III
Noland Company
2700 Warwick Blvd
Newport News, VA 23607
757-928-9000 ext 435
[EMAIL PROTECTED]
For the filter (mysql MySQL SQL table row insert select delete)


-
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 4.0.10: connection dies with SELECT @@not_a_global_variable

2003-02-08 Thread Michael Kofler

I am using MySQL 4.0.10 on Windows. If I process SELECT @@whatever (where
whatever is not a valid global variable name), the connection is closed.

Is this by design? Then it should be documented. Otherwise it is probably a
bug.

Best wishes,


Michael Kofler

http://www.kofler.cc



-
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

59 matches

Mail list logo