Re: SET field=field+1 no longer works?

[Stewart G.]

I no longer have the original post in my inbox, I had a problem with 
fetchmail which downloaded all the messages a couple hundred times, so i 
did a mass delete.

All you should have to do is wrap the statement in () like:

UPDATE table name SET field=(field+1) WHERE where clause

This will work fine from PHP using something like

? mysql_query (UPDATE page_views SET hits=(hits+1) where pageid='$page_id') ?

Hope this helps you,

Stewart


-
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

many field insert

[Sommai Fongnamthip]

Hi,
I have to insert data to table which has many fields (252 fields). This 
table was successful update by the LOAD DATA infile. But when I generate 
SQL statement with from VB, SQL statment length got more than 1000 byte.  I 
was try many time to re-check SQL syntax but I still can not insert data 
into mysql table.  Is there any problem with my SQL?

Sommai

--
Please be informed that all e-mail which are addressing to
thaithanakit.co.th will need to be changed to
BTsecurities.com by March 1, 2002 Thank you. :-)
--

-
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

mysqlbug

[Victoria Reznichenko]

rcastro,
Wednesday, February 27, 2002, 12:28:01 AM, you wrote:

r Hi!

r My name is Ricardo Castro and i'm writing for Ensenada, Mexico. My problem 
r installing MySQL is next:

r I've unzipped MySQL (mysql-max-3.23.49-pc-linux-gnu-i686.tar.gz)in /usr/local/; 
r i've follow all the steps that the INSTALL-BINARY indicates; but i have the 
r problem that in the moment to want to run mysql, indicates me: 
r ERROR 2002: Can't connect to local MySQL server through 
r socket '/tmp/mysql.sock' (111)

r I've made
r find / -name mysql.sock

r And, surprise, there is no file anywhere.

mysql.sock is created when mysqld is started.
Is your MySQL server running?

r When i run the steps, nothing indicates me a mistake or something like that
r What is happened???.

Check your privileges on the socket file and on the dir that contains socket file.
You can find the description of this error at:
http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html


r Thank's
r Ricardo Castro.




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.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: insert into with sub select

[Rob]

I've been having this problem as well, which results from mySQL not allowing
you to select and insert from the same table at the same time. This
restriction makes some sense even in your case- mySQL wants to insert each
row as it finds it in the select, but then that might change what results
the select returns. The restriction is less relevant if you are performing a
select which can return at most one row, but mySQL still enforces it.
There are a couple of solutions to this. The cleanest one is probably just
to use temporary tables to implement a true sub-select. (I've put together a
framework to do this hidden behind an abstraction layer so that I can do
subselects whether I'm using mySQL or a different database with a more
robust SQL implementation.)
That would go something like:

create temporary table TMP_table select table1.* from table1 left join
table2 on id where table2.id is null;
insert into table2 select * from TMP_table;
drop table TMP_table;

A much uglier solution involves creating a new permanent table which
duplicates the field you are selecting from table2, adding a field to
table2, and generating a unique number somehow.
You'd set this up with:

create table table2_id select id from table2;
alter table table2 add column insertion_id int;

(you'd probably also want to index table2_id...)
and then for each query run:

insert into table2 select table1.*, theUniqueNumber from table1.* left join
table2_id on id where table2_id.id is null;
insert into table2_id select id from table2 where
insertion_id=theUniqueNumber;

(and then, if you like, you can null out the insertion_id fields)

Obviously, this approach is best avoided because it is invasive, it pollutes
your database with wasteful and confusing processing information, and it
relies on your ability to come up with a unique ID.
The main advantage here is that these statements are pure insertions, so you
can execute them with the DELAYED flag, which can be very important in
reducing UI latency. (Again, a good wrapper library which allows you to
submit any SQL commands asyncronously from another thread is also useful in
this respect.) Of course, if that is important then you'd probably want to
do something substantially more clever than the standard auto_increment
database ops to pick your unique number. It also avoids the use of temporary
tables, which some claim are not as efficient as simple selects across
additional permanent tables. (I haven't done the profiling to test this
theory, however.)

On 27/2/02 at 9:18 am, Sommai Fongnamthip [EMAIL PROTECTED] wrote:

 
 Hi,
  MySQL has insert into function and sub select (mysql style) but I 
 could not conclude these function togethter.
 
  If I want to select not existing row in 2 table, I used:
 
  SELECT table1.* FROM table1 LEFT JOIN table2 ON 
 table1.id=table2.id where table2.id is null
 
 then I'd like to insert the result row back into table2 by this SQL:
 
  insert into table2 SELECT table1.* FROM table1 LEFT JOIN table2
ON 
 table1.id=table2.id where table2.id is null
 
  it got this error:
  ERROR 1066: Not unique table/alias: 'table2'
 
  How could I fixed this problem??
 
 Sommai


-
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

Help! Optimizing a multi-word search

[Steve Rapaport]

Problem:
1. in a phone book, a single field may contain several words, e.g.
District 52 Police Station.
2. The query for this record may contain some or all of these words, but not
necessarily in that order, e.g.  Police district 52.
3. Searching for all of the query words can be done in many ways, most of
 them slower than getting truthful admissions from Enron executives.

So here are some methods I've come up with:

1. Make a fulltext index of the field, and do fulltext searching on all the
query words.
(In mysql 3.23.48, this is often over 30 seconds, which is not fast enough)

2. Make an inverted index as a separate table, with each occurring word and
all of its record numbers in the main table.  (Sounds slow but the 10 hours
 it takes beats the 45 hours Mysql takes to create a FULLTEXT index on that
 table!)
2a) search all the query words in the inverted index, and the main table
in one big join.  (10 minutes typical!)
2b) find the least-occurring query word, make a temp table with it, (2 min)
  now join to the main table and search with an unanchored LIKE on other
  query words.  (another 2 min) (Total 4 min)
2c) find the 2 least-occurring query words and make 2 temp tables, do a
 3-way join with the temp tables and the main table (1 min, 1 min, 2 min)
 (Total 5 min)
2d) same as 2c but index each of the tmp tables as you create it
(1 min, 1 min, 15 sec) (Total 2:15)

Okay, it's getting better but still not very optimal.

The hardware is adequate (dual-CPU 700Mhz each, 1GB RAM, mysql configured for
big RAM, etc)

I'm getting desperate because I'm sure this should not be so slow.   The
problem isn't the 30-second wait per se, it's the fact that during those 30
seconds the server is more loaded:  1 or 2 new requests come in every second,
and once there are 50 of these in the queue, the server becomes unusable...

Things I'm trying next:
Upgrading to 4.0.1 for faster FULLTEXT.
Examining join syntax to find ways to help Mysql optimize the search
(beats me!)
Asking the list for advice...

Steve.

For join gurus:
Sample queries for TEATRO GRECO in any order:


select t1.pointer, t0.last_name from Invfile as t2, Invfile as t1, White as 
t0 where t2.word=TEATRO and t1.word=GRECO and t0.rec_no=t1.pointer;

select t1.pointer, t0.last_name from Invfile as t1, White as t0 where 
t1.word=GRECO and t0.rec_no=t1.pointer;  

select t1.pointer, t2.pointer from Invfile as t1, Invfile as t2 where t1.word 
= TEATRO and t2.word = GRECO and t1.pointer=t2.pointer;


create TEMPORARY TABLE tmp select word,pointer from Invfile where 
word=TEATRO; 
select White.rec_no, White.last_name, tmp.pointer from White, tmp where 
tmp.pointer=White.rec_no and White.last_name like %GRECO%;

create TEMPORARY TABLE tmp (index pointer(pointer)) select word,pointer from 
Invfile where word=TEATRO; 
create TEMPORARY TABLE tmp2 (index pointer(pointer)) select word,pointer from 
Invfile where word=GRECO;   
 SELECT  White.last_name, White.rec_no, tmp.pointer from White,tmp,tmp2 where 
rec_no=tmp.pointer and rec_no=tmp2.pointer;





-
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: Help Optimizing a multi-word search

[Steve Rapaport]

On Wednesday 27 February 2002 07:47 am, Jeff Kilbride wrote:

 -
 I'm going to be implementing a keyword search pretty soon myself, so I'd
 like to see you solve this.  :)

Me too!  :-)

 What about doing some sort of prefix indexing, instead of indexing the
 entire word? So, for every word you put in your indexed word table, you
 chop off the first few letters and index that:

Forgot to mention, I'm already doing that.  In the fulltext version, I use
only first 6 chars of each word.  (In Italian, that's short).  But you're 
right, it's worth trying with 3 or even 1, to see if things go faster.  If
only it didn't take 3 days to generate a new try!  :-(   

I am hoping that trying mysql 4.0.1 will at least speed that up.


 I suppose you could even take this one step further and create char(1)
 fields for the first N chars of your words, and then index across those.
 That should cut down the size of the left most part of the index and maybe
 make it easier/quicker to find records. Also, it might be quicker if you
 keep your columns static (char instead of varchar), if you're not already.

I can't do that, (too big),
but I've specified that the fulltext index search only the
first 40 chars of the field, so at least that part is static.

 Do you have enough memory to put this into a HEAP table -- or at least make
 your temp tables HEAP tables?

Good question.  To the first, no way, the phone book .MYD table is over 3 GB, 
and the index about the same.
For the temp tables, maybe, I'll give it a try if I can figure out how...

Thanks enormously for the help, Jeff, I hope others contribute too!

Steve


  Problem:
  1. in a phone book, a single field may contain several words, e.g.
  District 52 Police Station.
  2. The query for this record may contain some or all of these words, but

 not

  necessarily in that order, e.g.  Police district 52.
  3. Searching for all of the query words can be done in many ways, most of

 them

  slower than getting truthful admissions from Enron executives.
 
  So here are some methods I've come up with:
 
  1. Make a fulltext index of the field, and do fulltext searching on all

 the

  query words.
  (In mysql 3.23.48, this is often over 30 seconds, which is not fast

 enough)

  2. Make an inverted index as a separate table, with each occurring word

 and

  all of its record numbers in the main table.  (Sounds slow but the 10

 hours it

  takes beats the 45 hours Mysql takes to create a FULLTEXT index on that
  table!)
  2a) search all the query words in the inverted index, and the main table
  in one big join.  (10 minutes typical!)
  2b) find the least-occurring query word, make a temp table with it, (2

 min)

now join to the main table and search with an unanchored LIKE on

 other

query words.  (another 2 min) (Total 4 min)
  2c) find the 2 least-occurring query words and make 2 temp tables, do a

 3-way

join with the temp tables and the main table (1 min, 1 min, 2 min)
  (Total 5 min)
  2d) same as 2c but index each of the tmp tables as you create it
  (1 min, 1 min, 15 sec) (Total 2:15)
 
  Okay, it's getting better but still not very optimal.
 
  The hardware is adequate (dual-CPU 700Mhz each, 1GB RAM, mysql configured

 for

  big RAM, etc)
 
  I'm getting desperate because I'm sure this should not be so slow.   The
  problem isn't the 30-second wait per se, it's the fact that during those

 30

  seconds the server is more loaded:  1 or 2 new requests come in every

 second,

  and once there are 50 of these in the queue, the server becomes

 unusable...

  Things I'm trying next:
  Upgrading to 4.0.1 for faster FULLTEXT.
  Examining join syntax to find ways to help Mysql optimize the search
  (beats me!)
  Asking the list for advice...
 
  Steve.
 
  P.S.  I haven't included my sample queries but I will if asked...
 
 
 
 
 
 
  -
  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? 

Re: SET field=field+1 no longer works?

[DL Neil]

Hi Tyler,
Apologies for the absence/delay. Pleased to hear that the problem is solved.

It does raise the question though - if it failed in PHP (etc) how did you manage to 
get it to work in
MySQL-client?

If an UPDATE flat refuses to go (which didn't seem to be the case here), then the 
first 'check' should be to
substitute/paste the WHERE clause into a SELECT query. As it turns out, that would 
have highlighted the problem
for you!

Regards,
=dn


 This was my bad.  I forgot that I had encoded all passwords with
 base64_encrypt() in PHP.  So, the passwords in the database weren't in their
 plaintext forms.  So, my password wasn't matching up with what was in the
 database.

 Everything works good now.  :)

 Thanks for your help!
 tyler

 - Original Message -
 From: Stewart Gateley [EMAIL PROTECTED]
 To: Tyler Longren [EMAIL PROTECTED]; DL Neil
 [EMAIL PROTECTED]
 Cc: MySQL List [EMAIL PROTECTED]
 Sent: Tuesday, February 26, 2002 5:56 PM
 Subject: Re: SET field=field+1 no longer works?


  Try:
 
  UPDATE users SET board_posts=(board_posts+1) WHERE username='tyler' AND
  password='myfakepassword';
 
 
  I am using ? mysql_query (update $table set hits=(hits+1) where
  id=$id); ? and it works fine.
 
  -- Stewart
 
  --- Tyler Longren [EMAIL PROTECTED] wrote:
   Well, here's the query that PHP is generating:
   UPDATE users SET board_posts=board_posts+1 WHERE username='tyler' AND
   password='myfakepassword'
  
   If I copy and paste that exactly into the mysql client, it's executed
   correctly.  If I use phpMyAdmin to execute it, it IS NOT executed
   correctly
   (same as in my PHP code).  I really don't think this is a problem
   with my
   coding since it worked with previous versions of mysql.  Could PHP
   just be
   screwing up while sending the query to MySQL?
  
   Also, if I use MySQL Front (www.mysqlfront.de), the query doesn't get
   executed properly.  It only works correctly when issuing the query
   from the
   mysql command line client.  :)
  
   Tyler
  
   - Original Message -
   From: DL Neil [EMAIL PROTECTED]
   To: Tyler Longren [EMAIL PROTECTED]
   Cc: [EMAIL PROTECTED]
   Sent: Tuesday, February 26, 2002 8:52 AM
   Subject: Re: SET field=field+1 no longer works?
  
  
Hi Tyler,
[back on-list so that others can offer their wisdom!]
   
OK, so it's not a problem with the MySQL client, then it's likely
   the PHP.
   Most likely that the username and
password data values are strings and need to be properly contained
   with
   single- or double-quotation marks.
   
If you need further assistance, first try some debug ECHOs on the
   three
   fields used in the query, and ECHO the
query itself immediately prior to the call to MySQL. (is the last
   how you
   posted (copy-pasted) the query into
the MySQL client, or did you type it into MySQL by hand?)
   
If lights still don't go off, please post the PHP code snippet.
   
Regards,
=dn
   
   
 I tried it in PHP first, and it doesn't work in that.  But, when
   I use
   the
 mysql client, it works as expected.  Any ideas?
   
   
  Hello Tyler,
 
  Did someone pick up this question - haven't spotted a response
   on the
 list?
  I haven't spotted any such mis-behavior under either Win2000 or
   WinNT.
 
  Are you entering the query at the command line or into some
   tool?
  Have you tried another client?
 
  If it is still unresolved, send me (NOT the whole list) the
   actual
   query,
 and a short table with sample data,
  and I'll try it on my two Win boxes here.
 
  Regards,
  =dn
 
 
   I'm running MySQL on a Windows 2000 box.  I was running
   3.23.47
   until
   3.23.49 was released.  After upgrading to 3.23.49, queries
   like this
 don't
   work:
   UPDATE test_table SET board_posts=board_posts+1 WHERE
   username='blah'
 AND
   password='blah';
  
   Normally, that would increment the value in board_posts by 1,
   this
   no
 longer
   happens.  Is there a different way I should do this now?
  
   Thanks,
   Tyler
  
  
 
   
   -
   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 

Re: running mysql w/php..

[DL Neil]

Hi Floyd,

 Hi..  Can anyone tell me some good places to look for sample snips,
 tutorials or other assistance specifically for making PHP and mySQL
 cooperate.  Running mysql queries using php syntax.  Mysql talks about
 mysql queries, etc. and php talks about php functions, etc. but I'm
 finding it difficult when it comes to making them work together.


Go to the home pages (for MySQL, PHP, et al) and find your way to the tutorials or 
'links' pages. One thing
leads to another (as they say)!

