A Beginner's Query

[LinuxTech Inc]

Hi All

Actually I am Oracle Prgrammer novice to mysql
We have installed Linux RH 6.2  in which we have installd mysql. Now he want me to 
create 3 tables 
in that. He has given me mysql> prompt. However I dont 
know how exactly to go further. When I issue a select 
statement it says you have to connect to database
Now I even dont know what are databases here and how
to create a new database.
I have downloaded the documentation  but doesnt show how to go ahead. if I say create 
table ... after it says 
query processed . But how to view the structure of the table. I mean I am not able to 
do anything  even after mysql> prompt appears. I have the documentation. Can Anyone 
guide me on this

Amol

_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.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

my.cnf problems

[MCA Department PESIT]

hi there,
 my data directory is /var/lib/mysql . i have created a .my.cnf file 
here. i have restarted mysql and now i am not sure whether the entries are 
being read from the cnf file. can you tell me how to confirm this ?? thanks 
in advance
bye
Mathew


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

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

SELECT and ORDER OPTIONS

[Ghetalion]

I figure since there are various ways to sort information in SQL, there must
be some way to sort the most frequent bit of information.  Example:

SELECT term FROM table ORDER BY mostfrequent(term)

And say you had this as the table

ID  TERM
1   a
2   a
3   f
4   z
5   a
6   i
7   i
8   z
9   z
10  a

It would return:

a
a
a
a
z
z
z
i
i
f

It there a fuction like that availble built into 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: Hello!Help.

[Mohamad Ilhami]

> >   First I gzip and tar the mysql-3.23.36-sun-solaris2.7-sparc.tar.A error
> > echoed "tar:directory checksum error."Then I goto the /mysql/bin/ and excute
> > ./configure,the prompt is configure not found.I don't know what is the
> > reason.I think maybe the tar of Solaris is not work in good way.How can I
> > install a GNU tar and how to use it?Can you tell me?Thank you.
You can dl GNU tar and gzip at www.sunfreeware.com

