Re: Help me deal with this subquery removal

[Fred van Engen]

On Sat, Feb 24, 2001 at 08:56:03AM +0100, Fred van Engen wrote:
> On Fri, Feb 23, 2001 at 06:05:53PM -0600, Don Hosek wrote:
> > This'd be a piece of cake with sub queries: What I have is a table with two 
>relevant fields: iIssue and iSubId
> > 
> > iSubId represents a magazine subscriber
> > iIssue represents any issues that person has/had coming 
> > 
> 
> 
> > SELECT iSubID 
> > FROM Issues 
> > WHERE iIssue=N
> >  AND iSubID NOT IN
> >  (
> >   SELECT iSubID
> >   FROM Issues
> >   WHERE iIssue=N+1
> >  )
> > 
> > My first attempt based on the example from the documentation:
> > 
> > SELECT i1.iSubId 
> > FROM Issue AS i1 
> > LEFT JOIN Issue AS i2 
> >  ON i1.iSubId=i2.iSubId 
> > WHERE i2.iSubId IS NULL 
> >  AND i2.iIssue=9
> >  AND i1.iIssue=8
> > 
> 
> Your LEFT JOIN would generate rows for any combination of iIssue
> for an iSubId and then SELECT only those where iSubId is NULL,
> which I guess it never will be.
> 
> You might want to check the manual for the exact workings of a
> LEFT JOIN.
> 
> What you would need is this:
> 
> SELECT i1.iSubId
> FROM Issue AS i1
>  LEFT JOIN Issue AS i2
>  ON i1.iSubId=i2.iSubId AND i2.iIssue = i1.iIssue + 1
> WHERE i1.iIssue=8 AND i2.iIssue IS NULL
> 
> The LEFT JOIN then tries to find for each record in i1, one or
> more records in i2 with the same iSubId as the record in i1 and
> an iIssue one higher than the record in i1. If no such record
> exists, it will generate a row anyway, but this will have NULL
> values for all fields in i2.
> 
> So the WHERE will check for a NULL field in i2 and for the iIssue
> you want and return only those rows.
> 

You may also try this:

SELECT iSubId
FROM Issue
GROUP BY iSubId
HAVING MAX(iIssue) = 8

I don't use HAVING usually, so you might want to check this.
It does assume that there will be no gaps in issues for a
subscriber (i.e. a subscriber with issues 5,6,7,8,20,21 won't
be found with this).


Regards,

Fred.

-- 
Fred van Engen  XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC  Almere
fax: +31 36 5462424 The Netherlands

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

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

Re: MySQL as spider database.

[Vahan Yerkanian]

Ed Carp wrote:
> 
> Have you tried the full text search capabilities yet?  Might work in your case - 
>docs at http://www.mysql.com/doc/M/y/MySQL_full-text_search.html

Yeah I tried them, but it doesn't work on substring search, only phrase
search,
e.g. MATCH Keywords AGAINST('vid orce') wont find Nvidia GeForce in the
rows

What about the thing that indexing TEXT fields is possible since
3.23.33?
can someone give an example of creating a table with the text field as
an index?
I didn't succeeded creating one...

> --
> Ed Carp, N7EKG  [EMAIL PROTECTED]   940/367-2744 cell phone
> http://www.pobox.com/~erc   [EMAIL PROTECTED] - text pager
-- 
Vahan Yerkanian   Email: [EMAIL PROTECTED]
Leading Web Developer / Designer  Phone: (374) 158-2723
Web Development DepartmentFax:   (374) 128-5082
ARMINCO Global Telecommunications http://www.arminco.com

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

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

Re: Help me deal with this subquery removal

[Fred van Engen]

On Fri, Feb 23, 2001 at 06:05:53PM -0600, Don Hosek wrote:
> This'd be a piece of cake with sub queries: What I have is a table with two relevant 
>fields: iIssue and iSubId
> 
> iSubId represents a magazine subscriber
> iIssue represents any issues that person has/had coming 
> 


> SELECT iSubID 
> FROM Issues 
> WHERE iIssue=N
>  AND iSubID NOT IN
>  (
>   SELECT iSubID
>   FROM Issues
>   WHERE iIssue=N+1
>  )
> 
> My first attempt based on the example from the documentation:
> 
> SELECT i1.iSubId 
> FROM Issue AS i1 
> LEFT JOIN Issue AS i2 
>  ON i1.iSubId=i2.iSubId 
> WHERE i2.iSubId IS NULL 
>  AND i2.iIssue=9
>  AND i1.iIssue=8
> 

Your LEFT JOIN would generate rows for any combination of iIssue
for an iSubId and then SELECT only those where iSubId is NULL,
which I guess it never will be.

You might want to check the manual for the exact workings of a
LEFT JOIN.

What you would need is this:

SELECT i1.iSubId
FROM Issue AS i1
 LEFT JOIN Issue AS i2
 ON i1.iSubId=i2.iSubId AND i2.iIssue = i1.iIssue + 1
WHERE i1.iIssue=8 AND i2.iIssue IS NULL

The LEFT JOIN then tries to find for each record in i1, one or
more records in i2 with the same iSubId as the record in i1 and
an iIssue one higher than the record in i1. If no such record
exists, it will generate a row anyway, but this will have NULL
values for all fields in i2.

So the WHERE will check for a NULL field in i2 and for the iIssue
you want and return only those rows.


Regards,

Fred.

-- 
Fred van Engen  XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC  Almere
fax: +31 36 5462424 The Netherlands

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

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

Re: urgent

[vk . talwar]

Thanks
Vinay Talwar
[EMAIL PROTECTED]
[EMAIL PROTECTED]


   
 
Mohamad Ilhami 
 
<[EMAIL PROTECTED]To: [EMAIL PROTECTED]   
 
itb.ac.id>   cc: [EMAIL PROTECTED] 
 
 Subject: Re: urgent   
 
02/24/01 02:37 PM  
 
   
 
   
 



MySQL version is currently 3.23.33 and always available at www.mysql.com

regards

-ilham-
On Fri, 23 Feb 2001 [EMAIL PROTECTED] wrote:

> Hai,
> Pls let me know at the earliest where I can download SQL 7
> Thanks in advance
>
> Vinay Talwar
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


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

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






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

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

Re: Honest, my last question..... for a while. MYSQLIMPORT

[Fred van Engen]

Hi Joe (and Nancy ;-) ),

On Fri, Feb 23, 2001 at 05:23:10PM -0500, Joe and Nancy M wrote:
> I have my database created on my ISP's server.  I can telnet to it and log in.  I 
>have created my table.  I inserted 4 test records.  I have written my .php3 pages and 
>pull the data and get the results I want.  Now I need to populate the table with 
>hundreds of records exported out of Peachtree.  I can get a tab delimited file, no 
>problem.  I will clear this table weekly and re-import the entire record set, so I 
>obviously do not want to insert record by record.
> 
> I telnet to my ISP, login, then login to the mysql server with mysql 
>-hlocalhost.isp.com. -p databasename
> Then from mysql>, I type: mysqlimport -d --local cur myfile.txt
> 

mysqlimport is a command you would start from the telnet prompt,
not from the mysql prompt.

> where -d means delete the existing records, --local means get the file from the 
>client, cur is my table and myfile.txt is the file on my hard drive.  Again, I get 
>parse errors.  
> 
> Any thoughts on the command string?  
> Also, how do I specify the folder on the client?  (c:\a\myfile.txt)
> 

I never used it, but I guess it will use the current directory
or you can just specify a filename including its path. E.g.
/home/joe/myfile.txt or even ~/myfile.txt.

Regards,

Fred.

-- 
Fred van Engen  XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC  Almere
fax: +31 36 5462424 The Netherlands

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

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

MySql Install problems

[David Richards]

 >Description
  I have installed MySql version 3.23.33-1 using the RPM's for Redhat 
Linux -i386 (RedHat version 7)
  After installing I find myself unable to do any basic db 
administration including changing the password.
  I simply installed the packages with  rpm -i  and the 
mysqld was started for me with
default settings. When I tried to change the password with
mysqladmin -u root -p password 
I get the following error:
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

When I try to create a database with mysqladmin -u root create testdb  I 
get:

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

Upon doing the ps command I can see that I have three instances of 
mysqld running -
I am rather new to databases so I'm not sure where to go from here.
Any help would be very much appreciated 
Dave Richards





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

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

Re: urgent

[Mohamad Ilhami]

MySQL version is currently 3.23.33 and always available at www.mysql.com

regards

-ilham-
On Fri, 23 Feb 2001 [EMAIL PROTECTED] wrote:

> Hai,
> Pls let me know at the earliest where I can download SQL 7
> Thanks in advance
> 
> Vinay Talwar
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


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

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

urgent

[vk . talwar]

Hai,
Pls let me know at the earliest where I can download SQL 7
Thanks in advance

Vinay Talwar
[EMAIL PROTECTED]
[EMAIL PROTECTED]


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

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

Re: Table Design -- which is better?

[Jason Landry]

Have you considered using the SET datatype?  It would be perfect for your
situation.

- Original Message -
From: "Nino Skilj" <[EMAIL PROTECTED]>
To: "'Tbone'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 7:38 PM
Subject: RE: Table Design -- which is better?


> The data would be 1's and 0's (on/off)
>
> Nino
>
> -Original Message-
> From: Tbone [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 23, 2001 4:18 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Table Design -- which is better?
>
>
> Hi,
> How would the data look a like.
> And how about the query's
>
> Greetz Tbone
> - Original Message -
> From: "Nino Skilj" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, February 24, 2001 12:17 AM
> Subject: Table Design -- which is better?
>
>
> > I have a general design question.
> >
> > Is it better to design one table with 45 columns or to split it into 3
> > tables with 15 columns each. There would be about 5000 rows in the table
> and
> > it would be used more for reading rather than writing.
> >
> > I'm new to this, is there anything I'm missing?
> >
> > Thanks,
> > Nino
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


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

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

RE: Table Design -- which is better?

[Atle Veka]

IMO, you might as well keep them in one table. But I think that's up to
you. Choose a design method that you like and stick with it :)


Atle

On Fri, 23 Feb 2001, Nino Skilj wrote:

> The data would be 1's and 0's (on/off)
> 
> Nino
> 
> -Original Message-
> From: Tbone [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 23, 2001 4:18 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Table Design -- which is better?
> 
> 
> Hi,
> How would the data look a like.
> And how about the query's
> 
> Greetz Tbone
> - Original Message -
> From: "Nino Skilj" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, February 24, 2001 12:17 AM
> Subject: Table Design -- which is better?
> 
> 
> > I have a general design question.
> >
> > Is it better to design one table with 45 columns or to split it into 3
> > tables with 15 columns each. There would be about 5000 rows in the table
> and
> > it would be used more for reading rather than writing.
> >
> > I'm new to this, is there anything I'm missing?
> >
> > Thanks,
> > Nino
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> 
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


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

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

access denied...

[Sean Murray]

Hello,
I am running MySql 3.23.33 on Linux RH 6.2. In the documentation, it says if
you want to add a user that is allowed to connect from anywhere, use the "%"
symbol for host. When I add a user whil an empty host field or even a "%" -
I still get access denied... However when I go ahead and add "localhost" to
the host, it works just fine. Any suggestions?

Sean


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

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

RE: Table Design -- which is better?

[Nino Skilj]

The data would be 1's and 0's (on/off)

Nino

-Original Message-
From: Tbone [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 4:18 PM
To: [EMAIL PROTECTED]
Subject: Re: Table Design -- which is better?


Hi,
How would the data look a like.
And how about the query's

Greetz Tbone
- Original Message -
From: "Nino Skilj" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 24, 2001 12:17 AM
Subject: Table Design -- which is better?


> I have a general design question.
>
> Is it better to design one table with 45 columns or to split it into 3
> tables with 15 columns each. There would be about 5000 rows in the table
and
> it would be used more for reading rather than writing.
>
> I'm new to this, is there anything I'm missing?
>
> Thanks,
> Nino
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



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

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

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

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

Re: MySQL as spider database.

[Ed Carp]

Vahan Yerkanian ([EMAIL PROTECTED]) writes:

> I'm in process of writing a web page indexer, which retrieves
> pages from a preset URL list, strips them from HTML tags, and
> inserts the text into a database. Now what I'm puzzled with is
> the table structure which holds the text information. Setting
> TEXT/BLOB fields as an indexes wasn't supported before 3.23.33,
> and I'm greatly concerned about the performance, as the site
> itself gets around 300,000 hits daily. Anyone with previous
> experience in this field could shed some light on this?
> I should be able to find 'Hello World!' in the table row with
> any of those keywords 'ell', 'lo Wo', 'Hell ld!', 'Hello', 'World',etc.

Have you tried the full text search capabilities yet?  Might work in your case - docs 
at http://www.mysql.com/doc/M/y/MySQL_full-text_search.html
--
Ed Carp, N7EKG  [EMAIL PROTECTED]   940/367-2744 cell phone
http://www.pobox.com/~erc   [EMAIL PROTECTED] - text pager

I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.

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

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

Re: Grant Table Privileges

[Ed Carp]

Support EzClickThru.net ([EMAIL PROTECTED]) writes:

> I have a user that I want to grant create,drop on %_ext to user@localhost but it 
>does not like the wildcard in the tablename. I am creating heap tables and then 
>dropping them but I want the user to have create and drop privileges only on those 
>tables not all of them in the database. Is this possible or do I have specify each 
>table name or * for all of them. 

Try putting the % in single quotes.
--
Ed Carp, N7EKG  [EMAIL PROTECTED]   940/367-2744 cell phone
http://www.pobox.com/~erc   [EMAIL PROTECTED] - text pager

I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.

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

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

Re: test condition?

[bohyun yoon]

It is about If one can be allowed to update table.
If table colume has max value 100 and current value is 100 just one more 
person can insert into table.
In case of this administrator should limit access other.
That's it..
Maybe use select query


>From: WANG_KING£¨Íõ¸Ö£© <[EMAIL PROTECTED]>
>To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
>Subject: test condition?
>Date: Fri, 23 Feb 2001 09:37:29 +0800
>
>In the section of "How to cope without commit/rollback" of mysql manual,
>it said
>1. Use LOCK TABLES ... to lock all the tables you want to access.
>2. Test conditions.
>3. Update if everything is okay.
>4. Use UNLOCK TABLES to release your locks.
>
>my question is what is Test conditions?and how to do?
>
>Yours,
>Sincerely
>King Wang
>Shanghai Huateng Software Systems Co, Ltd.
>8/F, Wenxin United Press Tower, 755 Wei Hai Road, Shanghai 200041, P.R.C
>PH:32014500-5106
>Email:[EMAIL PROTECTED] 
>
>
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.


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

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

More Link Probs

[Alec Solway]

Hi,

My problems with open64 and fopen64 have been solved by using a newer 
version of glibc, however now I get the following errors when trying to 
link the MySQL C Client API library with my program.

/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress':
my_compress.o(.text+0x97): undefined reference to `uncompress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function 
`my_compress_alloc':
my_compress.o(.text+0x12b): undefined reference to `compress'
collect2: ld returned 1 exit status

Which library has the compress functions?

Regards.
Alec


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

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

Re: Table Design -- which is better?

[Tbone]

Hi,
How would the data look a like.
And how about the query's

Greetz Tbone
- Original Message -
From: "Nino Skilj" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 24, 2001 12:17 AM
Subject: Table Design -- which is better?


> I have a general design question.
>
> Is it better to design one table with 45 columns or to split it into 3
> tables with 15 columns each. There would be about 5000 rows in the table
and
> it would be used more for reading rather than writing.
>
> I'm new to this, is there anything I'm missing?
>
> Thanks,
> Nino
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



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

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

Help me deal with this subquery removal

[Don Hosek]

This'd be a piece of cake with sub queries: What I have is a table with two relevant 
fields: iIssue and iSubId

iSubId represents a magazine subscriber
iIssue represents any issues that person has/had coming 

So, for example, if someone is subscribed for 4 issues and has subscriber ID 47, they 
will generate four rows in the table:

47  11
47  12
47  13
47  14

I want to be able to determine whether someone is at the end of their subscription. 
The query should be give me all the subscriber IDs which have a record for iIssue=N 
but not for iIssue=N+1

as a sub-query, I would write:

SELECT iSubID 
FROM Issues 
WHERE iIssue=N
 AND iSubID NOT IN
 (
  SELECT iSubID
  FROM Issues
  WHERE iIssue=N+1
 )

My first attempt based on the example from the documentation:

SELECT i1.iSubId 
FROM Issue AS i1 
LEFT JOIN Issue AS i2 
 ON i1.iSubId=i2.iSubId 
WHERE i2.iSubId IS NULL 
 AND i2.iIssue=9
 AND i1.iIssue=8

Returned 0 rows (if it were correct it would have returned at least one row).

Any ideas?

-dh

Patching w/o the compiler was Re: Replication time patch

[William R. Mussatto]

Your reply triggered a question?

If you are on a win32 box and using the binary builds, what is the 
proceure for getting these patchs?  Last time I checked the site is was 
still showing 3.23.33 as the current release?  


On Fri, 23 Feb 2001, Sasha Pachev wrote:
...
> Just realized that a while ago, I fixed a bug in 3.23.33 with time 
> replication, and forgot to post the fix to the public lists - just sent it to 
> the user who reported the bug:
> 

Sincerely,

William Mussatto, Senior Systems Engineer
CyberStrategies, Inc
ph. 909-920-9154 ext. 27


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

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

test condition?

[WANG_KING（王钢）]

In the section of "How to cope without commit/rollback" of mysql manual,
it said 
1.  Use LOCK TABLES ... to lock all the tables you want to access. 
2.  Test conditions. 
3.  Update if everything is okay. 
4.  Use UNLOCK TABLES to release your locks. 

my question is what is Test conditions?and how to do?

Yours,
Sincerely 
King Wang
Shanghai Huateng Software Systems Co, Ltd.
8/F, Wenxin United Press Tower, 755 Wei Hai Road, Shanghai 200041, P.R.C
PH:32014500-5106
Email:[EMAIL PROTECTED] 
 



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

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

Table Design -- which is better?

[Nino Skilj]

I have a general design question.

Is it better to design one table with 45 columns or to split it into 3
tables with 15 columns each. There would be about 5000 rows in the table and
it would be used more for reading rather than writing.

I'm new to this, is there anything I'm missing?

Thanks, 
Nino

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

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

Re: Re: Youch!

[John Jensen]

Thank you.
I got /usr/local/mysql/bin/mysqld as the only return from that find 
command.
I'll try again from a tarball.

On 23 Feb 2001, at 14:58, Atle Veka wrote:

> 
> It might have installed it in a separate place. I believe the default
> might be /usr/local/libexec/mysqld.
> 
> Do a 'find /usr/ -name "mysqld"' to attempt to find your binary.
> 
> I always like to install stuff by source, cuz then I can always
> specify where things go :) RPM usually should work fine, but sometimes
> it can be tricky.
> 
> 
> Atle
> 
> On Fri, 23 Feb 2001, John Jensen wrote:
> 
> > I do believe I have a mess on my hands.
> > Lacking any other guidance, I tried upgrading my mysql to 3.23 with
> > an rpm on a Redhat Linux 6.1 system. I now have the same directory
> > layout for mysql as on my Redhat 7 server, except there is no daemon
> > to be found there. The only mysql daemon found anywhere is still in
> > /usr/local/mysql/bin, and it still doesn't work. Attempts to execute
> > no longer insist there is supposed to be a libexec directory. It
> > just tells me it can't find any data in the var directory. When I
> > ran scripts/mysql_install_db, it just tells me to remember to copy
> > the support-files/mysql.server to the right place (wherever that is,
> > if not where it is already) and to remember to set a password. That
> > doesn't work either. It wants a /tmp/mysql.sock file, and I don't
> > have one to give it.
> > 
> > Any ideas?
> > 
> > On 21 Feb 2001, at 16:29, Atle Veka wrote:
> > 
> > > 
> > > where's your mysqld located?
> > > 
> > > just change your safe_mysql script to contain the correct location
> > > of your mysqld binary.
> > > 
> > > also, i *think* mysqladmin -uroot -p[pass] shutdown
> > > is the preferred shutdown mechanism, didn't even know you could do
> > > that with mysql (client).
> > > 
> > > are you sure it's actually stopped? do a 'ps | grep mysqld' to
> > > find out ;)
> > > 
> > > 
> > > Atle
> > > 
> > > On Wed, 21 Feb 2001, John Jensen wrote:
> > > 
> > > > I had shut down the mysql daemon using:
> > > > bin/mysql -u root -p[password] shutdown
> > > > Now when I attempt to restart it using:
> > > > bin/safe_mysql &
> > > > it gives me the message:
> > > > [1] 2564
> > > > The file /usr/local/mysql/libexec/mysqld doesn't exist or is
> > > > not executable  Please do a cd to the mysql installation
> > > > directory and restart this  script from there as follows:
> > > > ./bin/safe_mysql but ./bin/safe_mysql just gave me the same
> > > > message prefaced by:[2] 2570 I checked and found the directory
> > > > 'libexec' does not exist. I can't recall it ever did. So now I
> > > > am left wondering: "Why is it trying to look in a non-existent
> > > > direcory?" and "What went wrong?"
> > > > 
> > > > Any ideas?
> > > > 
> > > > 
> > > > John Jensen
> > > > 520 Goshawk Court
> > > > Bakersfield, CA 93309
> > > > 661-833-2858
> > > > 
> > > > 
> > > >  - Before posting, please check:
> > > >http://www.mysql.com/manual.php   (the manual)
> > > >http://lists.mysql.com/   (the list archive)
> > > > 
> > > > To request this thread, e-mail
> > > > <[EMAIL PROTECTED]> To unsubscribe, e-mail
> > > > <[EMAIL PROTECTED]>
> > > > Trouble unsubscribing? Try:
> > > > http://lists.mysql.com/php/unsubscribe.php
> > > > 
> > > 
> > 
> > 
> > John Jensen
> > 520 Goshawk Court
> > Bakersfield, CA 93309
> > 661-833-2858
> > 
> > 
> > - Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> > 
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try:
> > http://lists.mysql.com/php/unsubscribe.php
> > 
> 


John Jensen
520 Goshawk Court
Bakersfield, CA 93309
661-833-2858

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

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

Re: Re: Youch!

[Atle Veka]

It might have installed it in a separate place. I believe the default
might be /usr/local/libexec/mysqld.

Do a 'find /usr/ -name "mysqld"' to attempt to find your binary.

I always like to install stuff by source, cuz then I can always specify
where things go :) RPM usually should work fine, but sometimes it can be
tricky.


Atle

On Fri, 23 Feb 2001, John Jensen wrote:

> I do believe I have a mess on my hands.
> Lacking any other guidance, I tried upgrading my mysql to 3.23 with 
> an rpm on a Redhat Linux 6.1 system. I now have the same directory 
> layout for mysql as on my Redhat 7 server, except there is no daemon 
> to be found there. The only mysql daemon found anywhere is still in 
> /usr/local/mysql/bin, and it still doesn't work. Attempts to execute 
> no longer insist there is supposed to be a libexec directory. It just 
> tells me it can't find any data in the var directory. When I ran 
> scripts/mysql_install_db, it just tells me to remember to copy the 
> support-files/mysql.server to the right place (wherever that is, if 
> not where it is already) and to remember to set a password. That 
> doesn't work either. It wants a /tmp/mysql.sock file, and I don't 
> have one to give it.
> 
> Any ideas?
> 
> On 21 Feb 2001, at 16:29, Atle Veka wrote:
> 
> > 
> > where's your mysqld located?
> > 
> > just change your safe_mysql script to contain the correct location of
> > your mysqld binary.
> > 
> > also, i *think* mysqladmin -uroot -p[pass] shutdown
> > is the preferred shutdown mechanism, didn't even know you could do
> > that with mysql (client).
> > 
> > are you sure it's actually stopped? do a 'ps | grep mysqld' to find
> > out ;)
> > 
> > 
> > Atle
> > 
> > On Wed, 21 Feb 2001, John Jensen wrote:
> > 
> > > I had shut down the mysql daemon using:
> > >   bin/mysql -u root -p[password] shutdown
> > > Now when I attempt to restart it using:
> > >   bin/safe_mysql &
> > > it gives me the message:
> > >   [1] 2564
> > >   The file /usr/local/mysql/libexec/mysqld doesn't exist or is not
> > >   executable  Please do a cd to the mysql installation directory and
> > > restart this  script from there as follows:   ./bin/safe_mysql but
> > > ./bin/safe_mysql just gave me the same message prefaced by:   [2]
> > > 2570 I checked and found the directory 'libexec' does not exist. I
> > > can't recall it ever did. So now I am left wondering: "Why is it
> > > trying to look in a non-existent direcory?" and "What went wrong?"
> > > 
> > > Any ideas?
> > > 
> > > 
> > > John Jensen
> > > 520 Goshawk Court
> > > Bakersfield, CA 93309
> > > 661-833-2858
> > > 
> > > 
> > > - Before posting, please check:
> > >http://www.mysql.com/manual.php   (the manual)
> > >http://lists.mysql.com/   (the list archive)
> > > 
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try:
> > > http://lists.mysql.com/php/unsubscribe.php
> > > 
> > 
> 
> 
> John Jensen
> 520 Goshawk Court
> Bakersfield, CA 93309
> 661-833-2858
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


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

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

Re: Quoting numbers? (was Re:MySQL Tables)

[Pete Harlan]

> Nah!  I think I'd prefer to do it myself and have the compiler/interpreter
> come up saying "hey buddy, what ya trying to do?  This ain't no number"
> rather than it changing the number into string and happily continue on
> running through the rest of the programming.  Takes you longer to figure out
> you used the letter "O" instead of the number 0.

Strong typing and weak typing each have their merits.

When MySQL compares numbers and strings, it does so by converting the
string to a number, rather than the number to a string (which would
seem more natural in a type-heirarchy sense, but would be confusing).

So my question is, if it 'demotes' strings to numbers when comparing
them with or assigning them to numeric fields, then why would it ever
make a difference to quote numeric literals?

And in practice, it has appeared to me to make no difference.  (Until
some recent bug report regarding bigints where it did appear to make a
difference.)

It was pointed out to me that there is an efficiency difference:

select benchmark(100, 1+1);=>   0.34 sec
select benchmark(100, 1+'1');  =>   1.81 sec

which, though true, would usually not matter.

My personal preference would be that if it could ever matter to quote
numeric literals, then disallow that (or at least provide a switch
that disallows it (and one that only warns), so as not to break a lot
of code).  If the policy is that it should not ever matter to quote
numeric literals, then treat as bugs the cases where it turns out to.

--
Pete Harlan
[EMAIL PROTECTED]  (Is "Antwort" Swedish?)


> > Tis true Rolf but you can bet your bottom dollar that at somepoint
> > a confusion will arise when it is most inconvenient.  There is
> > always a conversion somewhere in the code even if it is not
> > visible.
> >
> > > -Original Message-
> > > From: Rolf Hopkins [SMTP:[EMAIL PROTECTED]]
> > > Sent: 23 February 2001 02:09
> > > To: Julian Strickland; [EMAIL PROTECTED]
> > > Subject: Re: Quoting numbers? (was Re:MySQL Tables)
> > > 
> > > That's very true but these days, some languages/databases allow
> > > for strings to be assigned to numbers and vice versa without the
> > > need for conversion.  PHP is one such language, not that I'm
> > > bagging it or anything as I use it myself.  I just call it bad
> > > type checking.
> > >
> > > - Original Message -
> > > From: "Julian Strickland" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Thursday, February 22, 2001 22:35
> > > Subject: RE: Quoting numbers? (was Re:MySQL Tables)
> > >
> > > It's all to do with data types, traditionally and across most
> > > > languages quotes are used to delimit STRINGS and a string is
> > > > NOT a number although may represent one when displayed.
> > > >
> > > > > -Original Message-
> > > > > From: Pete Harlan [SMTP:[EMAIL PROTECTED]]
> > > > > Sent: 21 February 2001 20:51
> > > > > To: [EMAIL PROTECTED]
> > > > > Subject: Quoting numbers? (was Re:MySQL Tables)
> > > > >
> > > > > > I think you'll get better results if you don't quote your
> > > > > > numbers. Quotes should be used for text and dates
> > > > > > (depending) but not numbers.
> > > > >
> > > > > Out of curiosity, why?
> > > > > 
> > > > > We use quotes for numbers all the time here, for
> > > > > consistency's sake; the programmer doesn't have to worry
> > > > > about the representation of, say, a salesman_id, but just
> > > > > reads/displays/stores it in the database.
> > > > > 
> > > > > Aside from the fact that leaving them off is possible, is
> > > > > there a standards/compatibility/other reason to do so?
> > > > > 
> > > > > (An example of a good reason not to use them would be if the
> > > > > db engine weren't smart enough to use an index when you say
> > > > >
> > > > > select * from table_name where numeric_key = '1234'
> > > > >
> > > > > but possibly (probably?) all dbms's are that smart.)
> > > > >
> > > > > --Pete

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

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

Building MySQLGUI

[Hackley, Susan]

Help I ran into this problem while compiling.

root @
fwnau060.usco.com:/root/mysqlgui/fltk-1.0.10
=> make
=== making src ===
Compiling Fl.o...
In file included from Fl.cxx:28:
../FL/x.H:45: X11/Xlib.h: No such file or
directory
../FL/x.H:46: X11/Xutil.h: No such file or
directory
../FL/x.H:50: X11/Xatom.h: No such file or
directory
*** Error code 1

Stop.

What am I doing wrong?

Susan Hackley
Database Administrator
UNIX Services
USCO Logistics
Phone: (203)578-4364
[EMAIL PROTECTED] 



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

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

Honest, my last question..... for a while. MYSQLIMPORT

[Joe and Nancy M]

I have my database created on my ISP's server.  I can telnet to it and log in.  I have 
created my table.  I inserted 4 test records.  I have written my .php3 pages and pull 
the data and get the results I want.  Now I need to populate the table with 
hundreds of records exported out of Peachtree.  I can get a tab delimited file, no 
problem.  I will clear this table weekly and re-import the entire record set, so I 
obviously do not want to insert record by record.

I telnet to my ISP, login, then login to the mysql server with mysql 
-hlocalhost.isp.com. -p databasename
Then from mysql>, I type: mysqlimport -d --local cur myfile.txt

where -d means delete the existing records, --local means get the file from the 
client, cur is my table and myfile.txt is the file on my hard drive.  Again, I get 
parse errors.  

Any thoughts on the command string?  
Also, how do I specify the folder on the client?  (c:\a\myfile.txt)

Thanks once again, the list has been very helpful.  Really, I hope this has to be my 
last question!

Joe.

Re: Re: Youch!

[John Jensen]

I do believe I have a mess on my hands.
Lacking any other guidance, I tried upgrading my mysql to 3.23 with 
an rpm on a Redhat Linux 6.1 system. I now have the same directory 
layout for mysql as on my Redhat 7 server, except there is no daemon 
to be found there. The only mysql daemon found anywhere is still in 
/usr/local/mysql/bin, and it still doesn't work. Attempts to execute 
no longer insist there is supposed to be a libexec directory. It just 
tells me it can't find any data in the var directory. When I ran 
scripts/mysql_install_db, it just tells me to remember to copy the 
support-files/mysql.server to the right place (wherever that is, if 
not where it is already) and to remember to set a password. That 
doesn't work either. It wants a /tmp/mysql.sock file, and I don't 
have one to give it.

Any ideas?

On 21 Feb 2001, at 16:29, Atle Veka wrote:

> 
> where's your mysqld located?
> 
> just change your safe_mysql script to contain the correct location of
> your mysqld binary.
> 
> also, i *think* mysqladmin -uroot -p[pass] shutdown
> is the preferred shutdown mechanism, didn't even know you could do
> that with mysql (client).
> 
> are you sure it's actually stopped? do a 'ps | grep mysqld' to find
> out ;)
> 
> 
> Atle
> 
> On Wed, 21 Feb 2001, John Jensen wrote:
> 
> > I had shut down the mysql daemon using:
> > bin/mysql -u root -p[password] shutdown
> > Now when I attempt to restart it using:
> > bin/safe_mysql &
> > it gives me the message:
> > [1] 2564
> > The file /usr/local/mysql/libexec/mysqld doesn't exist or is not
> > executable  Please do a cd to the mysql installation directory and
> > restart thisscript from there as follows:   ./bin/safe_mysql but
> > ./bin/safe_mysql just gave me the same message prefaced by: [2]
> > 2570 I checked and found the directory 'libexec' does not exist. I
> > can't recall it ever did. So now I am left wondering: "Why is it
> > trying to look in a non-existent direcory?" and "What went wrong?"
> > 
> > Any ideas?
> > 
> > 
> > John Jensen
> > 520 Goshawk Court
> > Bakersfield, CA 93309
> > 661-833-2858
> > 
> > 
> > - Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> > 
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try:
> > http://lists.mysql.com/php/unsubscribe.php
> > 
> 


John Jensen
520 Goshawk Court
Bakersfield, CA 93309
661-833-2858

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

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

Re: create table

[MikeBlezien]

On Fri, 23 Feb 2001 15:50:23 -0500, "Joe and Nancy M"
<[EMAIL PROTECTED]>   wrote:

>>What is wrong with this syntax, it looks like what chapter 7.7 says.
>>
>>mysql>  CREATE TABLE cur (FLD1 char(30), FLD2 numeric(6,2), FLD3 int(7));
>>
>>I get a parse error.

Joe,


I don't think "numeric" is a valid data type, numeric describes the various
numerical data types, but isn't actually a data type, like DECIMAL(m,d) or
FLOAT(m,d)


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















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

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

create table - NEVER MIND

[Joe and Nancy M]

Sorry, I tried it several times and kept getting the parse error.  It must have been 
butterfingers, worked ok now.

Thanks, Joe.

Re: before you post your question, PLEASE READ

[MikeBlezien]

On Fri, 23 Feb 2001 14:18:47 -0600, Ed Carp <[EMAIL PROTECTED]>   wrote:

>>Oh, this is so perfect ... just a little humor to brighten your otherwise dull and 
>boring Friday... ;)
>>
>>http://www.hwnd.net/pub/mskb/Q209354.asp

Excellent! :)


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















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

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

create table

[Joe and Nancy M]

What is wrong with this syntax, it looks like what chapter 7.7 says.

mysql>  CREATE TABLE cur (FLD1 char(30), FLD2 numeric(6,2), FLD3 int(7));

I get a parse error.

Thanks,
Joe.

Re: MySQL as spider database.

[Vahan Yerkanian]

Atle Veka wrote:
> 
> Why not use something that's already created for you, and is probably
> *much* faster than your solution :)

Oh... if it really was an acceptable choice, I won't post this question.
:))

> One example is ht://Dig (htdig.org).
>
> Atle

-- 
Vahan Yerkanian   Email: [EMAIL PROTECTED]
Leading Web Developer / Designer  Phone: (374) 158-2723
Web Development DepartmentFax:   (374) 128-5082
ARMINCO Global Telecommunications http://www.arminco.com

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

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

Re: MySQL as spider database.

[Atle Veka]

Why not use something that's already created for you, and is probably
*much* faster than your solution :)

One example is ht://Dig (htdig.org).


Atle

On Sat, 24 Feb 2001, Vahan Yerkanian wrote:

> Greetings All!
> 
> I'm in process of writing a web page indexer, which retrieves
> pages from a preset URL list, strips them from HTML tags, and
> inserts the text into a database. Now what I'm puzzled with is
> the table structure which holds the text information. Setting
> TEXT/BLOB fields as an indexes wasn't supported before 3.23.33,
> and I'm greatly concerned about the performance, as the site
> itself gets around 300,000 hits daily. Anyone with previous
> experience in this field could shed some light on this?
> I should be able to find 'Hello World!' in the table row with
> any of those keywords 'ell', 'lo Wo', 'Hell ld!', 'Hello', 'World',etc.
> 
> Thanks for your time,
> -- 
> Vahan Yerkanian   Email: [EMAIL PROTECTED]
> Leading Web Developer / Designer  Phone: (374) 158-2723
> Web Development DepartmentFax:   (374) 128-5082
> ARMINCO Global Telecommunications http://www.arminco.com
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


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

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

Re: UPDATE issues

[Atle Veka]

On Fri, 23 Feb 2001, Marty wrote:

>  My questions are:
>  a) does it matter what order you attempt to update the fields in?

Once again... No

>  b) is there a way to view what the warnings were?

and.. Yes. with PHP: mysql_error()


Atle


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

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

Replication time patch

[Sasha Pachev]

Just realized that a while ago, I fixed a bug in 3.23.33 with time 
replication, and forgot to post the fix to the public lists - just sent it to 
the user who reported the bug:

--- 1.86/sql/slave.cc   Wed Feb 14 12:51:49 2001
+++ 1.87/sql/slave.cc   Wed Feb 14 21:23:20 2001
@@ -857,7 +857,8 @@
 
 thd->server_id = ev->server_id; // use the original server id for logging
 thd->set_time();   // time the query
-ev->when = time(NULL);
+if(!ev->when)
+  ev->when = time(NULL);
 
 switch(type_code) {
 case QUERY_EVENT:   


-- 
MySQL Development Team
   __  ___ ___   __ 
  /  |/  /_ __/ __/ __ \/ /   Sasha Pachev <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Provo, Utah, USA
   <___/  

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

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

Re: Foxes Me ???

[James Cox]

are you sure the password is set properly in the mysql.user table? did you flush 
privileges after
setting it?

HTH,

James

- Original Message -
From: "Donald Korth" <[EMAIL PROTECTED]>
To: "mysql@lists. mysql. com" <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 7:40 PM
Subject: Foxes Me ???


Hello All !!!

I 'm in a rather strange position . I've a servlet that fetches data from a MySql DB . 
If the
database is without a password it works perfectly fine . Ironically if i assign a user 
name and
passwd to the DB the servlet doessn't seem to like it and throws up the foll :

"SQLState: 08S01 Message: Communication link failure: Bad handshake Vendor: 1043 " on 
the browser


java.sql.SQLException: Communication link failure: Bad handshake
at org.gjt.mm.mysql.MysqlIO.init(Compiled Code)
at org.gjt.mm.mysql.Connection.(Connection.java:230)
at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager.java:159)
at Shopper.(Shopper.java:21)
at java.lang.Class.newInstance0(Native Method)
at java.lang.Class.newInstance(Compiled Code)
at com.sun.web.core.ServletWrapper.loadServlet(ServletWrapper.java:90)
at com.sun.web.core.ServletWrapper.handleRequest(ServletWrapper.java:109
)
at com.sun.web.core.InvokerServlet.service(InvokerServlet.java:169)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at com.sun.web.core.ServletWrapper.handleRequest(ServletWrapper.java:140
)
at com.sun.web.core.Context.handleRequest(Context.java:375)
at com.sun.web.server.ConnectionHandler.run(Compiled Code)
Shopper: init

My servlet code is as follows :

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class Shopper extends HttpServlet
  {
 Connection con;
 PreparedStatement stmt, stmt1;
 ResultSet rs,rs1;
 ResultSetMetaData rsmd;
 int numcol;

 public Shopper()
   {
  try
 {
   Class.forName("org.gjt.mm.mysql.Driver").newInstance();
   String url="jdbc:mysql://localhost:3306/project?user=Donald&password=Donald";

 // If no password assigned to DB
 // String url="jdbc:mysql://localhost:3306/project";

   con=DriverManager.getConnection(url);
   stmt=con.prepareStatement("select * from productregister");
   stmt1 = con.prepareStatement("select * from productregister where code=?");
 }
 catch(java.lang.Exception ex)
 {
   ex.printStackTrace();
  }

 }

 public void doGet(HttpServletRequest req, HttpServletResponse res)
  throws ServletException, IOException
  {
..
   ...
  }

Any help would be deeply appreciated
Regards
Donald

--
God  gimme patience er ... but hurry up !!
--





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

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

MySQL Gui Won't connect

[Christopher McClan]

Hello,

The staticly compiled mySQL gui, comes up with the following when I start 
mysqlgui :

Can't connect to local mySQL server through socket (111)

I'm doing this as root, I have set a password, and managed to create a 
databse (using mysqladmin), and then play with it using the mysql command.

Help!

Thanks,

Christopher.


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

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

Re: an issue with my UPDATE query

[Atle Veka]

On Fri, 23 Feb 2001 [EMAIL PROTECTED] wrote:

> I am sending a rather large UPDATE query to a table with a handful of sequential 
>fields (i.e. color1, color2, color3, size1, size2, size3, etc).  The query is 
>generated and executed from within a PHP script, and to make the script more 
>efficient, the query is generated with a FOR loop, so that instead of updating the 
>fields in the order in which they exist in the table, they are updated according to 
>their number at the end of the field name. 
> 
> So for example "UPDATE table SET color1='red', size1='big', color2='', size2='', 
>color3='', size3='' where id=1"
> 
> when i execute the query from the mysql shell, however, one row is matched but no 
>changes are made and warnings are returned.
> 
> My questions are:
> a) does it matter what order you attempt to update the fields in?

No.

> b) is there a way to view what the warnings were?

Yes. http://www.php.net/manual/en/function.mysql-error.php

Are you sure you're not appending an extra comma at the end  of your set
command? Also, it's helpful to output the sql statement you're about to
execute before you do.


Atle


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

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

RE: INSERT/REPLACE lock up in 3.23.33

[Steven Roussey]

> > There can be another source of problems with REPLACE. As it has to
> > DELETE a row first, it might take a lot of time on huge table if MySQL
> > is not able for some reason to utilize index in order to locate  rows.
>
> Now this seems like it might be related. On a variable sized row
> table, this could be a source of problems. As a note, there is a
> unique index it should be using. Is there a way to see if it is,
> or USE INDEX like select?

Some clarification. On this table there are a lot of indexes, but there is
one unique/primary key, and it is that one that the replace should be
checking for. The other indexes have the same fields in different places
though. Table key def is something like this:

PRIMARY KEY (f,m),
KEY (f,d,a),
KEY (f,d,p,m),
KEY (u,d,a,f),
KEY (i,d,a,f),
KEY (l,d,a,f),
FULLTEXT(t,m),
FULLTEXT(a,e),
KEY (f,r,d,m)


Sincerely,

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


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

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

before you post your question, PLEASE READ

[Ed Carp]

Oh, this is so perfect ... just a little humor to brighten your otherwise dull and 
boring Friday... ;)

http://www.hwnd.net/pub/mskb/Q209354.asp

--
Ed Carp, N7EKG  [EMAIL PROTECTED]   940/367-2744 cell phone
http://www.pobox.com/~erc   [EMAIL PROTECTED] - text pager

I sometimes wonder if the American people deserve to be free - they seem
so unwilling to fight to preserve the few freedoms they have left.

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

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

RE: INSERT/REPLACE lock up in 3.23.33

[Steven Roussey]

> Safest thing for you is to use our latest 3.23 binaries which are
> statically linked with stable glibc and with some additional patches.

For this reason and greater simplicity :) I have been using your binaries
for a long time now. Part of the reason we never tested BDB tables...

> There can be another source of problems with REPLACE. As it has to
> DELETE a row first, it might take a lot of time on huge table if MySQL
> is not able for some reason to utilize index in order to locate  rows.

Now this seems like it might be related. On a variable sized row table, this
could be a source of problems. As a note, there is a unique index it should
be using. Is there a way to see if it is, or USE INDEX like select?

Sincerely,

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



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

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

MySQL as spider database.

[Vahan Yerkanian]

Greetings All!

I'm in process of writing a web page indexer, which retrieves
pages from a preset URL list, strips them from HTML tags, and
inserts the text into a database. Now what I'm puzzled with is
the table structure which holds the text information. Setting
TEXT/BLOB fields as an indexes wasn't supported before 3.23.33,
and I'm greatly concerned about the performance, as the site
itself gets around 300,000 hits daily. Anyone with previous
experience in this field could shed some light on this?
I should be able to find 'Hello World!' in the table row with
any of those keywords 'ell', 'lo Wo', 'Hell ld!', 'Hello', 'World',etc.

Thanks for your time,
-- 
Vahan Yerkanian   Email: [EMAIL PROTECTED]
Leading Web Developer / Designer  Phone: (374) 158-2723
Web Development DepartmentFax:   (374) 128-5082
ARMINCO Global Telecommunications http://www.arminco.com

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

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

UPDATE issues

[Marty]

I am sending a rather large UPDATE query to a table with a handful of
sequential fields (i.e. color1, color2, color3, size1, size2, size3,
etc).  The query is generated and executed from within a
 PHP script, and to make the script more efficient, the query is
generated with a FOR loop, so that instead of updating the fields in the
order in which they exist in the table, they are updated
 according to their number at the end of the field name.

 So for example "UPDATE table SET color1='red', size1='big', color2='',
size2='', color3='', size3='' where id=1"

 when i execute the query from the mysql shell, however, one row is
matched but no changes are made and warnings are returned.

 My questions are:
 a) does it matter what order you attempt to update the fields in?
 b) is there a way to view what the warnings were?

 many thanks if you can help me

 marty mulligan


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

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

Grant Table Privileges

[Support EzClickThru.net]

I have a user that I want to grant create,drop on %_ext to user@localhost but it does 
not like the wildcard in the tablename. I am creating heap tables and then dropping 
them but I want the user to have create and drop privileges only on those tables not 
all of them in the database. Is this possible or do I have specify each table name or 
* for all of them. 

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

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

Re: Why Doesn't This Work???

[Eric Fitzgerald]

Please read the documentation on date functions.  That looks like one of
your problems.

Secondly, your not using any '' to encase your strings.

- Original Message -
From: "Ben Ocean" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 11:12 AM
Subject: Why Doesn't This Work???


> Hi;
> I insert the following code in a file:
>
>  >>>
>$count = sql_command("select count(id) from calendar");
>$count = $count[0] + 1;
>$mydate = $month.','.$day.','.$year;
>echo $mydate;
>echo "";
>echo $time;
>echo "";
>echo $name;
>echo "";
>
>sql_query("insert into calendar (id, date, time, duration, name) values
> ($count, $mydate, $time, 'one hour', $name)");
>echo $mydate;
>echo "";
>echo $time;
>echo "";
>echo $name;
>echo "";
>echo $mydate;
>echo "";
>echo $time;
>echo "";
>echo $name;
>echo "";
> <<<
>
> and get the following result:
>
>  >>>
> February,26,2001
> 11:30
> Ben_Ocean
> February,26,2001
> 11:30
> Ben_Ocean
> <<<
>
> So all the variables are passing. Yet the mysql table isn't updated.
> *However*, if I substitute this line for the above:
>
>  >>>
>sql_query("insert into calendar (id, date, time, duration, name) values
> ($count, $count, $count, 'one hour', $count)");
> <<<
>
> it enters a new column in the table! Why?!
> TIA,
> BenO
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>


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

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

Re: Why Doesn't This Work???

[Atle Veka]

what language are you using?? it looks like maybe PHP?

try using some error functions to see what mysql has to say.


Atle

On Fri, 23 Feb 2001, Ben Ocean wrote:

> Hi;
> I insert the following code in a file:
> 
>  >>>
>$count = sql_command("select count(id) from calendar");
>$count = $count[0] + 1;
>$mydate = $month.','.$day.','.$year;
>echo $mydate;
>echo "";
>echo $time;
>echo "";
>echo $name;
>echo "";
> 
>sql_query("insert into calendar (id, date, time, duration, name) values 
> ($count, $mydate, $time, 'one hour', $name)");
>echo $mydate;
>echo "";
>echo $time;
>echo "";
>echo $name;
>echo "";
>echo $mydate;
>echo "";
>echo $time;
>echo "";
>echo $name;
>echo "";
> <<<
> 
> and get the following result:
> 
>  >>>
> February,26,2001
> 11:30
> Ben_Ocean
> February,26,2001
> 11:30
> Ben_Ocean
> <<<
> 
> So all the variables are passing. Yet the mysql table isn't updated. 
> *However*, if I substitute this line for the above:
> 
>  >>>
>sql_query("insert into calendar (id, date, time, duration, name) values 
> ($count, $count, $count, 'one hour', $count)");
> <<<
> 
> it enters a new column in the table! Why?!
> TIA,
> BenO
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


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

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

an issue with my UPDATE query

[marty]

I am sending a rather large UPDATE query to a table with a handful of sequential 
fields (i.e. color1, color2, color3, size1, size2, size3, etc).  The query is 
generated and executed from within a PHP script, and to make the script more 
efficient, the query is generated with a FOR loop, so that instead of updating the 
fields in the order in which they exist in the table, they are updated according to 
their number at the end of the field name. 

So for example "UPDATE table SET color1='red', size1='big', color2='', size2='', 
color3='', size3='' where id=1"

when i execute the query from the mysql shell, however, one row is matched but no 
changes are made and warnings are returned.

My questions are:
a) does it matter what order you attempt to update the fields in?
b) is there a way to view what the warnings were?

many thanks if you can help me

marty mulligan

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

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

Foxes Me ???

[Donald Korth]

Hello All !!!

I 'm in a rather strange position . I've a servlet that fetches data from a MySql DB . 
If the database is without a password it works perfectly fine . Ironically if i assign 
a user name and passwd to the DB the servlet doessn't seem to like it and throws up 
the foll :

"SQLState: 08S01 Message: Communication link failure: Bad handshake Vendor: 1043 " on 
the browser


java.sql.SQLException: Communication link failure: Bad handshake
at org.gjt.mm.mysql.MysqlIO.init(Compiled Code)
at org.gjt.mm.mysql.Connection.(Connection.java:230)
at org.gjt.mm.mysql.Driver.connect(Driver.java:126)
at java.sql.DriverManager.getConnection(Compiled Code)
at java.sql.DriverManager.getConnection(DriverManager.java:159)
at Shopper.(Shopper.java:21)
at java.lang.Class.newInstance0(Native Method)
at java.lang.Class.newInstance(Compiled Code)
at com.sun.web.core.ServletWrapper.loadServlet(ServletWrapper.java:90)
at com.sun.web.core.ServletWrapper.handleRequest(ServletWrapper.java:109
)
at com.sun.web.core.InvokerServlet.service(InvokerServlet.java:169)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at com.sun.web.core.ServletWrapper.handleRequest(ServletWrapper.java:140
)
at com.sun.web.core.Context.handleRequest(Context.java:375)
at com.sun.web.server.ConnectionHandler.run(Compiled Code)
Shopper: init

My servlet code is as follows :

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class Shopper extends HttpServlet 
  {
 Connection con;
 PreparedStatement stmt, stmt1;
 ResultSet rs,rs1;
 ResultSetMetaData rsmd;
 int numcol;

 public Shopper() 
   {
  try
 {
   Class.forName("org.gjt.mm.mysql.Driver").newInstance();
   String url="jdbc:mysql://localhost:3306/project?user=Donald&password=Donald";  
  
 // If no password assigned to DB
 // String url="jdbc:mysql://localhost:3306/project";  
 
   con=DriverManager.getConnection(url);
   stmt=con.prepareStatement("select * from productregister");
   stmt1 = con.prepareStatement("select * from productregister where code=?");
 }
 catch(java.lang.Exception ex)
 {
   ex.printStackTrace();
  }

 } 

 public void doGet(HttpServletRequest req, HttpServletResponse res)
  throws ServletException, IOException
  {
..
   ...
  }

Any help would be deeply appreciated
Regards
Donald 

--
God  gimme patience er ... but hurry up !!
--
 

Re: generic question re. image blobs in dbs

[Jason Landry]

Well, if you have other varchar fields in your table, then it probably
wouldn't have any impact on performance.  But since BLOBS and TEXT are
considered varchar, the table no longer is a fixed width.  It is my
understanding that MySQL can locate specific records faster (even with
indexes) in tables with fixed widths (i.e., no variable-length columns).


- Original Message -
From: "WCBaker" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 11:07 AM
Subject: generic question re. image blobs in dbs


> Hi!
>
> There is a consensus that blobs containing image files like .jpgs,  .gifs,
> etc. might better be stored just as links in the database,  with the
actual
> files in a directory pointed to by the database links.   Forgive my
> ignorance, but can someone explain a few of the more obvious reasons why
> this makes a difference?   For example, if I avoid SELECT * when referring
> to a table with blobs it seems to be pretty fast. . .So I'd only refer
> to the heavyweight column when absolutely necessary.   Does it take a lot
> longer to pull out the blob than it would to load the file contents into a
> browser?
>
> Thanks for any information you can impart!
>
> Cheers!
>
> -Warren
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



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

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

Why Doesn't This Work???

[Ben Ocean]

Hi;
I insert the following code in a file:

 >>>
   $count = sql_command("select count(id) from calendar");
   $count = $count[0] + 1;
   $mydate = $month.','.$day.','.$year;
   echo $mydate;
   echo "";
   echo $time;
   echo "";
   echo $name;
   echo "";

   sql_query("insert into calendar (id, date, time, duration, name) values 
($count, $mydate, $time, 'one hour', $name)");
   echo $mydate;
   echo "";
   echo $time;
   echo "";
   echo $name;
   echo "";
   echo $mydate;
   echo "";
   echo $time;
   echo "";
   echo $name;
   echo "";
<<<

and get the following result:

 >>>
February,26,2001
11:30
Ben_Ocean
February,26,2001
11:30
Ben_Ocean
<<<

So all the variables are passing. Yet the mysql table isn't updated. 
*However*, if I substitute this line for the above:

 >>>
   sql_query("insert into calendar (id, date, time, duration, name) values 
($count, $count, $count, 'one hour', $count)");
<<<

it enters a new column in the table! Why?!
TIA,
BenO


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

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

Re: Quoting numbers? (was Re:MySQL Tables)

[Rolf Hopkins]

Yes, and the confusion will arise no matter whether it's "visible" or not.
Nah!  I think I'd prefer to do it myself and have the compiler/interpreter
come up saying "hey buddy, what ya trying to do?  This ain't no number"
rather than it changing the number into string and happily continue on
running through the rest of the programming.  Takes you longer to figure out
you used the letter "O" instead of the number 0.


- Original Message -
From: "Julian Strickland" <[EMAIL PROTECTED]>
To: "'Rolf Hopkins'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 21:18
Subject: RE: Quoting numbers? (was Re:MySQL Tables)


> Tis true Rolf but you can bet your bottom dollar that at somepoint a
> confusion will arise
> when it is most inconvenient.
> There is always a conversion somewhere in the code even if it is not
> visible.
>
> > -Original Message-
> > From: Rolf Hopkins [SMTP:[EMAIL PROTECTED]]
> > Sent: 23 February 2001 02:09
> > To: Julian Strickland; [EMAIL PROTECTED]
> > Subject: Re: Quoting numbers? (was Re:MySQL Tables)
> >
> > That's very true but these days, some languages/databases allow for
> > strings
> > to be assigned to numbers and vice versa without the need for
conversion.
> > PHP is one such language, not that I'm bagging it or anything as I use
it
> > myself.  I just call it bad type checking.
> >
> > - Original Message -
> > From: "Julian Strickland" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, February 22, 2001 22:35
> > Subject: RE: Quoting numbers? (was Re:MySQL Tables)
> >
> >
> > > It's all to do with data types, traditionally and across most
languages
> > > quotes are used to delimit STRINGS
> > > and a string is NOT a number although may represent one when
displayed.
> > >
> > > > -Original Message-
> > > > From: Pete Harlan [SMTP:[EMAIL PROTECTED]]
> > > > Sent: 21 February 2001 20:51
> > > > To: [EMAIL PROTECTED]
> > > > Subject: Quoting numbers? (was Re:MySQL Tables)
> > > >
> > > > > I think you'll get better results if you don't quote your numbers.
> > > > Quotes
> > > > > should be used for text and dates (depending) but not numbers.
> > > >
> > > > Out of curiosity, why?
> > > >
> > > > We use quotes for numbers all the time here, for consistency's sake;
> > > > the programmer doesn't have to worry about the representation of,
say,
> > > > a salesman_id, but just reads/displays/stores it in the database.
> > > >
> > > > Aside from the fact that leaving them off is possible, is there a
> > > > standards/compatibility/other reason to do so?
> > > >
> > > > (An example of a good reason not to use them would be if the db
engine
> > > > weren't smart enough to use an index when you say
> > > >
> > > > select * from table_name where numeric_key = '1234'
> > > >
> > > > but possibly (probably?) all dbms's are that smart.)
> > > >
> > > > --Pete
> > > >
> > >
> -
> > > > Before posting, please check:
> > > >http://www.mysql.com/manual.php   (the manual)
> > > >http://lists.mysql.com/   (the list archive)
> > > >
> > > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > > To unsubscribe, e-mail
> > > >
<[EMAIL PROTECTED]>
> > > > Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
> > >
> > > -
> > > Before posting, please check:
> > >http://www.mysql.com/manual.php   (the manual)
> > >http://lists.mysql.com/   (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


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

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

Re: Redirection of SELECT with replicated databases

[Jeremy D. Zawodny]

On Fri, Feb 23, 2001 at 10:16:55AM +0100, Guido Adam wrote:
> 
> maybe a FAQ, but I didn't find it in the docs: We started to
> replicate our databases with the new features MySQL 3.23.33 offers.
> So far, so cool.
> 
> The documentations says something about SQL commands (i.e. SELECT)
> that are redirected from the master servers to the slaves.  How does
> that work? Is it an automatic redirection?

SELECT queries are not redirected and I don't think there are plans to
do so--at least I've not seen anyone mention it.

There has been discussion of implementing a redirect feature on the
SLAVE that will redirect non-read-only queries to the master.

Jeremy
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

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

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

Re: Using 'Key' as Column-Name

[MikeBlezien]

On Fri, 23 Feb 2001 18:56:08 +0100, "CGint" <[EMAIL PROTECTED]>   wrote:

>>I'm about to migrate from an MS-access to MySQL.
>>
>>I named my primary-key-columns 'Key'.
>>Now, if i try to query this column I get an error:
>>
>>mysql> SELECT key, description FROM project;
>>ERROR 1064: You have an error in your SQL syntax near 'key, description FROM 
>project' at
>> line 1
>>
>>If I try SELECT * FROM project; everything is ok.
>>
>>Then I tryed to rename 'key' to 'key1'.
>>Everything works fine without an error.
>>I have over 40 tables and I don't want to change all column-names AND the 
>application-querys!

This is one of those "reserved" words not allowed in MySQL. For a complete
listing reserverd words, go to:
http://www.mysql.com/doc/R/e/Reserved_words.html



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















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

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

Silent column changes and Indexes

[Mark Chalkley]

According to the MySQL manual (section 7.7.1), CHAR columns defined to be greater than 
3 chars in length are converted to type VARCHAR.  I understand the space efficiency 
issues involved here, but when the column is used in an index, doesn't that impose a 
performance penalty?  Or does MySQL handle indexes in a manner different from other 
RDBMS, so that this doesn't happen?

Thanks,

Mark Chalkley

P.S.  If this message ends up duplicated, I apologize.  I sent it a couple hours ago 
and it hasn't shown up on the list yet, so I'm resending it.F


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

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

Re: XML support under mySQL

[John Jensen]

I agree with Jeremy and Colin.
Its one thing to add functionalities, in terms of modules and 
interfaces, but adding to the core program is limited in it 
practicality, because it will just slow down execution or load-time 
or both. This penalizes users who don't happen to need the 
capabilities that you want added, and those who find that their old 
hardware is suddenly made inadequate by the latest upgrade.

This has been one of my long-standing complaints with Microsoft. One 
of my favorite Microsoft programs was the Cardfile that came with 
Win3.1. That funcftionality got incorporated into Outlook, but 
Outlook was a clumsy monstrosity by comparison, slow to load, too 
many steps to get at what you want, and I couldn't have multiple 
copies in memory with different lists on them. I still have Cardfile, 
but now, Win98 won't let me have more than one copy in memory. This 
is not progress; this is an imposition. I would rather see smaller 
seperate programs better integrated with each other, instead of a few 
clumsy monster, do-everything, programs.

On 22 Feb 2001, at 23:39, Jeremy D. Zawodny wrote:

> On Fri, Feb 23, 2001 at 08:26:08AM +0100, Gorjan Todorovski wrote: > >
> To Ed: Why be so negative about adding new features to the DB >
> server? Why not make things easier and make the DB more flexible by >
> supporting more standards for TRANSPORTING data.
> 
> I'm not Ed, but...
> 
> The answer is simple: it doesn't belong as a core service in the
> database server [in the opinions of several folks, including Ed].
> 
> As an add-on tool, sure. If someone writes a tool which turns MySQL
> data into some XML format on the fly, great. Or maybe the logic can be
> integrated into the client libraries. But I really don't think that
> the mysqld process show know how to do it.
> 
> Then again, it wouldn't be HARD to do. I just hope then if it happens,
> it is a compile-time default so that I can disable it on my servers.
> :-)
> 
> Jeremy
> -- 
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 328-7878Fax: (408) 530-5454
> Cell: (408) 439-9951
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]> To
> unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


John Jensen
520 Goshawk Court
Bakersfield, CA 93309
661-833-2858

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

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

Re: berkeley db

[Edward Peschko]

On Fri, Feb 23, 2001 at 11:20:03AM -0700, Ashley M. Kirchner wrote:
> Edward Peschko wrote:
> 
> > I *then* talked to berkeley db, and they said 'well, mysql distributes its own
> > copy of berkeleydb with modifications. Is this true? If so, where do I get it?
> 
> http://www.mysql.com/downloads/mysql-3.23.html
> 
> Scroll down, Berkeley DB 3.2.9a is listed.
> 
> AMK4

argh! They might want to put this IN A MORE PROMINENT PLACE ON THEIR HOMEPAGE.
After all, I tried configuring mysql *without* berkeley db and I *still* got
the damn error.

Anyways, does this '3.2.9a' version break anything in Berkeley DBI proper?

Ed

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

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

Re: berkeley db

[Ashley M. Kirchner]

Edward Peschko wrote:

> I *then* talked to berkeley db, and they said 'well, mysql distributes its own
> copy of berkeleydb with modifications. Is this true? If so, where do I get it?

http://www.mysql.com/downloads/mysql-3.23.html

Scroll down, Berkeley DB 3.2.9a is listed.

AMK4

--
W |
  |  I haven't lost my mind; it's backed up on tape somewhere.
  |
  ~
  Ashley M. Kirchner    .   303.442.6410 x130
  SysAdmin / Websmith   . 800.441.3873 x130
  Photo Craft Laboratories, Inc. .eFax 248.671.0909
  http://www.pcraft.com  . 3550 Arapahoe Ave #6
  .. .  .  . .   Boulder, CO 80303, USA



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

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

bug?? in DBI/libmysql??

[Kyle Hayes]

Using Linux 2.2.x, Perl 5.6

MySQL 3.23.x (several versions).

We have been using LAST_INSERT_ID to do sequence tables to generate unique 
IDs for use in several other tables.  

Sequence table:
CREATE TABLE seq_table ( id_val bigint(20) unsigned );

We use SQL like this: "UPDATE seq_table SET id_val=LAST_INSERT_ID(id_val + 1)"

This works fine.

We then use Perl DBI to get the last_update_id:

$dbh->{'mysql_insertid'}

This works great until the value of id_val is over that allowed by a 32-bit 
integer.  We use bigint fields for IDs.

We recently did a test where the ID field was more than 4 billion.  The $dbh 
line above returned a negative number where it should have returned a value 
around 6 billion.

We look in the sequence table and see '600051'.  We got back a fairly 
large negative number (-678294 or something, I don't have it handy) from the 
Perl code above.

We changed our Perl code to use SQL to retrieve the ID:

$sql = "SELECT LAST_INSERT_ID()"

$sth = $dbh->prepare($sql);

$sth->execute();

my ($id) = $sth->fetchrow_array();

This works and correctly returns the result of the UPDATE statement above.  

It appears that there is a problem in DBI or with the libmysql code.  We are 
using one of the most recent versions of DBI (the newest has only doc bug 
fixes as far as we could see).  If the value will fit in 32 bits, it seems to 
work.  If not, it won't.  Actually, it appears that one of these two pieces 
of code (DBI or libmysql) uses a signed 32-bit integer somewhere.  Alpha 
machines may not be effected by this.

Can someone help on this?  I have seen Tim Bunce on the list occassionally...

We are in the process of changing our code over to the longer method, but 
this seems like it is a bug.

Best,
Kyle

-- 
Kyle Hayes
Quicknet Technologies  t: +1 415 864 5225
520 Townsend St. Suite D  f: +1 415 864 8388
San Francisco, CA 94103 w: http://www.quicknet.net
USA

***
"HEAR THE DIFFERENCE" with a live MICROTELCO demo at:
Computer Telephony EXPO, Mar 6-8, Los Angeles, CA

MicroTelco is a revolutionary service that brings multiple Internet
Telephony Service Providers (ITSPs) together in a convenient,
simple to use account center for greater reliability and flexibility.
For more information visit: http://www.microtelco.com.

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

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

Re: generic question re. image blobs in dbs

[Hesham F. Anan]

You are absolutely correct
But in some situations, using BLOBs inside the database is more convinient.
Consider for the example the case where you might want to migrate the data
to another location. If some of the data are existing as external files,
this might be a very difficult process.
And allowing an external OS to manage some of the data might result in
dangling links if some one accidently deletes the external file.
About enhancing the performance of the queries, you can avoid using SELECT *
and select only the fields that you are interested in and only SELCT the
bolb objects when you need them

Hesham Farouk Anan
Computer Science Department
Old Dominion University
Norfolk, VA 23529


- Original Message -
From: "WCBaker" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 12:07 PM
Subject: generic question re. image blobs in dbs


> Hi!
>
> There is a consensus that blobs containing image files like .jpgs,  .gifs,
> etc. might better be stored just as links in the database,  with the
actual
> files in a directory pointed to by the database links.   Forgive my
> ignorance, but can someone explain a few of the more obvious reasons why
> this makes a difference?   For example, if I avoid SELECT * when referring
> to a table with blobs it seems to be pretty fast. . .So I'd only refer
> to the heavyweight column when absolutely necessary.   Does it take a lot
> longer to pull out the blob than it would to load the file contents into a
> browser?
>
> Thanks for any information you can impart!
>
> Cheers!
>
> -Warren
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


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

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

Using 'Key' as Column-Name

[CGint]

I'm about to migrate from an MS-access to MySQL.

I named my primary-key-columns 'Key'.
Now, if i try to query this column I get an error:

mysql> SELECT key, description FROM project;
ERROR 1064: You have an error in your SQL syntax near 'key, description FROM project' 
at
 line 1

If I try SELECT * FROM project; everything is ok.

Then I tryed to rename 'key' to 'key1'.
Everything works fine without an error.
I have over 40 tables and I don't want to change all column-names AND the 
application-querys!

Now my questions:
 - Can't I use 'key' as column-name ?

My System:
 - MySQL 3.23.33 on Windows NT4 SP4
 - local database via TCP/IP
 - query-tool: mysql
 - other-test-connection: JAVA 1.1.8 via JDBC-Driver mm.mysql-2.0.4 from Mark Matthews

Thanks a lot
CGint

Break the rules when it seems wise.

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

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

Upgrading MySql on RaQ4i

[James Raff]

Can anybody give a newbie some clear instructions on how to upgrade a Cobalt RaQ4i 
server running 3.22.32-1 to the latest 3.23.33 version. The Cobalt MySQL server 
installation originally used a .pkg file but cobalt have indicated a new .pkg install 
will screw up - its apparently not that simple! What do I do with the existing 
databases on 3.23.32? I have live data on 6000 companies on this site.

Jim Raff
www.masterbuildersonline.com

berkeley db

[Edward Peschko]

hey all,

I'm getting the following error when i try to compile 3.23.33 -

ha_berkeley.cc:105: type specifier omitted for parameter
ha_berkeley.cc:105: parse error before `)'
ha_berkeley.cc: In function `bool berkeley_init()':
ha_berkeley.cc:143: no matching function for call to `__db_env::set_noticecall (DB_ENV 
*&, void (&)(...))'
ha_berkeley.cc: At top level:
ha_berkeley.cc:292: type specifier omitted for parameter
ha_berkeley.cc:292: parse error before `)'
ha_berkeley.cc: In function `void berkeley_noticecall(...)':
ha_berkeley.cc:294: `notice' undeclared (first use this function)
ha_berkeley.cc:294: (Each undeclared identifier is reported only once
ha_berkeley.cc:294: for each function it appears in.)
ha_berkeley.cc:296: `DB_NOTICE_LOGFILE_CHANGED' undeclared (first use this function)
ha_berkeley.cc:297: warning: unreachable code at beginning of switch statement

I *then* look for the symbol 'DB_NOTICE_LOGFILE_CHANGED' in my berkeley 
distribution *and* my mysql distribution, but neither has the symbol defined.
Neither is 'db_notices', nor a whole bunch of other symbols.

I *then* talked to berkeley db, and they said 'well, mysql distributes its own
copy of berkeleydb with modifications. Is this true? If so, where do I get it?

Note, this is solaris-2.6. And, if you could, please respond to 
[EMAIL PROTECTED] I don't subscribe to the mysql list now (although I may
soon).

