date:20030602

RE: Cant connect with SSL support

2003-06-02 Thread Andrew

try connecting using the server name not localhost

hth
Andrew

>-Original Message-
>From: Karam Chand [mailto:[EMAIL PROTECTED]
>Sent: 02 June 2003 14:43
>To: [EMAIL PROTECTED]
>Subject: Cant connect with SSL support
>
>
>Hello
>
>I have a MySQL 4.0.3 server with SSL option. I know
>that the SSL option is runnish coz when I do show
>variables...i am getting the value for ssl to be true
>:)
>
>I am writing a C app to connect to the MySQL server to
>do some jobs. 
>
>I am using the mysql_real_connect() function to
>connect. The code i use is -
>
>UINT client = 0;
>
>client = client | CLIENT_SSL;
>
>ret = mysql_real_connect ( mysql, "localhost", "user",
>"pwd", NULL, 3306, NULL, client );
>
>The app seems to hang? but when i comment out the line
>
>client = client | CLIENT_SSL; 
>
>everything seems to be working find. I want to use the
>SSL protocol? Am I doint anything wrong.
>
>Yeah...I am using the libmysql.dll which was provided
>with 3.23.54? Do I need to upgrade the .dll and .lib
>which is provided with MySQL 4.x???
>
>Thanks in advance.
>
>Karam
>
>
>__
>Do you Yahoo!?
>Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
>http://calendar.yahoo.com
>
>-- 
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.486 / Virus Database: 284 - Release Date: 29/05/2003
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query problem

2003-06-02 Thread Sparky Kopetzky

No, not swearing - just As Soon As Financially Possible!!!

Robin

*** Still need an answer if someone can help *


- Original Message -
From: "Nils Valentin" <[EMAIL PROTECTED]>
To: "Sparky Kopetzky" <[EMAIL PROTECTED]>; "My Sql List"
<[EMAIL PROTECTED]>
Sent: Sunday, June 01, 2003 19:52
Subject: Re: Query problem


> Hi everybody,
>
>
> I hope ASAFP stands for something like AS Soon AS Feasable Possible ;-)
>
> We are not going to swear are we ?
>
> Best regards
>
> Nils Valentin
>
> 2003年 6月 2日 月曜日 07:30、Sparky Kopetzky さんは書きました:
> > I have a view I need to create from several tables where I'm looking up
one
> > value from a table and need to add it to the Select stmt like this:
> >
> > SELECT sex (SELECT yes_no_meaning FROM yes_no WHERE yes_no_id =
> > bite.bite_animal_sex_id),
> >type (SELECT type_meaning FROM type WHERE type_id =
> > bite.bite_type_id), etc...
> >
> > However, I haven't found an example of how to do this and I need this
> > ASAFP!!
> >
> > Apreciate any help.
> >
> > Robin E. Kopetzky
> > Black Mesa Computers/Internet Services
> > www.blackmesa-isp.net
>
> --
> 
> Valentin Nils
> Internet Technology
>
>  E-Mail: [EMAIL PROTECTED]
>  URL: http://www.knowd.co.jp
> 
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Cant connect with SSL support

2003-06-02 Thread Karam Chand

Hello

I have a MySQL 4.0.3 server with SSL option. I know
that the SSL option is runnish coz when I do show
variables...i am getting the value for ssl to be true
:)

I am writing a C app to connect to the MySQL server to
do some jobs. 

I am using the mysql_real_connect() function to
connect. The code i use is -

UINT client = 0;

client = client | CLIENT_SSL;

ret = mysql_real_connect ( mysql, "localhost", "user",
"pwd", NULL, 3306, NULL, client );

The app seems to hang? but when i comment out the line

client = client | CLIENT_SSL; 

everything seems to be working find. I want to use the
SSL protocol? Am I doint anything wrong.

Yeah...I am using the libmysql.dll which was provided
with 3.23.54? Do I need to upgrade the .dll and .lib
which is provided with MySQL 4.x???

Thanks in advance.

Karam


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

result returned from query 'show fields from .....'

2003-06-02 Thread Karam Chand

Hello

It seems that an extra column has been added to the
column information returned from the query]

show fields from `dbname`.`tablename`

the column is called collation and gives some extra
information. 

Can somebody tell the exact version of MySQL from
which this extra information was added.

Thanks in advance.

Karam


__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Bug in RIGHT OUTER JOIN?

2003-06-02 Thread Victoria Reznichenko

Harald Fuchs <[EMAIL PROTECTED]> wrote:
> Either I misunderstand what a RIGHT OUTER JOIN does, or MySQL has a bug.
> Consider the following example:
> 

[skip]

> 
> This looks somewhat like the cartesian product of t3 with (t1 left
> join t2).  I would expect t3 left join (t1 left join t2).
> 

Thank you for bug report! This bug will be fixed in 5.1. Temporary solution is a 
rewritting query with a LEFT JOIN.


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





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ft_boolean_default='AND'

2003-06-02 Thread Egor Egorov

"electroteque" <[EMAIL PROTECTED]> wrote:
> hi guys , i was wondering if this variable , is available for 4.0.12 ? we
> tried to make it work but mysql would not start , if this is still not
> available , what are the best ways for me to try and format a search say for
> instance currently if i search for two words

There was no ft_boolean_default variable.

> 
> "something1 something2" "something3 something4" it will get either exact
> matches notice the space
> 
> if i try "something1 something2" + "something3 something4" doesnt work

There shouldn't be a space between + and "".

SELECT .. FROM .. WHERE .. MATCH(..) AGAINST('+"something1 something2" +"somethin3 
something4"' IN
BOOLEAN MODE);


> if i try "something1 something2"+"something3 something4" works without
> spaces
> 
> this is a really unfriendly syntax for not technical users , how can i make
> this search more friendly and make it default to AND ??



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




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Is this an inefficient query?

2003-06-02 Thread Jay Blanchard

Actually, the query I originally sent is probably OK...it is this query
that may be causing the problem
(I have left the PHP code intact.)

$qin = "SELECT COUNT(cdr.ani) AS qtyin, SUM(cdr.calldur/60) AS minin ";
$qin .= "FROM tblCDR cdr LEFT OUTER JOIN CDRFilter e ";
$qin .= "ON cdr.dialedno = e.phoneNumber ";
$qin .= "WHERE e.phoneNumber IS NULL ";
$qin .= "AND (cdr.dialedno LIKE '800%' ";
$qin .= "OR cdr.dialedno LIKE '866%' ";
$qin .= "OR cdr.dialedno LIKE '877%' ";
$qin .= "OR cdr.dialedno LIKE '888%') ";
$qin .= "AND cdr.pindigs = '' ";
$qin .= "AND cdr.predig <> '2' ";
$qin .= "AND cdr.predig <> '3' ";
$qin .= "AND cdr.discn_dt <= '" . $cdrdate . "' ";
$qin .= "AND cdr.billed_flag = '' ";

Thanks!

Jay

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Is this an inefficient query?

2003-06-02 Thread Jay Blanchard

I am having some frustrations with a group of queries on one table in my
database. Queries to other tables seem to proceed smoothly enough. This
group of queries (6 in total) is called from a PHP page for a report,
there are millions of records.

Here is an example of one of the queries...

SELECT COUNT(cdr.ani) AS qtyout, SUM(cdr.calldur/60) AS minout
FROM tblCDR cdr LEFT OUTER JOIN CDRFilter e
ON cdr.ani = e.phoneNumber
WHERE e.phoneNumber IS NULL
AND cdr.pindigs = '' 
AND cdr.predig <> '2'
AND cdr.predig <> '3'
AND cdr.dialedno NOT LIKE '800%' 
AND cdr.dialedno NOT LIKE '866%' 
AND cdr.dialedno NOT LIKE '877%' 
AND cdr.dialedno NOT LIKE '888%' 
AND cdr.discn_dt <= '2003-05-25'
AND cdr.billed_flag = '' 

here is the structure info for the primary table 

CREATE TABLE tblCDR (
  id int(11) NOT NULL auto_increment,
  discn_dt varchar(10) default NULL,
  anstype varchar(6) default NULL,
  pindigs varchar(4) default NULL,
  orig_time varchar(6) default NULL,
  discn_time varchar(6) default NULL,
  time_chng char(1) default NULL,
  ani varchar(15) default NULL,
  infodig char(2) default NULL,
  calldur int(11) default NULL,
  dialedno varchar(15) default NULL,
  calledno varchar(15) default NULL,
  predig char(1) default NULL,
  orig_dt varchar(10) default NULL,
  acctcd varchar(12) default NULL,
  prcmp_id varchar(6) default NULL,
  comp_grp_cd char(2) default NULL,
  comp_grp_val varchar(24) default NULL,
  intra_lata_ind char(1) default NULL,
  portedno varchar(10) default NULL,
  lnpcheck char(1) default NULL,
  whole_record text,
  FileName varchar(32) NOT NULL default '',
  billed_flag varchar(10) default NULL,
  cycle_flag varchar(10) default NULL,
  PRIMARY KEY  (id),
  KEY discn_dt (discn_dt),
  KEY billed_flag (billed_flag),
  KEY dialedno (dialedno),
  KEY predig (predig),
  KEY FileName (FileName),
  KEY ani (ani),
  KEY calldur (calldur)
) TYPE=MyISAM MAX_ROWS=10 AVG_ROW_LENGTH=600;

Can anyone see something that I may be doing incorrectly or
inefficiently? It is driving me nuts.

Thanks!

Jay

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems installing DBD::mysql for My SQL 4

2003-06-02 Thread James Marcinek

> I believe the package you are looking for is
>
> zlib-devel
>
> The latest version from redhat is available at
> http://updates.redhat.com/8.0/en/os/i386/zlib-devel-1.1.4-8.8x.i386.rpm
>
> Thanks,
> Ryan Yagatich
>
> ,_,
> \ Ryan Yagatich [EMAIL PROTECTED] \
> / Pantek Incorporated  (877) LINUX-FIX /
> \ http://www.pantek.com/security(440) 519-1802 \
> /   Are your networks secure? Are you certain? /
> \___9C80D881D4D379058537BE21F52F14FA6354C11AC57734FB___\
>
>
> On Sun, 2003-06-01 at 21:21, James Marcinek wrote:
>
> 
>> 1.) You may try to remove the -lz or -lgz flag from the libs list
>> by using the --libs switch for "perl Makefile.PL".
>> 2.) On Red Hat Linux install libz-devel
>> 3.) On other systems, please contact the mailing list
>>
> 
>> Can anyone help me out here?
>>
>> Thanks,
>>
>> James
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>


I got it finally!!!

Thanks for the help!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ft_boolean_default='AND'

2003-06-02 Thread electroteque

hi guys , i was wondering if this variable , is available for 4.0.12 ? we
tried to make it work but mysql would not start , if this is still not
available , what are the best ways for me to try and format a search say for
instance currently if i search for two words

"something1 something2" "something3 something4" it will get either exact
matches notice the space

if i try "something1 something2" + "something3 something4" doesnt work
if i try "something1 something2"+"something3 something4" works without
spaces

this is a really unfriendly syntax for not technical users , how can i make
this search more friendly and make it default to AND ??


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Database/table size

2003-06-02 Thread Keith Schuster

Is it possible to limit the size of a dbase or table?




---
Keith Schuster
Schuster & Company LLC
ph:704-799-2438
fx:704-799-0779
iChat/AIM:FSHSales

WWW.FlagShipHosting.com
WWW.Schusterandcompany.com
WWW.Vsheet.net




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.0.12 proftpd 1.2.8

2003-06-02 Thread Chris Knipe

> Jun 02 08:07:17 mod_sql/4.10[1108]: message: 'Unknown column 'password' in
> 'field list''
>

> mysql> SELECT * FROM users WHERE userid = "test"
> -> ;
>
++-+--+--+-+--+---+-
---+-+---+--+--+--+-
+--+--++
> | userid | uid | gid  | passwd   | description | disabled | shell
|


It should be obvious.

Fix your spelling mistake.

--
me


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AW: MySQL 4.0.12 proftpd 1.2.8

2003-06-02 Thread Mark Vollmann

The select statement references a column password but the table
definition/result of the select contains the column passwd!(you selected
password not passwd)