> >   Regards!
> > 
> > David
> > __
> > 
> > ===
> > ÂÀËÃâ·Ñµç¥ÓÓÊÏä (http://mail.sina.com.cn)
> > ÍøÀïÑ°Ëy´Ç§°Ù¶È!ûÓ"ÁÄÓÑËÙÅä",ÔõÄÜ"3ÉË«3ɶÔ"?
> > (http://newchat.sina.com.cn)
> > 
> > -
> > Before posting, please check:
> >  http://www.mysql.com/manual.php   (the manual)
> >  http://lists.mysql.com/   (the list archive)
> > 
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > 
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


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

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: Hello!Help.

[Quentin Bennett]

 




The information contained in this email is privileged 
and confidential and intended for the addressee only. If you are not the 
intended recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error you are asked 
to destroy this email and contact the sender immediately. Your assistance is 
appreciated.





Hi,

You need to use GNU tar - there is a link on the MySQL Download page for it.

Once you have got that, just use your 'gtar' instead of tar.

Quentin

-Original Message-
From: php_mysql [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 5 April 2001 3:34 p.m.
To: [EMAIL PROTECTED]
Subject: Hello!Help.


Hello!
How do you do!
I meet a problem when I install Mysql at Solaris 2.7 Sun SPARC.Please
help me.
First I gzip and tar the mysql-3.23.36-sun-solaris2.7-sparc.tar.A error
echoed "tar:directory checksum error."Then I goto the /mysql/bin/ and excute
./configure,the prompt is configure not found.I don't know what is the
reason.I think maybe the tar of Solaris is not work in good way.How can I
install a GNU tar and how to use it?Can you tell me?Thank you.
Regards!

David
__

===
ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn)
ÍøÀïÑ°Ëýǧ°Ù¶È!ûÓÐ"ÁÄÓÑËÙÅä",ÔõÄÜ"³ÉË«³É¶Ô"? (http://newchat.sina.com.cn)

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

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



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

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

Re: Hello!Help.

[Lindsay Adams]

I believe it states on the download page (or maybe it is on the mysql
download page, in any case, I have seen it a lot) that gzip is broken on
solaris and you MUST use gunzip? Just a guess. Don't know for sure. No
solaris to play with :|




On 4/4/01 8:33 PM, "php_mysql" <[EMAIL PROTECTED]> wrote:

>   Hello!
>   How do you do!
>   I meet a problem when I install Mysql at Solaris 2.7 Sun SPARC.Please help
> me.
>   First I gzip and tar the mysql-3.23.36-sun-solaris2.7-sparc.tar.A error
> echoed "tar:directory checksum error."Then I goto the /mysql/bin/ and excute
> ./configure,the prompt is configure not found.I don't know what is the
> reason.I think maybe the tar of Solaris is not work in good way.How can I
> install a GNU tar and how to use it?Can you tell me?Thank you.
>   Regards!
> 
> David
> __
> 
> ===
> ÂÀËÃâ·Ñµç¥ÓÓÊÏä (http://mail.sina.com.cn)
> ÍøÀïÑ°Ëy´Ç§°Ù¶È!ûÓ"ÁÄÓÑËÙÅä",ÔõÄÜ"3ÉË«3ɶÔ"?
> (http://newchat.sina.com.cn)
> 
> -
> Before posting, please check:
>  http://www.mysql.com/manual.php   (the manual)
>  http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


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

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

REPOST: SELECT syntax

[Ashley M. Kirchner]

Db -> table1, table2 and table3

SELECT table1.task, table2.comment, table2.remarks, table3.history
  FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid
  LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10;

Results (roughly) in:

+--++--+-+
|   task   |  comment   |remarks   |   history   |
+--++--+-+
|  task_1  |   cmt_1| rmk_1| |
|  task_1  |   cmt_2|  | |
|  task_1  |   cmt_3|  |hst_1|
|  task_1  |   cmt_4| rmk_2| |
|  task_1  |   cmt_5|  |hst_2|
|  task_1  |   cmt_6|  | |
+--++--+-+

However, what I'd really like to have is the following:

+--++--+-+
|   task   |  comment   |remarks   |   history   |
+--++--+-+
|  task_1  | 6  |   2  |  2  |
+--++--+-+

How do I change the select clause to have COUNT() in it instead?

AMK4

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

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

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

Re: Limit

[Dan Nelson]

In the last episode (Apr 05), [EMAIL PROTECTED] said:
> > On Wed, Apr 04, 2001 at 05:35:52PM -0600, Mat Murdock wrote:
> > >If I understand the manual correctly when I do a  "select blah
> > >from blah where blah = blah order by blah limit 10" Mysql
> > >finds the first 10 matching records and then sorts those
> > >records.  How do I have it first sort the database and then
> > >take the first 10 records?
> > 
> > LIMIT is applied after sorting.  It does what you want already.
> 
> As a matter of interest, if I have 10 million rows and specify :
> 
> "select * from Table order by epoch limit 10;"
> 
> Will all 10 million rows be sorted and the first 10 taken, or will
> the sort be "truncated" so that only the matching 10 rows are
> maitained during the trawl through the table?

Depends on whether you've got a key on epoch or not.  If not, I believe
mysql has to sort the whole thing.  I just did a test on a 1-million
record table, and it took 20 seconds to do a select on an unindexed
table, and 40 seconds to do an order by limit 10.  A "top-n" sort would
have taken around 20 seconds as well.  There are loads of little
optimizations like this can could be added to mysql; most of them only
apply to special cases and might not be worth the effort to code
(unless you buy a support contract. :)

If you do have an index, mysql is smart enough to just pull the first
10 records based on the index.

-- 
Dan Nelson
[EMAIL PROTECTED]

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

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

Hello!Help.

[php_mysql]

Hello!
How do you do!
I meet a problem when I install Mysql at Solaris 2.7 Sun SPARC.Please help me.
First I gzip and tar the mysql-3.23.36-sun-solaris2.7-sparc.tar.A error echoed 
"tar:directory checksum error."Then I goto the /mysql/bin/ and excute ./configure,the 
prompt is configure not found.I don't know what is the reason.I think maybe the tar of 
Solaris is not work in good way.How can I install a GNU tar and how to use it?Can you 
tell me?Thank you.
Regards!

David
__

===
ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn)
ÍøÀïÑ°Ëýǧ°Ù¶È!ûÓÐ"ÁÄÓÑËÙÅä",ÔõÄÜ"³ÉË«³É¶Ô"? (http://newchat.sina.com.cn)

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

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

Re: history file

[Taing Nguon]

> Does anyone know why no matter what user I log into my database undr, the
> only history file that is being written to is root's :
>
> /root/.mysql_history
>
> Why is a history file not created in the users home directory?

Mysql' user account is not related to user's account on Linux System.Which
Linux User's account you use to log in to Mysql that Linux User's account
keeps informations that you have done.

Taing Nguon




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

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: Math calculations

[Steve Werby]

"MikeBlezien" <[EMAIL PROTECTED]> wrote:
> ROUND((tally / votes),2) AS Rating
>
> which I believe should give me 4...correct?? or would it better to do the
> calculations within the script after extracting the column data ??

I think that you'll find that it is faster to do the calculation within
MySQL.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.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: Storing pictures in mySQL

[Taing Nguon]

>I would rather store the files on disk and the filenames in the database
for more speed.

>I'm a developer on a website which members have an uploaded image of
theirself..
>We just have a image directory with filenames as [username].jpg
>This dir is therefore easily mapped to the web with an Alias directive in
the Apache config.

I am not sure what you explained. You mean that place PATH/filename.jpg to
picture field. isn't it? If yes, it is just a text. How can we explore that
picture thru web browser such as IE or Netscape? Thanks for the answer

Regards

Taing Nguon





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

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

[Dan Nelson]

In the last episode (Apr 04), Mat Murdock said:
>If I understand the manual correctly when I do a  "select blah
>from blah where blah = blah order by blah limit 10" Mysql finds
>the first 10 matching records and then sorts those records.  How
>do I have it first sort the database and then take the first 10
>records?

It does that already.  In general, you can think of each SQL phrase
being applied to the resultset in order.  WHERE gets run, then GROUP
BY, then ORDER BY, then HAVING, then LIMIT (which explains why you
can't put a count() clause in WHERE, because the database doesn't even
know the count until the GROUP BY stage).

-- 
Dan Nelson
[EMAIL PROTECTED]

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

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

Mysql++

[Kevin Pratt]

I am having a problem installing mysql++ on a freebsd 4.2 install.. I am
wondering if there is anyone who has got it to work?  thanks


Kevin

ps if I am in the wrong place please tell me where I should be. :)


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

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

[hooker]

> On Wed, Apr 04, 2001 at 05:35:52PM -0600, Mat Murdock wrote:
> >If I understand the manual correctly when I do a  "select blah from blah where 
>blah = blah order by blah limit 10"  Mysql finds the first 10 matching records and 
>then sorts those records.  How do I have it first sort the database and then take the 
>first 10 records?
> > 
> 
> LIMIT is applied after sorting.  It does what you want already.

As a matter of interest, if I have 10 million rows and specify :

"select * from Table order by epoch limit 10;"

Will all 10 million rows be sorted and the first 10 taken, or will
the sort be "truncated" so that only the matching 10 rows are
maitained during the trawl through the table?

Paul Wilson
iiNet Ltd

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

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

Re: Help with ODBC

[Luis]

Gary Huntress wrote:

> I had a similar problem after I installed a driver set, I don't think it was
> the MyODBC drivers, but the outcome was the same, a very generic windows
> error that was not even associated with an attempted connection.
>
> I had to reinstall the Microsoft MDAC components, available here
> http://www.microsoft.com/data/download.htm#26info
>
> Once I did that I could connect, I didn't even have to reinstall the MyODBC
> driver.
>
> Good Luck
>
> Gary "SuperID" Huntress
> ===
> FreeSQL.org offering free database hosting to developers
> Visit http://www.freesql.org
>
> - Original Message -
> From: "Luis" <[EMAIL PROTECTED]>
> To: "Steve Ruby" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, April 04, 2001 9:59 PM
> Subject: Help with ODBC
>
> > Thank you for all the help on MyODBC  but I can't connect to mysql server
> > threw access.
> >
> > Here are the steps on how I start.
> >
> > 1. I download the MyODBC setup file for windows. I ran the setup
> everything
> > went fine.
> > 2. Then I went in to my control panel > double click on ODBC Data
> > 3. ODBC Data open , I see seven options User DSN, System DSN, File DNS,
> > Drivers, Tracing Connection Pooling, Abaout
> > 4. I add in the User DSN "agentinfo" --- agentinfo is a database also in
> mysql
> > server.
> > 5. When i added i got other window that had alot of fields to fill in .,
> >
> > A. Windows DSN name :   agentinfo
> > B. Mysql Host :   192.168.2.146 --- that's the
> ip
> > address were i have mysql running.
> > C. Mysql database name:   agentinfo---name of
> > database on mysql.
> > D. user name : root  thats what i
> use
> > when running mysql or adding databases.
> > E. password ghost password
> to
> > log into mysql server.
> > F. port (if not 3306)3306  that's what is
> says
> > it running on in my /etc/services file
> >
> > after that i say ok . I also added a entry into Data Source files.  were
> it
> > asked me the same question as above.
> > I click ok then i get this error message.
> >
> > "General error: Invalid file dsn 'C:\Program files\Command Files\ODBC\Data
> > Source\agentinfo.dsn"
> >
> > I dont know what this is .
> >
> > Just wondering what I'm doing wrong. or if someone could show me the right
> > steps on loading it configure the ODBC date
> > plus how to connect threw access.
> >
> > Thank you
> >
> > Luis
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >

thank you gary for the link i installed it . went back to control panel - ODBC
went to the "File DSN" option added

server1

filled out all the fields once again,  then i said ok

but this time i got this message

" A connection could not be made using the file data source parameters entered
. Save not-verified file DSN?"

So can you please tell me what i'm doing wrong


bye luis


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

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

Re: Help with ODBC

[Gary Huntress]

I had a similar problem after I installed a driver set, I don't think it was
the MyODBC drivers, but the outcome was the same, a very generic windows
error that was not even associated with an attempted connection.

I had to reinstall the Microsoft MDAC components, available here
http://www.microsoft.com/data/download.htm#26info

Once I did that I could connect, I didn't even have to reinstall the MyODBC
driver.

Good Luck

Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org




- Original Message -
From: "Luis" <[EMAIL PROTECTED]>
To: "Steve Ruby" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 9:59 PM
Subject: Help with ODBC


> Thank you for all the help on MyODBC  but I can't connect to mysql server
> threw access.
>
> Here are the steps on how I start.
>
> 1. I download the MyODBC setup file for windows. I ran the setup
everything
> went fine.
> 2. Then I went in to my control panel > double click on ODBC Data
> 3. ODBC Data open , I see seven options User DSN, System DSN, File DNS,
> Drivers, Tracing Connection Pooling, Abaout
> 4. I add in the User DSN "agentinfo" --- agentinfo is a database also in
mysql
> server.
> 5. When i added i got other window that had alot of fields to fill in .,
>
> A. Windows DSN name :   agentinfo
> B. Mysql Host :   192.168.2.146 --- that's the
ip
> address were i have mysql running.
> C. Mysql database name:   agentinfo---name of
> database on mysql.
> D. user name : root  thats what i
use
> when running mysql or adding databases.
> E. password ghost password
to
> log into mysql server.
> F. port (if not 3306)3306  that's what is
says
> it running on in my /etc/services file
>
> after that i say ok . I also added a entry into Data Source files.  were
it
> asked me the same question as above.
> I click ok then i get this error message.
>
> "General error: Invalid file dsn 'C:\Program files\Command Files\ODBC\Data
> Source\agentinfo.dsn"
>
> I dont know what this is .
>
> Just wondering what I'm doing wrong. or if someone could show me the right
> steps on loading it configure the ODBC date
> plus how to connect threw access.
>
> Thank you
>
> Luis
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

Support

[Andres Melai]

Remite:  Guillermo Guzman Ramirez
Ibague - Colombia - Sur America

Would you please help to repair/Corrige an error that
occured with mySQL and Delphi;
The error is like this ; error   127  from table
handler

We noticed that the table, which we do SELECT is out
of order and I named the original 
table and I have created a new one and works okey.

How can I repair the table, that is out of order? 
Please inform, from where can I download the command
myisamchk?
I haven´t found it.
Thank you in advance for your help.
Best regards.


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/

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

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

Re: Help with ODBC

[Gary Huntress]

- Original Message -
From: "Luis" <[EMAIL PROTECTED]>
To: "Steve Ruby" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 9:59 PM
Subject: Help with ODBC


> Thank you for all the help on MyODBC  but I can't connect to mysql server
> threw access.
>
> Here are the steps on how I start.
>
> 1. I download the MyODBC setup file for windows. I ran the setup
everything
> went fine.
> 2. Then I went in to my control panel > double click on ODBC Data
> 3. ODBC Data open , I see seven options User DSN, System DSN, File DNS,
> Drivers, Tracing Connection Pooling, Abaout
> 4. I add in the User DSN "agentinfo" --- agentinfo is a database also in
mysql
> server.
> 5. When i added i got other window that had alot of fields to fill in .,
>
> A. Windows DSN name :   agentinfo
> B. Mysql Host :   192.168.2.146 --- that's the
ip
> address were i have mysql running.
> C. Mysql database name:   agentinfo---name of
> database on mysql.
> D. user name : root  thats what i
use
> when running mysql or adding databases.
> E. password ghost password
to
> log into mysql server.
> F. port (if not 3306)3306  that's what is
says
> it running on in my /etc/services file
>
> after that i say ok . I also added a entry into Data Source files.  were
it
> asked me the same question as above.
> I click ok then i get this error message.
>
> "General error: Invalid file dsn 'C:\Program files\Command Files\ODBC\Data
> Source\agentinfo.dsn"
>
> I dont know what this is .
>
> Just wondering what I'm doing wrong. or if someone could show me the right
> steps on loading it configure the ODBC date
> plus how to connect threw access.
>
> Thank you
>
> Luis
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Limit

[Jeremy Zawodny]

On Wed, Apr 04, 2001 at 05:35:52PM -0600, Mat Murdock wrote:
>
>If I understand the manual correctly when I do a "select blah
>from blah where blah = blah order by blah limit 10" Mysql finds
>the first 10 matching records and then sorts those records.  How
>do I have it first sort the database and then take the first 10
>records?

Just like with any other query, use an ORDER BY clause. LIMIT does not
change this.

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

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

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

Access throw ODBC to MySQL strange behevior

[Arsen Kirillov]

I try to connect to MySQL database throw ODBC .
All i Ok except ... when i'am trying to add new
record in the form of access (linked) table i got
that record is deleted immidiatly after i hit Enter ...
All begins when i try to set one of fields as AUTO_INCREMENT and UNIQUE :

ALTER TABLE upd DROP INDEX upd_id;
ALTER TABLE upd MODIFY upd_id MEDIUMINT;
ALTER IGNORE TABLE upd ADDUNIQUE upd_id(upd_id);

When i have no indexed field - all was all-right but i want
to add new records to MySQL database , and not to see on value of index
field -
last one must be AUTO incremented when i do this !
Can your tell me is this problem of MyODBC of of microSOft_DeVeLoPmEnTs.

How can your help me to do this ... or there is no way to work this way with
MySQL.

PS.I use ACCESS 2000 & latest MyODBC.


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

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

[Paul DuBois]

On Wed, Apr 04, 2001 at 05:35:52PM -0600, Mat Murdock wrote:
>If I understand the manual correctly when I do a  "select blah from blah where 
>blah = blah order by blah limit 10"  Mysql finds the first 10 matching records and 
>then sorts those records.  How do I have it first sort the database and then take the 
>first 10 records?
> 

LIMIT is applied after sorting.  It does what you want already.

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

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: Problems with Mysql on Sol7 i386

[Quentin Bennett]

Hi Matt,

Probably worth checking the archives for 'restartable' - there are a few
messages there.

Quentin

-Original Message-
From: Matt Mueller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 5 April 2001 9:53 a.m.
To: [EMAIL PROTECTED]
Subject: Problems with Mysql on Sol7 i386


Hello,

I am trying to install mysql version 3.23.26 on my sun machine running
solaris 7.  I have installed gnu make, tar, and gcc-version 2.95.2.  I
have also tried doing everything that is reccomended for my error 
such as editing config.cache and even using the reccomended configure
line.  The error I am getting is:

checking for restartable system calls... configure: error can not
run test programs while cross compiling

Has anyone run into this problem even after updating thier systems?

Thanks for the help,

Matthew Mueller


Matthew Mueller
Space Science and Engineering Center
University of Wisconsin-Madison
Phone: 608.263.8185


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

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

The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.

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

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

Math calculations

[MikeBlezien]

Hi all,

We are modifying one of our db  tables to include two fields, 'votes' and
'tally' for allowing to display a "rating" system. The 'votes' column will be a
running total of all votes, the 'tally' will be a column to hold the 'votes'
values. Example, if a person submits a vote of 3(with a range of 1-5), then we
would enter 1 in the 'votes' column and 3 in the 'tally' column. Another person
comes along and votes, they submit a 4. Now we have 2 in the 'votes' column and
7 in the 'tally' column, another person comes along and votes a 4, now we have 3
in the 'votes' and 11 in the 'tally'... and so on.

In the table columns:

votes  tally
*-|--*
  3 11
*-|--*

Now we want to display our rating. What I need to do is take the tally divide it
by the number of votes = 3.67 Now can we do this with a SQL query in MySQL and
have it work, something like this:

ROUND((tally / votes),2) AS Rating 

which I believe should give me 4...correct?? or would it better to do the
calculations within the script after extracting the column data ??


Mike(mickalo)Blezien

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















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

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

Help with ODBC

[Luis]

Thank you for all the help on MyODBC  but I can't connect to mysql server
threw access.

Here are the steps on how I start.

1. I download the MyODBC setup file for windows. I ran the setup everything
went fine.
2. Then I went in to my control panel > double click on ODBC Data
3. ODBC Data open , I see seven options User DSN, System DSN, File DNS,
Drivers, Tracing Connection Pooling, Abaout
4. I add in the User DSN "agentinfo" --- agentinfo is a database also in mysql
server.
5. When i added i got other window that had alot of fields to fill in .,

A. Windows DSN name :   agentinfo
B. Mysql Host :   192.168.2.146 --- that's the ip
address were i have mysql running.
C. Mysql database name:   agentinfo---name of
database on mysql.
D. user name : root  thats what i use
when running mysql or adding databases.
E. password ghost password to
log into mysql server.
F. port (if not 3306)3306  that's what is says
it running on in my /etc/services file

after that i say ok . I also added a entry into Data Source files.  were it
asked me the same question as above.
I click ok then i get this error message.

"General error: Invalid file dsn 'C:\Program files\Command Files\ODBC\Data
Source\agentinfo.dsn"

I dont know what this is .

Just wondering what I'm doing wrong. or if someone could show me the right
steps on loading it configure the ODBC date
plus how to connect threw access.

Thank you

Luis


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

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: beggin, commit, and rollback

[Miguel Angel Solórzano]

At 14:52 4/4/2001 -0700, Kristopher Briscoe wrote:
Hi,
See the sample below:

C:\mysql\bin>mysql test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 3.23.36

Type 'help;' or '\h' for help. Type '\c' to clear the buffer

mysql> create table host_info (hostname char(50)) type=innobase;
Query OK, 0 rows affected (0.05 sec)

mysql> insert into host_info values ("Kris");
Query OK, 1 row affected (0.05 sec)

mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from host_info;
+--+
| hostname |
+--+
| Kris |
+--+
1 row in set (0.00 sec)

mysql> delete from host_info where hostname="Kris";
Query OK, 1 row affected (0.00 sec)

mysql> select * from host_info;
Empty set (0.00 sec)

mysql> rollback;
Query OK, 0 rows affected (0.03 sec)

mysql> select * from host_info;
+--+
| hostname |
+--+
| Kris |
+--+
1 row in set (0.00 sec)

mysql>

Regards,
Miguel

>Sorry if this is mundane for some, but I have searched the manual and I 
>cannot find the answer to itTwo issues here
>.
>
>1)
>Doesn't mysql support begin and rollback transactions?  If so what is the 
>correct procedure to make it happen.  I logged in and ran my query..
>
>>select * from host_info;
>
>saw what I expected.  Then I did a begin statement
>>begin;
>
>then I entered a delete statment
>>delete from host_info where hostname='kris';
>
>then did a select
>>select * from host_info where hostname='kris';
>
>my row had disappeared.  Then I tried to implement a rollback.
>>rollback;
>
>all returned a success, but when I ran my query again the data was still 
>gone.  This is probably something simple that I am missing.  Any help is 
>greatly appreaciated.
>
>
>2) Where can I find refernce to setting up and using joins?
>
>Thanks,
>Kris-
>_
>Get your FREE download of MSN Explorer at http://explorer.msn.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
>

__  ___   __
   /  |/  /_ __/ __/ __ \/ /   http://www.mysql.com/
  / /|_/ / // /\ \/ /_/ / /__  Miguel Solórzano <[EMAIL PROTECTED]>
/_/  /_/\_, /___/\___\_\___/  São Paulo, Brazil
<___/  Development Team


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

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

Temporary tables and 'does not exist'

[Daniel Cher]

Using PHP and MySQL 3.23, I create a temporary table. Then, in the same
page, I join the temporary table to another query. 
 
Most of the time it works. On about 10% of tries, however, I get an error
'temptable does not exist.'
 
Any help appreciated.
 
Daniel
--
Daniel Cher, MD
Product Manager
CareThere
635 Clyde Avenue
Mountain View, CA 94043
Tel 650-237-3936
Mob 650-269-4604
FAX 650-625-9133
[EMAIL PROTECTED]
 

Re: Security Mysql

[Danny]

Look very carefully at the mysql database by typing in
mysql -u root -p mysql 

Look at the manunal for how you can INSERT INTO the user table or how you can
use GRANT





On Thu, 05 Apr 2001, J.Heegsma wrote:
> >%_Dear Sir/Madam,
> 
> I am a student and my teacher want's to try to break in into my mysql-database. I 
>won't give him a change. I know Mysql have serveral options for security and 
>encryption. But I do not know, how I can use them and which one I can use the best. 
>Could you help me? The mysql database will be accessed by the internet with the php 
>language. Information from the database has to be published on the website and 
>information has to be put again into the databae by a form.
> 
> Please send all the information you can give me about mysql security and encryption 
>possiblities to: [EMAIL PROTECTED]
> 
> Thank you very much.
> 
> Greetings from a dutch student,
> 
> J.Heegsma
> 

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

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: beggin, commit, and rollback

[Gary Huntress]

The MySQL manual is one of the best I've seen

1)
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html
#Commit-rollback

2)
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOI
N


Regards,

Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org



- Original Message -
From: "Kristopher Briscoe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 5:52 PM
Subject: beggin, commit, and rollback


> Sorry if this is mundane for some, but I have searched the manual and I
> cannot find the answer to itTwo issues here
> .
>
> 1)
> Doesn't mysql support begin and rollback transactions?  If so what is the
> correct procedure to make it happen.  I logged in and ran my query..
>
> >select * from host_info;
>
> saw what I expected.  Then I did a begin statement
> >begin;
>
> then I entered a delete statment
> >delete from host_info where hostname='kris';
>
> then did a select
> >select * from host_info where hostname='kris';
>
> my row had disappeared.  Then I tried to implement a rollback.
> >rollback;
>
> all returned a success, but when I ran my query again the data was still
> gone.  This is probably something simple that I am missing.  Any help is
> greatly appreaciated.
>
>
> 2) Where can I find refernce to setting up and using joins?
>
> Thanks,
> Kris-
> _
> Get your FREE download of MSN Explorer at http://explorer.msn.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