My personal recommendation would be to get hold of a decent tutorial text, eg PHP and 
MySQL Web Development by
Welling and Thomson. Admittedly I'm a 'book' kind of guy (although not born on the 
fourth of July) but I find
that the coverage of topics/themes better enables me to build up a picture (or ?map) 
in my head, than studying
the syntax and brief snippets of usage in reference manuals, etc.

Have fun!
=dn



-
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: SET field=field+1 no longer works?

[DL Neil]

Stewart,

 All you should have to do is wrap the statement in () like:
 UPDATE table name SET field=(field+1) WHERE where clause


I had a look in the manual (http://www.mysql.com/doc/U/P/UPDATE.html). 
Where did you find the requirement for parentheses?

Do you have live code where UPDATE works with parentheses, but fails without them?

Please advise,
=dn

PS with regard to your question about the original post, Tyler's problem was elsewhere 
and has been solved.


-
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: Temporary Tables

[John Fishworld]

 You have written the following:

I understand the principles but WHEN should they be used or considered ??

Any help appreciated

 tia
 John

 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

Wrong sorting order using cp1257 character set.

[kestas]

Description:
  There are a few errors in characters sorting order 
  in sql/share/charsets/cp1257.conf file.

  Characters 0xE0 0x5A 0x7A 0xDE 0xFE are treated equaly.
  But accoding Lithuanian standart LST 1285:1993 (if you interested :)
  character 0xE0 should be between 0x61 (a) and 0x62 (b),
  and after 0x5A (Z), 0x7A (z)  should go 0xDE, 0xFE.
  

Fix:

--- sql/share/charsets/cp1257.conf.sv   Wed Feb 27 12:35:52 2002
+++ sql/share/charsets/cp1257.conf  Wed Feb 27 12:36:46 2002
@@ -61,14 +61,14 @@
   20  21  22  23  24  25  26  27  28  29  2A  2B  2C  2D  2E  2F
   30  31  32  33  34  35  36  37  38  39  3A  3B  3C  3D  3E  3F
   40  41  43  44  46  47  4A  4B  4C  4D  50  51  52  53  54  55
-  56  57  58  59  5B  5C  5F  60  61  4E  FF  62  63  64  65  66
-  67  41  43  44  46  47  4A  4B  4C  4D  50  51  52  53  54  55
-  56  57  58  59  5B  5C  5F  60  61  4E  FF  68  69  6A  6B  FF
+  56  57  58  59  5B  5C  5F  60  61  4E  62  64  65  66  67  68
+  69  41  43  44  46  47  4A  4B  4C  4D  50  51  52  53  54  55
+  56  57  58  59  5B  5C  5F  60  61  4E  62  6A  6B  6C  6D  FF
   FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF
   FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF
   FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF
   FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF  FF
   42  4F  FF  FF  FF  FF  48  FF  45  FF  FF  49  FF  FF  FF  FF
-  5A  FF  FF  FF  FF  FF  FF  FF  5E  FF  FF  5D  FF  FF  FF  FF
-  FF  4F  FF  FF  FF  FF  48  FF  45  FF  FF  49  FF  FF  FF  FF
-  5A  FF  FF  FF  FF  FF  FF  FF  5E  FF  FF  5D  FF  FF  FF  FF
+  5A  FF  FF  FF  FF  FF  FF  FF  5E  FF  FF  5D  FF  FF  63  FF
+  42  4F  FF  FF  FF  FF  48  FF  45  FF  FF  49  FF  FF  FF  FF
+  5A  FF  FF  FF  FF  FF  FF  FF  5E  FF  FF  5D  FF  FF  63  FF

 Here I also put characters: { | } ~ ... after
 0xDE, 0xFE which are last alphabet characters. 
 It's more acceptable I think.
 

Submitter-Id:  
Originator:Kestas
Organization:
MySQL support: none
Synopsis:  
Severity:  non-critical
Priority:  low
Category:  mysql
Class: change-request
Release:   mysql-3.23.49 (Source 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

.net

[Joshua Angolano]

Has anyone tried to use the Mysql++ api with visual C++.net?
   Thanks,
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

Re: insert into with sub select

[Sommai Fongnamthip]

Hi Rob,
 You're right for my problem.  I'll hope this solution to be fixed 
in MySQL someday. thanks anyway.

Sommai

At 10:28 27/2/2002 +, Rob wrote:
I've been having this problem as well, which results from mySQL not allowing
you to select and insert from the same table at the same time. This
restriction makes some sense even in your case- mySQL wants to insert each
row as it finds it in the select, but then that might change what results
the select returns. The restriction is less relevant if you are performing a
select which can return at most one row, but mySQL still enforces it.
There are a couple of solutions to this. The cleanest one is probably just
to use temporary tables to implement a true sub-select. (I've put together a
framework to do this hidden behind an abstraction layer so that I can do
subselects whether I'm using mySQL or a different database with a more
robust SQL implementation.)
That would go something like:

create temporary table TMP_table select table1.* from table1 left join
table2 on id where table2.id is null;
insert into table2 select * from TMP_table;
drop table TMP_table;

A much uglier solution involves creating a new permanent table which
duplicates the field you are selecting from table2, adding a field to
table2, and generating a unique number somehow.
You'd set this up with:

create table table2_id select id from table2;
alter table table2 add column insertion_id int;

(you'd probably also want to index table2_id...)
and then for each query run:

insert into table2 select table1.*, theUniqueNumber from table1.* left join
table2_id on id where table2_id.id is null;
insert into table2_id select id from table2 where
insertion_id=theUniqueNumber;

(and then, if you like, you can null out the insertion_id fields)

Obviously, this approach is best avoided because it is invasive, it pollutes
your database with wasteful and confusing processing information, and it
relies on your ability to come up with a unique ID.
The main advantage here is that these statements are pure insertions, so you
can execute them with the DELAYED flag, which can be very important in
reducing UI latency. (Again, a good wrapper library which allows you to
submit any SQL commands asyncronously from another thread is also useful in
this respect.) Of course, if that is important then you'd probably want to
do something substantially more clever than the standard auto_increment
database ops to pick your unique number. It also avoids the use of temporary
tables, which some claim are not as efficient as simple selects across
additional permanent tables. (I haven't done the profiling to test this
theory, however.)

On 27/2/02 at 9:18 am, Sommai Fongnamthip [EMAIL PROTECTED] wrote:

 
  Hi,
   MySQL has insert into function and sub select (mysql style) but I
  could not conclude these function togethter.
 
   If I want to select not existing row in 2 table, I used:
 
   SELECT table1.* FROM table1 LEFT JOIN table2 ON
  table1.id=table2.id where table2.id is null
 
  then I'd like to insert the result row back into table2 by this SQL:
 
   insert into table2 SELECT table1.* FROM table1 LEFT JOIN table2
ON
  table1.id=table2.id where table2.id is null
 
   it got this error:
   ERROR 1066: Not unique table/alias: 'table2'
 
   How could I fixed this problem??
 
  Sommai

--
Please be informed that all e-mail which are addressing to
thaithanakit.co.th will need to be changed to
BTsecurities.com by March 1, 2002 Thank you. :-)
--

-
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

character set

[Egor Egorov]

Michal,
Wednesday, February 27, 2002, 11:41:14 AM, you wrote:

MD Hello,

MD is possible to change encoding (character set) while conecting to
MD mysql from php ?? (In postgre is SET client_encoding = 'latin2').

Character set is set when mysqld is started. If you want to use
different character sets you should to restart, or start another
instance of mysqld.

MD Thank you.
MD Lampa aka Michal





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.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

Chinese support at MySQL

[Egor Egorov]

Joey,
Wednesday, February 27, 2002, 3:26:26 AM, you wrote:

JF Dear all,

JF How to make MySQL with Chinese Big5 support?  Thanks.

You should set big5 character set, look at:
http://www.mysql.com/doc/C/h/Character_sets.html





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.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: Table Creation Question

[Sinisa Milivojevic]

Davis, Charles M writes:
 Hello,
 
 I downloaded the beta version of MySQLGUI and was unable to perform any
 table creation. Is this feature currently not supported?
 
 Thanks,
 Charles
 
 Charles Davis
 Member Engineering Staff, Data Analysis Systems
 Lockheed Martin - Naval Electronics  Surveillance Systems
 MS 530-2, 199 Borton Landing Rd., P.O. Box 1027
 Moorestown, NJ 08057-0927
 Voice: (856) 787-3235Fax: (856) 787-3232
 E-mail: [EMAIL PROTECTED]
 
 


No, it is not yet supported. 

You can always issue CREATE TABLE statement...

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.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: VC++ .net

[Sinisa Milivojevic]

Joshua Angolano writes:
 Has anyone tried to use Mysql++ with Microsoft Visual C++ .NET? 
 Better yet, has anyone had any luck and how?
   Thanks for your help,
   Josh


No, but it could be tried out ..

If you have that VC++ version, you can try it.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.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: mysql php - while loops

[DL Neil]

Craig,
[BTW there is a set of PHP lists, including PHP-DB - mentioned because 'purists' 
sometimes object to 'PHP
questions'!?]

 The following lists 12 items from a fruits table.
 
 $results = mysql_query(SELECT ID, date, appleprice, orangeprice, pearprice
 FROM fruits);
 while ($data = mysql_fetch_array($results))
 {
 ?
 p?=$data[date]? - ?=$data[appleprice]? -
 ?=$data[orangeprice]? - ?=$data[pearprice]?/p
 ?
 }
 
 How would I modify the loop to display 4 items then a row of fruit images
 then 4 more items then another row of different fruit images and then
 finally finish the loop displaying the final 4 items?
 
 That's a good question, given that the query doesn't retrieve any images,
 nor is it evident where else they might come from. :-)
 
 But it sounds like you're talking about three loops, not one.

 if you decide to display only first 4 item try to used limit clause after
 the SQL statement.  otherwise use any count variable within your loop.


Performing multiple hits against MySQL is likely to be much more expensive that 
manipulating within PHP. Make
one query and be done!

Am a little surprised at the suggestion of three loops - perhaps Paul has spotted 
something that I've missed.

You have not said whether you will only ever have 12 rows in the recordset. You have 
said that you want a
'break' after every four rows of db results. Further that after the final set of four 
rows, there will not be a
'break' (nor by implication will there be one prior to the first set of rows).

If you can count on the 12 then hard-coding becomes possible - but stand away from 
me when I say that because
the pure-code police will strike me down with a lightning bolt. If you can't count on 
the 12, then are you
prepared to have an additional 'break' (line of fruit images) and a single (orphan) 
row in the case of (say) a
13-row resultset?

You say different fruit images which may mean that each break row features a 
different set of images (cf the
same image-row each time). It has already been observed that the source of this/these 
is 'unknown'. (I have
(below) pushed out that functionality to a mythical function, to 'bury' the whole 
question)

The current state of the nation:

query db to get resultset
num_rows is 12
while there's still data in the resultset
{
  ECHO row data
}

You could add a simple check for the need to add a 'break line':

query db to get resultset
num_rows is 12
row_ctr = 0
while there's still data in the resultset
{
  ECHO row data
  row_ctr ++
  if ( row_ctr divides evenly by 4 )
fnDisplayFruitImages;
}

I haven't understood why there is a WHILE loop here, but it's your code (and my warped 
mind)! Knowing that there
are 12 rows seems to indicate a FOR loop but I doubt there's any major performance 
difference, so I'll try not
to get snooty about it. The advantage of using a FOR, would be to save those lines 
that set and update row_ctr
(currently appearing in the 'body' of the code) and move them into the FOR command 
(where they do not 'intrude'
on the primary logic of the code).

Trouble is, the above exception condition kicks in after line 12 too - which you don't 
want, so:

  if ( row_ctr divides evenly by 4 AND row_ctr  12 )
fnDisplayFruitImages;

Yuk! Or relying upon the 12, even:

  if ( row_ctr = 4 or row_ctr = 8 )
fnDisplayFruitImages;

and then, if I don't mention it, someone else will even point out (that we should 
stick with the WHILE
choice(!!!***???)) and then we can have:

  if ( row_ctr = 4 )
{
  fnDisplayFruitImages;
  row_ctr = 0
}

Which brings us neatly to how to handle the situation if there are more than 12 
rows/we don't have advanced
knowledge of the number of rows that will be in the resultset. The exception portion 
of the last example will
continue to work (according to the above-assumed criteria), no matter how many rows 
you throw at it! Of course,
the code-police would be after us for the equi-relationship, instead insisting upon 
=; and the
structure-police will be after us because you 'should' reflect the structure more 
'properly' with multiple loops
(at which point I'm going to invoke the '5th', blame it all on you, and claim 
witness-protection):

query db to get resultset
get num_rows as last_row  //put in this change because now we 
don't know how many rows until
we ask
fetch first row//start processing the resultset
row_ctr = 0

while there's still data in the resultset //row_ctr  num_rows***
{
  set_ctr = 0

  while ( set_ctr  4 AND there's still data in the resultset*** )
  {
ECHO row data
set_ctr ++
fetch next row
  }
  row_ctr += 4
  if ( row_ctr  num_rows ) //or, use 'lookahead', ie ask if there 
is valid data in the
latest row fetched from the resultset
fnDisplayFruitImages;
}

BTW I haven't tested a single line of code (after all this typing you can guess why), 
so EOE. Please let me
know if you try to 

Re: mysql on redhat instalation problem

[jake williamson 28]

hello edna and brian,

your life savers! thank you for getting back to me.

i've done the chown and chmod which went well! then i typed:

mysql_install_db

this then said 'installing all prepared tables' and a message saying:

/usr/sbin/mysqld: Shutdown Complete

after that the default kind of welcome screen (that i've seen before when i
installed mysql on a win2000 pc) came up reminding me to set root passwords
ect.

i tried this and no joy... the default stuff seems to have gone in and when
the machine boots up it does say 'starting xsf' and then goes on about
starting the mysql daemon using /var/lib/mysql ect ect

i also tried the:

service mysqld start

and get a message saying:

mysqld: unrecognised service

have i missed something again?

thank you for any help you can chuck my way!

many thanks,

jake

p.s. has anyone ever found a complete tutorial on the web for installing
redhat, php and mysql? i've searched and found stuff that seems to bear no
relation to what i'm trying to do!

actually, once i get this up and running, i'm seriously thinking of setting
up a site that has this kind of thing on it - i've been using
http://www.entropy.ch to help me with php and mysql on mac osX and it's
first class! i cant believe theres not one for redhat


on 26/2/02 18:08, Edna Walton at [EMAIL PROTECTED] wrote:

 Hi
 
 Well, you shouldn't have to do anything (much).  RedHat has set it all up
 for you, albeit not in any place you would expect it if you read the
 manual.  RH creates a user mysql and sets up the tables.  They are in the
 directory /var/lib/mysql.
 
 However, for some reason RH has left root as the owner of all this, so you
 have to change it:
 
 chown -R mysql /var/lib/mysql
 
 and also give mysql permission to write to it.  Not being very security
 conscious on my standalone machine, I just did
 
 chmod -R 755 /var/lib/mysql
 
 but you may wish to be more stringent.
 
 To start the daemon under RH, the command is
 
 service mysqld start
 
 (note the d) rather than safe_mysqld or whatever.
 
 Hope this helps.
 
 Edna
 
 
 At 16:50 26/02/02 +, you wrote:
 hello!
 
 i'm rapidly loosing the hair i have left
 
 i've managed to get our old clockwork pc running redhat 7.1 and php4. apache
 is a rockin and now i've just installed the mysql RPM...
 
 this is where everything's come to a grinding halt...
 
 everything's gone in and mysql seems to be up and running in the background
 - thing is i've just got to the 'what to do to set up mysql' - at this point
 in the manual it seems to forget that you've used a PRM and uses a load of
 stuff that doesn't seem to be in my machine!
 
 it's this bit 'See section 2.4 Post-installation Setup and Testing.' where
 it all goes wrong - none of the directories seem to be there!
 
 in your new server wisdom dus you have any advice?? driving me bonkers...
 
 cheers dude,
 
 jake


-
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: insert into with sub select

[Sommai Fongnamthip]

Hi rob,
 I have another question but still in this solution.  How did you 
delete data which different in 2 table?

Sommai

At 10:28 27/2/2002 +, Rob wrote:
I've been having this problem as well, which results from mySQL not allowing
you to select and insert from the same table at the same time. This
restriction makes some sense even in your case- mySQL wants to insert each
row as it finds it in the select, but then that might change what results
the select returns. The restriction is less relevant if you are performing a
select which can return at most one row, but mySQL still enforces it.
There are a couple of solutions to this. The cleanest one is probably just
to use temporary tables to implement a true sub-select. (I've put together a
framework to do this hidden behind an abstraction layer so that I can do
subselects whether I'm using mySQL or a different database with a more
robust SQL implementation.)
That would go something like:

create temporary table TMP_table select table1.* from table1 left join
table2 on id where table2.id is null;
insert into table2 select * from TMP_table;
drop table TMP_table;

A much uglier solution involves creating a new permanent table which
duplicates the field you are selecting from table2, adding a field to
table2, and generating a unique number somehow.
You'd set this up with:

create table table2_id select id from table2;
alter table table2 add column insertion_id int;

(you'd probably also want to index table2_id...)
and then for each query run:

insert into table2 select table1.*, theUniqueNumber from table1.* left join
table2_id on id where table2_id.id is null;
insert into table2_id select id from table2 where
insertion_id=theUniqueNumber;

(and then, if you like, you can null out the insertion_id fields)

Obviously, this approach is best avoided because it is invasive, it pollutes
your database with wasteful and confusing processing information, and it
relies on your ability to come up with a unique ID.
The main advantage here is that these statements are pure insertions, so you
can execute them with the DELAYED flag, which can be very important in
reducing UI latency. (Again, a good wrapper library which allows you to
submit any SQL commands asyncronously from another thread is also useful in
this respect.) Of course, if that is important then you'd probably want to
do something substantially more clever than the standard auto_increment
database ops to pick your unique number. It also avoids the use of temporary
tables, which some claim are not as efficient as simple selects across
additional permanent tables. (I haven't done the profiling to test this
theory, however.)

On 27/2/02 at 9:18 am, Sommai Fongnamthip [EMAIL PROTECTED] wrote:

 
  Hi,
   MySQL has insert into function and sub select (mysql style) but I
  could not conclude these function togethter.
 
   If I want to select not existing row in 2 table, I used:
 
   SELECT table1.* FROM table1 LEFT JOIN table2 ON
  table1.id=table2.id where table2.id is null
 
  then I'd like to insert the result row back into table2 by this SQL:
 
   insert into table2 SELECT table1.* FROM table1 LEFT JOIN table2
ON
  table1.id=table2.id where table2.id is null
 
   it got this error:
   ERROR 1066: Not unique table/alias: 'table2'
 
   How could I fixed this problem??
 
  Sommai

--
Please be informed that all e-mail which are addressing to
thaithanakit.co.th will need to be changed to
BTsecurities.com by March 1, 2002 Thank you. :-)
--

-
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: Temporary Tables

[DL Neil]

John,

  You have written the following:

 I understand the principles but WHEN should they be used or considered ??

 Any help appreciated

Something of an assumption here that we're all able to recollect an earlier post? Hope 
I'm on the right
wavelength.

I use temporary tables to get over the (current) lacks in MySQL's features:

- sub-selects that cannot be restated as JOINs, eg recursive use of complex GROUP 
functions

- as a substitute for VIEWs (which overlaps the above).

Also for speed/efficiencies:

- where a number of different queries will be performed on (essentially) the same 
subset of a table/join of
tables, and I want to either save repeated hits (hammering) against the db, or where 
I want/need to
force/guarantee (in as much as I can) that the data will be kept in core/RAM and thus 
available at a higher
speed.

Will be interested to hear/learn from, what others have come up with!
=dn



-
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

.net

[Joshua Angolano]

I have tried to use the Mysql++ api with visual C++ .net.  It would not
even compile the library.  
Has anyone had any luck with this??  Maybe there is some setting that I
missed?? Are there any plans to update Mysql++ to work with visual
C++.net??
  Thanks,
 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

RE: Can somebody help me with round (columna,columnb) ?

[Roger Baklund]

* Doug Thompson
 Roger:
 I found using variables to work as expected with 3.23.43 and Win98.
 
 I was unable to duplicate your changing outputs.

I was using a 3.23.30-gamma win2k.

 mysql select @a:=digits,number,round(number,@a) from testme;
 ++--+--+
 | @a:=digits | number   | round(number,@a) |
 ++--+--+
 |  3 | 100.4235 | 100.4230 |
 |  1 |  85.4000 |  85.4000 |
 ++--+--+
 2 rows in set (0.00 sec)

Wouldn't you expect the output to be something like:

 ++--+--+
 | @a:=digits | number   | round(number,@a) |
 ++--+--+
 |  3 | 100.4235 |  100.423 |
 |  1 |  85.4000 | 85.4 |
 ++--+--+

also 100.423... should it not be 100.424?

This is still my win2k 3.23.30-gamma:

mysql select round(100.4234,3),round(100.4235,3),round(100.42350001,3);
+---+---+---+
| round(100.4234,3) | round(100.4235,3) | round(100.42350001,3) |
+---+---+---+
|   100.423 |   100.423 |   100.424 |
+---+---+---+
1 row in set (0.00 sec)

The same statement on solaris 3.23.39-log:

mysql select round(100.4234,3),round(100.4235,3),round(100.42350001,3);
+---+---+---+
| round(100.4234,3) | round(100.4235,3) | round(100.42350001,3) |
+---+---+---+
|   100.423 |   100.424 |   100.424 |
+---+---+---+
1 row in set (0.05 sec)

-- 
Roger
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: Wrong sorting order using cp1257 character set.

[Sinisa Milivojevic]

[EMAIL PROTECTED] writes:
 Description:
   There are a few errors in characters sorting order 
   in sql/share/charsets/cp1257.conf file.
 
   Characters 0xE0 0x5A 0x7A 0xDE 0xFE are treated equaly.
   But accoding Lithuanian standart LST 1285:1993 (if you interested :)
   character 0xE0 should be between 0x61 (a) and 0x62 (b),
   and after 0x5A (Z), 0x7A (z)  should go 0xDE, 0xFE.
   
   

Thanks for your contribution.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.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: .net

[Sinisa Milivojevic]

Joshua Angolano writes:
 Has anyone tried to use the Mysql++ api with visual C++.net?
Thanks,
 Josh
 

As far as I know, no.

But it is worth a try if you have VC++.net.

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.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: .net

[Sinisa Milivojevic]

Joshua Angolano writes:
 I have tried to use the Mysql++ api with visual C++ .net.  It would not
 even compile the library.  
 Has anyone had any luck with this??  Maybe there is some setting that I
 missed?? Are there any plans to update Mysql++ to work with visual
 C++.net??
   Thanks,
  Josh

Have you tried a version for VC++ from MySQL++ page ??

It should compile ...

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.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

Sum function question

[Javier]

 Hi, I have a table like this

   Key   Field-1
   A   string1
   A   string2
   A   string3
   B   string1
   B   string 2

 I want to create a query to get the following result (only one line by key
field):

   A  - string1,string2,string3
   B  - string1,string2

 I try to use the Sum  function but it only works on numbers, ( the number
of occurrences of  key field, is unknown)

 Thanks in advance for any advice that you might have.

 Javier Diaz
IT Developer


 - Scanned for all known viruses by Messagelabs --

-
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

NULL Values in mysqldump

[Baines, Dominic]

This is probably an easy one for someone...

Is here an easy way NOT to have a mysqldump data file that includes /N when the column 
is a NULL ?
Ideally what I'm looking for is a mysqldump option that doesn't put a /N in the data 
file for al the NULL VALUES.

Scripting a global cut or strip out of the /N from the dumpfile can/does work but 
would prefer to learn 
if it's possible to create a mysqldump file without this character.

If you immediately use the dump, this is fine if it is to be used with MySQL but if 
you 
want to port it to another RDBMS the /N for a NULL causes some 'issues'.

I'm sure there must be an method for this...

Regards,

Dominic


-
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

Japanese alpha sorting?

[Egor Egorov]

Paul,
Wednesday, February 27, 2002, 4:47:46 AM, you wrote:

PW Hi,
PW I wish to alphabetically sort data retrieved from MySQL using JSP for
PW web a page. The data will be stored in Japanese. I understand there are
PW multiple alphabets/dialects in Japanese with a large number of characters
PW for each, so this may be difficult / impossible (for the Japanese out there,
PW it will have become clear that I am not Japanese!).
PW Can anyone tell me if this is possible / feasible from MySQL?

Yes, it is possible. You can set ujis or sjis character sets.
Take a look at:
 http://www.mysql.com/doc/c/o/configure_options.html

You can find info about setting character sets.

PW Thanks and regards
PW Paul.








-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.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

Fixing corrupted table

[E.Boyd]

Hi. I am running MySQL 3.22.30, and am having trouble repairing a corrupted
table with isamchk. Everything that I've tried either doesn't work, or wipes
out all the data. Here's what I've tried so far:

***

isamchk -d guestbook

ISAM file: guestbook
Data records: 79764  Deleted blocks:  0
Recordlength:   376
Record format: Packed
Using only 3 keys of 0 possibly keys

table description:
Key Start Len Index   Type

***

isamchk -e guestbook
Checking ISAM file: guestbook
Data records:   79764   Deleted blocks:   0
- check file-size
- check delete-chain
- check index reference
- check records and index references
isamchk: error: Found too long record at 0
ISAM-table 'guestbook' is corrupted
Fix it using switch -r or -o

***

isamchk -o guestbook
isamchk: error: Can't lock indexfile of 'guestbook', error: 11

***

isamchk -r guestbook
- recovering ISAM-table 'guestbook.ISM'
Data records: 79764
Wrong bytesec:   1- 67-  0 at  0; Skipped
Data records: 0

***

Any suggestions on how I can fix this? I would really appreciate it!

Emily


-
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

mysqlhotcopy Problems with Databases/Tables with minus or blanks in name

[Pabst Simon]

Description:
When using mysqlhotcopy for database backups, it fails to backup a Database or Table 
with a minus (-) or blanks in its name, 
for example when using mydb.user-table, mydb.user table, my db.usertable or 
my-db.usertable and says You have an error in your SQL Syntax

How-To-Repeat:
Create a Table or Database with a minus or Blank in its name, for example my 
db.user-list, then run mysqlhotcopy on the corresponding database

Fix: 
?
  

Submitter-Id:  submitter ID
Originator:Simon Pabst
Organization: Siemens Business Services
MySQL support: none
Synopsis:  mysqlhotcopy Problems with Databases/Tables with minus or blanks in name
Severity:  serious
Priority:  high
Category:  mysql
Class: sw-bug
Release:   mysql-3.23.49 (Official MySQL binary)

Environment:
System: SunOS 5.8 Generic_108528-08 sun4u sparc SUNW,Ultra-Enterprise-1
Architecture: sun4

Some paths:  /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs
gcc version 2.95.3 20010315 (release)
Compilation info: CC='gcc'  CFLAGS='-O3 -fno-omit-frame-pointer'  CXX='gcc'  
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'  
LDFLAGS=''
LIBC:
-rw-r--r--   1 root bin  1749356 Jul 20  2000 /lib/libc.a
lrwxrwxrwx   1 root root  11 Mar  6  2001 /lib/libc.so - ./libc.so.1
-rwxr-xr-x   1 root bin  1135056 Jul 20  2000 /lib/libc.so.1
-rw-r--r--   1 root bin  1749356 Jul 20  2000 /usr/lib/libc.a
lrwxrwxrwx   1 root root  11 Mar  6  2001 /usr/lib/libc.so - ./libc.so.1
-rwxr-xr-x   1 root bin  1135056 Jul 20  2000 /usr/lib/libc.so.1
Configure command: ./configure  --prefix=/lvol1/mysql '--with-comment=Official MySQL 
binary' --with-extra-charsets=complex --with-server-suffix= 
--enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared
Perl: This is perl, v5.6.1 built for sun4-solaris-multi

Sincerely
Simon Pabst

-
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

Client installation by itself?

[Carl McNamee]

Is it possible to install just the mysql client software for NT?  The only
client distributions I can find include the mysql server as well.

Carl McNamee
Systems Administrator
Billing Concepts
(210) 949-7282


-
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

OT: Please Somebody can explain me what this message means??? Fw: ezmlm warning

[Walter D. Funk]

Sorry for the length of this message, but, I don´t understand what it means,
and why it says my address will be removed from the list without
explanation.

thanx

- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 27, 2002 12:58 AM
Subject: ezmlm warning


 Hi! This is the ezmlm program. I'm managing the
 [EMAIL PROTECTED] mailing list.


 Messages to you from the mysql mailing list seem to
 have been bouncing. I've attached a copy of the first bounce
 message I received.

 If this message bounces too, I will send you a probe. If the probe
bounces,
 I will remove your address from the mysql mailing list,
 without further notice.


 I've kept a list of which messages from the mysql mailing list have
 bounced from your address.

 Copies of these messages may be in the archive.
 To retrieve a set of messages 123-145 (a maximum of 100 per request),
 send an empty message to:
[EMAIL PROTECTED]

 To receive a subject and author list for the last 100 or so messages,
 send an empty message to:
[EMAIL PROTECTED]

 Here are the message numbers:

98921
98918
98916
98924
98919
98920
98917
98922
98949
98950
98951
98934
98943
98956
98957
98925
98958
98927
98959
98947
98923
98935
98940
98939
98944
98928
98931
98926
98960
98936
98946
98932
98942
98938
98937
98929
98930
98941
98933
98948
98945
98987
98988
98981
98982
98983
98978
98979
98976
98977
98974
98964
98963
98980
98984
98967
98968
98962
98965
98969
98952
98953
98954
98961
98955
98989
98975
98986
98985
98972
98973
98970
98992
98971
98990
98966
99006
99000
98993
98994
98991
99002
98995
98996
99003
98997
99004
98998
98999
99009
99007
99001
99005
99008
99014
99015
99013
99011
99010
99016
99012
99017
99025
99026
99031
99030
99032
99027
99018
99019
99020
99022
99021
99036
99034
99033
99028
99023
99029
99024
99042
99037
99041
99038
99045
99043
99049
99040
99047
99044
99048
99039
99046
99051
99050
99035
99052
99053
99054
99055
99056
99064
99063
99057
99058
99059
99067
99061
99068
99070
99060
99062
99071
99069
99065
99072
99066
99079
99075
99085
99076
99087
99093
99088
99078
99081
99077
99074
99082
99084
99080
99073
99090
99089
99083
99086
99101
99100
99107
99105
99106
99102
99109
99094
99108
99095
99103
99092
99091
99098
99104
99096
99097
99099
99111
99119
99120
99114
99123
99117
99118
99112
99110
99115
99132
99137
99139
99140
99113
99136
99149
99147
99116
99148
99131
99144
99145
99146
99141
99127
99126
99130
99133
99135
99125
99124
99129
99128
99160
99122
99121
99134
99163
99150
99153
99152
99151
99158
99157
99138
99155
99142
99156
99143
99154
99164
99165
99166
99162
99159
99161

 --- Enclosed is a copy of the bounce message I received.

 Return-Path: 
 Received: (qmail 23324 invoked for bounce); 15 Feb 2002 08:23:05 -
 Date: 15 Feb 2002 08:23:05 -
 From: [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 MIME-Version: 1.0
 Content-Type: multipart/mixed; boundary=1013152904web.mysql.com305023
 Subject: failure notice

 Hi. This is the qmail-send program at web.mysql.com.
 I'm afraid I wasn't able to deliver your message to the following
addresses.
 This is a permanent error; I've given up. Sorry it didn't work out.

 [EMAIL PROTECTED]:
 66.109.98.8 does not like recipient.
 Remote host said: 550 5.7.1 [EMAIL PROTECTED]... Relaying denied.
Please check your mail first.
 Giving up on 66.109.98.8.





-
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: Sum function question

[DL Neil]

Hi Javier,

 Hi, I have a table like this
 
Key   Field-1
A   string1
A   string2
A   string3
B   string1
B   string 2
 
  I want to create a query to get the following result (only one line by key
 field):
 
A  - string1,string2,string3
B  - string1,string2
 
  I try to use the Sum  function but it only works on numbers, ( the number
 of occurrences of  key field, is unknown)


Relational queries are performed on tables. The result of such a query will also be a 
table.
AFAIK there is no serialisation facility - you would need to post-process using 
another tool/language.

Regards,
=dn



-
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

many field insert

[Egor Egorov]

Sommai,
Wednesday, February 27, 2002, 11:29:30 AM, you wrote:

SF Hi,
SF I have to insert data to table which has many fields (252 fields). This 
SF table was successful update by the LOAD DATA infile. But when I generate 
SF SQL statement with from VB, SQL statment length got more than 1000 byte.  I 
SF was try many time to re-check SQL syntax but I still can not insert data 
SF into mysql table.  Is there any problem with my SQL?

What type of error did you receive?
What is your SQL statement?

SF Sommai






-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.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

php - apache compilation

[Victoria Reznichenko]

Oladejo,
Wednesday, February 27, 2002, 3:04:05 AM, you wrote:
Oeoen Hi All,

Oeoen I am trying to compile php with mysql and apache into it, however during the
Oeoen ./configure, I keep getting Invalid Apache directory - unable to find
Oeoen httpd.h under /usr/include/apache, even though that is where the header
Oeoen file httpd.h is. I am using Redhat 7.1. does anyone know the rigth path to
Oeoen apache directory on 7.1 RH.

You should set your apache source dir.
For example:
./configure --with-mysql --with-apache=/install/Apache/apache_1.3.23rusPL30.10

Oeoen Thanx
Oeoen All


-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.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: NULL Values in mysqldump

[Keith C. Ivey]

On 27 Feb 2002, at 8:18, Baines, Dominic wrote:

 If you immediately use the dump, this is fine if it is to be used
 with MySQL but if you want to port it to another RDBMS the /N for
 a NULL causes some 'issues'.

If you don't care about the difference between NULL and the empty 
string or 0, why not just set the columns to NOT NULL and be done 
with it?  If you do care about the difference, how do you propose to 
preserve it when you're porting to another database?

--Keith

Filter fodder: SQL, query

-- 
Keith C. Ivey [EMAIL PROTECTED]
Washington, DC

-
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: NuSphere v. MySQL 4

[Britt Johnston]

Please be careful of reading only half of the story, unfortunately the
article in question only talks about  

 -Original Message-
 From: Tyler Longren [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, February 26, 2002 3:25 PM
 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Subject: Re: NuSphere v. MySQL 4
 
 
 I suggest you use MySQL from MySQL AB.  Progress Software (parent of
 NuSphere), is having some legal troubles.
 
 http://www.newsforge.com/article.pl?sid=02/02/26/1825200
 
 Tyler
 
 - Original Message -
 From: [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Tuesday, February 26, 2002 1:01 PM
 Subject: NuSphere v. MySQL 4
 
 
  Hello,
 
  I'm not sure if this list is appropriate for this issue but 
 I'll go ahead
  ask for your input anyway. We're trying to decide to choose DBMS as a
  backend of our web portal. The portal will take online orders and other
  requests from end users and this is going to be available 
 enterprise wide
  (WAN) for approx. 19,000 employees. As Oracle license cost is 
 getting too
  high for this purpose, I'm thinking of using MySQL instead. 
 However, I saw
  two different versions here (NuSphere vs. MySQL AB) and cannot decide
 which
  one is better to use.
 
  Now, my questions are:
 
  1. What would be your recommendation for me to use, what are the
 advantages
  / disadvantages of using NuSphere's (or MySQL AB's) products other than
 the
  different pricing here?
 
  2. Is it true that Gemini type table from NuSphere is much better than
  other types (e.g. InnoDB). How about the installation and config
  themselves, any issues I should know about from each product? 
 We're going
  to install it on a W2000 server on the same box as the web portal.
 
  3. Is it safe enough to use MySQL v.4.0.1 instead of 3.23.49. How about
 the
  MAX 4.0.1., is this better? Although reliability is important this
  application is not mission critical.
 
  Sorry for the many questions, but I'm really new to MySQL and I want to
  feel comfortable with it before I decide to use this. I'd greatly
  appreciate any input from all of you.
 
 
  Thanks,
  Martin
 
 
 
 
 
 
  **Disclaimer**
  This  Memo and any attachments, may be confidential and legally
 privileged.
  If  you  are  not  the  intended recipient and have received this in
 error,
  kindly  destroy  this  message  and  notify the sender.  Thank you for
 your
  assistance.
 
 
  -
  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: Client installation by itself?

[Scalper]

I asked this question as well some time back and got the standard answer 
'READ THE MANUAL'.  However, I still never found the answer to my question, 
so when I get closer to deployment, I am going to experiment.  I am 
thinking that only MyODBC installation is required on the client and 
possibly one or more of the following files:

libmysql.dll
libmysql.lib
mysqlclient.lib

Perhaps someone can shed some light on this?  Otherwise, I am going to have 
to just do some trial and error.  Let me know, Carl, if you find out.

Craig O.

At 08:16 2/27/02 -0600, you wrote:
Is it possible to install just the mysql client software for NT?  The only
client distributions I can find include the mysql server as well.

Carl McNamee
Systems Administrator
Billing Concepts
(210) 949-7282


-
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

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

Changed localhost?

[Anthony Rodriguez]

All of a sudden Apache and MySQL are not running correctly under Windows 98.

It appears that somehow localhost was changed from 127.0.0.1 to something else.

Could the fact that I NOW have a 24/7cable connection to the Net cause the
problem?

Thanks!

Anthony Rodriguez
([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: replication issue

[Michael Douglass]

David,

  I am seeing the exact same thing on some Solaris boxen.  My database
sees a couple of updates every minute or two; and show slave status on
the slave always appears to lag behind the master.  The data in my
tables lag as well as I've done some rudimentary checksumming and have
found differences.  I've found that if I go to each slave and do a slave
stop and a slave start that it restarts the slave connection and then
runs through all of the new changes.

Mysql community,

  Thoughts as to what could be causing this?  I am using --replicate-do-
db command to replicate only a single database; that's about the only
thing I can think of that is special about my setup.

Thanks,

On Mon, Feb 11, 2002 at 10:24:46AM -0800, David Piasecki said:
 I've recently set up replication on one of my databases. Both master and
 slave are running MySQL 3.23.46 on FreeBSD 4.1. The only tables that get
 updated or inserted into hold approximately 140,000 records, growing at
 a rate of around 50-100 every day. The issue is it is currently taking
 approximately 20-30 minutes for an update/insert that occurs on the
 master to show up on the slave. An insert operation on the master
 usually only takes a second or so, so it doesn't make sense that it
 should take so long for the slave to update. There is nothing
 non-standard about either table - each contains approximately 20
 columns, one auto-increment field, and one index.
 
 Hoping someone has some insight into this matter... BTW, both servers
 are on the same private network, literally being right next to each
 other, so I know it's not a network issue.
 
 
 David Piasecki
 
 
 
 -
 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

-- 
Michael Douglass
Chief System Engineer
Texas Networking, Inc.  (512-794-7123)

-
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 installation on linux(RH7.2)

[nagendra prasad]

hi
i downloaded mysql rpms from mysql.com
 tried to install them on linux.
when i use the command rpm -i mysqlpackname in shell
it says

error:can't get exclusive lock on /var/lib/rpm/packages
error:can't open packages database in /var/lib/rpm

what shall i do.
later i managed to install it using both Red Carpet(ximian 
product),kpackage.in both the cases it gave installation finished 
,
but when i to try to configure php with mysql giving the path of 
mysql header files(/usr/include/mysql)
it says no header files r found in this dir.
but when i checked the file list using kpackage, i found all the 
header files in the same dir(/usr/include/mysql)
i don't understand what to .
HELP ME
I'M STRUCK
regards
prasad

-
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: NULL Values in mysqldump

[Baines, Dominic]

There is a huge difference between a NULL and NOT NULL  and an empty string
and it would be handled in the table definition statements of the 'new' RDBMS
usually with a default column setting.

However, in this case the MySQL columns values are NULL the problem 
(if it is one) is that /N does not mean NULL in other RDBMS and you have 
to craft a method of converting or parsing the data either at load or 
pre-load to another format to allow for the /N. 

e.g. Oracle would use a nullif (column name =//N) in a sql load script but
that is a real pain to have to do with a large number of tables involved.

There does not appear to be any way to figure out an alternative method
of outputing a NULL value... that was what I was driving at...

If it were possible to produce a csv file say where the values for a 
row were exportable as:

7543753, 4545, hgchkgc,

or

7543753, 4545, 'hgchkgc','','',,'',''

Instead of:

7543753, 4545, hgchkgc,/N,/N,/N,/N,/N

Where you can see the difference between a string and numerical null 
columns even 

I'd be happier 

Is this possible at MySQL mysqldump execution time.

Regards,

Dominic


-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]]
Sent: 27 February 2002 15:12
To: [EMAIL PROTECTED]
Subject: Re: NULL Values in mysqldump


On 27 Feb 2002, at 8:18, Baines, Dominic wrote:

 If you immediately use the dump, this is fine if it is to be used
 with MySQL but if you want to port it to another RDBMS the /N for
 a NULL causes some 'issues'.

If you don't care about the difference between NULL and the empty 
string or 0, why not just set the columns to NOT NULL and be done 
with it?  If you do care about the difference, how do you propose to 
preserve it when you're porting to another database?

--Keith

Filter fodder: SQL, query

-- 
Keith C. Ivey [EMAIL PROTECTED]
Washington, DC

-
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: Changed localhost?

[Xavier Prelat [webcentric]]

Hi,
Localhost is always associated to at least 127.0.0.1 IP, however you can add
as many IP adresses as you want to your machine by using TCP/IP properties
window in your control panel.

As long as you add IP adresses  (reference them in tcp/ip layer) your apache
will handle the HTTP request.
It will response to http request on 127.0.0.1 anytime (when started!).
If you add an IP, and you do want to call apache through this IP, you have
to add a listen directive to your apache httpd.conf configuration file.
see apache doc for more information.

In the case where your Internet provider uses the DHCP to give you a new IP
adresse, you should call your apache/mysql using localhost name or 127.0.01
IP!

Hope it helps

Xavier Prelat
Chief Technical Officer
[EMAIL PROTECTED]
WEBCENTRIC
25 rue de Ponthieu
75008 PARIS - FRANCE


-Message d'origine-
De : Anthony Rodriguez [mailto:[EMAIL PROTECTED]]
Envoye : mercredi 27 fevrier 2002 15:58
A : [EMAIL PROTECTED]
Objet : Changed localhost?


All of a sudden Apache and MySQL are not running correctly under Windows 98.

It appears that somehow localhost was changed from 127.0.0.1 to something
else.

Could the fact that I NOW have a 24/7cable connection to the Net cause the
problem?

Thanks!

Anthony Rodriguez
([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: Can somebody help me with round (columna,columnb) ?

[Doug Thompson]

On Wed, 27 Feb 2002 13:53:15 +0100, Roger Baklund wrote:

* Doug Thompson

 I found using variables to work as expected with 3.23.43 and Win98.
 
 I was unable to duplicate your changing outputs.

I was using a 3.23.30-gamma win2k.

 mysql select @a:=digits,number,round(number,@a) from testme;
 ++--+--+
 | @a:=digits | number   | round(number,@a) |
 ++--+--+
 |  3 | 100.4235 | 100.4230 |
 |  1 |  85.4000 |  85.4000 |
 ++--+--+
 2 rows in set (0.00 sec)

Wouldn't you expect the output to be something like:

 ++--+--+
 | @a:=digits | number   | round(number,@a) |
 ++--+--+
 |  3 | 100.4235 |  100.423 |
 |  1 |  85.4000 | 85.4 |
 ++--+--+


No, I would expect the output to inherit the field type of number and display the 
same way.


also 100.423... should it not be 100.424?

As you know, some systems/packages round down 0.xx50 while other round up from that 
value.  I agree that intuitively 
it should round up, but it is only a matter about which we need to be aware unless the 
application is critical -- 
control systems come to mind -- and then you compensate in the software design if it's 
needed.  It's a function of how 
the floating point hardware performs storage and manipulation of values in response to 
the instructions and how the 
software processes the calls.  It is reasonable to expect consistent behavior within a 
given processor family, but 
that's about all we can hope for. 

For example, I'm running an AMD K6/2-500 processor.  Your system likely has an Intel 
cpu.  Then there are still 
different results from a Sun system.  Your results brought the issues to light.  I 
wonder if there's a reasonable fix.


This is still my win2k 3.23.30-gamma:

mysql select round(100.4234,3),round(100.4235,3),round(100.42350001,3);
+---+---+---+
| round(100.4234,3) | round(100.4235,3) | round(100.42350001,3) |
+---+---+---+
|   100.423 |   100.423 |   100.424 |
+---+---+---+
1 row in set (0.00 sec)

The same statement on solaris 3.23.39-log:

mysql select round(100.4234,3),round(100.4235,3),round(100.42350001,3);
+---+---+---+
| round(100.4234,3) | round(100.4235,3) | round(100.42350001,3) |
+---+---+---+
|   100.423 |   100.424 |   100.424 |
+---+---+---+
1 row in set (0.05 sec)

-- 
Roger

Just when we thought it might be safe to go in the water ;-)

Regards,
Doug
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: NULL Values in mysqldump

[Keith C. Ivey]

On 27 Feb 2002, at 10:31, Baines, Dominic wrote:

 However, in this case the MySQL columns values are NULL the problem 
 (if it is one) is that /N does not mean NULL in other RDBMS and you have 
 to craft a method of converting or parsing the data either at load or 
 pre-load to another format to allow for the /N. 

Are you saying that other RDBMSs do use an empty string to represent 
NULL in CSV files?  If so, I still don't understand how they're 
supposed to know whether a NULL or an empty string is intended.  If 
not, it seems what you really want is a way to specify how NULL is 
represented in the export.  (By the way, it's actually a backslash, 
not a slash, in \N.)

If you have Perl, then stripping out the \N after export is as easy 
as

perl -pi.bak -es/\\N//g filename

(with perhaps slight adjustments to the exact syntax depending on 
your shell), and changing it to something else is just as easy.  You 
can do similar things with other languages.  I don't think there's an 
answer in MySQL itself.

[Filter fodder: SQL, query]


-- 
Keith C. Ivey [EMAIL PROTECTED]
Washington, DC

-
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

Changed localhost?

[Egor Egorov]

Anthony,
Wednesday, February 27, 2002, 4:58:09 PM, you wrote:

AR All of a sudden Apache and MySQL are not running correctly under Windows 98.
AR It appears that somehow localhost was changed from 127.0.0.1 to something else.

No, localhost is 127.0.0.1
What type of error did you recieve?

AR Thanks!
AR Anthony Rodriguez





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.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

Client installation by itself?

[Victoria Reznichenko]

Carl,
Wednesday, February 27, 2002, 4:16:51 PM, you wrote:

CM Is it possible to install just the mysql client software for NT?  The only
CM client distributions I can find include the mysql server as well.

Take a look at MySQLGUI and MyCC. You can find them at:
 http://www.mysql.com/downloads/gui-clients.html

CM Carl McNamee




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.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

order by date error!!!

[Wakan]

Hi,
I've noticed this problem, even if I don't know if it's really a mysql problem:
if I store a date in standard format, in a date field, all kinds of 
ordering are OK.
But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'),
the order by clause attempt to order the new format incorrectly, because
I've an output like this: 12-2-2002, 12-3-2002, 12-4-2002, and 13-2-2002!!!
What can you say about this?
Carlo


-
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

Query Problem...

[asherh]

Hi,

I am using MySQL 3.22.32 and are trying to accomplish the following (without
going into too much detail, this is an example of the exact situation)...

1) I have two tables:

 a) User table containing: UserID, FullName
 b) Project table containing: ProjectID, ProjectManagerID and ProjectOwnerID

 ProjectManagerID and ProjectOwnerID are effectively UserIDs from the User
table.

2) When I pull a particular record from the database by ProjectID, for
readability purposes, I would like the accompanying ProjectManagerID and
ProjectOwnerID to
be displayed as a name, not an ID (for example: John Smith, not A12930).

Has anyone got any ideas how I can select (within one record) both names
from the User table by each respective UserID (represented by the
ProjectManagerID and the ProjectOwnerID)??

Thanks,
Ash



-
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

www-mysql package

[Marek Wysmulek]

Dear all.

Has anyone practice in www-mysql package ?
I've installed apache, www-mysql. And so ? What next.

Marek Wysmulek.




-
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

perl mysql DBI::db question

[Shon Stephens]

i am trying to write a program in perl and am getting a mysql error from my
module. here is the error:

DBI::db=HASH(0x294738)-disconnect invalidates 1 active statement handle
(either destroy statement handles or call finish on them before
disconnecting) at ./pop.pl line 124, GEN1 line 2.

i think a finish statement is what i need, but i don't know how to exec it
properly. here is the code loop that generates this message

   my $sql_check = $dbh-prepare(select user,password,prefs from users
where username='$LNAME');
# I dont like the below die statement, it should exit gracefully.
$sql_check-execute or die Can't connect to users table :
$dbh-errstr;
my ($t_user,$t_password,$t_prefs) = $sql_check-fetchrow_array();
$dbh-disconnect;
if($debug_state) {
print S: $t_user,$t_password,$t_prefs\n;
}

thanks,
shon



-
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: order by date error!!!

[Andreas Frøsting]

 But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'),
 the order by clause attempt to order the new format 
 incorrectly, because
 I've an output like this: 12-2-2002, 12-3-2002, 12-4-2002, 
 and 13-2-2002!!!

I normally do this:

SELECT DATE_FORMAT(datefield,'%d-%m-%Y') as datefield FROM table ORDER
BY table.datefield

This forces mysql to order by the data in the table instead of the
result 'datefield' (note the same name of both the field and the
result).

:wq
//andreas
http://phpwizard.dk


-
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: order by date error!!!

[Keith C. Ivey]

Wakan [EMAIL PROTECTED] wrote:

 But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'),
 the order by clause attempt to order the new format incorrectly, because
 I've an output like this: 12-2-2002, 12-3-2002, 12-4-2002, and 13-2-2002!!!
 What can you say about this?

Can you give an example of a query that has the problem?  It sounds 
like you're using DATE_FORMAT() in the ORDER BY as well as in the 
SELECT.  If you do SELECT DATE_FORMAT(data,'%d-%m-%Y') ORDER BY data, 
and data is a DATE or DATETIME, then you shouldn't have that problem.

-- 
Keith C. Ivey [EMAIL PROTECTED]
Washington, DC

-
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

core dump in clients in MYSQL 3.23.49 using groups

[lwa]

Description:

When using groups in 3.23.49, client dumps core.
This bug sounds to be new (it does not appear in 3.23.41)

How-To-Repeat:

Just compile a little C client (you can also dump cores with DBI perl
module) :

% cat bug.c
#include mysql/mysql.h
#include stdio.h

int main(void) {
  MYSQL mysql;
  mysql_init(mysql);
  mysql_options(mysql, MYSQL_READ_DEFAULT_GROUP, bug);
  mysql_real_connect(mysql, NULL, NULL, NULL, NULL, 0, NULL, 0);
  return 0;
}
% cat $HOME/.my.cnf
[bug]
host=foobar
% cc -I/usr/local/include -g bug.c -o bug -L/usr/local/lib/mysql -lmysqlclient
% gdb bug
(gdb) run
Starting program: /home/lwa/tmp/mbug/bug 

Program received signal SIGSEGV, Segmentation fault.
strcend (s=0x804efff - Error reading address 0x804f000: Bad address, c=95)
at strcend.c:51
51   if (*s == (char) c) return (char*) s;
(gdb) where
#0  strcend (s=0x804efff - Error reading address 0x804f000: Bad address, 
c=95) at strcend.c:51
#1  0x280700f6 in mysql_read_default_options (options=0xbfbff400, 
filename=0x28081442 my, group=0x804b030 bug) at libmysql.c:715
#2  0x28070a64 in mysql_real_connect (mysql=0xbfbff270, host=0x0, user=0x0, 
passwd=0x0, db=0x0, port=0, unix_socket=0x0, client_flag=0)
at libmysql.c:1189
#3  0x80485e2 in main () at bug.c:8
#4  0x80484c3 in _start ()
(gdb) print (char *)0x804d000
$1 = 0x804d000 [bug]\n\thost=foobar\n, '-' repeats 181 times...
(gdb) 