> -Ursprungliche Nachricht-
> Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Gesendet: Montag, 2. Juni 2003 14:19
> An: [EMAIL PROTECTED]
> Betreff: MySQL 4.0.12 proftpd 1.2.8
>
>
> I have created two tables in mysql for users, and groups, but
> when I try to
> log into the ftp server I get this error:
>
>  backend module 'mod_sql_mysql/4.03'
> Jun 02 08:07:13 mod_sql/4.10[1108]: backend api'mod_sql_api_v1'
> Jun 02 08:07:13 mod_sql/4.10[1108]: >>> sql_getconf
> Jun 02 08:07:13 mod_sql/4.10[1108]: enteringmysql cmd_defineconnection
> Jun 02 08:07:13 mod_sql/4.10[1108]:  name: 'default'
> Jun 02 08:07:13 mod_sql/4.10[1108]:  user: 'proftpd'
> Jun 02 08:07:13 mod_sql/4.10[1108]:  host: '127.0.0.1'
> Jun 02 08:07:13 mod_sql/4.10[1108]:db: 'proftpd'
> Jun 02 08:07:13 mod_sql/4.10[1108]:  port: '3306'
> Jun 02 08:07:13 mod_sql/4.10[1108]:   ttl: '0'
> Jun 02 08:07:13 mod_sql/4.10[1108]: exiting mysql cmd_defineconnection
> Jun 02 08:07:13 mod_sql/4.10[1108]: enteringmysql cmd_open
> Jun 02 08:07:13 mod_sql/4.10[1108]: connection 'default' opened
> Jun 02 08:07:13 mod_sql/4.10[1108]: : connection 'default' count is now 1
> Jun 02 08:07:13 mod_sql/4.10[1108]: exiting mysql cmd_open
> Jun 02 08:07:13 mod_sql/4.10[1108]: backend successfully connected.
> Jun 02 08:07:13 mod_sql/4.10[1108]: mod_sql status : on
> Jun 02 08:07:13 mod_sql/4.10[1108]: negative_cache : off
> Jun 02 08:07:13 mod_sql/4.10[1108]: authenticate   : users groups
> Jun 02 08:07:13 mod_sql/4.10[1108]: usertable  : users
> Jun 02 08:07:13 mod_sql/4.10[1108]: userid field   : userid
> Jun 02 08:07:13 mod_sql/4.10[1108]: password field : password
> Jun 02 08:07:13 mod_sql/4.10[1108]: uid field  : uid
> Jun 02 08:07:13 mod_sql/4.10[1108]: gid field  : gid
> Jun 02 08:07:13 mod_sql/4.10[1108]: homedir field  : homedir
> Jun 02 08:07:13 mod_sql/4.10[1108]: shell field: shell
> Jun 02 08:07:13 mod_sql/4.10[1108]: homedirondemand: false
> Jun 02 08:07:13 mod_sql/4.10[1108]: group table: groups
> Jun 02 08:07:13 mod_sql/4.10[1108]: groupname field: groupname
> Jun 02 08:07:13 mod_sql/4.10[1108]: grp gid field  : gid
> Jun 02 08:07:13 mod_sql/4.10[1108]: grp members field  : members
> Jun 02 08:07:13 mod_sql/4.10[1108]: SQLMinUserUID  : 999
> Jun 02 08:07:13 mod_sql/4.10[1108]: SQLMinUserGID  : 999
> Jun 02 08:07:13 mod_sql/4.10[1108]: SQLDefaultUID  : 65533
> Jun 02 08:07:13 mod_sql/4.10[1108]: SQLDefaultGID  : 65533
> Jun 02 08:07:13 mod_sql/4.10[1108]: <<< sql_getconf
> Jun 02 08:07:17 mod_sql/4.10[1108]: >>> cmd_getgroups
> Jun 02 08:07:17 mod_sql/4.10[1108]: enteringmysql cmd_escapestring
> Jun 02 08:07:17 mod_sql/4.10[1108]: exiting mysql cmd_escapestring
> Jun 02 08:07:17 mod_sql/4.10[1108]: cache miss for user 'test'
> Jun 02 08:07:17 mod_sql/4.10[1108]: : entering  mysql cmd_select
> Jun 02 08:07:17 mod_sql/4.10[1108]: enteringmysql cmd_open
> Jun 02 08:07:17 mod_sql/4.10[1108]: connection 'default' count is now 2
> Jun 02 08:07:17 mod_sql/4.10[1108]: exiting mysql cmd_open
> Jun 02 08:07:17 mod_sql/4.10[1108]: query "SELECT userid, password, uid,
> gid, homedir, shell FROM users WHERE (userid='te
> st') LIMIT 1"
> Jun 02 08:07:17 mod_sql/4.10[1108]: enteringmysql cmd_close
> Jun 02 08:07:17 mod_sql/4.10[1108]: connection 'default' count is now 1
> Jun 02 08:07:17 mod_sql/4.10[1108]: exiting mysql cmd_close
> Jun 02 08:07:17 mod_sql/4.10[1108]: exiting mysql cmd_select
> Jun 02 08:07:17 mod_sql/4.10[1108]: unrecoverable backend error
> Jun 02 08:07:17 mod_sql/4.10[1108]: error: '1054'
> Jun 02 08:07:17 mod_sql/4.10[1108]: message: 'Unknown column 'password' in
> 'field list''
>
> Could you tell me what I am doing wrong.  I am using ppmy-0.2 which gives
> me a web interface that I can create users and groups.  I have also
> included a SELECT statement which verfies that the user has been created:
>
> mysql> SELECT * FROM users WHERE userid = "test"
> -> ;
> ++-+--+--+-+--
> +---++-+---+--+---
> ---+--+-+--+--++
> | userid | uid | gid  | passwd   | description | disabled
> | shell |
> homedir| expires | email | name | ul_bytes |
> dl_bytes |
> login_count | dl_count | ul_count | last_login |
> ++-+--+--+-+--
> +---++-+---+--+---
> ---+--+-+--+--++
> | test   | 211 | 1038 | 132aab5d56aeb1bb | |0
> |   |
> /b/01/ftp/test | 2013-05-28 13:08:52 |   | Test |0 |
>   0 |
> 0

MySQL 4.0.12 proftpd 1.2.8

2003-06-02 Thread jhardy

I have created two tables in mysql for users, and groups, but when I try to
log into the ftp server I get this error:

 backend module 'mod_sql_mysql/4.03'
Jun 02 08:07:13 mod_sql/4.10[1108]: backend api'mod_sql_api_v1'
Jun 02 08:07:13 mod_sql/4.10[1108]: >>> sql_getconf
Jun 02 08:07:13 mod_sql/4.10[1108]: enteringmysql cmd_defineconnection
Jun 02 08:07:13 mod_sql/4.10[1108]:  name: 'default'
Jun 02 08:07:13 mod_sql/4.10[1108]:  user: 'proftpd'
Jun 02 08:07:13 mod_sql/4.10[1108]:  host: '127.0.0.1'
Jun 02 08:07:13 mod_sql/4.10[1108]:db: 'proftpd'
Jun 02 08:07:13 mod_sql/4.10[1108]:  port: '3306'
Jun 02 08:07:13 mod_sql/4.10[1108]:   ttl: '0'
Jun 02 08:07:13 mod_sql/4.10[1108]: exiting mysql cmd_defineconnection
Jun 02 08:07:13 mod_sql/4.10[1108]: enteringmysql cmd_open
Jun 02 08:07:13 mod_sql/4.10[1108]: connection 'default' opened
Jun 02 08:07:13 mod_sql/4.10[1108]: : connection 'default' count is now 1
Jun 02 08:07:13 mod_sql/4.10[1108]: exiting mysql cmd_open
Jun 02 08:07:13 mod_sql/4.10[1108]: backend successfully connected.
Jun 02 08:07:13 mod_sql/4.10[1108]: mod_sql status : on
Jun 02 08:07:13 mod_sql/4.10[1108]: negative_cache : off
Jun 02 08:07:13 mod_sql/4.10[1108]: authenticate   : users groups
Jun 02 08:07:13 mod_sql/4.10[1108]: usertable  : users
Jun 02 08:07:13 mod_sql/4.10[1108]: userid field   : userid
Jun 02 08:07:13 mod_sql/4.10[1108]: password field : password
Jun 02 08:07:13 mod_sql/4.10[1108]: uid field  : uid
Jun 02 08:07:13 mod_sql/4.10[1108]: gid field  : gid
Jun 02 08:07:13 mod_sql/4.10[1108]: homedir field  : homedir
Jun 02 08:07:13 mod_sql/4.10[1108]: shell field: shell
Jun 02 08:07:13 mod_sql/4.10[1108]: homedirondemand: false
Jun 02 08:07:13 mod_sql/4.10[1108]: group table: groups
Jun 02 08:07:13 mod_sql/4.10[1108]: groupname field: groupname
Jun 02 08:07:13 mod_sql/4.10[1108]: grp gid field  : gid
Jun 02 08:07:13 mod_sql/4.10[1108]: grp members field  : members
Jun 02 08:07:13 mod_sql/4.10[1108]: SQLMinUserUID  : 999
Jun 02 08:07:13 mod_sql/4.10[1108]: SQLMinUserGID  : 999
Jun 02 08:07:13 mod_sql/4.10[1108]: SQLDefaultUID  : 65533
Jun 02 08:07:13 mod_sql/4.10[1108]: SQLDefaultGID  : 65533
Jun 02 08:07:13 mod_sql/4.10[1108]: <<< sql_getconf
Jun 02 08:07:17 mod_sql/4.10[1108]: >>> cmd_getgroups
Jun 02 08:07:17 mod_sql/4.10[1108]: enteringmysql cmd_escapestring
Jun 02 08:07:17 mod_sql/4.10[1108]: exiting mysql cmd_escapestring
Jun 02 08:07:17 mod_sql/4.10[1108]: cache miss for user 'test'
Jun 02 08:07:17 mod_sql/4.10[1108]: : entering  mysql cmd_select
Jun 02 08:07:17 mod_sql/4.10[1108]: enteringmysql cmd_open
Jun 02 08:07:17 mod_sql/4.10[1108]: connection 'default' count is now 2
Jun 02 08:07:17 mod_sql/4.10[1108]: exiting mysql cmd_open
Jun 02 08:07:17 mod_sql/4.10[1108]: query "SELECT userid, password, uid,
gid, homedir, shell FROM users WHERE (userid='te
st') LIMIT 1"
Jun 02 08:07:17 mod_sql/4.10[1108]: enteringmysql cmd_close
Jun 02 08:07:17 mod_sql/4.10[1108]: connection 'default' count is now 1
Jun 02 08:07:17 mod_sql/4.10[1108]: exiting mysql cmd_close
Jun 02 08:07:17 mod_sql/4.10[1108]: exiting mysql cmd_select
Jun 02 08:07:17 mod_sql/4.10[1108]: unrecoverable backend error
Jun 02 08:07:17 mod_sql/4.10[1108]: error: '1054'
Jun 02 08:07:17 mod_sql/4.10[1108]: message: 'Unknown column 'password' in
'field list''

Could you tell me what I am doing wrong.  I am using ppmy-0.2 which gives
me a web interface that I can create users and groups.  I have also
included a SELECT statement which verfies that the user has been created:

mysql> SELECT * FROM users WHERE userid = "test"
-> ;
++-+--+--+-+--+---++-+---+--+--+--+-+--+--++
| userid | uid | gid  | passwd   | description | disabled | shell |
homedir| expires | email | name | ul_bytes | dl_bytes |
login_count | dl_count | ul_count | last_login |
++-+--+--+-+--+---++-+---+--+--+--+-+--+--++
| test   | 211 | 1038 | 132aab5d56aeb1bb | |0 |   |
/b/01/ftp/test | 2013-05-28 13:08:52 |   | Test |0 |0 |
0 |0 |0 | NULL   |
++-+--+--+-+--+---++-+---+--+--+--+-+--+--++
1 row in set (0.04 sec)

Do you have any idea why I am getting this error, here is the proftpd.conf
file also:


ServerName  "charlotte"
ServerType  inetd
DefaultServer   on

SystemLog   /usr/local/var/p

Re: QUESTION ABOUT DATA AND INDEX FILE DIRECTORIES

2003-06-02 Thread Egor Egorov

Ares Liu <[EMAIL PROTECTED]> wrote:
> 
> Under windows XP, mysql-4.0.12, when I create a table with special data and index 
> directories as follow:
> 
> USE DATABASE test;
> 
> CREAT TABLE IF NOT EXISTS test_table ( Vola INT NOT NULL, PRIMARY KEY (Vola)) 
>   DATA DIRECTORY="D:/mySQLDBs/test/data" 
>   INDEX DIRECTORY="D:/mySQLDBs/test/index";
> 
> It show test_table created successfully in mysql client.
> But really, mysqld creats table test_table with three table files test_table.frm, 
> test_table.MYD, and test_table.MYI in D:\mySQLDBs directory. In addition, I defined 
> "datadir=d:/mySQLDBs" in my.cnf.
> 
> Who can tell me why this happened? And how can I put the data file and index file to 
> where I want to allocate without links.

DATA DIRECTORY and INDEX DIRECTORY is ignored on Windows.



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




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Signal 11 on replicated MySQL Slave (4.0.13-standard)

2003-06-02 Thread Victoria Reznichenko

Joel Rowbottom <[EMAIL PROTECTED]> wrote:
> >Description:
> MySQL crashes out with signal 11 when replication has been set up as
> a slave.
> >How-To-Repeat:
> Follow instructions for replicated slave, then simply log out. If you
> started mysqld (even if in nohup or background) it still sig11's -
> options used were:
> ./bin/safe_mysqld --user=mysql --skip-slave-start
> >Fix:
> It doesn't seem to affect the replication, which can be restarted
> with "slave start", so other than being aware of it, it doesn't seem
> to be too bad. However, I'll know in a day or so when I can check
> how the replication is going.
> 

Worked perfect for me. What others replication options do you use?


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





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ALTER TABLE

2003-06-02 Thread Victoria Reznichenko

"Lilian" <[EMAIL PROTECTED]> wrote:
> I have tested that function 
> 
> ALTER TABLE table_name_here AUTO_INCREMENT = 1000;
> 
> on version 4.0.12 and it's not working.
> (table TYPE=InnoDB)
> 
> in 3.23.54 that is OK
> 
> does anybody know what's wrong here?

Option AUTO_INCREMENT works only on MyISAM tables.


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





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ALTER TABLE

2003-06-02 Thread Heikki Tuuri

Hi!

I have now updated the manual to reflect this restriction on InnoDB tables:

"
You cannot set the first AUTO_INCREMENT column value in InnoDB with CREATE
TABLE ... AUTO_INCREMENT=... (or ALTER TABLE ...). To set the value insert a
dummy row with a value one less, and delete that dummy row.
"

Best regards,

Heikki Tuuri
Innobase Oy
http://www.innodb.com
Transactions, foreign keys, and a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/


- Original Message - 
From: "Becoming Digital" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, June 02, 2003 10:15 AM
Subject: Re: ALTER TABLE


> Is 'id' indexed?  AUTO_INCREMENT fields must be to work correctly.  Try
this:
>
> ALTER TABLE users
> ADD INDEX idx_id (id),
> AUTO_INCREMENT=1000;
>
>
> Quite honestly, your ID field should probably be the primary key, so:
>
> ALTER TABLE users
> MODIFY id INT(9) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
> AUTO_INCREMENT=1000;
>
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
>
>
> - Original Message - 
> From: "Lilian" <[EMAIL PROTECTED]>
> To: "Becoming Digital" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Monday, 02 June, 2003 02:28
> Subject: Re: ALTER TABLE
>
>
> I have check http://www.mysql.com/doc/en/ALTER_TABLE_problems.html but no
> solution for my problem.
>
> I have table_name 'users' (TYPE=InnoDB)  with one of field id
>
>   id int(9) unsigned NOT NULL auto_increment,
>
> when I update last insert id to 1000 , mysql 3 add next data automatically
> with 1001, 1002 etc.
> version 4 add data with id 3, 4 etc, it not check the value of last ID.
>
> I want to know if there are some solution, I need to start that ID from
1000
> not from 1.
>
> lilian
>
>
>
> - Original Message -
> From: "Becoming Digital" <[EMAIL PROTECTED]>
> To: "Lilian" <[EMAIL PROTECTED]>
> Sent: Monday, June 02, 2003 9:04 AM
> Subject: Re: ALTER TABLE
>
>
> > Did you check http://www.mysql.com/doc/en/ALTER_TABLE_problems.html for
> info?
> >
> > Edward Dudlik
> > Becoming Digital
> > www.becomingdigital.com
> >
> >
> > - Original Message -
> > From: "Lilian" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, 02 June, 2003 01:17
> > Subject: ALTER TABLE
> >
> >
> > Hi,
> > I have tested that function
> >
> > ALTER TABLE table_name_here AUTO_INCREMENT = 1000;
> >
> > on version 4.0.12 and it's not working.
> > (table TYPE=InnoDB)
> >
> > in 3.23.54 that is OK
> >
> > does anybody know what's wrong here?
> >
> > regards,
> > lilian
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> >
> >
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Connecting WO 5.2.1 to MySQL 4.0.13 on Windows 2000?

2003-06-02 Thread Victor Medina

Hi!

Most probably the drivers will be fine placing the jar file under
c:\jdk_dir\jre\lib\ext

This way there should be no classpath problem

Adding JDK_HOME and JAVA_HOME variables to your environment should help also
As for the drivers, both should work, just fine =)

On Sunday 01 June 2003 19:15, Kieran Kelleher wrote:
> Getting EO Modeler in WO 5.2.1 to connect to MySQL 4.0.12 on Windows 2000
> is evading us somehow and giving us a dreaded connection error. It works
> fine on OS X  I know it is something to do with Classpaths and the fact
> that EO Modeler uses a different JDBC connector than WO.
>
> 1) If someone out there has MySQL 4.0.XX and WO 5.2.1 Development on
> Windows 2000 can you tell me what JDBC drivers you have in what folders and
> what customization, if any you had to do to classpath, connection string,
> etc.?
>
> 2) Should I use the latest Connector/J 3.0.8 with MySQL 4.0.XX or does
> 2.0.14 work with MySQL 4.0.XX and which JDBC connector is best for WO
> 5.2.1?
>
> Thanks, Kieran

-- 
Victor Medina M
Ferreteria EPA - [EMAIL PROTECTED]
Geek by nature, Linux by choice!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

advanced statement

2003-06-02 Thread Frank Nørvig

Hello,

I was wondering if the following could be done with an advanced
sql-statement in MySQL 3.23:

I have 5 tables with the following columns: id, name, phonenumber
I need to check for duplicate phonenumbers in the 5 tables, that is if the
same phonenumber exists in 3 tables or more.

I've tried with a JOIN and a COUNT, but it doesn't seem to work.

Regards,
Frank Nørvig




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SELECT query with OUTER JOIN - problem

2003-06-02 Thread Dejan Milenkovic

Hi,
I have two tables, one is containing data about courses and the second one
is containing data about course start date.
Is it possible to list all courses with one query which should also return
earliest  scheduled start dates for courses (which are in the second table).
I tried something like this:
SELECT c_d.*, MIN(c_s.start) as start FROM course_data c_d RIGHT OUTER JOIN
course_start c_s ON c_s.courseid=c_d.courseid WHERE c_s.start>NOW() GROUP BY
c_s.courseid
But this return only courses that have start date if I replace ON condition
with 1=1 I get list of all courses but with the same date, if I remove ON
condition MySQL return error, I also tried replacing ON
c_s.courseid=c_d.courseid with
USING (courseid) but that didn't help.
Any help is appriciated.

Here are the table definitions and test data.
CREATE TABLE course_data (
  courseid mediumint(9) NOT NULL auto_increment,
  data varchar(255) NOT NULL default '',
  PRIMARY KEY  (courseid)
) TYPE=MyISAM;
INSERT INTO course_data VALUES (1, 'Test data');
INSERT INTO course_data VALUES (2, 'Also test data');

CREATE TABLE course_start (
  courseid  mediumint(9) NOT NULL,
  start date NOT NULL default '-00-00'
) TYPE=MyISAM;
INSERT INTO course_start VALUES (1, '2004-12-12');

So I need quey that would return both courses where the start column for
course 1 would be '2004-12-1 and NULL for course 2.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

UTF 8

2003-06-02 Thread Stefan Groschupf

Hi,
I have a 4.1 alpha running and need to write Greece and german chars in it.
Where I have to configurate UTF8?

Thanks
Stefan 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AW: How to run a script? Newbie alert..

2003-06-02 Thread Mark Vollmann

Use "source " from the mysql command line
Start mysql in the bin directory, switch to the db in use via "use "
and run the command "source "

Or read the manual section "3.6 Using mysql in Batch Mode"

Cheers

> -Ursprungliche Nachricht-
> Von: Terry Riley [mailto:[EMAIL PROTECTED]
> Gesendet: Montag, 2. Juni 2003 11:38
> An: [EMAIL PROTECTED]
> Betreff: How to run a script? Newbie alert..
>
>
> I've not been at this MySQL stuff too long, so bear with me..
> (4.0.13 running on Windows XP/Apache).
>
> Most of my work has been in Windows, and almost always with a
> GUI, so that
> when presented with the instruction to 'run mysql_fix_privilege_tables'
> script, I am totally clueless as to how to go about it!
>
> Tried going to a command box, getting to the c:\mysql\bin directory, type
> mysql, get mysql fired up, but I can't figure out (and yes, I have read
> the (mainly *nix oriented) manual without success) how to get a script in
> the \scripts sub-dir to run. Everything I try, in my ignorance, ends with
> a 'SQL query error' or similar.
>
> Help, please, I'm not used to this command-line stuff!
>
> Terry Riley
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to run a script? Newbie alert..

2003-06-02 Thread Terry Riley

I've not been at this MySQL stuff too long, so bear with me.. 
(4.0.13 running on Windows XP/Apache).

Most of my work has been in Windows, and almost always with a GUI, so that 
when presented with the instruction to 'run mysql_fix_privilege_tables' 
script, I am totally clueless as to how to go about it!

