Configuration error

[Aleksandar Pavic]

HI, when I try to compile mysql, I get message.
c++ can not write output files.
What should I do?

Thanks.

__
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

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

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

Re: Perl DBI: Same column name in different tables problem

[Dana Powers]

Or the perl way:

my %row;
@row{'f_handle','a_handle'} = $sth->fetchrow_array();

$row{f_handle} or $row{a_handle}are now set properly.

( if you really want a reference, you can say 'my $row = {};
@{$row}{'f_handle. )

dpk

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


> On Fri, Sep 07, 2001 at 10:03:03PM -0700, Philip Mak wrote:
> > Let's say I performed the following query using Perl DBI:
> >
> > $row = $dbh->selectrow_hashref(<<"~");
> > SELECT fanfics.handle, authors.handle
> > FROM fanfics, authors
> > WHERE fanfics.aid = authors.aid
> > ~
> >
> > I won't be able to access both fanfics.handle and authors.handle
> > this way, because they're called "handle". I would like to be able
> > to access them e.g. by doing $row->{fanfics.handle} and
> > $row->{authors.handle}, or something like that.
> >
> > What workarounds have people found for this problem?
>
> Use a column alias:
>
>   SELECT fanfics.handle as f_handle, authors.handle as a_handle
> FROM fanfics, authors
>WHERE fanfics.aid = authors.aid
>
> Then refer to them as $row->{a_handle} or $row->{f_handle}.
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
>
> MySQL 3.23.41-max: up 2 days, processed 42,300,526 queries (237/sec. avg)
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>


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

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

1030: Got error 127 from table handler on record 1382

[Jason G.]

Regarding error 127 from table handler...
I thought this may be helpful to anyone that is having this problem:

I tried to back up my database using mysqldump:

[pad@gamma dbbackup]$ mysqldump -u padadmin --password --verbose paddata | 
gzip > /home/pad/dbbackup/20010908a.gz
Enter password:
# Connecting to localhost...
# Retrieving table structure for table _chat...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table action_log...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table asessions...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table data_log...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table def_ccard...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table def_lead_status...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table def_serv...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table dist...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table dist_backup...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table dist_backup_ac...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table items...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table lead_assign_log...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table lead_comments...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table leads...
# Sending SELECT query...
# Retrieving rows...


When it got to here, it died, saying something like:

Error 1030: Got error 127 from table handler on record 1382

Hmmm...

I ran a:
repair table leads
command from in mysyl.   It fixed two errors.  Then I could do the backup.

Also, before I fixed the errors, I could preform the following:
SELECT lead_id FROM leads;

But I could not prefrom the following - I got error 127 from table handler:
SELECT lead_id, firstname, lastname FROM leads;

This one has me puzzled, but repair table fixed this also.

Hope it helps someone!

-Jason Garber
Lead Programmer - pulseaday.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: reach the hard limits!?

[Jeremy Zawodny]

On Mon, Sep 03, 2001 at 04:06:20PM +0200, Oliver Krapp - etracker.de e.K. wrote:
> Hello MySql,
> 
> I'm dealing with a large (think so) production mysql server. There
> are up to ~2500 small databases (each ~1-4 MB Data in 10
> Tables). The system is growing and the CPU gets more and more
> loaded. A new behaviour is that apache get sometimes out of clients,
> caused by bad response times from the mysql server.
>
> At the moment the system is running on one machine, however the
> concept is scalable.

So you can put Apache on a separate machine to scale better, right?

> I have no feeling/experience where are the limits with mysql. When I
> have to setup the next db-server? Are ~300 queries per sec. a joke
> for mysql? It's difficult to valuate if I'm going towards the hard
> limit or if I have a problem with my db design.

I'd look at the design...

> Are there people who can share there knowledge about large mysql servers?
> 
> Linux 2.4.4 SMP
> 2x PIII 800
> 512 MB RAM
> 80 GB EasyRaid System. Lev. 5 (~130 MB sec)
> 
> average of ~ 330 queries per second.

Sounds reasonable given your hardware.  If things are well tuned
(parameters in your my.cnf file), I'd guess that you can probably
double the load (maybe twice or more) and still have room to grow.
But if you have some unoptimized queries killing things, all bets are
off.

Do you have the slow query log enabled?

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

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

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

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

Re: I dont know if it's me or what...

[Deryck Henson]

Thanx dude.  That helped.  hey!  Dont forget to check out my web site!!  I'm
almost done with the source-code upload part.

- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Deryck Henson" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Saturday, September 08, 2001 12:46 AM
Subject: Re: I dont know if it's me or what...


> On Fri, Sep 07, 2001 at 10:33:07PM -0500, Deryck Henson wrote:
> >
> > That manual is confusing in some parts.  Like, how to make an
> > auto_increment column.  how do I anyway?  My database table needs
> > it.
>
> The manual isn't perfect, but users like us sometimes submit
> corrections and enhancements to help make it better.  Afterall, this
> is Open Source.  :-)
>
> To answer your question:
>
>   CREATE TABLE foo_bar
>   (
> col1integer unsigned auto_increment primary key,
> col2...
>   );
>
> Hope that helps,
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936
>
> MySQL 3.23.41-max: up 2 days, processed 42,297,388 queries (238/sec. avg)
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


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

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

Re: In the table Properties... What is Row_Format???

[Jeremy Zawodny]

On Fri, Sep 07, 2001 at 12:56:14PM -0300, Pablo Fraga wrote:
>
> What´s the diference between The row storage format (Fixed, Dynamic,
> or Compressed) .
> 
> I'am experiencing problems with update statements which goes against
> a table with the row_format property set to Fixed.

Fixed rows always use the same amount of space.  Dynamic do not.
Compressed rows are read-only.

Read more in the manual:

  http://www.mysql.com/doc/M/y/MyISAM_table_formats.html

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

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

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

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

1030: Got error 127 from table handler on record 1382

[Jason G.]

I thought this may be helpful to anyone that is having this problem.

I tried to back up my database using mysqldump:

[pad@gamma dbbackup]$ mysqldump -u padadmin --password --verbose paddata | 
gzip > /home/pad/dbbackup/20010908a.gz
Enter password:
# Connecting to localhost...
# Retrieving table structure for table _chat...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table action_log...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table asessions...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table data_log...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table def_ccard...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table def_lead_status...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table def_serv...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table dist...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table dist_backup...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table dist_backup_ac...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table items...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table lead_assign_log...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table lead_comments...
# Sending SELECT query...
# Retrieving rows...
# Retrieving table structure for table leads...
# Sending SELECT query...
# Retrieving rows...


When it got to here, it died, saying something like:

Error 1030: Got error 127 from table handler on record 1382

Hmmm...

I ran a:
repair table leads
command from in mysyl.   It fixed two errors.  Then I could do the backup.

Also, before I fixed the errors, I could preform the following:
SELECT lead_id FROM leads;

But I could not prefrom the following - I got error 127 from table handler:
SELECT lead_id, firstname, lastname FROM leads;

This one has me puzzled, but repair table fixed this also.

Hope it helps someone!

-Jason Garber
Lead Programmer - pulseaday.com


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

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

Re: Perl DBI: Same column name in different tables problem

[Jeremy Zawodny]

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

Use a column alias:

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

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

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

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

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

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

Re: I dont know if it's me or what...

[Jeremy Zawodny]

On Fri, Sep 07, 2001 at 10:33:07PM -0500, Deryck Henson wrote:
>
> That manual is confusing in some parts.  Like, how to make an
> auto_increment column.  how do I anyway?  My database table needs
> it.

The manual isn't perfect, but users like us sometimes submit
corrections and enhancements to help make it better.  Afterall, this
is Open Source.  :-)

To answer your question:

  CREATE TABLE foo_bar
  (
col1integer unsigned auto_increment primary key,
col2...
  );

Hope that helps,

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

MySQL 3.23.41-max: up 2 days, processed 42,297,388 queries (238/sec. avg)

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

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

Re: Can some PLEASE tell me what this error means

[Webmaster]

ASP question... not MySQL (if I understand correctly...)

But just do a replace...



variabletoinsert = replace(thevariablecomingin,"'","\'")

INSERT INTO ASP (title, description, code, user, email, date_created) VALUES
('title', 'description', '" & variabletoinsert & "', 'user', 'email', 'now')



you could write a quick function that you could call at will...

function fq(string)
fq = replace(string,"'","\'")
end function


mystr = "insert into asp (blah,blah,blah) values ('" & fq(inblah) & "','" &
fq(inbalh) & "','" & fq(inblah) & "')"
conn.execute mystr



- Original Message -
From: "Deryck Henson" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 10:10 PM
Subject: Re: Can some PLEASE tell me what this error means


> Except the problem is, this is done through an Active Server Page (ASP).
> The user does the inserting, I just use variables and insert them.
> TRANSLATION::  I have no control over what goes in the database until it's
> there.  So how can it be changed in the connection or sending process?
>
> - Deryck H
> - http://www.comp-u-exchange.com
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>



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

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

Perl DBI: Same column name in different tables problem

[Philip Mak]

Let's say I performed the following query using Perl DBI:

$row = $dbh->selectrow_hashref(<<"~");
SELECT fanfics.handle, authors.handle
FROM fanfics, authors
WHERE fanfics.aid = authors.aid
~

I won't be able to access both fanfics.handle and authors.handle this
way, because they're called "handle". I would like to be able to access
them e.g. by doing $row->{fanfics.handle} and $row->{authors.handle},
or something like that.

What workarounds have people found for this problem?

__
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

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

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

Table lockup?

[Hedgie's Techie]

Hi,

I'm relatively new to MySQL, but it's been working well for me with dozens
of Perl scripts.  We use it as our database with our ISP.  Our database size
is currently about 30MB, and the majority of that is in two tables which
each contain about 20,000 records.  The database has not changed much in
size, nor have the number of accesses (at a rare peak, 3 or 4 times per
minute but an average of 500 accesses per day), but over the last few months
we see the following scenario:

1) One or the other my large tables becomes inaccessible - I can get schema
but I can't do any queries.
2) All my scripts hang and then are killed by the ISP.
3) After a few hours with the table locked and scripts hanging, the entire
database becomes inaccessible because there are 'too many connections.'

When it first started 3 months ago, this happened once a month, then after
two weeks, then weekly.  It happened yesteday and then again today.  The
only recovery is to reload the MySQL Daemon.  Does anyone have any ideas
about what might cause the tables to become inaccessible?



Steve


Techie
Hedgehogbooks.com, Inc.
806 Modesto Avenue
Santa Cruz, Ca 95060
phone: 408-813-6294
www.hedgehogbooks.com


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

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

Re: Can some PLEASE tell me what this error means

[Deryck Henson]

Except the problem is, this is done through an Active Server Page (ASP).
The user does the inserting, I just use variables and insert them.
TRANSLATION::  I have no control over what goes in the database until it's
there.  So how can it be changed in the connection or sending process?

- Deryck H
- http://www.comp-u-exchange.com


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

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

mysql not starting

[Buddy]

I installed Mysql using the Apachetoolbox. Everything installed correctly,
but when linux boots, mysqld starts, and stops immediately. I checked out
the docs, and tried using "./safe_mysqld --skip-grant-tables" which starts
to load mysql, but then hangs, causing me to reboot.

I ran "mysql_install_db" which worked fine, but I was never able to setup
root password or anything like that since mysql wont run for me.

I have tried running "./safe_mysqld --user=mysql &" and all the variations
with no luck (I tried this at the beginning)

Any ideas?

Thanks in advance for the replys

Budroe



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

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: Sorry if this is a duplicate got a failure notice back: SQL basica question again

[Henning Schroeder]

At 06:44 07.09.01, you wrote:
>here is my sql query
>
>SELECT COUNT(*) as count, hostname FROM host_list GROUP BY hostname ORDER BY
>count DESC
>
>
>what I would like to do is list say just the hosts that have greater then 10
>in the left column


use the HAVING statement as in:

SELECT COUNT(*) as count, hostname FROM host_list GROUP BY hostname ORDER 
BY count DESC HAVING count>10

hand
henning schroeder



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

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

I dont know if it's me or what...

[Deryck Henson]

That manual is confusing in some parts.  Like, how to make an auto_increment
column.  how do I anyway?  My database table needs it.  Thanx

- Deryck H
- http://www.comp-u-exchange.com


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

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

Re: Minimal Mysql

[Rich Duzenbury]

