Billionium Bug

[Panos Kalos]

To Whom it may concern,

I've noticed a bug with the Billionium.  Now that we have hit 1 Billion 
seconds since the beginning of the Epoch mysql will NOT work properly with a 
MIN clause involving seconds before the Billionium.  

To clarify, I have a script that keeps track of the seconds of which the 
data was entered.  I then use another script that pulls that data using a 
'MIN(seconds)' statement to pull the oldest entry.  This no longer works as 
it will only pull data after 1 billion seconds and disregarding anything 
prior.

Im sure you can easily recreate this event by entering false info into a DB.

Regards,
Panos

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

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: Billionium Bug

[Jason Brooke]

 To Whom it may concern,

 I've noticed a bug with the Billionium.  Now that we have hit 1 Billion
 seconds since the beginning of the Epoch mysql will NOT work properly with
a
 MIN clause involving seconds before the Billionium.

 To clarify, I have a script that keeps track of the seconds of which the
 data was entered.  I then use another script that pulls that data using a
 'MIN(seconds)' statement to pull the oldest entry.  This no longer works
as
 it will only pull data after 1 billion seconds and disregarding anything
 prior.

 Im sure you can easily recreate this event by entering false info into a
DB.

 Regards,
 Panos

I'm not seeing this behaviour with 3.23.41

mysql show columns from test;
+-+-+--+-+-+---+
| Field   | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| seconds | int(11) |  | MUL | 1   |   |
+-+-+--+-+-+---+
1 row in set (0.00 sec)

mysql select min(seconds) from test;
+--+
| min(seconds) |
+--+
|998556700 |
+--+
1 row in set (0.18 sec)

mysql select max(seconds) from test;
+--+
| max(seconds) |
+--+
|   113720 |
+--+
1 row in set (0.00 sec)

mysql status;
--
mysql  Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686)


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

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: URGENTE - Replication......

[Rodrigo Zerlotti]

Ok, no answers yet, but more information:

master log:

010909  3:15:36  failed in send_file() : Failed reading file name

Should the same file used on the master for the load inline be already on
the slave? Or MySql takes care of moving it for us... I try to move myself
before the sql and didn't work... same error

Also, ignore table doesn't work when table on the inline query. I tried that
and the slave tried to run the sql

Configuration: Mandrake + Mysql 3.23.36

Please help, I would hate to leave replication just because this...

-
Regards,

Rod~

 -Original Message-
 From: Rodrigo Zerlotti [mailto:[EMAIL PROTECTED]]
 Sent: Saturday, September 08, 2001 7:58 PM
 To: Mysql@Lists. Mysql. Com
 Subject: URGENTE - Replication..
 Importance: High


 Can not find the problem and we are down!

 Here the question again (Any advice on replication of LOAD
 DATA INFILE is very appreciated.)

 

 I setup a mster-slave. My master does a lot of :

 LOAD  DATA INFILE 'path-to-file'
 REPLACE INTO TABLE TABLE-NAME FIELDS
 TERMINATED BY '\t' LINES TERMINATED BY '\n';

 Notice i am not using LOCAL because the docs states:

 LOAD DATA INFILE will be handled properly as long as the file
 still resides on the master server at the time of update
 propagation. LOAD LOCAL DATA INFILE will be skipped.

 But on Slave I am getting:

 Slave: Error 'Table '%-.64s.%-.64s' doesn't exist' running load
 data infile

 Ideas Where should I look???

 -
 Regards,

 Rod~


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

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: transaction tables

[Carl Troein]

Matthew Harting writes:

  Which table type would you
 recommend using for transaction support?

InnoDB, unless you have a small database and plenty of RAM.
At least that's what others who have actually tried it have
said. Since what I'm doing isn't really in need of transactions
I'm sticking with MyISAM for now.

//C

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.


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

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

Billionium Bug (fwd)

[Carl Troein]

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.


--Forwarded message --
Return-Path: [EMAIL PROTECTED]
Delivered-To: [EMAIL PROTECTED]
Received: (qmail 6088 invoked from network); 9 Sep 2001 08:57:59 -
Received: from web.mysql.com ([EMAIL PROTECTED])
  by shakespeare.thep.lu.se with SMTP; 9 Sep 2001 08:57:59 -
Received: (qmail 25240 invoked by uid 7797); 9 Sep 2001 08:52:34 -
Date: 9 Sep 2001 08:52:34 -
Message-ID: [EMAIL PROTECTED]
From: [EMAIL PROTECTED]
To: Carl Troein [EMAIL PROTECTED]
Subject: Re:  Re: Billionium Bug
  

Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:

database,sql,query,table

If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for
example.

You have written the following:


Jason Brooke writes:

 I'm not seeing this behaviour with 3.23.41

Could it be that the column that caused the problem was
of type INT(9)? Would that give such a problem by any chance?

//C

-- 
 Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
 Amiga user since '89, and damned proud of it too.



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

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

AW: Billionium Bug

[Christian Sage]

Only to make sure we don't have any OS-specific I tried your test on my
Win32 installation. Same result:

--- snip

mysql create table test (seconds bigint not null primary key);
Query OK, 0 rows affected (0.00 sec)

mysql insert into test values (998556700), (113720), (11);
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql select * from test;
++
| seconds|
++
|  998556700 |
| 11 |
| 113720 |
++
3 rows in set (0.00 sec)

mysql select min(seconds) from test;
+--+
| min(seconds) |
+--+
|998556700 |
+--+
1 row in set (0.03 sec)

mysql select max(seconds) from test;
+--+
| max(seconds) |
+--+
|   113720 |
+--+
1 row in set (0.00 sec)

mysql status
--
mysql  Ver 11.15 Distrib 3.23.41, for Win95/Win98 (i32)

--- snap

Then I thought, maybe a problem with indexes, so I recreated the table
without a primary key. Still same result. However, in the first case (with
primary key), the select might not have used the index, so I tested for
that. Indeed: explain came up with the comment

--- snip

+--+
| Comment  |
+--+
| Select tables optimized away |
+--+

--- snap

A quick search of the documentation did not yield any useful information.
Therefore, I inserted an additional 20 rows into the table (resulted in
1.7MB data and 3.5MB index size), but still the same comment. So it appears
that the min and max value is stored somewhere for the table or the index.
To find out a little more, I recreated the table once again without an index
and repeated the procedure. The result was:

--- snip

mysql select min(seconds) from test;
+--+
| min(seconds) |
+--+
|0 |
+--+
1 row in set (0.07 sec)

mysql explain select min(seconds) from test;
+---+--+---+--+-+--++---+
| table | type | possible_keys | key  | key_len | ref  | rows   | Extra |
+---+--+---+--+-+--++---+
| test  | ALL  | NULL  | NULL |NULL | NULL | 24 |   |
+---+--+---+--+-+--++---+
1 row in set (0.00 sec)

--- snap

Now I got the expected full table scan. Same thing for 3 rows. But still the
result is correct. The problem could still be with the port of MySQL Panos
is using or with the table definition. Script seems to make it unlikely
that it would be in the definition of the variable used for storing the
results retrieved.

I've wandered a bit off the original topic here, but since I think the
results may still be interesting for some of you I'm posting this anyway.

Cheers,
Christian

-Ursprüngliche Nachricht-
Von: Jason Brooke [mailto:[EMAIL PROTECTED]]
Gesendet: Sonntag, 9. September 2001 09:24
An: Panos Kalos; [EMAIL PROTECTED]
Betreff: Re: Billionium Bug


 To Whom it may concern,

 I've noticed a bug with the Billionium.  Now that we have hit 1 Billion
 seconds since the beginning of the Epoch mysql will NOT work properly with