Ed

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

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

Re: replication slave can't find master binary log after shutdown in3.23.32

[Gerald L. Clark]

THis is a known problem. Upgrade to 3.23.33.

"J.A. Romero L." wrote:
> 
> >Description:
> 3.23.32 can't reestablish replication link after slave shutdown (fixed)
> >How-To-Repeat:
> Configure master and slave, start replicating then stop and restart the 
>slave.
> >Fix:
> file: sql/slave.cc, line: 516
> is written: mi->log_file_name[length]= 0; // kill \n
> should be: mi->log_file_name[length - 1] = 0; // kill \n
> 
> >Submitter-Id:  Jose A. Romero
> >Originator:Jose A. Romero
> >Organization:  Onet.pl - Poland
>   --
> Jose A. Romero L.
>   Programowanie Systemowe / IT @ Onet.pl
> [EMAIL PROTECTED]
>   "It is impossible to make anything foolproof because fools are so ingenious."
>   >
>   >MySQL support: none
>   >Synopsis:  replication slave can't find the master binary log after shutdown
>   >Severity:  non-critical
>   >Priority:  low
>   >Category:  mysql
>   >Class: sw-bug
>   >Release:   mysql-3.23.32 (Source distribution)
> 
>   >Environment:
> 
>   System: Linux joselo 2.2.17 #2 Wed Jan 3 12:07:49 UTC 2001 i686 unknown
>   Architecture: i686
> 
>   Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
>   GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.3/specs
>   gcc version 2.95.3 20010125 (prerelease)
>   Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
>   LIBC:
>   lrwxrwxrwx1 root root   14 Aug  1  2000 /lib/libc.so.5 -> 
>libc.so.5.4.46
>   -rw-r--r--1 root root   586720 Feb  9  1999 /lib/libc.so.5.4.46
>   lrwxrwxrwx1 root root   13 Feb  8 14:21 /lib/libc.so.6 -> 
>libc-2.2.1.so
>   -rwxr-xr-x1 root root  1078540 Jan 14 06:51 /lib/libc-2.2.1.so
>   -rw-r--r--1 root root  2471916 Jan 14 06:53 /usr/lib/libc.a
>   -rw-r--r--1 root root  178 Jan 14 06:53 /usr/lib/libc.so
>   -rw-r--r--1 root root   665216 Apr 24  2000 /usr/lib/libc-client.so.4.7
>   Configure command: ./configure  --localstatedir=/var/lib/mysql --prefix=/opt/mysql
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

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