Fix:

After the core, the memory is full of '-'.

I suspect the following newly added lines in 
libmysql/libmysql.c:mysql_read_default_options() :

/* Change all '_' in variable name to '-' */
for (end= *option ; (end= strcend(end,'_')) ; )
  *end= '-';


Submitter-Id:  submitter ID
Originator:Laurent Wacrenier
Organization:  France Teaser
MySQL support: none
Synopsis:  core dump in clients using groups
Severity:  critical
Priority:  medium
Category:  mysql
Class: sw-bug
Release:   mysql-3.23.49 (FreeBSD port: mysql-server-3.23.49)

Environment:

System: FreeBSD victor.teaser.fr 5.0-CURRENT FreeBSD 5.0-CURRENT #3: Fri Feb  1 
15:12:56 CET 2002 [EMAIL PROTECTED]:/usr/src/sys/i386/compile/VICTOR  i386


Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 20010315 (release)
Compilation info: CC='cc'  CFLAGS='-O9 -mpentiumpro -pipe -g -march=pentiumpro'  
CXX='cc'  CXXFLAGS='-O9 -mpentiumpro -pipe -g -march=pentiumpro -felide-constructors 
-fno-rtti -fno-exceptions'  LDFLAGS=''
LIBC: 
-r--r--r--  1 root  wheel  1463360  1 fév 14:58 /usr/lib/libc.a
lrwxr-xr-x  1 root  wheel  9  1 fév 14:58 /usr/lib/libc.so - libc.so.5
-r--r--r--  1 root  wheel  732000  1 fév 14:58 /usr/lib/libc.so.5
Configure command: ./configure  --localstatedir=/var/db/mysql --without-perl 
--without-debug --without-readline --without-bench --with-mit-threads=no 
--with-libwrap --with-low-memory '--with-comment=FreeBSD port: mysql-server-3.23.49' 
--enable-assembler --with-berkeley-db --with-innodb --prefix=/usr/local 
i386-portbld-freebsd5.0