a
 MIN clause involving seconds before the Billionium.

 To clarify, I have a script that keeps track of the seconds of which the
 data was entered.  I then use another script that pulls that data using a
 'MIN(seconds)' statement to pull the oldest entry.  This no longer works
as
 it will only pull data after 1 billion seconds and disregarding anything
 prior.

 Im sure you can easily recreate this event by entering false info into a
DB.

 Regards,
 Panos

I'm not seeing this behaviour with 3.23.41

mysql show columns from test;
+-+-+--+-+-+---+
| Field   | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| seconds | int(11) |  | MUL | 1   |   |
+-+-+--+-+-+---+
1 row in set (0.00 sec)

mysql select min(seconds) from test;
+--+
| min(seconds) |
+--+
|998556700 |
+--+
1 row in set (0.18 sec)

mysql select max(seconds) from test;
+--+
| max(seconds) |
+--+
|   113720 |
+--+
1 row in set (0.00 sec)

mysql status;
--
mysql  Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686)


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

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/   

New release of mysqlgui for Win32

[Sinisa Milivojevic]

Hi!


A new sub-version of mysqlgui for Windoes has been uploaded to MySQLGUI page
on www.mysql.com.

This is a sub-release, titled 1.7.5-2 and contains   fixes for
several bugs that have been reported on Windows platform.

Among other bugs there is a bug of keys not working in a spreadsheet. This
has been fixed as much as the current spreadsheet widget allows. Most of the
time, keybooard navigation will work just fine, but in those very rare cases
when it does not, just click on the first cell and all keys will work just
fine. I must stress that such situations are very rare.

Few of these bugs could be hit upon on Unix too, and if that
accidentally happens, please let me know, so that I could release a
Unix version too.

But that will be left when I come back from my vacation. I am leaving
tomorrow and I will be back in the beginning of October. Till then,
good by list !

-- 
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: SELECT * FROM allofthetables

[Marjolein Katsma]

Deryck,

Since you already got a reply that it can't be done, here's a suggestion how it 
*could* be done (jus a general approach - since you mention usnig ASP):

- use an SQL command to gather all the table names in the database
- store the names in a list or array (ASP)
- use ASP to loop over the list
- for each %tablename% do teh SQL command (fill in the table name):
SELECT * FROM %tablename% WHERE User = 'username'

I don't use ASP myself, but the same general approach could be used with ASP, PHP, 
CFML, or any other server-side language.

Cheers,

At 21:09 2001-09-08 -0500, Deryck Henson wrote:
How do I select all of the tables in a database and use a whre clause like
this??::

SELECT * FROM alltables(substitute with command) WHERE User = 'username'

I need this for my site (Code Cafe- Free source code) so that the user can
see all the code he has uploaded.  It is done in ASP, but all I need is the
sql query string.  Thanx

- Deryck H
- http://www.comp-u-exchange.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

Marjolein Katsma  [EMAIL PROTECTED]
Java Woman - http://javawoman.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:Using Mysql 3.23.41 - accent searches not working

[Heikki Tuuri]

Brian,

I assume you are using MyISAM tables. The reason
for your problem probably is that your computer
does not give the latin1 codes to the accent
characters you type in. For example, the DOS
prompt in Win NT gives them different codes from
latin1, and consequently a similar test fails on
my NT machine.

InnoDB tables currently order latin1 characters outside
the ranges a-z and A-Z according to their numerical
code. I will change it in .43 so that they are ordered
in the same way as in MyISAM. Ar least one problem still
remains after that: MyISAM identifies an u with two
dots on it with the letter y, but in Brazil, I have been
told, it should be the same as plain u.

Regards,

Heikki
http://www.innodb.com

Hello,

I read that version 3.23 and later do accent insensitive searches when 
using LIKE in the query.

However, I'm still having problems getting accent insensitive searches to work.

I made a test page:  http://www.sedl.org/accents.html

to search a small database of names.  There are four names, each entered 
twice, with one version of each name including an accent over one of the 
vowels.

When I search for Jose (with accented e) it finds the unaccented Jose, but 
not the accented version.

Very strange.  Is this a characterset issue? or some other setting?

The system says its running MySQL 3.23.41
Client characterset: latin1
Server characterset: latin1

Any help would be greatly appreciated

Thanks,
Brian





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

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

Got error 127 from table handler

[Michael Widenius]

Hi!

Note that the [EMAIL PROTECTED] mailing list is only meant for
repeatable bugs report with full examples.  We at MySQL AB will ensure
that all bug reports of this type are promptly answered and all bugs
are fixed or documented (if the final fix has to be delayed to a
future MySQL version because of design problems).  Please post normal
other reports to the [EMAIL PROTECTED] list or to the appropriate
mailing list.

 dds == dds dds [EMAIL PROTECTED] writes:

dds Hi MySQL Team,
dds I have in my computer installed MySQL v.3.23.37 under
dds Windows NT. But while I was working with datbase the
dds following error occured: Got error 127 from table
dds handler. And I cannot perform any SQL command like
dds SELECT, DELETE, REPLACE, UPDATE, ALTER TABLE and etc.
dds This error always occurs when I perform these commands
dds in one of my tables in the database. Whould you
dds explain me how I can resolve this problem?

You should use 'REPAIR' table on the table in question.
You can find out more about repairing tables in the MySQL online manual.

Regards,
Monty

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

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: Billionium Bug

[Tonu Samuel]

On 09 Sep 2001 17:23:39 +1000, Jason Brooke wrote:
  To Whom it may concern,
 
  I've noticed a bug with the Billionium.  Now that we have hit 1 Billion
  seconds since the beginning of the Epoch mysql will NOT work properly with

This is NOT MySQL bug. I posted separate message with needed
explanations about this to mysql and bugraq lists.

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Security Administrator
/_/  /_/\_, /___/\___\_\___/   Hong Kong, China
   ___/   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

Enquiry

[Koh Hian Jin]

Hi there,

I am Alex, an underguaduate working on my final year project. I would
like to find out if there is a way to tabulate the total number of Sundays
between two dates (for example 2001-01-31 and 2001-04-31) without
creating any tables at all. I tried SQL statements like SELECT
COUNT(DATE) WHERE DATE2001-01-31 AND DATE2001-04-31 AND
DAYOFWEEK(DATE)=1 but to no avail because DATE is not a recognized
field. Therefore, I would appreciate if you could help me out. Thanks.


Yours Sincerely,
Alex


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

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

AW: Should We purchase mysql license Under Windows 2000??----Please Help!!!

[Walter Bertin]

MySQL was till version 3.22.??? shareware
and you had to pay for it when used commercialy (like in your case).
You had only 30 days free useage for, lets say, developing
- if you would use this aldery versions
- in case on new development does not make much sence -
you would have to pay.

since above version 3.22.???, which means all newer version,
is MySQL under the GPL convension
which means to mi -  it is free for a normal use - (like in your case)

 - this is what it is my understending of GPL.
am I right ??? would anyone correct me ???

see on the
http://www.mysql.com/support/arrangements/policy.html this states like

For normal internal use, MySQL costs nothing.
You do not have to pay us if you do not want to.

I understand that - the term - internal use -
means here simple
use MySQL to make SQL-Databases, lets say, for web.


Walter
-Urspr¨¹ngliche Nachricht-
Von: Deryck Henson [mailto:[EMAIL PROTECTED]]
Gesendet: Sonntag, 9. September 2001 04:59
An: aDragon
Cc: MySQL
Betreff: Re: Should We purchase mysql license Under Windows 2000??Please
Help!!!