LISP

[Thalis A. Kalfigopoulos]

Hi ppl,
is there a way I can have a LISP function talk to mysql (inserts/updates)? A 
search at the Mysql page for 'LISP' only revealed Monty's resume :-)

TIA,
thalis


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

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

generic question re. image blobs in dbs

[WCBaker]

Hi!

There is a consensus that blobs containing image files like .jpgs,  .gifs,
etc. might better be stored just as links in the database,  with the actual
files in a directory pointed to by the database links.   Forgive my
ignorance, but can someone explain a few of the more obvious reasons why
this makes a difference?   For example, if I avoid SELECT * when referring
to a table with blobs it seems to be pretty fast. . .So I'd only refer
to the heavyweight column when absolutely necessary.   Does it take a lot
longer to pull out the blob than it would to load the file contents into a
browser?

Thanks for any information you can impart!

Cheers!

-Warren


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

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

Re: More Innobase questions (Was: RE: Innobase)

[Heikki Tuuri]

Peter and Sander,

relevant questions, I will try to answer them.

>Good questions - I have a few more :)
>A) why does it seem to use fixed-size storage units. (The files)

I have copied the concept of a tablespace consisting of a small
number of files from Oracle. When the database itself manages
disk space, it can reduce disk fragmentation by using its own
file space allocation algorithm. Innobase uses an algorithm similar
to the Fast File System used in some Unixes. Also, one can use
raw disks to totally eliminate the disk fragmentation caused by the
operating system.

