date:20020919

Oracle to Mysql

2002-09-19 Thread RP C987342


hello

I want to move my database from Oracle to MySql, I am new to MySql.

Is there any documentation listing the important issues involved
in the migration?

thanks,



_
MSN Photos is the easiest way to share and print your photos: 
http://photos.msn.com/support/worldwide.aspx


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

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: optimizer bug in selecting fields that don´t belong to the index used by mysql

2002-09-19 Thread MySQL

   Date: Wed, 18 Sep 2002 05:46:39 -0400
   From: [EMAIL PROTECTED]

   InnoDB table

   Select Cod,Nom,Nif,Nombre_comercial from Clientes Where (Nom = 'a2618' And 
   Cod'059336') Or Nom'a2618' Order by Nom ASC, Cod ASC Limit 50;

   Time:0.08 secs.
   Handler_read_next: 1850 

  MyIsam table

  Select Cod,Nom,Nif,Nombre_comercial from Clientes Where (Nom = 'a2618' And 
  Cod'059336') Or Nom'a2618' Order by Nom ASC, Cod ASC Limit 50;

  Time:0.00 secs.
  Handler_read_next: 49

   Fix:
   -

   Synopsis:optimizer bug in selecting fields that don´t belong to the index used by 
mysql/innodb

   Exectutable:   mysqld-max-nt

---

Since I have the same, but worst, problem with poor performance with
innoDB compared to myISAM, it's not some fluke.  However, since an
award was just issued for innoDB, it's probably not the optimizer as
you suggest.

I'd bet that the problem is in the table conversion.

ALTER TABLE  TYPE=innoDB

is not the right way to convert.

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

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

max_connections

2002-09-19 Thread Stefan Faist


hello,
I want to change the varibale max_connections from 100 to 250. how can
I do that? I use MySQL 3.23.52 under Windows XP professional
Is the place I take the set-variable = max_connections=300 wrong?
 
I have the fallowing my.ini:
 
=== Begin of my.ini ==
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
# 
# One can use all long options that the program supports.
# Run the program with --help to get a list of available options
 
# This will be passed to all mysql clients
[client]
#password=my_password
port=3306
#socket=MySQL
 
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
 
# The MySQL server
[mysqld]
port=3306
#socket=MySQL
skip-locking
set-variable = key_buffer=256M
set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=1M
set-variable = record_buffer=1M
set-variable = myisam_sort_buffer_size=64M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
log-bin
server-id = 1
 
# Uncomment the following rows if you move the MySQL distribution to
another
# location
basedir =C:/Java/mysql-3.23.52
datadir=C:/Java/mysql-3.23.52/data
 
# Uncomment the following if you are using BDB tables
#set-variable = bdb_cache_size=64M
#set-variable = bdb_max_lock=10
 
# Uncomment the following if you are using Innobase tables
#innodb_data_file_path = ibdata1:1000M
#innodb_data_home_dir = c:\ibdata
#innodb_log_group_home_dir = c:\iblogs
#innodb_log_arch_dir = c:\iblogs
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#innodb_log_archive=0
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
#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
# Remove the next comment character if you are not familiar with SQL
#safe-updates
 
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
set-variable= max_connections=300
 
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
 
[mysqlhotcopy]
interactive-timeout
 
[WinMySQLadmin]
Server=C:/Java/mysql-3.23.52/bin/mysqld-nt.exe
user=admin
password=admin

=== End of my.ini ===
 
Thank you for reply
 
Regards
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

Loading jpeg and avi files to blob

2002-09-19 Thread kayamboo

Hello everyone

Can anyone give me some tips on how to insert and select jpeg and avi files
to a blob data type ?

Version used : mysql4.0.3-beta(innodb)
DTool  : Delphi5.0 with zeos libraries

Regards


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

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

Boolean Data Type in MySQL

2002-09-19 Thread Arul

Hi All

Does MySQl Support Boolean Datatypes

-Arul


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

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

2002-09-19 Thread Karthik


yes. put an entry set-variable=max_connections=300 after set-variable =
thread_concurrency=8 in your my.ini. Make sure this change is done in the
my.ini that is in the windows directory.

Karthik.