Limit

[Mat Murdock]

   If I understand the manual correctly when I do a  "select blah from blah where blah 
= blah order by blah limit 10"  Mysql finds the first 10 matching records and then 
sorts those records.  How do I have it first sort the database and then take the first 
10 records?

Thanks for your help,

Mat

Your mouse has moved. Windows must be restarted for the change to take
effect. Reboot now? [ OK ] 

Re: beggin, commit, and rollback

[Jeremy Zawodny]

On Wed, Apr 04, 2001 at 02:52:39PM -0700, Kristopher Briscoe wrote:
> 
> Doesn't mysql support begin and rollback transactions?  If so what
> is the correct procedure to make it happen.  I logged in and ran my
> query..

Depends on the table type. Check the manual for details on the
different table types.
-- 
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878Fax: (408) 530-5454
Cell: (408) 439-9951

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

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

Math calculations

[MikeBlezien]

Hi all,

We are modifying one of our db  tables to include two fields, 'votes' and
'tally' for allowing to display a "rating" system. The 'votes' column will be a
running total of all votes, the 'tally' will be a column to hold the 'votes'
values. Example, if a person submits a vote of 3(with a range of 1-5), then we
would enter 1 in the 'votes' column and 3 in the 'tally' column. Another person
comes along and votes, they submit a 4. Now we have 2 in the 'votes' column and
7 in the 'tally' column, another person comes along and votes a 4, now we have 3
in the 'votes' and 11 in the 'tally'... and so on.

In the table columns:

votes  tally
*-|--*
  3 11
*-|--*

Now we want to display our rating. What I need to do is take the tally divide it
by the number of votes = 3.67 Now can we do this with a SQL query in MySQL and
have it work, something like this:

ROUND((tally / votes),2) AS Rating 

which I believe should give me 4...correct?? or would it better to do the
calculations within the script after extracting the column data ??


Mike(mickalo)Blezien

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















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

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

Question about Open Source DB's

[Bryan Wheelock]

I was just wondering, I've been using MySQL and while still a beginner,
quite like it.
As MySQL is an db engine, how readily would my skills be translatable to
PostgeSQL.
I have a friend asking me to work on a project with him and he wants to use
PostgeSQL and PHP.

>From what I've seen the the structure of the SELECTS and INSERT's will be
essentially the same but with with different function.
This may just be an incredible niave question, but how easy is it to be able
to switch from mysql to postgres?


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

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

show logs

[Gustavo Vieira Goncalves Coelho Rios]

have anybody already faced a mysql crashed connection after a 'show
logs' query?

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

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

Problems with Mysql on Sol7 i386

[Matt Mueller]

Hello,

I am trying to install mysql version 3.23.26 on my sun machine running
solaris 7.  I have installed gnu make, tar, and gcc-version 2.95.2.  I
have also tried doing everything that is reccomended for my error 
such as editing config.cache and even using the reccomended configure
line.  The error I am getting is:

checking for restartable system calls... configure: error can not
run test programs while cross compiling

Has anyone run into this problem even after updating thier systems?

Thanks for the help,

Matthew Mueller


Matthew Mueller
Space Science and Engineering Center
University of Wisconsin-Madison
Phone: 608.263.8185


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

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

beggin, commit, and rollback

[Kristopher Briscoe]

Sorry if this is mundane for some, but I have searched the manual and I 
cannot find the answer to itTwo issues here
.

1)
Doesn't mysql support begin and rollback transactions?  If so what is the 
correct procedure to make it happen.  I logged in and ran my query..

>select * from host_info;

saw what I expected.  Then I did a begin statement
>begin;

then I entered a delete statment
>delete from host_info where hostname='kris';

then did a select
>select * from host_info where hostname='kris';

my row had disappeared.  Then I tried to implement a rollback.
>rollback;

all returned a success, but when I ran my query again the data was still 
gone.  This is probably something simple that I am missing.  Any help is 
greatly appreaciated.


2) Where can I find refernce to setting up and using joins?

Thanks,
Kris-
_
Get your FREE download of MSN Explorer at http://explorer.msn.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-MySql DBD Errors

[B. van Ouwerkerk]

>Msql-Mysql-modules-1.2215.tar.  For the life of me I can't find the
>mysql.h file that it keeps asking for?  Any ideas where this is...is it
>a bug with this version.

Type find -name mysql.h
I found mine (MySQL 3.23.36) in /usr/local/mysql/include

Sometimes it helps to use a very basic method to search your system.

Bye,


B.


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

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-MySql DBD Errors

[Ravi Raman]

hi.

don't know how much light this will shed on your situation, but mysql.h is
in the include directory under the directory where you installed mysql.
(i.e /opt/mysql/include or /usr/local/mysql/include)

hth. hand.

-ravi

-Original Message-
From: Eric Fegraus [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 3:24 PM
To: [EMAIL PROTECTED]
Subject: Perl-MySql DBD Errors



Hello,

I have redhat 7.0 with Mysql Ver 8.8 Distrib 3.23.22-beta.  This was the
Mysql version that came on the redhat cd's.  Perl and the Perl DBI are
installed and working correctly.  MySql seems to be working correctly as
well(i.e. no problems with permissions, created db's, tables, etc).
However, I can't install the mysql::DBD...I grabbed this from the Mysql
site,
Msql-Mysql-modules-1.2215.tar.  For the life of me I can't find the
mysql.h file that it keeps asking for?  Any ideas where this is...is it
a bug with this version.

Thanks in advance!

Eric



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

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: field separator

[Dan Nelson]

In the last episode (Apr 04), John Smith said:
> I've searched manyh places and can't get a good answer .. i hope I can get 
> help here.
> 
> I'm trying to dump all the data in my database to separate files (per table) 
> and be able to specify a field separator character.
> 
> for example, I'd like to use || as my field separator, I did the following:
> 
> >mysqldump -u root -p --tab --fields-enclosed-by='||' --no-create-info  myDB 
> > > output_file.txt
> 
> I get the folowing error:
> mysqldump: Got error: 1: Can't create/write to file 
> '/home/website/--fields-enclosed-by=||/alloc.txt' (Errcode: 2)

--tab takes an argument.

-- 
Dan Nelson
[EMAIL PROTECTED]

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

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

Re: Perl-MySql DBD Errors

[Peter Skipworth]

Eric,

Download the source tarball for mysql from the website and reinstall
using that - the necessary
include files do not come with the redhat rpm.

regads,

P


On Wed, 4 Apr 2001, Eric Fegraus wrote:

> 
> Hello,
> 
> I have redhat 7.0 with Mysql Ver 8.8 Distrib 3.23.22-beta.  This was the
> Mysql version that came on the redhat cd's.  Perl and the Perl DBI are
> installed and working correctly.  MySql seems to be working correctly as
> well(i.e. no problems with permissions, created db's, tables, etc).
> However, I can't install the mysql::DBD...I grabbed this from the Mysql
> site,
> Msql-Mysql-modules-1.2215.tar.  For the life of me I can't find the
> mysql.h file that it keeps asking for?  Any ideas where this is...is it
> a bug with this version.  
> 
> Thanks in advance!
> 
> Eric
> 
> 
> 
> -Original Message-
> From: Gerald Clark [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 04, 2001 10:23 AM
> To: Chris Becker
> Cc: [EMAIL PROTECTED]
> Subject: Re: Perl - DBD:DBI Errors
> 
> 
> Chris Becker wrote:
> > 
> > I checked my RH6.2 install cd's and found zlib-1.1.3-6.src.rpm, I went
> to
> > install the package with the following command and get the following
> error:
> > 
> > >rpm -ivh zlib-1.1.3-6.src.rpm
> > Unable to open /usr/lib/rpm/rpmrc for reading: No such file or
> directory.
> > 
> > When I originally installed the os I selected a custom install and
> checked
> > every option provided.  Why can I not use the rpm utility?  Do I need
> to
> > install that?  I have an rpm entry in the man pages???  I am logged in
> as
> > root.
> > 
> > Please help, and...
> > 
> > Thanks Again,
> > ChrisB
> > 
> > -Original Message-
> > From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On
> > Behalf Of Gerald Clark
> > Sent: Wednesday, March 28, 2001 9:26 AM
> > To: Chris Becker
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: Perl - DBD:DBI Errors
> > 
> > You don't have zlib on your machine.
> > Check your 6.2 CD.
> > 
> > Chris Becker wrote:
> > >
> > > I'm having trouble installing the perl module DBD specifically.  I
> found
> > on
> > > my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to
> install it
> > and
> > > got errors, I discovered I needed DBI installed first.  So I found
> > DBI-1.13
> > > and did the following:
> > >
> > > perl Makefile.PL
> > > make
> > > make test
> > >
> > > Made 100 connections in 0 wallclock secs...
> > > test.pl done
> > >
> > > DBI seemed to install ok.  Then I found DBD
> Msql-Mysql-modules-1.2210 and
> > > did the following:
> > > perl Makefile.PL
> > > select 1) MySQL only
> > > n - for install perl emulation
> > > then
> > > make
> > > make test
> > >
> > > then get output from make test:
> > > ...install_driver(mysql) failed: Can't load
> > > '../blib/arch/auto/DBD/mysql/mysql.so' for  module DBD::mysql:
> > > ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress
> at
> > > /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169.
> > > at (eval 1) line 3
> > > at t/00base.t line 38
> > > dubious
> > >  Test returned status 255 (wstat 65280, 0xff00)
> > > Undefined subroutine &Test::Harness::WCOREDUMP called at
> > > /usr/lib/perl5/5.00503/
> > > Test/Harness.pm line 288.
> > > make[1]: *** [test_dynamic] Error 255
> > > make[1]: Leaving directory
> '/perlmods/Msql-Mysql-modules-1.2210/mysql'
> > > make:  *** [test] Error\ 2
> > >
> > > after the above errors even i tried executing the 'make install'.
> Then I
> > > tried a sample perl file using the 'use DBI' function to test the
> perl
> > > module install w/ MySQL, and when I execute I get the same error:
> > undefined
> > > symbol: uncompress at blah blah blah...
> > >
> > > Please Help.  What am I doing wrong?  Do I need to do an un-install
> before
> > > trying to re-install DBD?  Should I blow out Perl altogether and
> > reinstall?
> > > Has anyone seen this before?
> > >
> > > Thanks in advance,
> > >
> > > Chris Becker
> > >
> >
> That is a source RPM.
> Your looking in the wrong directory.
> look on RedHat/RPMS
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> 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/

RE: NULL

[Roger Retamoza]

Saludos.

Creo que soy el único hispano y necesito de ustedes.

Construyo la siguiente consulta.

Select * from coniarticulos
left join conpproveedores use index (prov_codigo) on
prov_codigo=arti_proveedor
left join conimarcas use index (marc_codigo) on marc_codigo=arti_marca and
marc_proveedor=arti_proveedor
left join coniimpuestos use index (impu_codigo) on impu_codigo=arti_impuesto
where arti_codigo='001050'

Si una se las tablas no tiene registros me regresa valores nulos.
Quiero que si no existen registros por ejemplo en conimarcas me regrese 0,
se que se puede con isnull(micampo,0) as micampo. pero tendria que hacerlo
uno a uno. hay otra forma de hacerlo.

Gracias amigos.


Roger Retamoza
ICQ 102090754
[EMAIL PROTECTED]
Barranquilla-Colombia



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

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: Speed and Hardware

[Jason Landry]

Two ideas that come immediately to mind--

1) Is the web server on the same machine as MySQL?

2) Have you looked at replication?  You could have n slaves/webservers that
display data, and all wrtes go back to the master.  There's a rather
detailed analysis in the docs that explain how to figure out the type of
benefit you'd get.

- Original Message -
From: "Andy Sharp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 1:57 PM
Subject: Speed and Hardware


> Hi,
>
> I'm facing an issue with my primary mySQL server.  It powers a web site,
> which loads almost 100% dynamic data.  At peak times of the day, it
> seems to me that the Database is becomming maxxed.  (Thus bogging the
> site)
>
> I'm aware that there are simply too many variables to completely answer
> this question - number of tables, size of tables, the queries
> themselves, system configuration, type of data, program code, etc..  but
> I'm hoping to get a ball park idea of the limitations of my current
> hardware.
>
> The system is a Pentium 850, 1Gb Ram, Ultra-II SCSI Disks, 256 Mb Cache,
> running FreeBSD 4.1 and the binary copy of Mysql for FreeBSD.  (Had some
> unreleated problems with the thread libraries..)
>
> The system averages 550 Queries per second, over the course of a normal
> week.  Most of these queries are what I'd describe as "average"  joins
> on a table of 5000 records to two tables of about 30,000 records.  If
> anything I've overindexed.  the database is a total of 100Mb, and the
> system typically has 0 disk usage.
>
> During off peak times I'm getting great performance,  Fast -
> responsive.  During peak hours, the usage spikes to 700 to 900 Queries
> per second, the DB box doesn't thrash, it just slows down.  Perviously
> fast indexed queries start getting logged as slow, and even a lookup by
> primary key id can take 2 or 3 seconds.  I suspect the system is simply
> CPU bound.
>
> So, the question is this:  Is the above usage, given an "average"
> database, ok code, and optimized queries, considered ok?  Or should I be
> looking for some kind of configuration/query problem?  Have I simply
> maxxed out my hardware?
>
> I'm sure that further tuning may be able to squeeze more speed out of
> the hardware, but I'm looking for a speed boost of double (new site
> coming on line shortly). Yet before throwing more money on hardware (and
> the time to setup replication), I'd like to get some kind of 3rd party
> information saying "Your system is performing well enough, more tweaks
> will only give you a 10 to 20 percent boost."
>
> For people running largish mySQL servers, what kind of hardware do you
> have to support a volume in the range of 2,000+ queries per second?
>
> Thanks, I appreciate any time taken in answers.
>
> --A
>
> Ps: If I've missed any good references to this in documentation, please
> let me know - I haven't found a good reference for "what is good
> performance" in any searching.
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