>B) what happens when they ar full?

You have to shut down the database and add a new file to the
configuration file my.cnf.

>C) can it auto-create new files as demand grows?

Not currently. I think no database currently can auto-create
disk drives either :).

>D) can you safely add new files when there is data in them already?

Yes you can, but you have to shut down the database first.

>Sander> -Original Message-> From: Peter Zaitsev [mailto:[EMAIL PROTECTED]]

> Sent: 22 February 2001 19:52> To: [EMAIL PROTECTED]> Subject: Innobase> > 
> Hello mysql,> 
>   Today I got a chance to compile mysql 3.23.34 with innobase, so
>   althought it's not out yet I'll give some of my comments> 
>   The version I'm speaking about got from work.mysql.com> 
>   1) It does not even configure then trying to configure
>   --with-innobase-db the problem is autoconf is not called in innobase
>   directory so configure script is not created

In the source distribution there will be the files generated by
autoheader etc., you will not need to generate them in your machine.

>   2) innobase_data_home_dir   used as prefix, so if we'll not end it
>   with "/" we'll have files prefixed by directory name created in
>   upper level directory. This may be expected behavior but if so it
>   should be described in the manual.

I have to modify the code so that it adds the '/' or '\'.

>   3) Data files somehow are created with "x" attribute which I think
>   is not quite right
> drwxr-xr-x  19 root root  366 Feb 22 21:32 ..
> -rwxrwx--x   1 root root 1073741824 Feb 22 21:36 ibdata1
> -rwxrwx--x   1 root root 1073741824 Feb 22 21:08 ibdata2
> -rwxrwx--x   1 root root 1073741824 Feb 22 21:09 ibdata3
> -rwxrwx--x   1 root root 1073741824 Feb 22 21:09 ibdata4

Sorry, I will fix that. You are not supposed to execute database
data files :).

>   4) Currently ATIS test fails with innobase table:> Retrieving data
> Warning: Query 'select 
> city.city_name,state.state_name,city.city_code from state,city 
> where city.state_code=state.state_code' returned 1 rows when it 
> should have returned 11 rows> Got error:  when executing select 
> flight.flight_code,aircraft.aircraft_type from flight,aircraft 
> where flight.aircraft_code=aircraft.aircraft_code> got 0 instead of 579 ***> 

You may have an outdated version of the MySQL source distribution.
(I am currently exchanging lots of emails with Peter and looking at the
problem.)

>  5) Then started first time mysql creates innobase datafiles long
>  during startup which I think should be also mentioned in the manual -
>  I thought it's hanged up.> 

To avoid file fragmentation done by the operating system, Innobase
physically writes its data files full at database creation, so that
the space is physically occupied.

>  6) There is currently a serious lack of documentation - is there any
>  additional information about innobase tables ? For example how does
>  tables distributed over data files (I'e if putting them on different
>  disks will improve perfomance) Other thing is what should I do if I
>  somehow lose one file - will I be able to recover data at least
>  partitially ?  What is idea ? Is it better to make small files or one
>  big file if you OS supports this ? How may I backup table  ? Only
>  with mysqldump ?

I am writing more documentation, forgive me the sparseness. Your
questions will also influence the documentation.

Currently, user has no control over how tables are stored in the data files,
because the data files form a single tablespace. In future you will
be able create several tablespaces like in Oracle, and specify the
tablespace where the table is stored.

For best performance, you should create big files, so that disk
seeks are minimized.

If you lose a file, you must do an archive recovery from a backup,
using archived log files of MySQL, (not log files of Innobase).

Currently, to take a backup you have to shut down the database,
check that it shuts down without errors, and copy your whole data
files to a backup place. There is no incremental backup currently,
nor a hot (online) backup. The support for a hot backup is built in,
but there currently is no user interface for it.

To backup an individual table you have to dump it. It is a good idea
to take dumps now and then anyway, because a logical text file is
always your safest backup of a database 

BLOB Objects

[Hesham F. Anan]

Hi

How can I store a BLOB object (image file) into MySQL database ?
Could you give me a sample SQL for this ?

Hesham Farouk Anan
Computer Science Department
Old Dominion University
Norfolk, VA 23529

 

Re: 3.23 "Online Table Maintenance"?

[Hardy Merrill]

What privileges does a MySQL user need to execute the CHECK TABLES
command on a table?  Is it possible to GRANT very limited privileges
to a "chktbl" user so that all that user can do is "CHECK TABLES"?
But privs that will also allow that user to CHECK TABLES on tables
for *any* database in MySQL?