-
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: perl mysql DBI::db question

[Mike(mickalo)Blezien]

Try moving your $dbh-disconnect call after it prints out the fetchrow_array() 

 my ($t_user,$t_password,$t_prefs) = $sql_check-fetchrow_array();
 if($debug_state) {
 print S: $t_user,$t_password,$t_prefs\n;
}
$dbh-disconnect();

If your using an older version of DBI, like 1.13 or .14 you may need to call the
finish() after you execute() your statement handle.

sql,database,mysql

On Wed, 27 Feb 2002 11:07:51 -0500, Shon Stephens
[EMAIL PROTECTED]   wrote:

i am trying to write a program in perl and am getting a mysql error from my
module. here is the error:

DBI::db=HASH(0x294738)-disconnect invalidates 1 active statement handle
(either destroy statement handles or call finish on them before
disconnecting) at ./pop.pl line 124, GEN1 line 2.

i think a finish statement is what i need, but i don't know how to exec it
properly. here is the code loop that generates this message

   my $sql_check = $dbh-prepare(select user,password,prefs from users
where username='$LNAME');
# I dont like the below die statement, it should exit gracefully.
$sql_check-execute or die Can't connect to users table :
$dbh-errstr;
my ($t_user,$t_password,$t_prefs) = $sql_check-fetchrow_array();
$dbh-disconnect;
if($debug_state) {
print S: $t_user,$t_password,$t_prefs\n;
}

Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