field separator

[John Smith]

I've searched many places and can't get a good answer .. i hope I can get 
help here.

I'm trying to dump all the data in my database to separate files (per table) 
and be able to specify a field separator character.

for example, I'd like to use || as my field separator, I did the following:

>mysqldump -u root -p --tab --fields-enclosed-by='||' --no-create-info  myDB 
> > output_file.txt

I get the folowing error:
mysqldump: Got error: 1: Can't create/write to file 
'/home/website/--fields-enclosed-by=||/alloc.txt' (Errcode: 2)

thanks in advance
-john k. smith
_
Get your FREE download of MSN Explorer at http://explorer.msn.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: Database Design

[Chris Worth]

Paul's book is quite good. I picked it up after it was recommended here.

database design, and other goodies in there.

chris


On Wed, 04 Apr 2001 20:10:41 +0200, B. van Ouwerkerk wrote:

>At 16:25 4-4-01 +, Jonathan Duncan wrote:
>>Does anyone know of a good site or reference on database design?  That would
>>be efficient database design.  I can make a database but I want to know how
>>to plan one and make it very good.  Any ideas?  Thanks in advance.
>
>www.devshed.com (database normalization and other articles)
>
>the book MySQL written by Paul DuBois
>
>Bye,
>
>
>B.
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>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: Signal to Noise Ratio...

[Eric Fitzgerald]

I actually wouldn't have a problem moderating the false positives and
approving them.  Coarse, this is all just theoretical untill we get some
kind of official word from the MySQL team (You guys listening there?)  :)


- Original Message -
From: "Steve Werby" <[EMAIL PROTECTED]>
To: "Eric Fitzgerald" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 1:29 PM
Subject: Re: Signal to Noise Ratio...


> "Eric Fitzgerald" <[EMAIL PROTECTED]> wrote:
> > I can understand the concern of longer delays in moderation.  My problem
> > with anti spam filters is simply because they are too much like
anti-virus
> > filters.  TOO many false positives.
>
> Since you were volunteering...why not volunteer to moderate the false
> positives and approve them if appropriate?  Seriously though, the procmail
> rules I mentioned have an optional facility that notifies senders of false
> positives and requires them to re-post the message with a supplied
password
> to bypass the filter the second time.  It's something to consider since
this
> is a problem with no perfect solution.
>
> --
> Steve Werby
> President, Befriend Internet Services LLC
> http://www.befriend.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: Signal to Noise Ratio...

[Steve Werby]

"Eric Fitzgerald" <[EMAIL PROTECTED]> wrote:
> I can understand the concern of longer delays in moderation.  My problem
> with anti spam filters is simply because they are too much like anti-virus
> filters.  TOO many false positives.

Since you were volunteering...why not volunteer to moderate the false
positives and approve them if appropriate?  Seriously though, the procmail
rules I mentioned have an optional facility that notifies senders of false
positives and requires them to re-post the message with a supplied password
to bypass the filter the second time.  It's something to consider since this
is a problem with no perfect solution.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/


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

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

Re: Help with SQL

[Gerald Clark]

Jim Hamer wrote:
> 
> Hello Listers,
> 
> I am using mysql and I am trying to get a SQL statement to work. I have
> designed a query in Microsoft Access and I am changing the syntax so that
> it will run from Perl against a mysql database. Here is the code:
> 
> # from Access
> #SELECT DISTINCTROW Query1.licenceNo, Query1.subCCYYMM
> #FROM Query1
> #WHERE (((Query1.licenceNo) In (SELECT [licenceNo] FROM [Query1] As Tmp
> GROUP BY [licenceNo] HAVING Count(*)=1 )) AND ((Query1.subCCYYMM)="200103"))
> #ORDER BY Query1.licenceNo;
> 
> # in the Perl program
>  $sql = "SELECT licenceNo, provinceCode ".
>  "FROM Query1 ".
>  "WHERE subCCYYMM = '200103' and licenceNo IN
> (SELECT licenceNo FROM Query1 As Temp GROUP BY licenceNo HAVING COUNT(*)=1) ".
>  "ORDER BY licenceNo ";
> 
> The server chokes on the SELECT in the WHERE statement. I have a great
> mysql book, but it doesn't cover a SELECT in a  WHERE clause.
> 
> The background is as follows. Table Query1 is a historical file with lots
> of records. Records have a unique index of licenceNo and subCCYYMM. I am
> trying to find records that have only one occurrence for a licenceNo and
> the subCCYYMM is 200103. That is, find only the historical records for a
> licenceNo where March is the only record.
> 
> Any suggestions would be helpful.
> 
> Thanks,
> Jim
> 
> Jim Hamer
>
Nested Selects are not supported yet.

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

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: Database Design

[Jason Landry]

I agree with the Paul DuBois book on MySQL.  Another good one to get if you
are just getting started with databases and is somewhat system-agnostic is
"Database Design For Mere Mortals" by Michael Hernandez.


- Original Message -
From: "B. van Ouwerkerk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 1:10 PM
Subject: Re: Database Design


> At 16:25 4-4-01 +, Jonathan Duncan wrote:
> >Does anyone know of a good site or reference on database design?  That
would
> >be efficient database design.  I can make a database but I want to know
how
> >to plan one and make it very good.  Any ideas?  Thanks in advance.
>
> www.devshed.com (database normalization and other articles)
>
> the book MySQL written by Paul DuBois
>
> Bye,
>
>
> B.
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

test

[NSDB: Mail]

test


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

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: Signal to Noise Ratio...

[Eric Fitzgerald]

I can understand the concern of longer delays in moderation.  My problem
with anti spam filters is simply because they are too much like anti-virus
filters.  TOO many false positives.
- Original Message -
From: "Steve Werby" <[EMAIL PROTECTED]>
To: "Eric Fitzgerald" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 12:12 PM
Subject: Re: Signal to Noise Ratio...


> "Eric Fitzgerald" <[EMAIL PROTECTED]> wrote:
> > The amount of spam and other noise
> > on the list has been growing more and more every day.
>
> Agreed.  Same thing's happening with my own email accounts.
>
> > Second, perhaps setup some basic moderation, I'll help if
> > need be :)
>
> I think most people asking questions on the list would rather have some
spam
> slip through than have a thread of a few rapid fire posts take hours in
the
> future because of moderation delays.  Maybe implementation of a procmail
> spam filter like the extensive set of procmail recipes put together by
> http://www.spambouncer.org/ will cut down on the spam.  Just my 2 cents.
>
> --
> Steve Werby
> President, Befriend Internet Services LLC
> http://www.befriend.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

One-way data transfer

[Eric Anderson]

Let's say I've got a database on primary server (cluster1) and
periodically I need to purge data from it to a remote archive database.
What's the best way?  I thought about replication, but I don't want the
data to stick around in the cluster1 database.  Is a dump via SSH the
best/easiest way?


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

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

Re: Help with SQL

[Steve Werby]

"Jim Hamer" <[EMAIL PROTECTED]> wrote:
> I am using mysql and I am trying to get a SQL statement to work. I have
> designed a query in Microsoft Access and I am changing the syntax so that
> it will run from Perl against a mysql database. Here is the code:
>
> # from Access
> #SELECT DISTINCTROW Query1.licenceNo, Query1.subCCYYMM
> #FROM Query1
> #WHERE (((Query1.licenceNo) In (SELECT [licenceNo] FROM [Query1] As Tmp
> GROUP BY [licenceNo] HAVING Count(*)=1 )) AND
((Query1.subCCYYMM)="200103"))
> #ORDER BY Query1.licenceNo;
>
> # in the Perl program
>  $sql = "SELECT licenceNo, provinceCode ".
>  "FROM Query1 ".
>  "WHERE subCCYYMM = '200103' and licenceNo IN
> (SELECT licenceNo FROM Query1 As Temp GROUP BY licenceNo HAVING
COUNT(*)=1) ".
>  "ORDER BY licenceNo ";
>
> The server chokes on the SELECT in the WHERE statement. I have a great
> mysql book, but it doesn't cover a SELECT in a  WHERE clause.

Those are known as SUBSELECTS.  They haven't been incorporated into
MySQL...yet.

> The background is as follows. Table Query1 is a historical file with lots
> of records. Records have a unique index of licenceNo and subCCYYMM. I am
> trying to find records that have only one occurrence for a licenceNo and
> the subCCYYMM is 200103. That is, find only the historical records for a
> licenceNo where March is the only record.

I didn't sleep last night and it's catching up with me so I can't think SQL
right now, but if it can't be done with a LEFT JOIN and a GROUP BY then you
may have to consider CREATE TEMPORARY TABLE as an intermediate step.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.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

Perl-MySql DBD Errors

[Eric Fegraus]

Hello,

I have redhat 7.0 with Mysql Ver 8.8 Distrib 3.23.22-beta.  This was the
Mysql version that came on the redhat cd's.  Perl and the Perl DBI are
installed and working correctly.  MySql seems to be working correctly as
well(i.e. no problems with permissions, created db's, tables, etc).
However, I can't install the mysql::DBD...I grabbed this from the Mysql
site,
Msql-Mysql-modules-1.2215.tar.  For the life of me I can't find the
mysql.h file that it keeps asking for?  Any ideas where this is...is it
a bug with this version.  

Thanks in advance!

Eric



-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 10:23 AM
To: Chris Becker
Cc: [EMAIL PROTECTED]
Subject: Re: Perl - DBD:DBI Errors


Chris Becker wrote:
> 
> I checked my RH6.2 install cd's and found zlib-1.1.3-6.src.rpm, I went
to
> install the package with the following command and get the following
error:
> 
> >rpm -ivh zlib-1.1.3-6.src.rpm
> Unable to open /usr/lib/rpm/rpmrc for reading: No such file or
directory.
> 
> When I originally installed the os I selected a custom install and
checked
> every option provided.  Why can I not use the rpm utility?  Do I need
to
> install that?  I have an rpm entry in the man pages???  I am logged in
as
> root.
> 
> Please help, and...
> 
> Thanks Again,
> ChrisB
> 
> -Original Message-
> From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On
> Behalf Of Gerald Clark
> Sent: Wednesday, March 28, 2001 9:26 AM
> To: Chris Becker
> Cc: [EMAIL PROTECTED]
> Subject: Re: Perl - DBD:DBI Errors
> 
> You don't have zlib on your machine.
> Check your 6.2 CD.
> 
> Chris Becker wrote:
> >
> > I'm having trouble installing the perl module DBD specifically.  I
found
> on
> > my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to
install it
> and
> > got errors, I discovered I needed DBI installed first.  So I found
> DBI-1.13
> > and did the following:
> >
> > perl Makefile.PL
> > make
> > make test
> >
> > Made 100 connections in 0 wallclock secs...
> > test.pl done
> >
> > DBI seemed to install ok.  Then I found DBD
Msql-Mysql-modules-1.2210 and
> > did the following:
> > perl Makefile.PL
> > select 1) MySQL only
> > n - for install perl emulation
> > then
> > make
> > make test
> >
> > then get output from make test:
> > ...install_driver(mysql) failed: Can't load
> > '../blib/arch/auto/DBD/mysql/mysql.so' for  module DBD::mysql:
> > ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress
at
> > /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169.
> > at (eval 1) line 3
> > at t/00base.t line 38
> > dubious
> >  Test returned status 255 (wstat 65280, 0xff00)
> > Undefined subroutine &Test::Harness::WCOREDUMP called at
> > /usr/lib/perl5/5.00503/
> > Test/Harness.pm line 288.
> > make[1]: *** [test_dynamic] Error 255
> > make[1]: Leaving directory
'/perlmods/Msql-Mysql-modules-1.2210/mysql'
> > make:  *** [test] Error\ 2
> >
> > after the above errors even i tried executing the 'make install'.
Then I
> > tried a sample perl file using the 'use DBI' function to test the
perl
> > module install w/ MySQL, and when I execute I get the same error:
> undefined
> > symbol: uncompress at blah blah blah...
> >
> > Please Help.  What am I doing wrong?  Do I need to do an un-install
before
> > trying to re-install DBD?  Should I blow out Perl altogether and
> reinstall?
> > Has anyone seen this before?
> >
> > Thanks in advance,
> >
> > Chris Becker
> >
>
That is a source RPM.
Your looking in the wrong directory.
look on RedHat/RPMS

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

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: Signal to Noise Ratio...

[Steve Werby]

"Eric Fitzgerald" <[EMAIL PROTECTED]> wrote:
> The amount of spam and other noise
> on the list has been growing more and more every day.

Agreed.  Same thing's happening with my own email accounts.

> Second, perhaps setup some basic moderation, I'll help if
> need be :)

I think most people asking questions on the list would rather have some spam
slip through than have a thread of a few rapid fire posts take hours in the
future because of moderation delays.  Maybe implementation of a procmail
spam filter like the extensive set of procmail recipes put together by
http://www.spambouncer.org/ will cut down on the spam.  Just my 2 cents.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.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: Signal to Noise Ratio...

[Aigars Grins]

> This is an open plea to the MySQL team.  The amount of spam and other
noise
> on the list has been growing more and more every day.  I would like to
make
> a couple basic plea's.  The first, is that you require a poster to the
list
> have an actual account on the list, that should help cut out some of the
> general spam.  Second, perhaps setup some basic moderation, I'll help if
> need be :)