TIA.

-- 
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com


Sinisa Milivojevic [[EMAIL PROTECTED]] wrote:
> Hardy Merrill writes:
>  > In the 3.23 news article, at the bottom it says this:
>  > 
>  > 
>  > 
>  >  Online Table Maintenance 
>  > 
>  >  MySQL 3.23 now incorporates many of the table maintanence
>  >  features of the (previously only external) utilities
>  >  `(my)isamchk' directly into the MySQL server.  The use of
>  >  these newly incorporated features can help to eliminate
>  >  system downtime, by allowing the Database Administrator to
>  >  repair damaged tables without shutting-down the MySQL server.
>  > 
>  > Where can I find additional information about the table maintenance
>  > features that have now been incorporated into the MySQL server?
>  > 
>  > TIA.
>  > 
>  > -- 
>  > Hardy Merrill
>  > Mission Critical Linux, Inc.
>  > http://www.missioncriticallinux.com
>  > 
> 
> 
> Hi!
> 
> In the manual. Look for CHECK TABLE and REPAIR TABLE commands.
> 
> 
> Regards,
> 
> Sinisa
> 
>     __ _   _  ___ ==  MySQL AB
>  /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
>/*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
>   /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
>   /*/^^^\*\^^^
>  /*/ \*\Developers Team

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

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

Re: Binary distribution on FreeBSD4.0

[Vivek Khera]

> "d" == drew  <[EMAIL PROTECTED]> writes:

d>Just wondering if anyone could help me out here? I have recently 
d> downloaded the binary distribution of mysql for FreeBSD (mysql-
d> 3.23.32-unknown-freebsdelf4.2-i386.tar.gz). Now my problem is 
d> probably an easy fix but here goes. When I try and run 

Your best bet on FreeBSD is to build the MySQL port form /usr/ports.
It is really well done.


-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED]   Rockville, MD   +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

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

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

Re: Changing field types?

[Gerald L. Clark]

Maybe because text doesn't have a fieldlenfth.
Daniel Alsén wrote:
> 
> Hi!
> 
> I have a table where a textfield is set to VARCHAR and 255 as maximum
> length. I need to change that to a fieldtype that can hold more text. I
> tried changing the type to TEXT and 2000 as fieldlength. But i only get a
> syntax error.
> 
> Isn´t it possible to make that change? If not, what can i do to make the
> field hold more characters?
> 
> Regards
> ## Daniel Alsén  | http://www.eyebee.com #
> ## Innehållsbolaget  | ICQ: 63006462 #
> ## [EMAIL PROTECTED] | Fax: +46 8 4100 1650  #
> ## +46 8 4100 1605   | Mob: +46 709 93 57 05 #
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

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

MySQL GUI

[Ward, Brian]

Any idea why the create or edit table don't seem to do anything? I select
them and nothing happens?

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

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

Re: MySQL defuncting on heavy use

[Richard Lohwasser]

>> probability of defuncting increases. with 350 connections the bug occurs
>> really seldom (once a week or so), with 360 threads in the next hour and
>> with 370 threads nearly immediately.

>Did you try to increase system resources available for MySQL : number of
>sockets (per process as well as total available to system), maximum number
>of processes, etc. ? Maybe it's just your system runs out of resources.

I've already incresed the max amount of user processes from 256 to 2048, but
I didn't try increasing the nr. of sockets!
Do you have an url that explains how I increase sockets / process and
sockets / system ?

thx


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

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

Re: Is sequencing possible in Mysql?

[Gerald L. Clark]

Create a unique key on the id, or date,id.
If you insert first, and update if the insert fails, you don't have to
lock anything. Inserts and updates are atomic. 

"Opec Kemp ( Ozemail )" wrote:
> 
> Basically you'd have a DB set up like this:
> 
>hits_table  main_table
> +--+   +-+
> | id   | (long int) <- |  id |
> +--+   +-+
> |  num_hits| (long int)| foobar  |
> +--+   +-+
> | date_created | (date/time)   | bar |
> +--+   optional! :)+-+
> 
> 
> So when you want to create a new record you'd do:
> 
> 1) Lock the table "hits_table"
> 2) Check to see if the ID already exists in the hits_table
>SELECT * FROM hits_table WHERE id = (your id here)
>If Id exists, then just update
>   UPDATE hits_table SET num_hits = num_hits + 1 WHERE id = (your
> id)
>else
>   INSERT INTO hits_table(id, num_hits) VALUES (123, 1);
>end if
> 
>Optionally when you check to see if the ID exists, you might want
> to
>check for today's date as well. That is if you wanted to keep the
>histical records of all your hits. This will come in handy
>when you do your reporting ie you can get a break down of all
>hits per day, month, year etc etc. So do that your SQL
>would be something like
> 
>SELECT * FROM hits_table WHERE id = (your id here) AND
>Date(date_created) = CURRDate()
> 
>If Id exists, then just update
>   UPDATE hits_table SET num_hits = num_hits + 1
>   WHERE id = (your id) AND TO_DAYS(date_created) = TO_DAYS(NOW());
>else
>   INSERT INTO hits_table(id, num_hits, date_created) VALUES (123,
> 1, NOW());
>end if
> 
> 3) Unlock the table "hits_table"
> 
> 
> 
> HTH
> 
> > Opec,
> >   Thanks for the response. I will lock the table. That
> > would be important
> > because I have 3 different websites pulling the same info.
> > Do you have an
> > example that would help me know how to get started setting
> > that up or a link
> > perhaps?
> > Thanks a ton.
> > Alan
> >
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

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

replication slave can't find master binary log after shutdown in3.23.32

[J.A. Romero L.]

>Description:
3.23.32 can't reestablish replication link after slave shutdown (fixed)
>How-To-Repeat:
Configure master and slave, start replicating then stop and restart the slave.
>Fix:
file: sql/slave.cc, line: 516
is written: mi->log_file_name[length]= 0; // kill \n
should be: mi->log_file_name[length - 1] = 0; // kill \n

>Submitter-Id:  Jose A. Romero
>Originator:Jose A. Romero
>Organization:  Onet.pl - Poland
  --
Jose A. Romero L.
  Programowanie Systemowe / IT @ Onet.pl
[EMAIL PROTECTED]
  "It is impossible to make anything foolproof because fools are so ingenious."
  >
  >MySQL support: none
  >Synopsis:  replication slave can't find the master binary log after shutdown
  >Severity:  non-critical
  >Priority:  low
  >Category:  mysql
  >Class: sw-bug
  >Release:   mysql-3.23.32 (Source distribution)

  >Environment:

  System: Linux joselo 2.2.17 #2 Wed Jan 3 12:07:49 UTC 2001 i686 unknown
  Architecture: i686

  Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
  GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.3/specs
  gcc version 2.95.3 20010125 (prerelease)
  Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''  LDFLAGS=''
  LIBC:
  lrwxrwxrwx1 root root   14 Aug  1  2000 /lib/libc.so.5 -> 
libc.so.5.4.46
  -rw-r--r--1 root root   586720 Feb  9  1999 /lib/libc.so.5.4.46
  lrwxrwxrwx1 root root   13 Feb  8 14:21 /lib/libc.so.6 -> 
libc-2.2.1.so
  -rwxr-xr-x1 root root  1078540 Jan 14 06:51 /lib/libc-2.2.1.so
  -rw-r--r--1 root root  2471916 Jan 14 06:53 /usr/lib/libc.a
  -rw-r--r--1 root root  178 Jan 14 06:53 /usr/lib/libc.so
  -rw-r--r--1 root root   665216 Apr 24  2000 /usr/lib/libc-client.so.4.7
  Configure command: ./configure  --localstatedir=/var/lib/mysql --prefix=/opt/mysql


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

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

Re: Help on default value in set column

[MikeBlezien]

On Fri, 23 Feb 2001 15:54:03 +0100, Yong Li <[EMAIL PROTECTED]>
wrote:

>>Hi,
>>
>>I wanted to create a column with type set, and to specify a default
>>value for this column, but I always got either SQL syntax error or
>>invalid default value error. What is the right syntax for doing this?
>>or, it's impossible to do this?
>>
>>I am using MySQL 3.23.25.
>>

col_name SET ("val1","val2") DEFAULT ""; # empty SET if not NULL

Cheers,


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















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

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

a query which cannot be fast even theoretically?

[Artem Koutchine]

Hi!

Here is a worst case i have even seem so far:

create table aa(
some_numberint unsigned not null,
indexaa_sn (some_number)
);

create table bb(
min_numberint unsigned not null,
max_numberint unsigned not null,
range_typechar(1) not null,
primary key (min_number, max_number)
);

now we put 25000 records into aa and 1000 into
bb and try to figure out in what range each number in aa:

select some_number, range_type from aa inner join bb on
some_number>=min_number
and  some_number<=max_number;

I use inner join because number which are not in one of the ranges are
not interesting to me.

Explain gives 25000x1000 rows to  scan and range check w/o
using index. So, the select take about 7 minutes to complete.

Is there any way to make such case faster. The problems is that
I don't know ranges until aa has all the data, so i cannot
figure out the range while inserting into aa. Tricky business.

Any ideas?
Not really impirtant, but i thought i would an interesting task.

Regards,
Artem


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

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

Re: Antwort: ReisserFS

[Tim Bunce]

On Fri, Feb 23, 2001 at 11:29:21AM +0200, Tõnu Samuel wrote:
> [EMAIL PROTECTED] wrote:
> > 
> > On 22.02.2001 16:22:13 Simon Windsor wrote:
> > 
> > > Has anyone user MySql on a ReisserFS file system ?
> > 
> > HERE!
> > 
> > No problems whatsoever - why should there be problems anyway?
> 
> Only problem we know is that in our tests on ReiserFS is MySQL was 30%
> faster on writes :/

How does it compare to FreeBSD with "soft updates" enabled?

Tim.

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

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

Re: MySQL defuncting on heavy use

[Maciek Dobrzanski]

> probability of defuncting increases. with 350 connections the bug occurs
> really seldom (once a week or so), with 360 threads in the next hour and
> with 370 threads nearly immediately.

Did you try to increase system resources available for MySQL : number of
sockets (per process as well as total available to system), maximum number
of processes, etc. ? Maybe it's just your system runs out of resources.


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

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

any ASP/ADO/MySQL programmers out there?

[Henrik Lebtien Mohr]

Hi there!

If any of you have tried the following with ASP/ADO and MySQL, please inform
me of how you did it:

I use ASP and adodb.recordset to connect to a MySQL-database.
I use the following code to insert into the db:

[CODE START]
set rsGroup = server.CreateObject("adodb.recordset")
sql = "tblGroup"
rsGruppe.Open sql, connect

with rsGroup
.AddNew
.Fields("group_name") = strGName
.Fields("group_slogan") = strGSlogan
.Update
end with
[CODE END]

Now - the thing I have to do in the next line is, to get the (auto
incremented, indexed and unique) group_id of the newly inserted group from
tblGroup.

How do I do that? Can I call the last_insert_id() function in MySQL through
the recordset in some way? Or any other suggestions?

When I used Access-databases instead of MySQL, I could just call
rsGroup("group_id") in the next line of code, which would return the correct
group_id.

Please help, anybody!?

Kind regards,
Henrik Mohr, Denmark


w e b d a t a . d k
..

[EMAIL PROTECTED]
mob: +45 26 24 26 27

store kongensgade 36, 5.
postbox 9038
dk-1264 københavn k
tel. +45 70 20 11 60
fax. +45 70 20 11 61
http://webdata.dk
mail:[EMAIL PROTECTED]


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

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

Help on default value in set column

[Yong Li]

Hi,

I wanted to create a column with type set, and to specify a default
value for this column, but I always got either SQL syntax error or
invalid default value error. What is the right syntax for doing this?
or, it's impossible to do this?

I am using MySQL 3.23.25.

Thanks in advance.

Yong Li

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

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

Re: INSERT/REPLACE lock up in 3.23.33

[Artem Koutchine]

Hi!

You have probably missed the original message. I have pointed that
I have build Mysql 3.23.33 from the original TAR ball on
FreeBSD 4.2-STABLE using comiler options  which are used
in the port of MySQL for FreeBSD, so it does not crush
on high loads. After all this i am getting server crushed by
using INSERT DELAYED.

As for REPLACE/INSERT lockup, i figured that it could
happen when there is no space left on device.

Artem

- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 3:23 PM
Subject: Re: INSERT/REPLACE lock up in 3.23.33


> Steven Roussey writes:
>  > > My troubles continue with INSERTs (i posted a message about
INSERT
>  > > DELAYED crushing a server before). Now, I have this:
>  >
>  > We are running Linux and MySQL 3.23.30 and have similar problems.
In
>  > particular we have a lot of INSERT DELAYEDs into a fixed table,
and REPLACE
>  > DELAYED into a variable size table. At some point the handlers
never finish
>  > a query and then fill up handler, then fill up all other
processes with
>  > queries that are waiting for the table and then I have to kill -9
it from
>  > the commandline.
>  >
>  > This only seems to happen if the tables are really big for the
REPLACEs.
>  > I've tested it starting with multi-GB tables and then with empty
ones. I see
>  > the slow query and lock up situation with the bigger tables.
>  >
>  > I can't make a real test case, save for copying from one multiGig
table into
>  > another, perhaps, while also streaming in other log data into the
logging
>  > table we have. I wish we could have a replay software so it gets
the timing
>  > the same to see what is going on thread-wise.
>  >
>  > Oh, well. Let me know if you figure this out.
>  >
>  > Sincerely,
>  >
>  > Steven Roussey
>  > Network54.com
>  > http://network54.com/?pp=e
>  >
>  >
>
>
> Hi!
>
> Only few words. Problems with DELAYED ops on Linux are usually
related
> to broken LinuxThreads.
>
> Safest thing for you is to use our latest 3.23 binaries which are
> statically linked with stable glibc and with some additional
patches.
>
> There can be another source of problems with REPLACE. As it has to
> DELETE a row first, it might take a lot of time on huge table if
MySQL
> is not able for some reason to utilize index in order to locate
rows.
>
>
> Regards,
>
> Sinisa
>
>     __ _   _  ___ ==  MySQL AB
>  /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
>/*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
>   /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
>   /*/^^^\*\^^^
>  /*/ \*\Developers Team
>
>
>
> 
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
>
>


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

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

Antwort: Changing field types?

[alexander . skwar]

On 23.02.2001 13:35:33 ?iso-8859-1?Q?Daniel_Als=E9n?= wrote:

> tried changing the type to TEXT and 2000 as fieldlength. But i only get a
> syntax error.

What did you type and what was the error?  Maybe the VARCHAR field was indexed
without bounds?  That's not possible for BLOB types; you have to specify a limit
for the index length when you index a BLOB type.  Further, you cannot specify
the length of a BLOB type.



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

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

Antwort: Saving pictures in MySql

[alexander . skwar]

On 23.02.2001 13:01:44 Danie Weideman wrote:

> What field type must be defined for pictures.

MEDIUMTEXT for the data
VARCHAR/ENUM/INTEGER/whatever for the image type

> How to load and retreive pictures from a database using PHP

The same you do with "normal" data.  Ie.:
Store:INSERT INTO Table (ImageType, ImageData) VALUES ( ,
 )
Retrieve: SELECT ImageType, ImageData FROM Table  WHERE ID = 



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

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

Re: Mysql Table via php

[Steve Edberg]

At 12:48 PM -0500 2/22/01, Joe and Nancy M wrote:
>I finally got my ISP to resolve the issues with connecting to my db. 
>I have a test table in the database named test.  I have 3 fields; 
>ID(20Char), PRICE(int),QTY(int).  I am using php (this is what my 
>ISP supports and suggested).
>
>I can connect using:
>
>$link = mysql_connect ("localhost.domainnamehere.com.", 
>"usernameherel", "passwordhere")
>
>or die ("Could not connect");
>
>
>?>
>
>I can draw the data out using this sample code:
>
>
>$query = "SELECT ID, PRICE, QTY
>
>FROM test
>
>where PRICE=3";
>
>$result = mysql_query ($query)
>
>or die ("Query failed");
>
># fetch rows in reverse order
>
>for ($i = mysql_num_rows ($result) - 1; $i >=0; $i--) {
>
>if (!mysql_data_seek ($result, $i)) {
>
>printf ("Cannot seek to row %d\n", $i);
>
>continue;
>
>}
>
>if(!($row = mysql_fetch_object ($result)))
>
>continue;
>
>printf ("%s %s %s\n", $row->ID, $row->PRICE, $row->QTY);
>
>}
>
>mysql_free_result ($result);
>
>?>
>
>
>
>1.  I can not seem to get the syntax correct to select where the 
>ID=text value.  I get parse errors with almost every scenario.  What 
>is the correct string to select where a character field is equal to 
>a value???


You need to single quote the value:

$query = "SELECT ID, PRICE, QTY FROM test where id='text value'";


>2.  I primarily need to select one record from the table and display 
>the PRICE on the webpage and show a hyperlink "buyme" where QTY is 
>gt 0.  Does someone have a sample piece of php that will handle 
>this??


Well, this is a bit of a vague description, but here goes:

$id = 'some value';

$query = "SELECT id,price,qty FROM test WHERE id='$id'";
$result = @mysql_query($query) or die('Arrrghhh');

if (mysql_num_rows($result) != 1)
{
#   Do some error checking here: no record found or multiple 
records w/same id
}
else
{
echo 'Buy one now';
}


Also, there are a few things to note about the code you originally 
posted (above).

* you do not have an 'order by' in your sql statement. MySQL - and 
any relational database - will not necessarily return the results in 
any particular order without one. This will probably bollix up your 
fetching in 'reverse order'...there is no particular 'forward' order, 
so there ain't a REVERSE order.

* assuming you actually want the order to be by ID, why not let the 
database handle as much of the work as possible? It's faster at it 
than you & php:

$query = "SELECT ID, PRICE, QTY FROM test where PRICE=3 order 
by id desc";
#   'desc' means to sort in descending order - ie, from z -> a

$result = mysql_query ($query) or die ("Query failed");

while ($d = mysql_fetch_object($result))
{
printf ("%s %s %s\n", $row->ID, $row->PRICE, $row->QTY);
}
mysql_free_result ($result);


>
>
>
>Thanks, I am running very short on time
>
>Joe.

-- 
+--- "They've got a cherry pie there, that'll kill ya" --+
| Steve Edberg   University of California, Davis |
| [EMAIL PROTECTED]   Computer Consultant |
| http://aesric.ucdavis.edu/  http://pgfsun.ucdavis.edu/ |
+-- FBI Special Agent Dale Cooper ---+

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

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

CREATE/DROP DATABASE bug in mysql client

[Maciek Dobrzanski]

>Description:
The manual says that starting from MySQL 3.23.6, any combination
of characters is allowed for a database name (excluding '/', ASCII(0) and
ASCII(255)). I created database that name consist only of numbers
using mysqladmin tool, but I was unable to drop it using mysql command
line client (neither I was able to create database with that kind of
name):

ERROR 1064: You have an error in your SQL syntax near '12345' at line 1

 >How-To-Repeat:
mysqladmin create 12345
echo "drop database 12345" | mysql

>Release:   mysql-3.23.33 (Source distribution)
>Server: /usr/local/bin/mysqladmin  Ver 8.0 Distrib 3.22.32, for -freebsd4.2
on i386
TCX Datakonsult AB, by Monty

Server version  3.23.33
Protocol version10
Connection  Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 11 min 28 sec

Threads: 2  Questions: 399824  Slow queries: 0  Opens: 24  Flush tables: 1
Open tables: 12 Queries per second avg: 581.140
>Environment:

System: FreeBSD commonwealth.interia.pl 4.2-RELEASE FreeBSD 4.2-RELEASE #1:
Fri Feb 23 12:39:22 CET 2001 [EMAIL PROTECTED]
ia.pl:/usr/src/sys/compile/COMMONWEALTH  i386


Some paths:  /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='cc'  CFLAGS='-mcpu=pentiumpro -march=pentiumpro'
CXX='c++'  CXXFLAGS='-mcpu=pentiumpro -march=pentiumpro -fel
ide-constructors -fno-rtti -fno-exceptions'  LDFLAGS=''
LIBC:
-r--r--r--  1 root  wheel  1169076 Nov 20 12:59 /usr/lib/libc.a
lrwxrwxrwx  1 root  wheel  9 Feb 23 12:51 /usr/lib/libc.so -> libc.so.4
-r--r--r--  1 root  wheel  559196 Nov 20 12:59 /usr/lib/libc.so.4
Configure command:
./configure  --localstatedir=/home/mysqld/data --without-perl --without-debu
g --without-readline --without-bench
--with-mit-threads=no --with-libwrap --with-low-memory --enable-assembler --
with-charset=latin2 --prefix=/usr/local/mysql i386--free
bsd4.2
Perl: This is perl, version 5.005_03 built for i386-freebsd

--

Maciek Dobrzanski [EMAIL PROTECTED]
INTERIA.PL @ http://www.interia.pl/ +48 (12) 638 07 70
   ul. Krolewska 57, 30-081 Krakow



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

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

Replication

[Simon Windsor]

Hi

The new replication features in 3.23 look really good, but appears to limit you to a 
single replication thread per mysql configuration.

We currently have a number of totally independant production databases and are 
considering using replication in 3.23 to enhance
our backup/recovery stategy.

The only way I can see doing this with a single backup server is to use multiple mysql 
configuartions, one for each production database.

Does anyone know if it is possible to allow a single client to read from multiple 
masters ?

Simon
-- 
Simon Windsor

CricInfo http://www.cricinfo.com/
Tel: +44 (0) 1249 700744
Fax: +44 (0) 1249 700725
Email: mailto:[EMAIL PROTECTED]

This email message is for the sole use of the intended recipient(s) and may contain
confidential and privileged information.  Any unauthorized review, use, disclosure or
distribution is prohibited.  If you are not the intended recipient, please contact the
sender by reply email and destroy all copies of the original message.  Thank you for 
your
cooperation and assistance. 

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

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

MySQL defuncting on heavy use

[Richard Lohwasser]

>Description:
on heavy use (350-370 mysql threads, connections opened by multiple
apache webservs) one of the mysql threads suddenly defuncts and mysql does
not accept or serve any connections anymore. if more threads are opened the
probability of defuncting increases. with 350 connections the bug occurs
really seldom (once a week or so), with 360 threads in the next hour and
with 370 threads nearly immediately.
if you connect with the mysql client no response is given at all, and all
other opened threads do not respond and just idle. if you try to stop mysqld
with the redhat mysql shutdown scripts, mysqld doesn't stop. "waiting for
mysql to exit ..." keeps returning ~20 times and nothing happens. the only
solution is to reboot the computer, fix the now corrupted tables with
myisamchk and restart mysql.
what's really weird is that no errors can be found afterwars in the error
logs of the system / of mysql. mysql simply stops working.
I have 2 mysql servers running with the same setup and the same bug occurs
at both machines.

this problem is about the same as metioned in
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:23855 except that I don't get
any error messages in the errorlogfile, not even the "Aborted connection xx
to xx..." error.
i have already increased my file descriptor limit from 1024 to 4096 but it
didn't change anything.

>How-To-Repeat:
didn't find a way to repeat it yet.
>Fix:
limiting the load of the db server to less than 350 threads. with
less threads and less load everything works perfect. but the servers are
only running at about 20% of their capacity with these limits, since it's
impossible to increase it

>Submitter-Id:  
>Originator: Richard Lohwasser, [EMAIL PROTECTED]
>Organization:
 clanintern GmbH (www.clanintern.com)
>MySQL support: none (yet :)
>Synopsis:  MySQL defuncting on heavy use
>Severity:  serious
>Priority:  high
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.29-gamma (Source distribution)

>Environment:
dual p3-800 with 1gb ram and raid1-u160 harddrives running on red hat 7
System: Linux sql1.clanintern.de 2.2.18pre24b010125/2 #25 SMP Tue Feb 20
17:42:03 CET 2001 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 2731 (Red Hat Linux 7.0)
Compilation info: CC='gcc'  CFLAGS='-O2 -march=i386 -mcpu=i686'  CXX='c++'
CXXFLAGS='-O2 -march=i386 -mcpu=\
i686'  LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root   11 Dec  6 10:56 /lib/libc.so.6 ->
libc-2.2.so
-rwxr-xr-x1 root root  4733359 Nov 19 15:25 /lib/libc-2.2.so
-rw-r--r--1 root root 22806158 Nov 19 15:22 /usr/lib/libc.a
-rw-r--r--1 root root  178 Nov 19 15:22 /usr/lib/libc.so
Configure command: ./configure

i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbind
\
ir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/includ
e --libdir=/usr/lib --libexecdir\
=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/s
hare/man --infodir=/usr/share/in\
fo --without-debug --without-readline --enable-shared --with-extra-charsets=
complex --without-bench --locals\
tatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --w
ith-mysqld-user=mysql --with-ext\
ra-charsets=all


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

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

Re: Antwort: Re: Antwort: ReisserFS

[Tõnu Samuel]

[EMAIL PROTECTED] wrote:
> 
> On 23.02.2001 10:29:21 ?iso-8859-1?Q?T=F5nu?= Samuel wrote:
> 
> > Only ¨problem¨ we know is that in our tests on ReiserFS is MySQL was 30%
> > faster on writes :/
> 
> Hmm, so, I understand you right: You're saying that it's not a good idea to use
> MySQL on ReiserFS, as you may get a speed rush? *G*

Well, it can pull off socks off of feet ;)

But seriously, ReiserFS is only right choice for now. No doubt. 

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Tonu Samuel <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Tallinn, Estonia
   <___/

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

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

Re: 3.23 "Online Table Maintenance"?

[Peter Skipworth]

Look up "repair table" in the on-line manual.

regards,

P

On Fri, 23 Feb 2001, Hardy
Merrill wrote:

> In the 3.23 news article, at the bottom it says this:
> 
> 
> 
>  Online Table Maintenance 
> 
>  MySQL 3.23 now incorporates many of the table maintanence
>  features of the (previously only external) utilities
>  `(my)isamchk' directly into the MySQL server.  The use of
>  these newly incorporated features can help to eliminate
>  system downtime, by allowing the Database Administrator to
>  repair damaged tables without shutting-down the MySQL server.
> 
> Where can I find additional information about the table maintenance
> features that have now been incorporated into the MySQL server?
> 
> TIA.
> 
> 


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

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