-
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: order by date error!!!

[Joseph Bueno]

Hi,

Wakan wrote :
 
 Hi,
 I've noticed this problem, even if I don't know if it's really a mysql problem:
 if I store a date in standard format, in a date field, all kinds of
 ordering are OK.
 But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'),
 the order by clause attempt to order the new format incorrectly, because
 I've an output like this: 12-2-2002, 12-3-2002, 12-4-2002, and 13-2-2002!!!
 What can you say about this?

Nothing until you show us your query.

I suspect that you are ordering by formatted date, which is a string, instead
of date; but you don't give enough information to confirm that !

 Carlo
 

Regards
--
Joseph Bueno
NetClub/Trader.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: perl mysql DBI::db question

[Mike(mickalo)Blezien]

On Wed, 27 Feb 2002 10:40:21 -0600, nickg [EMAIL PROTECTED]   wrote:


You need to tell the handler you are finished with your statement, this will
free resources, etc..

http://www.savebaseball.com/mysql/DBD_3.21.X.php3#finish


$sql_check-finish;

EXTREMELY out-dated!

MySQL Version: 3.21.X
DBI.pm Version 0.93   = current 1.21
DBD::mysql.pm Version 1.1832  = current 2.2

I would not even consider using this for any type of reference. FYI, finish() is
not necessary. Read the man pages of the DBI docs :)

sql,mysql,database
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

-
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: NuSphere v. MySQL 4

[Britt Johnston]

Please be careful of reading only half of the story, unfortunately
the article in question only talks about half of the issues.  See
http://www.nusphere.com/releases/index.htm for more information and related
documents.

Britt...

  -Original Message-
  From: Tyler Longren [mailto:[EMAIL PROTECTED]]
  Sent: Tuesday, February 26, 2002 3:25 PM
  To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
  Subject: Re: NuSphere v. MySQL 4
 
 
  I suggest you use MySQL from MySQL AB.  Progress Software (parent of
  NuSphere), is having some legal troubles.
 
  http://www.newsforge.com/article.pl?sid=02/02/26/1825200
 
  Tyler
 
  - Original Message -
  From: [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Tuesday, February 26, 2002 1:01 PM
  Subject: NuSphere v. MySQL 4
 
 
   Hello,
  
   I'm not sure if this list is appropriate for this issue but
  I'll go ahead
   ask for your input anyway. We're trying to decide to choose DBMS as a
   backend of our web portal. The portal will take online orders
 and other
   requests from end users and this is going to be available
  enterprise wide
   (WAN) for approx. 19,000 employees. As Oracle license cost is
  getting too
   high for this purpose, I'm thinking of using MySQL instead.
  However, I saw
   two different versions here (NuSphere vs. MySQL AB) and cannot decide
  which
   one is better to use.
  
   Now, my questions are:
  
   1. What would be your recommendation for me to use, what are the
  advantages
   / disadvantages of using NuSphere's (or MySQL AB's) products
 other than
  the
   different pricing here?
  
   2. Is it true that Gemini type table from NuSphere is much better than
   other types (e.g. InnoDB). How about the installation and config
   themselves, any issues I should know about from each product?
  We're going
   to install it on a W2000 server on the same box as the web portal.
  
   3. Is it safe enough to use MySQL v.4.0.1 instead of 3.23.49.
 How about
  the
   MAX 4.0.1., is this better? Although reliability is important this
   application is not mission critical.
  
   Sorry for the many questions, but I'm really new to MySQL and
 I want to
   feel comfortable with it before I decide to use this. I'd greatly
   appreciate any input from all of you.
  
  
   Thanks,
   Martin
  
  
  
  
  
  
   **Disclaimer**
   This  Memo and any attachments, may be confidential and legally
  privileged.
   If  you  are  not  the  intended recipient and have received this in
  error,
   kindly  destroy  this  message  and  notify the sender.  Thank you for
  your
   assistance.
  
  
   -
   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




-
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: perl mysql DBI::db question

[Shon Stephens]

i am using the older v1.19 DBI. i looked at that line and it should not
cause a problem. the values are stored, even after the handle is destroyed
or the connection closed. the error is complaining that i should destroy
statement handles or call finish. thanks for the respones.

- Original Message -
From: Mike(mickalo)Blezien [EMAIL PROTECTED]
To: Shon Stephens [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, February 27, 2002 11:32 AM
Subject: Re: perl mysql DBI::db question


Try moving your $dbh-disconnect call after it prints out the
fetchrow_array()

 my ($t_user,$t_password,$t_prefs) = $sql_check-fetchrow_array();
 if($debug_state) {
 print S: $t_user,$t_password,$t_prefs\n;
}
$dbh-disconnect();

If your using an older version of DBI, like 1.13 or .14 you may need to call
the
finish() after you execute() your statement handle.

sql,database,mysql

On Wed, 27 Feb 2002 11:07:51 -0500, Shon Stephens
[EMAIL PROTECTED]   wrote:

i am trying to write a program in perl and am getting a mysql error from
my
module. here is the error:

DBI::db=HASH(0x294738)-disconnect invalidates 1 active statement handle
(either destroy statement handles or call finish on them before
disconnecting) at ./pop.pl line 124, GEN1 line 2.

i think a finish statement is what i need, but i don't know how to exec it
properly. here is the code loop that generates this message

   my $sql_check = $dbh-prepare(select user,password,prefs from
users
where username='$LNAME');
# I dont like the below die statement, it should exit gracefully.
$sql_check-execute or die Can't connect to users table :
$dbh-errstr;
my ($t_user,$t_password,$t_prefs) = $sql_check-fetchrow_array();
$dbh-disconnect;
if($debug_state) {
print S: $t_user,$t_password,$t_prefs\n;
}

Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=


-
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: Query Problem...

[DL Neil]

Hi Ash,

 I am using MySQL 3.22.32 and are trying to accomplish the following (without
 going into too much detail, this is an example of the exact situation)...

 1) I have two tables:

  a) User table containing: UserID, FullName
  b) Project table containing: ProjectID, ProjectManagerID and ProjectOwnerID

  ProjectManagerID and ProjectOwnerID are effectively UserIDs from the User
 table.

 2) When I pull a particular record from the database by ProjectID, for
 readability purposes, I would like the accompanying ProjectManagerID and
 ProjectOwnerID to
 be displayed as a name, not an ID (for example: John Smith, not A12930).

 Has anyone got any ideas how I can select (within one record) both names
 from the User table by each respective UserID (represented by the
 ProjectManagerID and the ProjectOwnerID)??


This is quite logical (when you look back at it!). Set up two joins from Project to 
User, the first equating
ProjectManagerID to UserID and the second ProjectOwnerID to UserID - just because User 
is only one table,
doesn't mean you can't have multiple ways of joining to it!

If that's not it, please send the query you have so far.

Regards,
=dn




-
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 installation on linux(RH7.2)

[Trond Eivind Glomsrød]

nagendra  prasad [EMAIL PROTECTED] writes:

 hi
 i downloaded mysql rpms from mysql.com
  tried to install them on linux.
 when i use the command rpm -i mysqlpackname in shell
 it says
 
 error:can't get exclusive lock on /var/lib/rpm/packages
 error:can't open packages database in /var/lib/rpm
 
 what shall i do.

Install as root.

-- 
Trond Eivind Glomsrød
Red Hat, 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

Re: BIIIG problem with some of the records

[DL Neil]

Hi Edward,
[I've put this back on the list - others will be able to share their wisdom/you might 
not have to wait so long
for me to get around to a reply!]

My first thought is that you have a neat system of encoding the link data being stored 
in MySQL.

I assume this is preceded by some sort of 'extract' function which takes the link out 
of some HTML page? That
being the case, and particularly if you are using a PREGI to accomplish the 
'extraction', why don't you store
the two components of the HTML link in two separate columns? So a 
href=http://www.test.com; test /a could
become www.test.com and test. The disassembly step being part of the (presumed) 
existing PREGI and
reassembly afterwards being a snap - seems easier than all those EREGI_REPLACEs!


 Here is the code for input:
 -- cut-
 mysql_select_db(falrdb,$con) or die (nu pot);
*
 $chtml=eregi_replace('',' \[st]',$chtml);
*
 $chtml=eregi_replace('','\[dr] ',$chtml);
*
 $ins= INSERT INTO continut (cef) VALUES
  '$chtml');$rezins=mysql_db_query(falrdb, $ins, $con);
**
 -cut--

 Here is the code for output:

 ---cut--

 $q=select * from continut;

 $rez=mysql_db_query(falrdb,$q);
**
 $zz=mysql_fetch_row($rez);
*
 $zz[0]=eregi_replace('\[st]','',$zz[0]);
*
 $zz[0]=eregi_replace('\[dr]','',$zz[0]);