Tried going to a command box, getting to the c:\mysql\bin directory, type 
mysql, get mysql fired up, but I can't figure out (and yes, I have read 
the (mainly *nix oriented) manual without success) how to get a script in 
the \scripts sub-dir to run. Everything I try, in my ignorance, ends with 
a 'SQL query error' or similar.

Help, please, I'm not used to this command-line stuff!

Terry Riley


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Maximum table size

2003-06-02 Thread Veysel Harun Sahin

If your os permits, mysql can handle file sizes up to terabytes. You 
don't need to spawn your tables. But you have to be careful when 
creating your myisam tables. If you don't specify your table size limit 
with the max_rows option when creating table mysql will create a table 
with 4G file size limit. If you use innodb you can setup auto extend 
feature, so you don't need to control your table size, if it reach its 
maximum innodb will automatically extend its file size.

[EMAIL PROTECTED] wrote:

Hello

As i understand it mysql maintains a file for every table created. Does it
mean that the filesystem restricts the maximum size of a given table or do i
have the option to make table data spawn more than on file like in oracle?
Thanks in advance
Mark Vollmann


Mit freundlichen Grüßen,
Mark Vollmann


accelsis technologies GmbH
www.accelsis.de


Boschetsrieder Str. 20
D - 81379 München
Tel. +49 (0)89 1893599-0
Fax. +49 (0)89 1893599-99


[EMAIL PROTECTED]



--
Die Information in dieser E-Mail ist vertraulich und kann dem
Berufsgeheimnis unterliegen. Sie ist ausschließlich für den Adressaten
bestimmt. Jeglicher Zugriff auf diese E-Mail durch andere Personen als den
Adressaten ist untersagt. Sollten Sie nicht der für diese E-Mail bestimmte
Adressat sein, ist Ihnen jede Veröffentlichung, Vervielfältigung oder
Weitergabe wie auch das Ergreifen oder Unterlassen von Maßnahmen im
Vertrauen auf erlangte Information untersagt. In dieser E-Mail enthaltene
Meinungen oder Empfehlungen unterliegen den Bedingungen des jeweiligen
Mandatsverhältnisses mit dem Adressaten.


The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else
is unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or any action taken or omitted to be taken in reliance
on it, is prohibited and may be unlawful. Any opinions or advice contained
in this email are subject to the terms and conditions expressed in the
governing accelsis technologies client






 

--

Veysel Harun Sahin
[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Maximum table size

2003-06-02 Thread Jerry

And the manual says : .

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

Jerry

- Original Message - 
From: "Mark Vollmann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 02, 2003 9:39 AM
Subject: Maximum table size


> Hello
>
> As i understand it mysql maintains a file for every table created. Does it
> mean that the filesystem restricts the maximum size of a given table or do
i
> have the option to make table data spawn more than on file like in oracle?
>
>
> Thanks in advance
> Mark Vollmann
>
>
>
> Mit freundlichen Grüßen,
> Mark Vollmann
>
>
>
> accelsis technologies GmbH
> www.accelsis.de
>
>
>
> Boschetsrieder Str. 20
> D - 81379 München
> Tel. +49 (0)89 1893599-0
> Fax. +49 (0)89 1893599-99
>
>
>
> [EMAIL PROTECTED]
>
>
>
> --
> Die Information in dieser E-Mail ist vertraulich und kann dem
> Berufsgeheimnis unterliegen. Sie ist ausschließlich für den Adressaten
> bestimmt. Jeglicher Zugriff auf diese E-Mail durch andere Personen als den
> Adressaten ist untersagt. Sollten Sie nicht der für diese E-Mail bestimmte
> Adressat sein, ist Ihnen jede Veröffentlichung, Vervielfältigung oder
> Weitergabe wie auch das Ergreifen oder Unterlassen von Maßnahmen im
> Vertrauen auf erlangte Information untersagt. In dieser E-Mail enthaltene
> Meinungen oder Empfehlungen unterliegen den Bedingungen des jeweiligen
> Mandatsverhältnisses mit dem Adressaten.
>
>
>
> The information in this email is confidential and may be legally
privileged.
> It is intended solely for the addressee. Access to this email by anyone
else
> is unauthorized. If you are not the intended recipient, any disclosure,
> copying, distribution or any action taken or omitted to be taken in
reliance
> on it, is prohibited and may be unlawful. Any opinions or advice contained
> in this email are subject to the terms and conditions expressed in the
> governing accelsis technologies client
>
>
>
>
>
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Maximum table size

2003-06-02 Thread Mark Vollmann

Hello

As i understand it mysql maintains a file for every table created. Does it
mean that the filesystem restricts the maximum size of a given table or do i
have the option to make table data spawn more than on file like in oracle?


Thanks in advance
Mark Vollmann



Mit freundlichen Grüßen,
Mark Vollmann



accelsis technologies GmbH
www.accelsis.de



Boschetsrieder Str. 20
D - 81379 München
Tel. +49 (0)89 1893599-0
Fax. +49 (0)89 1893599-99



[EMAIL PROTECTED]



--
Die Information in dieser E-Mail ist vertraulich und kann dem
Berufsgeheimnis unterliegen. Sie ist ausschließlich für den Adressaten
bestimmt. Jeglicher Zugriff auf diese E-Mail durch andere Personen als den
Adressaten ist untersagt. Sollten Sie nicht der für diese E-Mail bestimmte
Adressat sein, ist Ihnen jede Veröffentlichung, Vervielfältigung oder
Weitergabe wie auch das Ergreifen oder Unterlassen von Maßnahmen im
Vertrauen auf erlangte Information untersagt. In dieser E-Mail enthaltene
Meinungen oder Empfehlungen unterliegen den Bedingungen des jeweiligen
Mandatsverhältnisses mit dem Adressaten.



The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else
is unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or any action taken or omitted to be taken in reliance
on it, is prohibited and may be unlawful. Any opinions or advice contained
in this email are subject to the terms and conditions expressed in the
governing accelsis technologies client








-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECTing last occurences from a table

2003-06-02 Thread Mateusz

> select
> substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',id,'|',price)),'
> |',1) + 0 as day,
>  
> substring_index(substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',
> id,'|',price)),'|',2),'|',-1) as name,
>  
> substring_index(substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',
> id,'|',price)),'|',3),'|',-1) as id,
>  
> substring_index(substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',
> id,'|',price)),'|',4),'|',-1) as price 
> from   food 
> group by food.name;

Works great! Thanks, You helped me a lot!

Mateusz Uzdowski


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql/innodb and the 2GB limit

2003-06-02 Thread Per Andreas Buer

On Monday 02 June 2003 04:32 am, Kieran Kelleher wrote:
> What platform and hardware spec are you using?

Linux (2.4.19 with the rmap vm) on Intel x86 (32 bit) with 3GB of memory. 
Mysql won't start if I set the InnoDB buffer above 2048MB. 



>
> -Original Message-
> From: Per Andreas Buer [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 30, 2003 1:48 PM
> To: [EMAIL PROTECTED]
> Subject: mysql/innodb and the 2GB limit
>
>
>
> Hi.
>
> Lately, I've been banging against the glibc 2GB malloc limit - what a
> headache. :/
>
> I believe this is not a mysql-specific problem, so a might be a bit off
> topic here. Does anyone know of a way to work around this limit? Does
> Redhat Advanced Server also have this problem? Or Suse Enterprise?
>
> --
> Per Andreas Buer
> mysql, query
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]

-- 
There are only 10 different kinds of people in the world, 
those who understand binary, and those who don't.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: my first select

2003-06-02 Thread trogers

SELECT thankyou, thankyou FROM thankyou.thankyou WHERE thankyou = 
thankyou.
It's nice to end the weekend and go to bed with one small success!
Though my persistence is unending.  ;-)

I added ORDER BY lastName on the end, et viola!

Thanks and goodnight!
Ted
On Monday, June 2, 2003, at 03:26 AM, Paracková Eva, Ing wrote:

peopleID should match:

SELECT lastname, model FROM people, machines WHERE machines.peopleID =
people.peopleID;
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 2. júna 2003 9:19
To: [EMAIL PROTECTED]
Subject: my first select
I made a small DB of people and machines, where one person can have
more than one machine, each machine can be assigned to only one person.
  people | machines, one-to-many.
I have a primary key ID field in each table (peopleID, machineID) and
in the machines table I have the peopleID, the foreign key.
So this should query should work, no?

SELECT lastname, model FROM people, machines WHERE machines.machinesID
= people.peopleID;
What happens is it simply produces a list of last names and a list of
machines in the order of each ID, they are not "matched" properly.
(It's really just 2 list.)
What might some of my problems be?

Thanks,
Ted
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: my first select

2003-06-02 Thread "Paracková Eva, Ing"

peopleID should match:

SELECT lastname, model FROM people, machines WHERE machines.peopleID =
people.peopleID;

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 2. júna 2003 9:19
To: [EMAIL PROTECTED]
Subject: my first select

I made a small DB of people and machines, where one person can have 
more than one machine, each machine can be assigned to only one person. 
  people | machines, one-to-many.
I have a primary key ID field in each table (peopleID, machineID) and 
in the machines table I have the peopleID, the foreign key.

So this should query should work, no?

SELECT lastname, model FROM people, machines WHERE machines.machinesID 
= people.peopleID;

What happens is it simply produces a list of last names and a list of 
machines in the order of each ID, they are not "matched" properly.  
(It's really just 2 list.)

What might some of my problems be?

Thanks,
Ted

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

my first select

2003-06-02 Thread trogers

I made a small DB of people and machines, where one person can have 
more than one machine, each machine can be assigned to only one person. 
 people | machines, one-to-many.
I have a primary key ID field in each table (peopleID, machineID) and 
in the machines table I have the peopleID, the foreign key.

So this should query should work, no?

SELECT lastname, model FROM people, machines WHERE machines.machinesID 
= people.peopleID;

What happens is it simply produces a list of last names and a list of 
machines in the order of each ID, they are not "matched" properly.  
(It's really just 2 list.)

What might some of my problems be?

Thanks,
Ted
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ALTER TABLE

2003-06-02 Thread Becoming Digital

Is 'id' indexed?  AUTO_INCREMENT fields must be to work correctly.  Try this:

ALTER TABLE users
ADD INDEX idx_id (id),
AUTO_INCREMENT=1000;


Quite honestly, your ID field should probably be the primary key, so:

ALTER TABLE users
MODIFY id INT(9) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
AUTO_INCREMENT=1000;

Edward Dudlik
Becoming Digital
www.becomingdigital.com


- Original Message - 
From: "Lilian" <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, 02 June, 2003 02:28
Subject: Re: ALTER TABLE


I have check http://www.mysql.com/doc/en/ALTER_TABLE_problems.html but no
solution for my problem.

I have table_name 'users' (TYPE=InnoDB)  with one of field id

  id int(9) unsigned NOT NULL auto_increment,

when I update last insert id to 1000 , mysql 3 add next data automatically
with 1001, 1002 etc.
version 4 add data with id 3, 4 etc, it not check the value of last ID.

I want to know if there are some solution, I need to start that ID from 1000
not from 1.

lilian



- Original Message -
From: "Becoming Digital" <[EMAIL PROTECTED]>
To: "Lilian" <[EMAIL PROTECTED]>
Sent: Monday, June 02, 2003 9:04 AM
Subject: Re: ALTER TABLE


> Did you check http://www.mysql.com/doc/en/ALTER_TABLE_problems.html for
info?
>
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
>
>
> - Original Message -
> From: "Lilian" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, 02 June, 2003 01:17
> Subject: ALTER TABLE
>
>
> Hi,
> I have tested that function
>
> ALTER TABLE table_name_here AUTO_INCREMENT = 1000;
>
> on version 4.0.12 and it's not working.
> (table TYPE=InnoDB)
>
> in 3.23.54 that is OK
>
> does anybody know what's wrong here?
>
> regards,
> lilian
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: QUESTION ABOUT DATA AND INDEX FILE DIRECTORIES

2003-06-02 Thread Ares Liu

I use MySQL AB released win32 binary package. i don't know if it used --skip-symlink 
option. And after I added an entry skip-symlink=false in my.cnf, I can't start mysqld 
unfortunately.

-Ares

On 02 Jun 2003 14:15 CST you wrote:

> >From the Manual:
> By using DATA DIRECTORY="directory" or INDEX DIRECTORY="directory" you can
> specify where the storage engine should put it's table and index files. Note
> that the directory should be a full path to the directory (not relative path).
> This only works for MyISAM tables in MySQL 4.0, when you are not using
> the --skip-symlink option.
> 
> Make sure that option is set correctly.
> 
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
> 
> 
> - Original Message -
> From: "Ares Liu" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, 02 June, 2003 16:03
> Subject: QUESTION ABOUT DATA AND INDEX FILE DIRECTORIES
> 
> 
> HI, ALL
> 
> Under windows XP, mysql-4.0.12, when I create a table with special data and
> index directories as follow:
> 
> USE DATABASE test;
> 
> CREAT TABLE IF NOT EXISTS test_table ( Vola INT NOT NULL, PRIMARY KEY (Vola))
>DATA DIRECTORY="D:/mySQLDBs/test/data"
>INDEX DIRECTORY="D:/mySQLDBs/test/index";
> 
> It show test_table created successfully in mysql client.
> But really, mysqld creats table test_table with three table files
> test_table.frm, test_table.MYD, and test_table.MYI in D:\mySQLDBs directory. In
> addition, I defined "datadir=d:/mySQLDBs" in my.cnf.
> 
> Who can tell me why this happened? And how can I put the data file and index
> file to where I want to allocate without links.
> 
> -Ares
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fwd: Encoding problem (JDBC, mysql)

2003-06-02 Thread Venkata Srinivasa Rao, Yerra



Dear All,
I have
fixed the problem by my self. I just specify the character encoding as
follows
jdbc:mysql://myserver:3306/mydatabase?useUnicode=true&characterEncoding=UTF8
Thanks for
your time.
Best Regards,
Srinivas.
Mailing-List: contact
[EMAIL PROTECTED]; run by ezmlm
List-ID: 
List-Help:

List-Unsubscribe:

List-Post:

Delivered-To: mailing list [EMAIL PROTECTED]
X-Sender: [EMAIL PROTECTED]
X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9
Date: Mon, 02 Jun 2003 14:21:54 +0800
To: [EMAIL PROTECTED]
From: "Venkata Srinivasa Rao, Yerra"
<[EMAIL PROTECTED]>
Subject: Encoding problem (JDBC, mysql)
X-Spam-Check-By: lists.mysql.com
X-Spam: False ; 3.3 / 5.0
Dear All,
I am
facing encoding problem with JDBC, mysql.  I
can't insert/select Big5 text with JDBC connection. After I insert Big5
text, it becomes question marks () in the database. Before I insert
Big5 text to mysql db, I am converting web browser post data from
"8859_1"
to Big5 encoding. While fetching data from the database, I am
converting to Big5 (I am expect data from the database is Unicode).


Any kind
of help will be appreciated. Here is my environment & its
settings.
MYSQL:
mysql  Ver 12.20 Distrib 4.0.13, for pc-linux (i686)
Server version:
4.0.13-standard-log
Protocol version:   10
Connection:
Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX
socket:   
/tmp/mysql.sock
JAVA:
java version "1.4.1_02"
Java(TM) 2 Runtime Environment, Standard Edition (build
1.4.1_02-b06)
Java HotSpot(TM) Client VM (build 1.4.1_02-b06, mixed mode)
JDBC:
Driver Jar : mysql-connector-java-3.0.8-stable-bin.jar
DB_URL 
= jdbc:mysql://myserver:3306/mydb
DRIVER_CLASS_NAME   =
org.gjt.mm.mysql.Driver
Tomcat: jakarta-tomcat-4.1.24-LE-jdk14

Thanks in advance.
Best Regards,
Srinivas. 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
(http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 6/1/2003

-- 
MySQL General Mailing List
For list archives:
http://lists.mysql.com/mysql
To unsubscribe:   
http://lists.mysql.com/[EMAIL PROTECTED]

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system
(http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date:
6/1/2003



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 6/1/2003

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ALTER TABLE

2003-06-02 Thread Lilian

I have check http://www.mysql.com/doc/en/ALTER_TABLE_problems.html but no
solution for my problem.

I have table_name 'users' (TYPE=InnoDB)  with one of field id

  id int(9) unsigned NOT NULL auto_increment,

when I update last insert id to 1000 , mysql 3 add next data automatically
with 1001, 1002 etc.
version 4 add data with id 3, 4 etc, it not check the value of last ID.

I want to know if there are some solution, I need to start that ID from 1000
not from 1.

lilian



- Original Message -
From: "Becoming Digital" <[EMAIL PROTECTED]>
To: "Lilian" <[EMAIL PROTECTED]>
Sent: Monday, June 02, 2003 9:04 AM
Subject: Re: ALTER TABLE


> Did you check http://www.mysql.com/doc/en/ALTER_TABLE_problems.html for
info?
>
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
>
>
> - Original Message -
> From: "Lilian" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, 02 June, 2003 01:17
> Subject: ALTER TABLE
>
>
> Hi,
> I have tested that function
>
> ALTER TABLE table_name_here AUTO_INCREMENT = 1000;
>
> on version 4.0.12 and it's not working.
> (table TYPE=InnoDB)
>
> in 3.23.54 that is OK
>
> does anybody know what's wrong here?
>
> regards,
> lilian
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Encoding problem (JDBC, mysql)

2003-06-02 Thread Venkata Srinivasa Rao, Yerra



Dear All,
I am
facing encoding problem with JDBC, mysql.  I
can't insert/select Big5 text with JDBC connection. After I insert Big5
text, it becomes question marks () in the database. Before I insert
Big5 text to mysql db, I am converting web browser post data from
"8859_1"
to Big5 encoding. While fetching data from the database, I am
converting to Big5 (I am expect data from the database is Unicode).


Any kind
of help will be appreciated. Here is my environment & its
settings.
MYSQL:
mysql  Ver 12.20 Distrib 4.0.13, for pc-linux (i686)
Server version:
4.0.13-standard-log
Protocol version:   10
Connection:
Localhost via UNIX socket
Client characterset:    latin1
Server characterset:    latin1
UNIX
socket:   
/tmp/mysql.sock
JAVA:
java version "1.4.1_02"
Java(TM) 2 Runtime Environment, Standard Edition (build
1.4.1_02-b06)
Java HotSpot(TM) Client VM (build 1.4.1_02-b06, mixed mode)
JDBC:
Driver Jar : mysql-connector-java-3.0.8-stable-bin.jar
DB_URL 
= jdbc:mysql://myserver:3306/mydb
DRIVER_CLASS_NAME   =
org.gjt.mm.mysql.Driver
Tomcat: jakarta-tomcat-4.1.24-LE-jdk14

Thanks in advance.
Best Regards,
Srinivas. 



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 6/1/2003

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: QUESTION ABOUT DATA AND INDEX FILE DIRECTORIES

2003-06-02 Thread Becoming Digital

>From the Manual:
By using DATA DIRECTORY="directory" or INDEX DIRECTORY="directory" you can
specify where the storage engine should put it's table and index files. Note
that the directory should be a full path to the directory (not relative path).
This only works for MyISAM tables in MySQL 4.0, when you are not using
the --skip-symlink option.

Make sure that option is set correctly.

Edward Dudlik
Becoming Digital
www.becomingdigital.com


- Original Message -
From: "Ares Liu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, 02 June, 2003 16:03
Subject: QUESTION ABOUT DATA AND INDEX FILE DIRECTORIES


HI, ALL

Under windows XP, mysql-4.0.12, when I create a table with special data and
index directories as follow:

USE DATABASE test;

CREAT TABLE IF NOT EXISTS test_table ( Vola INT NOT NULL, PRIMARY KEY (Vola))
   DATA DIRECTORY="D:/mySQLDBs/test/data"
   INDEX DIRECTORY="D:/mySQLDBs/test/index";

It show test_table created successfully in mysql client.
But really, mysqld creats table test_table with three table files
test_table.frm, test_table.MYD, and test_table.MYI in D:\mySQLDBs directory. In
addition, I defined "datadir=d:/mySQLDBs" in my.cnf.

Who can tell me why this happened? And how can I put the data file and index
file to where I want to allocate without links.

-Ares

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

QUESTION ABOUT DATA AND INDEX FILE DIRECTORIES

2003-06-02 Thread Ares Liu

HI, ALL

Under windows XP, mysql-4.0.12, when I create a table with special data and index 
directories as follow:

USE DATABASE test;

CREAT TABLE IF NOT EXISTS test_table ( Vola INT NOT NULL, PRIMARY KEY (Vola)) 
   DATA DIRECTORY="D:/mySQLDBs/test/data" 
   INDEX DIRECTORY="D:/mySQLDBs/test/index";

It show test_table created successfully in mysql client.
But really, mysqld creats table test_table with three table files test_table.frm, 
test_table.MYD, and test_table.MYI in D:\mySQLDBs directory. In addition, I defined 
"datadir=d:/mySQLDBs" in my.cnf.

Who can tell me why this happened? And how can I put the data file and index file to 
where I want to allocate without links.

-Ares

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ALTER TABLE

2003-06-02 Thread Lilian

Hi,
I have tested that function 

ALTER TABLE table_name_here AUTO_INCREMENT = 1000;

on version 4.0.12 and it's not working.
(table TYPE=InnoDB)

in 3.23.54 that is OK

does anybody know what's wrong here?

regards,
lilian

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MYSQL Documentation

2003-06-02 Thread Nils Valentin

Hello Mysql List members,

I am about to create some documents which I feel are not "so" complete 
documented until now.

It's not a lot right now. I ceate a table comparison chart and a MySQL error 
code listing (in text format) which you could use to lookup Client and Server 
errors. Table or OS errors still will need to be added.

I was hoping that somebody else might find it useful as well.
There is no eye candy etc. - its really just the plain information.

http://www.knowd.co.jp/staff/nils/

Best regards
-- 

Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: SELECTing last occurences from a table

2003-06-02 Thread Gordon

It is possible if you make the number of digits in day all the same by
using something like lpad. 
The secret is to tie all of the values you want together with something
like CONCAT and making sure that
the resulting string sorts in the order you want with its alphabetic
sort sequence. Then MAX gives you
the largest {most recent} value and then substring_index breaks it back
apart. The other bit of magic is
to remember that with MySQL the fields you use to GROUP BY {food.name in
this case} does not have to be 
included in the SELECT. In this case name is not the same as food.name
and probably should be aliased 
something like 'recent_name' to avoid confusion.

select
substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',id,'|',price)),'
|',1) + 0 as day,
 
substring_index(substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',
id,'|',price)),'|',2),'|',-1) as name,
 
substring_index(substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',
id,'|',price)),'|',3),'|',-1) as id,
 