It's about $208.00 in USD or 1725 CNY (Chinese Currency).
You can buy it from anywhere I THINK.  You might want to check me on that
one.
Just buy it straight from MySQL's website ( http://order.mysql.com ) .
And, in my opinion, I'd just use the free version.
Not as much to worry about, but, if you WANT to pay $208 bucks, go ahead.

- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: aDragon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, September 08, 2001 9:53 PM
Subject: Should We purchase mysql license Under Windows 2000??Please
Help!!!


 hi,Everyone,
I have a great problem now,
I'm building a web site, using MySql as my Database under windows 2000
Advanced Server, and BEA weblogic Server as my server.
I don't whether we should buy the license in order to public our web
site for commercial purpose.
And What's the price for only one license of mysql server?
How to buy it in China? Is there any OEM or other for us to buy easily?

Any help is appreciated!

 aDragon
 [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


_
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

SQL query

[Grega]

hello

i have a question regarding a mySQL query sentence:

i have a mysql database named club with tables disciplines, results,
Swimmers and competitions

columns in tables are:

disciplines:
sif_discipline  int(8)
discipline   varchar(7)
gender  char(1)
pool  int(8)

PRIMARY KEY (sif_discipline)



swimmers:
sif_swimmerint(11)
surname_swimmer  text
name_swimmer   text
gender_swimmertext
born  year(4)

KEY (sif_swimmer),
PRIMARY KEY (sif_swimmer)



results:
sif_swimmer int(11)
sif_competition int(11)
sif_discipline int(11)
resulttext
scalesmallint(6)

PRIMARY KEY (sif_swimmer, sif_competition, sif_discipline),
KEY (sif_swimmer),
KEY (sif_discipline)


competitions:
sif_competition int(11)
date_competition datetime

KEY (sif_competition),
PRIMARY KEY (sif_competition)



variables, passed by PHP:
izpis.php?gender=Mno_of_outputs=10pool_length=25discipline=50K

the sql query i have written:

SELECT swimmers.surname_swimmer , swimmers.name_swimmer , swimmers.born ,
results.result , results.scale , competitions.date_competition
FROM results , disciplines , swimmers , competitions
WHERE results_scale  $no_of_outputs
AND disciplines.gender = '$gender'
AND disciplines.pool = $pool_length
AND disciplines.discipline = '$discipline'
AND results.sif_swimmer = swimmers.sif_swimmer
AND results.sif_discipline = disciplines.sif_discipline
AND results.sif_competition = competitions.sif_competition




now, this query executes for about 10 minutes on an AMD 900/256MB and then i
get an execution time exceeded from PHP

could anyone help me with writing a better query?
i know this one is not so good :)

maybe, the tables in the database are to big? results - 25000 entries,
competitions - 400 entries, swimmers - 6000 entries, disciplines - 100
entries
but probably, thats not the problem, is it? :)

i guess a better query would solve my problem

Thanks in advance!

Grega Lebar


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

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

Simple select problem.

[Eyal Rif]

Hi,

I have a table with the format of : 

char(20),int(7),char(32)

the Date char(20) contents in actually a number(seconds since 1970) -

I want to use a select query that will give the max value according to
number value of that column.

select @last:=MAX(Date) from stat1;

What I need to know is how to convert a string to a number on a select
statement.

Any help/reference will be appreciated

Thanks,

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

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 query

[Ian Moore]

It would be better to use joins. Something like this:

SELECT swimmers.surname_swimmer , swimmers.name_swimmer , swimmers.born ,
results.result , results.scale , competitions.date_competition
FROM results
left join disciplines on results.sif_discipline = disciplines.sif_discipline
left join swimmers on results.sif_swimmer = swimmers.sif_swimmer
left join competitions on results.sif_swimmer = swimmers.sif_swimmer
WHERE results.scale  $no_of_outputs
AND disciplines.gender = '$gender'
AND disciplines.pool = $pool_length
AND disciplines.discipline = '$discipline'

I doubt if this exact query would work best for you so if it is sub-optimal,
read the mysql documentation on joins.

On Mon, Sep 10, at 04:37pm, Grega ([EMAIL PROTECTED]) wrote:

 hello
 
 i have a question regarding a mySQL query sentence:
 
 i have a mysql database named club with tables disciplines, results,
 Swimmers and competitions
 
 columns in tables are:
 
 disciplines:
 sif_discipline  int(8)
 discipline   varchar(7)
 gender  char(1)
 pool  int(8)
 
 PRIMARY KEY (sif_discipline)
 
 
 
 swimmers:
 sif_swimmerint(11)
 surname_swimmer  text
 name_swimmer   text
 gender_swimmertext
 born  year(4)
 
 KEY (sif_swimmer),
 PRIMARY KEY (sif_swimmer)
 
 
 
 results:
 sif_swimmer int(11)
 sif_competition int(11)
 sif_discipline int(11)
 resulttext
 scalesmallint(6)
 
 PRIMARY KEY (sif_swimmer, sif_competition, sif_discipline),
 KEY (sif_swimmer),
 KEY (sif_discipline)
 
 
 competitions:
 sif_competition int(11)
 date_competition datetime
 
 KEY (sif_competition),
 PRIMARY KEY (sif_competition)
 
 
 
 variables, passed by PHP:
 izpis.php?gender=Mno_of_outputs=10pool_length=25discipline=50K
 
 the sql query i have written:
 
 SELECT swimmers.surname_swimmer , swimmers.name_swimmer , swimmers.born ,
 results.result , results.scale , competitions.date_competition
 FROM results , disciplines , swimmers , competitions
 WHERE results_scale  $no_of_outputs
 AND disciplines.gender = '$gender'
 AND disciplines.pool = $pool_length
 AND disciplines.discipline = '$discipline'
 AND results.sif_swimmer = swimmers.sif_swimmer
 AND results.sif_discipline = disciplines.sif_discipline
 AND results.sif_competition = competitions.sif_competition
 
 
 
 
 now, this query executes for about 10 minutes on an AMD 900/256MB and then i
 get an execution time exceeded from PHP
 
 could anyone help me with writing a better query?
 i know this one is not so good :)
 
 maybe, the tables in the database are to big? results - 25000 entries,
 competitions - 400 entries, swimmers - 6000 entries, disciplines - 100
 entries
 but probably, thats not the problem, is it? :)
 
 i guess a better query would solve my problem
 
 Thanks in advance!
 
 Grega Lebar
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 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: Billionium Bug

[Jason Brooke]

You should probably reply to the correct email - according to your email
body, it appears that it was me who made the claim that there was a mysql
bug when I was simply replying to the person who actually did make the
claim.

jason


 On 09 Sep 2001 17:23:39 +1000, Jason Brooke wrote:
   To Whom it may concern,
  
   I've noticed a bug with the Billionium.  Now that we have hit 1
Billion
   seconds since the beginning of the Epoch mysql will NOT work properly
with

 This is NOT MySQL bug. I posted separate message with needed
 explanations about this to mysql and bugraq lists.




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

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

Goldmine

[Oren Yehezkely]

Hi,

Has any one tried using Goldmine with MySQL ?

Thanks,

Oren

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

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: URGENTE - Replication...... - mySql

[Rodrigo Zerlotti]

Ok, got no emails, but I believe I found the problem , which I would
consider a bug.

My LOAD DATA INFILE query was running from a bash script, which was
executing the query thru a command line mysql call. The LOAD DATA was
loading the file into 2 tables on 2 different databases.