*
 $zz_fsh=stripslashes($zz[0]);
*
 echo $zz[0];

 -cut---


Do I observe STRIPSLASHES() but no ADDSLASHES()?

Recommend the addition of a debug ECHO BRchtml=$chtml~; (or equivalent) at every 
line where I have marked *.

Recommend the addition of a validation step to assure the MySQL interface calls where 
I have marked **.

The last/only ECHO statement examines the reconstituted HTML link BEFORE the call to 
STRIPSLASHES() - not the
resultant value!?

Is cef the first field in continut?

 I hope that it will be OK for debugging... If not, I'll send you more

Don't hesitate to be 'generous' - the more you show, the better the chance that we'll 
spot something out of
place!

Once you have added the above debugging ECHOs, please run the routine and show what 
happens with a sample that
works, and then two or three samples that don't.

Regards,
=dn



-
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: Client installation by itself?

[Venu]

Hi,  

 -Original Message-
 From: Scalper [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, February 27, 2002 6:53 AM
 To: [EMAIL PROTECTED]
 Subject: Re: Client installation by itself?
 
 
 I asked this question as well some time back and got the standard answer 
 'READ THE MANUAL'.  However, I still never found the answer to my 
 question, 
 so when I get closer to deployment, I am going to experiment.  I am 
 thinking that only MyODBC installation is required on the client and 
 possibly one or more of the following files:
 
 libmysql.dll
 libmysql.lib
 mysqlclient.lib
 
 Perhaps someone can shed some light on this?  Otherwise, I am 
 going to have 
 to just do some trial and error.  Let me know, Carl, if you find out.
 

If you are using MyODBC binary, you don't need any of 
the above. If you want to build the driver yourself 
from source, then you need mysqlclient.lib and client 
headers.

Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Mr. Venu [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Developer
/_/  /_/\_, /___/\___\_\___/  California, USA
   ___/  www.mysql.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

SQL

[Miguel Alves (SEP)]

Hi, 

I'm using MySQL for the first time and have been trying to solve this basic 
SQL problem for 2 days... I have tried everything from using JOINs to local variables, 
searching in www.mysql.com and Paul DuBois MySQL book (Great book!), but failed to do 
this in a single SQL query has I had use to do with Microsoft SQL Server.

The problem is;

If I have this table (versions):

Number | Version | Description
 1 |  A | testing
 1 |  B | flying


And use this query:

SELECT Number,MAX(Version),Description FROM versions GROUP BY Number;


I will get:

Number | Version | Description
 1 |  B | testing


Instead of:

Number | Version | Description
 1 |  B | flying

How can I make a single query that solves this problem ?!?! does anyone knows ?

Thanks, 

Miguel Lupi Alves
Methods  Tools Specialist, Helpdesk Methods  Tools
Customer Solutions

Ericsson Telecomunicações, Lda.
Division Global Services
Tel: +351 446 66 58
Fax: +351 21 446 66 66
Mobile: +351 91 760 14 24
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: MySQL Server cluster?

[Admin/Admin]

can MySQL run as cluster under the platform of IBM AS/400 also??


-
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: Query Problem...

[asherh]

Hi,

Thanks for the reply.

An example of the record output I was after is...

ProjectIDProjectOwnerProjectManager
A12345 Bob Smith   John Smith

from tables:

User -
UserIdFullName
1Bob Smith
2John Smith

Project -
ProjectIdProjectOwner   ProjectManager
A1234512

I have tried all sorts of joins and statements without much success... I can
obtain one name or both names if they are the same... but not different
names together in the one record.

Can you possibly provide an example of the specific joins you are talking
about. I think I must be missing something fundamental here.

Chrs,
Ash

- Original Message -
From: DL Neil [EMAIL PROTECTED]
To: asherh [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, February 27, 2002 9:12 AM
Subject: Re: Query Problem...


 Hi Ash,

  I am using MySQL 3.22.32 and are trying to accomplish the following
(without
  going into too much detail, this is an example of the exact
situation)...
 
  1) I have two tables:
 
   a) User table containing: UserID, FullName
   b) Project table containing: ProjectID, ProjectManagerID and
ProjectOwnerID
 
   ProjectManagerID and ProjectOwnerID are effectively UserIDs from the
User
  table.
 
  2) When I pull a particular record from the database by ProjectID, for
  readability purposes, I would like the accompanying ProjectManagerID and
  ProjectOwnerID to
  be displayed as a name, not an ID (for example: John Smith, not A12930).
 
  Has anyone got any ideas how I can select (within one record) both names
  from the User table by each respective UserID (represented by the
  ProjectManagerID and the ProjectOwnerID)??


 This is quite logical (when you look back at it!). Set up two joins from
Project to User, the first equating
 ProjectManagerID to UserID and the second ProjectOwnerID to UserID - just
because User is only one table,
 doesn't mean you can't have multiple ways of joining to it!

 If that's not it, please send the query you have so far.

 Regards,
 =dn




 -
 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: select takes a very long time

[Keith C. Ivey]

Alfredo Cole [EMAIL PROTECTED] wrote:

 select tr.*,ma.nombre from cbtran as tr, cbma as ma where 
 tr.empresa='1' and tr.mes='1' and tr.anio='2002' and 
 
concat(ma.empresa,ma.clase,ma.tipo,ma.mayor,ma.grupo,ma.costo,ma.cuenta,ma.subcuenta)=concat(tr.empresa,tr.cuenta)
 
 order by tr.anio, tr.mes, tr.dia, tr.partida
 
 takes over 19 minutes to complete on my laptop (Celeron 550 Mhz, 160 
 MB RAM, 20 GB HD).

The problem is that the join occurs through those concatenations, 
which have to be calculated for each pair of rows.  That means the 
indexes can't be used.

It would be a lot better if there were columns corresponding between 
the two tables -- for example, if tr.empresa was the same as 
ma.empresa and tr.cuenta was the same as ma.cuenta.  Is there any way 
that you can include columns in cbma where the concatenation has 
already been done -- that is, one for empresa+clase+tipo+grupo+costo 
(which could be paired with tr.empresa) and one for cuenta+subcuenta 
(which could be paired with tr.cuenta)?  Failing that, perhaps you 
could split up the columns for empresa and cuenta in cbtran so that 
they matched the columns in cbma.

That would not only speed up the query greatly (assuming appropriate 
indexes), but also eliminate the confusion of having identically 
named columns in two tables that don't mean the same thing.

-- 
Keith C. Ivey [EMAIL PROTECTED]
Washington, DC

-
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

Datawarehousing

[Oscar Colino]

Hi there ,

I read your thread discussion Jan and it is certainly very interesting to 
me.
There are though a couple of areas where I would (oh shit you wrote this 
email in 1999, I hope you are still there anyway ..) be rather skeptical, 
and these are:

Facts:
  - An average DW will contain an average of 500Gb this could be in turn 
around 7000.000.000 rows
  - An average fact table will contain around 30Gb -- 400.000.000 rows
  - There will be cases where a DW will go above 1Tb = 1000Gb

The way traditional RDBMS systems deal with this is:

1) Partitioning
There are systems like Teradata whose architecture is designed to be 
able to hold as much data as needed without degradation, based on 
multiprocessors and multidisks
and parallel IO/ parallel processing
In other databases like Oracle you have database level partitioning 
where a big table of 30Gb could be partition by month in chunks of up to 
500Mb, each one of these chunks is got associated a different data file
   Note that partitioning will be fundamental for performance on the 
loading, querying, backing up and archiving data

   what is the support for Partitioning in mySql if any?


2) Indexing

 MySql supports indexing but it just supports a class of indexing 
(B-tree indexign), what about hash and bitmaps, those are very useful in 
certain type of queries

3) What is the performance on loading and backup procedures in mySql?


I see mySql with very good potential to grow in the Dw arena, where no 
referential integrity is needed ... (why should we need triggeres and so on 
, they will slow down the queries), but there is key lack - support for 
partitioning



Cheers

Oscar


_
Chat with friends online, try MSN Messenger: http://messenger.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

RE: SQL

[Chris Newland]

Hi Miguel,