[Segmentation fault opening databse]

[glozano]

>Description:

>How-To-Repeat:
<./mysql -D unal -p>
>Fix:


>Submitter-Id:  
>Originator:Super-User
>Organization:
 
>MySQL support: [none ]
>Synopsis:  
>Severity:  
>Priority:  
>Category:  mysql
>Class: 
>Release:   mysql-3.22.32 (TCX binary)

>Environment:

System: SunOS Sunny 5.8 Generic_108528-04 sun4u sparc SUNW,Ultra-5_10
Architecture: sun4

Some paths:  /usr/bin/perl /usr/ccs/bin/make /usr/local/bin/gcc /usr/local/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc'  CFLAGS='-O3 -fomit-frame-pointer'  CXX='gcc'  
CXXFLAGS='-O3 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'  
LDFLAGS=''
Configure command: ./configure  --prefix=/usr/local/mysql '--with-comment=TCX binary' 
--with-low-memory --disable-shared


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

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

Re: 3.23 "Online Table Maintenance"?

[Sinisa Milivojevic]

Hardy Merrill writes:
 > In the 3.23 news article, at the bottom it says this:
 > 
 > 
 > 
 >  Online Table Maintenance 
 > 
 >  MySQL 3.23 now incorporates many of the table maintanence
 >  features of the (previously only external) utilities
 >  `(my)isamchk' directly into the MySQL server.  The use of
 >  these newly incorporated features can help to eliminate
 >  system downtime, by allowing the Database Administrator to
 >  repair damaged tables without shutting-down the MySQL server.
 > 
 > Where can I find additional information about the table maintenance
 > features that have now been incorporated into the MySQL server?
 > 
 > TIA.
 > 
 > -- 
 > Hardy Merrill
 > Mission Critical Linux, Inc.
 > http://www.missioncriticallinux.com
 > 


Hi!

In the manual. Look for CHECK TABLE and REPAIR TABLE commands.


Regards,

Sinisa

    __ _   _  ___ ==  MySQL AB
 /*/\*\/\*\   /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/   \*\_   |*|   |*||*| mailto:[EMAIL PROTECTED]
   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*| Larnaca, Cyprus
  /*/ /*/  /*/\*\_/*/ \*\_/*/ |*|
  /*/^^^\*\^^^
 /*/ \*\Developers Team

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

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

2nd Post : Problems with splitting data across different disks under Windows...

[Patrick FICHE]

Hi,

I'm working under Windows 98 with MySQL version 3.23.29.
I tried to connect to a database that is on a different disk from the data
directory (g:\mysql\data).
So I created a file g:\mysql\data\pfi.sym containing the path
e:\databases\pfi.
I compiled with the USE_SYMDIR option and launched the server with -s
option.

When I execute the "SHOW DATABASES" command, I can see that "pfi" database
exists.
When I try to connect to "pfi" database, I get the message "unknown
database".
Did I do something wrong ?

I had a look in the code and got the error in mysql_change_db function.
I saw nothing in this function taking into account the symbolic links...

Thanks

Patrick

__

Patrick Fiche - Prologue Software (France)
Software Engineer
Email: [EMAIL PROTECTED]
Internet : http://www.prologue-software.com
___




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

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

mySQL and Solid

[Janek Richter]

Hello,

is there any (simple?) way to import SolidSQL data to a mySQL 
database?

Could someone give me further information or some url's where I can 
find more stuff about importing Solid tables etc to mySQL?

Thanks,
Janek R.

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

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

3.23 "Online Table Maintenance"?

[Hardy Merrill]

In the 3.23 news article, at the bottom it says this:



 Online Table Maintenance 

 MySQL 3.23 now incorporates many of the table maintanence
 features of the (previously only external) utilities
 `(my)isamchk' directly into the MySQL server.  The use of
 these newly incorporated features can help to eliminate
 system downtime, by allowing the Database Administrator to
 repair damaged tables without shutting-down the MySQL server.

Where can I find additional information about the table maintenance
features that have now been incorporated into the MySQL server?

TIA.

-- 
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com

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

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

Compile fails on ha_berkeley.cc

[Matthew P. Marino]

Theres a long list of error messages following but the first is;

ha_berekeley.cc:105: syntax error before ')'
..deleted for brevety...
ha_berkeley.cc:297: warning! unreachable code at beginning of switch statement


Just wondering if this looks familiar to anyone. We are using FreeBSD4, gcc
2.95, gnu make 1.79.1 on MySQL-3.23.33. I used "CC=gcc CXX=gcc ./configure 
-with-low-memory"

P.S. We actualy got sql_yacc.cc to compile in 4 hours on a 166MHZPI with 32MB
RAM and a 64MB swap partition. Imagine my dissapointment when it crashed farther
down stream.

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

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