Intelligent moderation must be performed by a physical person. No? This
means delays on mails which is something I can live without.

Another solution would be to create even more specialized lists.. (eg. how
to write SQL/database design, one for
compilation/installation/configuration). The downside of that is of course
that most people on this might want to listen all those anyway.. (Besides
the point of MySQL-'newbies' being uneccessery disoriented by a huge amount
of different lists).

Just my .02. (more spam?)

--
Aigars




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

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 help with MYSQLDUMP syntax errors

[Gerald Clark]

Peter Skipworth wrote:
> 
> mysql --username=xxx --password=xxx -e "SELECT * INTO OUTFILE
> "/root/cTable-data.dump" FIELDS TERMINATED BY ',' ENCLOSED BY '"' FROM cTable WHERE
> myfield='1'" dbname
> 
>  On Wed, 4 Apr 2001, James
> Salinas wrote:
> 
> > Hi,
> >
> > My problem is specifically concerning syntax for mysqldump.
> > I can successfully execute the following SQL commands from within MYSQL:
> >
> > mysql> USE cDatabase
> > mysql> SELECT * INTO OUTFILE "/root/cTable-data.dump"
> >   -> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
> >   -> FROM cTable WHERE myfield='1';
> >
> > Query OK, 3693 rows affected (0.12 sec)
> >
> > mysql>
> >
> > This works fine and creates my dump file where it's supposed to.
> > (of course, if the file already exists, it will give an error and not run)
> >
> > my problem is I need a way to do the above from OUTSIDE of mysql
> > so i have been trying for days to find out what the exact syntax is for using
> > mysqldump and have not been successful.
> >
> > mysqldump -T --fields-terminated-by=',' --fields-enclosed-by='"' -u root -p 
>cDatabase cTable > cTable-data.dump
> >
> > The error I get is:  mysqldump: Can't create/write to file 
>'--fields-terminated-by=,/main.sql' (Errcode: 2)
> >
> > Basically, I have to get the data out of our mysql database and into Foxpro on a 
>w32 machine.
> > The fields must be enclosed in quotation marks "  and terminated by a comma ,  so 
>they'll be imported correctly.
> >
> >
> > Please help!!
> > Jim
> >
> >
> 
>

You have improperly nested quotes.

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

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

Speed and Hardware

[Andy Sharp]

Hi,

I'm facing an issue with my primary mySQL server.  It powers a web site,
which loads almost 100% dynamic data.  At peak times of the day, it
seems to me that the Database is becomming maxxed.  (Thus bogging the
site)

I'm aware that there are simply too many variables to completely answer
this question - number of tables, size of tables, the queries
themselves, system configuration, type of data, program code, etc..  but
I'm hoping to get a ball park idea of the limitations of my current
hardware.

The system is a Pentium 850, 1Gb Ram, Ultra-II SCSI Disks, 256 Mb Cache,
running FreeBSD 4.1 and the binary copy of Mysql for FreeBSD.  (Had some
unreleated problems with the thread libraries..)

The system averages 550 Queries per second, over the course of a normal
week.  Most of these queries are what I'd describe as "average"  joins
on a table of 5000 records to two tables of about 30,000 records.  If
anything I've overindexed.  the database is a total of 100Mb, and the
system typically has 0 disk usage.

During off peak times I'm getting great performance,  Fast -
responsive.  During peak hours, the usage spikes to 700 to 900 Queries
per second, the DB box doesn't thrash, it just slows down.  Perviously
fast indexed queries start getting logged as slow, and even a lookup by
primary key id can take 2 or 3 seconds.  I suspect the system is simply
CPU bound.

So, the question is this:  Is the above usage, given an "average"
database, ok code, and optimized queries, considered ok?  Or should I be
looking for some kind of configuration/query problem?  Have I simply
maxxed out my hardware?

I'm sure that further tuning may be able to squeeze more speed out of
the hardware, but I'm looking for a speed boost of double (new site
coming on line shortly). Yet before throwing more money on hardware (and
the time to setup replication), I'd like to get some kind of 3rd party
information saying "Your system is performing well enough, more tweaks
will only give you a 10 to 20 percent boost."

For people running largish mySQL servers, what kind of hardware do you
have to support a volume in the range of 2,000+ queries per second?  

Thanks, I appreciate any time taken in answers.

--A

Ps: If I've missed any good references to this in documentation, please
let me know - I haven't found a good reference for "what is good
performance" in any searching.

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

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

Differences (Newbie)

[Steve Lowe]

Hi All,

I have installed PHPTriad V1.0 on my Win98 and it is about the best 
programme I have ever used. What I need to know is, when I have created my 
site and upload it to my ISP's server (Linux / FreeBSD / MySQL + PHP 4) are 
there any pitfalls or code differences I should be aware of?

Kindest Regards,

Steve Lowe


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

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

field separator

[John Smith]

I've searched manyh places and can't get a good answer .. i hope I can get 
help here.

I'm trying to dump all the data in my database to separate files (per table) 
and be able to specify a field separator character.

for example, I'd like to use || as my field separator, I did the following:

>mysqldump -u root -p --tab --fields-enclosed-by='||' --no-create-info  myDB 
> > output_file.txt

I get the folowing error:
mysqldump: Got error: 1: Can't create/write to file 
'/home/website/--fields-enclosed-by=||/alloc.txt' (Errcode: 2)

thanks in advance
-john k. smith
_
Get your FREE download of MSN Explorer at http://explorer.msn.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

A bug fix for Innobase users on Solaris, FreeBSD, and other non-Linux platforms

[Heikki Tuuri]

Hi!

Alex Baumeister reported a couple of days ago that Innobase is
slow when a big DELETE is concurrent with UPDATES.

The bug can cause slowing down several database operations
on non-Linux platforms.

You have to edit mysql/innobase/os/os0thread.c.
About on line 140 it is now:

struct timeval  t;

t.tv_sec = 0;
t.tv_usec = tm;


It should be:


struct timeval  t;

t.tv_sec = tm / 100;
t.tv_usec = tm % 100;


I.e., the number of microseconds specified in timeval must not be
>= 100. The bug caused thread sleeps to be zero length and the buffer
pool flush to run constantly, greatly reducing the speed of the database
in some situations.

Best regards,

Heikki Tuuri
Innobase Oy



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

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: Database Design

[B. van Ouwerkerk]

At 16:25 4-4-01 +, Jonathan Duncan wrote:
>Does anyone know of a good site or reference on database design?  That would
>be efficient database design.  I can make a database but I want to know how
>to plan one and make it very good.  Any ideas?  Thanks in advance.

www.devshed.com (database normalization and other articles)

the book MySQL written by Paul DuBois

Bye,


B.


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

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 help with MYSQLDUMP syntax errors

[Andrew Gould]

You could place the code that works in a text file and
feed the text file to mysql from the command line.

If the text file was named 'dothis', the command line
might look like:

'mysql -u username -p cDatabase < dothis'

You will be prompted for username's password after
pressing ENTER.  If you want this to happen at night,
execute the job via cron.

I hope this helps.

Andrew Gould

--- James Salinas <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> My problem is specifically concerning syntax for
> mysqldump.
> I can successfully execute the following SQL
> commands from within MYSQL:
> 
> mysql> USE cDatabase
> mysql> SELECT * INTO OUTFILE
> "/root/cTable-data.dump"
>   -> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
>   -> FROM cTable WHERE myfield='1';
> 
> Query OK, 3693 rows affected (0.12 sec)
> 
> mysql>
> 
> This works fine and creates my dump file where it's
> supposed to.
> (of course, if the file already exists, it will give
> an error and not run)
> 
> my problem is I need a way to do the above from
> OUTSIDE of mysql
> so i have been trying for days to find out what the
> exact syntax is for using
> mysqldump and have not been successful.
> 
> mysqldump -T --fields-terminated-by=','
> --fields-enclosed-by='"' -u root -p cDatabase cTable
> > cTable-data.dump
> 
> The error I get is:  mysqldump: Can't create/write
> to file '--fields-terminated-by=,/main.sql'
> (Errcode: 2)
> 
> Basically, I have to get the data out of our mysql
> database and into Foxpro on a w32 machine.
> The fields must be enclosed in quotation marks " 
> and terminated by a comma ,  so they'll be imported
> correctly.
> 
> 
> Please help!!
> Jim
> 
> 


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/

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

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

Help with SQL

[Jim Hamer]

Hello Listers,

I am using mysql and I am trying to get a SQL statement to work. I have 
designed a query in Microsoft Access and I am changing the syntax so that 
it will run from Perl against a mysql database. Here is the code:

# from Access
#SELECT DISTINCTROW Query1.licenceNo, Query1.subCCYYMM
#FROM Query1
#WHERE (((Query1.licenceNo) In (SELECT [licenceNo] FROM [Query1] As Tmp 
GROUP BY [licenceNo] HAVING Count(*)=1 )) AND ((Query1.subCCYYMM)="200103"))
#ORDER BY Query1.licenceNo;

# in the Perl program
 $sql = "SELECT licenceNo, provinceCode ".
 "FROM Query1 ".
 "WHERE subCCYYMM = '200103' and licenceNo IN 
(SELECT licenceNo FROM Query1 As Temp GROUP BY licenceNo HAVING COUNT(*)=1) ".
 "ORDER BY licenceNo ";

The server chokes on the SELECT in the WHERE statement. I have a great 
mysql book, but it doesn't cover a SELECT in a  WHERE clause.

The background is as follows. Table Query1 is a historical file with lots 
of records. Records have a unique index of licenceNo and subCCYYMM. I am 
trying to find records that have only one occurrence for a licenceNo and 
the subCCYYMM is 200103. That is, find only the historical records for a 
licenceNo where March is the only record.

Any suggestions would be helpful.

Thanks,
Jim

Jim Hamer

Downtown Data Processing Inc.
(416) 489-3298 home and office
[EMAIL PROTECTED]
Toronto, Ontario, Canada
http://webhome.idirect.com/~jhamer/

Re: TheCasino.com: Registration Confirmation

[B. van Ouwerkerk]

At 10:19 4-4-01 -0600, Nathan wrote:
>I sincerely hope this is the result of a virus.

Dunno, one of the PHP lists is also being harrased by this kind of 
messages.. Perhaps Billy boy G. has to much time to spend ;-)
Or it might be a programm in a nasty loop.

The PHP list admin has blocked all traffic from these guys.. Perhaps the 
MySQL listadmin can do the same..

Bye,


B.


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

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: Provider claims 'it's normal that mysql crashes', is that true?

[B. van Ouwerkerk]

>After further asking I got a personal answer that says:
>"it's normal the mysql-servers die because of heavy load".
>"We can't help that the mysql task keeps crashing if to many users access it.
>That's totally normal for a mysql database"

Running 3.22.32 that's prehistoric (sort of).. I think I even remember some 
problems with 3.22.32 .. not sure though..

Our own mysqlservers have an average downtime of 1 hour (maybe 2 hours) per 
year, per server!! mostly because of maintenance.

To many users accessing their MySQL server.. can be.. but then you increase 
the amount of servers you've got. An average of >71000 users per server 
might be a little to must.. even if only 10 percent would use MySQL 
sound still as to many users.

Time to find yourself another ISP.. if they can't be convinced in spending 
a few DM extra that is..

Bye,


B.


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

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

Advanced MySQL

[Mike Roberts]

Hey everyone

Does anyone know of any sites that teach more advanced PHP and MySQL?
Tutorials are the best to learn from, but I'm willing to take anything.

Thanks all


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

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

Re: TheCasino.com: Registration Confirmation

[Andy Woolley]

Unfortunately not it's plain old SPAM!

It's on other lists as well.

Andy Woolley
www.databasewatch.com

- Original Message -
From: "Nathan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 5:19 PM
Subject: Re: TheCasino.com: Registration Confirmation


> I sincerely hope this is the result of a virus.
>
> # Nathan
>
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, April 04, 2001 8:54 AM
> Subject: TheCasino.com: Registration Confirmation
>
>
>
> TheCasino.com - Serving ''Winners'' Since 1999!!
>
>
> Dear MySQL List,
>
> Congratulations and welcome to TheCasino.com!!
>
> To confirm, you have successfully registered as a Real Player. From
> now on, every time you log on your Email Address will appear
automatically.
> And for security, you will need to supply your:
>
> Password:  lists
>
> If you have not already had a chance to play some of the CasinoSystem
> Games, our Progressive Jackpot is now US$13662.57 - and growing!!
>
> Now might be a good time to win some cash!!  Give it a try...
>
> http://www.TheCasino.com
>
> ...then click on the 'Progressive Jackpot' link at the top of the screen.
> And then select 'Real Money Games'.
>
> Go for the US$13662.57 Jackpot now!!
>
> Please do let us know if we can ever be of assistance!
>
> Regards,
>
> The Support Staff
> TheCasino.com Corporation
> http://www.TheCasino.com
> [EMAIL PROTECTED]
>
>
> TheCasino.com - Better Than Life! (TM)
> ''Now With 100% Bonus on Every Deposit!!''
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

Maybe a little off topic.

[Duumke]

I'm wondering if it is required to name int varibable in PHP any different
then a string variable.
I'm trying to get an ICQ number from my database with an query, but it gives
me a Resource #2 in stead of an ICQ number.
Does anyone know what I'm doing wrong?

Thanks

Guido



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

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 - DBD:DBI Errors

[Gerald Clark]