As far as I know (I'm no expert), this can't be done in a single MySQL
query. The following link shows how you can do it using a temporary table:

http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#exam
ple-Maximum-column-group-row

Alternatively, if you are using MySQL in conjunction with a programming
language you could:

SELECT MAX(Version) FROM versions GROUP BY Number;

store result in a variable

SELECT Number, Version,Description FROM versions WHERE Version=your
variable

Hope this helps,

Regards,

Chris

 -Original Message-
 From: Miguel Alves (SEP) [mailto:[EMAIL PROTECTED]]
 Sent: 27 February 2002 18:21
 To: [EMAIL PROTECTED]
 Subject: SQL


 Hi,

   I'm using MySQL for the first time and have been trying to
 solve this basic SQL problem for 2 days... I have tried
 everything from using JOINs to local variables, searching in
 www.mysql.com and Paul DuBois MySQL book (Great book!), but
 failed to do this in a single SQL query has I had use to do with
 Microsoft SQL Server.

   The problem is;

   If I have this table (versions):

 Number | Version | Description
  1 |  A | testing
  1 |  B | flying


 And use this query:

 SELECT Number,MAX(Version),Description FROM versions GROUP BY Number;


 I will get:

 Number | Version | Description
  1 |  B | testing


 Instead of:

 Number | Version | Description
  1 |  B | flying

 How can I make a single query that solves this problem ?!?! does
 anyone knows ?

 Thanks,

 Miguel Lupi Alves
 Methods  Tools Specialist, Helpdesk Methods  Tools
 Customer Solutions

 Ericsson Telecomunicações, Lda.
 Division Global Services
 Tel: +351 446 66 58
 Fax: +351 21 446 66 66
 Mobile: +351 91 760 14 24
 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






-
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

Order by on Alphnumeric

[Prospect'In]

sql,query

Good Day,
I have a varchar field which contains alphanumeric data. 
I want to be able to order this field by only the 
numeric values in the field.

help!!

Rick



-
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: replication issue

[Michael Douglass]

It would appear that the apparent lagging/slave processes not working
(yet telling me they are up) was due to having two slaves set to the
same server-id.  I will know as more time passes.

On Wed, Feb 27, 2002 at 09:27:04AM -0600, Michael Douglass said:
 
 David,
 
   I am seeing the exact same thing on some Solaris boxen.  My database
 sees a couple of updates every minute or two; and show slave status on
 the slave always appears to lag behind the master.  The data in my
 tables lag as well as I've done some rudimentary checksumming and have
 found differences.  I've found that if I go to each slave and do a slave
 stop and a slave start that it restarts the slave connection and then
 runs through all of the new changes.
 
 Mysql community,
 
   Thoughts as to what could be causing this?  I am using --replicate-do-
 db command to replicate only a single database; that's about the only
 thing I can think of that is special about my setup.
 
 Thanks,
 
 On Mon, Feb 11, 2002 at 10:24:46AM -0800, David Piasecki said:
  I've recently set up replication on one of my databases. Both master and
  slave are running MySQL 3.23.46 on FreeBSD 4.1. The only tables that get
  updated or inserted into hold approximately 140,000 records, growing at
  a rate of around 50-100 every day. The issue is it is currently taking
  approximately 20-30 minutes for an update/insert that occurs on the
  master to show up on the slave. An insert operation on the master
  usually only takes a second or so, so it doesn't make sense that it
  should take so long for the slave to update. There is nothing
  non-standard about either table - each contains approximately 20
  columns, one auto-increment field, and one index.
  
  Hoping someone has some insight into this matter... BTW, both servers
  are on the same private network, literally being right next to each
  other, so I know it's not a network issue.
  
  
  David Piasecki
  
  
  
  -
  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
 
 -- 
 Michael Douglass
 Chief System Engineer
 Texas Networking, Inc.  (512-794-7123)
 
 -
 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

-- 
Michael Douglass
Chief System Engineer
Texas Networking, Inc.  (512-794-7123)

-
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: flexible foreign keys?

[Jeff Kilbride]

InnoDB doesn't support the CASCADE functionality of foreign keys, so it's
possible deleting the key from the parent table won't have any effect on
existing transactions in the child. It may only prevent new records from
being inserted with that key -- which is essentially what you want. Most DBs
that support CASCADE give you the option of turning it off.

http://www.mysql.com/doc/S/E/SEC445.html

Have you tried entering a bogus ACH number and a corresponding transaction,
and then deleting the key? I don't use InnoDB, so I don't know if it will
work, but it's worth a try...

Thanks,
--jeff

- Original Message -
From: David Felio [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 27, 2002 8:21 AM
Subject: flexible foreign keys?


 I have a MySQL InnoDB table for recording checking account transactions
and
 it currently has a foreign key on the routing number referencing a local
 copy of the fed ach routing number database. It works a little too well,
in
 that a routing number may be good today, but not tomorrow. I would like
for
 the foreign key to be there to make sure an entry with a bad routing
number
 doesn't get entered, but I also will need to delete routing numbers from
 the local fed db when they are no longer good and if I have a transaction
 that previously used the routing number I won't be able to delete it. So,
 for example, on 2/27/2002 I do a transaction with routing number
123456789.
   The foreign key shows that that is a valid routing number so it lets the
 insert go through. On 2/29/2002 (or any other day after the transaction)
 the fed removes 123456789 from its list of valid routing numbers. Now I
 want to delete it from my local copy, but can't because it is linked via
 the foreign key to the transaction on 2/27/2002.

 Can someone help me with a solution here?

 David Felio
 Software Developer
 Information Network of Arkansas
 http://www.AccessArkansas.org


 -
 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: Order by on Alphnumeric

[Daniel Rosher]

select * from table 
where 
strcol REGEXP ^[[:digit:]]+$   
order by strcol

Regards
Dan

 -Original Message-
 From: Prospect'In [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, 28 February 2002 11:31 a.m.
 To: [EMAIL PROTECTED]
 Subject: Order by on Alphnumeric 
 
 
 sql,query
 
 Good Day,
 I have a varchar field which contains alphanumeric data. 
 I want to be able to order this field by only the 
 numeric values in the field.
 
 help!!
 
 Rick
 
 
 
 -
 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: flexible foreign keys?

[David Felio]

When I try to delete a row from the parent table and the key is in use in 
the child table, I get:

ERROR 1217: Cannot delete a parent row: a foreign key constraint fails

So it doesn't cascade and delete rows in the child table (assuming I am 
interpreting cascade on delete correctly), but it doesn't let me delete 
the parent row either. I can certainly understand the restriction, but it 
puts me in a bit of a bind on the db design. I don't want the child to be 
deleted anyway, if the parent is deleted. I just want to delete the parent 
row.

On Wednesday, February 27, 2002, at 01:37  PM, Jeff Kilbride wrote:

 InnoDB doesn't support the CASCADE functionality of foreign keys, so it's
 possible deleting the key from the parent table won't have any effect on
 existing transactions in the child. It may only prevent new records from
 being inserted with that key -- which is essentially what you want. Most 
 DBs
 that support CASCADE give you the option of turning it off.

 http://www.mysql.com/doc/S/E/SEC445.html

 Have you tried entering a bogus ACH number and a corresponding transaction,
 and then deleting the key? I don't use InnoDB, so I don't know if it will
 work, but it's worth a try...

 Thanks,
 --jeff

 - Original Message -
 From: David Felio [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, February 27, 2002 8:21 AM
 Subject: flexible foreign keys?


 I have a MySQL InnoDB table for recording checking account transactions
 and
 it currently has a foreign key on the routing number referencing a local
 copy of the fed ach routing number database. It works a little too well,
 in
 that a routing number may be good today, but not tomorrow. I would like
 for
 the foreign key to be there to make sure an entry with a bad routing
 number
 doesn't get entered, but I also will need to delete routing numbers from
 the local fed db when they are no longer good and if I have a transaction
 that previously used the routing number I won't be able to delete it. So,
 for example, on 2/27/2002 I do a transaction with routing number
 123456789.
   The foreign key shows that that is a valid routing number so it lets the
 insert go through. On 2/29/2002 (or any other day after the transaction)
 the fed removes 123456789 from its list of valid routing numbers. Now I
 want to delete it from my local copy, but can't because it is linked via
 the foreign key to the transaction on 2/27/2002.

 Can someone help me with a solution here?


-
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

help: can't get anonymous access configured

[Johan Knol]

Hi All,

I want to make my publicDB available for anonymous access from everywhere
and spend hours and hours reading the manuals and FAQ's and searching the
web, but can't make it work.

After deleting all entries in mysql.user apart from root@localhost:

grant select on publicDB.* to johan; works for johan from everywhere
grant select on publicDB.* to ; doesn't work for e.g. johan1 from
anywhere, apart from localhost.

There is a line: %   N N N ... in mysql.user and a line: %
public.DB  Y N N ... in mysql.db and mysql.host is still empty.

I must have overlooked something. Any ideas?

I just want _only_ this db to be available for anonymous access to the
world.

Thanks,
Johan





-
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: php - apache compilation

[Oladejo, Tokunboh]

Thanx Vic,

Are you saying I have to recompile apache as well before reconfiguring PHP.

Thanx
Toks



- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 27, 2002 9:54 AM
Subject: php - apache compilation


 Oladejo,
 Wednesday, February 27, 2002, 3:04:05 AM, you wrote:
 Oeoen Hi All,

 Oeoen I am trying to compile php with mysql and apache into it, however
during the
 Oeoen ./configure, I keep getting Invalid Apache directory - unable to
find
 Oeoen httpd.h under /usr/include/apache, even though that is where the
header
 Oeoen file httpd.h is. I am using Redhat 7.1. does anyone know the rigth
path to
 Oeoen apache directory on 7.1 RH.

 You should set your apache source dir.
 For example:

./configure --with-mysql --with-apache=/install/Apache/apache_1.3.23rusPL30.
10

 Oeoen Thanx
 Oeoen All


 --
 For technical support contracts, goto https://order.mysql.com/
 This email is sponsored by Ensita.net http://www.ensita.net/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
 /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
___/   www.mysql.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

HELP - Admin Removed mysql.host

[Matt Rudderham]

Hi,
I think that one of the admins on my MySQL 3.23.38 server somehow
removed mysql.host when he was cleaning out old databases, I get the
error:
020227 15:21:46  mysqld started
020227 15:21:46  /usr/local/libexec/mysqld: Table 'mysql.host' doesn't
exist
020227 15:21:46  mysqld ended

If I re-run mysql_install_db this should restore it correct? But will
this effect the existing production databases? Many Thanks!

- Matt

 Bonum volens duceris in Tartarum 


-
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: MySQLdMax crashed (for unknown reasons), please help

[Heikki Tuuri]

Jonathan,

the bug is probably the SHOW CREATE TABLE bug which was fixed in 3.23.48.

Please upgrade to 3.23.49a.

Best regards,

Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB

-Original Message-
From: JW [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Date: Tuesday, February 26, 2002 7:05 PM
Subject: MySQLdMax crashed (for unknown reasons), please help


Hello,

We're been running a pretty large MySQLd with InnoDB support, last night it
crashed on us in the middle of the night. I have never sent in a bug report
like this before so please give me a little slack. I do not have any clue
as
to what actually caused the crash, I only have the logs and confs.

In order: 1. System specs 2. my.cnf directives and 3. MySQL error log

= 1. System Specs 
Dell PowerEdge 2450 Dual PIII 850
2G RAM
5-disk RAID5 for a total of 67G in / (27 used, 39 free)
I think swap is also 2GB but I'm not sure (1060258+ blocks).
SuSE Linux 7.3
ccs012:~ # uname -a
Linux ccs012 2.4.10-64GB-SMP #1 SMP Fri Sep 28 17:26:36 GMT 2001 i686
unknown
ccs012:~ # free -m
 total   used   free sharedbuffers cached
Mem:  2013   2007  5  0 23695
-/+ buffers/cache:   1288724
Swap: 1035  0   1035

Not running any major service except MySQL, standalone sshd and inetd (for
telnet)
= 2. my.cnf  
ccs012:~ # grep -v # /etc/my.cnf

[client]
port= 3306
socket  = /var/lib/mysql/mysql.sock

[mysqld]
port= 3306
socket  = /var/lib/mysql/mysql.sock
skip-locking
set-variable= key_buffer=384M
set-variable= max_allowed_packet=1M
set-variable= table_cache=512
set-variable= sort_buffer=2M
set-variable= record_buffer=2M
set-variable= thread_cache=8
set-variable= max_connections=150
set-variable= thread_concurrency=4
set-variable= myisam_sort_buffer_size=64M
log-bin
server-id   = 1
innodb_data_file_path = ibdata1:2G
innodb_data_home_dir = /var/lib/mysql/
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/mysql/
set-variable = innodb_log_files_in_group=3
set-variable = innodb_log_file_size=156M
set-variable = innodb_log_buffer_size=12M
innodb_flush_log_at_trx_commit=1
innodb_log_archive=0
set-variable = innodb_buffer_pool_size=1024M
set-variable = innodb_additional_mem_pool_size=8M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable= max_allowed_packet=16M

[mysql]
no-auto-rehash

[isamchk]
set-variable= key_buffer=256M
set-variable= sort_buffer=256M
set-variable= read_buffer=2M
set-variable= write_buffer=2M

[myisamchk]
set-variable= key_buffer=256M
set-variable= sort_buffer=256M
set-variable= read_buffer=2M
set-variable= write_buffer=2M

[mysqlhotcopy]
interactive-timeout

[safe_mysqld]
open-files-limit=256

= 3. MySQLd-Max error log output 
ccs012:~ # less /var/lib/mysql/ccs012.err

020216 19:46:15  mysqld started
020216 19:46:20  InnoDB: Started
/usr/sbin/mysqld-max: ready for connections
InnoDB: Error: undo-id is 137339008
InnoDB: Assertion failure in thread 27591729 in file trx0undo.c line 1316
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked agaist is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose
the problem, but since we have already crashed, something is definitely
wrong
and this may fail

key_buffer_size=402649088
record_buffer=2093056
sort_buffer=2097144
max_used_connections=150
max_connections=150
threads_connected=68
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 1007010 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation

InnoDB: Thread 27614285 stopped in file btr0pcur.c line 202
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Stack range sanity check OK, backtrace follows:
0x806c9b9
0x8249998
0x81acb51
0x81a27d4
0x81949f3
0x817d565
0x817d949
0x817dc42
0x8170a1d
0x80baff9
0x809b855
0x80749a5
0x8076548
0x80725d4
0x8071ac7
Stack trace seems successful - bottom reached
Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
instructions on how to resolve the
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump 

PHP Security Update

[c.smart]

From the PHP home page:

PHP Security Update
[27-Feb-2002] Due to a security issue found in all versions of PHP
(including 3.x and
4.x), a new version of PHP has been released. Details about the security
issue are
available at http://security.e-matters.de/advisories/012002.html.
All users of PHP are strongly encouraged to either upgrade to PHP 4.1.2,
or install
the patch (available for PHP 3.0.18, 4.0.6 and 4.1.0/4.1.1).

I suggest that all users of PHP read the above link!

Regards

Clive Smart


to pass the anti-spam filter:
you should query the above page if you
use MySQL and 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

FULLTEXT error?

[Doug Dalton]

Error

SQL-query:

CREATE TABLE quotes (
id int(9) NOT NULL auto_increment,
author varchar(255),
content text,
PRIMARY KEY  (id),
UNIQUE KEY id (id),
FULLTEXT KEY author (author,content)
) TYPE=MyISAM;

MySQL said: You have an error in your SQL syntax near 'KEY author
(author,content) ) TYPE=MyISAM;' at line 7

I have also tried to create the table and ALTER TABLE  quotes ADD
FULLTEXT author (author,contect)

I get the same error,  is this a function at is only in 3.23 Max or is
it in the standard version as well?

R/Doug


-
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

Myisamchk can't repair table help help help

[Steve Rapaport]

Arrrggghhh!

This is definitely a problem!
Can't access table White in mysql 4.0.1:  table is read-only.
why?  because it's corrupt!
Try to fix:  takes a long time (about an hour) and seems to work.
But it's still corrupt and read-only:

[root@db1 elenco4_fb02]# myisamchk White;
Checking MyISAM file: White
Data records: 22079089   Deleted blocks:   0
- check file-size
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check data record references index: 5
- check data record references index: 6
- check data record references index: 7
- check data record references index: 8
- check record links
myisamchk: warning: Found   22079089 partsShould be: 0 parts
MyISAM-table 'White' is usable but should be fixed
[root@db1 elenco4_fb02]# echo $TMPDIR

[root@db1 elenco4_fb02]# TMPDIR=/var/lib/mysql/tmp
[root@db1 elenco4_fb02]# echo $TMPDIR
/var/lib/mysql/tmp
[root@db1 elenco4_fb02]# export TMPDIR
[root@db1 elenco4_fb02]# myisamchk -q -r --force --fast -O sort_buffer=64M 
White
- check key delete-chain
- check record delete-chain
- recovering (with sort) MyISAM-table 'White'
Data records: 22079089
- Fixing index 1
- Fixing index 2
- Fixing index 3
- Fixing index 4
- Fixing index 5
- Fixing index 6
- Fixing index 7
- Fixing index 8
[root@db1 elenco4_fb02]# ls -l
total 7001668
-rwxrwxr-x1 root root0 Feb 27 01:30 Counts.MYD
-rwxrwxr-x1 root root 1024 Feb 27 01:30 Counts.MYI
-rwxrwxr-x1 root root 8578 Feb 27 01:30 Counts.frm
-rwxrwxr-x1 root root 409097196 Feb 27 01:30 Invfile.MYD
-rwxrwxr-x1 root root 314644480 Feb 27 01:28 Invfile.MYI
-rwxrwxr-x1 root root 8612 Feb 27 01:27 Invfile.frm
-rwxrwxr-x1 root root 1964830232 Feb 27 19:19 White.MYD
-rwxrwxr-x1 root root 2079708160 Feb 27 22:11 White.MYI
-rwxrwxr-x1 root root 9159 Feb 27 01:18 White.frm
[root@db1 elenco4_fb02]# myisamchk -U White;
Checking MyISAM file: White
Data records: 22079089   Deleted blocks:   0
- check file-size
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check data record references index: 5
- check data record references index: 6
- check data record references index: 7
- check data record references index: 8
- check record links
myisamchk: warning: Found   22079089 partsShould be: 0 parts
MyISAM-table 'White' is usable but should be fixed
[root@db1 elenco4_fb02]#

-
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

Starting mysqld fails

[Dieter Lunn]

Hi,

I downloaded the tarball for the latest RH binaries of Mysql 3.23.49a.  I 
installed it according to the INSTALL-BINARY file included with the 
package. When I tried to run mysql according to the same file it crashed 
giving no explanation.  I have tried the suggestions listed on the website 
but none of them have provided any more information or solutions.  Please 
help and thank you to those who try.

Dieter

-
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: I heard that MySQL 4.01 supports Views?

[Paul DuBois]

At 16:31 -0500 2/27/02, Stephen Cox wrote:
Does MySQL 4.01 support Views? And if so, how?

Ask the person who told you that it does to substantiate the assertion.


Stephen Cox
Web Development, Webmaster
[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 DATA LOCAL INFILE in Alpha 3.23.49

[rob]

Description:
LOAD DATA LOCAL INFILE ...

leads to 'The used command is not allowed with this MySQL version'

This happens regardless of whether I have a 

local-infile= 1

in my /etc/my.cnf.  In neither case does the local-infile variable show
up with SHOW VARIABLES.


How-To-Repeat:
Fix:
Submitter-Id:  [EMAIL PROTECTED]
Originator:
Organization:  FatKat, Inc.
MySQL support: none
Synopsis:  
Severity:  serious
Priority:  low
Category:  mysql
Class: sw-bug
Release:   mysql-3.23.49 (Official MySQL binary)

Environment:
System: Linux fatkat2.fatkat.com 2.4.9-21smp #1 SMP Thu Jan 17 13:03:50 EST 2002 alpha 
unknown
Architecture: alpha

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/alpha-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-87)
Compilation info: CC='ccc'  CFLAGS='-fast'  CXX='cxx'  CXXFLAGS='-fast -noexceptions 
-nortti'  LDFLAGS=''
LIBC: 
lrwxrwxrwx1 root root   13 Jan 29 15:16 /lib/libc.so.6.1 - 
libc-2.2.4.so
-rwxr-xr-x2 root root 10121827 Dec  8 09:10 /lib/libc-2.2.4.so
-rw-r--r--1 root root 23810772 Dec  8 09:10 /usr/lib/libc.a
-rw-r--r--1 root root  180 Dec  8 09:10 /usr/lib/libc.so
lrwxrwxrwx1 root root   10 Jan 29 12:54 /usr/lib/libc-client.a - 
c-client.a
Configure command: ./configure  --prefix=/usr/local/mysql '--with-comment=Official 
MySQL binary' --with-extra-charsets=complex --with-server-suffix= 
--enable-thread-safe-client --enable-local-infile --with-mysqld-ldflags=-non_shared 
--with-client-ldflags=-non_shared --disable-shared


-
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: I heard that MySQL 4.01 supports Views?

[Paul DuBois]

At 17:09 -0500 2/27/02, Anthony W. Marino wrote:
On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote:
   Does MySQL 4.01 support Views? And if so, how?

   Ask the person who told you that it does to substantiate the assertion.


Can't you just say NO or just don't respond?

Sure.  But why should this question have even been posted?  Isn't it
reasonable that if someone told him that views are supported, he could
have asked that person, how do you know?  Or maybe looked in the manual?


-
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: I heard that MySQL 4.01 supports Views?

[Anthony W. Marino]

On Wednesday 27 February 2002 05:16 pm, you wrote:
 At 17:09 -0500 2/27/02, Anthony W. Marino wrote:
 On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote:
Does MySQL 4.01 support Views? And if so, how?
   
Ask the person who told you that it does to substantiate the
assertion.
 
 Can't you just say NO or just don't respond?

 Sure.  But why should this question have even been posted?  Isn't it
 reasonable that if someone told him that views are supported, he could
 have asked that person, how do you know?  Or maybe looked in the manual?

Paul,

My point is that you are EXTREMELY well versed with MySQL and the current 
status.  I could just imagine at how easy it is to become very annoyed at 
some of the questions that arrive.

We shoudn't stifle interest in this list.  We should offer guidance and 
direction and thus help them help themselves (ie; Please follow the 
yellowbrick road...)

Great '99 book can't wait for more!!!

Thank You,
Anthony


-
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: Query Problem...

[DL Neil]

Hi Ash,

 I have tried all sorts of joins and statements without much success... I can
 obtain one name or both names if they are the same... but not different
 names together in the one record.

=how about some example code showing what you are doing?
At the very least it gives me a 'starting point' and saves my time/typing.
Also without the 'hints' communicated by your code, I might assume you are 'smarter', 
or more of a beginner,
than you really are!

=it sounds as if it is not the 'type' of join that is the 'problem', but the number of 
joins.
A 'stock standard' LEFT INNER JOIN is quite sufficient.
The 'trick', as I mentioned, is to set up two joins!

 Can you possibly provide an example of the specific joins you are talking
 about. I think I must be missing something fundamental here.

Let's start with the project table and simply list that:

SELECT ProjectId, ProjectOwner, ProjectManager
  FROM AshProject

ProjectIdProjectOwner   ProjectManager
A1234512

Now let's bring in the User tbl and 'translate' the ProjectOwner's Id/nr into his/her 
name. Put in one join and
output the name of the ProjectOwner (as well as his/her number, for debugging 
purposes):

SELECT ProjectId, ProjectOwner, ProjectManager, FullName AS ProjectOwner
  FROM AshProject, AshUser
  WHERE ProjectOwner = UserId

ProjectIdProjectOwner   ProjectManager   ProjectOwner
A12345 1 2 Bob Smith

So far, so good. Now we need to translate/add the ProjectManager's name!

Persisting with a single join and trying to add WHERE ... AND ProjectManager = UserId, 
results in it all turning
to ashes, because MySQL goes looking for a SINGLE UserId value that will equal *both* 
names, and such will only
happen if the Project's Manager and Owner are the same person! (in the case of the 
limited sample data provided,
never!)

We need to add a second version/copy of the User tbl to the query, and distinguish 
between the two 'versions' by
using aliases - that way you can apparently use UserId 'twice', ie two *separate* 
UserIds and thus the two names
can be retrieved from different rows of the User tbl (or twice from the same row, if 
required):

SELECT ProjectId, ProjectOwner, ProjectManager,
AU1.FullName AS ProjectOwner, AU2.FullName AS ProjectManager
  FROM AshProject, AshUser AS AU1, AshUser AS AU2
  WHERE ProjectOwner = AU1.UserId
AND ProjectManager = AU2.UserId

ProjectIdProjectOwner   ProjectManager   ProjectOwner   ProjectManager
A12345 1 2 Bob Smith John Smith

Once you've checked the logic/implementation, don't forget to remove the 'workings' 
and then you'll have the
answer required.

Ok now?
=dn



   I am using MySQL 3.22.32 and are trying to accomplish the following
 (without
   going into too much detail, this is an example of the exact
 situation)...
  
   1) I have two tables:
  
a) User table containing: UserID, FullName
b) Project table containing: ProjectID, ProjectManagerID and
 ProjectOwnerID
  