Re: Saving pictures in MySql

[Peter Skipworth]

Agreed

I generally set aside a directory for any images, etc, per table, and
simply save any images as [primary_key].jpg. That way you can write
simple GetImage([table_name], [primary_key]) functions to return the
location/URL of the matching image.

regards,

P

On Fri, 23 Feb 2001, Mikel King wrote:

> Greetings,
> 
> In most cases you will find that the storage of pictures and mp3's for
> instance are better left to the host fs rather than the dbs. Then you would
> only store the link to such files. Some will argue that this slows down access
> to the perticular file et cettera, blah blah blah...but generally most of us
> are creating web based apps that end up creating url's to said data anyway.
> 
> Ok well that's my take on it.
> 
> cheers,
> mikel
> 
> Barry Radloff wrote:
> 
> > A blob is a nice field to use I guess
> >
> > see these attachements from when I asked the same Q...
> >
> > Some of them may or maynot be helpful..
> >
> > regards
> > Barry
> >
> > -Original Message-
> > From: Danie Weideman [mailto:[EMAIL PROTECTED]]
> > Sent: 23 February 2001 02:02
> > To: [EMAIL PROTECTED]
> > Subject: Saving pictures in MySql
> >
> > Hi everyone
> >
> > I am new to MySql and PHP
> >
> > I have downloaded and configured both
> >
> > I have just finished my first db and are on a high. I was quickly broad to
> > ground when I tried to load a image via a form into the database. Could
> > someone
> > please help with:
> >
> > What field type must be defined for pictures.
> > How to load and retreive pictures from a database using PHP
> >
> > Any thing more will be appreciated
> >
> > Kind Regards
> > Danie Weideman
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >   
> >
> > Subject: RE: Binary data
> > Date: Wed, 31 Jan 2001 10:30:34 +0200
> > From: "Carsten H. Pedersen" <[EMAIL PROTECTED]>
> > To: Barry Radloff <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> >
> > > hi I am pretty new at this and would like to know how does one store a
> > > binary blob to the mysql DB ie I would like to store a jpeg to the db
> >
> > http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_13_0
> >
> > http://www.bitbybit.dk/mysqlfaq/faq.html#ch14_1_0
> >
> > / Carsten
> > --
> > Carsten H. Pedersen
> > keeper and maintainer of the bitbybit.dk MySQL FAQ
> > http://www.bitbybit.dk/mysqlfaq
> >
> >   
> >
> > Subject: RE: Binary data
> > Date: Wed, 31 Jan 2001 19:28:24 +0200
> > From: David Wilde <[EMAIL PROTECTED]>
> > To: Barry Radloff <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED]'"
> >  <[EMAIL PROTECTED]>
> >
> > If your using PHP there is an article here on doing it with PHP3, it works
> > on 4 as well.  HTH
> >
> > http://www.phpbuilder.com/columns/florian19991014.php3
> >
> > Dave W.
> >
> >  -Original Message-
> > From:   Barry Radloff [mailto:[EMAIL PROTECTED]]
> > Sent:   Tuesday, January 30, 2001 10:56 PM
> > To: '[EMAIL PROTECTED]'
> > Subject:Binary data
> >
> > hi I am pretty new at this and would like to know how does one store a
> > binary blob to the mysql DB ie I would like to store a jpeg to the db
> >
> > Thanks
> >
> > Barry Radloff
> > R&D
> > Media24
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >   
> >
> > Subject: Re: Binary data
> > Date: Thu, 1 Feb 2001 22:58:58 +0200
> > From: Peter Szekszardi <[EMAIL PROTECTED]>
> > To: Barry Radloff <[EMAIL PROTECTED]>
> > CC: [EMAIL PROTECTED]
> >
> > Hi Barry,
> >
> > I do not know what do you use for feeding your database, but in Perl you
> > shoud use the DBI module, and insert the binary data through bindings.
> >
> > use DBI;
> > use strict;
> >
> > ...
> >
> > my $dbh = DBI->connect("dbi:mysql:image_db", "user", "password") || die
> > "$DBI::errstr\n";   # connect to the
> > database
> >
> > ...
> >
> > my $sth = $dbh->prepare("INSERT jpeg_table SET size_x = $size_x, size_y =
> > $size_y, image_data = ?;") || die "$DBI::errstr\n"; # prepare the insert
> > statement, replacing the image data with a question mark
> > $sth->bind_param(1, $image_data); 

RE: Saving pictures in MySql

[Barry Radloff]

I hearterly concur ...

-Original Message-
From: Mikel King [mailto:[EMAIL PROTECTED]]
Sent: 23 February 2001 03:46
To: Barry Radloff
Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: Re: Saving pictures in MySql


Greetings,

In most cases you will find that the storage of pictures and mp3's for
instance are better left to the host fs rather than the dbs. Then you would
only store the link to such files. Some will argue that this slows down
access
to the perticular file et cettera, blah blah blah...but generally most of us
are creating web based apps that end up creating url's to said data anyway.

Ok well that's my take on it.

cheers,
mikel

Barry Radloff wrote:

> A blob is a nice field to use I guess
>
> see these attachements from when I asked the same Q...
>
> Some of them may or maynot be helpful..
>
> regards
> Barry
>
> -Original Message-
> From: Danie Weideman [mailto:[EMAIL PROTECTED]]
> Sent: 23 February 2001 02:02
> To: [EMAIL PROTECTED]
> Subject: Saving pictures in MySql
>
> Hi everyone
>
> I am new to MySql and PHP
>
> I have downloaded and configured both
>
> I have just finished my first db and are on a high. I was quickly broad to
> ground when I tried to load a image via a form into the database. Could
> someone
> please help with:
>
> What field type must be defined for pictures.
> How to load and retreive pictures from a database using PHP
>
> Any thing more will be appreciated
>
> Kind Regards
> Danie Weideman
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>   
>
> Subject: RE: Binary data
> Date: Wed, 31 Jan 2001 10:30:34 +0200
> From: "Carsten H. Pedersen" <[EMAIL PROTECTED]>
> To: Barry Radloff <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>
> > hi I am pretty new at this and would like to know how does one store a
> > binary blob to the mysql DB ie I would like to store a jpeg to the db
>
> http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_13_0
>
> http://www.bitbybit.dk/mysqlfaq/faq.html#ch14_1_0
>
> / Carsten
> --
> Carsten H. Pedersen
> keeper and maintainer of the bitbybit.dk MySQL FAQ
> http://www.bitbybit.dk/mysqlfaq
>
>   
>
> Subject: RE: Binary data
> Date: Wed, 31 Jan 2001 19:28:24 +0200
> From: David Wilde <[EMAIL PROTECTED]>
> To: Barry Radloff <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED]'"
>  <[EMAIL PROTECTED]>
>
> If your using PHP there is an article here on doing it with PHP3, it works
> on 4 as well.  HTH
>
> http://www.phpbuilder.com/columns/florian19991014.php3
>
> Dave W.
>
>  -Original Message-
> From:   Barry Radloff [mailto:[EMAIL PROTECTED]]
> Sent:   Tuesday, January 30, 2001 10:56 PM
> To: '[EMAIL PROTECTED]'
> Subject:Binary data
>
> hi I am pretty new at this and would like to know how does one store a
> binary blob to the mysql DB ie I would like to store a jpeg to the db
>
> Thanks
>
> Barry Radloff
> R&D
> Media24
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>   
>
> Subject: Re: Binary data
> Date: Thu, 1 Feb 2001 22:58:58 +0200
> From: Peter Szekszardi <[EMAIL PROTECTED]>
> To: Barry Radloff <[EMAIL PROTECTED]>
> CC: [EMAIL PROTECTED]
>
> Hi Barry,
>
> I do not know what do you use for feeding your database, but in Perl you
> shoud use the DBI module, and insert the binary data through bindings.
>
> use DBI;
> use strict;
>
> ...
>
> my $dbh = DBI->connect("dbi:mysql:image_db", "user", "password") || die
> "$DBI::errstr\n";   # connect to the
> database
>
> ...
>
> my $sth = $dbh->prepare("INSERT jpeg_table SET size_x = $size_x, size_y =
> $size_y, image_data = ?;") || die "$DBI::errstr\n"; # prepare the
insert
> statement, replacing the image data with a question mark
> $sth->bind_param(1, $image_data);   # binding the
binary
> data
> $sth->execute() || die "$DBI::errstr\n";# executing the
> insert
>
> ...
>
> $dbh->disconnect(); # disconnect
>
> Regards,
>
> Peter Szekszardi
> PortoLogic Ltd.
> Portal building, design, net survey and more...
>
> On Wed, 31 Jan 2001, Barry Radloff wrote:
>
> >
> >
> > hi I am 

Re: Saving pictures in MySql

[Mikel King]

Greetings,

In most cases you will find that the storage of pictures and mp3's for
instance are better left to the host fs rather than the dbs. Then you would
only store the link to such files. Some will argue that this slows down access
to the perticular file et cettera, blah blah blah...but generally most of us
are creating web based apps that end up creating url's to said data anyway.

Ok well that's my take on it.

cheers,
mikel

Barry Radloff wrote:

> A blob is a nice field to use I guess
>
> see these attachements from when I asked the same Q...
>
> Some of them may or maynot be helpful..
>
> regards
> Barry
>
> -Original Message-
> From: Danie Weideman [mailto:[EMAIL PROTECTED]]
> Sent: 23 February 2001 02:02
> To: [EMAIL PROTECTED]
> Subject: Saving pictures in MySql
>
> Hi everyone
>
> I am new to MySql and PHP
>
> I have downloaded and configured both
>
> I have just finished my first db and are on a high. I was quickly broad to
> ground when I tried to load a image via a form into the database. Could
> someone
> please help with:
>
> What field type must be defined for pictures.
> How to load and retreive pictures from a database using PHP
>
> Any thing more will be appreciated
>
> Kind Regards
> Danie Weideman
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>   
>
> Subject: RE: Binary data
> Date: Wed, 31 Jan 2001 10:30:34 +0200
> From: "Carsten H. Pedersen" <[EMAIL PROTECTED]>
> To: Barry Radloff <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>
> > hi I am pretty new at this and would like to know how does one store a
> > binary blob to the mysql DB ie I would like to store a jpeg to the db
>
> http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_13_0
>
> http://www.bitbybit.dk/mysqlfaq/faq.html#ch14_1_0
>
> / Carsten
> --
> Carsten H. Pedersen
> keeper and maintainer of the bitbybit.dk MySQL FAQ
> http://www.bitbybit.dk/mysqlfaq
>
>   
>
> Subject: RE: Binary data
> Date: Wed, 31 Jan 2001 19:28:24 +0200
> From: David Wilde <[EMAIL PROTECTED]>
> To: Barry Radloff <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED]'"
>  <[EMAIL PROTECTED]>
>
> If your using PHP there is an article here on doing it with PHP3, it works
> on 4 as well.  HTH
>
> http://www.phpbuilder.com/columns/florian19991014.php3
>
> Dave W.
>
>  -Original Message-
> From:   Barry Radloff [mailto:[EMAIL PROTECTED]]
> Sent:   Tuesday, January 30, 2001 10:56 PM
> To: '[EMAIL PROTECTED]'
> Subject:Binary data
>
> hi I am pretty new at this and would like to know how does one store a
> binary blob to the mysql DB ie I would like to store a jpeg to the db
>
> Thanks
>
> Barry Radloff
> R&D
> Media24
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>   
>
> Subject: Re: Binary data
> Date: Thu, 1 Feb 2001 22:58:58 +0200
> From: Peter Szekszardi <[EMAIL PROTECTED]>
> To: Barry Radloff <[EMAIL PROTECTED]>
> CC: [EMAIL PROTECTED]
>
> Hi Barry,
>
> I do not know what do you use for feeding your database, but in Perl you
> shoud use the DBI module, and insert the binary data through bindings.
>
> use DBI;
> use strict;
>
> ...
>
> my $dbh = DBI->connect("dbi:mysql:image_db", "user", "password") || die
> "$DBI::errstr\n";   # connect to the
> database
>
> ...
>
> my $sth = $dbh->prepare("INSERT jpeg_table SET size_x = $size_x, size_y =
> $size_y, image_data = ?;") || die "$DBI::errstr\n"; # prepare the insert
> statement, replacing the image data with a question mark
> $sth->bind_param(1, $image_data);   # binding the binary
> data
> $sth->execute() || die "$DBI::errstr\n";# executing the
> insert
>
> ...
>
> $dbh->disconnect(); # disconnect
>
> Regards,
>
> Peter Szekszardi
> PortoLogic Ltd.
> Portal building, design, net survey and more...
>
> On Wed, 31 Jan 2001, Barry Radloff wrote:
>
> >
> >
> > hi I am pretty new at this and would like to know how does one store a
> > binary blob to the mysql DB ie I would like to store a jpeg to the db
> >
> > Thanks
> >
> > Barry Radloff
> > R&D
> > Media24
> >
>
>   -

Antwort: help booting mysql

[alexander . skwar]

On 23.02.2001 11:52:27 Software by ScuoLavoro wrote:

> Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost'

> (10061) in lib.inc.php3 on line 255
> Erreur
> coul someone help me?

With such a "descriptive" error message?
Please also post the line 255 to the list.

But maybe it's just because the username and/or password are wrong?



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

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

RE: Quoting numbers? (was Re:MySQL Tables)

[Julian Strickland]

Tis true Rolf but you can bet your bottom dollar that at somepoint a
confusion will arise
when it is most inconvenient.
There is always a conversion somewhere in the code even if it is not
visible.

> -Original Message-
> From: Rolf Hopkins [SMTP:[EMAIL PROTECTED]]
> Sent: 23 February 2001 02:09
> To:   Julian Strickland; [EMAIL PROTECTED]
> Subject:  Re: Quoting numbers? (was Re:MySQL Tables)
> 
> That's very true but these days, some languages/databases allow for
> strings
> to be assigned to numbers and vice versa without the need for conversion.
> PHP is one such language, not that I'm bagging it or anything as I use it
> myself.  I just call it bad type checking.
> 
> - Original Message -
> From: "Julian Strickland" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, February 22, 2001 22:35
> Subject: RE: Quoting numbers? (was Re:MySQL Tables)
> 
> 
> > It's all to do with data types, traditionally and across most languages
> > quotes are used to delimit STRINGS
> > and a string is NOT a number although may represent one when displayed.
> >
> > > -Original Message-
> > > From: Pete Harlan [SMTP:[EMAIL PROTECTED]]
> > > Sent: 21 February 2001 20:51
> > > To: [EMAIL PROTECTED]
> > > Subject: Quoting numbers? (was Re:MySQL Tables)
> > >
> > > > I think you'll get better results if you don't quote your numbers.
> > > Quotes
> > > > should be used for text and dates (depending) but not numbers.
> > >
> > > Out of curiosity, why?
> > >
> > > We use quotes for numbers all the time here, for consistency's sake;
> > > the programmer doesn't have to worry about the representation of, say,
> > > a salesman_id, but just reads/displays/stores it in the database.
> > >
> > > Aside from the fact that leaving them off is possible, is there a
> > > standards/compatibility/other reason to do so?
> > >
> > > (An example of a good reason not to use them would be if the db engine
> > > weren't smart enough to use an index when you say
> > >
> > > select * from table_name where numeric_key = '1234'
> > >
> > > but possibly (probably?) all dbms's are that smart.)
> > >
> > > --Pete
> > >
> > > -
> > > Before posting, please check:
> > >http://www.mysql.com/manual.php   (the manual)
> > >http://lists.mysql.com/   (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

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