Chris Becker wrote:
> 
> I checked my RH6.2 install cd's and found zlib-1.1.3-6.src.rpm, I went to
> install the package with the following command and get the following error:
> 
> >rpm -ivh zlib-1.1.3-6.src.rpm
> Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory.
> 
> When I originally installed the os I selected a custom install and checked
> every option provided.  Why can I not use the rpm utility?  Do I need to
> install that?  I have an rpm entry in the man pages???  I am logged in as
> root.
> 
> Please help, and...
> 
> Thanks Again,
> ChrisB
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Gerald Clark
> Sent: Wednesday, March 28, 2001 9:26 AM
> To: Chris Becker
> Cc: [EMAIL PROTECTED]
> Subject: Re: Perl - DBD:DBI Errors
> 
> You don't have zlib on your machine.
> Check your 6.2 CD.
> 
> Chris Becker wrote:
> >
> > I'm having trouble installing the perl module DBD specifically.  I found
> on
> > my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to install it
> and
> > got errors, I discovered I needed DBI installed first.  So I found
> DBI-1.13
> > and did the following:
> >
> > perl Makefile.PL
> > make
> > make test
> >
> > Made 100 connections in 0 wallclock secs...
> > test.pl done
> >
> > DBI seemed to install ok.  Then I found DBD Msql-Mysql-modules-1.2210 and
> > did the following:
> > perl Makefile.PL
> > select 1) MySQL only
> > n - for install perl emulation
> > then
> > make
> > make test
> >
> > then get output from make test:
> > ...install_driver(mysql) failed: Can't load
> > '../blib/arch/auto/DBD/mysql/mysql.so' for  module DBD::mysql:
> > ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at
> > /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169.
> > at (eval 1) line 3
> > at t/00base.t line 38
> > dubious
> >  Test returned status 255 (wstat 65280, 0xff00)
> > Undefined subroutine &Test::Harness::WCOREDUMP called at
> > /usr/lib/perl5/5.00503/
> > Test/Harness.pm line 288.
> > make[1]: *** [test_dynamic] Error 255
> > make[1]: Leaving directory '/perlmods/Msql-Mysql-modules-1.2210/mysql'
> > make:  *** [test] Error\ 2
> >
> > after the above errors even i tried executing the 'make install'.  Then I
> > tried a sample perl file using the 'use DBI' function to test the perl
> > module install w/ MySQL, and when I execute I get the same error:
> undefined
> > symbol: uncompress at blah blah blah...
> >
> > Please Help.  What am I doing wrong?  Do I need to do an un-install before
> > trying to re-install DBD?  Should I blow out Perl altogether and
> reinstall?
> > Has anyone seen this before?
> >
> > Thanks in advance,
> >
> > Chris Becker
> >
>
That is a source RPM.
Your looking in the wrong directory.
look on RedHat/RPMS

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

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 help with MYSQLDUMP syntax errors

[Peter Skipworth]

mysql --username=xxx --password=xxx -e "SELECT * INTO OUTFILE 
"/root/cTable-data.dump" FIELDS TERMINATED BY ',' ENCLOSED BY '"' FROM cTable WHERE
myfield='1'" dbname




 On Wed, 4 Apr 2001, James
Salinas wrote:

> Hi,
> 
> My problem is specifically concerning syntax for mysqldump.
> I can successfully execute the following SQL commands from within MYSQL:
> 
> mysql> USE cDatabase
> mysql> SELECT * INTO OUTFILE "/root/cTable-data.dump"
>   -> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
>   -> FROM cTable WHERE myfield='1';
> 
> Query OK, 3693 rows affected (0.12 sec)
> 
> mysql>
> 
> This works fine and creates my dump file where it's supposed to.
> (of course, if the file already exists, it will give an error and not run)
> 
> my problem is I need a way to do the above from OUTSIDE of mysql
> so i have been trying for days to find out what the exact syntax is for using
> mysqldump and have not been successful.
> 
> mysqldump -T --fields-terminated-by=',' --fields-enclosed-by='"' -u root -p 
>cDatabase cTable > cTable-data.dump
> 
> The error I get is:  mysqldump: Can't create/write to file 
>'--fields-terminated-by=,/main.sql' (Errcode: 2)
> 
> Basically, I have to get the data out of our mysql database and into Foxpro on a w32 
>machine.
> The fields must be enclosed in quotation marks "  and terminated by a comma ,  so 
>they'll be imported correctly.
> 
> 
> Please help!!
> Jim
> 
> 


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

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: TheCasino.com: Registration Confirmation

[Jack Lauman]

Under the laws of the State of Washington spamming is illegal.

RCW 19.190.040
Violations -- Damages.

(1) Damages to the recipient of a commercial electronic mail message
sent in violation of this chapter are five hundred dollars, or actual
damages, whichever is greater.

(2) Damages to an interactive computer service resulting from a
violation of this chapter are one thousand dollars, or actual
damages, whichever is greater.

[1998 c 149 § 5.]


http://www.leg.wa.gov/pub/rcw/RCW%20%2019%20%20TITLE/RCW%20%2019%20.190%20%20CHAPTER/RCW%20%2019%20.190%20%20CHAPTER.htm

[EMAIL PROTECTED] wrote:
> 
> TheCasino.com - Serving ''Winners'' Since 1999!!
> 
> Dear MySQL List,
> 
> Congratulations and welcome to TheCasino.com!!
> 
> To confirm, you have successfully registered as a Real Player. From
> now on, every time you log on your Email Address will appear automatically.
> And for security, you will need to supply your:
> 
> Password:  lists
> 
> If you have not already had a chance to play some of the CasinoSystem
> Games, our Progressive Jackpot is now US$13662.57 - and growing!!
> 
> Now might be a good time to win some cash!!  Give it a try...
> 
> http://www.TheCasino.com
> 
> ...then click on the 'Progressive Jackpot' link at the top of the screen.
> And then select 'Real Money Games'.
> 
> Go for the US$13662.57 Jackpot now!!
> 
> Please do let us know if we can ever be of assistance!
> 
> Regards,
> 
> The Support Staff
> TheCasino.com Corporation
> http://www.TheCasino.com
> [EMAIL PROTECTED]
> 
> TheCasino.com - Better Than Life! (TM)
> ''Now With 100% Bonus on Every Deposit!!''
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> 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

Signal to Noise Ratio...

[Eric Fitzgerald]

This is an open plea to the MySQL team.  The amount of spam and other noise
on the list has been growing more and more every day.  I would like to make
a couple basic plea's.  The first, is that you require a poster to the list
have an actual account on the list, that should help cut out some of the
general spam.  Second, perhaps setup some basic moderation, I'll help if
need be :)

I think the last thing we all need is more spam coming down our pipes, so if
anything can be done to help prevent this, it would make everyone's lives
easier...except of coarse the low life scum that get's a rise out of farming
a list for E-Mails or even sending spam to the list.


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

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 - DBD:DBI Errors

[Chris Becker]

I checked my RH6.2 install cd's and found zlib-1.1.3-6.src.rpm, I went to
install the package with the following command and get the following error:

>rpm -ivh zlib-1.1.3-6.src.rpm
Unable to open /usr/lib/rpm/rpmrc for reading: No such file or directory.


When I originally installed the os I selected a custom install and checked
every option provided.  Why can I not use the rpm utility?  Do I need to
install that?  I have an rpm entry in the man pages???  I am logged in as
root.

Please help, and...

Thanks Again,
ChrisB




-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Gerald Clark
Sent: Wednesday, March 28, 2001 9:26 AM
To: Chris Becker
Cc: [EMAIL PROTECTED]
Subject: Re: Perl - DBD:DBI Errors


You don't have zlib on your machine.
Check your 6.2 CD.

Chris Becker wrote:
>
> I'm having trouble installing the perl module DBD specifically.  I found
on
> my CPAN cd the DBD module Msql-Mysql-modules-1.2208, tried to install it
and
> got errors, I discovered I needed DBI installed first.  So I found
DBI-1.13
> and did the following:
>
> perl Makefile.PL
> make
> make test
>
> Made 100 connections in 0 wallclock secs...
> test.pl done
>
> DBI seemed to install ok.  Then I found DBD Msql-Mysql-modules-1.2210 and
> did the following:
> perl Makefile.PL
> select 1) MySQL only
> n - for install perl emulation
> then
> make
> make test
>
> then get output from make test:
> ...install_driver(mysql) failed: Can't load
> '../blib/arch/auto/DBD/mysql/mysql.so' for  module DBD::mysql:
> ../blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: uncompress at
> /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169.
> at (eval 1) line 3
> at t/00base.t line 38
> dubious
>  Test returned status 255 (wstat 65280, 0xff00)
> Undefined subroutine &Test::Harness::WCOREDUMP called at
> /usr/lib/perl5/5.00503/
> Test/Harness.pm line 288.
> make[1]: *** [test_dynamic] Error 255
> make[1]: Leaving directory '/perlmods/Msql-Mysql-modules-1.2210/mysql'
> make:  *** [test] Error\ 2
>
> after the above errors even i tried executing the 'make install'.  Then I
> tried a sample perl file using the 'use DBI' function to test the perl
> module install w/ MySQL, and when I execute I get the same error:
undefined
> symbol: uncompress at blah blah blah...
>
> Please Help.  What am I doing wrong?  Do I need to do an un-install before
> trying to re-install DBD?  Should I blow out Perl altogether and
reinstall?
> Has anyone seen this before?
>
> Thanks in advance,
>
> Chris Becker
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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: Provider claims 'it's normal that mysql crashes', is that true?

[nigel wood]

On Wed, 04 Apr 2001, Gunnar von Boehn wrote:
> Hello
> 
> 
> My provider 1&1-Puretec (www.puretec.de)
> hosting more than 1.000.000 domains
> runs about 14 Databaseserver with MySQL 3.22.32-log
> on Linux dual Penti-III 500Mhz machines.
> 
> In the last 6 month the average uptime of the mysql-servers was around 8 hours.
> 
> As I asked them why their mysql-server die so often, I got their
> standard problem email-answer that claims "mysql is scaling rather badly".
> 
> After further asking I got a personal answer that says:
> "it's normal the mysql-servers die because of heavy load".
> "We can't help that the mysql task keeps crashing if to many users access it.
> That's totally normal for a mysql database"
> 
> 
> Is that true?

Only if their servers/queries are set up wrong. We use Sparc/Solaris exclusively
in our production network now but used to have more data than this hosted on a
similar machine. They could be telling the truth is they have huge queries that
lock the tables for extended periods. The table level locking of .ism tables can
cause problems on very busy servers. MySQL's newer tables avoid this problem
but I'm not sure how production ready they are.

Nigel  

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

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: Provider claims 'it's normal that mysql crashes', is that true?

[Owen Scott Medd]

We've been running on RedHat distribution (starting with 5.2 or so) and
Slackware before that for the last few years (currently running mysql
3.23.32... that update bug introduced in 3.23.34 really spanked us hard,
we'll be moving to "latest" again soon).

Currently, we've got dual and quad PII and PIII machines with upwards of
2GB of memory averaging around 400 queries/second (150-400 sessions at any
given time).  Our mysql uptime depends on how often we do software
or hardware upgrades, not on mysql "mean time to crash".

Translated:  our mysql servers run for weeks/months.

I consider our mysql databases to be very stable. :)

Owen

On Wed, 4 Apr 2001, Gunnar von Boehn wrote:
> Hello
>
> My provider 1&1-Puretec (www.puretec.de)
> hosting more than 1.000.000 domains
> runs about 14 Databaseserver with MySQL 3.22.32-log
> on Linux dual Penti-III 500Mhz machines.
>
> In the last 6 month the average uptime of the mysql-servers was around 8 hours.
>
> As I asked them why their mysql-server die so often, I got their
> standard problem email-answer that claims "mysql is scaling rather badly".
>
> After further asking I got a personal answer that says:
> "it's normal the mysql-servers die because of heavy load".
> "We can't help that the mysql task keeps crashing if to many users access it.
> That's totally normal for a mysql database"
>
>
> Is that true?
>
>
>
> regards
> Gunnar von Boehn
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

-- 
USMail:   CareerSite Corporation, 310 Miller Avenue, Ann Arbor, MI 48103
Phone:+1 734 213-9500   FAX:+1 734 213-9011
mailto:[EMAIL PROTECTED]   http://www.careersite.com/~osm/


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

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: Provider claims 'it's normal that mysql crashes', is that true?

[Scott Baker]

No this is not true...  a lot of the stability of the database server has 
to do with the #1 the load, and #2 the design of the database.  But no 
MySQL should not be crashing this much.

Scott

At 05:26 PM 4/4/2001 +0200, Gunnar von Boehn wrote:

>Hello
>
>
>My provider 1&1-Puretec (www.puretec.de)
>hosting more than 1.000.000 domains
>runs about 14 Databaseserver with MySQL 3.22.32-log
>on Linux dual Penti-III 500Mhz machines.
>
>In the last 6 month the average uptime of the mysql-servers was around 8 
>hours.
>
>As I asked them why their mysql-server die so often, I got their
>standard problem email-answer that claims "mysql is scaling rather badly".
>
>After further asking I got a personal answer that says:
>"it's normal the mysql-servers die because of heavy load".
>"We can't help that the mysql task keeps crashing if to many users access it.
>That's totally normal for a mysql database"
>
>
>Is that true?
>
>
>
>regards
>Gunnar von Boehn
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]

"It has been said that the primary function of schools is to impart enough 
facts to make children stop asking questions. Some, with whom the schools 
do not succeed, become scientists." - Knut Schmidt-Nielson








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

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

TheCasino.com: Abuse...

[TheCasino.com: Abuse]

TheCasino.com - Serving "Winners" Since 1999!!

Dear Members of the '[EMAIL PROTECTED]',

I am in receipt of your email regarding an unsolicited email.

>
> STOP SPAMMING THE MAIL LISTS ASSHOLE
> 

We have a very strict anti-spam policy, and we take extreme measures to
adhere to these directions:

1)  We NEVER purchase email lists.
2)  We NEVER sell or otherwise trade our own database of user information.
3)  We IMMEDIATELY terminate any "affiliates" who are found to be utilizing
SPAM to promote their account.

If you are receiving this "particular" email, it is because of two possible
reasons:

1)  You signed up to be included in our monthly drawings.
2)  "Someone else" signed up on your behalf.

I would imagine in your case, the latter to be the case.  In any event, your
contact information has been permanently removed/deleted from our records.

I do apologize for any inconvenience this may have caused you.

Please do let us know if our prompt efforts do not immediately resolve this
situation for you.

Sincerely,

Terry Ngona
The Support Staff
[EMAIL PROTECTED]
http://www.TheCasino.com

TheCasino.com - Better Than Life! (TM)
"Now With 100% Bonus on Every Deposit!!"



> STOP SPAMMING THE MAIL LISTS ASSHOLE
> 
> TheCasino.com: Registration Confirmation
> Date: Wed, 4 Apr 2001 10:54:06 -0400 (EDT)
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Reply to: [EMAIL PROTECTED]
> 
> 
> TheCasino.com - Serving \'\'Winners\'\' Since 1999!!
> 
> 
> Dear MySQL List,
> 
> Congratulations and welcome to TheCasino.com!!
> 
> To confirm, you have successfully registered as a Real Player. From
> now on, every time you log on your Email Address will appear automatically.
> And for security, you will need to supply your:
> 
> Password:  lists
> 
> If you have not already had a chance to play some of the CasinoSystem
> Games, our Progressive Jackpot is now US$13662.57 - and growing!!
> 
> Now might be a good time to win some cash!!  Give it a try...
> 




> http://www.TheCasino.com
> 
> ...then click on the \'Progressive Jackpot\' link at the top of the screen.
> AAnd then select \'Real Money Games\'.
> 
> Go for the US$13662.57 Jackpot now!!
> 
> Please do let us know if we can ever be of assistance!
> 
> Regards,
> 
> The Support Staff
> TheCasino.com Corporation
> http://www.TheCasino.com
> [EMAIL PROTECTED]
> 
> 
> TheCasino.com - Better Than Life! (TM)
> \'\'Now With 100% Bonus on Every Deposit!!\'\'
> 
> 
> -
> Before posting, please check:
> http://www.mysql.com/manual.php   (the manual)
> http://lists.mysql.com/   (the list archive)
> 







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

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

Database Design

[Jonathan Duncan]

Does anyone know of a good site or reference on database design?  That would 
be efficient database design.  I can make a database but I want to know how 
to plan one and make it very good.  Any ideas?  Thanks in advance.

-- 
Jonathan Duncan
nacnud.com administrator
Nacnud, Inc.





Brought to you by nacnudMail using TWIG.  http://www.nacnud.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: TheCasino.com: Registration Confirmation

[Nathan]

I sincerely hope this is the result of a virus.

# Nathan


- Original Message - 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 8:54 AM
Subject: TheCasino.com: Registration Confirmation



TheCasino.com - Serving ''Winners'' Since 1999!!


Dear MySQL List,

Congratulations and welcome to TheCasino.com!!

To confirm, you have successfully registered as a Real Player. From 
now on, every time you log on your Email Address will appear automatically.  
And for security, you will need to supply your:

Password:  lists

If you have not already had a chance to play some of the CasinoSystem
Games, our Progressive Jackpot is now US$13662.57 - and growing!!

Now might be a good time to win some cash!!  Give it a try...

http://www.TheCasino.com

...then click on the 'Progressive Jackpot' link at the top of the screen.
And then select 'Real Money Games'.

Go for the US$13662.57 Jackpot now!!

Please do let us know if we can ever be of assistance!

Regards,

The Support Staff
TheCasino.com Corporation
http://www.TheCasino.com
[EMAIL PROTECTED]


TheCasino.com - Better Than Life! (TM)  
''Now With 100% Bonus on Every Deposit!!''


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

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

Security Mysql

[J.Heegsma]

Dear Sir/Madam,

I am a student and my teacher want's to try to break in into my mysql-database. I 
won't give him a change. I know Mysql have serveral options for security and 
encryption. But I do not know, how I can use them and which one I can use the best. 
Could you help me? The mysql database will be accessed by the internet with the php 
language. Information from the database has to be published on the website and 
information has to be put again into the databae by a form.

Please send all the information you can give me about mysql security and encryption 
possiblities to: [EMAIL PROTECTED]

Thank you very much.

Greetings from a dutch student,

J.Heegsma

Re: MySQL Security

[William R. Mussatto]

Apache can be set to run your cgi as you user which means that it could 
be set world unreadable I think.

On Wed, 4 Apr 2001, Taing Nguon wrote:

> Date: Wed, 4 Apr 2001 07:14:33 +0700
> From: Taing Nguon <[EMAIL PROTECTED]>
> To: "William R. Mussatto" <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: MySQL Security
> 
> > Make sure that the files are not world readable.
> 
> In Linux system, In order to run CGI in PERL script, that perl script
> must be 755. It is read by any users and Perl is written in text format, so
> Its is easy to know user and password of MYSQL. How do you think about
> this?Need More HELP
> 
> Million of thanks
> 
> Regards
> Taing Nguon
> 
> 
> > On Tue, 3 Apr 2001, Taing Nguon wrote:
> >
> > > Date: Tue, 3 Apr 2001 09:52:30 +0700
> > > From: Taing Nguon <[EMAIL PROTECTED]>
> > > To: [EMAIL PROTECTED]
> > > Subject: MySQL Security
> > >
> > > Dear sir or madam
> > >
> > > MySQL user's account is not related to user's account on Linux =
> > > System, so they can be different.
> > >
> > > My problem is that I use perl DBI to interact MySQL server as belows:
> > >
> > > --
> > > use DBI;
> > > $dbh =3D DBI->connect("DBI:mysql:DatabaseName","$user","$password");
> > >
> > > ---
> > >
> > > So $user and $password can be known by any users in Linux system because
> =
> > >  they are written in text format and DataBase can be changed or updated
> =
> > > by other users in Linux system easily by using Perl DBI. Is there any =
> > > way to prevent Database from being changed? Millon of thanks
> > >
> > >
> > > Regards
> > >
> > > Taing Nguon
> > >
> > >
> > >
> >
> > 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
> 

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

Please help with MYSQLDUMP syntax errors

[James Salinas]

Hi,

My problem is specifically concerning syntax for mysqldump.
I can successfully execute the following SQL commands from within MYSQL:

mysql> USE cDatabase
mysql> SELECT * INTO OUTFILE "/root/cTable-data.dump"
  -> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
  -> FROM cTable WHERE myfield='1';

Query OK, 3693 rows affected (0.12 sec)

mysql>

This works fine and creates my dump file where it's supposed to.
(of course, if the file already exists, it will give an error and not run)

my problem is I need a way to do the above from OUTSIDE of mysql
so i have been trying for days to find out what the exact syntax is for using
mysqldump and have not been successful.

mysqldump -T --fields-terminated-by=',' --fields-enclosed-by='"' -u root -p cDatabase 
cTable > cTable-data.dump

The error I get is:  mysqldump: Can't create/write to file 
'--fields-terminated-by=,/main.sql' (Errcode: 2)

Basically, I have to get the data out of our mysql database and into Foxpro on a w32 
machine.
The fields must be enclosed in quotation marks "  and terminated by a comma ,  so 
they'll be imported correctly.


Please help!!
Jim

Re: Converting Access to MySQL

[Scott Meesseman]

in access   >>>File Menu >>>   Export or Import, depending which 
way youre goin'   >>   Follow on screen inst.

scott


At 03:06 PM 4/3/01, you wrote:
>Ok i'm still a little bit lost. I have a database in MySQL called "irm"
>
>In the ODBC Data Source 32 bit I went in user dsn and added user data source
>called irm  the driver is mysql
>
>not this is were i dont understand .
>
>In the field that says Windwos DSN name I put "irm"
>MySQL I put the ip address were mysql is located.
>user name I put :root
>the password : password
>
>then i sayed ok.
>
>after this what do I do.
>
>Do i go to access and try to connect that way or how do i connect to the
>database irm that i have in mysql.
>
>Luis
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
>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

merge tables - rename

[daveclark]

I got into trouble the other day trying to delete gobs of rows.   Actually
I was selecting 90% of the rows from table1 and inserting them into a
table2, then deleting from table1.  It was way too slow!   So I stopped all
activity (inserts) from table1 and flipped table1 with table2 using rename
statements.  Then started up the inserts!   Worked great.   

How can I do this with out stoping inserts?   Can I lock the table1, rename
table1 to table2, then create a new table1 and release all locks?   




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

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

merge tables

[daveclark]

I frequently get a error 127 on merged tables.  The query is a join of two
merged table with each merge table have 4 base tables.   If I flush tables
the query works.   I notice that when have about 190 tables in memory this
situation is more likely to happen.   I am using 3.23.32.

Using 3.32.35, I got 'no rows' response instead of error 127.  Again the
flush table allow the query to run.  I knew data shoud have been return
because I query the base table and got a positive response.

I noticed some discussion on this over the past couple weeks but no one
mentioned the flush table impact.

I tried to increase the number of files allowed, but this problem is not
too predictable.   Guess I could try and break it with large number of
queries, but I have not.

Is there any problems with issueing a flush table every x hours ... minutes
to avoid this problem?

When are tables flushed by mysql?


Dave Clark 









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

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

How to get a user created DB work in users home dir.

[Emil Sykkö]

Hello. My name is Emil, I'm from at company called ES Design.

My problem is that I whant to do this.

When a user creat's a database it shoudl be installed in ~userdir/my_db
and when root/superuser creat's a database is would be in /path/to/mysql/var.
I have understand that it would work... with help of my.cnf file... but I can't get it 
to work. Please help. Here is the spec. of my system.


1.Slackware linux 7.0
2. Mysql  Ver 11.9 Distrib 3.23.29a-gamma, for pc-linux-gnu (i686)


I'll hope that this would be enough information for U to help me 



- Emil Sykkö

e-mail: [EMAIL PROTECTED] 
e-mail2: [EMAIL PROTECTED]

if posible please answer in swedish =) as U can see so isnät my english so good.. 
=)

Provider claims 'it's normal that mysql crashes', is that true?

[Gunnar von Boehn]

Hello


My provider 1&1-Puretec (www.puretec.de)
hosting more than 1.000.000 domains
runs about 14 Databaseserver with MySQL 3.22.32-log
on Linux dual Penti-III 500Mhz machines.

In the last 6 month the average uptime of the mysql-servers was around 8 hours.

As I asked them why their mysql-server die so often, I got their
standard problem email-answer that claims "mysql is scaling rather badly".

After further asking I got a personal answer that says:
"it's normal the mysql-servers die because of heavy load".
"We can't help that the mysql task keeps crashing if to many users access it.
That's totally normal for a mysql database"


Is that true?



regards
Gunnar von Boehn

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

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

TheCasino.com: Registration Confirmation

[support]

TheCasino.com - Serving ''Winners'' Since 1999!!


Dear MySQL List,

Congratulations and welcome to TheCasino.com!!

To confirm, you have successfully registered as a Real Player. From 
now on, every time you log on your Email Address will appear automatically.  
And for security, you will need to supply your:

Password:  lists

If you have not already had a chance to play some of the CasinoSystem
Games, our Progressive Jackpot is now US$13662.57 - and growing!!

Now might be a good time to win some cash!!  Give it a try...

http://www.TheCasino.com

...then click on the 'Progressive Jackpot' link at the top of the screen.
And then select 'Real Money Games'.

Go for the US$13662.57 Jackpot now!!

Please do let us know if we can ever be of assistance!

Regards,

The Support Staff
TheCasino.com Corporation
http://www.TheCasino.com
[EMAIL PROTECTED]


TheCasino.com - Better Than Life! (TM)  
''Now With 100% Bonus on Every Deposit!!''


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

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

request help importing to mysql from tcp feed

[David Armstrong]

somehow my post screwed up here it is in it's entirety.

could i respectfully request help, i am totaly lost as to how to format this code 
as well as only been with mysql & perl for 2 weeks.
i am trying to take a real time internet tcp feed that is a comma deliminated row 
and input into fields in a mysql database
my attempt although possibly flawed all over the place is listed here :-

=== code 
#!/usr/bin/perl -w

#for test using socket input from 

$remote_host = "linus.chemeketa.edu";

$port = "10152";

$hostname = '127.0.0.1'; # localhost

$portdb ="3306"; # default mysql port

$database = "track"; # database name

$user = "david"; # database user name

$password = "12345"; # database password

$table ="trackpos"; # database table 

use strict;

use DBI;

use DBD::mysql; 

use IO::Socket;

my %serial_port_buffers; # Used for buffering input from each port.



$s = IO::Socket::INET->new(

Proto => "tcp",

PeerAddr => "$remote_host",

PeerPort => "$port",

)

or die "Cannot connect to $port at $remote_host : $@\n";

# output print testing 

# for test this line produces text output correctly works ok 

#while (<$s>) {print} # for testing socket only

#end of first hurdle

#

#now add in database and connect the two together !

# read only the socket and put socket output split by comma's into database variables

# and put into database tables , seems easy enough how wrong can i get !.

#$dbh = DBI->connect("DBI:mysql:$database:$hostname:$portdb",

# $user, $password,

# { RaiseError => 1, AutoCommit => 0 });


# my $sth = $dbh->prepare(q{

# INSERT INTO $table (callsign,id,lat,lon,msg) VALUES (?,?,?,?,?)

# }) || die $dbh->errstr;

while ( <$s> ) {

$line = $s->getc();

chop;

my ($callsign,$id,$lat,$lon,$msg) = split /,/;

print "callsign is-,$callsign\n";

print "id is-,$id\n";

print "lat-,$lat\n";

print "lon-,$lon\n";

print "msg-,$msg\n"


# $sth->execute($callsign,$id,$lat,$lon,$msg) || die $dbh->errstr;

}

# $dbh->commit || die $dbh->errstr;


# $dbh ->close


#end
 end code ==