substring_index(substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',
id,'|',price)),'|',4),'|',-1) as price 
from   food 
group by food.name;

mysql> create table food (id int(11) not null primary key, name
char(20), day int(11), price decimal(10,2));
Query OK, 0 rows affected (0.07 sec)

mysql> insert into food
-> values
-> (1, 'tomatoes', 1, 25),
-> (2, 'onions', 1, 13),
-> (3, 'onions', 2, 16),
-> (4, 'tomatoes', 2, 30);
Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> select * from food;
++--+--+---+
| id | name | day  | price |
++--+--+---+
|  1 | tomatoes |1 | 25.00 |
|  2 | onions   |1 | 13.00 |
|  3 | onions   |2 | 16.00 |
|  4 | tomatoes |2 | 30.00 |
++--+--+---+
4 rows in set (0.00 sec)

mysql> select
substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',id,'|',price)),'
|',1) + 0 as day,
->
substring_index(substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',
id,'|',price)),'|',2),'|',-1) as name,
->
substring_index(substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',
id,'|',price)),'|',3),'|',-1) as id,
->
substring_index(substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',
id,'|',price)),'|',4),'|',-1) as price
-> from   food
-> group by food.name;
+--+--+--+---+
| day  | name | id   | price |
+--+--+--+---+
|2 | onions   | 3| 16.00 |
|2 | tomatoes | 4| 30.00 |
+--+--+--+---+
2 rows in set (0.00 sec)

Also works when foods are last updated on different days

mysql> update food set day = 3 where id = 4;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select
substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',id,'|',price)),'
|',1) + 0 as day,
->
substring_index(substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',
id,'|',price)),'|',2),'|',-1) as name,
->
substring_index(substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',
id,'|',price)),'|',3),'|',-1) as id,
->
substring_index(substring_index(max(concat(lpad(day,4,'0'),'|',name,'|',
id,'|',price)),'|',4),'|',-1) as price
-> from   food
-> group by food.name;
+--+--+--+---+
| day  | name | id   | price |
+--+--+--+---+
|2 | onions   | 3| 16.00 |
|3 | tomatoes | 4| 30.00 |
+--+--+--+---+
2 rows in set (0.00 sec)

> -Original Message-
> From: Becoming Digital [mailto:[EMAIL PROTECTED] 
> Sent: Sunday, June 01, 2003 5:29 PM
> To: [EMAIL PROTECTED]
> Subject: Re: SELECTing last occurences from a table
> 
> 
> Do you have daily prices for a set number number of foods?  If so, try
> 
> SELECT * FROM food
> LIMIT n,-1;
> 
> where n is the number of items.  There's probably a better 
> way to do it in SQL, I just don't know how.  If you are using 
> PHP, that's another story.
> 
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
> 
> 
> - Original Message -
> From: "Mateusz" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, 01 June, 2003 15:38
> Subject: SELECTing last occurences from a table
> 
> 
> Hi!
> I couldn't find anything in archives, maybe I search for 
> wrong phrase. I'm running MySQL v.3.23.49 (if it's not 
> possible under this version, I may upgrade it). What I need 
> to accomplish is to find only last occurence of all possible 
> items from given column.
> 
> Supposing:
> 
> idnamedayprice
> ---
> 1tomatoes125
> 2onions113
> 3onions216
> 4tomatoes230
> 
> I want to obtain only:
> 
> 3onions216(latest price of onions - 
> from day 2nd)
> 4tomatoes230(latest price of tomatoes - 
> from day 2nd)
> 
> How to do that? (in as little selects as possible)
> Thanks for any help!
> 
> Mateu

confusion clearing up

2003-06-02 Thread trogers

Ok, list friends... I think I get it.  My tables are ALREADY populated 
except for a Foreign Key column.

What I think I "get" is that there is no way that the DB can possibly 
know or be told which row from the master table to insert/correspond 
(Foreign Key) to which row(s) in the slave ("many") table.  This *must* 
be done manually.  Either by creating a text file or whatever makes it 
easier, but you can't do it with SQL because there is no relationship 
or correspondence established yet, that is exactly what I'm trying to 
do.
Right?

Ted

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: becoming unconfused

2003-06-02 Thread trogers

I appreciate this and I have read it several times, the problem is it 
ain't easy to find a practical example, one with real data.  That would 
I could figure out what "symbol" was.  In fact what I am doing now is 
trying to build a small DB so I can learn these things --the books and 
I've got lots of them, just don't make it easy to find practical info.  
Name the book and I probably have it.  But they don't show me how to 
get the data in there --from PK of one table to FK of another.  This is 
a close as I've come:
[CONSTRAINT symbol] FOREIGN KEY (studentID)
  REFERENCES table2 (studentID)
  [ON DELETE {CASCADE | SET NULL | NO ACTION
  | RESTRICT}]
  [ON UPDATE {CASCADE | SET NULL | NO ACTION
  | RESTRICT}]

But I don't find [quickly] what, say, "symbol" is.  I searched the 
manual for "Constraint symbol" and got the same page I was looking at.

:-(

Ted

On Sunday, June 1, 2003, at 10:11 PM, Becoming Digital wrote:

Check out the InnoDB reference in the MySQL manual.
http://www.mysql.com/doc/en/InnoDB.html
Here's the section Foreign Key Constraints
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
Good luck.

Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 21:48
Subject: Re: becoming unconfused
I just came from the bookstore where I perused "Mastering MySQL 4".
Specifically, I wanted to know how to specify a Foreign Key.  After a
thorough, albeit short lived search, and reading every page the index
on "Foreign Key" pointed to, I deduced that all one needs do is put the
blasted field (primary key from other table) into the "many" (re
:appropriate) table.  That there was no "identifier" like there is a
Primary Key.
Ok, my last puzzlement --for now-- is, let me illustrate:

table1 table2
studentID -->PK  classID -->PK
student_name class_name
   studentID  (foreign key)
Simple (yes I'm slow, yes it's a problem) question:  how does the
studentID field in table2 get populated?
Thanks in Advance,
Ted
On Sunday, June 1, 2003, at 06:32 PM, Becoming Digital wrote:

The way I was taught, in my limited education, was simply to have,
say,
the people_id also appear in table2 as a Foreign Key, that tis would
serve to relate the tables.  Now I've been advised that the way to do
this is NOT like that, but to have a third, linking, table
In my opinion, you've been wrongly advised.  I would follow your
original
instinct and use a one->many relationship for people to machines.
Using a third
table is just going to complicate things and goes against the concepts
of
normalized data.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 15:59
Subject: Re: Inserting data?
I'd be glad to share.. you mean what the db is supposed to be?  Ok,
there are 3 tables:
table1 = people, people_id = primary key
table2 = machines, machines_id = primary key
One person can have many machines, one machine can only be assigned to
one person.
The way I was taught, in my limited education, was simply to have, 
say,
the people_id also appear in table2 as a Foreign Key, that tis would
serve to relate the tables.  Now I've been advised that the way to do
this is NOT like that, but to have a third, linking, table where there
are 2 fields: one is the people_id (primary key from table1) and the
other is the machines_id (primary key from table2).

I was asking how to write a SQL statement to populate that third table
from the data already in/from the other 2.
Any other comments about this are welcome.

Thanks,
Ted
On Sunday, June 1, 2003, at 10:53 AM, Becoming Digital wrote:

You need a constraint on the data to be inserted into the second
table.  Care to
share what that is supposed to be?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 03:17
Subject: Inserting data?
I have a table, in the table is a field called  name_id; in a second
table (a linking table) I also have the field name_id, this should be
the same/reference the same name_id as in the first table.
The first table is fully populated.  How do write a SQL statement to
get the data from the name_id field of table1 into the name_id field
of
table2?
(I'll do this and find out after if it actually references the same
data!  So, if it doesn't at least I'll have learned the proper SQL
statement. :)
Thank you,
Ted Rogers

Re: Problems installing DBD::mysql for My SQL 4

2003-06-02 Thread Ryan Yagatich

I believe the package you are looking for is

zlib-devel

The latest version from redhat is available at
http://updates.redhat.com/8.0/en/os/i386/zlib-devel-1.1.4-8.8x.i386.rpm

Thanks,
Ryan Yagatich

,_,
\ Ryan Yagatich [EMAIL PROTECTED] \
/ Pantek Incorporated  (877) LINUX-FIX /
\ http://www.pantek.com/security(440) 519-1802 \
/   Are your networks secure? Are you certain? /
\___9C80D881D4D379058537BE21F52F14FA6354C11AC57734FB___\


On Sun, 2003-06-01 at 21:21, James Marcinek wrote:


> 1.) You may try to remove the -lz or -lgz flag from the libs list
> by using the --libs switch for "perl Makefile.PL".
> 2.) On Red Hat Linux install libz-devel
> 3.) On other systems, please contact the mailing list
> 

> Can anyone help me out here?
> 
> Thanks,
> 
> James


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: swapping data

2003-06-02 Thread Becoming Digital

Why do you need to do that?  If all that matters is which column the data is,
use ALTER TABLE to rename them.

Edward Dudlik
Becoming Digital
www.becomingdigital.com


- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 22:18
Subject: swapping data


how can I swap the data between to columns in the same table?

Ted


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: becoming unconfused

2003-06-02 Thread trogers

Thanks, so is this correct, do I run this on table1?

table1   table2
studentID -->PK  classID -->PK
student_name class_name
  studentID  (foreign key)
[CONSTRAINT symbol] FOREIGN KEY (studentID)
  REFERENCES table2 (studentID)
  [ON DELETE {CASCADE | SET NULL | NO ACTION
  | RESTRICT}]
  [ON UPDATE {CASCADE | SET NULL | NO ACTION
  | RESTRICT}]
??
Ted
On Sunday, June 1, 2003, at 10:11 PM, Becoming Digital wrote:

Check out the InnoDB reference in the MySQL manual.
http://www.mysql.com/doc/en/InnoDB.html
Here's the section Foreign Key Constraints
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
Good luck.

Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 21:48
Subject: Re: becoming unconfused
I just came from the bookstore where I perused "Mastering MySQL 4".
Specifically, I wanted to know how to specify a Foreign Key.  After a
thorough, albeit short lived search, and reading every page the index
on "Foreign Key" pointed to, I deduced that all one needs do is put the
blasted field (primary key from other table) into the "many" (re
:appropriate) table.  That there was no "identifier" like there is a
Primary Key.
Ok, my last puzzlement --for now-- is, let me illustrate:

table1 table2
studentID -->PK  classID -->PK
student_name class_name
   studentID  (foreign key)
Simple (yes I'm slow, yes it's a problem) question:  how does the
studentID field in table2 get populated?
Thanks in Advance,
Ted
On Sunday, June 1, 2003, at 06:32 PM, Becoming Digital wrote:

The way I was taught, in my limited education, was simply to have,
say,
the people_id also appear in table2 as a Foreign Key, that tis would
serve to relate the tables.  Now I've been advised that the way to do
this is NOT like that, but to have a third, linking, table
In my opinion, you've been wrongly advised.  I would follow your
original
instinct and use a one->many relationship for people to machines.
Using a third
table is just going to complicate things and goes against the concepts
of
normalized data.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 15:59
Subject: Re: Inserting data?
I'd be glad to share.. you mean what the db is supposed to be?  Ok,
there are 3 tables:
table1 = people, people_id = primary key
table2 = machines, machines_id = primary key
One person can have many machines, one machine can only be assigned to
one person.
The way I was taught, in my limited education, was simply to have, 
say,
the people_id also appear in table2 as a Foreign Key, that tis would
serve to relate the tables.  Now I've been advised that the way to do
this is NOT like that, but to have a third, linking, table where there
are 2 fields: one is the people_id (primary key from table1) and the
other is the machines_id (primary key from table2).