- Original Message -
From: Stefan Faist [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 12:15 PM
Subject: max_connections


 hello,
 I want to change the varibale max_connections from 100 to 250. how can
 I do that? I use MySQL 3.23.52 under Windows XP professional
 Is the place I take the set-variable = max_connections=300 wrong?

 I have the fallowing my.ini:

 === Begin of my.ini ==
 # Example mysql config file.
 # Copy this file to c:\my.cnf to set global options
 #
 # One can use all long options that the program supports.
 # Run the program with --help to get a list of available options

 # This will be passed to all mysql clients
 [client]
 #password=my_password
 port=3306
 #socket=MySQL

 # Here is entries for some specific programs
 # The following values assume you have at least 32M ram

 # The MySQL server
 [mysqld]
 port=3306
 #socket=MySQL
 skip-locking
 set-variable = key_buffer=256M
 set-variable = max_allowed_packet=1M
 set-variable = table_cache=256
 set-variable = sort_buffer=1M
 set-variable = record_buffer=1M
 set-variable = myisam_sort_buffer_size=64M
 set-variable = thread_cache=8
 # Try number of CPU's*2 for thread_concurrency
 set-variable = thread_concurrency=8
 log-bin
 server-id = 1

 # Uncomment the following rows if you move the MySQL distribution to
 another
 # location
 basedir =C:/Java/mysql-3.23.52
 datadir=C:/Java/mysql-3.23.52/data

 # Uncomment the following if you are using BDB tables
 #set-variable = bdb_cache_size=64M
 #set-variable = bdb_max_lock=10

 # Uncomment the following if you are using Innobase tables
 #innodb_data_file_path = ibdata1:1000M
 #innodb_data_home_dir = c:\ibdata
 #innodb_log_group_home_dir = c:\iblogs
 #innodb_log_arch_dir = c:\iblogs
 #set-variable = innodb_mirrored_log_groups=1
 #set-variable = innodb_log_files_in_group=3
 #set-variable = innodb_log_file_size=5M
 #set-variable = innodb_log_buffer_size=8M
 #innodb_flush_log_at_trx_commit=1
 #innodb_log_archive=0
 #set-variable = innodb_buffer_pool_size=16M
 #set-variable = innodb_additional_mem_pool_size=2M
 #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
 # Remove the next comment character if you are not familiar with SQL
 #safe-updates

 [isamchk]
 set-variable = key_buffer=128M
 set-variable = sort_buffer=128M
 set-variable = read_buffer=2M
 set-variable = write_buffer=2M
 set-variable= max_connections=300

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

 [mysqlhotcopy]
 interactive-timeout

 [WinMySQLadmin]
 Server=C:/Java/mysql-3.23.52/bin/mysqld-nt.exe
 user=admin
 password=admin

 === End of my.ini ===

 Thank you for reply

 Regards
 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




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

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

Syncing Databases.

2002-09-19 Thread Chris


Greetings,

I have the following setup:

- Machine A is running MySQL and is disconnected from the network 80% of
the time.

- Machine B is running MySQL and I would like it to act as a master
server.

- Machine A has a crontab running to check the network status every
second. When the network link comes up, I would like to have machine A's
data transfered to Machine B.

I don't know if this would be the best solution, nor do I know much on this
topic, but would after the network connection is made, should I have a
script write all the records from Machine A to a file (I saw an e-mail
on this list once about dumping all the tables and their info to one .sql
file, and using that for a backup copy) and then transfer that file to
Machine B, then on machine B have the file imported into Machine A's
MySQL?

Im sure there is a better solution to mine.

Any suggestions?

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

JOIN-Question

2002-09-19 Thread Peter Stöcker


Hi there!

I have a question on JOINs.

First the system:

table1: name: t1
entries: name  field1  field2
 
 test   1 2
 test2 3 4

table2: name t2
entries: name  field3  field4
 
 test   5 6
 test   7 8

table3: name t3
entries: name  field5  field6
 
 test   9 10
 test   11   12
 test2 13   14
 test2 15   16

And here the problem:

with the query

SELECT a.*, b.*, c.* FROM t1 a INNER JOIN t2 b USING(name) INNER JOIN t3 c USING(name) 
WHERE b.field3=7 OR c.field6=16;

I only get 1 entry with name=test.

By using LEFT JOIN I only get name=test either. For sure, because in table2 there is 
no test2 entry.

The only 2 ways I know to get also test2:
1. INSERT INTO t2 VALUES(test2,NULL,NULL)
2. temporary table

But I don't want to have such dummy entries or a temporary table. Does anybody know 
what I have to do to with:

SELECT a.*,b.*,c.* FROM ?? WHERE b.field3=5 OR c.field6=16


the result:


namefield1 field2   field3field4   field5   field6
-
test 12  5  6  9 10
test 12  5  6 1112
test2   34   NULLNULL  1516


I hope that someone can help me!

Thank a lot,
Peter
__
WEB.DE MyPage - Ultimatives Kommunikationstool! Ihre Message sofort
online! Domain aenderbar! http://www.das.ist.aber.ne.lustige.sache.ms/


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

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

insert and deletind dublicating

2002-09-19 Thread Savaidis


Hello!

I have to add  a  .sql  file from MySQL-Front

(insert into mytable ('0','asdf',ecc))  

that  containts  some dublicates in the unic key.

How can I do this and later to delere the dublicate records?

The unic key has 3 string fields segments.

Thanks!

Makis



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

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

Palm Pilot Sync / Sync Server.

2002-09-19 Thread Chris


Greetings,

Has anybody had any luck having their Palm Pilot sync with MySQL
using something like pilot-link and NOT just the address book, memo pad,
etc databases. Im looking to sync my Palm Pilot's custom, but generic PDB
database with MySQL either by directly inserting into MySQL (palm -
pilot-link - MySQL) or by dumping the PDB to a plain text file (palm -
pilot-link - PDB converter) and then importing it into MySQL. The latter
would be so you can run any scripts or anything else on the exported PDB
data before it is inserted into MySQL.

Would anybody be interested in developing a SyncServer project as well?

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

Importing date data from text files

2002-09-19 Thread Andrew Whittam - JM Data Services


Hi - I am relatively new to MySQL, previous experience is mainly Visual
FoxPro and MS SQL2000.  

I have a client who supplies data in text files.  In numerous of these
files and subsequent tables there are date fields.  

In the UK we use the date format of dd/mm/.  I understand that MySQL
only accepts data in -mm-dd, and as far as keeping the data in MySQL
I don't have a problem with that, but somehow I have to get the data
into MySQL tables from the text files.  

In SQL Server, I can do this using some VB script in a DTS... is there
anything similar, or, does anyone have any other ideas?

Many thanks

Andrew


JM Data Services
8 Stanton Road
Wimbledon
LONDON
SW20 8RL
 
t:   020-8286 8545
f:   020-8944 8621
m: 07801-866043
e:  [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: JOIN-Question

2002-09-19 Thread Mikhail Entaltsev


Peter,

If you would like to get such resultset

 namefield1 field2   field3field4   field5   field6
 -
 test 12  5  6  9 10
 test 12  5  6 1112
 test2   34   NULLNULL  1516

then you need to use left join for t2, but based only on these information
I couldn't help you to implement this query (I don't know how to group by
rows).
Please, give more information about why do you need exactly this resultset.

Best regards,
Mikhail.

- Original Message -
From: Peter Stöcker [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 11:03 AM
Subject: JOIN-Question


 Hi there!

 I have a question on JOINs.

 First the system:

 table1: name: t1
 entries: name  field1  field2
  
  test   1 2
  test2 3 4

 table2: name t2
 entries: name  field3  field4
  
  test   5 6
  test   7 8

 table3: name t3
 entries: name  field5  field6
  
  test   9 10
  test   11   12
  test2 13   14
  test2 15   16

 And here the problem:

 with the query

 SELECT a.*, b.*, c.* FROM t1 a INNER JOIN t2 b USING(name) INNER JOIN t3 c
USING(name) WHERE b.field3=7 OR c.field6=16;

 I only get 1 entry with name=test.

 By using LEFT JOIN I only get name=test either. For sure, because in
table2 there is no test2 entry.

 The only 2 ways I know to get also test2:
 1. INSERT INTO t2 VALUES(test2,NULL,NULL)
 2. temporary table

 But I don't want to have such dummy entries or a temporary table. Does
anybody know what I have to do to with:

 SELECT a.*,b.*,c.* FROM ?? WHERE b.field3=5 OR c.field6=16


 the result:


 namefield1 field2   field3field4   field5   field6
 -
 test 12  5  6  9 10
 test 12  5  6 1112
 test2   34   NULLNULL  1516


 I hope that someone can help me!

 Thank a lot,
 Peter


__
 WEB.DE MyPage - Ultimatives Kommunikationstool! Ihre Message sofort
 online! Domain aenderbar! http://www.das.ist.aber.ne.lustige.sache.ms/


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

 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

Changing datatypes

2002-09-19 Thread Mark Colvin


Can I change the data type of a column in a table from varchar(10) to
smallint(5) unsigned zerofill. The column that is set to varchar(10) is
populated with values from a primary key column in another table that has a
datatype smallint(5) unsigned zerofill and I need to make them both the
same. I administer my MySQL database from the command line and just need to
know
the syntax for changing data types. Also, can I do this without affecting
the data that is currently in the varchar(10) column (this data has came
from a column of the data type that I wish to change to)?



This e-mail is intended for the recipient only and
may contain confidential information. If you are
not the intended recipient then you should reply
to the sender and take no further ation based
upon the content of the message.
Internet e-mails are not necessarily secure and
CCM Limited does not accept any responsibility
for changes made to this message. 
Although checks have been made to ensure this
message and any attchments are free from viruses
the recipient should ensure that this is the case.


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

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

chunk-size RAID-0 with InnoDB

2002-09-19 Thread Iago Sineiro


Hi all.

Anybody uses MySQL InnoDB with RAID-0?

Wich would be the best chunk-size for a raid-0 where put the datafiles?

Thanks in advance.

Iago.


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

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

Re: Re: JOIN-Question

2002-09-19 Thread Peter Stöcker


Hi Mikhail!

The query should be released automaticly and it shoulb be something like:

SELECT a.*,b.*,c.* FROM ?? WHERE b.field3=5 OR c.field6=16

I want to have all entries wich fit to the condition. But at this time I don't know 
weather there is a entry with name=test or test2 or not. So when there is none it 
should return some NULLs otherwise the entries.

I already tries using LEFT JOINs, but it doesn't work the way I want it to.

Do you think there is a proper way to solve this problem?

CU,
Peter

Mikhail Entaltsev [EMAIL PROTECTED] schrieb am 19.09.02 11:36:16:
 Peter,
 
 If you would like to get such resultset
 
  namefield1 field2   field3field4   field5   field6
  -
  test 12  5  6  9 10
  test 12  5  6 1112
  test2   34   NULLNULL  1516
 
 then you need to use left join for t2, but based only on these information
 I couldn't help you to implement this query (I don't know how to group by
 rows).
 Please, give more information about why do you need exactly this resultset.
 
 Best regards,
 Mikhail.
 
 - Original Message -
 From: Peter Stöcker [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, September 19, 2002 11:03 AM
 Subject: JOIN-Question
 
 
  Hi there!
 
  I have a question on JOINs.
 
  First the system:
 
  table1: name: t1
  entries: name  field1  field2
   
   test   1 2
   test2 3 4
 
  table2: name t2
  entries: name  field3  field4
   
   test   5 6
   test   7 8
 
  table3: name t3
  entries: name  field5  field6
   
   test   9 10
   test   11   12
   test2 13   14
   test2 15   16
 
  And here the problem:
 
  with the query
 
  SELECT a.*, b.*, c.* FROM t1 a INNER JOIN t2 b USING(name) INNER JOIN t3 c
 USING(name) WHERE b.field3=7 OR c.field6=16;
 
  I only get 1 entry with name=test.
 
  By using LEFT JOIN I only get name=test either. For sure, because in
 table2 there is no test2 entry.
 
  The only 2 ways I know to get also test2:
  1. INSERT INTO t2 VALUES(test2,NULL,NULL)
  2. temporary table
 
  But I don't want to have such dummy entries or a temporary table. Does
 anybody know what I have to do to with:
 
  SELECT a.*,b.*,c.* FROM ?? WHERE b.field3=5 OR c.field6=16
 
 
  the result:
 
 
  namefield1 field2   field3field4   field5   field6
  -
  test 12  5  6  9 10
  test 12  5  6 1112
  test2   34   NULLNULL  1516
 
 
  I hope that someone can help me!
 
  Thank a lot,
  Peter
 
 
 __
  WEB.DE MyPage - Ultimatives Kommunikationstool! Ihre Message sofort
  online! Domain aenderbar! http://www.das.ist.aber.ne.lustige.sache.ms/
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 


__
Jetzt testen für 1 Euro! Ihr All-in-one-Paket! 
https://digitaledienste.web.de/Club/?mc=021106


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

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 searching - getting list of stop words?

2002-09-19 Thread Tim Fountain



I'm implementing a search feature on one of my sites and I would like
to have a Google-style X is a very common word and was not included
in your search for stop words.  I believe the stop words in fulltext
searching are dictated at compile time, so is there any way I can get
a list of current stop words from MySQL?

Alternatively, how would I find out the default (assuming there is
one) set of stop words used?


Cheers,
Tim.

-- 
Tim Fountain ([EMAIL PROTECTED])
http://www.tfountain.co.uk/


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

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

Re: Re: JOIN-Question

2002-09-19 Thread Peter Stöcker


Hi CH!

Thanks a lot!  That's it!

I thought there is no differece between ON (condition) and USING(field), but there 
is!

Thank you very much!

CU,
Peter

[EMAIL PROTECTED] schrieb am 19.09.02 12:02:58:
 Hi Peter,
 
 pls try this query. but its not tested.
 
 select t1.name, t1.f1, t1.f2, t2.f3, t2.f4, t3.f5, t3.f6
   from t1 left join t2 on (t1.name = t2.name)
   left join t3 on (t1.name = t3.name)
  where t2.f3 = 5 or t3.f6 = 16
 
 cheers,
 CH
 
 Peter Stöcker wrote:
 
  Hi Mikhail!
 
  The query should be released automaticly and it shoulb be something like:
 
  SELECT a.*,b.*,c.* FROM ?? WHERE b.field3=5 OR c.field6=16
 
  I want to have all entries wich fit to the condition. But at this time 
  I don't know weather there is a entry with name=test or test2 or 
  not. So when there is none it should return some NULLs otherwise the 
  entries.
 
  I already tries using LEFT JOINs, but it doesn't work the way I want 
  it to.
 
  Do you think there is a proper way to solve this problem?
 
  CU,
  Peter
 
  Mikhail Entaltsev [EMAIL PROTECTED] schrieb am 19.09.02 11:36:16:
 
  Peter,
 
  If you would like to get such resultset
 
  name field1 field2 field3 field4 field5 field6
  -
  test 1 2 5 6 9 10
  test 1 2 5 6 11 12
  test2 3 4 NULL NULL 15 16
 
  then you need to use left join for t2, but based only on these 
  information
  I couldn't help you to implement this query (I don't know how to group by
  rows).
  Please, give more information about why do you need exactly this 
  resultset.
 
  Best regards,
  Mikhail.
 
  - Original Message -
  From: Peter Stöcker [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Thursday, September 19, 2002 11:03 AM
  Subject: JOIN-Question
 
 
  Hi there!
 
  I have a question on JOINs.
 
  First the system:
 
  table1: name: t1
  entries: name field1 field2
  
  test 1 2
  test2 3 4
 
  table2: name t2
  entries: name field3 field4
  
  test 5 6
  test 7 8
 
  table3: name t3
  entries: name field5 field6
  
  test 9 10
  test 11 12
  test2 13 14
  test2 15 16
 
  And here the problem:
 
  with the query
 
  SELECT a.*, b.*, c.* FROM t1 a INNER JOIN t2 b USING(name) INNER 
  JOIN t3 c
 
  USING(name) WHERE b.field3=7 OR c.field6=16;
 
  I only get 1 entry with name=test.
 
  By using LEFT JOIN I only get name=test either. For sure, because in
 
  table2 there is no test2 entry.
 
  The only 2 ways I know to get also test2:
  1. INSERT INTO t2 VALUES(test2,NULL,NULL)
  2. temporary table
 
  But I don't want to have such dummy entries or a temporary table. Does
 
  anybody know what I have to do to with:
 
  SELECT a.*,b.*,c.* FROM ?? WHERE b.field3=5 OR c.field6=16
 
 
  the result:
 
 
  name field1 field2 field3 field4 field5 field6
  -
  test 1 2 5 6 9 10
  test 1 2 5 6 11 12
  test2 3 4 NULL NULL 15 16
 
 
  I hope that someone can help me!
 
  Thank a lot,
  Peter
 
  
  __
 
  WEB.DE MyPage - Ultimatives Kommunikationstool! Ihre Message sofort
  online! Domain aenderbar! http://www.das.ist.aber.ne.lustige.sache.ms/
 
 
  -
  Before posting, please check:
  http://www.mysql.com/manual.php (the manual)
  http://lists.mysql.com/ (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
 
  [EMAIL PROTECTED]
 
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 
 
  __
  Jetzt testen für 1 Euro! Ihr All-in-one-Paket!
  https://digitaledienste.web.de/Club/?mc=021106
 
 
  -
  Before posting, please check:
  http://www.mysql.com/manual.php (the manual)
  http://lists.mysql.com/ (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail 
  [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 
 


__
Nur ein Zuhause im Internet: Verwalten Sie alle Ihre E-Mail-Adressen
einfach bei WEB.DE FreeMail! http://freemail.web.de/?mc=021124


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

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

/usr/local/mysql/libexec/mysqld doesn't exist in installation

2002-09-19 Thread moka



Trying to install 4.03 from the tarball...
Any idea whay I am doing wrong??
Thanks, S.Alexiou

Here is what I get
...linux:/usr/local/mysql # scripts/mysql_install_db
Installing all prepared tables
020918 21:55:07  ./bin/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-
files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root 
USER !
This is done with:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h linux password 'new-
password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL = 3.22.10 you 
should run
the ./bin/mysql_fix_privilege_tables. Otherwise you 
will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe 

You can test the MySQL daemon with the benchmarks in 
the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug 
script!

The latest information about MySQL is available on the 
web at
http://www.mysql.com
Support MySQL by buying support/licenses at 
https://order.mysql.com

linux:/usr/local/mysql # vi INSTALL-BINARY
linux:/usr/local/mysql #  bin/mysqld_safe --user=mysql 
[1] 13054
linux:/usr/local/mysql # The 
file /usr/local/mysql/libexec/mysqld doesn't exist or 
is not executable
Please do a cd to the mysql installation directory and 
restart
this script from there as follows:
./bin/mysqld_safe.

[1]+  Exit 1  bin/mysqld_safe --
user=mysql
linux:/usr/local/mysql # ls -
l /usr/local/mysql/libexec/*
ls: /usr/local/mysql/libexec/*: No such file or 
directory
linux:/usr/local/mysql # ls -l
total 4908
drwxr-xr-x   13 root mysql 542 Sep 18 
21:55 .
drwxr-xr-x   13 root root  387 Sep 11 
18:33 ..
-rw-r--r--1 root mysql   19106 Aug 24 17:34 
COPYING
-rw-r--r--1 root mysql   28003 Aug 24 17:34 
COPYING.LIB
-rw-r--r--1 root mysql  122323 Aug 24 16:43 
ChangeLog
-rw-r--r--1 root mysql6808 Aug 24 17:34 
INSTALL-BINARY
-rw-r--r--1 root mysql1937 Aug 24 16:43 
README
drwxr-xr-x2 root mysql1231 Aug 24 17:39 
bin
-rwxr-xr-x1 root mysql 773 Aug 24 17:39 
configure
drwxr-x---2 mysqlmysql  35 Sep 12 17:00 
data
drwxr-xr-x2 root mysql1331 Aug 24 17:39 
include
drwxr-xr-x2 root mysql 208 Aug 24 17:39 
lib
drwxr-xr-x2 root mysql 378 Aug 24 17:39 
man
-rw-r--r--1 root mysql 2531460 Aug 24 17:32 
manual.html
-rw-r--r--1 root mysql 2185064 Aug 24 17:32 
manual.txt
-rw-r--r--1 root mysql   92248 Aug 24 17:32 
manual_toc.html
drwxr-xr-x6 root mysql 199 Aug 24 17:39 
mysql-test
drwxr-xr-x2 root mysql  67 Aug 24 17:39 
scripts
drwxr-xr-x3 root mysql  56 Aug 24 17:39 
share
drwxr-xr-x7 root mysql 869 Aug 24 17:39 
sql-bench
drwxr-xr-x2 root mysql 291 Aug 24 17:39 
support-files
drwxr-xr-x2 root mysql 560 Aug 24 17:39 
tests
-rw-r--r--1 root root11189 Sep 13 20:27 
typescript
linux:/usr/local/mysql # vi INSTALL-BINARY



linux:/usr/local/mysql # ./bin/mysqld_safe
The file /usr/local/mysql/libexec/mysqld doesn't exist 
or is not executable
Please do a cd to the mysql installation directory and 
restart
this script from there as follows:
./bin/mysqld_safe.




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

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

myisampack , sql , admin

2002-09-19 Thread Franz, Fa. PostDirekt MA



Good Morning Ladies and Gentlemen,

there is a real bad problem with myisampack , that never occured before.
I wanted to pack some of my Tables via myisampack and at any condition
you i can imagin (server up , server down , database directory , different directory ,
running myisamchk with mostly any recovering parameter , big table , small table ,
on finger where the sun never shines , etc. )
I got 'Segmentation fault'.
The tables , that I tried to compress worked fine , and gladly still do.
Is that a known problem.
The version of mysql is 3.23.41-log.
The whole stuff installed from RPMs distributed on SUSE 7.3.
Kernel is 2.4.10-4GB.
FS for databases is Reiser.
Root-FS is ext2 (tried it there too).

help me please
Klaus


Topaktuelle Consumer-Adressen anmieten www.consumeradressen.de


Diese Mail ist von:
Deutsche Post Direkt GmbH
Beleglese Center Mannheim

Klaus Franz 
Manager Abgleichsysteme 

Willy-Brandt-Platz 13   Tel. 06 21.129 56 436
68161 Mannheim  


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

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

Re: Re: JOIN-Question

2002-09-19 Thread Mikhail Entaltsev


Peter,

Try this query:

SELECT a.name, a.field1, a.field2,
b.field3, b.field4,c.field5, c.field6
FROM
t1 as a left join t2 as b on (a.name = b.name)
left join t3 as c on (a.name = c.name)
having b.field3=5 OR c.field6=16

Best regards,
Mikhail.



- Original Message -
From: Peter Stöcker [EMAIL PROTECTED]
To: Mikhail Entaltsev [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 11:56 AM
Subject: Re: Re: JOIN-Question


Hi Mikhail!

The query should be released automaticly and it shoulb be something like:

SELECT a.*,b.*,c.* FROM ?? WHERE b.field3=5 OR c.field6=16

I want to have all entries wich fit to the condition. But at this time I
don't know weather there is a entry with name=test or test2 or not. So
when there is none it should return some NULLs otherwise the entries.

I already tries using LEFT JOINs, but it doesn't work the way I want it to.

Do you think there is a proper way to solve this problem?

CU,
Peter

Mikhail Entaltsev [EMAIL PROTECTED] schrieb am 19.09.02 11:36:16:
 Peter,

 If you would like to get such resultset

  namefield1 field2   field3field4   field5   field6
  -
  test 12  5  6  9 10
  test 12  5  6 1112
  test2   34   NULLNULL  1516

 then you need to use left join for t2, but based only on these information
 I couldn't help you to implement this query (I don't know how to group by
 rows).
 Please, give more information about why do you need exactly this
resultset.

 Best regards,
 Mikhail.

 - Original Message -
 From: Peter Stöcker [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, September 19, 2002 11:03 AM
 Subject: JOIN-Question


  Hi there!
 
  I have a question on JOINs.
 
  First the system:
 
  table1: name: t1
  entries: name  field1  field2
   
   test   1 2
   test2 3 4
 
  table2: name t2
  entries: name  field3  field4
   
   test   5 6
   test   7 8
 
  table3: name t3
  entries: name  field5  field6
   
   test   9 10
   test   11   12
   test2 13   14
   test2 15   16
 
  And here the problem:
 
  with the query
 
  SELECT a.*, b.*, c.* FROM t1 a INNER JOIN t2 b USING(name) INNER JOIN t3
c
 USING(name) WHERE b.field3=7 OR c.field6=16;
 
  I only get 1 entry with name=test.
 
  By using LEFT JOIN I only get name=test either. For sure, because in
 table2 there is no test2 entry.
 
  The only 2 ways I know to get also test2:
  1. INSERT INTO t2 VALUES(test2,NULL,NULL)
  2. temporary table
 
  But I don't want to have such dummy entries or a temporary table. Does
 anybody know what I have to do to with:
 
  SELECT a.*,b.*,c.* FROM ?? WHERE b.field3=5 OR c.field6=16
 
 
  the result:
 
 
  namefield1 field2   field3field4   field5   field6
  -
  test 12  5  6  9 10
  test 12  5  6 1112
  test2   34   NULLNULL  1516
 
 
  I hope that someone can help me!
 
  Thank a lot,
  Peter
 


 __
  WEB.DE MyPage - Ultimatives Kommunikationstool! Ihre Message sofort
  online! Domain aenderbar! http://www.das.ist.aber.ne.lustige.sache.ms/
 
 
  -
  Before posting, please check:
 http://www.mysql.com/manual.php   (the manual)
 http://lists.mysql.com/   (the list archive)
 
  To request this thread, e-mail [EMAIL PROTECTED]
  To unsubscribe, e-mail
 [EMAIL PROTECTED]
  Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 




__
Jetzt testen für 1 Euro! Ihr All-in-one-Paket!
https://digitaledienste.web.de/Club/?mc=021106



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

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: Importing date data from text files

2002-09-19 Thread Moestl, Wolfgang


Hi Andrew,

DATE_FORMAT is the function you're looking for.

Check the documentation on it, chapter 6.3.4 Date and Time Functions.

DATE_FORMAT works like the following:

SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');


BTW, SQL Server offers the CONVERT function for this purpose. No need to use some VB 
script in order to convert strings into dates.

Best regards,
Wolf




Hi - I am relatively new to MySQL, previous experience is mainly Visual
FoxPro and MS SQL2000.  

I have a client who supplies data in text files.  In numerous of these
files and subsequent tables there are date fields.  

In the UK we use the date format of dd/mm/.  I understand that MySQL
only accepts data in -mm-dd, and as far as keeping the data in MySQL
I don't have a problem with that, but somehow I have to get the data
into MySQL tables from the text files.  

In SQL Server, I can do this using some VB script in a DTS... is there
anything similar, or, does anyone have any other ideas?

Many thanks

Andrew


JM Data Services
8 Stanton Road
Wimbledon
LONDON
SW20 8RL
 
t:   020-8286 8545
f:   020-8944 8621
m: 07801-866043
e:  [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: Boolean Data Type in MySQL

2002-09-19 Thread rafarife


MySql doesn´t support boolean data type.

Try TinyInt unsigned, with two values: 0 False, 1 True.

Regards,
Rafa


RE: Boolean Data Type in MySQL

__
The NEW Netscape 7.0 browser is now available. Upgrade now! 
http://channels.netscape.com/ns/browsers/download.jsp 

Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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

WG: ABUSE? , myisampack , sql , admin [T2002091901XL]

2002-09-19 Thread Franz, Fa. PostDirekt MA




-Ursprüngliche Nachricht-
Von: Franz, Fa. PostDirekt MA 
Gesendet am: Donnerstag, 19. September 2002 13:00
An: '[EMAIL PROTECTED]'
Betreff: AW:ABUSE? , myisampack , sql , admin [T2002091901XL]

Hi there,

i received this message , after sending a request to mysql-mailing-list:

Thank you for bringing this matter to our attention.  We are sorry for
any inconvenience it has caused you.  Because we receive a large
number of complaints each day at [EMAIL PROTECTED],  regretfully, a
personalized response to each message is not possible.

Please be assured that Verizon investigates each reported occurrence
of unsolicited e-mail or spamming.  We maintain a zero-tolerance
policy in regard to spamming and will take the appropriate action as
permitted by Verizon's Acceptable Use Policy.  To view our policy,
please refer to one of the two following links:

Former Bell Atlantic users:
http://www.bellatlantic.net/help/faqs/#faqpolicies

Former GTE users:
http://www.gte.net/hotlinks/policies/agreement.html

To better understand the problems with unsolicited e-mail, we have
provided information about filtering Spam with your e-mail software,
answers to several frequently asked questions and links to some useful
online information about Spam at the following link:

http://www.gte.net/announcements/spam.html

You may also link directly to our page about unsolicited e-mail:

http://www.gte.net/contact/spam.html

If you are reporting an issue of hacking or other security issues not
related to e-mail abuse, please submit your report to [EMAIL PROTECTED]
for investigation.

Sincerely,
Verizon Internet Services
[EMAIL PROTECTED]

It wasn't my intention to abuse , offend or spam anyone or anything and
i think i didn't do something like that at all.
If i did , i am very sorry about it , but I'd like to know :
What went wrong?

mfg
Klaus

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

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

BUG in InnoDB tables

2002-09-19 Thread deep kapasi


Hi,

I am using MySQL 4.0.3 and Innodb tables for my
application,  I have created a unique index on
multiple column but its not working, here is sql
script to generate an bug


CREATE TABLE TESTING
(
ID INT AUTO_INCREMENT NOT NULL PRIMARY KEY ,
FLD1 VARCHAR(100) NOT NULL ,
FLD2 VARCHAR(15) NOT NULL,
FLD3 INT NOT NULL ,
FLD4 INT NOT NULL ,
FLD5 INT NULL
)TYPE=InnoDB;

CREATE UNIQUE INDEX IX_FLD12345_TESTING ON TESTING
(FLD1,FLD2,FLD3,FLD4,FLD5);

INSERT INTO TESTING (FLD1,FLD2,FLD3,FLD4,FLD5)
VALUES(A,B,1,2,NULL), (A,B,1,2,NULL);

Above INSERT statment tries to insert duplicate
records and though UNIQUE INDEX is created it allows
it. 
Problem is with NULL value, if any of the index field
contains NULL than only this bug is generated.

Is it BUG or Behaviour?

Regards,
Deep


Want to sell your car? advertise on Yahoo Autos Classifieds. It's Free!!
   visit http://in.autos.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

mysql crashing

2002-09-19 Thread Terry


hi,

my mysql is crashing from time to time,
on nothing more than just count(*) on a table.

its 3.23.52 compiled from the sources, running on openbsd 3.1

i have compiled with debug turned on,
but there is no backtrace in the log file when it happens,only
this:

020918 16:16:20  mysqld restarted
/mysql/libexec/mysqld: ready for connections
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=16773120
record_buffer=131072
sort_buffer=524280
max_used_connections=50
max_connections=100
threads_connected=40
It is possible that mysqld could use up to 
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 80379 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation

020919 03:31:48  mysqld restarted

i have increased all the limits on memory, stack, opened files etc to no avail.

what else can i do to debug the problem or resolve the issue ?

regards,
terry


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

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: Marketing materials ??

2002-09-19 Thread John Griffin


My point was that unless you were worried about tens of thousands of simultaneous 
connections, MySQL is a better choice in terms of costs. If you are worried about tens 
of thousands of connections, MS-SQL still isn't a good solution because it won't 
handle the load and it will cost even more money; one lot to convert to MS-SQL, 
another lot to convert to Oracle because Oracle can handle the load. The reason I 
brought Oracle up in the first place is because a properly tuned Oracle database will 
outperform everybody in high load conditions. Twenty five years of experience tends to 
give people a bit of an edge when designing databases ;)

John

-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 5:49 PM
To: John Griffin
Cc: Yuri; [EMAIL PROTECTED]
Subject: Re: Marketing materials ??


On Wed, Sep 18, 2002 at 10:15:05AM -0400, John Griffin wrote:
 Hi Yuri,
 
 Money talks. Point out that MySQL is an open source initiative and
 can save them money. As for knowing another product, such as MS-SQL,
 being a deciding factor; it really isn't an issue. All databases, at
 their core functionality, are the same. The same rules of database
 design apply to all databases. There is a SQL standard that all
 databases conform to (to varying degrees). All backups, etc. still
 need to done regardless of the database. In fact, the only real
 differentiator that management should worry about is scalability. If
 your management is worried about thousands of simultaneous requests
 (i.e.  25,000) than I would suggest you look at an Oracle solution.

You lost me on that last part.  The hardware required to make Oracle
handle 25,000 connections efficiently is FAR more expensive than for
MySQL.  Money talks, right?

Jeremy
-- 
Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED]  |  http://jeremy.zawodny.com/

MySQL 3.23.51: up 43 days, processed 914,113,484 queries (242/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

Re: Oracle to Mysql

2002-09-19 Thread Peter Goggin


There are several major differences that you will need to consider.

1. So far as I know MySQL does not allow you to assign tables and indexes to
table spaces, hence load spreading is much more difficult. You cannot split
tables and indexes so that they reside on differentt disks.

2. There are no stored procedures and triggers available in MySQL.

3. You will need to use the Innodb or equivalent extensions to get
transaction processing.

4. The table and index creation syntax is different with MySQL. (Personally
I found MySQL somewhat more logical).

If you want to discuss the issues in more detail please e-mail me directly.

Regards

Peter Goggin

- Original Message -
From: RP C987342 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 4:29 PM
Subject: Oracle to Mysql


 hello

 I want to move my database from Oracle to MySql, I am new to MySql.

 Is there any documentation listing the important issues involved
 in the migration?

 thanks,



 _
 MSN Photos is the easiest way to share and print your photos:
 http://photos.msn.com/support/worldwide.aspx


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

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

2002-09-19 Thread Victoria Reznichenko


Stefan,
Thursday, September 19, 2002, 9:45:52 AM, you wrote:

SF I want to change the varibale max_connections from 100 to 250. how can
SF I do that? I use MySQL 3.23.52 under Windows XP professional
SF Is the place I take the set-variable = max_connections=300 wrong?
 
SF I have the fallowing my.ini:
 
[skip]

SF [isamchk]
SF set-variable = key_buffer=128M
SF set-variable = sort_buffer=128M
SF set-variable = read_buffer=2M
SF set-variable = write_buffer=2M
SF set-variable= max_connections=300
 
[skip]

You should put set-variable = max_connections = 300 in the [mysqld]
section of my.ini instead of [isamchk]


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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

mysql@lists.mysql.com

2002-09-19 Thread


×ð¾´µÄmysql:
ÄúºÃ£¡
´Å¿¨¡¢ÌõÂëÉè±¸Ö®¼Ò--º¼ÖÝÕýÔµç×Ó www.zymc.com
»¶ÓÄúµÄÝ°ÁÙÖ¸µ¼£¡
º¼ÖÝÕýÔµç×ÓÓÐÏÞ¹«Ë¾ÊÇÒ»¼Ò×¨ÒµÖÂÁ¦ÓÚÐÅÏ¢×Ô¶¯Ê¶±ðµÄ¸ß¿Æ
¼¼ÆóÒµ¡¢×Ô¶¯Ê¶±ðÉè±¸µÄ×¨Òµ¿ª·¢ÉÌºÍOEMÖÆÔìÉÌ¡£ÕýÔªÅÆZYÏµÁÐ
´Å¿¨¶ÁÐ´Æ÷¡¢´Å¿¨ÔÄ¶ÁÆ÷¡¢ÌõÂëË¢¿¨Æ÷ºÍÃÜÂë¼üÅÌµÈÉè±¸£¬ÊÇÓÉ±¾
¹«Ë¾×ÔÐÐÑÐÖÆ¡¢¿ª·¢ºÍÉú²ú£¬²¢ÔÚÈ«¹ú¶à¼ÒÒøÐÐÉè±¸Ñ¡ÐÍÖÐÈëãÇ¡£
¹«Ë¾»¹´úÀí¾Ïú½ø¿ÚÖøÃûÆ·ÅÆµÄCCDÌõÂëÉ¨ÃèÆ÷¡¢¼¤¹âÌõÂëÉ¨
ÃèÆ÷¡¢ÌõÂëÊý¾Ý²É¼¯Æ÷¡¢ÌõÂë±êÇ©´òÓ¡»úµÈ£¬ÖÆ×÷Éè¼ÆÌõÂë±êÇ©¡¢
´Å¿¨¡¢IC¿¨£¬³Ð½Ó¸ÐÓ¦IC¿¨¿¼ÇÚ¡¢Ïû·Ñ¡¢ÃÅ½ûµÈÏµÍ³¹¤³Ì£¬Ñ¡ÔñÕý
Ôª²úÆ·£¬¾ÍÊÇÑ¡Ôñ¸üºÃµÄÆ·ÖÊºÍ·þÎñ£¡

ÁªÏµ·½Ê½£ºµç»°£º0571-85803525  85803521  85965139
  ´«Õæ£º0571-85803521

µç×ÓÓÊ¼þ£º [EMAIL PROTECTED]  [EMAIL PROTECTED]

µØÖ·£ºº¼ÖÝ³¯êÍÂ·182ºÅ¹ú¶¼·¢Õ¹´óÏÃ1ºÅÂ¥19²ãI×ù
ÓÊ±à£º310014


ÖÂ
Àñ£¡

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

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: Aliasing all fields

2002-09-19 Thread xuefer tinys

he may want SELECT table1.* prefix t1,table2.* prefix t2
which not seems to be supported.

instead of select table1.c1 as t1c1,table1.c2 as t1c2,
table2.c1 as t2c2..

From: z [EMAIL PROTECTED]
To: [EMAIL PROTECTED],   [EMAIL PROTECTED]
Subject: Re: Aliasing all fields
Date: Wed, 18 Sep 2002 19:51:16 -0700

On Wed, 18 Sep 2002 22:45:29 -0400, Rob Hutton wrote:
 Is there a way to get MYSQL to alias all fields in a select even if
 there is
 no naming conflict?  For instance, if I do a:

 select * from table1, table2 where table1.t1c1 = table2.t2c2

 then I want

would select table1.*,table2.* from

do that?

-z

--
z, [EMAIL PROTECTED] on 09/18/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

_
ÏíÓÃÊÀ½çÉÏ×î´óµÄµç×ÓÓÊ¼þÏµÍ³¡ª MSN Hotmail¡£http://www.hotmail.com/cn

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

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 searching - getting list of stop words?

2002-09-19 Thread Egor Egorov


Tim,
Thursday, September 19, 2002, 1:09:42 PM, you wrote:

TF I'm implementing a search feature on one of my sites and I would like
TF to have a Google-style X is a very common word and was not included
TF in your search for stop words.  I believe the stop words in fulltext
TF searching are dictated at compile time, so is there any way I can get
TF a list of current stop words from MySQL?

Check /myisam/ft_static.c from the source distribution.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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

sql , myisampack

2002-09-19 Thread Franz, Fa. PostDirekt MA


Hi,

after being mailed from a spam filter (and i still don't know why) ,
i am sorry , if my question my appear a second time.
Myisampack  crashes with 'segmentation fault' anytime i try to use it.
MySQL-Version is 2.23-41-log.
Linux-kernel is 2.4.10-4GB.
Everything installed from SUSE 7.3-distribution.
The databases are on Reiser-FS.
The system on ext2.

Anyone with a clue?

greetings
Klaus

Topaktuelle Consumer-Adressen anmieten www.consumeradressen.de


Diese Mail ist von:
Deutsche Post Direkt GmbH
Beleglese Center Mannheim

Klaus Franz 
Manager Abgleichsysteme 

Willy-Brandt-Platz 13   Tel. 06 21.129 56 436
68161 Mannheim  


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

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: Marketing materials ??

2002-09-19 Thread Brent Baisley


There was a comparison run on eweek.com a few months ago that tested the 
top databases, including MySQL, using a JDBC interface. Oracle came on 
top, as you would expect, and it should for the money. MySQL was second, 
MSSQL was dead last. All were professionally tuned as I recall. 
However, MSSQL was  the fastest by quite a margin if you dropped the 
JDBC connector and used all Microsoft technologies, front, middle and 
back ends. Not a setup I would like, but some might find it comforting.
I think they had all databases running under Windows. You would probably 
get far better performance running the other databases under Unix, which 
is a nice option to have.

On Thursday, September 19, 2002, at 07:50 AM, John Griffin wrote:

 The reason I brought Oracle up in the first place is because a properly 
 tuned Oracle database will outperform everybody in high load conditions.
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search  Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577


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

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: BUG in InnoDB tables

2002-09-19 Thread Victoria Reznichenko


deep,
Thursday, September 19, 2002, 2:28:07 PM, you wrote:

dk I am using MySQL 4.0.3 and Innodb tables for my
dk application,  I have created a unique index on
dk multiple column but its not working, here is sql
dk script to generate an bug


dk CREATE TABLE TESTING
dk (
dk ID INT AUTO_INCREMENT NOT NULL PRIMARY KEY ,
dk FLD1 VARCHAR(100) NOT NULL ,
dk FLD2 VARCHAR(15) NOT NULL,
dk FLD3 INT NOT NULL ,
dk FLD4 INT NOT NULL ,
dk FLD5 INT NULL
dk )TYPE=InnoDB;

dk CREATE UNIQUE INDEX IX_FLD12345_TESTING ON TESTING
dk (FLD1,FLD2,FLD3,FLD4,FLD5);

dk INSERT INTO TESTING (FLD1,FLD2,FLD3,FLD4,FLD5)
dk VALUES(A,B,1,2,NULL), (A,B,1,2,NULL);

dk Above INSERT statment tries to insert duplicate
dk records and though UNIQUE INDEX is created it allows
dk it. 
dk Problem is with NULL value, if any of the index field
dk contains NULL than only this bug is generated.

dk Is it BUG or Behaviour?

It's not a bug, it's a behaviour feature. UNIQUE can has multiple NULL values.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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: Changing datatypes

2002-09-19 Thread Egor Egorov


Mark,
Thursday, September 19, 2002, 12:24:45 PM, you wrote:

MC Can I change the data type of a column in a table from varchar(10) to
MC smallint(5) unsigned zerofill. The column that is set to varchar(10) is
MC populated with values from a primary key column in another table that has a
MC datatype smallint(5) unsigned zerofill and I need to make them both the
MC same. I administer my MySQL database from the command line and just need to
MC know
MC the syntax for changing data types. Also, can I do this without affecting
MC the data that is currently in the varchar(10) column (this data has came
MC from a column of the data type that I wish to change to)?

Yes, you can do it with ALTER TABLE .. MODIFY .. . If varchar(10) column
contains allowable values for SMALLINT(5) UNSIGNED ZEROFILL, there
shoudn't be a problem:
 http://www.mysql.com/doc/en/ALTER_TABLE.html



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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: Re: count function issue

2002-09-19 Thread Egor Egorov


McIrvin,
Thursday, September 19, 2002, 2:41:35 AM, you wrote:

M No,, I dumped the table and put it on a different server and tried it there.

Could you send a dump of the table to test it?



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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: insert and deletind dublicating

2002-09-19 Thread Victoria Reznichenko


Savaidis,
Thursday, September 19, 2002, 12:06:47 PM, you wrote:

S I have to add  a  .sql  file from MySQL-Front

S (insert into mytable ('0','asdf',ecc))  

S that  containts  some dublicates in the unic key.

S How can I do this and later to delere the dublicate records?

S The unic key has 3 string fields segments.

You can't insert duplicates except NULL if columns are defined as
UNIQUE. If you'll try - you will get an error.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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

Fractions

2002-09-19 Thread William Martell


Hello.

Can anyone tell me whether we can represent fractions in MySQL 4.0.  I have
data representing different lengths of objects measured in inches.  Can I
load this data as is into a field in MySQL or do I have to convert it first
into an floating point interger or decimal value???

Thanks in advance.
William


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

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

2002-09-19 Thread Paul DuBois


At 20:47 -0500 9/18/02, William Martell wrote:
Hello.

Can anyone tell me whether we can represent fractions in MySQL 4.0.  I have
data representing different lengths of objects measured in inches.  Can I
load this data as is into a field in MySQL or do I have to convert it first
into an floating point interger or decimal value???

You could store them as strings, but you'd have to interpret them on
the client side, most likely.


Thanks in advance.
William


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

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

Fractions

2002-09-19 Thread William Martell


sql,query,database,odbc


Hello All,

Can anyone tell me whether I can represent fractions in MySQL 4.  I have
data representing different lengths of objects measured in inches.  Can I
load this data as is into a field in MySQL and still retain the same value
or do I have to convert it first to a float or decimal value??

What type of data type will the field be bigint, int, decimal???  The
measurements are small, for example 2 1/2 inches, 3 1/8 inches.

Thanks in advance


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

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

persistant db connections?

2002-09-19 Thread andy


Hi there,

I am tring to locate some errors which pop up once in a while.

Now I have tracked them done to a point where permanent db connections could
be involved. Every Page in my system where a db (mysql) is involved connects
to the db server. This seems to be the reason why in some cases the values
pulled out of the db re not pressent. I did outcomment the connect statement
and the db connection still works. But why??!!

What would be a propper way to deal with the connect statement. I know that
persistant connects are faster and my system supports them. But what is a
persistant connection anyway? Is is persistant when the user is browsing all
the sites in my sytem? And when do I have to build the connection?

Thanx for any help on that,

Andy

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: MySQL on Redhat 7.3

2002-09-19 Thread Danny Haworth


-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Peter Goggin wrote:
| I followed the advice given but get these errors:
| If I use rpm -Uvh MySQL-3-23-52-1.i386 I get;
| error failed dependencies


| MySQL-server conflicts with mysql-server-3.23.49-3
| followed by a list of dependencies on libmysqlclient.so.10
| If I use rpm -Uvh MySQL*.rpm I get:
| error failed dependencies
| MySQL-server conflicts with mysql-server-3.23.49-3
| MySQL-DBI-Perl-bin is needed by MySQL-bench-3.23.52-1
|
| Do I need to deinstall all of the old rpms first or is there some form of
| force command I should use?

Looks like you have a conflict between packages installed with your
distro and the official mysql packages.

Personally i would remove the origional packages first. Do an 'rpm -qa |
grep -i mysql' which should list all the currently installed packages.

remove these using rpm -e {package name} where {package name} is each
package listed from the 'rpm -qa...' that is equivalent to the packages
you want to install (e.g. mysql-server. for MySQL-x).

you should then be able to install the newer packages.

MySQL-bench is also saying it wants the mysql perl dbi module installed.
you may want to go find and install this.

as with any (re)installation i recommend you make a backup of your
database first (usually /var/lib/mysql) if you have important
information there.

HTH
danny

- --

Danny Haworth
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Ge2 System Administrator
Gas~Elec Safety Systems
Tel : 01895 422 997
Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED])
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.7 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE9iHM2UKf+497XC3QRAjHVAJ9KOxIJISpb2mBw2LyH1GkYxRTvUgCeI65B
bn5hA+o3PvQcW1/WVzLLMr4=
=omjO
-END PGP SIGNATURE-


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

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

Re: Fractions

2002-09-19 Thread David Patte


you could store them as 3 integers. The integral part, the numerator of 
the fraction and the denominator of the fraction - then interpret them 
at the client side.


William Martell wrote:
 sql,query,database,odbc
 
 
 Hello All,
 
 Can anyone tell me whether I can represent fractions in MySQL 4.  I have
 data representing different lengths of objects measured in inches.  Can I
 load this data as is into a field in MySQL and still retain the same value
 or do I have to convert it first to a float or decimal value??
 
 What type of data type will the field be bigint, int, decimal???  The
 measurements are small, for example 2 1/2 inches, 3 1/8 inches.
 
 Thanks in advance


-- 
David Patte
Relative Data, Inc.
--
MyStars! 2.7 Shareware for Stargazers
Website #1: http://www.relativedata.com/
Website #2: http://www.mystarslive.com/
24 Hr Bus. Phone/Fax: 1 (613) 728-4240


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

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 and deletind dublicating

2002-09-19 Thread Paul DuBois


At 12:06 +0300 9/19/02, Savaidis wrote:
Hello!

I have to add  a  .sql  file from MySQL-Front

(insert into mytable ('0','asdf',ecc)) 

that  containts  some dublicates in the unic key.

That sounds self-contradictory.


How can I do this and later to delere the dublicate records?

The unic key has 3 string fields segments.

You can either:

- Create the table, including the unique index, and then load it
   with either INSERT IGNORE or REPLACE
- Create the table, but do not place any index on it yet.  Then load
   then table.  Then add the index using ALTER IGNORE TABLE ... rather
   than ALTER TABLE ... to tell it to ignore (and delete) duplicate
   records when creating the index.


Thanks!

Makis


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

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: Server shutdown

2002-09-19 Thread Victoria Reznichenko


Shravan,
Wednesday, September 18, 2002, 10:17:29 PM, you wrote:

SD I am completely new to MySQL. I installed the source
SD version of MySQL on Solaris 2.8. I did
SD mysql_install_db. 

SD I started the server by saying 
SD bin/safe_mysqld --user=mysql . The server started
SD my creating mysql.sock file in the /tmp directory.
SD Now i 
SD want to stop the server. How should i do it?

SD I did bin/mysqladmin -u mysql shutdown
SD The error message that came up was:
SD **
SD /home/shravan/extra/mysql/bin/mysqladmin: shutdown
SD failed; error: 'Access denied for user: '@localhost'
SD (Using password: NO)'
SD **

SD I also tried bin/mysqladmin -u root shutdown and
SD also
SD bin/mysqladmin -u shravan shutdown. But i could not
SD get the server down.

Do users 'root' and 'shravan' have passwords? if so, you should use
   mysqladmin -u root -p shutdown


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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: Re: 4.6.3 Adding a New Character Set

2002-09-19 Thread Egor Egorov


bhushan,
Wednesday, September 18, 2002, 5:32:04 PM, you wrote:

b Can anybody tell me source for getting information on 
b 4.6.3 Adding a New Character Set in MySQL.

b I read the manual, it's not clear to me.
b The steps there does not give enough information to start.

Some info you can also find in the /sql/share/charsets/README file of
the source distribution.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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: Can't Connect From Script

2002-09-19 Thread Egor Egorov


Alex,
Wednesday, September 18, 2002, 9:25:33 PM, you wrote:

AK I've got a weird conundrum here that I'm hoping I can get some help on. I'm
AK attempting to install a chat board system called Ikonboard 
AK (www.ikonboard.com) with MySQL as the database; setup on it went smoothly 
AK until it tried to talk to the database. No matter what I do, I get: 

AK mySQL connection error: Access denied for user: 'alex@localhost' (Using 
AK password: YES)  

AK This is despite several things that would indicate I should have no trouble: 

AK 1. I can connect from a shell with the same username and password no 
AK problem.
AK 2. I've quadruple-checked the spelling of the username and password, so it's 
AK not a typo.
AK 3. I can connect to the database from a test script with the same username 
AK and password. 

AK The only reason I can think of that the installer program can't connect is 
AK because it's a web script (installer.cgi), and some sort of permissions 
AK might be wrong there. 

Alex, installer.cgi is located on the same host as host from you successfully
connected via test script and shell?



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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: /usr/local/mysql/libexec/mysqld doesn't exist in installation

2002-09-19 Thread Gerald Clark


chown -R  mysql.mysql  /usr/local/mysql

[EMAIL PROTECTED] wrote:

Trying to install 4.03 from the tarball...
Any idea whay I am doing wrong??
Thanks, S.Alexiou

Here is what I get
...linux:/usr/local/mysql # scripts/mysql_install_db
Installing all prepared tables
020918 21:55:07  ./bin/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-
files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root 
USER !
This is done with:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h linux password 'new-
password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL = 3.22.10 you 
should run
the ./bin/mysql_fix_privilege_tables. Otherwise you 
will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe 

You can test the MySQL daemon with the benchmarks in 
the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug 
script!

The latest information about MySQL is available on the 
web at
http://www.mysql.com
Support MySQL by buying support/licenses at 
https://order.mysql.com

linux:/usr/local/mysql # vi INSTALL-BINARY
linux:/usr/local/mysql #  bin/mysqld_safe --user=mysql 
[1] 13054
linux:/usr/local/mysql # The 
file /usr/local/mysql/libexec/mysqld doesn't exist or 
is not executable
Please do a cd to the mysql installation directory and 
restart
this script from there as follows:
./bin/mysqld_safe.

[1]+  Exit 1  bin/mysqld_safe --
user=mysql
linux:/usr/local/mysql # ls -
l /usr/local/mysql/libexec/*
ls: /usr/local/mysql/libexec/*: No such file or 
directory
linux:/usr/local/mysql # ls -l
total 4908
drwxr-xr-x   13 root mysql 542 Sep 18 
21:55 .
drwxr-xr-x   13 root root  387 Sep 11 
18:33 ..
-rw-r--r--1 root mysql   19106 Aug 24 17:34 
COPYING
-rw-r--r--1 root mysql   28003 Aug 24 17:34 
COPYING.LIB
-rw-r--r--1 root mysql  122323 Aug 24 16:43 
ChangeLog
-rw-r--r--1 root mysql6808 Aug 24 17:34 
INSTALL-BINARY
-rw-r--r--1 root mysql1937 Aug 24 16:43 
README
drwxr-xr-x2 root mysql1231 Aug 24 17:39 
bin
-rwxr-xr-x1 root mysql 773 Aug 24 17:39 
configure
drwxr-x---2 mysqlmysql  35 Sep 12 17:00 
data
drwxr-xr-x2 root mysql1331 Aug 24 17:39 
include
drwxr-xr-x2 root mysql 208 Aug 24 17:39 
lib
drwxr-xr-x2 root mysql 378 Aug 24 17:39 
man
-rw-r--r--1 root mysql 2531460 Aug 24 17:32 
manual.html
-rw-r--r--1 root mysql 2185064 Aug 24 17:32 
manual.txt
-rw-r--r--1 root mysql   92248 Aug 24 17:32 
manual_toc.html
drwxr-xr-x6 root mysql 199 Aug 24 17:39 
mysql-test
drwxr-xr-x2 root mysql  67 Aug 24 17:39 
scripts
drwxr-xr-x3 root mysql  56 Aug 24 17:39 
share
drwxr-xr-x7 root mysql 869 Aug 24 17:39 
sql-bench
drwxr-xr-x2 root mysql 291 Aug 24 17:39 
support-files
drwxr-xr-x2 root mysql 560 Aug 24 17:39 
tests
-rw-r--r--1 root root11189 Sep 13 20:27 
typescript
linux:/usr/local/mysql # vi INSTALL-BINARY



linux:/usr/local/mysql # ./bin/mysqld_safe
The file /usr/local/mysql/libexec/mysqld doesn't exist 
or is not executable
Please do a cd to the mysql installation directory and 
restart
this script from there as follows:
./bin/mysqld_safe.




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

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: Aliasing all fields

2002-09-19 Thread Rob Hutton


Exactly

Rob Hutton
Web Safe
www.wsafe.com

**

Introducing Symantec Client Security - Integrated Anti-Virus,
Firewall, and Intrusion Detection for the Client.

Learn more:
http://enterprisesecurity.symantec.com/symes238.cfm?JID=2PID=11624271

View our Symantec Client Security Demo:
http://enterprisesecurity.symantec.com/symes238.cfm?JID=3PID=11624271

Download the Symantec Client Security Fact Sheet:
http://enterprisesecurity.symantec.com/symes238.cfm?JID=4PID=11624271

Download the Symantec Client Security Brochure:
http://enterprisesecurity.symantec.com/symes238.cfm?JID=5PID=11624271


 -Original Message-
 From: xuefer tinys [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, September 19, 2002 8:15 AM
 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Subject: Re: Aliasing all fields


 he may want SELECT table1.* prefix t1,table2.* prefix t2
 which not seems to be supported.

 instead of select table1.c1 as t1c1,table1.c2 as t1c2,
 table2.c1 as t2c2..


 From: z [EMAIL PROTECTED]
 To: [EMAIL PROTECTED],   [EMAIL PROTECTED]
 Subject: Re: Aliasing all fields
 Date: Wed, 18 Sep 2002 19:51:16 -0700
 
 On Wed, 18 Sep 2002 22:45:29 -0400, Rob Hutton wrote:
  Is there a way to get MYSQL to alias all fields in a select even if
  there is
  no naming conflict?  For instance, if I do a:
  
  select * from table1, table2 where table1.t1c1 = table2.t2c2
  
  then I want
  
 would select table1.*,table2.* from
 
 do that?
 
 -z
 
 --
 z, [EMAIL PROTECTED] on 09/18/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




 _
 ÏíÓÃÊÀ½çÉÏ×î´óµÄµç×ÓÓÊ¼þÏµÍ³¡ª MSN Hotmail¡£http://www.hotmail.com/cn


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

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

2002-09-19 Thread Thomas Spahni


On Wed, 18 Sep 2002, William Martell wrote:

 Can anyone tell me whether we can represent fractions in MySQL 4.0.  I have
 data representing different lengths of objects measured in inches.  Can I
 load this data as is into a field in MySQL or do I have to convert it first
 into an floating point interger or decimal value???

Did you consider storing a fraction using 2 integers? That's the way we
did it many years ago in Forth.

Thomas Spahni
-- 
sql, query


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

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

Re: /usr/local/mysql/libexec/mysqld doesn't exist in installation

2002-09-19 Thread moka



ÐáñÜèåóç Gerald Clark 
[EMAIL PROTECTED]:

 chown -R  mysql.mysql  /usr/local/mysql
Thanks, but apparently it still cannot find it:

linux:/usr/local/mysql # chown -R 
mysql.mysql /usr/local/mysql
linux:/usr/local/mysql # scripts/mysql_install_db
Installing all prepared tables
020919 22:44:19  ./bin/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-
files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root 
USER !
This is done with:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h linux password 'new-
password'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL = 3.22.10 you 
should run
the ./bin/mysql_fix_privilege_tables. Otherwise you 
will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe 

You can test the MySQL daemon with the benchmarks in 
the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug 
script!

The latest information about MySQL is available on the 
web at
http://www.mysql.com
Support MySQL by buying support/licenses at 
https://order.mysql.com

linux:/usr/local/mysql # ./bin/mysqld_safe 
[1] 29610
linux:/usr/local/mysql # The 
file /usr/local/mysql/libexec/mysqld doesn't exist or 
is not executable
Please do a cd to the mysql installation directory and 
restart
this script from there as follows:
./bin/mysqld_safe.

[1]+  Exit 1  ./bin/mysqld_safe
linux:/usr/local/mysql #
=

 
 [EMAIL PROTECTED] wrote:
 
 Trying to install 4.03 from the tarball...
 Any idea whay I am doing wrong??
 Thanks, S.Alexiou
 
 Here is what I get
 ...linux:/usr/local/mysql # scripts/mysql_install_db
 Installing all prepared tables
 020918 21:55:07  ./bin/mysqld: Shutdown Complete
 
 
 To start mysqld at boot time you have to copy 
support-
 files/mysql.server
 to the right place for your system
 
 PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root 
 USER !
 This is done with:
 ./bin/mysqladmin -u root password 'new-password'
 ./bin/mysqladmin -u root -h linux password 'new-
 password'
 See the manual for more instructions.
 
 NOTE:  If you are upgrading from a MySQL = 3.22.10 
you 
 should run
 the ./bin/mysql_fix_privilege_tables. Otherwise you 
 will not be
 able to use the new GRANT command!
 
 You can start the MySQL daemon with:
 cd . ; ./bin/mysqld_safe 
 
 You can test the MySQL daemon with the benchmarks in 
 the 'sql-bench' directory:
 cd sql-bench ; perl run-all-tests
 
 Please report any problems with the ./bin/mysqlbug 
 script!
 
 The latest information about MySQL is available on 
the 
 web at
 http://www.mysql.com
 Support MySQL by buying support/licenses at 
 https://order.mysql.com
 
 linux:/usr/local/mysql # vi INSTALL-BINARY
 linux:/usr/local/mysql #  bin/mysqld_safe --
user=mysql 
 [1] 13054
 linux:/usr/local/mysql # The 
 file /usr/local/mysql/libexec/mysqld doesn't exist 
or 
 is not executable
 Please do a cd to the mysql installation directory 
and 
 restart
 this script from there as follows:
 ./bin/mysqld_safe.
 
 [1]+  Exit 1  bin/mysqld_safe --
 user=mysql
 linux:/usr/local/mysql # ls -
 l /usr/local/mysql/libexec/*
 ls: /usr/local/mysql/libexec/*: No such file or 
 directory
 linux:/usr/local/mysql # ls -l
 total 4908
 drwxr-xr-x   13 root mysql 542 Sep 18 
 21:55 .
 drwxr-xr-x   13 root root  387 Sep 11 
 18:33 ..
 -rw-r--r--1 root mysql   19106 Aug 24 
17:34 
 COPYING
 -rw-r--r--1 root mysql   28003 Aug 24 
17:34 
 COPYING.LIB
 -rw-r--r--1 root mysql  122323 Aug 24 
16:43 
 ChangeLog
 -rw-r--r--1 root mysql6808 Aug 24 
17:34 
 INSTALL-BINARY
 -rw-r--r--1 root mysql1937 Aug 24 
16:43 
 README
 drwxr-xr-x2 root mysql1231 Aug 24 
17:39 
 bin
 -rwxr-xr-x1 root mysql 773 Aug 24 
17:39 
 configure
 drwxr-x---2 mysqlmysql  35 Sep 12 
17:00 
 data
 drwxr-xr-x2 root mysql1331 Aug 24 
17:39 
 include
 drwxr-xr-x2 root mysql 208 Aug 24 
17:39 
 lib
 drwxr-xr-x2 root mysql 378 Aug 24 
17:39 
 man
 -rw-r--r--1 root mysql 2531460 Aug 24 
17:32 
 manual.html
 -rw-r--r--1 root mysql 2185064 Aug 24 
17:32 
 manual.txt
 -rw-r--r--1 root mysql   92248 Aug 24 
17:32 
 manual_toc.html
 drwxr-xr-x6 root mysql 199 Aug 24 
17:39 
 mysql-test
 drwxr-xr-x2 root mysql  67 Aug 24 
17:39 
 scripts
 drwxr-xr-x3 root mysql  56 Aug 24 
17:39 
 share
 drwxr-xr-x7 root mysql 869 Aug 24 
17:39 
 sql-bench
 drwxr-xr-x2 root mysql 291 Aug 24 
17:39 
 support-files
 drwxr-xr-x2 root mysql 560 Aug 24 
17:39 
 tests
 -rw-r--r--1 root root11189 Sep 13 
20:27

Problem with last_insert_id()

2002-09-19 Thread Riaan Stander


Hi there

I've got the following problem scenario.
After inserting a new record into a table with a auto_inc
id, I need to get the new id back to insert into another table.

I use the following code to do this:

dim rs as recordset
dim newid as long

'this works
set rs = dataenvironment.connection.execute(  SELECT LAST_INSERT_ID() AS
newid  )
'this fails with message: [Microsoft][ODBC Driver Manager]Driver does not
support this parameter
newid = rs.fields(newid).value

When I insert into the other table with the following it works, but I need
to set it to another variable as the above example shows.
dataenvironment.connection.execute(  INSERT INTO othertable ( newid )
VALUES ( LAST_INSERT_ID() )  )

If you have any ideas what it might be it would help.

OS = Win2K + SP2
VB = 6
MySQL = 3.23.49
MyODBC = 2.50.39

Thanx
Riaan Stander



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

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 and deletind dublicating

2002-09-19 Thread Savaidis


I had already done the first (insert ignore into bla-bla ) solution with
personal e-mail from a friend. It works fast and fine. But the word ignore
leds me to missunderstanding: insert the row inspite of the unique key!
continue I think it is more meanfull as without this I get an error
message and the job stops at this row.
I think also  something like explain to insert should exist as to select
too (and to other commands too). We could locate missplaced quots , missing
fields ecc to run the whole .sql without actualy insert it to the table.
Also the error message couldn't be more precise? I mean to show where is the
problem on the insert line? Close too - shows always the begin of the line.

Something relative: If the table contains dublicate keys I haven't define
yet, I should export to .sql , empty the table, define the keys and import
again or is there a simpler way to delete dups at once?

Also is possible to MERGE identical tables with same unique keys and abord
dublicates ?
Or must use export-import trick again?
JOIN does this or is used only for SELECT?



thanks anyway...



Makis


-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 5:10 PM
To: Savaidis; mysql list
Subject: Re: insert and deletind dublicating


At 12:06 +0300 9/19/02, Savaidis wrote:
Hello!

I have to add  a  .sql  file from MySQL-Front

(insert into mytable ('0','asdf',ecc))

that  containts  some dublicates in the unic key.

That sounds self-contradictory.


How can I do this and later to delere the dublicate records?

The unic key has 3 string fields segments.

You can either:

- Create the table, including the unique index, and then load it
   with either INSERT IGNORE or REPLACE
- Create the table, but do not place any index on it yet.  Then load
   then table.  Then add the index using ALTER IGNORE TABLE ... rather
   than ALTER TABLE ... to tell it to ignore (and delete) duplicate
   records when creating the index.


Thanks!

Makis




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

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

2002-09-19 Thread Michael T. Babcock



[ this mysql spam filter sucks -- including a query in one's message 
isn't good enough ]

[EMAIL PROTECTED] wrote:

you could store them as 3 integers. The integral part, the numerator 
of the fraction and the denominator of the fraction - then interpret 
them at the client side.



This would even have the benefit of making the whole thing sortable 
(with approximations) ...

# val_i := integer; val_n := numerator; val_d := denominator
SELECT id FROM table WHERE val_i + (val_n / val_d)  10;

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



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

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

question about LEFT JOIN

2002-09-19 Thread Michael Boudreau


I can't tell if this is an SQL question or a MySQL question, so please 
forgive me if it's not germane. I'm wondering whether I'm expecting MySQL's 
LEFT JOIN to do something it can't, or if I just don't know my SQL well 
enough.

Given a database with these (partial) tables for manuscripts and editors:

Mss
---
   MsID int(11) unsigned
   EditorID int(11) unsigned
   MsStatusCode int(3) unsigned  # code 101 = active MS

People
--
   PeopleID int(11) unsigned
   Lastname varchar(40)
   Databaserolecode int(3) unsigned  # codes 1, 2, and 3 are for editors


Why wouldn't these two queries--to determine how many MSS are assigned to 
each Editor--return the same number of rows? Shouldn't the left join 
force the results to include *all* the editors, even if they don't have 
active MSS assigned to them?

(Using MySQL 3.23.37 on Solaris)

mysql select p.peopleid, p.lastname, count(m.msid) from People p left join 
Mss m on p.peopleid=m.editorid where p.databaserolecode in (1,2,3) group by 
p.peopleid;
+--++---+
| peopleid | lastname   | count(m.msid) |
+--++---+
|  166 | Barza  |  1656 |
|  1000106 | Blacklow   |   280 |
|  1000124 | Eliopoulos | 8 |
|  1000509 | Goldstein  |   997 |
|  1000513 | Gorbach|   601 |
|  1000524 | Graybill   |   307 |
|  1000735 | Klein  |   245 |
|  1001204 | Schooley   |20 |
|  1001345 | Tompkins   |   284 |
|  1003540 | Yoshikawa  |16 |
|  1003736 | Karchmer   |   260 |
|  1003984 | Meyer  |   343 |
|  1005336 | Wanke  |   305 |
|  1007198 | Sears  |   283 |
+--++---+
14 rows in set (1.47 sec)

mysql select p.peopleid, p.lastname, count(m.msid) from People p left join 
Mss m on p.peopleid=m.designatededitorid where p.databaserolecode in 
(1,2,3) and m.msstatuscode=101 group by p.peopleid;
+--+---+---+
| peopleid | lastname  | count(m.msid) |
+--+---+---+
|  1000106 | Blacklow  |26 |
|  1000509 | Goldstein | 3 |
|  1000513 | Gorbach   |23 |
|  1000524 | Graybill  |27 |
|  1000735 | Klein |19 |
|  1001204 | Schooley  |16 |
|  1001345 | Tompkins  |28 |
|  1003736 | Karchmer  |24 |
|  1003984 | Meyer |27 |
|  1005336 | Wanke |20 |
|  1007198 | Sears |18 |
+--+---+---+
11 rows in set (1.10 sec)



=
Michael Boudreau
Senior Electronic Publishing Developer
The University of Chicago Press
1427 E. 60th Street
Chicago, IL 60637-2954

phone: 773 753 3298
fax: 773 753 3383
= 


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

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

ANN: EMS MySQL Manager 1.91 released

2002-09-19 Thread Igor Brynskich


EMS HiTech company is announcing the next version (1.91) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.

You can download the latest version from
http://www.mysqlmanager.com/download.phtml


What's new in version 1.91?

1. A possibility to set keyword and function formats was added to the
Visual Query Builder. Now you can specify the case of keywords and
functions appearing in the script generated by the Query Builder. Those
options can be set on the Query Builder page of the Environment Options
dialog. (*)

2. The abilities of color customizing were extended in the Query
Builder. Now you can customize almost all the colors using in the Query
Builder diagram. (*)

3. Now you can use DEL key to delete table or link from the Query
Builder diagram. (*)

4. Fixed bug with join representing in a script if some joined field is
not checked in the diagram. (*)

5. Fixed bug in the Query Builder with parsing functions containing more
than one argument. (*)

6. Fixed bug with joining a table in the diagram with itself using
different aliases. (*)

7. Fixed bug with deleting joined table from the diagram. Access
Violation doesn't appear anymore. (*)

8. Fixed bug with Access Violation appearance while trying to rename a
table in the diagram using popup menu and there's no table selected. (*)

9. Some bugfixes in the Import Data wizard. (*)

10. Some small improvements and minor bugfixes.

(*) - Professional Edition only


What is the EMS MySQL Manager?

EMS MySQL Manager provides you powerful and effective tools for MySQL
Server administration and objects management. Its Graphical User
Interface (GUI) allows you to create/edit all MySQL database objects in
a most easy and simple way, run SQL scripts, manage users and
administrate user privileges, visually build SQL queries, extract or
print metadata, export/import data, view/edit BLOBs and many more
services that will make your work with the MySQL server as easy as it
can be...


We hope you'll enjoy working with our software.
Thank you for your attention.


Best regards,
EMS HiTech development team.
http://www.ems-hitech.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

Time caculations

2002-09-19 Thread smudholkar


Hello all, I am trying to write a delete statement in 
which a record is deleted if the time a user logged in 
is more than 15 minutes. As a result I would need to 
compare login times to the current time. Is there a way 
in MySQL to do this? Can the current time be calculated 
by SQL?

thanks,

Sunil

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

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: Japanese Characters in MySQL Win2k

2002-09-19 Thread Dawn Friedland


Thank you so much for your time  the sample code. It is the same as
what I have except for 

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html lang=ja

I added the above, but it does not fix the 'morphed' characters. It
helps immensely to know that you have the same environment  HTML/ASP as
I do. What does the Transitional//EN part in the above code do? 

I understand the DOS prompt shows only junk text, but the data is ok. I
wish I could see it directly in MySQL to eliminate the possibility that
MySQL is morphing the characters and that this is a bug (unlikely I
know). Dumping it to a web page is where the problem crops up. 

I guess now I have to figure out how to capture the data as it goes from
the web form through IIS to MyODBC to MySQLand then back out again
from MySQL to MyODBC to IIS. 



-Original Message-
From: Shashank Tripathi [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, September 18, 2002 6:25 AM
To: Dawn Friedland; [EMAIL PROTECTED]
Subject: RE: Japanese Characters in MySQL  Win2k


Hi,

I think Joel Rees wrote an interesting message as well. Hope you read
it. 

I run MySQL on Windows, SuSE 7.3 (Linux) and FreeBSD. Access it through
ASP/PHP/JSP/Perl DBI. There is no problem as far as I am concerned, it
works without a hitch. 

If your default locale is EN, then you may see junk text in your MS DOS
prompt but rest assured, it is most likely the correct data -- it just
appears that way to you. Try dumping the same data onto a web page with
the following META tags: 


%@ Language=VBScript %
% 

' Some OLEDB/ODBC code comes here 
' to initialize a variable with your JP text 

%

!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
html lang=ja
head
meta http-equiv=Content-Type content=text/html;
charset=Shift_JIS

/head

body
 % Response.Write (-YOUR JP TEXT COMES HERE-)
%
/body
/html



That should do it. 

Cheers,
Shanx


Shashank Tripathi 
www.shanx.com 




| -Original Message-
| From: Dawn Friedland [mailto:[EMAIL PROTECTED]] 
| Sent: Wednesday, September 18, 2002 7:46 AM
| To: Shashank Tripathi; [EMAIL PROTECTED]
| Subject: RE: Japanese Characters in MySQL  Win2k
| 
| 
| Thank you Thank you. 
| 
| Are you running MySQL on Windows and using ASP on the web 
| server?  
| 
| When I display the data after pulling it out, I use Shift_Jis. 
| 
| Yes, I mean the DOS prompt. My default language is 
| English. I fear changing my locale because I wouldn't be 
| able to change it back without a deepfry (I can't read 
| Japanese!)  
| 
| -Original Message-
| From: Shashank Tripathi [mailto:[EMAIL PROTECTED]] 
| Sent: Tuesday, September 17, 2002 3:36 PM
| To: Dawn Friedland; [EMAIL PROTECTED]
| Subject: RE: Japanese Characters in MySQL  Win2k
| 
| 
| Storing JP and EN data in the same table has worked for 
| me ever since I started using MySQL. Unlike Oracle, you 
| don't need any specific charset configs (I may stand 
| corrected). The idea is to use the correct character 
| encodings when you *display* the data after pulling it 
| out. In your case, I'd think Shift_JIS. 
| 
| You mention displaying on the command line...u mean DOS 
| prompt? If not, and if you meant some software, it shd be 
| easy. If you meant DOS prompt, I guess it depends on what 
| the default language in your windows box is. Do you have 
| Japan set as your default locale and as the default 
| language (Regional Options in Control Panel)?  If so, the 
| data shd display correctly without any additional effort. 
| 
| You can store EUC, Shift, ISO2022, and for that matter, 
| Chinese in the same table in diff rows as well. During 
| presentation time (display), just display using the 
| appropriate encoding and it shd be ok. 
| 
| Holler if you need more help.  
| 
| Cheers,
| Shashank
| 
| 
| 
| 
| 
| 


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

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

Getting timing from MySQL scripts

2002-09-19 Thread Jamie Beu


Whenever I run a command from the MySQL prompt, The command executes and
outputs the time to process the command.
However, if I put the same command in a script file, and run it in batch
mode from the shell prompt (or even use SOURCE from the mysql prompt),
I do not get the same timing info.

I want to run some benchmark tests, but I need precision greater than 1 sec
(the automatic timing output from MySQL is to the hundredth of a second,
which will suffice).

Please help. I am not using PHP at all - just sourcing MySQL query scripts.

Jamie Beu
Lockheed-Martin Information Systems
Software Engineer
CTIA
(407) 306-2484

The true soldier fights not because he hates what is in
 front of him, but because he loves what is behind him.
G. K. Chesterton - Illustrated London News, 1/14/11



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

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: Time caculations

2002-09-19 Thread Torbjørn Lindahl


now() will give current time and work in all contexts (unix timestamp or
datetime forma)

Try...

delete from table_name where now()-user_login_time  interval 15 minute

in this statment, user_login_time is the time the user logged in.

Regards
Torbjørn

On Thu, 19 Sep 2002 [EMAIL PROTECTED] wrote:

 Hello all, I am trying to write a delete statement in
 which a record is deleted if the time a user logged in
 is more than 15 minutes. As a result I would need to
 compare login times to the current time. Is there a way
 in MySQL to do this? Can the current time be calculated
 by SQL?

 thanks,

 Sunil

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

 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: /usr/local/mysql/libexec/mysqld doesn't exist in installation

2002-09-19 Thread Clayburn W. Juniel, III



On Thursday, September 19, 2002, at 07:44 AM, Clayburn W. Juniel, III 
wrote:


 On Thursday, September 19, 2002, at 03:19 AM, [EMAIL PROTECTED] wrote:

 linux:/usr/local/mysql # ./bin/mysqld_safe
 The file /usr/local/mysql/libexec/mysqld doesn't exist
 or is not executable
 Please do a cd to the mysql installation directory and
 restart
 this script from there as follows:
 ./bin/mysqld_safe.

 try sudo su linux:/user/local/mysql # .bin/mysqld_safe or just change 
 to root first.
--
Clayburn W. Juniel, III -- Effective Software Solutions
Phone: (602) 326-7707Mobile: (602)326-7707
Email: [EMAIL PROTECTED]
http://EffectiveSoftwareSolutions.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: Japanese Charset

2002-09-19 Thread Dawn Friedland


Thank you for your time and response. 

I have checked if the text is surviving the paste buffer - it is. (I did
a character by character comparison of the text one pasted in the web
form, but before hitting submit.)

The problem characters are the ASCII backslash and the ASCII tilde -
Good to know, I will eliminate those, although there are still many more
problem characters. 

How do I catch what's going into IIS and what's coming out? Also, what's
going into MyODBC and what's coming out of that? - I will post a
separate message to the list with this as the only question. 

I declare the doctype with meta http-equiv=Content-Type
content=text/html; charset=Shift_JIS. My code is exactly what
Shashank Tripathi posted in another response to my post - which he says
works perfectly for him on Windows/ASP/MySQL.

I am not displaying Japanese, Chinese, Korean, and English on the same
page: each page is intended for a single language audience. However,
both Shashank Tripathi and you suggested using UTF-8 anyway. I will
reserve this as a possible solution. Thank you for the idea. Good to
know I have options. I'm sure I'll be posting questions on that later if
it comes to it. 

What do you mean by Installed, but not selected.

So MySQL is using Latin...but with support for multi-byte charsets.
Thank you - I wasn't sure how to interpret the manual. Here is the
documentation from http://www.mysql.com/doc/en/Character_sets.html to
which I assume you are referring. All standard MySQL binaries are
compiled with --with-extra-charsets=complex. This will add code to all
standard programs to be able to handle latin1 and all multi-byte
character sets within the binary.

I'll be sending you and Shashank Tripathi links to the problem pages and
also the source content  shortly. Anyone else interested in this thread
should email me and I'll include them on the links. 

Again, thank you so much for your time and effort in responding to my
post. 
Dawn Friedland
[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: Getting timing from MySQL scripts

2002-09-19 Thread Paul DuBois


At 12:01 -0400 9/19/02, Jamie Beu wrote:
Whenever I run a command from the MySQL prompt, The command executes and
outputs the time to process the command.
However, if I put the same command in a script file, and run it in batch
mode from the shell prompt (or even use SOURCE from the mysql prompt),
I do not get the same timing info.

That's because when mysql runs in batch mode, it disables a lot of the
interactive mode output.  Run it with the -vvv option and you'll get
the information you're looking for.


I want to run some benchmark tests, but I need precision greater than 1 sec
(the automatic timing output from MySQL is to the hundredth of a second,
which will suffice).

Please help. I am not using PHP at all - just sourcing MySQL query scripts.

Jamie Beu
Lockheed-Martin Information Systems
Software Engineer
CTIA
(407) 306-2484

The true soldier fights not because he hates what is in
  front of him, but because he loves what is behind him.
G. K. Chesterton - Illustrated London News, 1/14/11



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

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

temporary tables

2002-09-19 Thread speters


Is there a way to see what temporary tables exist for the connection.

SHOW TABLES
doesnt list the temp tables for the connection. Is there some other command
i can issue?

thanks
sean peters
[EMAIL PROTECTED]


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

Auto Increment ID of Inserted Row

2002-09-19 Thread Davis, Tim


What is the SQL to get the created AutoInc ID from a row that I have just
inserted?

Tim Davis
Sunbelt Systems Concepts, Inc
[EMAIL PROTECTED]
Client/Server Database Programmer/Analyst


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

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

'print' or '\p' from mysql prompt

2002-09-19 Thread Robert Fox


Hello-

I've just started using MySQL so this is absolutely a 'newbie' question. 
I'm used to working with Oracle's SQL*Plus which is a very different tool. 
In SQL*Plus, I could type 'l' or 'list' at the SQL*Plus prompt and see a 
printout to STDOUT (the screen) of the current command in the buffer. 
Apparently, mysql duplicates this functionality via the 'print' and/or '\p' 
function. However, even if I have an SQL statement in memory, when I type 
in this command at the mysql prompt, it simply prints the following:

mysql print
--

--

This seems to indicate that nothing is in the buffer, however if I type 
'edit' the command appears from the buffer. Am I doing something wrong? I'm 
using MySQL v. 3.23.41 on Linux 7.1.

I have another related question. Are we always forced to execute an SQL 
command immediately after using an editor? In other words, when I type 
'edit', edit my command and then exit the editor, I'm released to the '-' 
prompt which forces me to either clear the buffer or execute the query, 
neither of which I would like to do immediately.

Any advice or help with these issues would be appreciated.

Thanks!

Rob

P.S. Another useful command which doesn't seem to be a part of the feature 
set for the mysql command line utility is a pause option. In Oracle 
SQL*Plus, I could set a pause feature on by entering the command 'set pause 
on', and I would be allowed to view a few returned records at a time. Is 
that option available in the mysql command line tool?


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

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 and deletind dublicating

2002-09-19 Thread Paul DuBois


At 17:54 +0300 9/19/02, Savaidis wrote:
I had already done the first (insert ignore into bla-bla ) solution with
personal e-mail from a friend. It works fast and fine. But the word ignore
leds me to missunderstanding: insert the row inspite of the unique key!

That's why it's a good idea to read the manual if you're not sure about
what something means.

continue I think it is more meanfull as without this I get an error
message and the job stops at this row.

A matter of taste, perhaps.  I don't find IGNORE confusing, and I don't
find CONTINUE meaningful, myself.

I think also  something like explain to insert should exist as to select
too (and to other commands too). We could locate missplaced quots , missing
fields ecc to run the whole .sql without actualy insert it to the table.
Also the error message couldn't be more precise? I mean to show where is the
problem on the insert line? Close too - shows always the begin of the line.

EXPLAIN cannot work in the way you describe, because it requires a
syntactically legal statement to begin with.  Syntax errors are the domain
of the parser.  If it says the error is close to the beginning of the line,
normally that's exactly what is wrong.


Something relative: If the table contains dublicate keys I haven't define
yet, I should export to .sql , empty the table, define the keys and import
again or is there a simpler way to delete dups at once?

Yes.  ALTER IGNORE TABLE, as stated below.


Also is possible to MERGE identical tables with same unique keys and abord
dublicates ?

If you mean that you want to set up a MERGE table, then you can use SELECT
DISTINCT when you run a query on the table if you want to remove duplicates
from the query result.

You might also try UNION, if you have MySQL 4.x.  UNION removes duplicates
by default, unless you say UNION ALL to get all rows including duplicates.

Or must use export-import trick again?
JOIN does this or is used only for SELECT?



thanks anyway...



Makis


-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 5:10 PM
To: Savaidis; mysql list
Subject: Re: insert and deletind dublicating


At 12:06 +0300 9/19/02, Savaidis wrote:
Hello!

I have to add  a  .sql  file from MySQL-Front

(insert into mytable ('0','asdf',ecc))

that  containts  some dublicates in the unic key.

That sounds self-contradictory.


How can I do this and later to delere the dublicate records?

The unic key has 3 string fields segments.

You can either:

- Create the table, including the unique index, and then load it
with either INSERT IGNORE or REPLACE
- Create the table, but do not place any index on it yet.  Then load
then table.  Then add the index using ALTER IGNORE TABLE ... rather
than ALTER TABLE ... to tell it to ignore (and delete) duplicate
records when creating the index.


Thanks!

  Makis


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

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: question about LEFT JOIN

2002-09-19 Thread Gerald Clark




Michael Boudreau wrote:

 I can't tell if this is an SQL question or a MySQL question, so please 
 forgive me if it's not germane. I'm wondering whether I'm expecting 
 MySQL's LEFT JOIN to do something it can't, or if I just don't know 
 my SQL well enough.

 Given a database with these (partial) tables for manuscripts and editors:

 Mss
 ---
   MsID int(11) unsigned
   EditorID int(11) unsigned
   MsStatusCode int(3) unsigned  # code 101 = active MS

 People
 --
   PeopleID int(11) unsigned
   Lastname varchar(40)
   Databaserolecode int(3) unsigned  # codes 1, 2, and 3 are for editors


 Why wouldn't these two queries--to determine how many MSS are assigned 
 to each Editor--return the same number of rows? Shouldn't the left 
 join force the results to include *all* the editors, even if they 
 don't have active MSS assigned to them?


Not when you have and m.msstatuscode=101
NULL does NOT equal 101.


 (Using MySQL 3.23.37 on Solaris)

 mysql select p.peopleid, p.lastname, count(m.msid) from People p left 
 join Mss m on p.peopleid=m.editorid where p.databaserolecode in 
 (1,2,3) group by p.peopleid;
 +--++---+
 | peopleid | lastname   | count(m.msid) |
 +--++---+
 |  166 | Barza  |  1656 |
 |  1000106 | Blacklow   |   280 |
 |  1000124 | Eliopoulos | 8 |
 |  1000509 | Goldstein  |   997 |
 |  1000513 | Gorbach|   601 |
 |  1000524 | Graybill   |   307 |
 |  1000735 | Klein  |   245 |
 |  1001204 | Schooley   |20 |
 |  1001345 | Tompkins   |   284 |
 |  1003540 | Yoshikawa  |16 |
 |  1003736 | Karchmer   |   260 |
 |  1003984 | Meyer  |   343 |
 |  1005336 | Wanke  |   305 |
 |  1007198 | Sears  |   283 |
 +--++---+
 14 rows in set (1.47 sec)

 mysql select p.peopleid, p.lastname, count(m.msid) from People p left 
 join Mss m on p.peopleid=m.designatededitorid where p.databaserolecode 
 in (1,2,3) and m.msstatuscode=101 group by p.peopleid;
 +--+---+---+
 | peopleid | lastname  | count(m.msid) |
 +--+---+---+
 |  1000106 | Blacklow  |26 |
 |  1000509 | Goldstein | 3 |
 |  1000513 | Gorbach   |23 |
 |  1000524 | Graybill  |27 |
 |  1000735 | Klein |19 |
 |  1001204 | Schooley  |16 |
 |  1001345 | Tompkins  |28 |
 |  1003736 | Karchmer  |24 |
 |  1003984 | Meyer |27 |
 |  1005336 | Wanke |20 |
 |  1007198 | Sears |18 |
 +--+---+---+
 11 rows in set (1.10 sec)



 =
 Michael Boudreau
 Senior Electronic Publishing Developer
 The University of Chicago Press
 1427 E. 60th Street
 Chicago, IL 60637-2954

 phone: 773 753 3298
 fax: 773 753 3383
 =

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

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





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

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

Re: re: Server shutdown

2002-09-19 Thread Victoria Reznichenko


Hello Shravan,
Thursday, September 19, 2002, 5:45:59 PM, you wrote:

SD I am able to stop the server when i specify the
SD password for the user root. 

SD But if the user shravan (who does not have a
SD password) who tries to stop the server started by
SD himself, then it fails.

User shravan must have Shutdown_priv:
 http://www.mysql.com/doc/en/Privileges_provided.html

SD Thanks,
SD SKD
SD --- Victoria Reznichenko
SD [EMAIL PROTECTED] wrote:
 Shravan,
 Wednesday, September 18, 2002, 10:17:29 PM, you
 wrote:
 
 SD I am completely new to MySQL. I installed the
 source
 SD version of MySQL on Solaris 2.8. I did
 SD mysql_install_db. 
 
 SD I started the server by saying 
 SD bin/safe_mysqld --user=mysql . The server
 started
 SD my creating mysql.sock file in the /tmp
 directory.
 SD Now i 
 SD want to stop the server. How should i do it?
 
 SD I did bin/mysqladmin -u mysql shutdown
 SD The error message that came up was:
 SD
 **
 SD /home/shravan/extra/mysql/bin/mysqladmin:
 shutdown
 SD failed; error: 'Access denied for user:
 '@localhost'
 SD (Using password: NO)'
 SD
 **
 
 SD I also tried bin/mysqladmin -u root shutdown
 and
 SD also
 SD bin/mysqladmin -u shravan shutdown. But i
 could not
 SD get the server down.
 
 Do users 'root' and 'shravan' have passwords? if so,
 you should use
mysqladmin -u root -p shutdown


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
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: Auto Increment ID of Inserted Row

2002-09-19 Thread Paul DuBois


At 12:55 -0400 9/19/02, Davis, Tim wrote:
What is the SQL to get the created AutoInc ID from a row that I have just
inserted?

SELECT LAST_INSERT_ID();




Seems like there's an echo in here...this question has been asked about
4 times in the last couple of days. :-)


Tim Davis
Sunbelt Systems Concepts, Inc
[EMAIL PROTECTED]
Client/Server Database Programmer/Analyst


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

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: 'print' or '\p' from mysql prompt

2002-09-19 Thread Paul DuBois


At 11:58 -0500 9/19/02, Robert Fox wrote:
Hello-

I've just started using MySQL so this is absolutely a 'newbie' 
question. I'm used to working with Oracle's SQL*Plus which is a very 
different tool. In SQL*Plus, I could type 'l' or 'list' at the 
SQL*Plus prompt and see a printout to STDOUT (the screen) of the 
current command in the buffer. Apparently, mysql duplicates this 
functionality via the 'print' and/or '\p' function. However, even if 
I have an SQL statement in memory, when I type in this command at 
the mysql prompt, it simply prints the following:

mysql print
--

--

Yeah, seems like a problem.  Use \p instead.


This seems to indicate that nothing is in the buffer, however if I 
type 'edit' the command appears from the buffer. Am I doing 
something wrong? I'm using MySQL v. 3.23.41 on Linux 7.1.

I have another related question. Are we always forced to execute an 
SQL command immediately after using an editor? In other words, when 
I type 'edit', edit my command and then exit the editor, I'm 
released to the '-' prompt which forces me to either clear the 
buffer or execute the query, neither of which I would like to do 
immediately.

What would you like to do instead.


Any advice or help with these issues would be appreciated.

Thanks!

Rob

P.S. Another useful command which doesn't seem to be a part of the 
feature set for the mysql command line utility is a pause option. In 
Oracle SQL*Plus, I could set a pause feature on by entering the 
command 'set pause on', and I would be allowed to view a few 
returned records at a time. Is that option available in the mysql 
command line tool?

Probably not quite the same thing, but you can use the --pager option
when you invoke mysql to send the output through a paging program like
more.  Or use the \P and \n commands in mysql to turn paging on/off.
UNIX only, doesn't work on Windows.


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

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: Auto Increment ID of Inserted Row

2002-09-19 Thread Steven Kreuzer


SELECT MAX(id_field) FROM table

SK

On Thursday, September 19, 2002, at 12:55 PM, Davis, Tim wrote:

 What is the SQL to get the created AutoInc ID from a row that I have 
 just
 inserted?

 Tim Davis
 Sunbelt Systems Concepts, Inc
 [EMAIL PROTECTED]
 Client/Server Database Programmer/Analyst


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

 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

Connecting to remote database using MyODBC

2002-09-19 Thread Adam Witney



Hi,

Have been trying to connect to a remote MySQL server from Matlab through an
ODBC connection, however the error is receive is

[TCX][MyODBC]Can't connect to MySQL server on
'server name' (10060)

I have searched the docs and archives and google... But can't see any answer
to what this error means.

Any help would be greatly appreciated

Thanks

adam


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.


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

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 from Different txt files.

2002-09-19 Thread William Martell


Hello All,

How do I load data from different text files.  IE.  Suppose I have a table
set up and I have 3 text files that have the data I want to load into the
table.  How do I tell MySQL to load this data from 3 different text files?
How much control do I have with this option???

Thanks in Advance.
William


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

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: Auto Increment ID of Inserted Row

2002-09-19 Thread Paul DuBois


At 13:23 -0400 9/19/02, Steven Kreuzer wrote:
SELECT MAX(id_field) FROM table

That won't give you the correct answer if some other client gets in
there an inserts a row before you have a change to get the MAX()
value.  LAST_INSERT_ID() is designed for this; it's not affected
by whatever other clients are doing.

SK

On Thursday, September 19, 2002, at 12:55 PM, Davis, Tim wrote:

What is the SQL to get the created AutoInc ID from a row that I have just
inserted?

Tim Davis
Sunbelt Systems Concepts, Inc
[EMAIL PROTECTED]
Client/Server Database Programmer/Analyst


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

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: Auto Increment ID of Inserted Row

2002-09-19 Thread Rodney Broom


From: Steven Kreuzer [EMAIL PROTECTED]
 SELECT MAX(id_field) FROM table

 On Thursday, September 19, 2002, at 12:55 PM, Davis, Tim wrote:
  What is the SQL to get the created AutoInc ID from a row that I
  have just inserted?

More formally, you can do this:

  SELECT LAST_INSERT_ID();


---
Rodney Broom
President, R.Broom Consulting
http://www.rbroom.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: Auto Increment ID of Inserted Row

2002-09-19 Thread Tam, Michael


I believe this approach work in a single connection environment and it has a
potential problem when it is running in a concurrent system.
  
What happens if there is another insert occurred through another connection
just before this statement being executed??
The result of this statement would not be id you are expecting.

Regards,
Michael

-Original Message-
From: Steven Kreuzer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 10:24 AM
To: Davis, Tim
Cc: Mysql (E-mail)
Subject: Re: Auto Increment ID of Inserted Row


SELECT MAX(id_field) FROM table

SK

On Thursday, September 19, 2002, at 12:55 PM, Davis, Tim wrote:

 What is the SQL to get the created AutoInc ID from a row that I have 
 just
 inserted?

 Tim Davis
 Sunbelt Systems Concepts, Inc
 [EMAIL PROTECTED]
 Client/Server Database Programmer/Analyst


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

 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: BUG in InnoDB tables

2002-09-19 Thread Paul DuBois


At 16:00 +0300 9/19/02, Victoria Reznichenko wrote:
deep,
Thursday, September 19, 2002, 2:28:07 PM, you wrote:

dk I am using MySQL 4.0.3 and Innodb tables for my
dk application,  I have created a unique index on
dk multiple column but its not working, here is sql
dk script to generate an bug


dk CREATE TABLE TESTING
dk (
dk ID INT AUTO_INCREMENT NOT NULL PRIMARY KEY ,
dk FLD1 VARCHAR(100) NOT NULL ,
dk FLD2 VARCHAR(15) NOT NULL,
dk FLD3 INT NOT NULL ,
dk FLD4 INT NOT NULL ,
dk FLD5 INT NULL
dk )TYPE=InnoDB;

dk CREATE UNIQUE INDEX IX_FLD12345_TESTING ON TESTING
dk (FLD1,FLD2,FLD3,FLD4,FLD5);

dk INSERT INTO TESTING (FLD1,FLD2,FLD3,FLD4,FLD5)
dk VALUES(A,B,1,2,NULL), (A,B,1,2,NULL);

dk Above INSERT statment tries to insert duplicate
dk records and though UNIQUE INDEX is created it allows
dk it.
dk Problem is with NULL value, if any of the index field
dk contains NULL than only this bug is generated.

dk Is it BUG or Behaviour?

It's not a bug, it's a behaviour feature. UNIQUE can has multiple NULL values.

True for MyISAM and InnoDB tables.  If it would be acceptable to use a
BDB table instead, BDB tables do not allow multiple NULL values in UNIQUE
indexes.


(and what about ISAM tables? Question doesn't apply: indexed columns
must be NOT NULL for ISAM.)

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

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: Dynamic Links

2002-09-19 Thread William Martell

- Original Message -
From: [EMAIL PROTECTED]
To: William Martell [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 2:33 PM
Subject: Re: Dynamic Links

 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:

 sql,query

 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:

 Hello All,

 How can I create dynamic links between fields in different tables.  IE.  I
 load data for the price of an item into Table_1.  I want the price of the
 same item in Table_2 to equal the price in Table_1.

 Thanks for your assistance.
 William

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

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

Replace query question

2002-09-19 Thread speters


If i use a replace query, and there isn't an error, then either
a new row was inserted, or an existing row was updated.

The primary key in the table i'm replacing to is defined as
mprid int not null auto_increment primary key

whether an insert or update actually occurs, i want to get the value of 
mprid that was affected.

if it's a new row, i assume i can use select last_insert_id()
but if its an update, will that work?

thanks,
sean peters
[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: Auto Increment ID of Inserted Row

2002-09-19 Thread Dan Nelson


In the last episode (Sep 19), Steven Kreuzer said:
 What is the SQL to get the created AutoInc ID from a row that I have
 just inserted?

 SELECT MAX(id_field) FROM table

Nope.  If someone else inserted a record between the time you inserted
yours and the time you run that select, your answer will be wrong. 
Use LAST_INSERT_ID(), or whatever construct your language provides for
retrieving it without doing another query.

-- 
Dan Nelson
[EMAIL PROTECTED]

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

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

Problem sorting through Email ...

2002-09-19 Thread Tom Adams


I have message rules to move Emails to the proper lists.  If you would send
this to the list(s), with CC to person I would see it.  I get hundreds of
Email a day and have to organize them to stay sane.

As it is now, I just see names I don't know and delete.

Tom


- Original Message -
From: David Patte [EMAIL PROTECTED]
To: William Martell [EMAIL PROTECTED]
Cc: MySQL Main List [EMAIL PROTECTED]; win32 MySQL List
[EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 9:03 AM
Subject: Re: Fractions


 you could store them as 3 integers. The integral part, the numerator of
 the fraction and the denominator of the fraction - then interpret them
 at the client side.


 William Martell wrote:
  sql,query,database,odbc
 
 
  Hello All,
 
  Can anyone tell me whether I can represent fractions in MySQL 4.  I have
  data representing different lengths of objects measured in inches.  Can
I
  load this data as is into a field in MySQL and still retain the same
value
  or do I have to convert it first to a float or decimal value??
 
  What type of data type will the field be bigint, int, decimal???  The
  measurements are small, for example 2 1/2 inches, 3 1/8 inches.
 
  Thanks in advance


 --
 David Patte
 Relative Data, Inc.
 --
 MyStars! 2.7 Shareware for Stargazers
 Website #1: http://www.relativedata.com/
 Website #2: http://www.mystarslive.com/
 24 Hr Bus. Phone/Fax: 1 (613) 728-4240


 -
 Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before
 posting. To request this thread, e-mail [EMAIL PROTECTED]

 To unsubscribe, send a message to the address shown in the
 List-Unsubscribe header of this message. If you cannot see it,
 e-mail [EMAIL PROTECTED] instead.



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

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 and deletind dublicating

2002-09-19 Thread Savaidis

-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 7:59 PM
To: Savaidis; mysql list
Subject: RE: insert and deletind dublicating

At 17:54 +0300 9/19/02, Savaidis wrote:
I had already done the first (insert ignore into bla-bla ) solution with
personal e-mail from a friend. It works fast and fine. But the word
ignore
leds me to missunderstanding: insert the row inspite of the unique key!

That's why it's a good idea to read the manual if you're not sure about
what something means.

I have read the manual 3-4 times and I'm surprised everytime- I work in
MySQL more than a year now, so simple things in front of my eyes, I can't
see them.

continue I think it is more meanfull as without this I get an error
message and the job stops at this row.

A matter of taste, perhaps.  I don't find IGNORE confusing, and I don't
find CONTINUE meaningful, myself.

On that, I have to agree :)

I think also  something like explain to insert should exist as to select
too (and to other commands too). We could locate missplaced quots , missing
fields ecc to run the whole .sql without actualy insert it to the table.
Also the error message couldn't be more precise? I mean to show where is
the
problem on the insert line? Close too - shows always the begin of the
line.

EXPLAIN cannot work in the way you describe, because it requires a
syntactically legal statement to begin with.  Syntax errors are the domain
of the parser.  If it says the error is close to the beginning of the line,
normally that's exactly what is wrong.

I believe parser works before every command. It works before searching, it
founds the error possition anyway,  so it wouldn't slowdown the execution of
searching proccess ecc.
I see always pointing at the beggining of the line. I don't know if this is
becouse of MySQL itself (doesn't return the exact possition) or MySQL-Front
doesn't make good implementation of returning error.
As for EXPLAIN, if could be also easily add too to every command with no
extra cost as is an external (seperated) command. In addition to some
hundreds checks of rights, locks, keys ecc one more if it is real or
EXPLAIN.

Makis

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

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

Slow results return through ODBC

2002-09-19 Thread Mike Hillyer


Hi All;

I have been writing a VB app that has been very quick and responsive across
the DSL modem connection I have to the server. Yesterday I populated the
tables with about 100,000 rows, and then I started having a problem: When I
run a query through a SSH session to the server, the query is reported at
0.02 seconds, and returns 5 rows very quickly (the appropriate index is in
place), but when I run the query through ODBC on my VB client, it takes 10
seconds. Any ideas on what is causeing the discrepancy?

Mike


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

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

back up automation...

2002-09-19 Thread antispam


i have mysql in redhat and i would liket o automate the backup process..

i would like to use mysqldump without password.. any idea how to do this..

thanks for the help..

-Antz
---
This email was brought to you by Foothill.net
http://webmail.foothill.net/user/login.cgi

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

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 2.23 DELETE ORDER BY bug

2002-09-19 Thread Peter M. Flor


I have been beating my head against a wall to try and get this to work.
Apparently in version 2.22 a bug preventing ORDER BY in a SELECT statement
from working was fixed in 2.23. Well I think that this bug also exists in
2.23 when using ORDER BY in conjunction with a DELETE statement, and
possibly others.

My code yields an SQL syntax error near the order by statement:

DELETE FROM sessions WHERE userid=someuser ORDER BY sessionid DESC LIMIT
somenumber;

I'm using php, here is the actual code as it is written in my script:

mysql_query( DELETE * FROM sessions WHERE userid=$userid ORDER BY sessionid
DESC LIMIT $numrows );

During my research i found an example of code at
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DEL
ETE with an example of code that in function resembles my code almost
exactly. Here is the code from that page:

DELETE FROM somelog
WHERE user = 'jcole'
ORDER BY timestamp
LIMIT 1;

However this doesn't work either. There's absolutely nothing i've been able
to do. Please email me with any followups to this bug, and any action taken.
Thanks so much for your time.


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

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 needed with fixed size table database design!

2002-09-19 Thread Csaba Kiss


Hello guys,
  this is my first mail to the mailing last, since I am new to the mysql
world. I would like to create a cell-bank mysql database. We freeze
down cells in small tubes. These tubes are stored in boxes and the
boxes are in big freezers. Sometimes we freeze 10-20 new tubes with
new samples (i.e. 5 of each). When we pick them up we do it usually
one by one. Since the size of the boxes and the freezers are constant,
the tables that I should use should also be constant (right?). I am
not sure how I should design my database. That's why I would like to
ask for help.
 I thought of using the following tables:
Samples (contains the data about the samples)

Boxes   (I am not sure about this) It should contain how many rows and
columns are in the box?

Freezers (Freezers have racks that holds the boxes and these racks are
arranged in rows and columns again)I guess this table should contain
the number of racks, rows, and columns, location, temperature)

I am stuck somewhere here. I am not too sure how I should proceed.
Should I create a freezing table that contains Sample_id, Box_id,
Freezer_id...?
The database should automatically put the tubes in the boxes until
they are full and then move to another box by itself. If is thaw one
samples it should remove those samples from the box and mark it empty.

I am quite sure that this kind of database have been already created
652,342 times. Nevertheless, I would appreciate any type of help for a
newbie, with links or tutorials for these kind of problems.

Thanx

-- 
Best regards,

   Csaba Kiss
  [EMAIL PROTECTED]
 MTC Karolinska Institute
Stockholm, Sweden

tel:+4687286259
fax:+468330498
ICQ:7911383
_

This message was created using The Bat! v1.60q on Friday, September 20, 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: MySQL 2.23 DELETE ORDER BY bug

2002-09-19 Thread Mike Hillyer


While I have no solution for you, I am curious: why would you need to
specify the order rows are deleted in?

Mike


-Original Message-
From: Peter M. Flor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 4:03 PM
To: [EMAIL PROTECTED]
Subject: MySQL 2.23 DELETE ORDER BY bug


I have been beating my head against a wall to try and get this to work.
Apparently in version 2.22 a bug preventing ORDER BY in a SELECT statement
from working was fixed in 2.23. Well I think that this bug also exists in
2.23 when using ORDER BY in conjunction with a DELETE statement, and
possibly others.

My code yields an SQL syntax error near the order by statement:

DELETE FROM sessions WHERE userid=someuser ORDER BY sessionid DESC LIMIT
somenumber;

I'm using php, here is the actual code as it is written in my script:

mysql_query( DELETE * FROM sessions WHERE userid=$userid ORDER BY sessionid
DESC LIMIT $numrows );

During my research i found an example of code at
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DEL
ETE with an example of code that in function resembles my code almost
exactly. Here is the code from that page:

DELETE FROM somelog
WHERE user = 'jcole'
ORDER BY timestamp
LIMIT 1;

However this doesn't work either. There's absolutely nothing i've been able
to do. Please email me with any followups to this bug, and any action taken.
Thanks so much for your time.


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

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

Multi-row insert

2002-09-19 Thread Chris Tucker


Hi,

I'm having some trouble with a sizable (but certainly not huge)
multi-row insert statement.  I can successfully execute the query with
up to 7365 rows, but any more and it fails (ERROR 2006: MySQL server has
gone away).  More complete info:

Total working query size: 1047426 bytes
wait_timeout variable: 28800
Table type: MyISAM
Columns: 13, including: 4 VARCHAR, 7 INT (varying sizes), 1 TEXT, 1
DATETIME.

This fails through the mysql client copy/paste, mysql client using a
piped file (mysql filename), and through Perl DBI.  

Server uname -a:
Linux test-db 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown

Distro:
Red Hat Linux release 7.2 (Enigma)

MySQL version:
3.23.52-log

I'd be appreciative of any advice regarding limits that may exist on the
amount of data that can be run through a single multi-row insert.  The
easy fix for me right now is to split into multiple multi-row inserts
(splitting at 1000 rows/query seems to be working fine), but I'd rather
get the proper solution or file a bug if need be.

Cheers,
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

Help with selecting, grouping and distincting ... May need nested statement?

2002-09-19 Thread Ben Holness


Hi all,

I am writing a PHP web page that displays some statistics based on
information in a database.

The database has a table (stats) with three fields:

ID, Sender, Text, UserID, Timestamp

I have set it up so that I get basic statistics with the following query:

SELECT Text, Count(*) FROM stats WHERE UserID='1' GROUP BY Text

What I would also like to do is get the stats for unique Senders, such that
if there are multiple entries for a particular Sender, it is only counted
once and it is grouped under the first (chronologically) entry.

Example (fixed font):

IDSenderTextUserIDTimestamp
1 a One 1 2002091815
2 b One 1 20020918151000
3 c Two 1 20020918152000
4 d Two 1 20020918153000
5 a Two 1 20020918154000

This currently gives me the following output:

One, 2
Two, 3

What I would like is:

One, 2
Two, 2

i.e. data from sender 'a' is only counted once and is counted as One.

Can I do this with an SQL query, nested or otherwise, or do I need to go
through the rows one by one in the PHP code?

Many thanks,

Ben


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

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

Re: MySQL 2.23 DELETE ORDER BY bug

2002-09-19 Thread Arjen Lentz


Hi Peter,

On Fri, 2002-09-20 at 08:03, Peter M. Flor wrote:
 I have been beating my head against a wall to try and get this to work.
 Apparently in version 2.22 a bug preventing ORDER BY in a SELECT statement
 from working was fixed in 2.23. Well I think that this bug also exists in
 2.23 when using ORDER BY in conjunction with a DELETE statement, and
 possibly others.
 
 My code yields an SQL syntax error near the order by statement:
 
 DELETE FROM sessions WHERE userid=someuser ORDER BY sessionid DESC LIMIT
 somenumber;
 
 I'm using php, here is the actual code as it is written in my script:
 
 mysql_query( DELETE * FROM sessions WHERE userid=$userid ORDER BY sessionid
 DESC LIMIT $numrows );
 
 During my research i found an example of code at
 http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DEL
 ETE with an example of code that in function resembles my code almost
 exactly.

The same page contains a note that ORDER BY in DELETE is supported from
MySQL version 4.0. So if you grab a 4.0 from www.mysql.com, you will
find that your query will work just fine!


Regards,
Arjen.

-- 
MySQL Training, Support, Licenses @ https://order.mysql.com/?marl
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Technical Writer, Trainer
/_/  /_/\_, /___/\___\_\___/   Brisbane, QLD Australia
   ___/   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: Help needed with fixed size table database design!

2002-09-19 Thread Arjen Lentz


Hi,

On Fri, 2002-09-20 at 08:30, Csaba Kiss wrote:
   this is my first mail to the mailing last, since I am new to the mysql
 world. I would like to create a cell-bank mysql database. We freeze
 down cells in small tubes. These tubes are stored in boxes and the
 boxes are in big freezers. Sometimes we freeze 10-20 new tubes with
 new samples (i.e. 5 of each). When we pick them up we do it usually
 one by one. Since the size of the boxes and the freezers are constant,
 the tables that I should use should also be constant (right?). I am
 not sure how I should design my database. That's why I would like to
 ask for help.
  I thought of using the following tables:
 Samples (contains the data about the samples)
 
 Boxes   (I am not sure about this) It should contain how many rows and
 columns are in the box?
 
 Freezers (Freezers have racks that holds the boxes and these racks are
 arranged in rows and columns again)I guess this table should contain
 the number of racks, rows, and columns, location, temperature)
 
 I am stuck somewhere here. I am not too sure how I should proceed.
 Should I create a freezing table that contains Sample_id, Box_id,
 Freezer_id...?

Rule #1: a database is not a spreadsheet.
Particularly with a RELATIONAL database.
Also, you want to prevent duplicating information (in relational terms:
normalise).

You could create a freezer table, a box table and a sample table.

Each box (=row in box table) has a reference to the freezer_id, and each
sample has a reference to its box_id. So you build relations between the
tables.

If you need to store the location of a box within a freezer, you can add
its row/col coordinates as extra columns in the box table. That way each
box has its own coordinates with it as well as its freezer_id. Easy!

Temperature... per freezer or per indivual box? Put in the appropriate
table (i.e. freezer if per freezer. That way you only have to
store/update it in one place).


 The database should automatically put the tubes in the boxes until
 they are full and then move to another box by itself.

That is something for your application to do.
You can find out how many samples each indivual box has, so where to add
new samples, and you can also decide when to start a new box.


 If is thaw one samples it should remove those samples from the box
 and mark it empty.

In the above schema, you would simply delete the sample from the sample
table. In the end, a box would have no samples referring to it, which
implicitly makes it empty.


So, start thinking in relational terms. Your project actually makes this
quite easy because it itself already has clear relations (samples in a
box, boxes in a freezer, etc).
Good luck!

You may also wish to consider MySQL training, to quickly get to grips
with these concepts. See http://www.mysql.com/training/ for details on
currently scheduled training courses.


Regards,
Arjen.


-- 
MySQL Training, Support, Licenses @ https://order.mysql.com/?marl
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Technical Writer, Trainer
/_/  /_/\_, /___/\___\_\___/   Brisbane, QLD Australia
   ___/   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: ABUSE? , myisampack , sql , admin [T2002091901XL]

2002-09-19 Thread kayamboo

Me too received the same but dont know why

- Original Message -
From: Franz, Fa. PostDirekt MA [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 19, 2002 8:03 PM
Subject: WG: ABUSE? , myisampack , sql , admin [T2002091901XL]

-Ursprüngliche Nachricht-
Von: Franz, Fa. PostDirekt MA
Gesendet am: Donnerstag, 19. September 2002 13:00
An: '[EMAIL PROTECTED]'
Betreff: AW:ABUSE? , myisampack , sql , admin [T2002091901XL]

Hi there,

i received this message , after sending a request to mysql-mailing-list:

Thank you for bringing this matter to our attention.  We are sorry for
any inconvenience it has caused you.  Because we receive a large
number of complaints each day at [EMAIL PROTECTED],  regretfully, a
personalized response to each message is not possible.

Please be assured that Verizon investigates each reported occurrence
of unsolicited e-mail or spamming.  We maintain a zero-tolerance
policy in regard to spamming and will take the appropriate action as
permitted by Verizon's Acceptable Use Policy.  To view our policy,
please refer to one of the two following links:

Former Bell Atlantic users:
http://www.bellatlantic.net/help/faqs/#faqpolicies

Former GTE users:
http://www.gte.net/hotlinks/policies/agreement.html

To better understand the problems with unsolicited e-mail, we have
provided information about filtering Spam with your e-mail software,
answers to several frequently asked questions and links to some useful
online information about Spam at the following link:

http://www.gte.net/announcements/spam.html

You may also link directly to our page about unsolicited e-mail:

http://www.gte.net/contact/spam.html

If you are reporting an issue of hacking or other security issues not
related to e-mail abuse, please submit your report to [EMAIL PROTECTED]
for investigation.

Sincerely,
Verizon Internet Services
[EMAIL PROTECTED]

It wasn't my intention to abuse , offend or spam anyone or anything and
i think i didn't do something like that at all.
If i did , i am very sorry about it , but I'd like to know :
What went wrong?

mfg
Klaus

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

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 errors in newer PHP 4.2.3

2002-09-19 Thread Steven Roussey


Since updating to 4.2.3, we have been getting intermittent errors of
Commands out of sync. Anyone else see this?

Sincerely,
Steven Roussey
http://Network54.com/?pp=e 

php,sql,query


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

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

Re: MySQL errors in newer PHP 4.2.3

2002-09-19 Thread Jocelyn Fournier


Hi,

Same problem for me, although it was already here with 4.2.0 for me (well it
seems to be also a high QPS problem...). The problem seems to disappear with
an apache restart, but sometimes appear again randomly.

Regards,
  Jocelyn

- Original Message -
From: Steven Roussey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Mysql [EMAIL PROTECTED]
Sent: Friday, September 20, 2002 2:14 AM
Subject: MySQL errors in newer PHP 4.2.3


 Since updating to 4.2.3, we have been getting intermittent errors of
 Commands out of sync. Anyone else see this?

 Sincerely,
 Steven Roussey
 http://Network54.com/?pp=e

 php,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






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

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 Views

2002-09-19 Thread Art Fore


Since MySQL does not have views or queries that can be within the database,
is there a way to make tables which are subtables of the main table? For
example, I have an ID that goes from 0010-10010 to 7000-. I want a table
that will show only those items with LIKE '0080-%'. This table should be
updated automatically when the main table is updated. 

Art

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

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: WG: ABUSE? , myisampack , sql , admin [T2002091901XL]

2002-09-19 Thread Joel Rees


...
 i received this message , after sending a request to mysql-mailing-list:
 
 Thank you for bringing this matter to our attention.  We are sorry for
 any inconvenience it has caused you. 
...
 It wasn't my intention to abuse , offend or spam anyone or anything and
 i think i didn't do something like that at all.

You didn't. No need to worry. They were thanking you (us? the list?) for
reporting someone who was.

 If i did , i am very sorry about it , but I'd like to know :
 What went wrong?

Good question. I also received that response, but hadn't recalled
submitting any abuse reports to them in the past month, so I was
wondering what was going on, too. I think maybe the automatic machinery
they use to filter the abuse complaints thought someone's abuse report
was coming from the list for some reason.

(You should look at the headers you get from some people. It's easy to
understand how a machine could get confused.)

-- 
Joel Rees [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: WG: ABUSE? , myisampack , sql , admin [T2002091901XL]

2002-09-19 Thread Paul DuBois


At 10:07 +0900 9/20/02, Joel Rees wrote:
...
  i received this message , after sending a request to mysql-mailing-list:

  Thank you for bringing this matter to our attention.  We are sorry for
  any inconvenience it has caused you.
...
  It wasn't my intention to abuse , offend or spam anyone or anything and
  i think i didn't do something like that at all.

You didn't. No need to worry. They were thanking you (us? the list?) for
reporting someone who was.

  If i did , i am very sorry about it , but I'd like to know :
  What went wrong?

Good question. I also received that response, but hadn't recalled
submitting any abuse reports to them in the past month, so I was
wondering what was going on, too. I think maybe the automatic machinery
they use to filter the abuse complaints thought someone's abuse report
was coming from the list for some reason.

(You should look at the headers you get from some people. It's easy to
understand how a machine could get confused.)

[EMAIL PROTECTED] got subscribed to the mailing list.  It's been
taken care of, you shouldn't get any more of these.


--
Joel Rees [EMAIL PROTECTED]

mysql, sql, query

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

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

RE: WG: ABUSE? , myisampack , sql , admin [T2002091901XL]

2002-09-19 Thread Sqlcoders.com Programming Dept


It's also possible someone subscribed abuse@verizon to the mySQL mailing
list I think.

Perhaps someone has a grudge against verizon.



 -Original Message-
 From: Joel Rees [mailto:[EMAIL PROTECTED]]
 Sent: 19 September 2002 18:07
 To: Franz, Fa. PostDirekt MA
 Cc: [EMAIL PROTECTED]
 Subject: Re: WG: ABUSE? , myisampack , sql , admin [T2002091901XL]


 ...
  i received this message , after sending a request to mysql-mailing-list:
 
  Thank you for bringing this matter to our attention.  We are sorry for
  any inconvenience it has caused you.
 ...
  It wasn't my intention to abuse , offend or spam anyone or anything and
  i think i didn't do something like that at all.

 You didn't. No need to worry. They were thanking you (us? the list?) for
 reporting someone who was.

  If i did , i am very sorry about it , but I'd like to know :
  What went wrong?

 Good question. I also received that response, but hadn't recalled
 submitting any abuse reports to them in the past month, so I was
 wondering what was going on, too. I think maybe the automatic machinery
 they use to filter the abuse complaints thought someone's abuse report
 was coming from the list for some reason.

 (You should look at the headers you get from some people. It's easy to
 understand how a machine could get confused.)

 --
 Joel Rees [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

SELECT DISTINCT bug MySQL 4.0.3 MAX NT

2002-09-19 Thread Glenn Watson


Hi,

I was able to crash MySQL every time with the following -- it is 
incorrectly formatted I know and I should be using GROUP BY in this 
particular case

When I do the following query:
SELECT DISTINCT * FROM CUSTOMER INNER JOIN PRODUCT ON CUSTOMER.CUST_NO = 
PRODUCT.CUST_NO

Without the distinct there are no issues

SHOW VARIABLES OUTPUT:
back_log50
basedirC:\mysql4\
bdb_cache_size8388600
bdb_log_buffer_size0
bdb_home
bdb_max_lock1
bdb_logdir
bdb_shared_dataOFF
bdb_tmpdir
bdb_versionSleepycat Software: Berkeley DB 3.2.9a: (August 28
binlog_cache_size32768
bulk_insert_buffer_size8388608
character_setlatin1
character_setslatin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 
ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew 
win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 
latin5
concurrent_insertON
connect_timeout5
convert_character_set
datadirC:\mysql4\data\
delay_key_writeON
delayed_insert_limit100
delayed_insert_timeout300
delayed_queue_size1000
flushOFF
flush_time1800
ft_min_word_len4
ft_max_word_len254
ft_max_word_len_for_sort20
ft_boolean_syntax+ -()~*:|
have_bdbDISABLED
have_innodbYES
have_isamYES
have_raidNO
have_symlinkYES
have_opensslNO
have_query_cacheYES
init_file
innodb_additional_mem_pool_size2097152
innodb_buffer_pool_size16777216
innodb_data_file_pathibdata1:250M
innodb_data_home_dirc:\mysql4\ibdata
innodb_file_io_threads4
innodb_force_recovery0
innodb_thread_concurrency8
innodb_flush_log_at_trx_commit1
innodb_fast_shutdownON
innodb_flush_method
innodb_lock_wait_timeout50
innodb_log_arch_dirc:\mysql4\iblogs
innodb_log_archiveOFF
innodb_log_buffer_size8388608
innodb_log_file_size5242880
innodb_log_files_in_group3
innodb_log_group_home_dirc:\mysql4\iblogs
innodb_mirrored_log_groups1
interactive_timeout28800
join_buffer_size131072
key_buffer_size16773120
languageC:\mysql4\share\english\
large_files_supportON
local_infileON
logOFF
log_updateOFF
log_binOFF
log_slave_updatesOFF
log_slow_queriesOFF
log_warningsOFF
long_query_time10
low_priority_updatesOFF
lower_case_table_namesON
max_allowed_packet1047552
max_binlog_cache_size4294967295
max_binlog_size1073741824
max_connections100
max_connect_errors10
max_delayed_threads20
max_heap_table_size16777216
max_join_size4294967295
max_sort_length1024
max_user_connections0
max_tmp_tables32
max_write_lock_count4294967295
myisam_max_extra_sort_file_size268435456
myisam_max_sort_file_size2147483647
myisam_recover_optionsOFF
myisam_sort_buffer_size8388608
named_pipeOFF
net_buffer_length8192
net_read_timeout30
net_retry_count10
net_write_timeout60
open_files_limit0
pid_fileC:\mysql4\data\Elite-Win-2000.pid
port3306
protocol_version10
read_buffer_size131072
read_rnd_buffer_size262144
rpl_recovery_rank0
query_cache_limit1048576
query_cache_size0
query_cache_typeON
safe_show_databaseOFF
server_id1
slave_net_timeout3600
skip_external_lockingON
skip_networkingOFF
skip_show_databaseOFF
slow_launch_time2
socketMySQL
sort_buffer_size524280
sql_mode0
table_cache64
table_typeMYISAM
thread_cache_size0
thread_stack65536
tx_isolationREAD-COMMITTED
timezoneAUS Eastern Standard Time
tmp_table_size33554432
tmpdirC:\DOCUME~1\MySQL\LOCALS~1\Temp\
version4.0.3-beta-max-nt
wait_timeout28800

TABLE STRUCTURE:
#
# Table structure for table 'adodbseq'
#

CREATE TABLE `adodbseq` (
   `id` int(11) NOT NULL default '0'
) TYPE=InnoDB;



#
# Table structure for table 'articles'
#

CREATE TABLE `articles` (
   `article_id` int(11) NOT NULL auto_increment,
   `article_title` varchar(125) default NULL,
   `category_id` int(11) default NULL,
   `article_desc` text,
   `date_posted` datetime default NULL,
   `date_expire` datetime default NULL,
   PRIMARY KEY  (`article_id`)
) TYPE=InnoDB;



#
# Table structure for table 'categories'
#

CREATE TABLE `categories` (
   `category_id` int(11) NOT NULL auto_increment,
   `category_desc` varchar(50) default NULL,
   PRIMARY KEY  (`category_id`)
) TYPE=InnoDB;



#
# Table structure for table 'cds'
#

CREATE TABLE `cds` (
   `cd_no` int(8) NOT NULL auto_increment,
   `inv_no` int(8) default NULL,
   `cust_no` varchar(8) default NULL,
   `prod_code` varchar(10) default NULL,
   `date_sent` date default NULL,
   `date_expected` date default NULL,
   `cd_sent` enum('Y','N') default 'N',
   `cd_pack` enum('Y','N') default 'N',
   PRIMARY KEY  (`cd_no`),
   KEY `CD_KEY` (`cd_no`),
   KEY `INV_KEY` (`inv_no`),
   KEY `CUST_KEY` (`cust_no`)
) TYPE=InnoDB;



#
# Table structure for table 'contacts'
#

CREATE TABLE `contacts` (
   `ref_id` int(8) NOT NULL auto_increment,
   `cust_no` varchar(8) default NULL,
   `name` varchar(76) default NULL,
   `ph_area` varchar(10) default NULL,
   `ph_number` varchar(15) default NULL,
   `ph_extn` varchar(5) default NULL,
   `fax_area` varchar(10) default NULL,
   `fax_number` varchar(15) default NULL,
   `fax_extn` varchar(15) default NULL,
   `mobile_no` varchar(15) default NULL,
   `email_addr` varchar(76) default NULL,
   `web_addr` varchar(76) default

1 2 >

1 - 100 of 111 matches

Mail list logo