all help is very much appriciated 

Kind regards
David Armstrong G0JQO ( UK)
[EMAIL PROTECTED] 

Re: Mysqld problem Re: ownership/permission problems

[Brian Warn]

Not sure how helpful I'll be able to be for you.  I  installed
MySQL-3.23.36-1.i386.rpm and MySQL-client-3.23.36-1.i386.rpm packages.  I
verified that everything worked as root and then shutdown the server.  I
then followed the steps outlined on p. 476 of the manual (also p. 419 of
Monty Widenius' MySQL book).  I also received some advice from another
person on this list -- I've attached it below -- that I used.

I discovered in my (server name).err file -- mine was located in my
/var/lib/mysql directory -- that mysqld couldn't find  the
/var/lib/mysql/mysql/host.frm file.  After changing the permissions on the
mysql table to 760, everything worked fine.  As you'll see below, the
recommendation was to set it to 660.

Hope this helps a bit ...

-Brian
---
Excerpt from note I received:

You should create a "mysql" group also,  and make sure that the "mysql" user
has it as it's "primary group ID" (in /etc/passwd).  Then you can add the
appropriate users (such as your own login) to the group (so you don't have
to be "root" to access the mysql stuff).

You can leave your "mysql" program directory owned by "root.root" (user and
group = "root"),  as long as the "var" subdirectory and all the files and
directories in "var" are owned by "mysql.mysql" with 2770 (rwxrws---) for
the directory permissions and 660 (rw-rw) for the files...   Set the
same ownership and permissions for the 'data' directories (if you've placed
them somewhere else on the system (linked to 'var' via symbolic links).

- Original Message -
From: "Foresight Systems Ltd." <[EMAIL PROTECTED]>
To: "Brian Warn" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 1:57 AM
Subject: Mysqld problem Re: ownership/permission problems


> Dear Sir,
> Since you already have mysql running, we seek your help in sorting out
> some problem.
> mysqld starts and ends instantaneously.
> We are using Red Hat Linux 7.0 /Apache Server on PIII 550 intel
> processor.
> We have compiled the mysql and installed version 3.23.32.
> The contents of our my.cnf file in /etc is as follows :
> 
> # Example mysql config file.
> # You can copy this to one of:
> # /usr/local/mysql/etc/my.cnf to set global options,
> # mysql-data-dir/my.cnf to set server-specific options (in this
> # installation this directory is /usr/local/mysql/var) or
> # ~/.my.cnf to set user-specific options.
> #
> # One can use all long options that the program supports.
> # Run the program with --help to get a list of available options
>
> # This will be passed to all mysql clients
> [client]
> #password = my_password
> port  = 3306
> socket  = /var/lib/mysql/mysql.sock
>
> # Here is entries for some specific programs
> # The following values assume you have at least 32M ram
>
> # The MySQL server
> [mysqld]
> port  = 3306
> socket  = /var/lib/mysql/mysql.sock
> skip-locking
> set-variable = key_buffer=16M
> set-variable = max_allowed_packet=1M
> set-variable = thread_stack=128K
> # Start logging
> log
>
> [mysqldump]
> quick
> set-variable = max_allowed_packet=16M
>
> [mysql]
> no-auto-rehash
>
> [isamchk]
> set-variable = key_buffer=16M
> ==
> The contents on the error file is follows
>
> 010403 16:19:55  mysqld started
> 010403 16:19:56  Can't start server : Bind on unix socket:
> Permission
> denied
> 010403 16:19:56  Do you already have another mysqld server
> running
> on socket: /var/lib/mysql/mysql.sock ?
> 010403 16:19:56  Aborting
>
> 010403 16:19:56  mysqld ended
>
> 010403 16:35:05  mysqld started
> 010403 16:35:05  Can't start server : Bind on unix socket:
> Permission
> denied
> 010403 16:35:05  Do you already have another mysqld server
> running
> on socket: /var/lib/mysql/mysql.sock ?
> 010403 16:35:05  Aborting
>
> 010403 16:35:05  mysqld ended
>
> 010403 17:09:52  mysqld started
> 010403 17:09:52  Can't start server : Bind on unix socket:
> Permission
> denied
> 010403 17:09:52  Do you already have another mysqld server
> running
> on socket: /var/lib/mysql/mysql.sock ?
> 010403 17:09:52  Aborting
>
> 010403 17:09:52  mysqld ended
>
> 
> Further,We have also tried latest available rpm installation -i386
> downloaded from mysql.com.
> using command
> rpm -i rpm-file-name
> but it fails to install rpm package just stating
> can not install rpm
> Please guide, how to create mysql users,set permissions,ownerships etc.
>
> Regards
> Akshaya
>
> Brian Warn wrote:
>
> > I finally did find a discussion in Monty's book on p. 417 about this.
> >
> > Thanks,
> > Brian
> >
> > - Original Message -
> > From: "B. van Ouwerkerk" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, April 03, 2001 11:20 AM
> > Subject: Re: ownership/permission problems
> >
> > >
> > > >I haven't had any success so far finding any help in the manual or
>

Uncertainty in using mySQL

[Randy Ng]

Dear Sir, 
I am new in using mySQL database. The
purpose of this email is to enquire bout the method
used to connect both the Java Programming and mySQL
database together.  Thanks.

Regards,

Randy


__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/

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

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

Re: fastest queries

[René Tegel]

not for speed, but i defitively prefer your second query. Reason for this is
simple: you name the field you want to insert.

with your first query, if you'd ever alter the table you would have to check
all your source code that interacts with this table.

speed difference should be very minimal anyhow, since it's only the parser's
speed making some diff in speed, whereas your actual delay is in the writing
of the data to disk.

regards,

rene

- Original Message -
From: "Bryan Wheelock" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 3:19 PM
Subject: fastest queries


> I'm working on a MySQL db and I was just curious what type of query was
> faster.
>
> e.g.
> I have this table1
> id (auto# primary key) |  date| Name | address | email
>
> I want to insert a new name into the DB.
> Which method would be faster?
> 1.
> INSERT INTO table1 VALUES(null,null,'Bryan',null,null);
>
> 2.
> INSERT INTO table1( name ) VALUES('Bryan');
>
> Thanks,
> Bryan
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> 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

Calculated Fields

[MCA Department PESIT]

Hi there,
i have a similar query regarding calculated fields. i have a table 
which stores the 3 test results in a particular subject. i need to find the 
average of the best 2 of the tests, i.e for a entry of 46,47,48 i need to 
find average of 47 and 48. as of right now i am using a field to store this 
average, which i find whenever i update the above marks. ofcourse a query 
would suffice in displaying the average but i think it is faster when i 
calculate it once and then read it from the field directly whenever i need 
to display the average.
please suggest if the strategy is wrong.
bye
Mathew


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

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 message to mysql@lists.mysql.com

[lucy]

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
   Are you bored and want some excitement?
   Las Vegas Has Just Showed Up In Your Neigbourhood!
  In fact, you wont even have to leave your computer!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


Queensclub Online Casino Advantages:
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

* Play in your pyjamas
* Play for fun option (without gambling money)
* Free money to play with!
* Confidential and safe
* No travel headaches
* No hotel bill suprises
* Take your time playing!
* Play with your creditcard
* Get advice as you play!
* Almost 98% payout!

++
|  This could be your lucky day! Give us a try!  |
++
  http://www.sonixxx.com/casino/

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
What do our satisfied visitors think about us?
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

PAULM, A ,460 Jackpot winner from Georgia:
"That's when I decided to throw caution to the wind.
I just put the whole wad into the machine and on my tenth
try -- BINGO! almost 150,000 dollars!" 

BOSSMAN48, A Jackpot winner from Michigan:
"After throwing out  bets for 20 minutes or so at the
JacksOrBetter game, my one big bet made me a richer man.
I pulled down a royal flush!!!" 

5666777, A Jackpot winner from New Jersey:
"After four or five unsuccessful bets I gave it a rest and
went to pick up a sandwich from the fridge. Then, after
couple of bites and couple of pulls on the slot machine,
it happened!!! I HIT THE JACKPOT!" 

RIVER, ,878 jackpot winner from Canada:
"I couldn't believe it as the money suddenly showed in my
account! We both jumped so quickly, we almost knocked
the PC off the table." 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


++
| This could be your lucky day! Give us a try!  |
+---+
http://www.sonixxx.com/casino/

This message was sent to [EMAIL PROTECTED] If you do not wish to receive more 
emails from me, just
click on the link below.
http://206.48.130.19/cgi-bin/remove.cgi

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

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

Re:Monthly Drawing Winner!

[Heikki Tuuri]

Yippee!

What shall we do with our prize money? Buy something new to
the MySQL kitchen :)?

Heikki
.
Dear MySQL Kitchen List,
Congratulations!
You just won US$10.00!!
We just gave away US$25,000.00!! 
And you MySQL Kitchen List are among the lucky 
2500 people
randomly selected to receive a FREE US$10.00 Trial Account at TheCasino.com
- the
Internet's Premier Online Casino!Account Status for MySQL Kitchen List:
Live Account Balance: US$5.00  (your cash account)
Live Buffer Balance:  US$5.00  (for extended play!)
To access your "Winning Account", please go to:
http://special.TheCasino.com/drawing.cs?winner=MySQL&lastname=List&addressEm
[EMAIL PROTECTED]
Again, congratulations to you MySQL Kitchen List, and to the rest of our
most recent instant money winners!!Enjoy your VIP visit to TheCasino.com!
Sincerely,
Ms. Kaara Moore
Director of Relations


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

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

fastest queries

[Bryan Wheelock]

I'm working on a MySQL db and I was just curious what type of query was
faster.

e.g.
I have this table1
id (auto# primary key) |  date| Name | address | email

I want to insert a new name into the DB.
Which method would be faster?
1.
INSERT INTO table1 VALUES(null,null,'Bryan',null,null);

2.
INSERT INTO table1( name ) VALUES('Bryan');

Thanks,
Bryan


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

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: Does query inside while loop slow down page?

[Steve Werby]

"Cody Law" <[EMAIL PROTECTED]> wrote:
>  When you do a query inside a while loop in PHP,
> does it dramatically slow down the loading of the
> page? For example,
>
> while($row = mysql_fetch_row($result)) {
>  $id = $row[0];
>  $query2 = "select field from some_table
> where(id='$id')";
>  $result2 = mysql_result($query2, $link);
> }

It will take longer, whether it's dramatically longer depends on a lot of
things.  In your case the inner query will be fast if the id field ia a key
of an index, but since it has to be run once for every record returned from
the outer query there might be a better way.  If possible, try to use the
LEFT JOIN syntax to get the data you want from a single query.  LEFT JOIN
syntax is covered in the online manual and the list archives.

--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.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: Does query inside while loop slow down page?

[nod]

yes, you really should be using an inner join and just looping through the 
one result set.

On Wednesday 04 April 2001 12:11 pm, Cody Law wrote:
> Hi,
>  When you do a query inside a while loop in PHP,
> does it dramatically slow down the loading of the
> page? For example,
>
> while($row = mysql_fetch_row($result)) {
>  $id = $row[0];
>  $query2 = "select field from some_table
> where(id='$id')";
>  $result2 = mysql_result($query2, $link);
> }
>
> Does it have anything to configuring the buffer length
> when you install MYSQL? Thank you.
>

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

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: Does query inside while loop slow down page?

[Rolf Hopkins]

You can do that with one mysql query.  Create a comma delimited list of $id
and change your where clause to "WHERE id in (your comma delimited list)".

- Original Message -
From: "Cody Law" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 20:11
Subject: Does query inside while loop slow down page?


> Hi,
>  When you do a query inside a while loop in PHP,
> does it dramatically slow down the loading of the
> page? For example,
>
> while($row = mysql_fetch_row($result)) {
>  $id = $row[0];
>  $query2 = "select field from some_table
> where(id='$id')";
>  $result2 = mysql_result($query2, $link);
> }
>
> Does it have anything to configuring the buffer length
> when you install MYSQL? Thank you.
>
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


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

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: Calculations in a field?

[Bob Hall]

>"Bob Hall" <[EMAIL PROTECTED]> wrote:
>  > Quorting someone else who's name is no longer present:
>  > >Is there any way to make one field in a table calculate another field.
>  > >I'm making a DB that calculates commissions. So in the money_made
>  > >field would have the # of sales (sales field) times whatever the
>  > >commission would be.
>  >
>  > Yes sir, but don't do it. That's the classic example of something
>  > that should not be in a table. Calculated fields belong in queries.
>
>In a lot of cases that's true to prevent storing of redundant data.
>However, the poster's example was about sales and commissions.  In the real
>world commission rates within a company can change over time so if the
>poster is trying to calculate the commission in conjunction with an INSERT
>STATEMENT it might be wise to have the commission rate in a variable in the
>associatd application and add the commission as the record is entered.  Then
>when the commission rate goes down (or up), a variable can be modified and
>the application will work fine.  If the commission rate is already in the
>table (the poster didn't state this, but it could be) then it might make
>sense to calculate the commission instead of saving it in a field.

Sir, it doesn't matter whether the commission rate is stored in the 
table or the application. In either case, the application can 
generate an SQL statement that calculates the commission. Commission 
rates can be changed either in the client application or in the table.

>Then
>again, if the number of rows is large and reports are going to be generated
>based on things like total commissions by sales person by month, it might
>create more overhead than desired.

If the reports are generated monthly or less often, then the overhead 
isn't going to matter much, unless you have a huge organization with 
thousands of sales people, and the query that calculates the 
commission is very complex. I have had to include calculated fields 
in tables occasionally, but only when the SQL optimizer was confused 
by several layers of subqueries. For obvious reasons, this has never 
happened with MySQL.

>
>--
>Steve Werby
>President, Befriend Internet Services LLC
>http://www.befriend.com/

Bob Hall

Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak

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

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