I was asking how to write a SQL statement to populate that third table
from the data already in/from the other 2.
Any other comments about this are welcome.

Thanks,
Ted
On Sunday, June 1, 2003, at 10:53 AM, Becoming Digital wrote:

You need a constraint on the data to be inserted into the second
table.  Care to
share what that is supposed to be?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 03:17
Subject: Inserting data?
I have a table, in the table is a field called  name_id; in a second
table (a linking table) I also have the field name_id, this should be
the same/reference the same name_id as in the first table.
The first table is fully populated.  How do write a SQL statement to
get the data from the name_id field of table1 into the name_id field
of
table2?
(I'll do this and find out after if it actually references the same
data!  So, if it doesn't at least I'll have learned the proper SQL
statement. :)
Thank you,
Ted Rogers

RE: mysql/innodb and the 2GB limit

2003-06-02 Thread Kieran Kelleher

What platform and hardware spec are you using?

-Original Message-
From: Per Andreas Buer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 2003 1:48 PM
To: [EMAIL PROTECTED]
Subject: mysql/innodb and the 2GB limit

Hi.

Lately, I've been banging against the glibc 2GB malloc limit - what a
headache. :/

I believe this is not a mysql-specific problem, so a might be a bit off
topic here. Does anyone know of a way to work around this limit? Does
Redhat Advanced Server also have this problem? Or Suse Enterprise?

--
Per Andreas Buer
mysql, query

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Inserting data?

2003-06-02 Thread Nils Valentin

Hi Ted,

I believe that there is no easy right wrong answer here. Your question is to 
general to be ale to answer it correctly. The correct table format depends 
STRONGLY on how you want to use your data and which SELECT requests you will 
use.

It might make sense to put all data in 1 table in case you want to formulate a 
"simple" SELECT statement - however this will give you restrictions when the 
table grows -menaing you might have the same information which you need to 
update for originally a single record.

If you split your data so that you use f.e. 3 tables, making sure that each 
information is inserted only once than this is absolutely fine in the way of 
optimizing your data for the Normal forms (1-6), however this will make a 
SELECT statement more complicated as you will need to request the data from 
several tables. The advantae would be in case of updating any data record , 
you will have to update this only once, while in the previous sample you will 
have to update it several times (time consuming). While this is a complex 
topic I would suggest to read some articles from www.devshed.com about 
database normalization


Best regards

Nils Valentin
Tokyo/Japan
 


2003年 6月 2日 月曜日 07:32、Becoming Digital さんは書きました:
> > The way I was taught, in my limited education, was simply to have, say,
> > the people_id also appear in table2 as a Foreign Key, that tis would
> > serve to relate the tables.  Now I've been advised that the way to do
> > this is NOT like that, but to have a third, linking, table
>
> In my opinion, you've been wrongly advised.  I would follow your original
> instinct and use a one->many relationship for people to machines.  Using a
> third table is just going to complicate things and goes against the
> concepts of normalized data.
>
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
>
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Becoming Digital" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Sunday, 01 June, 2003 15:59
> Subject: Re: Inserting data?
>
>
> I'd be glad to share.. you mean what the db is supposed to be?  Ok,
> there are 3 tables:
> table1 = people, people_id = primary key
> table2 = machines, machines_id = primary key
> One person can have many machines, one machine can only be assigned to
> one person.
> The way I was taught, in my limited education, was simply to have, say,
> the people_id also appear in table2 as a Foreign Key, that tis would
> serve to relate the tables.  Now I've been advised that the way to do
> this is NOT like that, but to have a third, linking, table where there
> are 2 fields: one is the people_id (primary key from table1) and the
> other is the machines_id (primary key from table2).
>
> I was asking how to write a SQL statement to populate that third table
> from the data already in/from the other 2.
>
> Any other comments about this are welcome.
>
> Thanks,
> Ted
>
> On Sunday, June 1, 2003, at 10:53 AM, Becoming Digital wrote:
> > You need a constraint on the data to be inserted into the second
> > table.  Care to
> > share what that is supposed to be?
> >
> > Edward Dudlik
> > Becoming Digital
> > www.becomingdigital.com
> >
> >
> > - Original Message -
> > From: <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Sunday, 01 June, 2003 03:17
> > Subject: Inserting data?
> >
> >
> > I have a table, in the table is a field called  name_id; in a second
> > table (a linking table) I also have the field name_id, this should be
> > the same/reference the same name_id as in the first table.
> >
> > The first table is fully populated.  How do write a SQL statement to
> > get the data from the name_id field of table1 into the name_id field of
> > table2?
> >
> > (I'll do this and find out after if it actually references the same
> > data!  So, if it doesn't at least I'll have learned the proper SQL
> > statement. :)
> >
> > Thank you,
> > Ted Rogers
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
> http://lists.mysql.com/[EMAIL PROTECTED]

-- 

Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

swapping data

2003-06-02 Thread trogers

how can I swap the data between to columns in the same table?

Ted

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECTing last occurences from a table

2003-06-02 Thread Becoming Digital

This would return only the most recently updated rows, excluding, from the
poster's example, the onion prices from Day 1.

Edward Dudlik
Becoming Digital
www.becomingdigital.com


- Original Message -
From: "Nils Valentin" <[EMAIL PROTECTED]>
To: "Mateusz" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 22:10
Subject: Re: SELECTing last occurences from a table


In this case you would need to add a timestamp and check for the latest
timestamp. This price should be taken for your query. Something like

SELECT * FROM food WHERE timestamp(MAX);


Thats my guess - anybody please correct me if I talk rubbish here


Best regards

Nils Valentin
Tokyo/Japan

2003年 6月 2日 月曜日 08:17、Mateusz さんは書きました:
> That'd be the solution, but unfortunately i gave You incorrect example (too
> little rows):
> the problem is I don't have a constant number of foods. For example the
> latest price of tomatoes could be from day 20 but the last price of
> potatoes might be from day 19, and for onions from day 1. I need single
> most recent row for each type of food that has appeared in database.
>
> - Original Message -
> From: "Becoming Digital" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, June 02, 2003 12:28 AM
> Subject: Re: SELECTing last occurences from a table
>
> > Do you have daily prices for a set number number of foods?  If so, try
> >
> > SELECT * FROM food
> > LIMIT n,-1;
> >
> > where n is the number of items.  There's probably a better way to do it
> > in
>
> SQL,
>
> > I just don't know how.  If you are using PHP, that's another story.

--

Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECTing last occurences from a table

2003-06-02 Thread Becoming Digital

It seems to me that you have two options:

1) Insert the price for each item every day and use a SELECT similar to that
which I posted.
2) Use different tables for each food if you don't like (1)

Your request, while easy on the surface, is not so easy when the dates differ
and you aren't using a scripting language.

Edward Dudlik
Becoming Digital
www.becomingdigital.com


- Original Message -
From: "Mateusz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 19:55
Subject: Re: SELECTing last occurences from a table


> SELECT * FROM myTable ORDER BY COLUMN_WHICH_CONTAINS_INSERTED_DATE ASC
LIMIT
> 1;
> COLUMN_WHICH_CONTAINS_INSERTED_DATE is a column which contains the date
that
> the record was inserted

This would only select one row (the most recent). I need a set of rows, one
for _each_ type of food (one and only one for tomatoes, one and only one for
potatoes and so on).

Mateusz Uzdowski


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECTing last occurences from a table

2003-06-02 Thread Nils Valentin

I believe you are at minimum talking about a subselect command here.

I am just about to get the idea what you really want. You want to request all 
updated prices f.e. to show a pricelist with the newest prices.

I guess thats to high for me to reach right now - but definitely interesting 
;-)

Best regards

Nils Valentin
Tokyo/Japan


2003年 6月 2日 月曜日 08:55、Mateusz さんは書きました:
> > SELECT * FROM myTable ORDER BY COLUMN_WHICH_CONTAINS_INSERTED_DATE ASC
>
> LIMIT
>
> > 1;
> > COLUMN_WHICH_CONTAINS_INSERTED_DATE is a column which contains the date
>
> that
>
> > the record was inserted
>
> This would only select one row (the most recent). I need a set of rows, one
> for _each_ type of food (one and only one for tomatoes, one and only one
> for potatoes and so on).
>
> Mateusz Uzdowski

-- 

Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: becoming unconfused

2003-06-02 Thread Becoming Digital

Check out the InnoDB reference in the MySQL manual.
http://www.mysql.com/doc/en/InnoDB.html

Here's the section Foreign Key Constraints
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html

Good luck.

Edward Dudlik
Becoming Digital
www.becomingdigital.com


- Original Message - 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 21:48
Subject: Re: becoming unconfused


I just came from the bookstore where I perused "Mastering MySQL 4".  
Specifically, I wanted to know how to specify a Foreign Key.  After a 
thorough, albeit short lived search, and reading every page the index 
on "Foreign Key" pointed to, I deduced that all one needs do is put the 
blasted field (primary key from other table) into the "many" (re 
:appropriate) table.  That there was no "identifier" like there is a 
Primary Key.

Ok, my last puzzlement --for now-- is, let me illustrate:

table1 table2
studentID -->PK  classID -->PK
student_name class_name
   studentID  (foreign key)

Simple (yes I'm slow, yes it's a problem) question:  how does the 
studentID field in table2 get populated?

Thanks in Advance,
Ted


On Sunday, June 1, 2003, at 06:32 PM, Becoming Digital wrote:

>> The way I was taught, in my limited education, was simply to have, 
>> say,
>> the people_id also appear in table2 as a Foreign Key, that tis would
>> serve to relate the tables.  Now I've been advised that the way to do
>> this is NOT like that, but to have a third, linking, table
>
> In my opinion, you've been wrongly advised.  I would follow your 
> original
> instinct and use a one->many relationship for people to machines.  
> Using a third
> table is just going to complicate things and goes against the concepts 
> of
> normalized data.
>
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
>
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: "Becoming Digital" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Sunday, 01 June, 2003 15:59
> Subject: Re: Inserting data?
>
>
> I'd be glad to share.. you mean what the db is supposed to be?  Ok,
> there are 3 tables:
> table1 = people, people_id = primary key
> table2 = machines, machines_id = primary key
> One person can have many machines, one machine can only be assigned to
> one person.
> The way I was taught, in my limited education, was simply to have, say,
> the people_id also appear in table2 as a Foreign Key, that tis would
> serve to relate the tables.  Now I've been advised that the way to do
> this is NOT like that, but to have a third, linking, table where there
> are 2 fields: one is the people_id (primary key from table1) and the
> other is the machines_id (primary key from table2).
>
> I was asking how to write a SQL statement to populate that third table
> from the data already in/from the other 2.
>
> Any other comments about this are welcome.
>
> Thanks,
> Ted
>
> On Sunday, June 1, 2003, at 10:53 AM, Becoming Digital wrote:
>
>> You need a constraint on the data to be inserted into the second
>> table.  Care to
>> share what that is supposed to be?
>>
>> Edward Dudlik
>> Becoming Digital
>> www.becomingdigital.com
>>
>>
>> - Original Message -
>> From: <[EMAIL PROTECTED]>
>> To: <[EMAIL PROTECTED]>
>> Sent: Sunday, 01 June, 2003 03:17
>> Subject: Inserting data?
>>
>>
>> I have a table, in the table is a field called  name_id; in a second
>> table (a linking table) I also have the field name_id, this should be
>> the same/reference the same name_id as in the first table.
>>
>> The first table is fully populated.  How do write a SQL statement to
>> get the data from the name_id field of table1 into the name_id field 
>> of
>> table2?
>>
>> (I'll do this and find out after if it actually references the same
>> data!  So, if it doesn't at least I'll have learned the proper SQL
>> statement. :)
>>
>> Thank you,
>> Ted Rogers


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fulltext indexing/searching of Unicode fields

2003-06-02 Thread Visontay Peter

Hello!

I'm building a database that will have tables containing UTF-8-encoded
text, and I want to use full-text indexing and searching for these
fields.

The aim would be that I should be able to index the UTF-8 text, and
then search it accent-insensitively - that is, a search query for
"cliche" should find texts containing "cliche" and "cliché", as well.

The problem is, that as far as I know, MySQL doesn't support the
full-text indexing of UTF-8 (or any other multibyte encoding) text.

Can you help me with this problem? It doesn't need to be MySQL-specific,
as this is a totally general problem, affecting most database systems :|

One possible solution would be to store every text twice - one
version with accents, and one without them, indexing and searching
the latter. But this would be an ugly redundancy, making data
handling and manipulating more difficult. Is there a better
solution?

Regards,
Peter
http://prodigycenter.com/cv

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECTing last occurences from a table

2003-06-02 Thread Nils Valentin

In this case you would need to add a timestamp and check for the latest 
timestamp. This price should be taken for your query. Something like

SELECT * FROM food WHERE timestamp(MAX);


Thats my guess - anybody please correct me if I talk rubbish here


Best regards

Nils Valentin
Tokyo/Japan

2003年 6月 2日 月曜日 08:17、Mateusz さんは書きました:
> That'd be the solution, but unfortunately i gave You incorrect example (too
> little rows):
> the problem is I don't have a constant number of foods. For example the
> latest price of tomatoes could be from day 20 but the last price of
> potatoes might be from day 19, and for onions from day 1. I need single
> most recent row for each type of food that has appeared in database.
>
> - Original Message -
> From: "Becoming Digital" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, June 02, 2003 12:28 AM
> Subject: Re: SELECTing last occurences from a table
>
> > Do you have daily prices for a set number number of foods?  If so, try
> >
> > SELECT * FROM food
> > LIMIT n,-1;
> >
> > where n is the number of items.  There's probably a better way to do it
> > in
>
> SQL,
>
> > I just don't know how.  If you are using PHP, that's another story.

-- 

Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query problem

2003-06-02 Thread Nils Valentin

Hi everybody,


I hope ASAFP stands for something like AS Soon AS Feasable Possible ;-)

We are not going to swear are we ?

Best regards

Nils Valentin

2003年 6月 2日 月曜日 07:30、Sparky Kopetzky さんは書きました:
> I have a view I need to create from several tables where I'm looking up one
> value from a table and need to add it to the Select stmt like this:
>
> SELECT sex (SELECT yes_no_meaning FROM yes_no WHERE yes_no_id =
> bite.bite_animal_sex_id),
>type (SELECT type_meaning FROM type WHERE type_id =
> bite.bite_type_id), etc...
>
> However, I haven't found an example of how to do this and I need this
> ASAFP!!
>
> Apreciate any help.
>
> Robin E. Kopetzky
> Black Mesa Computers/Internet Services
> www.blackmesa-isp.net

-- 

Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: becoming unconfused

2003-06-02 Thread trogers

I just came from the bookstore where I perused "Mastering MySQL 4".  
Specifically, I wanted to know how to specify a Foreign Key.  After a 
thorough, albeit short lived search, and reading every page the index 
on "Foreign Key" pointed to, I deduced that all one needs do is put the 
blasted field (primary key from other table) into the "many" (re 
:appropriate) table.  That there was no "identifier" like there is a 
Primary Key.

Ok, my last puzzlement --for now-- is, let me illustrate:

table1  table2
studentID -->PK  classID -->PK
student_name class_name
  studentID  (foreign key)
Simple (yes I'm slow, yes it's a problem) question:  how does the 
studentID field in table2 get populated?

Thanks in Advance,
Ted
On Sunday, June 1, 2003, at 06:32 PM, Becoming Digital wrote:

The way I was taught, in my limited education, was simply to have, 
say,
the people_id also appear in table2 as a Foreign Key, that tis would
serve to relate the tables.  Now I've been advised that the way to do
this is NOT like that, but to have a third, linking, table
In my opinion, you've been wrongly advised.  I would follow your 
original
instinct and use a one->many relationship for people to machines.  
Using a third
table is just going to complicate things and goes against the concepts 
of
normalized data.

Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 15:59
Subject: Re: Inserting data?
I'd be glad to share.. you mean what the db is supposed to be?  Ok,
there are 3 tables:
table1 = people, people_id = primary key
table2 = machines, machines_id = primary key
One person can have many machines, one machine can only be assigned to
one person.
The way I was taught, in my limited education, was simply to have, say,
the people_id also appear in table2 as a Foreign Key, that tis would
serve to relate the tables.  Now I've been advised that the way to do
this is NOT like that, but to have a third, linking, table where there
are 2 fields: one is the people_id (primary key from table1) and the
other is the machines_id (primary key from table2).
I was asking how to write a SQL statement to populate that third table
from the data already in/from the other 2.
Any other comments about this are welcome.

Thanks,
Ted
On Sunday, June 1, 2003, at 10:53 AM, Becoming Digital wrote:

You need a constraint on the data to be inserted into the second
table.  Care to
share what that is supposed to be?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 03:17
Subject: Inserting data?
I have a table, in the table is a field called  name_id; in a second
table (a linking table) I also have the field name_id, this should be
the same/reference the same name_id as in the first table.
The first table is fully populated.  How do write a SQL statement to
get the data from the name_id field of table1 into the name_id field 
of
table2?