Something like:

LOAD  DATA INFILE 'path-to-file'
REPLACE INTO TABLE database1.TABLE-NAME1 FIELDS
TERMINATED BY '\t' LINES TERMINATED BY '\n';

LOAD  DATA INFILE 'path-to-file'
REPLACE INTO TABLE database2.TABLE-NAME2 FIELDS
TERMINATED BY '\t' LINES TERMINATED BY '\n';

Notice that both tables was qualified by the database, 1 and 2. Of course,
to run the command line, I had to logon, choosing one of the databases (they
have permissions to update each other).

The problem is that it would work on the master, but it was executing
(looking at log-bin) the query not qualified. The second statement would
look like:

LOAD  DATA INFILE 'path-to-file'
REPLACE INTO TABLE TABLE-NAME2 FIELDS
TERMINATED BY '\t' LINES TERMINATED BY '\n';

and TABLE_NAME2 was not on database1, where I logged on.

I believe this is bug. The replication engine should keep the qualification
on the table name.


-
Regards,

Rod~

 -Original Message-
 From: Rodrigo Zerlotti [mailto:[EMAIL PROTECTED]]
 Sent: Sunday, September 09, 2001 3:57 AM
 To: Mysql@Lists. Mysql. Com
 Subject: RE: URGENTE - Replication..
 Importance: High


 Ok, no answers yet, but more information:

 master log:

 010909  3:15:36  failed in send_file() : Failed reading file name

 Should the same file used on the master for the load inline be
 already on
 the slave? Or MySql takes care of moving it for us... I try to move myself
 before the sql and didn't work... same error

 Also, ignore table doesn't work when table on the inline query. I
 tried that
 and the slave tried to run the sql

 Configuration: Mandrake + Mysql 3.23.36

 Please help, I would hate to leave replication just because this...

 -
 Regards,

 Rod~

  -Original Message-
  From: Rodrigo Zerlotti [mailto:[EMAIL PROTECTED]]
  Sent: Saturday, September 08, 2001 7:58 PM
  To: Mysql@Lists. Mysql. Com
  Subject: URGENTE - Replication..
  Importance: High
 
 
  Can not find the problem and we are down!
 
  Here the question again (Any advice on replication of LOAD
  DATA INFILE is very appreciated.)
 
  
 
  I setup a mster-slave. My master does a lot of :
 
  LOAD  DATA INFILE 'path-to-file'
  REPLACE INTO TABLE TABLE-NAME FIELDS
  TERMINATED BY '\t' LINES TERMINATED BY '\n';
 
  Notice i am not using LOCAL because the docs states:
 
  LOAD DATA INFILE will be handled properly as long as the file
  still resides on the master server at the time of update
  propagation. LOAD LOCAL DATA INFILE will be skipped.
 
  But on Slave I am getting:
 
  Slave: Error 'Table '%-.64s.%-.64s' doesn't exist' running load
  data infile
 
  Ideas Where should I look???
 
  -
  Regards,
 
  Rod~


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

 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

Updating Customer table

[Armando Cerna]

Hi I am trying to update a table that is full of customer ID's using another 
table with the following command

 update customers set row_id=mc.id where tele=mc.tele;

But it give me the error

ERROR 1109: Unknown table 'mc' in where clause


The table mc does exist I am pretty lost on this one any help would be  great

Armando

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

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

REMOVE NOW THIS IS THE SECOND TIME

[Nev and Emel Gokcen]