I don't know how small the mysql distro can be made but I'm guessing pretty 
small.  I see that the mysqld on my box runs about 1.4mb.  I have seen 
linux setups that can boot entirely from a floppy (so less than 1.44MB) at 
http://www2.linuxrouter.org:81/ , perhaps you may also be interested in that.

At 08:59 AM 9/6/01, [EMAIL PROTECTED] wrote:
>Hi, I need to install Mysql on a 386 machine with 4 MB RAM and 32 MB Hard
>Drive (Flash Disk). I have small Linux running on it which has taken up
>about 10MB already. I need at lease 5-10 MB for the DB and my files. Is it
>possible to install Mysql Server (stripped) in this limited space?
>
>I surely don't want any documentation or other things that are not needed.
>It will be mainly used for select, insert, select and updates.
>
>Has anyone tried a similar thing (and succeeded ??) ?.
>
>Detailed document would be great if someone can direct me to that.
>
>Thanks.
>
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Regards,
Rich


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

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

RE: Can some PLEASE tell me what this error means

[Cal Evans]

Add a \ before the '

INSERT INTO ASP (title, description, code, user, email, date_created) VALUES
('title', 'description', '\'get file scripting object Set objFileScripting =
CreateObject("Scripting.F', 'user', 'email', 'now')


Cal
http://www.calevans.com


-Original Message-
From: Deryck Henson [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 07, 2001 6:30 PM
To: MySQL
Subject: Can some PLEASE tell me what this error means


I am trying to input some data into the database when all of a
suddenPOOF!  This pops up!::

You have an error in your SQL syntax near 'get file scripting object Set
objFileScripting = CreateObject("Scripting.F' at line 1

Is there anything I can doabout this?  The 'get file scripting object Set
objFileScripting = CreateObject("Scripting.F' stuff is part of this query::

INSERT INTO ASP (title, description, code, user, email, date_created) VALUES
('title', 'description', ''get file scripting object Set objFileScripting =
CreateObject("Scripting.F', 'user', 'email', 'now')

I figured out that the ' before "get" is bad but how do I make it so that
when it is processed, that ' turns into something that can go into MySQL and
when it is shown on a web page, it gets turned back into a regular old ' ?

email me for clarification.

- Deryck H
- http://www.comp-u-exchange.com


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

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



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

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: What is MySQL 4.0??

[Jeremy Zawodny]

On Fri, Sep 07, 2001 at 07:34:03PM -0500, Deryck Henson wrote:
>
> I keep on hereing in the manual them talking about some MySQL 4.0.
> What is it and how do I get it?  If it even exists (which I doubt)

It is the next major version of MySQL, currently in development.

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

MySQL 3.23.41-max: up 1 days, processed 41,440,299 queries (258/sec. avg)

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

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

Re: Re: intersection: join query...

[Rodney Broom]

Riza-frasin...
---
Rodney Broom
Programmer: Desert.Net



> Your message cannot be posted because it appears to be either spam...
> database,sql,query,table

> From: Anthony E. <[EMAIL PROTECTED]>
> 
> > Unknow column 'USER' in 'where clause'.
> 
> D'oh! Fast fingers and too many thoughts.
> 
>select count(USER_TMP.email)
>  from USER_TMP, USER
> where USER_TMP.email =3D USER.email;
> 
> ---
> Rodney Broom
> Programmer: Desert.Net
> 
> 
> 
> 


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

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: intersection: join query...

[Anthony E.]

Unknow column 'USER' in 'where clause'.


--- Rodney Broom <[EMAIL PROTECTED]> wrote:
> From: Anthony E. <[EMAIL PROTECTED]>
> 
> 
> > This comes up with more records than are in
> USER_TMP.
> 
> Is the 'email' column unique in both tables?
> 
> Heh, sorry about that. Try this:
> 
>   select count(USER_TMP.email)
> from USER_TMP, USER
>where USER_TMP.email = USER.email
>  and USER;
> 
> 
> ---
> Rodney Broom
> Programmer: Desert.Net
> 
> 
> 

=
--
Anthony Ettinger
[EMAIL PROTECTED]
415-504-8048
http://chovy.com/resume.doc

__
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

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

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

Re: intersection: join query...

[Rodney Broom]

From: Anthony E. <[EMAIL PROTECTED]>


> This comes up with more records than are in USER_TMP.

Is the 'email' column unique in both tables?

Heh, sorry about that. Try this:

  select count(USER_TMP.email)
from USER_TMP, USER
   where USER_TMP.email = USER.email
 and USER;


---
Rodney Broom
Programmer: Desert.Net




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

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

What is MySQL 4.0??

[Deryck Henson]

I keep on hereing in the manual them talking about some MySQL 4.0.  What is
it and how do I get it?  If it even exists (which I doubt)

- Deryck H
- http://www.comp-u-exchange.com


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

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

Re: UPDATE bug

[Jeremy Zawodny]

On Wed, Jul 04, 2001 at 07:16:50PM -0500, [EMAIL PROTECTED] wrote:

> Ok, I know I submitted an earlier bug report about this, but I've
> actually had it happen from the mysql monitor. Essentially, UPDATE
> queries are executing, but not actually updating, unless I SELECT
> data from the table first.
> 
> >How-To-Repeat:
>   Simple as that. I have yet to notice any particular pattern. It happens
> for some queries, on some tables, some of the time.

Can you try MySQL 3.23.41?

What table type are you using?  MyISAM?

> System: FreeBSD xtabi.carspot.com 4.2-RELEASE FreeBSD 4.2-RELEASE #4: Sat Jun  2 
>22:42:12 CDT 2001 [EMAIL PROTECTED]:/usr/src/sys/compile/XTABI  i386

Ugh.  You really need to run FreeBSD 4.3 if you want to avoid nasty
threading problems.

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

MySQL 3.23.41-max: up 1 days, processed 41,358,529 queries (261/sec. avg)

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

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

Re: NOT IN query problems.

[Paul DuBois]

At 4:40 PM -0700 9/7/01, Anthony E. wrote:
>I've tried to do a NOT IN statement, but still am
>getting SQL syntax error.
>
>
>SELECT COUNT(*) FROM USER_TMP WHERE USER_TMP.email NOT
>IN (SELECT USER.email FROM USER);
>
>I'm trying to produce a list of records from USER_TMP

Huh?  COUNT(*) produces a count, not a list.

>table where the USER_TMP.email is NOT IN USER.email.
>
>(in other words, i want only the records where the
>email address from USER_TMP is not already in USER).
>
>Please help, i've been strugglying on this all day.

You're trying to use a sub-select, and MySQL doesn't
support them yet.  You can probably get what you want
with a LEFT JOIN, however:

SELECT USER_TMP.email FROM USER_TMP LEFT JOIN USER USING (email)
WHERE USER.email IS NULL


>=
>--
>Anthony Ettinger
>[EMAIL PROTECTED]
>415-504-8048
>http://chovy.com/resume.doc


-- 
Paul DuBois, [EMAIL PROTECTED]

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

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

ACCESS DENIED

[Shawn Ouderkirk]

Use:

mysqladmin -p

and it will ask you for the password. To execute without question,
specify password on command line, but it is not masked if you do this
(say your password is "allaccess"):

 mysqladmin -pallaccess

and follow with the command on the same line (using the appropriate
options, of course) . . .

--
--

 Shawn Ouderkirk
 Senior Engineer and Systems Administrator
 SCI Systems, Inc.
 Fountain, CO

 [EMAIL PROTECTED]

 (719) 382-2289

--

Cease dependence on inspection to
achieve quality. Eliminate the need for
inspection on a mass basis by building
quality into the product in the first place.

 -- W. Edwards Deming



>Hi
>
>Trying to create a database or reload the Grant tables using mysql/bin/

>./mysqladmin  I get an access denied message including a PASSWORD NO
>message. Trying the troubleshoot docs for this I get Access Denied for
the
>suggestions made to deal with this. This is also causing a MERANT mySQL

>driver not to connect, ACCESS DENIED again problem of CF5.0 loaded on
cobalt
>raq running linux red hat tring the connect to database. Is there any
>command or function or option I can use to pass the password with these

>commands, or any other suggestions gladly received
>
>Colm Brazel (MA)
>CB Publications
>www.cbweb.net
>[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]>





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

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

NOT IN query problems.

[Anthony E.]

I've tried to do a NOT IN statement, but still am
getting SQL syntax error.


SELECT COUNT(*) FROM USER_TMP WHERE USER_TMP.email NOT
IN (SELECT USER.email FROM USER);

I'm trying to produce a list of records from USER_TMP
table where the USER_TMP.email is NOT IN USER.email.

(in other words, i want only the records where the
email address from USER_TMP is not already in USER).

Please help, i've been strugglying on this all day.


=
--
Anthony Ettinger
[EMAIL PROTECTED]
415-504-8048
http://chovy.com/resume.doc

__
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

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

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

Can some PLEASE tell me what this error means

[Deryck Henson]

I am trying to input some data into the database when all of a
suddenPOOF!  This pops up!::

You have an error in your SQL syntax near 'get file scripting object Set
objFileScripting = CreateObject("Scripting.F' at line 1

Is there anything I can doabout this?  The 'get file scripting object Set
objFileScripting = CreateObject("Scripting.F' stuff is part of this query::

INSERT INTO ASP (title, description, code, user, email, date_created) VALUES
('title', 'description', ''get file scripting object Set objFileScripting =
CreateObject("Scripting.F', 'user', 'email', 'now')

I figured out that the ' before "get" is bad but how do I make it so that
when it is processed, that ' turns into something that can go into MySQL and
when it is shown on a web page, it gets turned back into a regular old ' ?

email me for clarification.

- Deryck H
- http://www.comp-u-exchange.com


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

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

Re: Question

[Ian Barwick]

On Saturday 08 September 2001 00:10, Mysql List wrote:
> Thanks,
>
> I already tried that, and I am only trying to insert about a dozen fields.
>
> Thanks for the response, I will wait and see if anyone else has an idea.

The documentation:

http://www.mysql.com/doc/C/R/CREATE_TABLE.html

has the answer (but not very clearly).

The AUTO_INCREMENT parameter is set on a per-table and not a per-row basis, 
so the definition comes after the row definitions, e.g.:

CREATE TABLE mytable(
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY)
AUTO_INCREMENT=1000;

HTH

Ian Barwick

> > MaybeI guessThere's either too many datatypes or try putting like
> > this (again, probably wont work)
> >
> > Auto_Increment=1000, .
> >
> > - Deryck H
> > - http://www.comp-u-exchange.com
> > - Original Message -
> > From: "Mysql List" <[EMAIL PROTECTED]>
> > To: "Deryck Henson" <[EMAIL PROTECTED]>
> > Cc: "mysql" <[EMAIL PROTECTED]>
> > Sent: Friday, September 07, 2001 4:26 PM
> > Subject: Re: Question
> >
> > > That didn't work either.
> > > The documentation seems to show that you have to use  = 1000, but I
>
> can't
>
> > > get it to work.
> > >
> > > > Try putting it like this ::
> > > >
> > > > AUTO_INCREMENT(1000), .
> > > >
> > > > Not sure but that should work
> > > >
> > > > - Deryck H
> > > > - http://www.comp-u-exchange.com
> > > > - Original Message -
> > > > From: "Mysql List" <[EMAIL PROTECTED]>
> > > > To: "mysql" <[EMAIL PROTECTED]>
> > > > Sent: Friday, September 07, 2001 3:49 PM
> > > > Subject: Question
> > > >
> > > > > Hi,
> > > > > Why is mysql(ver 3.23.41) complaining about this:
> > > > >
> > > > > CREATE TABLE mytable(ID INT NOT NULL AUTO_INCREMENT = 1000,PRIMARY
>
> KEY
>
> > > > (ID),
> > > >
> > > > > I know it is not the entire statement, but mysql does not like the
> > > > > AUTO_INCREMENT = 1000 part, how do I do that so it is acceptable?
> > > > >
> > > > > Thanks,
> > > > > Chris
> >
> > -
> >
> > > > > Before posting, please check:
> > > > >http://www.mysql.com/manual.php   (the manual)
> > > > >http://lists.mysql.com/   (the list archive)
> > > > >
> > > > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > > > To unsubscribe, e-mail
> > > >
> > > > <[EMAIL PROTECTED]>
> > > >
> > > > > Trouble unsubscribing? Try:
>
> http://lists.mysql.com/php/unsubscribe.php
>
> > > -
> > > Before posting, please check:
> > >http://www.mysql.com/manual.php   (the manual)
> > >http://lists.mysql.com/   (the list archive)
> > >
> > > 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

-- 
Ian Barwick - Developer  [EMAIL PROTECTED]
http://www.akademie.de

"Luncheon meat tables with MySQL data"


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

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 and more questions......

[Jeremy Zawodny]

On Fri, Sep 07, 2001 at 02:54:18PM -0700, [EMAIL PROTECTED] wrote:
>
> Just wondering, if I make changes to the master database table
> structures, will the changes be reflected in the slave databaase
> tables or do I need to manually re-copy master database snapshot to
> the slave?

They will be replicated automatically.
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936

MySQL 3.23.41-max: up 1 days, processed 37,753,918 queries (251/sec. avg)

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

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

Re: Question

[Mysql List]

Thanks,

I already tried that, and I am only trying to insert about a dozen fields.

Thanks for the response, I will wait and see if anyone else has an idea.

Chris

> MaybeI guessThere's either too many datatypes or try putting like
> this (again, probably wont work)
>
> Auto_Increment=1000, .
>
> - Deryck H
> - http://www.comp-u-exchange.com
> - Original Message -
> From: "Mysql List" <[EMAIL PROTECTED]>
> To: "Deryck Henson" <[EMAIL PROTECTED]>
> Cc: "mysql" <[EMAIL PROTECTED]>
> Sent: Friday, September 07, 2001 4:26 PM
> Subject: Re: Question
>
>
> > That didn't work either.
> > The documentation seems to show that you have to use  = 1000, but I
can't
> > get it to work.
> >
> > > Try putting it like this ::
> > >
> > > AUTO_INCREMENT(1000), .
> > >
> > > Not sure but that should work
> > >
> > > - Deryck H
> > > - http://www.comp-u-exchange.com
> > > - Original Message -
> > > From: "Mysql List" <[EMAIL PROTECTED]>
> > > To: "mysql" <[EMAIL PROTECTED]>
> > > Sent: Friday, September 07, 2001 3:49 PM
> > > Subject: Question
> > >
> > >
> > > > Hi,
> > > > Why is mysql(ver 3.23.41) complaining about this:
> > > >
> > > > CREATE TABLE mytable(ID INT NOT NULL AUTO_INCREMENT = 1000,PRIMARY
KEY
> > > (ID),
> > > >
> > > > I know it is not the entire statement, but mysql does not like the
> > > > AUTO_INCREMENT = 1000 part, how do I do that so it is acceptable?
> > > >
> > > > Thanks,
> > > > Chris
> > > >
> > > >
> > >
> -
> > > > Before posting, please check:
> > > >http://www.mysql.com/manual.php   (the manual)
> > > >http://lists.mysql.com/   (the list archive)
> > > >
> > > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > > Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > 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

Update question

[Jeff Tanner]

UPDATE returns the number of rows that were actually changed.
How is the returned number of rows formatted for SQLFetch/SQLGet?
Thanks
Jeff Tanner
Seattle, WA


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

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: intersection: join query...

[Ian Barwick]

On Friday 07 September 2001 23:37, Anthony E. wrote:
> i have two tables with similar structure...
>
> i want to find the intersection of data between two
> tables that have the same email address.
>
>
> I tried the following with an error (Unknown table
> 'USER' in where clause) the USER table is definitely
> there though:
>
>
> select count(email) from USER_TMP where USER_TMP.email
> = USER.email;

Tell MySQL you want to access the table USER as well:

SELECT COUNT(email) FROM USER_TMP, USER 
 WHERE USER_TMP.email=USER.email

(the FROM-clause contains the names of all tables you reference in the query, 
not just the ones you select)

(...)

HTH

Ian Barwick

-- 
Ian Barwick - Developer  [EMAIL PROTECTED]
http://www.akademie.de

"Luncheon meat tables with MySQL data"

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

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 and more questions......

[linux]

Just wondering, if I make changes to the master database table structures,
will the changes be reflected in the slave databaase tables or do I need to
manually re-copy master database snapshot to the slave?


Thanks,

Jeff


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

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: ERROR 2002

[Narvaez, Teresa]

Seems like MySQL is not running.  Check to make sure it's running by
executing: 
ps -eaf | grep mysql (on a Unix platform).  If no processes are running then
start MySQL. 

Hope this helps you,
-Teresa



-Original Message-
From: Pablo Javier Gonzalez Mateos [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 07, 2001 4:10 PM
To: [EMAIL PROTECTED]
Subject: ERROR 2002


Anyone can help me with this 
What can i do 
thanks a lot !

ERROR 2002: Can't connect to local MySQL server through socket 
'/tmp/mysql.sock' (111)


-- 
Pablo Javier Gonzalez Mateos, [EMAIL PROTECTED] on 
07/09/2001



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

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

intersection: join query...

[Anthony E.]

i have two tables with similar structure...

i want to find the intersection of data between two
tables that have the same email address.


I tried the following with an error (Unknown table
'USER' in where clause) the USER table is definitely
there though:


select count(email) from USER_TMP where USER_TMP.email
= USER.email;


(i want to delete entries from USER_TMP, where the
email is the same as an entrie in USER tablem, before
eventually insert data from USER_TMP into USER table).


Mysql v 3.22.32



=
--
Anthony Ettinger
[EMAIL PROTECTED]
415-504-8048
http://chovy.com/resume.doc

__
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com

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

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

Re: Question

[Deryck Henson]

MaybeI guessThere's either too many datatypes or try putting like
this (again, probably wont work)

Auto_Increment=1000, .

- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Mysql List" <[EMAIL PROTECTED]>
To: "Deryck Henson" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 4:26 PM
Subject: Re: Question


> That didn't work either.
> The documentation seems to show that you have to use  = 1000, but I can't
> get it to work.
>
> > Try putting it like this ::
> >
> > AUTO_INCREMENT(1000), .
> >
> > Not sure but that should work
> >
> > - Deryck H
> > - http://www.comp-u-exchange.com
> > - Original Message -
> > From: "Mysql List" <[EMAIL PROTECTED]>
> > To: "mysql" <[EMAIL PROTECTED]>
> > Sent: Friday, September 07, 2001 3:49 PM
> > Subject: Question
> >
> >
> > > Hi,
> > > Why is mysql(ver 3.23.41) complaining about this:
> > >
> > > CREATE TABLE mytable(ID INT NOT NULL AUTO_INCREMENT = 1000,PRIMARY KEY
> > (ID),
> > >
> > > I know it is not the entire statement, but mysql does not like the
> > > AUTO_INCREMENT = 1000 part, how do I do that so it is acceptable?
> > >
> > > Thanks,
> > > Chris
> > >
> > >
> > > -
> > > Before posting, please check:
> > >http://www.mysql.com/manual.php   (the manual)
> > >http://lists.mysql.com/   (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Question

[Mysql List]

That didn't work either.
The documentation seems to show that you have to use  = 1000, but I can't
get it to work.

> Try putting it like this ::
>
> AUTO_INCREMENT(1000), .
>
> Not sure but that should work
>
> - Deryck H
> - http://www.comp-u-exchange.com
> - Original Message -
> From: "Mysql List" <[EMAIL PROTECTED]>
> To: "mysql" <[EMAIL PROTECTED]>
> Sent: Friday, September 07, 2001 3:49 PM
> Subject: Question
>
>
> > Hi,
> > Why is mysql(ver 3.23.41) complaining about this:
> >
> > CREATE TABLE mytable(ID INT NOT NULL AUTO_INCREMENT = 1000,PRIMARY KEY
> (ID),
> >
> > I know it is not the entire statement, but mysql does not like the
> > AUTO_INCREMENT = 1000 part, how do I do that so it is acceptable?
> >
> > Thanks,
> > Chris
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


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

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

Question

[Mysql List]

Hi,
Why is mysql(ver 3.23.41) complaining about this:

CREATE TABLE mytable(ID INT NOT NULL AUTO_INCREMENT = 1000,PRIMARY KEY (ID),

I know it is not the entire statement, but mysql does not like the
AUTO_INCREMENT = 1000 part, how do I do that so it is acceptable?

Thanks,
Chris


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

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

ERROR 2002

[Pablo Javier Gonzalez Mateos]

Anyone can help me with this 
What can i do 
thanks a lot !

ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)


--
Pablo Javier Gonzalez Mateos, [EMAIL PROTECTED] on
07/09/2001



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

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 deadlock situation - possible bug

[Michael Widenius]

Hi!

> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:

Sinisa> Aaron Brick writes:
>> good day -
>> 
>> i have found cases in which the daemon blocks waiting on a select() and
>> just plain refuses to process certain queries. since i am reading in a 60
>> meg file, meaning about 3.5 million queries, this consistently happens
>> somewhere in the middle. i am using 3.23.41.



What does 'mysqladmin proc' say when this happens ?
If it says 'system lock' then this is a bug in the lockd daemon and
you should start mysqld with '--skip-locking' or remove
'enable-locking' from your my.cnf file.

Regards,
Monty

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
   <___/   www.mysql.com

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

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

UPDATE bug

[nep]

>Description:
Ok, I know I submitted an earlier bug report about this, but I've actually
had it happen from the mysql monitor. Essentially, UPDATE queries are
executing, but not actually updating, unless I SELECT data from the table
first.

>How-To-Repeat:
Simple as that. I have yet to notice any particular pattern. It happens
for some queries, on some tables, some of the time.

>Fix:
Select data from the table first.

>Submitter-Id:  
>Originator:nick edward purvis
>Organization:
 CarSpot.com
>MySQL support: none
>Synopsis:  UPDATE queries executing, but failing to actually update
>Severity:  non-critical
>Priority:  low
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.34a (Source distribution)

>Environment:

System: FreeBSD xtabi.carspot.com 4.2-RELEASE FreeBSD 4.2-RELEASE #4: Sat Jun  2 
22:42:12 CDT 2001 [EMAIL PROTECTED]:/usr/src/sys/compile/XTABI  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='-O -pipe'  CXX='c++'  CXXFLAGS='-O -pipe 
-felide-constructors -fno-rtti -fno-exceptions'  LDFLAGS=''
LIBC: 
-r--r--r--  1 root  wheel  1169076 Nov 20  2000 /usr/lib/libc.a
lrwxrwxrwx  1 root  wheel  9 Mar 13 12:02 /usr/lib/libc.so -> libc.so.4
-r--r--r--  1 root  wheel  559196 Nov 20  2000 /usr/lib/libc.so.4
Configure command: ./configure  --localstatedir=/var/db/mysql --without-perl 
--without-debug --without-readline --without-bench --with-mit-threads=no 
--with-libwrap --with-low-memory --enable-assembler --with-berkeley-db 
--prefix=/usr/local i386--freebsd4.2
Perl: This is perl, version 5.005_03 built for i386-freebsd

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

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: Let's approach stored procedures

[Robert Alexander]

Hi Claudio,

I think having the functionality of stored procedures would be a wonderful addition to 
MySQL. Let me be the first to say a hearty 'Thank you!' for your very generous offer 
to devote your vacation time to this task.

I like Oracle's PL/SQL. I've used it a fair amount, and it get's the job done. PL/SQL 
= Procedural SQL -- SQL plus procedural logic. This has the advantage of being a 
language that uses the SQL that we all already know and love, plus enough procedural 
things -- loops, conditionals, etc. -- to implement logic. It's more a programming 
language than just a query language. This is a good thing.

That being said, I don't think re-implementing PL/SQL is necessarily the way to go for 
MySQL. There may indeed be proprietary issues (though I'm not sure) and I think it'd 
be possible to take a more 'open source' approach.

Let's remember what we want to accomplish with stored procs; that is, the ability to 
store server-side logic where we can implement such things as business rules, and 
ensure consistency in the way 'front-ends' of whatever flavour (and probably written 
by different programmers) perform transactions with the dataset.

In my opinion, it'd be great if the choice of the server-side procedural language 
could be left up to the developer/DBA. Perhaps a method whereby the stored proc would 
then call a script in [language-of-choice] and then accept the returned results.

I realize that that method is not as tightly 'married' to MySQL as an internal 
PL/SQL-like language would be and, depending on the scripting language, may have a bit 
of a performance hit, but it does allow more freedom for the DBA in the tools to 
choose from.

Just some thoughts. They're open-source, of course, so do with them what you will. :>

Best,
/Rob

Ob. MySQL: database, sql, query, table

~
Robert Alexander~~   Programmer/Analyst/DBA/Admin
WWW Database Applications~~http://www.ra1.net
Web Software and Hosting   ~~  http://www.workmate.ca

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

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: Expiring Binary Logs

[A. Clausen]

-- Original Message --
From: Jeremy Zawodny <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 7 Sep 2001 00:12:24 -0700

>On Wed, Sep 05, 2001 at 01:33:03PM -0700, A. Clausen wrote:
>
>PURGE LOGS:
>
>  http://www.mysql.com/doc/R/e/Replication_SQL.html

Thanks for the pointer.

Aaron

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

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

Re: Please Advice

[Webmaster]

I am using ASP and MySQL and am very happy with the performance!

If you are on a Windows box, and have IIS5, there is no reason not to use
ASP and the MySQL/MyODBC set up... it really does work well... (you could,
of course, install PHP on your Windows box... (www.php.net)... I do like
PHP... and use it in certain circumstances)... really, in my opinion, both
set-ups perform equally well... and it comes down to a C++ "feel" or a VB
"feel" when you are scripting...

John Shipp
SmallTownWorld.com


- Original Message -
From: "Shaji Khan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 11:10 AM
Subject: Please Advice


> Hi, I am a newbie to MySql and I am planning to use MySql and PHP to
develop
> a shopping cart and other components of a full blown ecommerce site. Is
this
> a good choice for this kind of work or do you guys think some thing like
SQL
> Server and ASP is a better choice.
>
> Experienced users, please advice.
>
> Thanks for all the help.
>
> Khan
>
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>



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

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

[Colm Brazel]

Hi

Trying to create a database or reload the Grant tables using mysql/bin/
./mysqladmin  I get an access denied message including a PASSWORD NO
message. Trying the troubleshoot docs for this I get Access Denied for the
suggestions made to deal with this. This is also causing a MERANT mySQL
driver not to connect, ACCESS DENIED again problem of CF5.0 loaded on cobalt
raq running linux red hat tring the connect to database. Is there any
command or function or option I can use to pass the password with these
commands, or any other suggestions gladly received

Colm Brazel (MA)
CB Publications
www.cbweb.net
[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

Fulltext search

[Lorang Jacques]

One last question : The Fulltext search only matches those rows who match
teh exact word, so if I search for "bank", the query wont find banking.
(this would work with "like '%bank%'", but that is much slower). So is there
anything you can to make it also match those ??
Lorang Jacques
sql is 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

Fulltext search

[Lorang Jacques]

One last question : The Fulltext search only matches those rows who match
teh exact word, so if I search for "bank", the query wont find banking.
(this would work with "like '%bank%'", but that is much slower). So is there
anything you can to make it also match those ??
Lorang Jacques



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

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: InnoDB problems

[Heikki Tuuri]

Nuno,

what does

ulimit -a

say (assuming you are running on Unix)?
ulimit tells the limits set for the user.
I think there are also hard limits decided
at kernel compile time.

What does

free

say?

Regards,

Heikki
http://www.innodb.com

>Nuno Dias wrote:
> 
>> I installed mysql with innodb support on a machine with 2G of RAM.> 
>> The manual recommends that one should set innodb_buffer_pool_size in
my.cnf to 
>up to 80% of the physical memory available.
> 
>> However, if I set a value above 50M!!! I get this error:
> 
>> Innobase: Fatal error: cannot allocate memory!
>> Innobase: Cannot continue operation!
>> Innobase: Check if you can increase the swap file of your
>> Innobase: operating system.
> 010906 15:31:27  mysqld ended
> 
>> Anyone as any clue about this?
> > --> Nuno Dias <[EMAIL PROTECTED]>
>> Novis - Dir. Rede - ISP 
>> Ed. Atrium Saldanha - Pça. Dq. de Saldanha, 1, 7o / 1050 - 094 Lisboa
>> tel: +351 21 0104437 - fax: +351 21 0104301> 
>> I may not be able to walk, but I drive from a sitting position.



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

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: Limit query to a value

[Benjamin Pflugmann]

Hi.

On Fri, Sep 07, 2001 at 07:12:47PM +0200, [EMAIL PROTECTED] wrote:
> Hello,
> How can I limit the query to those rows where "SUM(value) as Tot > 0".
> If I put it in an where clause it get an error.

That is to be expected, as in SQL the WHERE clause is evaluated before
the SELECT clause (i.e. the fields) are read at all. So SUM(value) is
not defined at the time the WHERE clause is evaluated.

Expression which depend on the selected fields can/have to be written
in the HAVING clause.

> So how to do that

SELECT   id,url,title,description,top,keyword,SUM(value) as Tot 
FROM links LEFT JOIN keywords ON links.id=keywords.LinkId
GROUP BY id
HAVING   Tot > 0
ORDER BY tot DESC

This should work.

Bye,

Benjamin.

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

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

A Way to protect DBI passwords in perl

[Anthony R. J. Ball]

  Hi all, just thought I'd let people know. I recently
developed a way to pass protected config file data to
unprotected perl scripts (system user scripts/cgis).

  The project can be found at 
http://psc.sourceforge.net/

  It is a C setuid wrapper that opens a protected file
and drops its priviledge, then execs the proper perl
script leaving the filehandle available to it. There
is then a module Config::Secure, which initializes the
script and optionally parses the conf data.

  I originally came up with this idea in the search
for a way to pass DBI passwords to scripts that needed
to be available to users but connected to a database,
so I thought others here might appreciate it.

  It is still alpha, but I would appreciate any input.

  The project is all GPL, free for use.

Thanks - Ant

-- 
 ___  __  ____  _  _  _  _     
/ __)(  )(  )  /__\( \/ )( ___)  ( \( )( ___)(_  _)
\__ \ )(__)(  /(__)\\  /  )__))  (  )__)   )(  
(___/(__)(__)(__)\/  ()()(_)\_)() (__) 
A clear conscience is usually the result of bad memory. 



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

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: Limit query to a value

[Dana Powers]

Add 'HAVING Tot>0' to your query.
dpk

- Original Message -
From: "Lorang Jacques" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 10:12 AM
Subject: Limit query to a value


> Hello,
> How can I limit the query to those rows where "SUM(value) as Tot > 0". If
I
> put it in an where clause it get an error. So how to do that
> SELECT id,url,title,description,top,keyword,SUM(value) as Tot FROM links
> LEFT JOIN keywords on links.id=keywords.LinkId Group by id order by tot
desc
> Lorang Jacques
> sql is 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

Re: Please Advice

[Rodney Broom]

From: Shaji Khan <[EMAIL PROTECTED]>


> Hi, I am a newbie to MySql and I am planning to use MySql and PHP to develop 
> a shopping cart and other components of a full blown ecommerce site. Is this 
> a good choice for this kind of work or do you guys think some thing like SQL 
> Server and ASP is a better choice.

- MySQL is free, MS SQL Server is not (as far as I know).
- MySQL is faster than pretty much anything else going with the same features.
  At least on *NIX type systems, I don't know about MickySoft.
- PHP has lots of options, LOTS. Although I've found it to be with concernes.
  If you write Perl, I would suggest using that. Here's part of why:
http:[EMAIL PROTECTED]/msg01457.html
http:[EMAIL PROTECTED]/msg01461.html



---
Rodney Broom
Programmer: Desert.Net




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

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: Please Advice

[Adams, Bill TQO]

Shaji Khan wrote:

> Hi, I am a newbie to MySql and I am planning to use MySql and PHP to develop
> a shopping cart and other components of a full blown ecommerce site. Is this
> a good choice for this kind of work or do you guys think some thing like SQL
> Server and ASP is a better choice.
>
> Experienced users, please advice.


If you use MS SQL Server + ASP all of your profits will be eaten by licensing
fees.


AFAIK, there is nothing that the MS solution has to offer that MySQL+PHP does
not.  MySQL+PHP is a good choice IMNOHO.

--Bill


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

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 Perl for the Web

[Paul DuBois]

I've been mildly scolded for not announcing this somewhere,
so, on the "better late than never" principle, here goes. :-)

New Riders has published a new book called "MySQL and Perl for the Web"
(by me).  It focuses on using MySQL together with the Perl DBI and CGI.pm
modules to perform various kinds of Web-related tasks.  It's also got
some stuff on using mod_perl.  The book's home page is at:

 http://www.kitebird.com/mysql-perl/

where you can also find a pointer to the New Riders listing. That
listing provides access to a PDF version of one of the chapters,
which you can read to get some idea of what the rest of the book is
like.

I'll point out that there's a review of the book on Amazon.  It's
negative.  From my point of view, the review is unsatisfactory, not
because it's negative, but because it doesn't really say what the reader
found wrong with it in any specific manner. That doesn't help me know
how it could have been improved. (Feedback that I've received privately
has been much more positive.)

I should also point out that some of the online booksellers have a
table of contents posted that is inaccurate.  Specifically, such TOCs
list a chapter on XML, but there is no such chapter. (Had one planned,
but ran out of time and energy.)

-- 
Paul DuBois, [EMAIL PROTECTED]

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

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

Re: Limit query to a value

[Adams, Bill TQO]

Lorang Jacques wrote:

> Hello,
> How can I limit the query to those rows where "SUM(value) as Tot > 0". If I
> put it in an where clause it get an error. So how to do that
> SELECT id,url,title,description,top,keyword,SUM(value) as Tot FROM links
> LEFT JOIN keywords on links.id=keywords.LinkId Group by id order by tot desc

SELECT id,url,title,description,top,keyword,SUM(value) as Tot FROM links LEFT
JOIN keywords on links.id=keywords.LinkId Group by id order by tot desc HAVING
Tot>0

--Bill




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

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

MyODBC Recordset problem.

[Clark, John]

Sorry if this e-mail is rather long but I want to give all code I am using
as to make sure that everyone has all the information they need.

Machine info:
MySQL for Win 2000
IIS5

The Table:

CREATE TABLE Players (
pid INT AUTO_INCREMENT NOT NULL,
RealFullName CHAR(70) NOT NULL,
RealAge INT NOT NULL,
EMAIL CHAR(50) NOT NULL,
Login CHAR(50) NOT NULL,
Password CHAR(50) NOT NULL,
UserLevel TINYINT NOT NULL,
lastip CHAR(20) NOT NULL,
lastlogindate DATE NOT NULL,
lastlogintime TIME NOT NULL,
rank INT NOT NULL,
turns INT NOT NULL,
money BIGINT NOT NULL,
commission INT NOT NULL,
bodyguards INT NOT NULL,
associates INT NOT NULL,
soldiers INT NOT NULL,
captains INT NOT NULL,
hitmen INT NOT NULL,
glocks INT NOT NULL,
shotguns INT NOT NULL,
mguns INT NOT NULL,
srifles INT NOT NULL,
food INT NOT NULL,
fid INT NOT NULL,
Voted TINYINT NOT NULL,
Frozen TINYINT NOT NULL,
Squelched TINYINT NOT NULL,
PRIMARY KEY (pid),
UNIQUE (Login),
UNIQUE (EMail)
);

The ASP Code:

   set dbs = CreateObject ("ADODB.Connection")
   dbs.Open "gamedb"
   Set rs = Server.CreateObject("ADODB.Recordset")
   rs.open "SELECT * FROM Players", dbs, 3,3
rs.addnew
rs("pid") = lastpid + 1
rs("RealFullName") = request.form("FullName")
rs("RealAge") = request.form("RealAge")
rs("EMail") = request.form("EMail")
rs("Login") = request.form("usrname")
rs("Password") = request.form("usrpassword")
rs("UserLevel") =   1
session.contents("UserLevel") = 1
if request.form("usrname") = "Kewlb" or _
   request.form("usrname") = "Strike" then
rs("UserLevel") = 5
session.contents("UserLevel") = 5
end if
rs("LastIP") = Request.ServerVariables("REMOTE_ADDR")
rs("LastLoginDate") = date
rs("LastLoginTime") = time
rs("rank") = 0
rs("turns") = 355
rs("money") = 7500
rs("commission") = 10
rs("bodyguards") = 5
rs("associates") = 0
rs("soldiers") = 0
rs("captains") = 0
rs("hitmen") = 0
rs("glocks") = 0
rs("shotguns") = 0
rs("mguns") = 0
rs("srifles") = 0
rs("food") = 500
rs("fid") = 0
rs("voted") = 0
rs("frozen") = 0
rs("Squelched") = 0
session.contents("LoggedIn") = true
rs.update
dbs.close

ASP ERROR:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
/mafiastar/doregister.asp, line 53

if I try to manually (via mysqlgui) add a new record I get the following:

column count doesn't match value count


Any help would be great, once again sorry for the really long e-mail



Brian Clark - A+, Net+, CCA, MCP, CCNA
Systems Anyalsis
Expanets Direct


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

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: command line open source ARRRGGGGGG!!!!!!

[Robert Alexander]

At 23:07 -0700 2001/09/06, Chadrick Mahaffey wrote:
>I realize that I'm going to be in the minority here but I have to say it.
>Open source would go much farther if they had self explanatory GUIs and had
>basic pre-setup apps that were ready for the average user to use. I program
>in Java and I feel the same about the JDK Sun produces. I use JCreator
>because it has an easy to follow GUI interface. Most open source apps I have
>attempted to use have some of the worse documentation around. The writers
>assume so much about the users. OK - call me inept, stupid, or whatever but
>I had to say it.
>
>Thanks,
>THE chad

Hi Chad,

I feel your pain... :>  I come from a predominately GUI environment, too. But, if 
you've gotten this far, I doubt very much that you're stupid -- just inexperienced 
with this type of app and these methods.

MySQL actually has very good documentation; you're just looking in the wrong area. Try 
the Windows-specific installation instructions instead of the Unix ones.

Granted, working at the command-line can be daunting at first with all those cryptic 
and arcane instructions, *but* it's also very powerful; you can accomplish difficult 
things very quickly once you're used to it. (Definitely true in Unix, I'm unsure about 
Windows.)

Both GUIs and the command-line have their place, and their strengths and weaknesses. I 
wouldn't want to do without either.

I learned 'command-line stuff' on Sun Solaris and Linux. What a bitch it was the first 
time I installed one of those boxes from scratch (and then learned how to compile and 
build software). But, ya know, even though it may (initially) be a lot of difficult 
work to configure and set one up, there's a big pay-back. Once it's done, you've got a 
nearly bulletproof, rock-solid, absolutely dependable computer. My Sun boxes simply 
*never* crash.

Hell, I'd be frustrated and pulling my hair, too, if I had to sit down and attempt an 
install on Windows. I've never done it, so it'd be a completely new, confusing, and 
seemingly idiotic procedure for me. But I'm pretty sure I'd eventually get through it. 
:>

So dive in, get your hands dirty, read lots, and it'll start to make sense pretty 
quickly.

Good luck. May the foo be with you. :>

/Rob

~
Robert Alexander~~   Programmer/Analyst/DBA/Admin
WWW Database Applications~~http://www.ra1.net
Web Software and Hosting   ~~  http://www.workmate.ca

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

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: Let's approach stored procedures

[Dana Powers]

>Claudio Cicali ([EMAIL PROTECTED]) writes:
> - where I work, we have a HUGE database-driven web-application. A lot of
>our businness logic is implemented via stored procedures, that
>act as black boxes for the web-designers.
>Think of enterprise java beans.
>They are not "nonsense" or such. They are usefull.
>(I know, you can use ejb with JDBS and mysql..., but if you want to
have
>some logic incapsualted, you should use some kind of "component")
> - sp extends the RDBMS itself in its functionality. Think about some
stupid
>"check_fiscal_code()" or "insert_new_customer()".
>Web designers use the "insert_new_customer", instead of using SQL
>directly.

I have found that the same thing can be achieved using a middle layer like
XML-RPC or SOAP. This also allows business logic to appear closer to native
functions in your web programming language than still having to use SQL. For
example, if you use mod_perl, you can just call 'insert_new_customer()' from
perl and this gets transmorgified across XML-RPC to a transaction in the
database with very little extra code.

Ive been thinking/working on this problem for a while and it seems that
there are 2 major issues:

1. Ability to create arbitrary functions in some language X.
2. Ability for arbitrary function to call back into the database.

Problem 1 is pretty straightforward. I've even put a patch for an older
version of mysql up at http://www.tanisconsulting.com/mysql-perl.html that
creates a language 'plugin' architecture and implements perl for starters.
( python would be easy, as would javascript or lisp etc.. I just happen to
be a perl hacker )

Problem 2 is not, or at least I havent come up with a good, non-intrusive
way to accomplish it yet.

dpk


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

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

InnoDB problems

[Nuno Dias]

I installed mysql with innodb support on a machine with 2G of RAM.

The manual recommends that one should set innodb_buffer_pool_size in my.cnf to up to 
80% of the physical memory available.

However, if I set a value above 50M!!! I get this error:

Innobase: Fatal error: cannot allocate memory!
Innobase: Cannot continue operation!
Innobase: Check if you can increase the swap file of your
Innobase: operating system.
010906 15:31:27  mysqld ended

Anyone as any clue about this?

-- 
Nuno Dias <[EMAIL PROTECTED]>
Novis - Dir. Rede - ISP  
Ed. Atrium Saldanha - Pça. Dq. de Saldanha, 1, 7o / 1050 - 094 Lisboa
tel: +351 21 0104437 - fax: +351 21 0104301



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

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

Please Advice

[Shaji Khan]

Hi, I am a newbie to MySql and I am planning to use MySql and PHP to develop 
a shopping cart and other components of a full blown ecommerce site. Is this 
a good choice for this kind of work or do you guys think some thing like SQL 
Server and ASP is a better choice.

Experienced users, please advice.

Thanks for all the help.

Khan

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


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

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

Limit query to a value

[Lorang Jacques]

Hello,
How can I limit the query to those rows where "SUM(value) as Tot > 0". If I
put it in an where clause it get an error. So how to do that
SELECT id,url,title,description,top,keyword,SUM(value) as Tot FROM links
LEFT JOIN keywords on links.id=keywords.LinkId Group by id order by tot desc
Lorang Jacques
sql is 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: A question about load / queries pr second

[Basil Hussain]

Hi,

> > On the other hand though, it gives me some comfort that the hardware
> > being used in my operation will meet any future needs. We have
> > similar spec servers (P3-1Ghz dual-cpu, 512Mb RAM, 3x36Gb SCSI
> > RAID5). Maybe I should try out mysql-super-smack and see what kind
> > of numbers it turns up. :-)
>
> It would be interesting.

Well, I finally got super-smack compiled and running (had to make a couple
of amendments to die.cc and gen-data.cc - thanks Joshua S), so here are my
results:

# super-smack -d mysql select-key.smack 25 100
Query Barrel Report for client smacker1
connect: max=27ms  min=0ms avg= 7ms from 25 clients
Query_type  num_queries max_timemin_timeq_per_s
select_index50000   0   8271.83

# super-smack -d mysql update-select.smack 25 100
Query Barrel Report for client smacker
connect: max=20ms  min=0ms avg= 4ms from 25 clients
Query_type  num_queries max_timemin_timeq_per_s
select_index25001   0   3154.04
update_index25001   0   3154.04

Performance peaks at 25 clients, with performance being lesser with fewer or
greater numbers of connections. I find it strange that performance is
relatively 'poor' with only 1 client (at 5153.31 q/sec) - must probably be
something to do with caching. What's better though, is that performance at
250 clients is just as good as with one!

This was on a machine with the spec. above and running Red Hat 7.0 (kernel
2.2.16-22enterprise) and MySQL 3.23.38 with the following config:

set-variable = max_connections = 500
set-variable = key_buffer=256M
set-variable = join_buffer_size=16M
set-variable = sort_buffer=16M
set-variable = record_buffer=16M
set-variable = tmp_table_size=64M
set-variable = table_cache=256
set-variable = thread_cache_size=16
set-variable = thread_concurrency=4
set-variable = back_log=100
set-variable = max_allowed_packet=2M
set-variable = wait_timeout=240
skip-locking

Regards,

Basil Hussain
---
Internet Developer, Kodak Weddings
E-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

RE: Let's approach stored procedures

[Ed Carp]

> Since the current version of MySQL is open source you could write stored
> procedures in the same language used in (until recently) DB2, i.e., C.  I

Why reinvent the wheel? MySQL already has user-defined function capability
in C.

> Related question, what language or psuedo language would be used to code
> them.


SQL, obviously. Anything else would be insane.
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 -
http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London


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

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: Let's approach stored procedures

[Cal Evans]

SQL. Stored procedures are loosely analogous to shell scripts.  No
additional language constructs, outside of what is defined in the ANSI-SQL
standard are necessary for them.

IMHO, C would be a bad thing.
My $.02 worth, (which is worth less, each time I post)
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "William R. Mussatto" <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "Ed Carp" <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 11:27
Subject: Re: Let's approach stored procedures


> On Fri, 7 Sep 2001, Cal Evans wrote:
>
> > Date: Fri, 7 Sep 2001 11:05:27 -0500
> > From: Cal Evans <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED], [EMAIL PROTECTED], Ed Carp <[EMAIL PROTECTED]>
> > Subject: Re: Let's approach stored procedures
> >
> > Ed,
> >
> > Stored procedures allow you to pre-compile and re-use code easily. They
also
> > make transactions easier. (At least from one point of view) It's not
like
> > the XML argument. SPs are also part of the ANSI spec so to be compliant,
> > MySQL will have to have them. XML is not part of the ANSI-SQL spec.
> >
> > IMHO,
> > Cal
> > *
> > * Cal Evans
> > * Senior Internet Dreamer
> > * http://www.calevans.com
> > *
> Since the current version of MySQL is open source you could write stored
> procedures in the same language used in (until recently) DB2, i.e., C.  I
> don't think that would be useful for those of us who are C challanged...
> I think the real question is, can it be done w/o impacting performance.
> Related question, what language or psuedo language would be used to code
> them.
>
> > - Original Message -
> > From: "Ed Carp" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > Sent: Friday, September 07, 2001 10:44
> > Subject: Re: Let's approach stored procedures
> >
> >
> > > Claudio Cicali ([EMAIL PROTECTED]) writes:
> > >
> > > > At a first glance, I think Oracle PL/SQL is the best (afaik)
> > > > programming language for sp, but, in the case we implement
> > > > that language, should we go against some Oracle copytight
> > > > infringment ?
> > >
> > > Why would you want to do such a thing? Isn't SQL good enough? I'm just
> > trying to figure out your reasoning here, besides the same argument used
by
> > the XML crowd of "it's the latest/greatest do-all-be-all-end-all, so
> > everyone should be using it" type of nonsense.
> > > --
> > > Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 -
> > http://www.pobox.com/~erc
> > >
> > > Squished Mosquito, Inc.
> > > Internet Applications Development
> > > Escapade Server-Side Scripting Language Development Team
> > > http://www.squishedmosquito.com
> > > Pensacola - Dallas - Dresden - London
> > >
> > > -
> > > Before posting, please check:
> > >http://www.mysql.com/manual.php   (the manual)
> > >http://lists.mysql.com/   (the list archive)
> > >
> > > 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
> >
>
> 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

Re: Let's approach stored procedures

[Adams, Bill TQO]

Cal Evans wrote:

> Stored procedures allow you to pre-compile and re-use code easily. They also
> make transactions easier. (At least from one point of view) It's not like
> the XML argument. SPs are also part of the ANSI spec so to be compliant,
> MySQL will have to have them. XML is not part of the ANSI-SQL spec.

The other thing about all of this is that MySQL is feature rich so most people
might not have a use for stored procedures.  Unlike, say, Informix which has
not build in MIN or MAX function.

Again, if having stored procedures built in does not slow down queries that do
not use stored procedures, I do not see what the harm is.

--Bill


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

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: Let's approach stored procedures

[William R. Mussatto]

On Fri, 7 Sep 2001, Cal Evans wrote:

> Date: Fri, 7 Sep 2001 11:05:27 -0500
> From: Cal Evans <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED], [EMAIL PROTECTED], Ed Carp <[EMAIL PROTECTED]>
> Subject: Re: Let's approach stored procedures
> 
> Ed,
> 
> Stored procedures allow you to pre-compile and re-use code easily. They also
> make transactions easier. (At least from one point of view) It's not like
> the XML argument. SPs are also part of the ANSI spec so to be compliant,
> MySQL will have to have them. XML is not part of the ANSI-SQL spec.
> 
> IMHO,
> Cal
> *
> * Cal Evans
> * Senior Internet Dreamer
> * http://www.calevans.com
> *
Since the current version of MySQL is open source you could write stored 
procedures in the same language used in (until recently) DB2, i.e., C.  I 
don't think that would be useful for those of us who are C challanged... 
I think the real question is, can it be done w/o impacting performance.  
Related question, what language or psuedo language would be used to code 
them.

> - Original Message -
> From: "Ed Carp" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, September 07, 2001 10:44
> Subject: Re: Let's approach stored procedures
> 
> 
> > Claudio Cicali ([EMAIL PROTECTED]) writes:
> >
> > > At a first glance, I think Oracle PL/SQL is the best (afaik)
> > > programming language for sp, but, in the case we implement
> > > that language, should we go against some Oracle copytight
> > > infringment ?
> >
> > Why would you want to do such a thing? Isn't SQL good enough? I'm just
> trying to figure out your reasoning here, besides the same argument used by
> the XML crowd of "it's the latest/greatest do-all-be-all-end-all, so
> everyone should be using it" type of nonsense.
> > --
> > Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 -
> http://www.pobox.com/~erc
> >
> > Squished Mosquito, Inc.
> > Internet Applications Development
> > Escapade Server-Side Scripting Language Development Team
> > http://www.squishedmosquito.com
> > Pensacola - Dallas - Dresden - London
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > 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
> 

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

Re: newbie:

[Carl Troein]

ricardo bravo writes:

> Hi All,
> 
> where do I specify the remote hosts that are allowed to access port 3306? I 
> have made entries in the user table of the mysql db, but still cannot conect 
> from a remote machine. Thanks,

Do the entries match the host you're connecting from? Did you add them
with GRANT, and if not did you FLUSH PRIVILEGES? And first and foremost
excaclty what error message do you get, and when? Did you disable
TCP/IP with --skip-networking? Are you connecting to the right host and
port? Is MySQL running? Is there a firewall blocking the way? Did you
try connecting with telnet like the manual suggests?

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


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

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

Re: Mysql Fulltextsearch

[Doug Poland]

On Fri, Sep 07, 2001 at 11:10:46AM -0500, Ed Carp wrote:
> > Do the current limitations of 500 characters per index and limited (?)
> > number of columns per index pose problems?  I want to use fulltext
> > on a database with 7 varchar(255) columns and several smaller varchar
> > columns but can't build a fulltext index.  Is there documentation on
> > the limitations of fulltext?
> 
> I've had no problems, but I also haven't seen any documentation on
> limitations.  The FULLTEXT page is at
> http://www.mysql.com/doc/F/u/Fulltext_Search.html if you can see something
> I've missed...
>
Thanks for the URL, the limitiations I mentioned were discovered when I was
attempting to build fulltext indexes on said tables.

-- 
Regards,
Doug

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

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

Re: COUNT elements in a LIMIT query

[Carl Troein]

Torgil Zechel writes:

> I would like to get the total number of records in tbl along with the 10
> first ones..

As far as I recall this is one of the things that will be added in
version 4. The question is just when that version will be stable
enough to be fully trusted (it might already be for all I know),
and when there will be a function to access the count in PHP
(which is the only thing I've used to access a MySQL db).

//C - who once again curses the list manager for not doing something
about reply-to and the dead email addresses on the list. Oh,
and for not responding to emails as well.

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


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

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

Re: Let's approach stored procedures

[Cal Evans]

Let me clarify.

I'm in great favor of stored procedures in MySQL.  It is my HO that all
interaction with the database should take place within stored procedures.
But the ANSI standard is sufficient for most interaction with the database.
My call to arms was to resist the urge that Oracle could not, implementing a
full-blown language within the context of SPs. (Oracle used Java, rumor has
it that MS will implement C#, Java's moronic cousin, in a future release)

Again, IMHO, take it for what it's worth.
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Ed Carp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 11:14
Subject: Re: Let's approach stored procedures


> Cal Evans ([EMAIL PROTECTED]) writes:
>
> > Stick with the ANSI standard. (ANSI99?) Do not try to implement either
> > PL/SQL or T/SQL. Please do not implement PERL (or Python) , Java, PHP or
any
> > other procedural or OO language in stored procedures.  Speaking form
> > experience, all this does is blur the lines of that the database should
do
> > and what the middle tier should do.
>
> BRAVO!  At last, the voice of common sense is heard :)
>
> --
> Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 -
http://www.pobox.com/~erc
>
> Squished Mosquito, Inc.
> Internet Applications Development
> Escapade Server-Side Scripting Language Development Team
> http://www.squishedmosquito.com
> Pensacola - Dallas - Dresden - London
>


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

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

AW: Optimization question and possible bug

[Stefan Pinkert]

No, they do not differ from the rest. The only thing is that they need
longer
time to process (between 1 and 4 seconds, normally the SAME query is
processed
in a few miliseconds). The only correlation i found is that all queries
in that 
log query the merge table.

How does mysql handle locks on merge-tables? Maybe it has do to with
some locking
problembut it's just another suspicion.

-Ursprungliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im Auftrag von Adams, Bill TQO
Gesendet: Freitag, 7. September 2001 17:37
An: Stefan Pinkert
Cc: [EMAIL PROTECTED]
Betreff: Re: Optimization question and possible bug


.


> In the database i have a merge-table that merges 10 myisam tables.
> Sometimes the loadaverage of the system raise above 50 and the
> long-query-log is
> filled with some query accessing the merge table. This happens 2-3
times a
> day.
> Only a minute later everthing is okay again without doing anything.
> I can't believe that it is a performance problem because there is a
> summary of only 10,000 entries in the merge table and 50,000 entries
in
> other
> tables. Does anybody experienced this strange problem, too?

Is the long query different than the other queries? Have you done an
expain
on it?


.

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

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

Re: Query question.

[Michael Garvin]

Not quite.  We're not looking for a left join or natural left join.
I'm not sure MySQL or any database can even do this, it may have to be 
done (rather unattractively) on the API side.
The data in the two tables aren't tied by ID, and shouldn't mix w/ each 
other at all.
To do this, all we've been able to come up with is to use the API (PHP 
in our case) to make 2 queries, copy them into the same array,
and sort the array by timestamp.  However the API's array sort isn't the 
quickest thing ever coded, and the SQL level is where we'd like
to do the sorting.

To clarify, I'll give an example of what we are trying to do:

daily_notes:
note_iduser_numtimestampnote
111Hello
212Goodbye
3231   Blah

project_notes:
note_iduser_numtimestampnote
121Working hard
215Watching others 
work hard


We'd like a query that would return daily_notes #1 and #2 and 
project_notes #2.
However, like I said earlier, I'm not sure SQL can do this.  This list 
is kind of a last resort before defaulting on letting the API sort it 
out after the 2 queries.

Ken wrote:

>Sounds like a left join, maybe even a "natural join", which I haven't tried yet.
>
>select message
>from project left join daily on project.uid = daily.uid
>order by timestamp
>
>Check manual for syntax.
>
>Or am I missing something?
>
>- Ken
>[EMAIL PROTECTED]
>
>At 05:47 PM 9/6/01 -0700, Michael Garvin wrote:
>
>>Ok, we just can't seem to find a solution for this problem.  Thought I'd post it up 
>to see if anyone has any input.
>>
>>Say you have 2 tables project_notes and daily_notes.
>>Each table has a timestamp, and a user_id.
>>Is there any way, in one query, to select all messages from both tables that were 
>entered by a given user_id and
>>sort by timestamp?
>>
>>This isn't the first time this problem has come up here where I work, another 
>application of this solution (if it exists) would be to query
>>different tables representing different realms on our radius servers to get a total 
>usage summary across our network for a given user.
>>




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

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: About MYSQL APIs

[Peter Harvey]

Ed Carp wrote:
> 
> Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
> 
> > Ed Carp writes:
> > > Sinisa Milivojevic ([EMAIL PROTECTED]) writes:
> > >
> > >
> > > ODBC, or MyODBC?
> >
> > ODBC as an API.
> >
> > Then you install ODBC driver for RDBMS of your choice and configure
> > ODBC likewise.
> >
> > But ODBC as a   programming model is independent of RDBMS make.
> 
> So, is MyODBC just for MySQL, or can one use it for talking to other databases via 
>ODBC also? Sorry, I'm just confused today, I guess ;)
> --
> Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc
> 


Check out...
 
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcodbc_function_summary.asp

...for more information on ODBC. Also check out

http://www.unixodbc.org

...for ODBC on UNIX/Linux.

Peter
-- 
+---
| Data Architect
| your data; how you want it
| http://www.codebydesign.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: Let's approach stored procedures

[Claudio Cicali]

At 11.03 07/09/2001 -0500, Ed Carp wrote:
> > - it's cool
>
>Not a valid business reason.
>
> > - where I work, we have a HUGE database-driven web-application. A lot of
> >our business logic is implemented via stored procedures, that
> >act as black boxes for the web-designers.
> >Think of enterprise java beans.
> >They are not "nonsense" or such. They are usefull.
>
>Stored procedures aren't nonsense, but using or re-implementing a particular
>vendor's implementation is.
>
> >(I know, you can use ejb with JDBS and mysql..., but if you
> > want to have
> >some logic incapsualted, you should use some kind of "component")
> > - sp extends the RDBMS itself in its functionality. Think about
> > some stupid
> >"check_fiscal_code()" or "insert_new_customer()".
> >Web designers use the "insert_new_customer", instead of using SQL
> >directly.
>
>These are all great reasons to implement stored procedures, not Oracle
>PL/SQL. I think I'm missing your point here...

No, sorry, it's me :)
I haven't got your point. All, clear, now.

bye


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

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: In the table Properties... What is Row_Format???

[Ed Carp]

Pablo Fraga ([EMAIL PROTECTED]) writes:

> What´s the diference between The row storage format (Fixed, Dynamic, or
> Compressed) .

RTFM!

http://www.mysql.com/doc/C/R/CREATE_TABLE.html
http://www.mysql.com/doc/D/y/Dynamic_format.html

--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

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

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: Let's approach stored procedures

[Ed Carp]

Cal Evans ([EMAIL PROTECTED]) writes:

> Stick with the ANSI standard. (ANSI99?) Do not try to implement either
> PL/SQL or T/SQL. Please do not implement PERL (or Python) , Java, PHP or any
> other procedural or OO language in stored procedures.  Speaking form
> experience, all this does is blur the lines of that the database should do
> and what the middle tier should do.

BRAVO!  At last, the voice of common sense is heard :)

--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

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

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 Fulltextsearch

[Ed Carp]

> Do the current limitations of 500 characters per index and limited (?)
> number of columns per index pose problems?  I want to use fulltext
> on a database with 7 varchar(255) columns and several smaller varchar
> columns but can't build a fulltext index.  Is there documentation on
> the limitations of fulltext?

I've had no problems, but I also haven't seen any documentation on
limitations.  The FULLTEXT page is at
http://www.mysql.com/doc/F/u/Fulltext_Search.html if you can see something
I've missed...
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 -
http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development, Database/SQL Research Directorate
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London


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

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: Let's approach stored procedures

[Cal Evans]

Ed,

Stored procedures allow you to pre-compile and re-use code easily. They also
make transactions easier. (At least from one point of view) It's not like
the XML argument. SPs are also part of the ANSI spec so to be compliant,
MySQL will have to have them. XML is not part of the ANSI-SQL spec.

IMHO,
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Ed Carp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 10:44
Subject: Re: Let's approach stored procedures


> Claudio Cicali ([EMAIL PROTECTED]) writes:
>
> > At a first glance, I think Oracle PL/SQL is the best (afaik)
> > programming language for sp, but, in the case we implement
> > that language, should we go against some Oracle copytight
> > infringment ?
>
> Why would you want to do such a thing? Isn't SQL good enough? I'm just
trying to figure out your reasoning here, besides the same argument used by
the XML crowd of "it's the latest/greatest do-all-be-all-end-all, so
everyone should be using it" type of nonsense.
> --
> Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 -
http://www.pobox.com/~erc
>
> Squished Mosquito, Inc.
> Internet Applications Development
> Escapade Server-Side Scripting Language Development Team
> http://www.squishedmosquito.com
> Pensacola - Dallas - Dresden - London
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Let's approach stored procedures

[Ed Carp]

> - it's cool

Not a valid business reason.

> - where I work, we have a HUGE database-driven web-application. A lot of
>our business logic is implemented via stored procedures, that
>act as black boxes for the web-designers.
>Think of enterprise java beans.
>They are not "nonsense" or such. They are usefull.

Stored procedures aren't nonsense, but using or re-implementing a particular
vendor's implementation is.

>(I know, you can use ejb with JDBS and mysql..., but if you
> want to have
>some logic incapsualted, you should use some kind of "component")
> - sp extends the RDBMS itself in its functionality. Think about
> some stupid
>"check_fiscal_code()" or "insert_new_customer()".
>Web designers use the "insert_new_customer", instead of using SQL
>directly.

These are all great reasons to implement stored procedures, not Oracle
PL/SQL. I think I'm missing your point here...
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 -
http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London


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

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

In the table Properties... What is Row_Format???

[Pablo Fraga]

 What´s the diference between The row storage format (Fixed, Dynamic, or
Compressed) .

I'am experiencing problems with update statements which goes against a table
with the row_format property set to Fixed.

Thanks.

Pablo Fraga (MIS).
e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED]
icq: 113466029




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

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

[Gerald Clark]

This is a standard 1st quarter computer science topic.
You can't reliably test floating point numbers for equality.
0.1 has no exact floating point binary representation.
Perhaps you should use the DECIMAL type which is stored
internally as a string.

Guddack Thorsten ICM MP SCM SCCM PI wrote:

> Hi List,
> 
> I'm a little bit confused.
> 
> I do the following:
> 
> Create a table with 1 int and two floats.
> 
> mysql> create table testfloat(z int, ll float, ul float);
> Query OK, 0 rows affected (0.00 sec)
> 
> inserting one row into the table
> 
> mysql> insert into testfloat values(1,-0.1,0.1);
> Query OK, 1 row affected (0.00 sec)
> 
> check if values where inside
> 
> mysql> select * from testfloat;
> +--+--+--+
> | z| ll   | ul   |
> +--+--+--+
> |1 | -0.1 |  0.1 |
> +--+--+--+
> 1 row in set (0.01 sec)
> 
> 
> and now I wants to take a look on special rows..
> 
> mysql> select * from testfloat where ul=0.1;
> Empty set (0.00 sec)
> 
> 
> I didn't understand why I didn't get what I expect.
> 
> Best regards
> 
> Thorsten Guddack
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
[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: RPM or SourceCode ???

[Alok Daipuria]

If you read thru more about the reasons for recommendation for
installing thru RPM, you'll understand. Since the folks who built RPMs
have definitely spent lot of time building the RPMs which is optimized
for performance. I do trust them and commend their efforts.
  The source definitely gives you more options and flexibility. It's
entirely your choice.

cheers
-alok

Nilesh Parmar wrote:
> 
> Hi all
>  I was just getting thru the documentation of MySQL at the mysql.com
> site and there it is specified that
> "The recommended way to install MySQL on Linux is by using an RPM file"
> Can anyone tell me in what way it is different installing mysql from the
> rpm's and from the source code ??
> except that if we install from the source code it is a bit tedious where as
> with the rpm it is convineint. Are there any reasons other than this ??
> i for one feel that installing from the source gives us a lot of options and
> flexibility
> thanx in advance.
> cheers !!
> Nilesh Parmar
> [EMAIL PROTECTED]
> Wrox Press - Programmer to Programmer((tm))
> http://www.wrox.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: Let's approach stored procedures

[Cal Evans]

My $.02,

Stick with the ANSI standard. (ANSI99?) Do not try to implement either
PL/SQL or T/SQL. Please do not implement PERL (or Python) , Java, PHP or any
other procedural or OO language in stored procedures.  Speaking form
experience, all this does is blur the lines of that the database should do
and what the middle tier should do.

Whatever you do, do not adversely impact the speed at which MySQL runs.

Happy to Alpha/Beta test any patches you may create,

IMHO,
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Claudio Cicali" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 10:30
Subject: Let's approach stored procedures


>
> I think this is a little OT here, so after reading please
> indicate me where to talk about this subject.
>
> I'm a skilled programmer in C, C++ and others progr. lang.
> I have also a solid background in SQL and some RDMS
> (DB2, Oracle, SQLServer, and of course, Mysql).
>
> I'm going to attend a long period of holidays (finally) so,
> I thought: why don't try to implement stored procedures
> in mysql ?
>
> Now, on with the questions:
>
> I think that MySQL programmers had yet thinked on some
> way to implement sp, and I'd wish that someone say me:
> - "No, dude it's impossible/too hard"
> - "No, dude, we are in the way to finish that by ourselves"
> - "No, dude, we never insert big patches in our official
>distribution branch, that does not belong to us"
>
> Or, better, something more optimistic...
>
> I don't want to loose my time, in something that you
> know is impossible or too hard to get.
>
> Another question:
>
> At a first glance, I think Oracle PL/SQL is the best (afaik)
> programming language for sp, but, in the case we implement
> that language, should we go against some Oracle copytight
> infringment ?
>
> That's all, for now.
>
> database, 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

newbie:

[ricardo bravo]

Hi All,

where do I specify the remote hosts that are allowed to access port 3306? I 
have made entries in the user table of the mysql db, but still cannot conect 
from a remote machine. Thanks,

Ric.

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


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

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

Re: Slow replication question/problem

[Jeff Adams]

Jeremy Zawodny wrote:

< snip >

> 
> Are subsequent inserts just as slow to replicate?
> 
> Can you show us the output of SHOW SLAVE STATUS and maybe the my.cnf
> files of the master and a slow slave?
> 
> Jeremy
> 

Thanks for the response. Below is the info you requested. If there's 
anything else that might be of help, please let me know and I'll do my 
best to provide it.

I'm pretty sure most, if not all subsequent inserts are slow, although 
it might be true that if we did a number of inserts at the same time 
that they may inserted on the slaves together. We have not tried this at 
this point in time.

The slave status looks like:
---
| Master_Host | Master_User | Master_Port | Connect_retry | Log_File 
| Pos| Slave_Running | Replicate_do_db | Replicate_ignore_db | 
Last_errno | Last_error | Skip_counter |

| p23.hoovers.com | repl | 3306 | 60 | p23-bin.004 | 931831 | Yes 
| portlets | hoovers | 0 | | 0 |
---


The Master status gives:
---
| File| Position | Binlog_do_db | Binlog_ignore_db |
+-+--+--+--+
| p23-bin.004 | 1004808  | portlets | hoovers  |
---


The Master my.cnf (comments removed):
---[mysqld]
skip-locking
set-variable= key_buffer=384M
set-variable= max_allowed_packet=16M
set-variable= table_cache=512
set-variable= sort_buffer=6M
set-variable= record_buffer=1M
set-variable= myisam_sort_buffer_size=128M
set-variable= thread_cache_size=4
set-variable= thread_concurrency=4  # Try number of CPU's*2
set-variable= tmp_table_size=4M
set-variable= net_read_timeout=300
set-variable= net_write_timeout=300

# Replication
log-bin
server-id=1
binlog-do-db=portlets
binlog-ignore-db=hoovers


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

[mysql]
no-auto-rehash

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

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


Slave my.cnf (comments removed):
---
[mysqld]
skip-locking
set-variable= key_buffer=384M
set-variable= max_allowed_packet=16M
set-variable= table_cache=512
set-variable= sort_buffer=5M
set-variable= record_buffer=1M
set-variable= myisam_sort_buffer_size=128M
set-variable= thread_cache_size=4
set-variable= thread_concurrency=4  # Try number of CPU's*2
set-variable= tmp_table_size=3M
set-variable= net_read_timeout=300
set-variable= net_write_timeout=300
set-variable= max_connections=500
log-update

# Replication
master-host=p23.hoovers.com
master-user=repl
master-password=
master-port=3306
server-id=2
replicate-do-db=portlets
replicate-ignore-db=hoovers
log-slave-updates
log-bin

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

[mysql]
no-auto-rehash

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

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

Thanks again,

-  Jeff


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

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 Fulltextsearch

[Doug Poland]

On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote:
> Lorang Jacques ([EMAIL PROTECTED]) writes:
> 
> > Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
> > tables. As it is quiet some work, I first want to ask you guys if this 
> > is really going to make my queries faster (much faster ?)
> > 
> 
> Yup. I've got the entire set of laws for the State of Texas online. 
> My query time went down from 120 seconds to less than a second. 
> So, yes, it's really worth it.
>
Do the current limitations of 500 characters per index and limited (?)
number of columns per index pose problems?  I want to use fulltext
on a database with 7 varchar(255) columns and several smaller varchar
columns but can't build a fulltext index.  Is there documentation on
the limitations of fulltext?

-- 
Regards,
Doug

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

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

Re: Let's approach stored procedures

[Claudio Cicali]

At 10.44 07/09/2001 -0500, Ed Carp wrote:
>Claudio Cicali ([EMAIL PROTECTED]) writes:
>
> > At a first glance, I think Oracle PL/SQL is the best (afaik)
> > programming language for sp, but, in the case we implement
> > that language, should we go against some Oracle copytight
> > infringment ?
>
>Why would you want to do such a thing? Isn't SQL good enough? I'm just 
>trying to figure out your reasoning here, besides the same argument used 
>by the XML crowd of "it's the latest/greatest do-all-be-all-end-all, so 
>everyone should be using it" type of nonsense.

Nice question, overall.

Answers (partial list):

- it's cool
- where I work, we have a HUGE database-driven web-application. A lot of
   our businness logic is implemented via stored procedures, that
   act as black boxes for the web-designers.
   Think of enterprise java beans.
   They are not "nonsense" or such. They are usefull.
   (I know, you can use ejb with JDBS and mysql..., but if you want to have
   some logic incapsualted, you should use some kind of "component")
- sp extends the RDBMS itself in its functionality. Think about some stupid
   "check_fiscal_code()" or "insert_new_customer()".
   Web designers use the "insert_new_customer", instead of using SQL
   directly.

I think that there are others examples, but this is my point.




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

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

In the table Properties... What is Row_Format???

[Pablo Fraga]

What´s the diference between The row storage format (Fixed, Dynamic, or
Compressed) .

I'am experiencing problems with update statements which goes against a table
with the row_format property set to Fixed.

Thanks.

Pablo Fraga (MIS).
e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED]
icq: 113466029



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

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: Let's approach stored procedures

[Ed Carp]

Claudio Cicali ([EMAIL PROTECTED]) writes:

> At a first glance, I think Oracle PL/SQL is the best (afaik)
> programming language for sp, but, in the case we implement
> that language, should we go against some Oracle copytight
> infringment ?

Why would you want to do such a thing? Isn't SQL good enough? I'm just trying to 
figure out your reasoning here, besides the same argument used by the XML crowd of 
"it's the latest/greatest do-all-be-all-end-all, so everyone should be using it" type 
of nonsense.
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

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

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

Fw: command line open source ARRRGGGGGG!!!!!!

[Colm Brazel]

- Original Message -
From: "Colm Brazel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 4:33 PM
Subject: Re: command line open source ARRRGG!!


> > Open source software is written by technical people.  They do it because
> > they enjoy it.  Most of them don't get paid for it.
> >
> > Many technical people don't enjoy writing documentation at all, and
> > _very_ few enjoy writing documentation at the "complete newbie" level.
>
> Hi,
>
> The maxim should be that no one should mind a difficult concept well
> explained. But everybody should mind
> a simple concept made difficult because it is poorly explained. A poor
> explanation is one that is not intelligible
> by a newbie not because it is difficult, but because it is poorly
explained
> in  terms easily understood by a newbie.
>
> Colm
>
> Colm Brazel (MA)
> CB Publications
> www.cbweb.net
> [EMAIL PROTECTED]
>
>
>
> - Original Message -
> From: "Paul D. Smith" <[EMAIL PROTECTED]>
> To: "Chadrick Mahaffey" <[EMAIL PROTECTED]>
> Cc: "mysql" <[EMAIL PROTECTED]>
> Sent: Friday, September 07, 2001 2:50 PM
> Subject: Re: command line open source ARRRGG!!
>
>
> > %% Chadrick Mahaffey <[EMAIL PROTECTED]> writes:
> >
> >   cm> How do I start the server and create a database in plain English.
> I'm not
> >   cm> familiar with:
> >   cm> SECTION 4.16 - Documentation
> >
> >   shell> ./scripts/mysql_install_db
> >   shell> cd mysql_installation_directory
> >   shell> ./bin/safe_mysqld --user=mysql &
> >
> >   shell> cd mysql_installation_directory
> >   shell> ./bin/mysql_install_db
> >   shell> ./bin/safe_mysqld --user=mysql &
> >
> >   cm> what does all this mean?
> >
> > These are the commands and instructions for installing MySQL on a UNIX
> > box.  They are UNIX shell commands, not Windows DOS commands.
> >
> > You need to find the commands and instructions for installing MySQL on a
> > Windows box, if that's what you are using.
> >
> >   cm> Open source would go much farther if they had self explanatory
> >   cm> GUIs and had basic pre-setup apps that were ready for the average
> >   cm> user to use. I program in Java and I feel the same about the JDK
> >   cm> Sun produces. I use JCreator because it has an easy to follow GUI
> >   cm> interface. Most open source apps I have attempted to use have some
> >   cm> of the worse documentation around. The writers assume so much
> >   cm> about the users. OK - call me inept, stupid, or whatever but I had
> >   cm> to say it.
> >
> > Open source software is written by technical people.  They do it because
> > they enjoy it.  Most of them don't get paid for it.
> >
> > Many technical people don't enjoy writing documentation at all, and
> > _very_ few enjoy writing documentation at the "complete newbie" level.
> > If they don't enjoy it, they aren't going to do it for fun.  If someone
> > who _did_ enjoy it were to volunteer to help, well, that would be great.
> >
> > Further, you are working on a Windows platform.  Microsoft has, at
> > almost every turn, expressed its deep-seated hostility for Open Source
> > software of all kinds, and even the very idea of OS software.  Also,
> > many developers, esp. those doing OS software which has a very
> > UNIX-based ancestry, don't _like_ working on Windows, as they don't
> > think it's a good platform either to use or develop on.  So, naturally
> > enough you won't find all that many Open Source developers who are very
> > interested in expending a lot of effort to keep people who use Windows
> > happy.  They don't want to _encourage_ people to use an environment that
> > is so hostile to the things they like to do, and they don't like using
> > Windows themselves.  So, I doubt you'll see a big effort expended on the
> > part of OS developers to make the Windows-specific parts of their
> > software simpler.
> >
> > There are, obviously, some well-known exceptions like the
> > StarOffice/OpenOffice folks, Emacs, Apache, etc. who do spend a lot of
> > effort trying to get Windows versions easier to use and install.
> >
> >
> > If you wanted to buy a support license for MySQL, I'm sure they'd help
> > you get it installed properly.  If you want to use the free version and
> > you want to use it on Windows, then, for better or for worse, you're
> > going to have to get used to life on a second-tier platform :(.
> >
> > --
>
> --
> -
> >  Paul D. Smith <[EMAIL PROTECTED]> HASMAT--HA Software Mthds &
> Tools
> >  "Please remain calm...I may be mad, but I am a professional." --Mad
> Scientist
>
> --
> -
> >These are my opinions---Nortel Networks takes no responsibility for
> them.
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists

Re: Let's approach stored procedures

[Adams, Bill TQO]

Claudio Cicali wrote:

> I'm going to attend a long period of holidays (finally) so,
> I thought: why don't try to implement stored procedures
> in mysql ?
>

Someone did it with perl.
http://software.tangent.org/article.pl?sid=01/08/23/0817244&mode=thread&threshold=

> At a first glance, I think Oracle PL/SQL is the best (afaik)
> programming language for sp, but, in the case we implement



--Bill



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

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 Fulltextsearch

[Ed Carp]

Lorang Jacques ([EMAIL PROTECTED]) writes:

> Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
> tables. As it
> is quiet some work, I first want to ask you guys if this is really going to
> make my queries faster (much faster ?)

Yup. I've got the entire set of laws for the State of Texas online. My query time went 
down from 120 seconds to less than a second. So, yes, it's really worth it.
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

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

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

[Joshua M . Schmidlkofer]

On Friday 07 September 2001 06:11 am, you wrote:
> Giovanni Borri writes:
> > hi all,
> >
> > i have a question. i would like to know if mysql has a sql'x' standard.
> > my problem is that i would like to use UNION or MINUS or... but it seems
> > not to work, another problem is that i would like to make some nested
> > query.
> >
> > by
> > thanks in advance.
> >
> > Giovanni
>
> UNION's will come in 4.0, which will come this or next month. MINUS
> will come next year.


What about the nested queries?

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

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: Optimization question and possible bug

[Adams, Bill TQO]

Stefan Pinkert wrote:

> Examine that query with explain select... show that the indexes are not
> used. The keyfields are unsigned tiny int where every bit has a different
> meaning. Any clue how i can rewrite this query in a way where the indexes
> are
> used?

If MySQL thinks it will be faster to scan, it will.  Make sure you analyze
the tables with [my]isamchk -a.
If that does not help, please send the output from "SHOW INDEX FROM table"
and the EXPLAIN.


> In the database i have a merge-table that merges 10 myisam tables.
> Sometimes the loadaverage of the system raise above 50 and the
> long-query-log is
> filled with some query accessing the merge table. This happens 2-3 times a
> day.
> Only a minute later everthing is okay again without doing anything.
> I can't believe that it is a performance problem because there is a
> summary of only 10,000 entries in the merge table and 50,000 entries in
> other
> tables. Does anybody experienced this strange problem, too?

Is the long query different than the other queries? Have you done an expain
on it?


> The last thing i found is a possible bug in merge-table implementation
> of 2.23.41. After an update from 2.23.37 to 2.23.41 i got only the first
> row of the result set again and again. Maybe it's a communication problem
> between php (with included mysql interface) and the new MySQL version.
> (Haven't determined it yet).

Don't know.  But read this thread just to be sure:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:84077:200108:ilgknliamhblokdjmmhb

--Bill


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

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

Let's approach stored procedures

[Claudio Cicali]

I think this is a little OT here, so after reading please
indicate me where to talk about this subject.

I'm a skilled programmer in C, C++ and others progr. lang.
I have also a solid background in SQL and some RDMS
(DB2, Oracle, SQLServer, and of course, Mysql).

I'm going to attend a long period of holidays (finally) so,
I thought: why don't try to implement stored procedures
in mysql ?

Now, on with the questions:

I think that MySQL programmers had yet thinked on some
way to implement sp, and I'd wish that someone say me:
- "No, dude it's impossible/too hard"
- "No, dude, we are in the way to finish that by ourselves"
- "No, dude, we never insert big patches in our official
   distribution branch, that does not belong to us"

Or, better, something more optimistic...

I don't want to loose my time, in something that you
know is impossible or too hard to get.

Another question:

At a first glance, I think Oracle PL/SQL is the best (afaik)
programming language for sp, but, in the case we implement
that language, should we go against some Oracle copytight
infringment ?

That's all, for now.

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

Mysql Fulltextsearch

[Lorang Jacques]

Hello,

Actually I am programming an web directory (like yahoo). But my sql queries
need
ernormous cpu resources. So it is quiet slow. I can't use indexing because
my serach works with <>. (apparently then it dosen't
help).
Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
tables. As it
is quiet some work, I first want to ask you guys if this is really going to
make my queries faster (much faster ?)
Or perhaps you know any better solution ?
Lorang Jacques



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

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: command line open source ARRRGGGGGG!!!!!!

[Joshua M . Schmidlkofer]

I wanted to put in my 2 cents.   Access is not an RDBMS..   It is a single 
user - small user, and frequent fix  type system.  I have never worked on a 
real database system that does not have a command line interface.   It seems 
fearsome at first, but it's actually easy.   SQL Server do doubt has very 
nice GUI tools, but having used that DB a bit, [as a user] I am not very 
impressed.


>
> I know these are pathetic questions to most of you so please have patience
> with a Windows user...
> what is "shell>"?
> what is the "./"?
> is "mysql_installation_directory" supposed to be replaced with my
> installation dir?

On of the afore mentioned e-mails already answered most of this, but IU 
wanted to add some significance about the './' and why you need it and you 
DON'T need '.\' on a dos/windows systems.  

Any file in a unix environment can be marked executable.  That does not mean 
it will run but any file can.   Unix/Posix shells [you could related cmd.exe, 
or command.com to a shell]  rely on the PATH variable to tell them where to 
run programs from.  No Unix has './' [or the local directory] in the path, 
because it would present a small security risk when running programs, 
especially for the root user.   Hence, if you want to run a program from a 
specific location that is _not_ in the PATH, you need to type in the 
relative, or the full  path to the program.   In this case, change to the 
directory where you find the program, and type:
  './progname'

>
> I realize that I'm going to be in the minority here but I have to say it.
> Open source would go much farther if they had self explanatory GUIs and had
> basic pre-setup apps that were ready for the average user to use. I program
> in Java and I feel the same about the JDK Sun produces. I use JCreator
> because it has an easy to follow GUI interface. Most open source apps I
> have attempted to use have some of the worse documentation around. The
> writers assume so much about the users. OK - call me inept, stupid, or
> whatever but I had to say it.

I don't know what you've been using, but I have used a TON of open source, 
and most of it has good documentation.   Partly because most opensource 
programmers think that you might want to understand the underlying process 
that the computer is going through in order to complete your requests, run 
the program, etc.   Windows silently teaches you something else - using the 
pretty eye candy.   You are gently brought in and taught one way of thinking 
and relating to your computer.  But if you could step back and look at the 
skills necessary to run a GUI vs. use a command prompt , one is not actually 
more complicated than the other.  [And you lose a lot of flexibility with a 
GUI].   Save one problem, people tend towards visual things, it's natural, 
and so they seem to fear CLI more than GUI. 

Oh, and on a more personal note, most people who have huge issues with 
open-source apps don't completly RTFM.  They are impatient, frustrated and 
want all this stuff to work in 30 seconds otherwords is MUST be crap.  
However, 15 minutes of patient reading will often alleviate those issues. =P.

Hope you get this figured out to your comfort.  MySQL may take a little bit 
of extra effort to administrate, [esp. at first] but it is vastly superior to 
Access, and MUCH MUCH cheaper than SQL Server 7, or whatever.  Also, it 
boasts one HUGE advantage  over SQL server:   You are not tied to a single 
proprietary platform  =). 

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

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: COUNT elements in a LIMIT query

[Ian Barwick]

On Friday 07 September 2001 15:37, Torgil Zechel wrote:

> Is it possible to get the total number of records when doing a select with
> LIMIT?

No. As least, not in MySQL, unless I am missing something.

> For example, if I do:
>
>   SELECT * FROM tbl LIMIT 0,10
>
> I would like to get the total number of records in tbl along with the 10
> first ones..
>
> I need this to display "showing 0 - 10 of 354", and my query is much more
> complex so I dont wan't to make two queries:
>
>   SELECT COUNT(*) FROM tbl
>   SELECT * FROM tbl LIMIT 0,10

COUNT is an aggregate function which works on the result set returned. You 
can therefore select a number of rows to be displayed and count these, or 
select all rows in the table and count these, but not both at once.
(You can't have both your cake and eat it ;-)

If UNION was supported, you could do something like

  SELECT field1, field2, ... fieldx  LIMIT 0,10 
FROM tbl
   UNION
  SELECT count(*), '', ... ''<- provide x - 1 blank fields of the same
datatype as 'fieldn' in the first SELECT

which would provide you with the first 10 results as well as the total number
of rows. This is however a pretty messy way of doing things and I would stick 
with two SELECT statements.

BTW a simple COUNT(*) without a WHERE clause is optimized in MySQL.

HTH

Ian Barwick


-- 
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de

"To query tables in a MySQL database is more fun than eating spam"

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

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: Corrupted tables -- for 'no apparent' reason

[Adams, Bill TQO]

Mark Papadakis wrote:

> We are using mySQL on over 6 servers here, we have been doing so for over 2 years, 
>and we are constaly facing problems with corrupted tables, especially on two of our 
>busiest servers.
> Tables seem to corrupt out of the blue and we have to shut them down ( the servers ) 
>occassionaly to fix all tables and then bring them up again.

I have found that sometimes (esp. with older versions of MySQL which is not the case 
for you) that the only way to either repair or permanently repair a table is to 
dump/drop/reload the table and data.  I had some instances a number of years back 
where the table would
repair and be okay with isamchk but would, at a random time, be corrupted again.  
Doing the dump, etc. fixed the problem.

--Bill



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

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