(I'll do this and find out after if it actually references the same
data!  So, if it doesn't at least I'll have learned the proper SQL
statement. :)
Thank you,
Ted Rogers


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problems installing DBD::mysql for My SQL 4

2003-06-02 Thread James Marcinek

I know this isn't the perl list but I'm thinking that some one out there
has installed MySQL 4 on Red Hat 8. I couldn't upgrade from MySQL 3. I
tried to uninstall MySQL 3 but I had too many dependency errors. I keep
trying to install the necessary packages but I have a problem with the
DBD::mysql module with perl. This is preventing me from installing the
MySQL-MAX and the MySQL-SHARED rpms from the MySQL website. Here's what I
keep getting:

LD_RUN_PATH="/usr/lib/mysql:/usr/lib:/lib" /usr/bin/perl myld gcc  -shared
-L/usr/local/lib dbdimp.o mysql.o  -o blib/arch/auto/DBD/mysql/mysql.so  
-L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc -lnss_files
-lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv
/usr/bin/ld: cannot find -lz
collect2: ld returned 1 exit status


An error occurred while linking the DBD::mysql driver. The error
message seems to indicate that you don't have a libz.a, libgz.a,
libz.so or libgz.so. This is typically resolved by:

1.) You may try to remove the -lz or -lgz flag from the libs list
by using the --libs switch for "perl Makefile.PL".
2.) On Red Hat Linux install libz-devel
3.) On other systems, please contact the mailing list

 [EMAIL PROTECTED]

For further hints, see INSTALL.html, section Linker flags.
make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1
  /usr/bin/make  -- NOT OK
Running make test
  Can't test without successful make
Running make install
  make had returned bad status, install seems impossible

Can anyone help me out here?

Thanks,

James

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Find out what version I am using?

2003-06-02 Thread Paul DuBois

At 22:52 -0400 5/31/03, Mehrdad Ziaei wrote:
That will give you version of mysql client you're running,
That seems to have been what the original question was.

For version of mysql server, after successful connection to mysql, use
status command.
mysql> status
Or

telnet to port 3306 of server running mysql
C:\>telnet  192.168.1.2  3306
you'll see few garbage and mysql version number in there too.
Re: that latter suggestion, it's easier to simply issue this query from
the mysql client:
mysql> SHOW VERSION();

Then you don't have to ignore all the garbage characters. :-)

Me

- Original Message -
From: "Steven Kreuzer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Mysql" <[EMAIL PROTECTED]>
Sent: Saturday, May 31, 2003 10:32 PM
Subject: Re: Find out what version I am using?

 $ mysql --version

 On Sat, 2003-05-31 at 22:21, Robert Mark Bram wrote:
 > Howdy all!
 >
 > How do I find out what version of mysql I am running from the command
line?
 >
 > Is there a type of system select statement I can execute?
 >
 > Rob
 > :)
 > :->
 > > :-}

--
Paul DuBois
http://www.kitebird.com/
sql, query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Update query with substring

2003-06-02 Thread jbonnett

You can't have two tables in the UPDATE query, at least not in v3.x of
MySQL. I'm not sure about version 4. That's why it's complaining about
table2. I think the SUBSTRING_INDEX should be OK.

You may have to split your query into a series of queries. There is some
guidance in the MySQL manual.

John Bonnett

-Original Message-
From: Davy Obdam [mailto:[EMAIL PROTECTED]
Sent: Friday, 30 May 2003 6:57 PM
To: MySQL; MySQL-WIN
Subject: Update query with substring


Hello people,

I am trying to run this query:

UPDATE table1, table2 SET table1.periode = table.periode WHERE table1.id 
= 3 AND SUBSTRING_INDEX( table1.name, '.', - 1 ) = table2.name

But i keep getting the same error message

You have an error in your SQL syntax near '
table2 SET table1.periode = table2.periode WHERE table1.id = 3 AND 
SUBSTRIN' at line 1

Is it possible to use a SUBSTRING_INDEX in a update query, or what i am 
i doing wrong?

Any help is appreciated, thanks for your time

Best regards,

Davy Obdam

-- 
---
Davy Obdam 
Web application developer

Networking4all
email: [EMAIL PROTECTED]
email: [EMAIL PROTECTED]
internet: http://www.networking4all.com
---




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECTing last occurences from a table

2003-06-02 Thread Mateusz

> SELECT * FROM myTable ORDER BY COLUMN_WHICH_CONTAINS_INSERTED_DATE ASC
LIMIT
> 1;
> COLUMN_WHICH_CONTAINS_INSERTED_DATE is a column which contains the date
that
> the record was inserted

This would only select one row (the most recent). I need a set of rows, one
for _each_ type of food (one and only one for tomatoes, one and only one for
potatoes and so on).

Mateusz Uzdowski


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query problem

2003-06-02 Thread Gürhan Özen

Hi,
Sounds like you will need to use subqueries which is available at MySQL
4.1 and above ..
See: http://www.mysql.com/doc/en/Nutshell_4.1_features.html
Hope this helps.
Gurhan

On Sun, 2003-06-01 at 18:30, Sparky Kopetzky wrote:
> I have a view I need to create from several tables where I'm looking up one
> value from a table and need to add it to the Select stmt like this:
> 
> SELECT sex (SELECT yes_no_meaning FROM yes_no WHERE yes_no_id =
> bite.bite_animal_sex_id),
>type (SELECT type_meaning FROM type WHERE type_id =
> bite.bite_type_id), etc...
> 
> However, I haven't found an example of how to do this and I need this
> ASAFP!!
> 
> Apreciate any help.
> 
> Robin E. Kopetzky
> Black Mesa Computers/Internet Services
> www.blackmesa-isp.net
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Not A Newbie to Application Development

2003-06-02 Thread Paul G.

Greetings,

Want to submit a patch to mysql.h as I am porting an app which needs to be 
able to access Mysql servers and 
clients.  Environment is a hybrid (not totally win32api, not totally Posix and not 
totally Linux but useable with all of 
those file systems) Msys/Mingw (http://www.mingw.org/).

What is the currently accepted practice when it comes to submitting patches 
and getting those patches applied to 
the Bitmover repository?

Thanks,

Paul G.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECTing last occurences from a table

2003-06-02 Thread Martin Gainty

SELECT * FROM myTable ORDER BY COLUMN_WHICH_CONTAINS_INSERTED_DATE ASC LIMIT
1;
COLUMN_WHICH_CONTAINS_INSERTED_DATE is a column which contains the date that
the record was inserted
Hth,
Martin
- Original Message -
From: "Mateusz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 01, 2003 7:17 PM
Subject: Re: SELECTing last occurences from a table


> That'd be the solution, but unfortunately i gave You incorrect example
(too
> little rows):
> the problem is I don't have a constant number of foods. For example the
> latest price of tomatoes could be from day 20 but the last price of
potatoes
> might be from day 19, and for onions from day 1. I need single most recent
> row for each type of food that has appeared in database.
>
> - Original Message -
> From: "Becoming Digital" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, June 02, 2003 12:28 AM
> Subject: Re: SELECTing last occurences from a table
>
>
> > Do you have daily prices for a set number number of foods?  If so, try
> >
> > SELECT * FROM food
> > LIMIT n,-1;
> >
> > where n is the number of items.  There's probably a better way to do it
in
> SQL,
> > I just don't know how.  If you are using PHP, that's another story.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECTing last occurences from a table

2003-06-02 Thread Mateusz

That'd be the solution, but unfortunately i gave You incorrect example (too
little rows):
the problem is I don't have a constant number of foods. For example the
latest price of tomatoes could be from day 20 but the last price of potatoes
might be from day 19, and for onions from day 1. I need single most recent
row for each type of food that has appeared in database.

- Original Message -
From: "Becoming Digital" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 02, 2003 12:28 AM
Subject: Re: SELECTing last occurences from a table

> Do you have daily prices for a set number number of foods?  If so, try
>
> SELECT * FROM food
> LIMIT n,-1;
>
> where n is the number of items.  There's probably a better way to do it in
SQL,
> I just don't know how.  If you are using PHP, that's another story.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Server configuration denies access to data source

2003-06-02 Thread Martin Gainty

You need to create the user and grant permissions try (username=teva):
INSERT INTO user (Host,User,Password) VALUES ('%', 'teva',
PASSWORD('your_password'));
and finally add access to the database
INSERT INTO db (Host,Db,User)
VALUES('%','NameOfDatabase','teva');

Hope this helps,
- Original Message -
From: "Rodolfo Ricci" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 01, 2003 6:32 PM
Subject: Server configuration denies access to data source


> I'm trying to use mysql with java, I create a short
> piece of code to make a conection but when the class
> run it sends an exception:
> Server configuration denies access to data source
> I can use the database using mysql client without
> problem.
> Could someone help me, or ask me where i find the
> listins from this mailing list? I guess this kind of
> error was reported before.
>
> thanks...
> Rodolfo Ricci
>
> ___
> Yahoo! Mail
> Mais espaço, mais segurança e gratuito: caixa postal de 6MB, antivírus,
proteção contra spam.
> http://br.mail.yahoo.com/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Moving to version 4.1

2003-06-02 Thread Daniel Kasak

Robert Mark Bram wrote:

Howdy all!

I now know that I was running  3.23.55 and that I need 4.1 for Unicode
support.
I am running Windows XP Pro and in my "add or remove programs" utility, I
see "MySQL ODBC 3.51 Driver" and "MySQL Servers and Clients 3.23.55".
If I use Windows "add or remove programs" utility to remove "MySQL Servers
and Clients 3.23.55" and then in stall 4.1, how will my "MySQL ODBC 3.51
Driver" driver know to connect to 4.1 now? Is there anything else I need to
do?
Thanks for any advice!

Rob
:)
:->
:-}
 

From what I gather, you can't use MySQL-4.1 with MyODBC-3.51. You get 
an error message telling you that the authentication method requested by 
the server is not available, and to upgrade your client libraries (or 
something like that).
I too am hanging out for MySQL-4.1, but due to this, and a number of 
other problems (browse the list), I would suggest you wait at least 
until MySQL-4.1.1 and MyODBC-3.52 until trying it out.

--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Inserting data?

2003-06-02 Thread Becoming Digital

> The way I was taught, in my limited education, was simply to have, say,
> the people_id also appear in table2 as a Foreign Key, that tis would
> serve to relate the tables.  Now I've been advised that the way to do
> this is NOT like that, but to have a third, linking, table

In my opinion, you've been wrongly advised.  I would follow your original
instinct and use a one->many relationship for people to machines.  Using a third
table is just going to complicate things and goes against the concepts of
normalized data.

Edward Dudlik
Becoming Digital
www.becomingdigital.com

- Original Message -
From: <[EMAIL PROTECTED]>
To: "Becoming Digital" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 15:59
Subject: Re: Inserting data?

I'd be glad to share.. you mean what the db is supposed to be?  Ok,
there are 3 tables:
table1 = people, people_id = primary key
table2 = machines, machines_id = primary key
One person can have many machines, one machine can only be assigned to
one person.
The way I was taught, in my limited education, was simply to have, say,
the people_id also appear in table2 as a Foreign Key, that tis would
serve to relate the tables.  Now I've been advised that the way to do
this is NOT like that, but to have a third, linking, table where there
are 2 fields: one is the people_id (primary key from table1) and the
other is the machines_id (primary key from table2).

I was asking how to write a SQL statement to populate that third table
from the data already in/from the other 2.

Any other comments about this are welcome.

Thanks,
Ted

On Sunday, June 1, 2003, at 10:53 AM, Becoming Digital wrote:

> You need a constraint on the data to be inserted into the second
> table.  Care to
> share what that is supposed to be?
>
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
>
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, 01 June, 2003 03:17
> Subject: Inserting data?
>
>
> I have a table, in the table is a field called  name_id; in a second
> table (a linking table) I also have the field name_id, this should be
> the same/reference the same name_id as in the first table.
>
> The first table is fully populated.  How do write a SQL statement to
> get the data from the name_id field of table1 into the name_id field of
> table2?
>
> (I'll do this and find out after if it actually references the same
> data!  So, if it doesn't at least I'll have learned the proper SQL
> statement. :)
>
> Thank you,
> Ted Rogers

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Server configuration denies access to data source

2003-06-02 Thread Rodolfo Ricci

I'm trying to use mysql with java, I create a short
piece of code to make a conection but when the class
run it sends an exception:
Server configuration denies access to data source
I can use the database using mysql client without
problem.
Could someone help me, or ask me where i find the
listins from this mailing list? I guess this kind of
error was reported before.

thanks...
Rodolfo Ricci  

___
Yahoo! Mail
Mais espaço, mais segurança e gratuito: caixa postal de 6MB, antivírus, proteção 
contra spam.
http://br.mail.yahoo.com/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SELECTing last occurences from a table

2003-06-02 Thread Becoming Digital

Do you have daily prices for a set number number of foods?  If so, try

SELECT * FROM food
LIMIT n,-1;

where n is the number of items.  There's probably a better way to do it in SQL,
I just don't know how.  If you are using PHP, that's another story.

Edward Dudlik
Becoming Digital
www.becomingdigital.com


- Original Message -
From: "Mateusz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 15:38
Subject: SELECTing last occurences from a table


Hi!
I couldn't find anything in archives, maybe I search for wrong phrase.
I'm running MySQL v.3.23.49 (if it's not possible under this version, I may
upgrade it).
What I need to accomplish is to find only last occurence of all possible
items from given column.

Supposing:

idnamedayprice
---
1tomatoes125
2onions113
3onions216
4tomatoes230

I want to obtain only:

3onions216(latest price of onions - from day 2nd)
4tomatoes230(latest price of tomatoes - from day 2nd)

How to do that? (in as little selects as possible)
Thanks for any help!

Mateusz Uzdowski


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Query problem

2003-06-02 Thread Sparky Kopetzky

I have a view I need to create from several tables where I'm looking up one
value from a table and need to add it to the Select stmt like this:

SELECT sex (SELECT yes_no_meaning FROM yes_no WHERE yes_no_id =
bite.bite_animal_sex_id),
   type (SELECT type_meaning FROM type WHERE type_id =
bite.bite_type_id), etc...

However, I haven't found an example of how to do this and I need this
ASAFP!!

Apreciate any help.

Robin E. Kopetzky
Black Mesa Computers/Internet Services
www.blackmesa-isp.net


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Advice on improving our current method

2003-06-02 Thread Becoming Digital

> Unfortunately though i think we need to be able to make the changes in
> something we can see which is why we are using mysqlcc.

What is the final use for the database?  Is it for a website, an application, or
just mere data storage?  If it's either of the first two, an admin form can be
built into the website or application.  If you're just using the DB to store
data (and not archiving it), you're making life difficult.

I find a good general rule to be: if the data isn't being searched, sorted,
indexed, or archived, use a flat file (like Excel).

Edward Dudlik
Becoming Digital
www.becomingdigital.com


- Original Message -
From: "Daniel Crompton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 14:00
Subject: Re: Advice on improving our current method


> SET @rank:=5;
>
> UPDATE music SET chart=0 WHERE [EMAIL PROTECTED];
> UPDATE music SET chart=chart+1 WHERE chart<@rank;
>


Thanks Don

Unfortunately though i think we need to be able to make the changes in
something we can see which is why we are using mysqlcc.

With mysqlcc any of us can simply reorder the chart by simply re-typing in
all the position numbers.
It is a pain typing in

1
2
3
4
5
6 etc
up to 100

everyweek,  but i guess this is possibly the easiest way for us to maintain
the music chart.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Insert query

2003-06-02 Thread Kieran Kelleher

Use 'char' instead of 'varchar' and INDEX the fields that you will be using
in the WHERE clause of your SELECTS.