ProjectManagerID and ProjectOwnerID are effectively UserIDs from the
 User
   table.
  
   2) When I pull a particular record from the database by ProjectID, for
   readability purposes, I would like the accompanying ProjectManagerID and
   ProjectOwnerID to
   be displayed as a name, not an ID (for example: John Smith, not A12930).
  
   Has anyone got any ideas how I can select (within one record) both names
   from the User table by each respective UserID (represented by the
   ProjectManagerID and the ProjectOwnerID)??
 
 
  This is quite logical (when you look back at it!). Set up two joins from
 Project to User, the first equating
  ProjectManagerID to UserID and the second ProjectOwnerID to UserID - just
 because User is only one table,
  doesn't mean you can't have multiple ways of joining to it!
 
  If that's not it, please send the query you have so far.


-
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: Query Problem...

[Roger Baklund]

* asherh
 An example of the record output I was after is...

 ProjectIDProjectOwnerProjectManager
 A12345 Bob Smith   John Smith

 from tables:

 User -
 UserIdFullName
 1Bob Smith
 2John Smith

 Project -
 ProjectIdProjectOwner   ProjectManager
 A1234512

 I have tried all sorts of joins and statements without much
 success... I can
 obtain one name or both names if they are the same... but not different
 names together in the one record.

 Can you possibly provide an example of the specific joins you are talking
 about. I think I must be missing something fundamental here.

You don't show your failing joins, but my guess is you are missing aliases,
which are needed when joining the same table multiple times:

SELECT ProjectId,owner.FullName,manager.FullName
  FROM Project
  LEFT JOIN User AS owner ON
owner.UserId = Project.ProjectOwnerID
  LEFT JOIN User AS manager ON
manager.UserId = Project.ProjectManagerID
  WHERE
ProjectId = 'A12345';

--
Roger
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: I heard that MySQL 4.01 supports Views?

[Charles Little]

We shoudn't stifle interest in this list.  We should offer guidance and

direction and thus help them help themselves (ie; Please follow the 
yellowbrick road...)

I don't think that was his intent... It's just that this is in the .sig
for the list...

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

snip

Just an observation...

Charles


-
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: FULLTEXT error?

[DL Neil]

Doug,

Can quite see why you have id as a key twice, but...

This worked first time for me (3.23.40-nt).

Regards,
=dn



 Error
 
 SQL-query:
 
 CREATE TABLE quotes (
 id int(9) NOT NULL auto_increment,
 author varchar(255),
 content text,
 PRIMARY KEY  (id),
 UNIQUE KEY id (id),
 FULLTEXT KEY author (author,content)
 ) TYPE=MyISAM;
 
 MySQL said: You have an error in your SQL syntax near 'KEY author
 (author,content) ) TYPE=MyISAM;' at line 7
 
 I have also tried to create the table and ALTER TABLE  quotes ADD
 FULLTEXT author (author,contect)
 
 I get the same error,  is this a function at is only in 3.23 Max or is
 it in the standard version as well?
 
 R/Doug
 
 
 -
 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: Myisamchk can't repair table help help help

[Mihail Manolov]

Steve Rapaport wrote:
 
 Arrrggghhh!
 
 This is definitely a problem!
 Can't access table White in mysql 4.0.1:  table is read-only.
 why?  because it's corrupt!
 Try to fix:  takes a long time (about an hour) and seems to work.
 But it's still corrupt and read-only:
 
[cut]

 [root@db1 elenco4_fb02]# ls -l
 total 7001668
 -rwxrwxr-x1 root root0 Feb 27 01:30 Counts.MYD
 -rwxrwxr-x1 root root 1024 Feb 27 01:30 Counts.MYI
 -rwxrwxr-x1 root root 8578 Feb 27 01:30 Counts.frm
 -rwxrwxr-x1 root root 409097196 Feb 27 01:30 Invfile.MYD
 -rwxrwxr-x1 root root 314644480 Feb 27 01:28 Invfile.MYI
 -rwxrwxr-x1 root root 8612 Feb 27 01:27 Invfile.frm
 -rwxrwxr-x1 root root 1964830232 Feb 27 19:19 White.MYD
 -rwxrwxr-x1 root root 2079708160 Feb 27 22:11 White.MYI
 -rwxrwxr-x1 root root 9159 Feb 27 01:18 White.frm
[cut]

Does your system have support for files larger than 2GB?

-- 
Mihail Manolov
Solutions Architect
Government Liquidation, LLC
www.govliquidation.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: I heard that MySQL 4.01 supports Views?

[DL Neil]

 On Wednesday 27 February 2002 05:16 pm, you wrote:
  At 17:09 -0500 2/27/02, Anthony W. Marino wrote:
  On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote:
 Does MySQL 4.01 support Views? And if so, how?

 Ask the person who told you that it does to substantiate the
 assertion.
  
  Can't you just say NO or just don't respond?
 
  Sure.  But why should this question have even been posted?  Isn't it
  reasonable that if someone told him that views are supported, he could
  have asked that person, how do you know?  Or maybe looked in the manual?

 Paul,

 My point is that you are EXTREMELY well versed with MySQL and the current
 status.  I could just imagine at how easy it is to become very annoyed at
 some of the questions that arrive.

 We shoudn't stifle interest in this list.  We should offer guidance and
 direction and thus help them help themselves (ie; Please follow the
 yellowbrick road...)


I disagree somewhat! I agree that politeness should prevail, also that knowledgeable 
people should endeavor to
be helpful and exercise forbearance towards learners...
(just who is in which category will vary over time and according to topic, so today's 
JOIN-expert might ask
tomorrow's question of the day in privileges/control (for example) - so it pays to be 
'nice')

However if we're (all) going to be polite to each other, then why ask questions that 
waste everyone's time (not
even just those who make the effort to answer the question), when a quick 'flip 
through' the manual and/or the
web site would throw up the answer? [effect: devaluation of, disrespect for others' 
time/efforts/kindness]

If you want an 'expert' to demonstrate his/her knowledge, then how about providing as 
much information as might
be relevant, eg I found this statement ... on ... web site/newsgroup/page of the 
manual...
- or in the case of query problems, how about the 'current best' version that isn't 
quite working, and some
sample data that is formatted so that it can be quickly thrown at a MySQL client/tool 
so that the 'expert' can
test/debug and quality check advice before launching into 'print' on the list? [help 
others to help you]

The exercise of freedom is a two-way street!
=dn
MD of soapboxes unlimited


-
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

ignore words in full text indexes

[David yahoo]

Hi all,

I m using mysql 4.01 alpha

I read in the doc :
MySQL uses a very simple parser to split text into words. A ``word'' is any
sequence of letters, numbers, `'', and `_'. Any ``word'' that is present in
the stopword list or just too short (3 characters or less) is ignored. 

My queries let me devine that =4 words are ignored.

How to know more.

SELECT * FROM T_Stories WHERE match   against ('+fiat -bagnole'   IN
BOOLEAN MODE)
doesnt give any row
but when changing fiat to fiato it gives me row ?

I regenerate the index beetween queries - nothing ?

Is there any easy way planed fro changing stopword and words min length in
the future ?
By an easy way I didint want to recompile a mysql server only changing some
files or syetem database,
like the mysql database is ?


Thanks.
Regards.


_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.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: ignore words in full text indexes

[Daniel Rosher]

David,

I think the nominal minimum word length is 4 so 'fiat' will not be indexed.

This can be modified however.

regards,
Dan

 -Original Message-
 From: David yahoo [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, 28 February 2002 12:28 p.m.
 To: [EMAIL PROTECTED]
 Subject: ignore words in full text indexes


 Hi all,

 I m using mysql 4.01 alpha

 I read in the doc :
 MySQL uses a very simple parser to split text into words. A
 ``word'' is any
 sequence of letters, numbers, `'', and `_'. Any ``word'' that is
 present in
 the stopword list or just too short (3 characters or less) is ignored. 

 My queries let me devine that =4 words are ignored.

 How to know more.

 SELECT * FROM T_Stories WHERE match   against ('+fiat -bagnole'   IN
 BOOLEAN MODE)
 doesnt give any row
 but when changing fiat to fiato it gives me row ?

 I regenerate the index beetween queries - nothing ?

 Is there any easy way planed fro changing stopword and words min length in
 the future ?
 By an easy way I didint want to recompile a mysql server only
 changing some
 files or syetem database,
 like the mysql database is ?


 Thanks.
 Regards.

  _ Do You
 Yahoo!? Get your free @yahoo.com address at http://mail.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

heap tables and slow index query

[Aaron J Mackey]

server version: 3.23.47

mysql create table myhits (
- libid int unsigned not null,
- begin bigint unsigned not null,
- end bigint unsigned not null,
- index(libid),
- index(begin),
- index(end)
- ) type = heap;
Query OK, 0 rows affected (0.00 sec)

[ insert statement to fill table myhits ]
Query OK, 65681 rows affected (1.70 sec)
Records: 65681  Duplicates: 0  Warnings: 0

mysql explain select h1.libid as libid,
-max(h1.end + 1) as begin,
-min(h2.begin - 1) as end
- from myhits as h1 inner join myhits as h2 on (h1.libid = h2.libid and h2.begin 
 h1.end)
- group by h1.libid, h1.begin
- ;
+---+--+---+---+-+--+---+-+
| table | type | possible_keys | key   | key_len | ref  | rows  | Extra   |
+---+--+---+---+-+--+---+-+
| h1| ALL  | libid | NULL  |NULL | NULL | 65681 | Using temporary |
| h2| ref  | libid,begin   | libid |   4 | h1.libid |18 | where used  |
+---+--+---+---+-+--+---+-+

mysql create temporary table ranges type = heap
- select h1.libid as libid,
-max(h1.end + 1) as begin,
-min(h2.begin - 1) as end
- from myhits as h1 inner join myhits as h2 on (h1.libid = h2.libid and h2.begin 
 h1.end)
- group by h1.libid, h1.begin
- ;
[wait wait wait wait]

When I actually execute the query above, it seems to hang (for at
least three hours, until I killed it); show processlist says Copying to
tmp table for the whole time.  I've set max_tmp_table to be 1500M
(there's 2Gb of memory in the machine), so I know (?) it's doing all of
the operations in memory, and it's definitely not swapping out.  So why is
this taking so long?  Is there some hidden O(N^4) operation going on? ;)

Thanks for any help,

-Aaron



-
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-3.23.49-1.src.rpm does not build under RedHat Linux 6.2

[Gabriele Carioli]

I see binaries are now shipping with vwesrion 3.23.49a.
Have sources been changed since 3.23.49? I'm asking since
I've tried to build binary packages from MySQL-3.23.49-1.src.rpm
as suggested. The compilation fails like this:

[..snip...]
creating libmysqlclient.la
(cd .libs  rm -f libmysqlclient.la  ln -s ../libmysqlclient.la
libmysqlclient.la)
make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/libmysql'
Making all in client
make[2]: Entering directory `/usr/src/redhat/BUILD/mysql-3.23.49/client'
gcc -DUNDEF_THREADS_HACK -I./../include -I..
/include -I./.. -I.. -I..-O3 -DDBUG_OFF  -O3   -felide-const
ructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exception
s -fno-rtti -fpermissive -I/usr/local/mysql-glibc/include -c mysql.cc
In file included from mysql.cc:48:
/usr/include/curses.h:195: warning: `ERR' redefined
/usr/include/sys/ucontext.h:74: warning: this is the location of the
previous definition
cc1plus: Invalid option `-fpermissive'
In file included from client_priv.h:19,
 from mysql.cc:28:
../include/global.h:685: abstract declarator used as declaration
make[2]: *** [mysql.o] Error 1
make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/client'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49'
make: *** [all-recursive-am] Error 2
error: Bad exit status from /var/tmp/rpm-tmp.61911 (%build)


RPM build errors:
Bad exit status from /var/tmp/rpm-tmp.61911 (%build)



Is there anything missing or wrong in my system. What can I do?

Thanks a lot




-
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 with Insert

[Chris Herold]

Hi-

Problem:
Having trouble inserting text files longer than a few lines into MySQL
although short ones go in fine.


I'm using a form in HTML to get a value for $abstract...

form method=POST action=abstract_submit.php

textarea name=abstract rows=20 cols=70/textarea

/form

I am then using PHP to insert the information into MySQL...

abstract_submit.php

?php


$db = mysql_connect(db.db_name.com, user, pass);

mysql_select_db(db_name,$db);
 

$sql = INSERT INTO Abstract_DB (abstract) VALUE ('$abstract');

$result = mysql_query($sql);


 ?



When $abstract is relatively short/small (3 or 4 lines) the insertion takes
place without any problem.

THE PROBLEM IS that when a LONG abstract is entered, nothing gets submitted.

Any ideas on what's up with this?

thanks,

Chris 







-
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: ignore words in full text indexes

[Sergei Golubchik]

Hi!

On Feb 28, David yahoo wrote:
 Hi all,
 
 I m using mysql 4.01 alpha
 
 I read in the doc :
 MySQL uses a very simple parser to split text into words. A ``word'' is any
 sequence of letters, numbers, `'', and `_'. Any ``word'' that is present in
 the stopword list or just too short (3 characters or less) is ignored. 
 
 My queries let me devine that =4 words are ignored.
 
 How to know more.
 
 SELECT * FROM T_Stories WHERE match   against ('+fiat -bagnole'   IN
 BOOLEAN MODE)
 doesnt give any row
 but when changing fiat to fiato it gives me row ?

may be there're no rows with fiat ?  :)

 
 I regenerate the index beetween queries - nothing ?
 
 Is there any easy way planed fro changing stopword and words min length in
 the future ?

yes.

 By an easy way I didint want to recompile a mysql server only changing some
 files or syetem database,
 like the mysql database is ?
 
 
 Thanks.
 Regards.
 
 
 _
 Do You Yahoo!?
 Get your free @yahoo.com address at http://mail.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
 
Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   ___/

-
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: Query Problem...

[asherh]

Thanks guys, works a treat. Yip, it was the Alias thing... interesting.

- Original Message -
From: Roger Baklund [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: asherh [EMAIL PROTECTED]
Sent: Wednesday, February 27, 2002 2:39 PM
Subject: RE: Query Problem...


 * asherh
  An example of the record output I was after is...
 
  ProjectIDProjectOwnerProjectManager
  A12345 Bob Smith   John Smith
 
  from tables:
 
  User -
  UserIdFullName
  1Bob Smith
  2John Smith
 
  Project -
  ProjectIdProjectOwner   ProjectManager
  A1234512
 
  I have tried all sorts of joins and statements without much
  success... I can
  obtain one name or both names if they are the same... but not different
  names together in the one record.
 
  Can you possibly provide an example of the specific joins you are
talking
  about. I think I must be missing something fundamental here.

 You don't show your failing joins, but my guess is you are missing
aliases,
 which are needed when joining the same table multiple times:

 SELECT ProjectId,owner.FullName,manager.FullName
   FROM Project
   LEFT JOIN User AS owner ON
 owner.UserId = Project.ProjectOwnerID
   LEFT JOIN User AS manager ON
 manager.UserId = Project.ProjectManagerID
   WHERE
 ProjectId = 'A12345';

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