I will have you served for a violation of federal law if you do not remove
immediately!!
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Philip Mak [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, September 07, 2001 10:48 PM
Subject: Re: Perl DBI: Same column name in different tables problem


 On Fri, Sep 07, 2001 at 10:03:03PM -0700, Philip Mak wrote:
  Let's say I performed the following query using Perl DBI:
 
  $row = $dbh-selectrow_hashref(~);
  SELECT fanfics.handle, authors.handle
  FROM fanfics, authors
  WHERE fanfics.aid = authors.aid
  ~
 
  I won't be able to access both fanfics.handle and authors.handle
  this way, because they're called handle. I would like to be able
  to access them e.g. by doing $row-{fanfics.handle} and
  $row-{authors.handle}, or something like that.
 
  What workarounds have people found for this problem?

 Use a column alias:

   SELECT fanfics.handle as f_handle, authors.handle as a_handle
 FROM fanfics, authors
WHERE fanfics.aid = authors.aid

 Then refer to them as $row-{a_handle} or $row-{f_handle}.

 Jeremy
 --
 Jeremy D. Zawodny, [EMAIL PROTECTED]
 Technical Yahoo - Yahoo Finance
 Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

 MySQL 3.23.41-max: up 2 days, processed 42,300,526 queries (237/sec. avg)

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

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



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

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: REMOVE NOW THIS IS THE SECOND TIME

[Mourad de Riche]

Umm,

Is he drunk or something? Report to a federal law?

It's like a mail from a mailing list, i mean... whats wrong with these
people.

On Sun, 9 Sep 2001, Nev and Emel Gokcen wrote:

 I will have you served for a violation of federal law if you do not remove
 immediately!!

 - Original Message -
 From: Jeremy Zawodny [EMAIL PROTECTED]
 To: Philip Mak [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Sent: Friday, September 07, 2001 10:48 PM
 Subject: Re: Perl DBI: Same column name in different tables problem



--
Regards, Mourad de Riche
Omnix Resources Online 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

RE: REMOVE NOW THIS IS THE SECOND TIME

[Kenneth Wells]

Nev and emel,

Stop being an asshole and take your name out of the mailing list. It
does work you know



-Original Message-
From: Nev and Emel Gokcen [mailto:[EMAIL PROTECTED]] 
Sent: Sunday, September 09, 2001 2:05 PM
To: [EMAIL PROTECTED]
Subject: REMOVE NOW THIS IS THE SECOND TIME 


I will have you served for a violation of federal law if you do not
remove immediately!!
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Philip Mak [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, September 07, 2001 10:48 PM
Subject: Re: Perl DBI: Same column name in different tables problem


 On Fri, Sep 07, 2001 at 10:03:03PM -0700, Philip Mak wrote:
  Let's say I performed the following query using Perl DBI:
 
  $row = $dbh-selectrow_hashref(~);
  SELECT fanfics.handle, authors.handle
  FROM fanfics, authors
  WHERE fanfics.aid = authors.aid
  ~
 
  I won't be able to access both fanfics.handle and authors.handle 
  this way, because they're called handle. I would like to be able 
  to access them e.g. by doing $row-{fanfics.handle} and 
  $row-{authors.handle}, or something like that.
 
  What workarounds have people found for this problem?

 Use a column alias:

   SELECT fanfics.handle as f_handle, authors.handle as a_handle
 FROM fanfics, authors
WHERE fanfics.aid = authors.aid

 Then refer to them as $row-{a_handle} or $row-{f_handle}.

 Jeremy
 --
 Jeremy D. Zawodny, [EMAIL PROTECTED]
 Technical Yahoo - Yahoo Finance
 Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

 MySQL 3.23.41-max: up 2 days, processed 42,300,526 queries (237/sec. 
 avg)

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

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



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

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

MySQL 3.23.42 released

[Michael Widenius]

Hi!

MySQL 3.23.42 is now released.

We recommend anyone using BDB tables or InnoDB tables with BLOB's to
upgrade to this new release.

If you are using InnoDB tables with BLOBS bigger than 8000 bytes, you
should do a mysqldump of the table and then drop and recreate the
table.

Most other bug fixes are for unlikely or minor bugs.

As always, don't be concerned if you can't find this release on web
site or on our mirrors right away;  It takes some time for the web
site to be updated from our development site.


Changes in release 3.23.42
--

   * Fixed problem when using `LOCK TABLES' and `BDB' tables.
 
   * Fixed problem with `REPAIR TABLE' on MyISAM tables with row lengths
 between 65517 - 65520 bytes
 
   * Fixed rare hang when doing `mysqladmin shutdown' when there was a
 lot of activity in other threads.
 
   * Fixed problem with `INSERT DELAYED' where delay thread could be
 hanging on `upgrading locks' without any apparent reasons.
 
   * Fixed problem with `myisampack' and `BLOB'.
 
   * Fixes problem when one edited `.MRG' tables by hand.  (Patch from
 Benjamin Pflugmann).
 
   * Enforce that all tables in a `MERGE' table come from the same
 database.
 
   * Fixed bug with `LOAD DATA INFILE' and transactional tables.
 
   * Fix bug when using `INSERT DELAYED' with wrong column definition.
 
   * Fixed coredump during `REPAIR' of some particularly broken tables.
 
   * Fixed bug in `InnoDB' and `AUTO_INCREMENT' columns.
 
   * Fixed bug in `InnoDB' and `RENAME TABLE' columns.
 
   * Fixed critical bug in `InnoDB' and `BLOB' columns.  If one has
 used `BLOB' columns larger than 8000 bytes in an `InnoDB' table,
 one must dump the table with `mysqldump', drop it and restore it
 from the dump.
 
   * Applied large patch for OS/2 from Yuri Dario.
 
   * Fixed problem with `InnoDB' when one could get the error `Can't
 execute the given command...' even when one didn't have an active
 transaction.
 
   * Applied some minor fixes that concern Gemini.
 
   * Use real arithmetic operations even in integer context if not all
 arguments are integers. (Fixes uncommon bug in some integer
 context).

   * Don't force everything to lower cases on Windows. (To fix problem
 with Windows and `ALTER TABLE').  Now `--lower_case_names' also
 works on Unix.
 
   * Fixed that automatic rollback that is done when thread end doesn't
 lock other threads.

Regards,
Monty

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

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: Wildcard Hostname's in MySQL 3.23.41

[Mike Miller]

I just made the upgrade from 3.22 to 3.23.41 this weekend and had one little 
hiccup.

  I have a few users with host entries with wildcards (hostname = '%').
These users stopped working and were not able to login.  When I added one 
for the hosts they were connecting from, it began to work fine.  This is all 
in the users table of the MySQL database.

  Is there something I have to do to get wildcard hostnames to work again?
Networking is enabled in case that makes a difference.

  Please help.  Thanks in advance;
--
Mike


query

_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


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

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

windows ME

[Doug V]

Will  mysql  run on  Microsoft's windows ME operating system ?

Thank You,
Doug V.


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

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: windows ME

[Deryck Henson]

No, only Windows 95/98/200/NT

- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Doug V [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 09, 2001 4:24 PM
Subject: windows ME


 Will  mysql  run on  Microsoft's windows ME operating system ?

 Thank You,
 Doug V.


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

 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 * FROM allofthetables

[Benjamin Pflugmann]

Hi.

It cannot be done with a SQL command, except if the structure of all
involved tables is the same. In this case, have a look for MERGE
tables.

Else, you could create a temporary table and use 

INSERT INTO temp SELECT ...

for all tables in question. Of course, you can simulate this in your
application, too.

Bye,

Benjamin.


On Sat, Sep 08, 2001 at 09:09:42PM -0500, [EMAIL PROTECTED] wrote:
 How do I select all of the tables in a database and use a whre clause like
 this??::
 
 SELECT * FROM alltables(substitute with command) WHERE User = 'username'
 
 I need this for my site (Code Cafe- Free source code) so that the user can
 see all the code he has uploaded.  It is done in ASP, but all I need is the
 sql query string.  Thanx
 
 - Deryck H
 - http://www.comp-u-exchange.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: SELECT * FROM allofthetables

[Deryck Henson]

Thanx ben.  But I have found a way to do it :

SELECT * FROM Asp, C, Cpp, Java, Javascript, etc... Where 

If you know asp, write to me in private, I have something that (if you do
know asp) you might be able to help me with.

- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Deryck Henson [EMAIL PROTECTED]
Cc: MySQL [EMAIL PROTECTED]; Webmaster
[EMAIL PROTECTED]
Sent: Sunday, September 09, 2001 4:30 PM
Subject: Re: SELECT * FROM allofthetables


 Hi.

 It cannot be done with a SQL command, except if the structure of all
 involved tables is the same. In this case, have a look for MERGE
 tables.

 Else, you could create a temporary table and use

 INSERT INTO temp SELECT ...

 for all tables in question. Of course, you can simulate this in your
 application, too.

 Bye,

 Benjamin.


 On Sat, Sep 08, 2001 at 09:09:42PM -0500, [EMAIL PROTECTED] wrote:
  How do I select all of the tables in a database and use a whre clause
like
  this??::
 
  SELECT * FROM alltables(substitute with command) WHERE User = 'username'
 
  I need this for my site (Code Cafe- Free source code) so that the user
can
  see all the code he has uploaded.  It is done in ASP, but all I need is
the
  sql query string.  Thanx
 
  - Deryck H
  - http://www.comp-u-exchange.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

Win32 Mysql 3.23.41 will not start anymore

[Ken Sorenson]

I have a V. 3.23.41 sql db installation on Windows 2k server.. Just
stopped and refuses to restart.. I have looked at just about everything.
Uninstalled and reinstalled, restored backups ... Nothing seem to be
working..  Checked through the registry, nothing seems to be off.. Any
ideas were to look? It was running fine for over two weeks..

Thanks!

Ken 


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

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 query

[Benjamin Pflugmann]

Hi.

On Sun, Sep 09, 2001 at 10:52:49AM -0400, [EMAIL PROTECTED] wrote:
 It would be better to use joins. Something like this:

Sorry? He did already use joins. You use LEFT JOINs, which have a
different meaning! So your query may give a different result as
desired. Additionally, LEFT JOINs are usually slower than normal joins
(written with comma).

 SELECT swimmers.surname_swimmer , swimmers.name_swimmer , swimmers.born ,
 results.result , results.scale , competitions.date_competition
 FROM results
 left join disciplines on results.sif_discipline = disciplines.sif_discipline
 left join swimmers on results.sif_swimmer = swimmers.sif_swimmer
 left join competitions on results.sif_swimmer = swimmers.sif_swimmer
 WHERE results.scale  $no_of_outputs
 AND disciplines.gender = '$gender'
 AND disciplines.pool = $pool_length
 AND disciplines.discipline = '$discipline'

 On Mon, Sep 10, at 04:37pm, Grega ([EMAIL PROTECTED]) wrote:
  

Grega, could you post the result of EXPLAIN your select?

Note that KEY(sif_swimmer) is redundant if you already have PRIMARY
KEY (sif_swimmer), but this does only little harm. The same is true
for the other tables.

Maybe an additional key on disciplines could be helpful, but I doubt
that this has a huge impact as the table is rather small.

Btw, how many rows do you expect the result set to have?

[...]
  disciplines:
  sif_discipline  int(8)
  discipline   varchar(7)
  gender  char(1)
  pool  int(8)
  
  PRIMARY KEY (sif_discipline)
  
  swimmers:
  sif_swimmerint(11)
  surname_swimmer  text
  name_swimmer   text
  gender_swimmertext
  born  year(4)
  
  KEY (sif_swimmer),
  PRIMARY KEY (sif_swimmer)
  
  results:
  sif_swimmer int(11)
  sif_competition int(11)
  sif_discipline int(11)
  resulttext
  scalesmallint(6)
  
  PRIMARY KEY (sif_swimmer, sif_competition, sif_discipline),
  KEY (sif_swimmer),
  KEY (sif_discipline)
  
  competitions:
  sif_competition int(11)
  date_competition datetime
  
  KEY (sif_competition),
  PRIMARY KEY (sif_competition)
  
  the sql query i have written:
  
  SELECT swimmers.surname_swimmer , swimmers.name_swimmer , swimmers.born ,
  results.result , results.scale , competitions.date_competition
  FROM results , disciplines , swimmers , competitions
  WHERE results_scale  $no_of_outputs
  AND disciplines.gender = '$gender'
  AND disciplines.pool = $pool_length
  AND disciplines.discipline = '$discipline'
  AND results.sif_swimmer = swimmers.sif_swimmer
  AND results.sif_discipline = disciplines.sif_discipline
  AND results.sif_competition = competitions.sif_competition
  
  now, this query executes for about 10 minutes on an AMD 900/256MB and then i
  get an execution time exceeded from PHP

Ever tried it in the command line client?

  could anyone help me with writing a better query?

The query itself looks fine. It's rather that the database can need
some indexes or the MySQL server is not so well tuned.

  maybe, the tables in the database are to big? results - 25000 entries,
  competitions - 400 entries, swimmers - 6000 entries, disciplines - 100
  entries
  but probably, thats not the problem, is it? :)

It depends. In the worst case, a join has to examine
25000*400*6000*100 = 6.000.000.000.000 rows, which may take some
time. :-)

Normally this number is greatly reduced by the use of indexes. So
let's see the EXPLAIN and then we can tell a lot more (at least I hope
so ;).

Bye,

Benjamin.


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

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 runs on windows ME

[WCBaker]

I have 2 OS's.   One is Linux and the other is WinME.  MySql runs fine on
BOTH systems (it is running just fine on Win ME right now).

-w


- Original Message -
From: Doug V [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 09, 2001 2:24 PM
Subject: windows ME


 Will  mysql  run on  Microsoft's windows ME operating system ?

 Thank You,
 Doug V.



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

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 locked thread with MySQL-4.0 ?

[Fournier Jocelyn [Presence-PC]]

Hi,

I'm using MySQL 4.0.0-alpha, and I'm wondering why sometimes I have so many
lock in my processlist (I don't see any non-locked INSERT which could cause
all the lock).

mysql show processlist;
+---+---+---++-+--+--+--

+
| Id| User  | Host  | db | Command | Time | State|
Info
|
+---+---+---++-+--+--+--

+
| 39767 | mysql | localhost | Hardwarefr | Sleep   | 94   |  |
NULL
|
| 40364 | mysql | localhost | Hardwarefr | Sleep   | 44   |  |
NULL
|
| 40479 | mysql | localhost | Hardwarefr | Sleep   | 13   |  |
NULL
|
| 40586 | mysql | localhost | Hardwarefr | Sleep   | 15   |  |
NULL
|
| 40709 | mysql | localhost | Hardwarefr | Query   | 14   | Locked   |
INSERT INTO threadhardwarefr7
(numeropost,icone,contenu,pseudo,date,signature,ip) VALUES (48128,16,' |
| 40723 | mysql | localhost | Hardwarefr | Sleep   | 123  |  |
NULL
|
| 40757 | mysql | localhost | Hardwarefr | Query   | 7| Locked   |
SELECT COUNT(*) FROM threadhardwarefr7
|
| 40773 | mysql | localhost | Hardwarefr | Sleep   | 70   |  |
NULL
|
| 40805 | mysql | localhost | Hardwarefr | Sleep   | 27   |  |
NULL
|
| 40851 | mysql | localhost | Hardwarefr | Sleep   | 13   |  |
NULL
|
| 40874 | mysql | localhost | Hardwarefr | Sleep   | 122  |  |
NULL
|
| 40878 | mysql | localhost | Hardwarefr | Sleep   | 36   |  |
NULL
|
| 40881 | mysql | localhost | Hardwarefr | Sleep   | 9|  |
NULL
|
| 40893 | mysql | localhost | Hardwarefr | Sleep   | 120  |  |
NULL
|
| 40966 | mysql | localhost | Hardwarefr | Sleep   | 12   |  |
NULL
|
| 40970 | mysql | localhost | Hardwarefr | Sleep   | 2|  |
NULL
|
| 40979 | mysql | localhost | Hardwarefr | Sleep   | 9|  |
NULL
|
| 40995 | mysql | localhost | Hardwarefr | Sleep   | 14   |  |
NULL
|
| 40997 | mysql | localhost | Hardwarefr | Sleep   | 109  |  |
NULL
|
| 41009 | mysql | localhost | Hardwarefr | Sleep   | 195  |  |
NULL
|
| 41014 | mysql | localhost | Hardwarefr | Query   | 11   | Locked   |
SELECT 1 FROM threadhardwarefr7 WHERE numeropost=48069 AND pseudo='OTH'
LIMIT 1  |
| 41034 | mysql | localhost | Hardwarefr | Sleep   | 17   |  |
NULL
|
| 41052 | mysql | localhost | Hardwarefr | Sleep   | 51   |  |
NULL
|
| 41063 | mysql | localhost | Hardwarefr | Sleep   | 8|  |
NULL
|
| 41064 | mysql | localhost | Hardwarefr | Query   | 9| Locked   |
SELECT 1 FROM threadhardwarefr7 WHERE numeropost=48124 AND pseudo='Tchou'
LIMIT 1|
| 41069 | mysql | localhost | Hardwarefr | Sleep   | 6|  |
NULL
|
| 41109 | mysql | localhost | Hardwarefr | Sleep   | 69   |  |
NULL
|
| 41123 | mysql | localhost | Hardwarefr | Sleep   | 33   |  |
NULL
|
| 41128 | mysql | localhost | Hardwarefr | Sleep   | 49   |  |
NULL
|
| 41131 | mysql | localhost | Hardwarefr | Sleep   | 31   |  |
NULL
|
| 41135 | mysql | localhost | Hardwarefr | Query   | 12   | Locked   |
SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM
threadhardwarefr7 WHERE num |
| 41136 | mysql | localhost | Hardwarefr | Sleep   | 55   |  |
NULL
|
| 41204 | mysql | localhost | Hardwarefr | Sleep   | 11   |  |
NULL
|
| 41205 | mysql | localhost | Hardwarefr | Query   | 14   | Locked   |
SELECT 1 FROM threadhardwarefr7 WHERE numeropost=48128 AND pseudo='LYLO'
LIMIT 1 |
| 41207 | mysql | localhost | Hardwarefr | Sleep   | 66   |  |
NULL
|
| 41214 | mysql | localhost | Hardwarefr | Query   | 14   | Locked   |
SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM
threadhardwarefr7 WHERE num |
| 41215 | mysql | localhost | Hardwarefr | Query   | 13   | Locked   |
SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM
threadhardwarefr7 WHERE num |
| 41216 | mysql | localhost | Hardwarefr | Sleep   | 111  |  |
NULL
|
| 41221 | mysql | localhost | Hardwarefr | Sleep   | 15   |  |
NULL
|
| 41257 | mysql | localhost | Hardwarefr | Sleep   | 10   |  |
NULL
|
| 41326 | mysql | localhost | Hardwarefr | Sleep   | 75   |  |
NULL
|
| 41329 | mysql | localhost | Hardwarefr | Sleep   | 87   |  |
NULL
|
| 41331 | mysql | localhost | Hardwarefr | Sleep   | 74   |  |
NULL
|
| 41352 | mysql | localhost | Hardwarefr | Sleep   | 71   |  |
NULL
|
| 41366 | mysql | localhost | Hardwarefr | 

Re: MySql runs on windows ME

[WCBaker]

I have 2 OS's.   One is Linux and the other is WinME.  MySql runs fine on
BOTH systems (it is running just fine on Win ME right now).

-w


- Original Message -
From: Doug V [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 09, 2001 2:24 PM
Subject: windows ME


 Will  mysql  run on  Microsoft's windows ME operating system ?

 Thank You,
 Doug V.



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

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 * FROM allofthetables

[Benjamin Pflugmann]

Hi.

On Sun, Sep 09, 2001 at 04:44:24PM -0500, [EMAIL PROTECTED] wrote:
 Thanx ben.  But I have found a way to do it :
 
 SELECT * FROM Asp, C, Cpp, Java, Javascript, etc... Where 

You know, that this is not really the same? You (should) get each code
of each table paired with each code from each other table (for that
user, of course). That can be quite slow and you get a result multiple
times.

It doesn't work (I think), if no code for a user appears in one of the
tables. For this to work, you need to use LEFT JOINs, but then you
would still get too much results.

Maybe I misunderstand you database design here, assume you have
something like:

Asp:
Usercodesomeotherfields
Tom 1234
Paulabcd

Cpp 
Usercode
Tom 
Tom 
Tom 

In this case

SELECT * FROM Asp, Cpp WHERE Asp.User='Tom' AND Cpp.User='Tom' gives back:
UsercodeUsercode
Tom 1234Tom 
Tom 1234Tom 
Tom 1234Tom 

and SELECT * FROM Asp, Cpp WHERE Asp.User='Paul' AND Cpp.User='Paul'
results in an empty set, because there is no row with Cpp.User='Paul'.

There, if it works for you, you obviously skipped some important
detail of your database design.

Usually, if the table all have the same structure, in relational
design they shouldn't have split at the first place, but the language
should be a flag in a column. But real life shows other needs
sometimes... if you need them split, you could use a MERGE table, as
said.

If they have a different structure, you may want to explain.

 If you know asp, write to me in private, I have something that (if you do
 know asp) you might be able to help me with.

Sorry, never had my hands on ASP.

Bye,

Benjamin.


 From: Benjamin Pflugmann [EMAIL PROTECTED]
  Hi.
 
  It cannot be done with a SQL command, except if the structure of all
  involved tables is the same. In this case, have a look for MERGE
  tables.
 
  Else, you could create a temporary table and use
 
  INSERT INTO temp SELECT ...
 
  for all tables in question. Of course, you can simulate this in your
  application, too.
 
  On Sat, Sep 08, 2001 at 09:09:42PM -0500, [EMAIL PROTECTED] wrote:
   How do I select all of the tables in a database and use a whre
   clause like this??:: 
  
   SELECT * FROM alltables(substitute with command) WHERE User =
   'username' I need this for my site (Code Cafe- Free source code)
   so that the user can see all the code he has uploaded.  It is
   done in ASP, but all I need is the sql query string.  Thanx

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

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

RE: How to purchase MySQL License In China (People's Republic of China)?

[Simon K. Chan]

Nh, you shouldn't be surprised, John.
Only stuff related to politics gets band, my friend.
Huh.  Almost surprised you didn't know that...


##
--- John Coggeshall [EMAIL PROTECTED] wrote:
 
 huh. almost surprised China lets it's citizens get out this far in the
 Internet...
 
 John
 
 
 |-Original Message-
 |From: aDragon [mailto:[EMAIL PROTECTED]]
 |Sent: Saturday, September 08, 2001 11:14 PM
 |To: [EMAIL PROTECTED]
 |Subject: How to purchase MySQL License In China (People's Republic
 |of China)?
 |
 |
 |hi, everyone,
 |   is there any easy way to buy mySQL in China?
 |Is there any company who manage the OEM for MySQL in China,
 |I am in Beijing, please Contact with me.
 |My tel: 86-10-62209449
 |email:  [EMAIL PROTECTED]
 |
 |aDragon
 |[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
 


=
#
Warmest Regards,
Simon K. Chan - [EMAIL PROTECTED]

Great spirits have always encountered violent opposition from mediocre minds.

-Albert Einstein

__
Do You Yahoo!?
Get email alerts  NEW webcam video instant messaging with Yahoo! Messenger
http://im.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

The EXTRA field

[Ralof]

Hi, I would like to use the EXTRA field for 
sorting and maybe caption, but I find no way
of setting it.
I tried like:

Alter table myTable 
change  myField myNewField varchar(255) DEFAULT 'a' EXTRA '3'

But that does not work.
I can not find anything in the documentation about this.

Thanks

Stefan

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

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 SELECT QUESTION

[Paul DuBois]

At 8:44 PM -0500 9/9/01, Marcus Young wrote:
Hi,

I'm fairly new to MySQL.  I'm trying to insert data into a table 
where one field is derived from a SELECT on another table (a key) 
and the other fields are defined directly (eg field_01=abcd) . 
The formats I have been trying don't appear to be correct.  Is the 
commbined insert possible or what is the appropriate technique?

thanks in anticipation,

Marcus

INSERT INTO tbl2 (col1, col2, col3) SELECT key, 'abcd', 'efgh' FROM tbl2

-- 
Paul DuBois, [EMAIL PROTECTED]

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

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

Re: INSERT SELECT QUESTION

[Calvin Chin]

Try to look at page 442 to 446 of the mySQL manual, it may give some help 
on your field creation using insert  select.

Regards,
Calvin Chin
[EMAIL PROTECTED]
Ipmuda Berhad - Building materials for tomorrow's world !


-Original Message-
From: Marcus Young [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Sun, 09 Sep 2001 20:44:23 -0500
Subject: INSERT SELECT QUESTION

 Hi,
 
 I'm fairly new to MySQL.  I'm trying to insert data into a table where
 one field is derived from a SELECT on another table (a key) and the
 other fields are defined directly (eg field_01=abcd) .  The formats I
 have been trying don't appear to be correct.  Is the commbined insert
 possible or what is the appropriate technique?
 
 thanks in anticipation,
 
 Marcus
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 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

sqld core dump after power failure

[Katrina Maffey]

Description:

After a brief power failure, I rebooted the mysql server machine, and got this 
error on startup:

Starting mysqld daemon with databases from /var/lib/mysql
/usr/bin/safe_mysqld: line 254:  1844 Segmentation fault  (core dumped) 
$NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION 
--datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21
010910 13:32:48  mysqld ended

I tried running myisamchk -re on every *.MYI file under /var/lib/mysql, and they 
seemed to repair successfully, however the crash still occurs. From the strace output, 
I don't think mysqld even gets as far as opening these files. What else can I try to 
get mysqld running again?

  Extra info:

The following lines appeared  at boot time immediately after the power failure:
Sep  7 10:29:43 plex5 fsck: / was not cleanly unmounted, check forced. 
Sep  7 10:29:43 plex5 fsck: /:  
Sep  7 10:29:43 plex5 fsck: Deleted inode 314548 has zero dtime.  FIXED. 
Sep  7 10:29:43 plex5 fsck: /: Deleted inode 315383 has zero dtime.  FIXED. 
Sep  7 10:29:43 plex5 fsck: /:  
Sep  7 10:29:43 plex5 fsck: Deleted inode 657264 has zero dtime.  FIXED. 
Sep  7 10:29:43 plex5 fsck: Setting filetype for entry 'mysql.sock' in /var/lib/mysql 
(163202) to 6. 
Sep  7 10:29:43 plex5 fsck: Setting filetype for entry 'log' in /dev (195841) to 6. 
Sep  7 10:29:43 plex5 fsck: Setting filetype for entry 'gpmctl' in /dev (195841) to 6. 
Sep  7 10:29:43 plex5 fsck: Setting filetype for entry 'fs7100' in /tmp/.font-unix 
(315379) to 6. 
Sep  7 10:29:43 plex5 fsck: Setting filetype for entry 'plex5.oz.agile.tv:0.0' in 
/tmp/.sawmill-root (473314) to 6. 
Sep  7 10:29:43 plex5 fsck: Setting filetype for entry 'X0' in /tmp/.X11-unix (526411) 
to 6. 
Sep  7 10:29:43 plex5 fsck: Setting filetype for entry 'orb-1329759521518799309' in 
/tmp/orbit-root (526413) to 6. 
Sep  7 10:29:43 plex5 fsck: Setting filetype for entry 'pump.sock' in /var/run 
(734401) to 6. 
Sep  7 10:29:43 plex5 fsck: Setting filetype for entry '6797' in /tmp/.ICE-unix 
(848723) to 6. 
Sep  7 10:29:43 plex5 fsck: /: 291612/897600 files (1.0% non-contiguous), 
1510399/1793247 blocks 
Sep  7 10:29:43 plex5 rc.sysinit: Checking root filesystem succeeded 



  Strace output:

execve(/usr/sbin/mysqld, [/usr/sbin/mysqld, --basedir=/, 
--datadir=/var/lib/mysql, --user=mysql, 
--pid-file=/var/lib/mysql/plex5.oz.agile.tv.pid, --skip-locking], [/* 41 vars */]) 
= 0
fcntl(0, F_GETFD)   = 0
fcntl(1, F_GETFD)   = 0
fcntl(2, F_GETFD)   = 0
personality(PER_LINUX)  = 0
geteuid()   = 0
getuid()= 0
getegid()   = 0
getgid()= 0
getpid()= 2130
getrlimit(RLIMIT_STACK, {rlim_cur=8192*1024, rlim_max=2147483647}) = 0
setrlimit(RLIMIT_STACK, {rlim_cur=120*1024, rlim_max=2147483647}) = 0
uname({sys=Linux, node=plex5.oz.agile.tv, ...}) = 0
rt_sigaction(SIGRT_0, {0x81303dc, [], 0x400}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {0x8130448, [], 0x400}, NULL, 8) = 0
rt_sigaction(SIGRT_2, {0x8130508, [], 0x400}, NULL, 8) = 0
rt_sigprocmask(SIG_BLOCK, [RT_0], NULL, 8) = 0
brk(0)  = 0x82272b8
brk(0x82272e8)  = 0x82272e8
brk(0x8228000)  = 0x8228000
getpid()= 2130
open(/etc/localtime, O_RDONLY)= 3
read(3, TZif\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\4\0\0\0\4\0..., 44) = 44
read(3, \234N\246\234\234\274 \360\313T\263\0\313\307Wp\314\267..., 80) = 80
fstat64(3, 0xb404)  = -1 ENOSYS (Function not implemented)
fstat(3, {st_mode=S_IFREG|0644, st_size=160, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0x4000
read(3, \0\0\232\260\1\0\0\0\214\240\0\0\0\0\232\260\1\0\0\0\214..., 4096) = 36
close(3)= 0
munmap(0x4000, 4096)= 0
time(NULL)  = 999841159
uname({sys=Linux, node=plex5.oz.agile.tv, ...}) = 0
open(/etc/my.cnf, O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory)
open(/var/lib/mysql/my.cnf, O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or 
directory)
open(/root/.my.cnf, O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory)
lstat(/, {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open(/usr/share/mysql/charsets/Index, O_RDONLY|O_LARGEFILE) = 3
fstat(3, {st_mode=S_IFREG|0755, st_size=549, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0x4000
read(3, # sql/share/charsets/Index\n#\n# T..., 4096) = 549
brk(0x822a000)  = 0x822a000
read(3, , 4096)   = 0
close(3)= 0
munmap(0x4000, 4096)= 0
stat(/usr/share/mysql/charsets/dec8.conf, 

Re: windows ME

[Paul DuBois]

At 4:29 PM -0500 9/9/01, Deryck Henson wrote:
No, only Windows 95/98/200/NT

What problems have you seen?  It works under Windows ME for me.


- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: Doug V [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, September 09, 2001 4:24 PM
Subject: windows ME


  Will  mysql  run on  Microsoft's windows ME operating system ?

  Thank You,
   Doug V.


-- 
Paul DuBois, [EMAIL PROTECTED]

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

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

BDB Tables, InnoDB tables ??

[Nilesh Parmar]

 Hi 
  I just came across these words in the mailing lists. 
  Can anyone tell me what are BDB tables and  InnoDB tables  .
I am new to mysql and would like to know what are they .
thanx in advance 
Nilesh




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

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: BDB Tables, InnoDB tables ??

[Nilesh Parmar]

 Hi 
   I just came across these words in the mailing lists. 
   Can anyone tell me what are BDB tables and  InnoDB tables  .
 I am new to mysql and would like to know what are they .
 thanx in advance 
 Nilesh
 
 
 


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

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: windows ME

[Miguel Angel Solórzano]

At 17:24 09/09/2001 -0400, Doug V wrote:
Hi,

Personally I didn't tried on Win ME. However some users had
reported it use without problem. To avoid the problem to
start without the DOS prompt screen, use WinMYSQLAdmin.exe
which you find at \mysql\bin directory.

Regards,
Miguel

Will  mysql  run on  Microsoft's windows ME operating system ?

Thank You,
Doug V.


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

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


-- 
For technical support contracts, goto https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
___/   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: Win32 Mysql 3.23.41 will not start anymore

[Miguel Angel Solórzano]

At 16:43 09/09/2001 -0500, Ken Sorenson wrote:
Hi,

Follow the step below:

- Install the MySQL stuff.
- Go to \mysql\bin directory with a DOS prompt screen.
- Type the command: mysqld-nt-max --remove (Even you don't have the
   service, this don't provoke any problem).
- With the explorer open or create the \winnt\my.ini file
- Edit the following keys:

[mysqld]
basedir= yourdirpath  e.g.: c:\mysql
datadir= c:\mysql\data
skip-innodb

If you want to use InnoDB table, read the manual about the
variables you need and the directories that you need to create
manually.

- At the DOS prompt type:
   mysqld-max-nt --standalone

- Take a look in the messages errors that you got. Try to resolve
   or send me the printed messages.
- If you want to use the server as service. Do:
   mysqladmin shutdown
- mysqld-max-nt --install
- net start mysql

Regards,
Miguel



I have a V. 3.23.41 sql db installation on Windows 2k server.. Just
stopped and refuses to restart.. I have looked at just about everything.
Uninstalled and reinstalled, restored backups ... Nothing seem to be
working..  Checked through the registry, nothing seems to be off.. Any
ideas were to look? It was running fine for over two weeks..

Thanks!

Ken


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

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

-- 
For technical support contracts, goto https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
___/   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