-Original Message-
From: Ulterior [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 31, 2003 10:35 AM
To: [EMAIL PROTECTED]
Subject: Re: Insert query


sow what would you suggest, Jerry?

( I need a very FAST search on this table's filename field)

Ulterior

> Don't use varchar unless you absolutely have to, that should help.
>
> Jerry
>
> - Original Message -
> From: "Ulterior" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, May 31, 2003 3:13 PM
> Subject: Insert query
>
>
> > Hi,
> >
> > I have a database table:
> >
> > CREATE TABLE FTPFILE (
> >   ID int(11) NOT NULL auto_increment,
> >   FTPSITEID int(11) DEFAULT '0' NOT NULL,
> >
> >   FILENAME varchar(254) DEFAULT 'Not defined' NOT NULL,
> >   FILEPATH varchar(254) DEFAULT 'Not defined' NOT NULL,
> >   FILEEXTN varchar(3) DEFAULT '---' NOT NULL,
> >   FILESIZE int(11) NOT NULL,
> >   FILEDATE datetime DEFAULT '-00-00 00:00:00' NOT NULL,
> >
> >   PRIMARY KEY (ID)
> > );
> >
> > when this table reaches 1 records, insert queries are very slow,
> > aproximately 2 records a second.
> > And worst of all mysql-ntd.exe reaches 99% of my processor timing.
> >
> > I am using native mysql C API mysql_query() func for inserting data.
> >
> > Is there any way to speedup insert querys to this table? ( I am planning
> to
> > have at least 2-5 million entries in this table )
> >
> > Ulterior
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
>



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: updating database query

2003-06-02 Thread Don Read


On 01-Jun-2003 Grant Cooper wrote:
> I'm trying to update an email field. Our company has changed from a .com
> to
> a .ca. I wrote a php script to make the changes but I was wondering if I
> could do this from the command line. Its a text field and I would like to
> replace. [EMAIL PROTECTED] to [EMAIL PROTECTED] Can someone help me out please.
> 
> Thank You
> 

UPDATE datable SET email=REPLACE(email, '@test.com', '@test.ca') 
  WHERE email LIKE '[EMAIL PROTECTED]';

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems with Connector/J

2003-06-02 Thread Mark Matthews

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Gilmar Caiado wrote:

> Hi!
>
> I've been experiencing some problems regarding connection mysql/java. I'm
> using a connector 3.0.8, and linux debian. I have also copied the
connector
> to JAVA_HOME/jre/lib/ext directory.
>
> Here's is the code:
>
> import java.sql.*;
>
> public class DBTeste{
>
>   public static void main(String[] args) {
> try {
>   Class.forName ("com.mysql.jdbc.Driver");
>   System.out.println("Driver JDBC loaded!");
>   Connection con =
> DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql");
> } catch (SQLException sqle) {
>   System.err.println("SQL Exception: " + sqle.getMessage());
> } catch (Exception e) {
>   System.err.println("Exception: " + e.getMessage());
> }
>   }
> }
>
> The error message I've got:
>
> SQL Exception: Unable to connect to any hosts due to exception:
> java.net.ConnectException: Connection refused
>
> It's worth to remember that I'm able to enter in the db using a shell
> command, without problems...
>
> Could someone help me?
>
> Thanks!
>
> Gilmar
>
>

Debian has 'skip-networking' set in their .deb-based installs of MySQL.
Connector/J needs TCP/IP networking in MySQL to be enabled, because Java
doesn't support Unix domain sockets. You need to edit your my.cnf in
/etc/mysql to remove the 'skip-networking' line, and restart MySQL.

Of course, you should also figure out what you need to do to make sure
this is secure for your particular situation :)

-Mark

- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma

__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows
 /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+2mzRtvXNTca6JD8RAny9AJ9yO6frhU2wiltJelgx2So+8zgpYQCfaozE
cTwv7N49ryz63XE4zkQ1LCk=
=oZaK
-END PGP SIGNATURE-


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problems with Connector/J

2003-06-02 Thread Gilmar Caiado

Hi!

I've been experiencing some problems regarding connection mysql/java. I'm 
using a connector 3.0.8, and linux debian. I have also copied the connector 
to JAVA_HOME/jre/lib/ext directory.

Here's is the code:

import java.sql.*;

public class DBTeste{

  public static void main(String[] args) {
try {
  Class.forName ("com.mysql.jdbc.Driver");
  System.out.println("Driver JDBC loaded!");
  Connection con = 
DriverManager.getConnection("jdbc:mysql://localhost:3306/mysql");
} catch (SQLException sqle) {
  System.err.println("SQL Exception: " + sqle.getMessage());
} catch (Exception e) {
  System.err.println("Exception: " + e.getMessage());
}
  }
}

The error message I've got:

SQL Exception: Unable to connect to any hosts due to exception: 
java.net.ConnectException: Connection refused

It's worth to remember that I'm able to enter in the db using a shell 
command, without problems...

Could someone help me?

Thanks!

Gilmar


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Inserting data?

2003-06-02 Thread trogers

I'd be glad to share.. you mean what the db is supposed to be?  Ok, 
there are 3 tables:
table1 = people, people_id = primary key
table2 = machines, machines_id = primary key
One person can have many machines, one machine can only be assigned to 
one person.
The way I was taught, in my limited education, was simply to have, say, 
the people_id also appear in table2 as a Foreign Key, that tis would 
serve to relate the tables.  Now I've been advised that the way to do 
this is NOT like that, but to have a third, linking, table where there 
are 2 fields: one is the people_id (primary key from table1) and the 
other is the machines_id (primary key from table2).

I was asking how to write a SQL statement to populate that third table 
from the data already in/from the other 2.

Any other comments about this are welcome.

Thanks,
Ted
On Sunday, June 1, 2003, at 10:53 AM, Becoming Digital wrote:

You need a constraint on the data to be inserted into the second 
table.  Care to
share what that is supposed to be?

Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 03:17
Subject: Inserting data?
I have a table, in the table is a field called  name_id; in a second
table (a linking table) I also have the field name_id, this should be
the same/reference the same name_id as in the first table.
The first table is fully populated.  How do write a SQL statement to
get the data from the name_id field of table1 into the name_id field of
table2?
(I'll do this and find out after if it actually references the same
data!  So, if it doesn't at least I'll have learned the proper SQL
statement. :)
Thank you,
Ted Rogers


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SELECTing last occurences from a table

2003-06-02 Thread Mateusz

Hi!
I couldn't find anything in archives, maybe I search for wrong phrase.
I'm running MySQL v.3.23.49 (if it's not possible under this version, I may
upgrade it).
What I need to accomplish is to find only last occurence of all possible
items from given column.

Supposing:

idnamedayprice
---
1tomatoes125
2onions113
3onions216
4tomatoes230

I want to obtain only:

3onions216(latest price of onions - from day 2nd)
4tomatoes230(latest price of tomatoes - from day 2nd)

How to do that? (in as little selects as possible)
Thanks for any help!

Mateusz Uzdowski


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

updating database query

2003-06-02 Thread Grant Cooper

I'm trying to update an email field. Our company has changed from a .com to
a .ca. I wrote a php script to make the changes but I was wondering if I
could do this from the command line. Its a text field and I would like to
replace. [EMAIL PROTECTED] to [EMAIL PROTECTED] Can someone help me out please.

Thank You


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Connecting WO 5.2.1 to MySQL 4.0.13 on Windows 2000?

2003-06-02 Thread Kieran Kelleher

Getting EO Modeler in WO 5.2.1 to connect to MySQL 4.0.12 on Windows 2000 is
evading us somehow and giving us a dreaded connection error. It works fine
on OS X  I know it is something to do with Classpaths and the fact that
EO Modeler uses a different JDBC connector than WO.

1) If someone out there has MySQL 4.0.XX and WO 5.2.1 Development on Windows
2000 can you tell me what JDBC drivers you have in what folders and what
customization, if any you had to do to classpath, connection string, etc.?

2) Should I use the latest Connector/J 3.0.8 with MySQL 4.0.XX or does
2.0.14 work with MySQL 4.0.XX and which JDBC connector is best for WO 5.2.1?

Thanks, Kieran


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Advice on improving our current method

2003-06-02 Thread Jeff Shapiro


Perhaps I'm being a bit slow today. I don't see (or maybe I haven't 
found the magic syntax) that would allow a table index to handle the 
re-sequencing of information.

On Sun, 1 Jun 2003 14:09:15 -0400, Martin Gainty wrote:
> let the DB manage the sequencing before and after Make Chart # an Index
> Martin
> - Original Message -
> From: "Don Read" <[EMAIL PROTECTED]>
> To: "Daniel Crompton" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Sunday, June 01, 2003 1:54 PM
> Subject: RE: Advice on improving our current method
> 
> 
>> 
>>  On 01-Jun-2003 Daniel Crompton wrote:
>>  
>> 
>>> 
>>>  If for example we move song number 5 up to number 1,  we then have to
>>>  manually change the
>>>  ' Chart Number'  of all the ones below it,  i.e. changing the old number
>>>  1 to a number 2,
>>>  number 2 to a number 3, number 4 to a number 5 etc.
>>> 
>>>  Ideally we need to keep using mysqlcc because it is very simple to use,
>>>  but it is very time consuming.
>>> 
>>>  Any suggestions?
>>> 
>>> 
>> 
>>  SET @rank:=5;
>> 
>>  UPDATE music SET chart=0 WHERE [EMAIL PROTECTED];
>>  UPDATE music SET chart=chart+1 WHERE chart<@rank;
>> 
>>  Regards,
>>  --
>>  Don Read   [EMAIL PROTECTED]
>>  -- It's always darkest before the dawn. So if you are going to
>> steal the neighbor's newspaper, that's the time to do it.
>>  (53kr33t w0rdz: sql table query)
>> 
>> 
>>  --
>>  MySQL General Mailing List
>>  For list archives: http://lists.mysql.com/mysql
>>  To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>> 
>> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

---
Listserv only address.
Jeff Shapiro

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Advice on improving our current method

2003-06-02 Thread Martin Gainty

let the DB manage the sequencing before and after Make Chart # an Index
Martin
- Original Message -
From: "Don Read" <[EMAIL PROTECTED]>
To: "Daniel Crompton" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, June 01, 2003 1:54 PM
Subject: RE: Advice on improving our current method


>
> On 01-Jun-2003 Daniel Crompton wrote:
> 
>
> >
> > If for example we move song number 5 up to number 1,  we then have to
> > manually change the
> > ' Chart Number'  of all the ones below it,  i.e. changing the old number
> > 1 to a number 2,
> > number 2 to a number 3, number 4 to a number 5 etc.
> >
> > Ideally we need to keep using mysqlcc because it is very simple to use,
> > but it is very time consuming.
> >
> > Any suggestions?
> >
> >
>
> SET @rank:=5;
>
> UPDATE music SET chart=0 WHERE [EMAIL PROTECTED];
> UPDATE music SET chart=chart+1 WHERE chart<@rank;
>
> Regards,
> --
> Don Read   [EMAIL PROTECTED]
> -- It's always darkest before the dawn. So if you are going to
>steal the neighbor's newspaper, that's the time to do it.
> (53kr33t w0rdz: sql table query)
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Advice on improving our current method

2003-06-02 Thread Jeff Shapiro


OK, here's a lengthy answer:

I don't use MySQLCC, so I'm assuming that it has a way that you can 
enter and run SQL statements.

Say our top 10 songs are:

mysql [test]> SELECT * FROM musicchart ORDER BY chartnumber LIMIT 10;
+-+--++
| ChartNumber | Artist   | Title  |
+-+--++
|   1 | Led Zepplin  | All of My Love |
|   2 | Jeff Foster  | Volim Te (I Love You)  |
|   3 | Dave Brubeck Quartet | Brotherly Love |
|   4 | U2   | Love Rescue Me |
|   5 | Eurythmics   | Miracle Of Love (Live) |
|   6 | Charlie  | Lovers |
|   7 | Melissa Etheridge| My Lover   |
|   8 | The Call | For Love   |
|   9 | Jewel| Love and Affection (Vh1 Duets) |
|  10 | Diana Krall  | Peel Me a Grape|
+-+--++
10 rows in set (0.00 sec)

Now we move #9 up to #1 and we have to close up the hole that was 
created by the move (there is no longer a #9 song (i.e. we have numbers 
7, 8, 10, 11).

mysql [test]> UPDATE `MusicChart`
-> SET `ChartNumber` = 1
-> WHERE `ChartNumber` = 9;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql [test]> UPDATE `MusicChart`
-> SET `Chartnumber` = `ChartNumber` - 1
-> WHERE `ChartNumber` > 9;
Query OK, 118 rows affected (0.01 sec)
Rows matched: 118  Changed: 118  Warnings: 0

We now have:

mysql [test]> select * from musicchart order by chartnumber limit 10;
+-+--++
| ChartNumber | Artist   | Title  |
+-+--++
|   1 | Jewel| Love and Affection (Vh1 Duets) |
|   1 | Led Zepplin  | All of My Love |
|   2 | Jeff Foster  | Volim Te (I Love You)  |
|   3 | Dave Brubeck Quartet | Brotherly Love |
|   4 | U2   | Love Rescue Me |
|   5 | Eurythmics   | Miracle Of Love (Live) |
|   6 | Charlie  | Lovers |
|   7 | Melissa Etheridge| My Lover   |
|   8 | The Call | For Love   |
|   9 | Diana Krall  | Peel Me a Grape|
+-+--++
10 rows in set (0.00 sec)

Ooops! we have to number 1's. Now we have to shift the rest of the 
songs up one slot.

mysql [test]> UPDATE `MusicChart`
-> SET `ChartNumber` = `ChartNumber` + 1
-> WHERE `Title` !=  'Love and Affection (Vh1 Duets)';
Query OK, 126 rows affected (0.02 sec)
Rows matched: 126  Changed: 126  Warnings: 0

mysql [test]> select * from musicchart order by chartnumber limit 10;
+-+--++
| ChartNumber | Artist   | Title  |
+-+--++
|   1 | Jewel| Love and Affection (Vh1 Duets) |
|   2 | Led Zepplin  | All of My Love |
|   3 | Jeff Foster  | Volim Te (I Love You)  |
|   4 | Dave Brubeck Quartet | Brotherly Love |
|   5 | U2   | Love Rescue Me |
|   6 | Eurythmics   | Miracle Of Love (Live) |
|   7 | Charlie  | Lovers |
|   8 | Melissa Etheridge| My Lover   |
|   9 | The Call | For Love   |
|  10 | Diana Krall  | Peel Me a Grape|
+-+--++
10 rows in set (0.00 sec)

You may want to be careful about the column used in the last statement. 
You will want to use some combination of columns or a unique column to 
ensure against duplicates. With my example there is a possibility that 
you could have two songs with the same title. I think I would add an 
auto_increment column that way I'd only have to know the auto_increment 
number to use in the WHERE clause. The last statement would become:

UPDATE `MusicChart`
SET `ChartNumber` = `ChartNumber` + 1
WHERE `Song_ID` = 135;

Where Song_ID is some number assigned by MySQL to the record.


On Sun, 1 Jun 2003 17:23:13 +0100, Daniel Crompton wrote:
> Can anyone advise how we should improve t

Re: Advice on improving our current method

2003-06-02 Thread Daniel Crompton

> SET @rank:=5;
>
> UPDATE music SET chart=0 WHERE [EMAIL PROTECTED];
> UPDATE music SET chart=chart+1 WHERE chart<@rank;
>


Thanks Don

Unfortunately though i think we need to be able to make the changes in
something we can see which is why we are using mysqlcc.

With mysqlcc any of us can simply reorder the chart by simply re-typing in
all the position numbers.
It is a pain typing in

1
2
3
4
5
6 etc
up to 100

everyweek,  but i guess this is possibly the easiest way for us to maintain
the music chart.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Advice on improving our current method

2003-06-02 Thread Don Read


On 01-Jun-2003 Daniel Crompton wrote:


> 
> If for example we move song number 5 up to number 1,  we then have to
> manually change the
> ' Chart Number'  of all the ones below it,  i.e. changing the old number
> 1 to a number 2,
> number 2 to a number 3, number 4 to a number 5 etc.
> 
> Ideally we need to keep using mysqlcc because it is very simple to use,
> but it is very time consuming.
> 
> Any suggestions?
> 
> 

SET @rank:=5;

UPDATE music SET chart=0 WHERE [EMAIL PROTECTED];
UPDATE music SET chart=chart+1 WHERE chart<@rank;

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Advice on improving our current method

2003-06-02 Thread Anthony Ward

Hi,

I'm not to familiar with MySQL, but as far as I can seem, you might want to
look at programming.
I.e a program in C++ or Perl, or Visual Basic.

Anthony



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Update query with substring

2003-06-02 Thread Paul DuBois

At 11:26 +0200 5/30/03, Davy Obdam wrote:
Hello people,

I am trying to run this query:

UPDATE table1, table2 SET table1.periode = table.periode WHERE 
table1.id = 3 AND SUBSTRING_INDEX( table1.name, '.', - 1 ) = 
table2.name

But i keep getting the same error message

You have an error in your SQL syntax near '
table2 SET table1.periode = table2.periode WHERE table1.id = 3 AND 
SUBSTRIN' at line 1

Is it possible to use a SUBSTRING_INDEX in a update query, or what i 
am i doing wrong?
That's not what the error message is telling you.  It's complaining about
the second table name prior to the SET keyword.  My guess is that your
version of MySQL is not recent enough to support multiple-table updates
(which were implemented around 4.0.2 or so).  What version is your server?
Any help is appreciated, thanks for your time

Best regards,

Davy Obdam

--
---
Davy Obdam Web application developer
Networking4all
email: [EMAIL PROTECTED]
email: [EMAIL PROTECTED]
internet: http://www.networking4all.com
---


--
Are you MySQL certified?, http://www.mysql.com/certification/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Mr. Paul DuBois <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Senior Technical Writer
 /_/  /_/\_, /___/\___\_\___/   Madison, Wisconsin, USA
<___/   www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Rating rows only with FULLTEXT

2003-06-02 Thread O'K Web Design

Hi

I would like to use a FULLTEXT index to rate each row without comparison
to the other rows in the dataset.  I am retrieving documents from remote
databases and would like to limit the responses from the database before an
external script rates them against each other.  I was wondering if something
might be done in the myisam/ftdefs.h source file to remove the dataset
weighting feature.

Thanks
Mike O'Krongli
O'K Web Design


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Advice on improving our current method

2003-06-02 Thread Daniel Crompton

Can anyone advise how we should improve this method of updating our database.

We have a Music chart it is a table with 3 columns

Chart Number  (ie,  1,2,3,4,5,6,7,8,9,10..)
Artist  (Artists Name)
Title (Title of Song)

Each week we login using mysql control center to make changes to the chart positions

The problems is this is currently a very time consuming manual job changing the 'Chart 
Number' Column

1
2
3
4
5
etc.

If for example we move song number 5 up to number 1,  we then have to manually change 
the
' Chart Number'  of all the ones below it,  i.e. changing the old number 1 to a number 
2,
number 2 to a number 3, number 4 to a number 5 etc.

Ideally we need to keep using mysqlcc because it is very simple to use, but it is very 
time consuming.

Any suggestions?

Re: Using varchar or something else?

2003-06-02 Thread Jeff Shapiro

On Sun, 1 Jun 2003 14:53:54 +0100, Dan wrote:
> I have used varchar for ALL my fields as this is the only one i know.
> 
> Alot of my rows just contain image link text ie.
> 
> /image/logoa.gif
> 
> Is using varchar overkill for these fields?.  Would i be better using 
> something else?

It depends. We would need a lot more information about your data and 
application before we could make any meaningful suggestions.

> Any advice?
> 
> TIA
> Dan
> 
> 
> ps. for my row which contains numbers it seems i can use either 
> numeric or int ?  What's the difference, which should i use?

Numeric type (really is decimal type):
An unpacked floating-point number.  Behaves like a CHAR column: 
``unpacked'' means the number is stored as a string, using one 
character for each digit of the value.  The decimal point and, for 
negative numbers, the `-' sign, are not counted in M (but space for 
these is reserved). If D is 0, values will have no decimal point or 
fractional part.  The maximum range of DECIMAL values is the same as 
for DOUBLE , but the actual range for a given DECIMAL column may be 
constrained by the choice of M and D.  If UNSIGNED is specified, 
negative values are disallowed.If D is omitted, the default is 0.  
If Mis omitted, the default is 10.  Prior to MySQL Version 3.23, the 
Margument must include the space needed for the sign and the decimal 
point. 

Int type:
INT[(M)] [UNSIGNED] [ZEROFILL] 
A normal-size integer. The signed range is -2147483648 to 2147483647 .  
The unsigned range is 0 to 4294967295.

So yes there is a difference.

> pps.  is there a list which specifys all options and their uses?

The manual? Which was installed along with MySQL.

/usr/local/mysql/manual.txt
/usr/local/mysql/manual.html

or where ever you install location is.

Or at:
http://www.mysql.com/doc/en/Column_types.html

---
Listserv only address.
Jeff Shapiro

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MYSQL DB PROBLEM

2003-06-02 Thread Peter Lovatt

Hi

This is a bug. You can fix it by adding a line to my.cnf. Can't remember
what but search the archives as it has appeared before.

Peter

-Original Message-
From: Nick Arnett [mailto:[EMAIL PROTECTED]
Sent: 01 June 2003 15:54
To: [EMAIL PROTECTED]
Subject: RE: MYSQL DB PROBLEM


> -Original Message-
> From: Adam Murphy [mailto:[EMAIL PROTECTED]
> Sent: Saturday, May 31, 2003 10:48 PM
> To: [EMAIL PROTECTED]
> Subject: MYSQL DB PROBLEM
>
>
>
> I am trying to insert a table ibf_posts
>
> into a localhost database using the MYSQL control center every
> time i try to insert that one table i get an error
>
> [forum] ERROR 2013: Lost connection to MySQL server during query

Are you trying to insert a lot of data at once?  If so, that will produce
this error if it exceeds a certain size.  The solutions are to insert fewer
records at once or increase MAX_ALLOWED_PACKET, if I recall the correct
variable.

Nick


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Insert query

2003-06-02 Thread Becoming Digital

> If he only has a few million records, why would this be more efficient?

Because MEDIUMINT takes up less space in the database.

Edward Dudlik
Becoming Digital
www.becomingdigital.com


- Original Message -
From: "Nick Arnett" <[EMAIL PROTECTED]>
To: "Andrew Braithwaite" <[EMAIL PROTECTED]>; "'Ulterior'"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 10:47
Subject: RE: Insert query


> -Original Message-
> From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
> Sent: Saturday, May 31, 2003 12:05 PM
> To: 'Ulterior'; [EMAIL PROTECTED]
> Subject: RE: Insert query
>
>
> Hi,
>
> I would use mediumint rather than int for the ID column (int has
> support for
> up to 2.1 Billion records wheras mediumint is up to 8.3 million - more
> efficient for your data type).

If he only has a few million records, why would this be more efficient?

Nick

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Inserting data?

2003-06-02 Thread Becoming Digital

You need a constraint on the data to be inserted into the second table.  Care to
share what that is supposed to be?

Edward Dudlik
Becoming Digital
www.becomingdigital.com


- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 03:17
Subject: Inserting data?


I have a table, in the table is a field called  name_id; in a second
table (a linking table) I also have the field name_id, this should be
the same/reference the same name_id as in the first table.

The first table is fully populated.  How do write a SQL statement to
get the data from the name_id field of table1 into the name_id field of
table2?

(I'll do this and find out after if it actually references the same
data!  So, if it doesn't at least I'll have learned the proper SQL
statement. :)

Thank you,
Ted Rogers


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MYSQL DB PROBLEM

2003-06-02 Thread Nick Arnett

> -Original Message-
> From: Adam Murphy [mailto:[EMAIL PROTECTED]
> Sent: Saturday, May 31, 2003 10:48 PM
> To: [EMAIL PROTECTED]
> Subject: MYSQL DB PROBLEM
>
>
>
> I am trying to insert a table ibf_posts
>
> into a localhost database using the MYSQL control center every
> time i try to insert that one table i get an error
>
> [forum] ERROR 2013: Lost connection to MySQL server during query

Are you trying to insert a lot of data at once?  If so, that will produce
this error if it exceeds a certain size.  The solutions are to insert fewer
records at once or increase MAX_ALLOWED_PACKET, if I recall the correct
variable.

Nick


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Insert query

2003-06-02 Thread Nick Arnett

> -Original Message-
> From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
> Sent: Saturday, May 31, 2003 12:05 PM
> To: 'Ulterior'; [EMAIL PROTECTED]
> Subject: RE: Insert query
> 
> 
> Hi,
> 
> I would use mediumint rather than int for the ID column (int has 
> support for
> up to 2.1 Billion records wheras mediumint is up to 8.3 million - more
> efficient for your data type).  

If he only has a few million records, why would this be more efficient?

Nick

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Using varchar or something else?

2003-06-02 Thread Jerry

i.e.16 chars, make it 30 to be sure

"it" = CHAR

- Original Message - 
From: "Jerry" <[EMAIL PROTECTED]>
To: "Dan" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, June 01, 2003 3:10 PM
Subject: Re: Using varchar or something else?


> I'd advise char due to the over head and space usage of varchar. if its
> something like your example i.e.16 chars, make it 30 to be sure.
>
> Jerry
>
> ps. + pps. = http://www.mysql.com/doc/en/Column_types.html
>
>
> - Original Message - 
> From: "Dan" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, June 01, 2003 2:53 PM
> Subject: Using varchar or something else?
>
>
> I have used varchar for ALL my fields as this is the only one i know.
>
> Alot of my rows just contain image link text ie.
>
> /image/logoa.gif
>
> Is using varchar overkill for these fields?.  Would i be better using
> something else?
>
> Any advice?
>
> TIA
> Dan
>
>
> ps. for my row which contains numbers it seems i can use either numeric or
> int ?  What's the difference, which should i use?
>
> pps.  is there a list which specifys all options and their uses?
>
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Using varchar or something else?

2003-06-02 Thread Jerry

I'd advise char due to the over head and space usage of varchar. if its
something like your example i.e.16 chars, make it 30 to be sure.

Jerry

ps. + pps. = http://www.mysql.com/doc/en/Column_types.html


- Original Message - 
From: "Dan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 01, 2003 2:53 PM
Subject: Using varchar or something else?


I have used varchar for ALL my fields as this is the only one i know.

Alot of my rows just contain image link text ie.

/image/logoa.gif

Is using varchar overkill for these fields?.  Would i be better using
something else?

Any advice?

TIA
Dan


ps. for my row which contains numbers it seems i can use either numeric or
int ?  What's the difference, which should i use?

pps.  is there a list which specifys all options and their uses?




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Practical samples for table types

2003-06-02 Thread Nils Valentin

Hi Everybody,

our server was down for 8 hours. I applogize in case anybody did try to access 
the table chart. Its up and running and of course I would appreciate any 
feedback.

http://www.knowd.co.jp/staff/nils/mysql-ttf.html

Best regards
Nils Valentin
Tokyo/Japan



2003年 5月 30日 金曜日 17:34、Nils Valentin さんは書きました:
> I created a little table chart showing the features of  the different table
> types. Its not complete and might even contain wrong info. The information
> is taken from the the mysql manual and several books.
>
> http://knowd.co.jp/staff/nils/mysql-ttf.html
>
> As I dont have (yet) had the time to try all features of each table type I
> would appreciate if anybody with experience could take a sharp look and
> point out to me anything that is obvious wrong in the chart. I want this to
> be a practical chart, meaning as live is there will be a difference between
> the documentattion and the real life.
>
> Please also let me know why it is wrong and on which system you made the
> experience.
>
> Perhaps you are using features which are not even mentioned on the chart ?
> Also in this case let me know please, I will update the chart.
>
> Of course I will make the final chart available so the everybody can use
> it.
>
> Note: The Gemini table was available only from Nusphere and is not sold or
> used anymore. I know this, but I want  to create a chart which shows the
> feature of all possible table types on a technical base, to fully
> understand the advantages/disadvantages each type has or had. ( You will
> also find enclosed the ISAM table type which is probably not even used
> anymore ;-)
>
> Best regards and thank you for any feedback
>
> Nils Valentin
> Tokyo/Japan
>
> 2003年 5月 29日 木曜日 16:35、Nils Valentin さんは書きました:
> > Hi Jeremy,
> >
> > You are right it's not sold anymore, but that doesnt mean that it wasnt
> > good, right ;-).
> >
> > Apart from the fact that Gemini might be outdated or not, I am really
> > more interested in the technical features etc.
> >
> > Anyway thanks for the reply.
> >
> > Best regards
> >
> > Nils Valentin
> >
> > 2003年 5月 29日 木曜日 16:27、Jeremy Zawodny さんは書きました:
> > > On Tue, May 27, 2003 at 07:50:21AM -0400, Becoming Digital wrote:
> > > > MyISAM is the default MySQL table type.  This is the table type of
> > > > choice for tables whose primary activity comes from SELECT
> > > > statements.  There is no need for transaction-safe tables unless
> > > > INSERT, UPDATE, and/or DELETE actions will be performed frequently.
> > > > Remember that with transaction-safe tables comes an increase in the
> > > > amount of system resources needed to use those table types.
> > > >
> > > > BDB table type is a usable, transaction-safe table type, but it is
> > > > not the most optimized table type in the mix.  BDB tables support
> > > > the basic elements of transactions as well as the AUTOCOMMIT
> > > > variable, but are not as popular or as developed as the InnoDB or
> > > > Gemini types.
> > >
> > > Gemini?  I haven't heard that name for a while.  I thought it was
> > > dead.  Is NuSphere still selling their Gemini-enhanced MySQL?
> > >
> > > Jeremy
> > > --
> > > Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
> > > <[EMAIL PROTECTED]>  |  http://jeremy.zawodny.com/
> > >
> > > MySQL 4.0.8: up 114 days, processed 3,575,209,651 queries (360/sec.
> > > avg)
> >
> > --
> > 
> > Valentin Nils
> > Internet Technology
> >
> >  E-Mail: [EMAIL PROTECTED]
> >  URL: http://www.knowd.co.jp/staff/nils
> > 
> >  有限会社ナレッジデザイン
> >  〒182-0024 東京都調布市布田4-6-1 調布丸善ビル7F
> >  Phone: 0424-40-7912 Fax: 0424-40-7913
> >  URL: http://www.knowd.co.jp
> > 
>
> --
> 
> Valentin Nils
> Internet Technology
>
>  E-Mail: [EMAIL PROTECTED]
>  URL: http://www.knowd.co.jp/staff/nils
> 
>  有限会社ナレッジデザイン
>  〒182-0024 東京都調布市布田4-6-1 調布丸善ビル7F
>  Phone: 0424-40-7912 Fax: 0424-40-7913
>  URL: http://www.knowd.co.jp
> 

-- 

Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL Errno: 2013

2003-06-02 Thread Nils Valentin

Hi Kevin,

I dont think its the switch.

I would like to try the following variables:

net_read_timeout 60
net_write_timeout 60
long_query_time 30

Please let me know if this was of any help.

Best regards

NIls Valentin 
Tokyo/Japan


2003年 5月 30日 金曜日 23:33、Kevin A. Miller さんは書きました:
> Nils:
>
> thank you so much for the response. Below are results related to '%time%'
> from the db giving 2013 error:
>
> mysql> SHOW VARIABLES LIKE '%time%';
> +--+---+
>
> | Variable_name| Value |
>
> +--+---+
>
> | connect_timeout  | 30|
> | delayed_insert_timeout   | 300   |
> | flush_time   | 0 |
> | innodb_lock_wait_timeout | 50|
> | interactive_timeout  | 28800 |
> | long_query_time  | 10|
> | net_read_timeout | 30|
> | net_write_timeout| 60|
> | slave_net_timeout| 3600  |
> | slow_launch_time | 2 |
> | timezone | EDT   |
> | wait_timeout | 28800 |
>
> +--+---+
>
> just this morning we replaced the switch sitting between our application
> boxes and the db boxes hoping that it may resolve the issue, but we are
> still getting random 2013 errors. If it's any help, the majority of the
> queries which seem to fail with a 2013 are pretty small, a simple select
> from a single table with less than 100 entries. As it happens this is the
> first query of many from a series of scripts which get accessed quite a
> bit. We get pretty steady traffic throughout the day and the 2013's seem
> fairly constant throughout all application boxes, not every query by any
> means though. I'm pretty much shooting in the dark now, but hoping that
> maybe there are some tracer bullets around which can help to rectify this.
>
> Thanks again,
>
> Kevin
>
>
> -Original Message-
> From: Nils Valentin [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 29, 2003 8:34 PM
> To: Kevin A. Miller; [EMAIL PROTECTED]
> Subject: Re: MySQL Errno: 2013
>
>
> Hi Kevin,
>
> Error 2013 means lost connection during query
>
> So, as you said the workload of the server is not so high - and I take your
> word for it -I would like to go once more to the timeout variables.
>
> You said that you changed wait timeout, but I believe you missed the
> important one ( just a guess o.k:-)
>
> How about : ??
>
> connect_timeout
> interactive_timeout
> net_read_timeout
> net_write_timeout
> slave_net_timeout
>
> Try this
>
> SHOW VARIABLES LIKE '%time%';
>
> and let me know if this was of any help.
>
> Best regards
>
> Nils Valentin
> Tokyo/Japan
>
> 2003年 5月 30日 金曜日 01:54、Kevin A. Miller さんは書きました:
> > I am reposting this in hopes that somebody out there has at least a
> > suggestion or hint as where to look. Everything I've tried so far (mainly
> > small setting changes) seems to prevent numerous 2013 errors.
> >
> > help me mysql kenobi, you're my only hope.
> >
> > Kevin
> >
> > -Original Message-
> > From: Kevin A. Miller [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, May 27, 2003 3:18 PM
> > To: [EMAIL PROTECTED]
> > Subject: MySQL Errno: 2013
> >
> >
> > In our production environment, we are receiving sporadic but constant
> > 2013 errors from one of our mysql dbs.
> >
> > The production environment consists of 5 servers running RH 6.2/apache
> > 1.3.27/php 4.0.6, load balanced with a foundry server iron. Each app box
> > queries a central db box, using pconnect, (rh 8.0/mysql 4.0.12) primarily
> > for reads (roughly 80% of a script's db transactions) and another db box
> > for writes (rh 6.2/mysql 4.0.12).
> >
> > Logic is in place to log any mysql errors on each app box from either
> > mysql server. Over the past month, well pretty much since logging was
> > enabled, the 'read' server returns quite a few 2013 errors. We log the
> > 'suspect' query and the queries are valid. Not every query results in an
> > error, but enough where we get up to 50 an hour from every box. During
> > peak times we average around 500 qps. The db server in question is pretty
> > robust and hardly ever carries a load above 1.0. We are using a pretty
> > standard 'huge' version of my.conf, except for the following changed
> > lines:
> > skip-innodb
> > skip-name-resolve
> > set-variable=thread_stack=256k
> >
> > set-variable=wait_timeout=60
> > set-variable=thread_cache_size=40
> >
> > From scanning previous posts related to errno 2013, we have adjusted
> > 'thread_stack' to above value as well as the 'wait_timeout'. Nothing so
> > far seems to correct the problem. There seems to be no rhyme or reason as
> > to what causes the errors, many scripts are executed during the day. In
> > fact nobody in our office has even experienced the error first-hand, but
> > logs indicate that it does occur and quite frequently
> >
> > Thanks in advance.
> >
> > Kevin A. Miller
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubsc

1 2 >

1 - 100 of 101 matches

Mail list logo