Download Manual
I've been using the online database manual, and the current version is for 2.23.38 according to the title page. I've downloaded the different html format, both all on one page, and one page per chapter, and they're for version 2.23.33. Is there a current version of the manual for download that's one chapter per page? Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Five (5) Product Give Away - No Conditions!
MINDLEADERS.COM INC You are subscribed as: [EMAIL PROTECTED] Good Afternoon! We are running a FREE software promotion for five (5) powerful products for our subscribers: eXpressForms ($129.99 value), DataScan business card scanner ($149.99), Fortune contact builder and relationship manager ($149.99 value), TransForm Suite "forms scanning and designer" ($59.99), VersaClips "hand crafted cliart for checks, greeting cards and brochures. a) "eXpressForms2000" is an ideal solution for tax preparation, business forms creation, greeting cards and invitations. Best of all, you can instantly post any of your forms and documents on the internet for everybody to view and fill out. The information entered is captured into your database or Excel. b) "DataScan" allows you to scan in business cards. directories and printed contact lists directly into your database without typing. c) "Fortune" helps automate your contact information, keep track of events, send mass email, faxes, letters and build a powerful database of friends, customers and useful company information. d) "TransForm Suite" lets you scan pre-printed paper forms into you PC to create electronic forms with ease. Includes OCR and raster-to-vector converter. e) "VersaClips" - images and hand crafted clipart for checks, greeting cards, web sites, documents and brochures. Offer expires May 15. ** Click on the link below and add your FREE products to the shopping cart in the check out area. http://www.g7ps.com About eXpressFroms: http://www.g7ps.com/scripts/expforms.asp About DataScan: http://www.g7ps.com/scripts/datascan.asp About Fortune: http://www.g7ps.com/scripts/fortune.asp About TransForm Suite: http://www.g7ps.com/scripts/trans.asp About VersaClips: http://www.g7ps.com/scripts/clips.asp Not valid with any other offer. Up to 5 per customer and product. * Please do not hesitate to call 800-303-2620 for any questions you may have. Thank you very much. Yours truly, Maria Stevens Customer Relations Manager G7 Productivity Systems, Inc. [EMAIL PROTECTED] 800-303-2620 To change your communication preference please click on: http://www.globalzon2k.com/scripts/mf_de.asp?[EMAIL PROTECTED] or simply reply to this Email with UNSUBSCRIBE in the subject line. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 (3.23) connection bombardment question ..
Hello .. I've been experiencing a few problems with MySQL 3.23.3[67] configured for TCP on Linux .. We have two websites which are very active, and are noticing similar behaviour with the database.. One site has about a hundred thousand users, and gets very active a few times a day.. The site does many reads and updates to the database, at the same time .. Usually during the peak times, when it seems as though everyone is logging in and using it, the database starts filling up with queries waiting for updates to complete .. It keeps going until the database server (4 processors @ 550mhz ea) gets unbearably slow, and our cluster of webservers do the same with apache's + cgi's waiting for replies from the database ... From what I've read, this is considered normal, because of the table locking nature of MySQL ... Right? Ok .. The second site does no writes to the database just strictly reads .. The database itself is also on a large server (4 cpu/550mhz), and during peak times where many users bombard the site all at once, the database seems to act similar to above .. Connections flood the system and apache's get caught waiting for a reply .. In both cases the built-in timeouts in MySQL kill the connections, but the scripts (Apache's + cgi's) don't seem to get notified and just hang around indefinately ... This may be a coding bug .. (?) I guess my question is .. Are there any known problems with MySQL receiving many instantaneous connections ? (hundreds within a few seconds .. ) For further info, I'm running linux 2.2.19 configured for up to 2000 processes (the max I've seen the server get to is around 800 .. Idling at around 60)... I've tried running the database with the database both on the local raid and currently over 1gb ethernet to a NetApp filer (incase the local raid, which is a year or so old is too slow .. ) Any ideas? Thanks, Terry Katz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Licensing Question
On Fri, Apr 27, 2001 at 07:15:59PM -0500, Alec Solway wrote: > > I'm a bit confused about whether I need to purchase a license in the > following situation. Different sources (MySQL by Paul DuBois and the > MySQL doc) differ in certain aspects, I assume the doc is more > accurate, but even still, I want to make sure. The license issue became much easier last year when MySQL moved to the GPL for their license. You don't need to buy a license, but might consider purchasing a support agreement. They're not all that expensive, but they do support the development of MySQL. 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
Licensing Question
Hi, I'm a bit confused about whether I need to purchase a license in the following situation. Different sources (MySQL by Paul DuBois and the MySQL doc) differ in certain aspects, I assume the doc is more accurate, but even still, I want to make sure. I would like to install MySQL on my server and use it as the back-end for a website. CGI programs will be written in C/C++, which handle all the MySQL access. They are linked with the mysqlclient library in order to accomplish this. The website will be of a commercial nature. I do not plan to distribute the applications, as they will be designed specifically for this site. I would generate income by running the applications myself. Do I need a license in this situation? The book mentions those who offer services that use (require) MySQL and generate income require a license, while I do not see this mentioned in the doc. The doc only mentions building software that is not free, which requires MySQL. Second situation: If others have access to my server and I would like to make MySQL accessible to them (and they pay for access to the server, however MySQL is only one of the many things offered to them), do I need a license? This may seem obvious to some, but I would like to be absolute sure. TIA Alec Solway - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What is most stable??
How stable is InnoDB, BDB, MyISAM, etc?? I am developing a production system using MySQL, and wanted to know that stability status on these table types. I wanted to use transactions if I could - is the transaction-enabled table types stable enough for production? Or should I stick with MyISAM and engineer transaction-like behavior into my code?? Thanks! Patrick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
libexec
When I run the safe_mysqld, I get the following error message: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. I don't have a folder called "libexec" in my mysql dir. Help! Thanks everybody __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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 needed with Query UPDATE INFO
Ok, a few things I see...first off, slap some keys into those tables on the join portions. Secondly, upon examining your query a second time, your never joining subsnp and locuslink. I see your trying to use a full join, but you didn't put the criteria for it in the where clause. That would cause some VERY weird join results, and may be your problem. Try adding in the join clause in the where clause. - Original Message - From: "Bryan Coon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 27, 2001 2:52 PM Subject: RE: Help needed with Query UPDATE INFO > Okay, here is the full monty from the database regarding the query in > question, any suggestions on how to improve any of it are greatly > appreciated! > > Also, if any more info is needed, just let me know. > > Thanks! > Bryan > > > QUERY: > mysql> select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as > panel, null as first_pcrp, null as second_pcrp, null as prb_seq, null as > term, null as validation, null as freq, null as population from locuslink > l, subsnp left outer join chromosome_position c on subsnp_pk = c.snp_fk > left outer join locus_annotation a on subsnp_pk = a.snp_fk where a.locusid > = substring(l.locusid, 4) and description like '%GABA%' order by subsnp_pk; > > EXPLAIN: > ++--+---+--+-+--+---+--- > --+ > | table | type | possible_keys | key | key_len | ref | rows | Extra > | > ++--+---+--+-+--+---+--- > --+ > | subsnp | ALL | NULL | NULL |NULL | NULL | 1201 | Using > temporary; Using filesort | > | l | ALL | NULL | NULL |NULL | NULL | 21294 | where used > | > | c | ALL | NULL | NULL |NULL | NULL | 579 | > | > | a | ALL | NULL | NULL |NULL | NULL | 704 | where > used; Distinct| > ++--+---+--+-+--+---+--- > --+ > 4 rows in set (0.00 sec) > > DESCRIBE: > mysql> describe locuslink; > ++--+--+-+-+---+ > | Field | Type | Null | Key | Default | Extra | > ++--+--+-+-+---+ > | LOCUSID| varchar(12) | | | | | > | SYMBOL | varchar(15) | YES | | NULL| | > | INTERIM_SYMBOL | varchar(15) | YES | | NULL| | > | MIM_NUMBER | varchar(15) | YES | | NULL| | > | CHROM | varchar(6) | YES | | NULL| | > | BAND | varchar(20) | YES | | NULL| | > | DESCRIPTION| varchar(150) | YES | | NULL| | > | SPECIES| varchar(10) | YES | | NULL| | > | SOURCESEQ | varchar(15) | YES | | NULL| | > ++--+--+-+-+---+ > 9 rows in set (0.01 sec) > > mysql> describe subsnp; > ++-+--+-+-+---+ > | Field | Type| Null | Key | Default | Extra | > ++-+--+-+-+---+ > | SUBSNP_PK | int(11) | | PRI | 0 | | > | SOURCE | varchar(40) | | | | | > | SOURCEID | varchar(20) | | | | | > | SNPPOSITION| int(11) | | | 0 | | > | TOTALSEQLENGTH | int(11) | | | 0 | | > | VARIATION | varchar(20) | YES | | NULL| | > | NUM_ALLELES| int(11) | YES | | NULL| | > ++-+--+-+-+---+ > 7 rows in set (0.00 sec) > > mysql> describe chromosome_position; > +--++--+-+-+---+ > | Field| Type | Null | Key | Default | Extra | > +--++--+-+-+---+ > | SNP_FK | int(11)| | | 0 | | > | CHROM| varchar(5) | YES | | NULL| | > | CHROMPOS | int(11)| YES | | NULL| | > +--++--+-+-+---+ > 3 rows in set (0.00 sec) > > mysql> describe locus_annotation; > +-+-+--+-+-+---+ > | Field | Type| Null | Key | Default | Extra | > +-+-+--+-+-+---+ > | SNP_FK | int(11) | | | 0 | | > | LOCUS | varchar(20) | YES | | NULL| | > | LOCUSID | int(11) | YES | | NULL| | > +-+-+--+-+-+---+ > 3 rows in set (0.00 sec) > > mysql> > > KEYS: > mysql> show keys from locuslink; > Empty set (0.00 sec) > > mysql> show keys from subsnp; > +++--+--+-+---+- > +--++--
RE: Help needed with Query UPDATE INFO
Okay, here is the full monty from the database regarding the query in question, any suggestions on how to improve any of it are greatly appreciated! Also, if any more info is needed, just let me know. Thanks! Bryan QUERY: mysql> select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as panel, null as first_pcrp, null as second_pcrp, null as prb_seq, null as term, null as validation, null as freq, null as population from locuslink l, subsnp left outer join chromosome_position c on subsnp_pk = c.snp_fk left outer join locus_annotation a on subsnp_pk = a.snp_fk where a.locusid = substring(l.locusid, 4) and description like '%GABA%' order by subsnp_pk; EXPLAIN: ++--+---+--+-+--+---+--- --+ | table | type | possible_keys | key | key_len | ref | rows | Extra | ++--+---+--+-+--+---+--- --+ | subsnp | ALL | NULL | NULL |NULL | NULL | 1201 | Using temporary; Using filesort | | l | ALL | NULL | NULL |NULL | NULL | 21294 | where used | | c | ALL | NULL | NULL |NULL | NULL | 579 | | | a | ALL | NULL | NULL |NULL | NULL | 704 | where used; Distinct| ++--+---+--+-+--+---+--- --+ 4 rows in set (0.00 sec) DESCRIBE: mysql> describe locuslink; ++--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-+---+ | LOCUSID| varchar(12) | | | | | | SYMBOL | varchar(15) | YES | | NULL| | | INTERIM_SYMBOL | varchar(15) | YES | | NULL| | | MIM_NUMBER | varchar(15) | YES | | NULL| | | CHROM | varchar(6) | YES | | NULL| | | BAND | varchar(20) | YES | | NULL| | | DESCRIPTION| varchar(150) | YES | | NULL| | | SPECIES| varchar(10) | YES | | NULL| | | SOURCESEQ | varchar(15) | YES | | NULL| | ++--+--+-+-+---+ 9 rows in set (0.01 sec) mysql> describe subsnp; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | SUBSNP_PK | int(11) | | PRI | 0 | | | SOURCE | varchar(40) | | | | | | SOURCEID | varchar(20) | | | | | | SNPPOSITION| int(11) | | | 0 | | | TOTALSEQLENGTH | int(11) | | | 0 | | | VARIATION | varchar(20) | YES | | NULL| | | NUM_ALLELES| int(11) | YES | | NULL| | ++-+--+-+-+---+ 7 rows in set (0.00 sec) mysql> describe chromosome_position; +--++--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--++--+-+-+---+ | SNP_FK | int(11)| | | 0 | | | CHROM| varchar(5) | YES | | NULL| | | CHROMPOS | int(11)| YES | | NULL| | +--++--+-+-+---+ 3 rows in set (0.00 sec) mysql> describe locus_annotation; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+ | SNP_FK | int(11) | | | 0 | | | LOCUS | varchar(20) | YES | | NULL| | | LOCUSID | int(11) | YES | | NULL| | +-+-+--+-+-+---+ 3 rows in set (0.00 sec) mysql> KEYS: mysql> show keys from locuslink; Empty set (0.00 sec) mysql> show keys from subsnp; +++--+--+-+---+- +--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +++--+--+-+---+- +--++-+ | subsnp | 0 | PRIMARY |1 | SUBSNP_PK | A | 1201 | NULL | NULL | | +++--+--+-+---+- +--++-+ 1 row in set (0.00 sec) mysql> show keys from chromosome_position; Empty set (0.00 sec) mysql> show keys from locus_annotation; Empty set (0.00 sec) mysql> - Before posting, please check: http://www.mysql.com
Re: if Linux and Win2000 dual boot is possible?
johnd wrote: > > Hi, > We have Win2000 server version installed. > If we want to install Linux on the same computer, is it possible? > How to do it? > Need install Linux first then install Win2000? > We would like to compare Linux and Win2000 work with MySQL for our application >development. > Greately appreciate for your help. > > Regards, > > John Ding John: Make sure you have the bootable partitions for both drives on the primary master. Create a 2 GBytes partition on the drive, and install Win2K. Boot up from the RH CD-ROM. Using FDisk, create your / partition on /dev/hda2 (/dev/sga2 if scsi). Set up the remaining paritions on the drive for your data, and leave at least a 2 GBytes partition for your MySQL data directory under Win2k. Use an extra drive as necessary. When Linux is installed, allow it to detect the Win2K bootable partition, and make sure you have one Win2k entry and one Linux entry in your Lilo boot selection menu. Install the boot-loader to the MBR, and it should work fine. Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help needed with Query
Please do a "SHOW FIELDS FROM" and "SHOW KEYS FROM" on all tables involved so we can see what's going on here. Also, a warning, if desacription is indexed, by doing LIKE '%GABA%' with wildcard at beginning, it won't use index's. Would also help if you did an EXPLAIN on that query and sent that. - Original Message - From: "Bryan Coon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 27, 2001 1:20 PM Subject: Help needed with Query > I am working on a mysql database with many large tables (1.5 million rows on > some) and came across a beeg problem. > > I have need for a query like this: > mysql> select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as > panel, null as first_pcrp, null as second_pcrp, null as prb_seq, null as > term, null as validation, null as freq, null as population from locuslink > l, subsnp left outer join chromosome_position c on subsnp_pk = c.snp_fk > left outer join locus_annotation a on subsnp_pk = a.snp_fk where a.locusid > = substring(l.locusid, 4) and description like '%GABA%' order by subsnp_pk; > > Which seems insane. This 4 table join in another situation would become a 6 > table join. As it is, it takes 1min 10.60 seconds for this query to return > one result. Clearly I am not a MySQL expert, and even though this query > works, there must be a better way to do this. > > Is it a matter of indexing? A matter of poor schema design? Poor query > design? Is it unavoidable? > > As far as I know, none of the tables are indexed (I did not set up the > schema). > > Please let me know if more info is required to help with this. > > 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
RE: Help needed with Query
hi. by skimming that query, the first thing that will take a long time is the 'description like "%GABA%"' part...that's a pretty inefficient method of searching due to the wildcard at the beginning of the string. if there are no indexes on the tables, you should probably add some. "show index from tablename" will tell you for sure. check out the mysql manual section re: indexes for more information...also use the keyword EXPLAIN before the select query to find out where/if indexes are being used and where they would likely be the most helpful. hth. -ravi. -Original Message- From: Bryan Coon [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 4:20 PM To: '[EMAIL PROTECTED]' Subject: Help needed with Query I am working on a mysql database with many large tables (1.5 million rows on some) and came across a beeg problem. I have need for a query like this: mysql> select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as panel, null as first_pcrp, null as second_pcrp, null as prb_seq, null as term, null as validation, null as freq, null as population from locuslink l, subsnp left outer join chromosome_position c on subsnp_pk = c.snp_fk left outer join locus_annotation a on subsnp_pk = a.snp_fk where a.locusid = substring(l.locusid, 4) and description like '%GABA%' order by subsnp_pk; Which seems insane. This 4 table join in another situation would become a 6 table join. As it is, it takes 1min 10.60 seconds for this query to return one result. Clearly I am not a MySQL expert, and even though this query works, there must be a better way to do this. Is it a matter of indexing? A matter of poor schema design? Poor query design? Is it unavoidable? As far as I know, none of the tables are indexed (I did not set up the schema). Please let me know if more info is required to help with this. 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
Kill the Query
Hi evrerybody I have recently joint this mailing list.I am a new user of Mysql, I am having a problem with mysql 3.22.32 on sun sparc netra t1.we are running an ISP and we have around 9000 to 1 users in our database. The problem is this that if some one sends any large query to check three four months accounts or cash report or any other report then it get hang, and all othere people working on mysql stuck with their current query.then i have to kill the processes then it starts working again.Can any body tell me whats goin wrong and how can i fix it. thanx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help needed with Query
I am working on a mysql database with many large tables (1.5 million rows on some) and came across a beeg problem. I have need for a query like this: mysql> select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as panel, null as first_pcrp, null as second_pcrp, null as prb_seq, null as term, null as validation, null as freq, null as population from locuslink l, subsnp left outer join chromosome_position c on subsnp_pk = c.snp_fk left outer join locus_annotation a on subsnp_pk = a.snp_fk where a.locusid = substring(l.locusid, 4) and description like '%GABA%' order by subsnp_pk; Which seems insane. This 4 table join in another situation would become a 6 table join. As it is, it takes 1min 10.60 seconds for this query to return one result. Clearly I am not a MySQL expert, and even though this query works, there must be a better way to do this. Is it a matter of indexing? A matter of poor schema design? Poor query design? Is it unavoidable? As far as I know, none of the tables are indexed (I did not set up the schema). Please let me know if more info is required to help with this. 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
mysql access problems
Why do I get message "Can't connect Mysql server throuht mysql.sock "?
Re: A question of performance?
Davin Flatten wrote:
>
> Hello everyone,
>
> I have a quick question of performance. Which is
> faster with the Perl DBI:
>
> 1. One SQL query that retrieves a large amount of data
> and then lets Perl decide what to do with each row.
> i.e. this row is a "foo1" do this, this row is a
> "foo2" do this.
>
> 2. Several SQL queries that segement the larger query
> into several small queries. i.e. Perl does this to
> all "foo1" from query #1. Perl does this to all "foo2"
> from query #2. Etc...
>
If there's a chance that in #2 you might end up operating
on a smaller dataset than in #1, you may get better
performance out of #2, if you end up fetching
fewer (rows X columns) worth of data.
But if its the same data set size no matter what,
and you are just going to do different things to it,
then as long are you are not building up large @arrays
to hold the data in some post processing stage, it
shouldn't matter. If you are aggregating the data
in large arrays, then it may again help to go with #2.
Generally, its more efficient for LARGE (10,000's+ of rows)
data sets to:
while(my $row = $sth->fetchrow_arrayref) {
... do something to $row, then output, move on ...
}
than it is to:
my $rows = $dbh->selectall_arrayref();
for my $row ( @$rows ) {
... do something ...
}
--Josh
_
Joshua Chamas Chamas Enterprises Inc.
NodeWorks >> free web link monitoring Huntington Beach, CA USA
http://www.nodeworks.com1-714-625-4051
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: Viewing data from the previous row
Actually, there is a way to do this by taking advantage of variables. If you read my previous post on the matter, you can use variables to get a cumulative total. - Original Message - From: "Steve Ruby" <[EMAIL PROTECTED]> To: "Roger Karnouk" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, April 27, 2001 12:37 PM Subject: Re: Viewing data from the previous row > Roger Karnouk wrote: > > > > Is it possible in a Select query to get values from the previously read row > > in order to do things like cumulative sums or other formulas which require > > the previous value in order to calculate the current value. > > > > ex. > > day current sales cumu_total > > - --- > > 1 120 120 > > 2 60 180 > > 3 125305 > > 4 40 345 > > > > I'd like to be able to do this in one select statement > > is this even possible? > > > > Roger Karnouk > > [EMAIL PROTECTED] > > > > > You can totalize all numbers but there isn't really any way in sql > to do cross-row type functions as you indicated? Why can't you do the > running some in whatever program is generating the output? > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: Viewing data from the previous row
Roger Karnouk wrote: > > Is it possible in a Select query to get values from the previously read row > in order to do things like cumulative sums or other formulas which require > the previous value in order to calculate the current value. > > ex. > day current sales cumu_total > - --- > 1 120 120 > 2 60 180 > 3 125305 > 4 40 345 > > I'd like to be able to do this in one select statement > is this even possible? > > Roger Karnouk > [EMAIL PROTECTED] > You can totalize all numbers but there isn't really any way in sql to do cross-row type functions as you indicated? Why can't you do the running some in whatever program is generating the output? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 question of performance?
Hello everyone, I have a quick question of performance. Which is faster with the Perl DBI: 1. One SQL query that retrieves a large amount of data and then lets Perl decide what to do with each row. i.e. this row is a "foo1" do this, this row is a "foo2" do this. 2. Several SQL queries that segement the larger query into several small queries. i.e. Perl does this to all "foo1" from query #1. Perl does this to all "foo2" from query #2. Etc... I know this is really not specific enough for a concrete answer but I was just wondering which is 'generally' more efficient. Just wonderin' Thanks. -Davin __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.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
SU permission definition
Attempting to define an admin user that can connect from any host. Host='%', user='admin', password=PASSWORD(xxx), all _priv values are 'Y' when launching "./mysql -u admin -p mysql" and entering password, I get: "./mysqladmin: connect to server at 'localhost' failed "error: 'Access denied for user: 'admin@localhost' (Using password: YES)' I thought '%' in host means "any host". What am I missing? (and I DID read The Fine Manual...) Regards, Fred Atlanta - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: if Linux and Win2000 dual boot is possible?
Hi I have this very set up. I use System Commander from VCommunications. Also I run Win2000 in a VMWare virtual machine under Linux. MySQL runs fine using either method At 09:57 27/04/1999 -0400, johnd wrote: >Hi, >We have Win2000 server version installed. >If we want to install Linux on the same computer, is it possible? >How to do it? >Need install Linux first then install Win2000? >We would like to compare Linux and Win2000 work with MySQL for our >application development. > Greately appreciate for your help. > >Regards, > >John Ding Regards John -- MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / John Dean <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mansfield, England, UK <___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
starting and stopping mysql
# mysql.server stop # mysql.server start gives me a permission denied. Is there another way to start the daemon? Manatee - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Failed to compile.
All seemed to be going well untill... sr/local/include/mysql -c get_table.cc g++ -O3 -g -pipe -fforce-mem -fforce-addr -I. -I../mysql++-1.7.8/sqlplusint -I/usr/local/include/mysql -c admin.cc g++ -O3 -g -pipe -fforce-mem -fforce-addr -I. -I../mysql++-1.7.8/sqlplusint -I/usr/local/include/mysql -c single.cc g++ -O3 -g -pipe -fforce-mem -fforce-addr -I. -I../mysql++-1.7.8/sqlplusint -I/usr/local/include/mysql -c zoom.cc g++ -O3 -g -pipe -fforce-mem -fforce-addr -I. -I../mysql++-1.7.8/sqlplusint -I/usr/local/include/mysql -c sin_jpeg.cc gcc -O3 -g -pipe -fforce-mem -fforce-addr -I. -I../mysql++-1.7.8/sqlplusint -I/usr/local/include/mysql -c jmemsrc.c jmemsrc.c: In function `jpeg_mem_src': jmemsrc.c:198: warning: assignment from incompatible pointer type gcc -O3 -g -pipe -fforce-mem -fforce-addr -I. -I../mysql++-1.7.8/sqlplusint -I/usr/local/include/mysql -c options.c options.c:17: warning: initialization from incompatible pointer type options.c: In function `mysql_read_default_options': options.c:40: warning: initialization makes pointer from integer without a cast options.c:135: structure has no member named `charset_dir' options.c:136: structure has no member named `charset_dir' options.c:139: structure has no member named `charset_name' options.c:140: structure has no member named `charset_name' make: *** [options.o] Error 1 root@nova:/usr/local/mysqlgui-1.7.4# eric -- Eric K. Dickinson CNE, MCSE, GNU/Linux Geek http://dickinse.dyndns.org NRA Indoor Pistol Master - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Manual
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Thanks to all for their suggestions. NuSphere is 'expensive' because they sell a commercial product, a one stop MySQL shop. I thought about burning a PDF file on CD, but decided against it. I'll probably pick up the MySQL book by Paul Dubois. -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.1 Int. for non-commercial use Comment: Have A NORML Day iQA/AwUBOum2V6iBx49EaaTxEQK9EgCgs3g3xl+GGBGMdEnI/GLTBKkYCmMAnjIY N0dZ3+SPFaRRBLoWnDwlkL1r =LGqv -END PGP SIGNATURE- Rodney D. Myers <[EMAIL PROTECTED]> Member of Digital Freedom Alliance Amateur: KG6ANXGMRS: WPOM592 ICQ# : 18002350Have A NORML Day - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Viewing data from the previous row
Is it possible in a Select query to get values from the previously read row in order to do things like cumulative sums or other formulas which require the previous value in order to calculate the current value. ex. day current sales cumu_total - --- 1 120 120 2 60 180 3 125305 4 40 345 I'd like to be able to do this in one select statement is this even possible? Roger Karnouk [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
Problems with MOD
Why do I get the following results? mysql> select (1008306000-988344000)/86400/7, mod((1008306000-988344000)/86400,7.); ++-- + | (1008306000-988344000)/86400/7 | mod((1008306000-988344000)/86400,7.) | ++-- + |33.0060 |0 | ++-- + 1 row in set (0.00 sec) Shouldn't the value in Column 2 be some number other then 0? I'm running MySQL 3.23.27. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL question
It sounds like you might have some stray ' characters in your text
You didn't give much information, but let me see if I can't figure out kinda
what your doing...
Your using perl, so I assume your going to be using DBI. In DBI you have
your statement handles, or do statements. That means your inserts are going
to be one of two ways:
$dbh->do('query');
or:
$sth = $dbh->prepare('query');
$sth->execute();
Whichever way your doing it, use the prepare method, I'll show you why.
When you do a prepare, you can put in things called placeholders, so if you
needed to insert into table_a 2 values ($header,$body) you would do this:
$sth = $dbh->prepare('INSERT INTO table_a VALUES (?,?)'); #Note the ?'s are
the placeholders
$sth->execute($header,$body); #The arguments passed to execute go into the
placeholders
What this does is it has DBI automatically escape out special characters,
because it knows exactly where they need to go.
If neither of these are the case, please give us some more information (the
code where your inserting the data etc..)
- Original Message -
From: "Chris Herold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2001 10:26 PM
Subject: RE: MySQL question
> hi--
>
> firstly, I am relatively new to mysql.
>
> I am having a problem getting text I enter into a perl script (for reasons
> of parsing and sending to my mysql database) to consistently get entered
> into the database.
>
> the perl script takes a mail message and makes the body of the message
> "$body". It then pulls the first bit of the body to make the "$header"...
> this is then written to the database. All very simple.
>
> when i run a simple text body through the program it is picked up, parsed
> and correctly sent to the mysql database table specified. When I try a
> number of other texts of same or very similar formats, I found that only a
> quarter to a half of them get written to the database.
>
> this is very confusing because I have it set upin the perl script that all
> the parsed values ($body and $header) are e-mailed to my address so I can
> confirm the script worked correctly on the text in question.
>
> And in every case it did ... based on the e-mail.
>
> So then, why am I getting selective acceptance of data strings into my
mysql
> database?
>
> Is this something that others have suffered with that you may be able to
> help me with?
>
> As a note: the mysql I use is run through PhpMyAdmin.
>
> thanks,
>
> chris herold
> [EMAIL PROTECTED]
> 858-534-5875
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> 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: mail all users in MySQL database
\n\nDatabase Administrator";
$subject = "Your Subject here";
mail("$email","$subject","$message","FROM:[EMAIL PROTECTED]\nBCC:your
[EMAIL PROTECTED]");
}
} else {
$error = mysql_error();
echo"your sql statement : $sql generated the following error :
$error";
}
?>
HTH
--
Stephen Johnson
[EMAIL PROTECTED]
http://www.pets4u.com
Owner / Founder
-- your next best friend is waiting for 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
Question About Integration
Hello Friends at MySQL : Above all, I want to greet you and thanks for given us a great opportunity to have a stable, reliable and free database. By the current time, I'm working with MS-SQLSERVER. It works fine and the tables has the common datatypes known ( datetime, char, numeric, etc ). My developer is Power Builder 7.0.3 Build 10047. I would like to make a test with MySQL. I mean, I dont need to modify a line of script, but need to install you database software. I have my own tables definition and would like to know, when installed and created the tables it must work without problems. How reliable is MySQL ? Is MySQL able to handle all my information in the same way as MS-SQLSERVER ? Thanks for clearing up and for your ideas. Good Luck, Javier Barbieri - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AIX recommendations
This note is primarily meant to stuff something into the archives in case other people have problems compiling mysql under AIX. There are a number of changes that need to be made that aren't detailed in the documentation, (some alteration to those docs could save someone a lot of effort in the future). I don't know how universal this is so I will say that this works under AIX 4.2.1 for mysql 3.23.37 using gcc 2.95.3 To begin with, you may need to use the following config as opposed to the one given in the docs... CC="gcc -pipe -mcpu=power -Wa,-many" \ CXX="gcc -pipe -mcpu=power -Wa,-many" \ CXXFLAGS="-felide-constructors -fno-exceptions -fno-rtti" \ ./configure --prefix=/usr/local/mysql --with-low-memory The key change here is the -mcpu, the docs specify power2, but that causes compiles on older equipment to toss out bad assembly code. Determine what your cpu is if you are experiencing errors that indicate that problem. Typically power2, power, or powerpc may need to be used, alternatively you might need to use 604 or 604e. I'm not positive but I would think using "power" would likely be safe most of the time, even on a power2 machine. If you don't know what your cpu is then do a "uname -m", this will give you back a string that looks like "000514676700", with a format of xxyymmss where xx and ss are always 0's, yy is a unique system id and mm is the id of the CPU Planar. A chart of these values can be found at http://www.rs6000.ibm.com/doc_link/en_US/a_doc_lib/cmds/aixcmds5/uname.htm This will give you a machine type and a machine model you can use to determine what type of cpu you have. Next, after configuring, edit config.h and change the line that says #define HAVE_SNPRINTF 1 to #undef HAVE_SNPRINTF Do the same for include/my_config.h There is probably a better way to handle that that would address the issue for the entire source but I didn't take the time to find it nor did I stumble across it. And finally, in mysqld.cc you need to add a prototype for initgoups. #ifdef _AIX41 extern "C" int initgroups(const char *,int); #endif After doing this, I had a version of mysql that I could compile and install. Hopefully there aren't any bugs waiting for me as a result of these changes. I'm seeing test failures for tests rpl15 and rpl16 that I haven't dug into yet but everything else looks ok. Darren Henderson [EMAIL PROTECTED] [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with LEFT JOIN and MIN
>Description: When i want to find the next unused id from a table joining it whith another table the result is allways 1, even though this is not correct >How-To-Repeat: create table a (id int not null primary key); create table b (id int not null primary key); insert into a values (1),(2),(3),(4),(5),(6),(7),(8); insert into b values (1),(2),(3),(5),(6); select min(a.id) from a left join b on a.id = b.id where b.id is null; +---+ | min(a.id) | +---+ | 1 | +---+ >Fix: The problem can be fixed whith the following select select min(a.id) from a left join b on a.id = b.id where b.id is null and a.id is not null; +---+ | min(a.id) | +---+ | 4 | +---+ even though the a.id never is null. >Submitter-Id: >Originator: >Organization: - / \ | Ole Lund Jensen | | Groenjordsvej 1, st., -1114 | | DK-2300 Koebenhavn S | | Tlf.: (+45) 32 87 60 13 | | e-mail: [EMAIL PROTECTED] | \ / - > >MySQL support: none >Synopsis: ?? >Severity: non-critical >Priority: low >Category: mysql >Class: sw-bug >Release: mysql-3.23.36 (Source distribution) >Environment: System: OSF1 gram V4.0 878 alpha Architecture: alpha Machine: alpha Some paths: /usr/local/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/alpha-dec-osf4.0d/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='cc -pthread -std1' CFLAGS='' CXX='cxx -pthread -O' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root system17 Jul 5 1998 /lib/libc.a -> ../ccs/lib/libc.a lrwxrwxrwx 1 root system17 Jul 5 1998 /usr/lib/libc.a -> ../ccs/lib/libc.a Configure command: ./configure '--with-named-thread-libs=-lpthread -lmach -lexc -lc' --with-low-memory --enable-large-files --prefix=/var/mysql/v3.23.36 --with-mysqld-ldflags=-all-static -disable-shared Perl: This is perl, version 5.004_04 built for alpha-dec_osf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
User id and password
How do i create a username and password in mySQL. Also please advise me how can i create tables mySQL. Sorry for very basic questions. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: if Linux and Win2000 dual boot is possible?
Yes it's possible and quite easy no matter which one you install first, but this is a mysql mailing list. You can find everything you need at http://www.linux.org jason - Original Message - From: "johnd" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 27, 1999 11:57 PM Subject: if Linux and Win2000 dual boot is possible? Hi, We have Win2000 server version installed. If we want to install Linux on the same computer, is it possible? How to do it? Need install Linux first then install Win2000? We would like to compare Linux and Win2000 work with MySQL for our application development. Greately appreciate for your help. Regards, John Ding - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
if Linux and Win2000 dual boot is possible?
Hi, We have Win2000 server version installed. If we want to install Linux on the same computer, is it possible? How to do it? Need install Linux first then install Win2000? We would like to compare Linux and Win2000 work with MySQL for our application development. Greately appreciate for your help. Regards, John Ding
Need MySQL hel
How do I fix this error: "MySQL Connection Failed: Access denied for user: 'mysql_user@server' (Using password: YES)" Even I am unable to use database Kindly help me... _ 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
cannot run mysql_install_db
To Whom It May Concern: I am following the install procedures from the current documentation manual and trying to install mysql version 3.23.37-pc-linux-gnu-i686 in RedHat version 7.0. When I try to run the mysql_install_db in the scripts directory, it comes back stating that I should try to run make make install. When I try to do that, it says nothing to make. Any help would be greatly appreciated. TIA Sincerely, Shawn M. Campbell LBMC I.S. Specialist A+; MCP V - (615) 309-2223 F - (615) 309-2523 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Migration Oracle => MySQL
I'm not sure how this happend but Mikel didn't write that. Could some one kindly forward me the original for the snippet below, including the headers...? Thanks, Mikel Ray Cote wrote: > At 4:44 PM -0400 4/26/01, Mikel wrote: > > > I'm trying to create a perl script that just produces a MySQL compliant > >> SQL file based on the tables from Oracle, but I can't get everything work, > >> like indexes etc.. > > Do you mean you cannot figure out how to find the index definitions from Oracle? > > If so, head on over to CPAN and check out a package with the name something like >Oracle-DDL. This little package will export whatever pieces of your schema you need: >tables, indexes, views, etc. > > Ray > -- > --- > Raymond Cote, President Appropriate Solutions, Inc. > www.AppropriateSolutions.com [EMAIL PROTECTED] > 603.924.6079(v) POB 458, Peterborough, NH 03458603.924.8668(f) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug in mysqldump
[EMAIL PROTECTED] writes:
> >Description:
>Mysqldump does not work correcly. Some data from some tables are not
>dumped.
>ex) Tabledef.
> +--+--+--+-+-+---+
> | Field| Type | Null | Key | Default | Extra |
> +--+--+--+-+-+---+
> | bug_id | mediumint(9) | | MUL | 0 | |
> | who | mediumint(9) | | | 0 | |
> | bug_when | datetime | | MUL | -00-00 00:00:00 | |
> | thetext | mediumtext | YES | | NULL| |
> +--+--+--+-+-+---+
>
> Rows with bug_when > "end of 2000" are not dumped.
>
> >How-To-Repeat:
>
> >Fix:
>
>
> >Submitter-Id:jonash
> >Originator:
> >Organization: Gatespace AB
>
> >MySQL support: none
> >Synopsis:Bug in mysqldump
> >Severity:serious
> >Priority: medium
> >Category:mysql
> >Class: sw-bug
> >Release: mysql-3.23.37 (Source distribution)
>
> >Environment:
>
> System: SunOS crocodile.crt.se 5.7 Generic_106541-10 sun4u sparc SUNW,Ultra-5_10
> Architecture: sun4
>
> Some paths: /q/pd/perl/bin/perl /q/pd/bin/make /q/pd/bin/gmake /q/pd/bin/gcc
> GCC: Reading specs from /q/pd/lib/gcc-lib/sparc-sun-solaris2.7/2.95.3/specs
> gcc version 2.95.3 20010315 (release)
> Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='-L/q/pd/lib
>-R/q/pd/lib'
> LIBC:
> -rw-r--r-- 1 root bin 1696732 Mar 14 2000 /lib/libc.a
> lrwxrwxrwx 1 root root 11 Apr 4 2000 /lib/libc.so -> ./libc.so.1
> -rwxr-xr-x 1 root bin 1115336 Mar 14 2000 /lib/libc.so.1
> -rw-r--r-- 1 root bin 1696732 Mar 14 2000 /usr/lib/libc.a
> lrwxrwxrwx 1 root root 11 Apr 4 2000 /usr/lib/libc.so -> ./libc.so.1
> -rwxr-xr-x 1 root bin 1115336 Mar 14 2000 /usr/lib/libc.so.1
> Configure command: ./configure --prefix=/q/pd/mysql --sysconfdir=/etc/mysql
>--localstatedir=/var/mysql --enable-raid --without-debug --with-berkeley-db
>--with-innodb
> Perl: This is perl, version 5.005_03 built for sun4-solaris
>
> -
Hi!
What table type is the above table ?? If MyISAM have you used RAID
option on it ??
Also, can you check whether that table is corrupted ??
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mail all users in MySQL database
Dear Clay Bond, I am really new to PHP, Can you please kindly let me know a code snippet to do the same? i.e. while loop etc. Thanks Love and regards Prasad - Original Message - From: "clay bond" <[EMAIL PROTECTED]> To: "*MySQL mail list" <[EMAIL PROTECTED]> Sent: Friday, April 27, 2001 4:45 PM Subject: Re: mail all users in MySQL database On Fri, 27 Apr 2001, Prasad Mhatre wrote: > Dear All, > > Can anyone suggest a link where I can find a script in PHP3 to mal all users > in MySQL database? That's pretty simple, isn't it? Pull the usernames from the table, then put mailto:$email>link ?> or something like that in a while loop ... -- /"\ \ / ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \ AND POSTINGS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: error can't create database (error 13)
At 20:45 26/04/01 -0700, Brent and Maria wrote: Hi, I guess that your problem is the permission of the user that you made the login. Take a look to permission properties in the \mysql\data directory. Regards, Miguel >Hello List, > I have recently installed mysql 3.23.33 on my windows 2000 > machine. I don't see anything in the documentation that I need to do to > my machine for setup (after the installation). I can run mysql fine, but > it seems to be only able to read. I want to create a new database. I > try to do this in mysql and using mysqladmin create dbName. I get the error: > >mysqladmin: Create failed; error: 'Can't create database 'dbName'. (errno: >13)' > >Has anyone run into this? I am making a beginner mistake? I would >appreciate any one to point me in the right direction. > Thanks, > Brent > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >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
Re: mail all users in MySQL database
There is a php mail tutorial at http://www.phpdeveloper.org/tutorial.php Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - Original Message - From: "Prasad Mhatre" <[EMAIL PROTECTED]> To: "*MySQL mail list" <[EMAIL PROTECTED]> Sent: Friday, April 27, 2001 6:55 AM Subject: mail all users in MySQL database > Dear All, > > Can anyone suggest a link where I can find a script in PHP3 to mal all users > in MySQL database? > > Thanks > Love and regards > Prasad > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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: mail all users in MySQL database
On Fri, 27 Apr 2001, Prasad Mhatre wrote: > Dear All, > > Can anyone suggest a link where I can find a script in PHP3 to mal all users > in MySQL database? That's pretty simple, isn't it? Pull the usernames from the table, then put mailto:$email>link ?> or something like that in a while loop ... -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
upgrade / database problem?
Am running Redhat 7.0, and had installed. 3.23.22. with php4.0. Would like to upgrade to 3.23.32. No existing tables or data. Any major problems anyone having with .32 version on 7.0 redhat? Also, any special steps to upgrade rpm and keep php4.0 intact? What add'l libraries are needed? What about existing tables / data? Will it affect exsiting database. Thanx Marc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mail all users in MySQL database
Dear All, Can anyone suggest a link where I can find a script in PHP3 to mal all users in MySQL database? Thanks Love and regards Prasad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Manual
Hi There There are two books that I know of that are about SQL. www.amazon.com I use a book and web site to get the full pic...! Simon PS Book is $34.95...! -Original Message- From: Robert Vetter [mailto:[EMAIL PROTECTED]] Sent: 27 April 2001 10:04 To: [EMAIL PROTECTED] Subject: Re: MySQL Manual Jeremy Zawodny wrote: > > On Thu, Apr 26, 2001 at 07:36:34PM -0700, Rodney D. Myers wrote: > > > > Is there a place to purchase the MySQL manual? > > The folks at NuSphere will sell you one for $79 or so. You'll get a > CD, printed manual, and support for the software. What? I hope you don't mean US-Dollars. If you do - it's much much too expensive, to express it in a friendly manner. I just took the PDF manual, burned a CD-ROM and went to a copy shop, where they printed and binded it. Robert -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug in mysqldump
>Description: Mysqldump does not work correcly. Some data from some tables are not dumped. ex) Tabledef. +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | bug_id | mediumint(9) | | MUL | 0 | | | who | mediumint(9) | | | 0 | | | bug_when | datetime | | MUL | -00-00 00:00:00 | | | thetext | mediumtext | YES | | NULL| | +--+--+--+-+-+---+ Rows with bug_when > "end of 2000" are not dumped. >How-To-Repeat: >Fix: >Submitter-Id: jonash >Originator: >Organization: Gatespace AB >MySQL support: none >Synopsis: Bug in mysqldump >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.37 (Source distribution) >Environment: System: SunOS crocodile.crt.se 5.7 Generic_106541-10 sun4u sparc SUNW,Ultra-5_10 Architecture: sun4 Some paths: /q/pd/perl/bin/perl /q/pd/bin/make /q/pd/bin/gmake /q/pd/bin/gcc GCC: Reading specs from /q/pd/lib/gcc-lib/sparc-sun-solaris2.7/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='-L/q/pd/lib -R/q/pd/lib' LIBC: -rw-r--r-- 1 root bin 1696732 Mar 14 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Apr 4 2000 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 root bin 1115336 Mar 14 2000 /lib/libc.so.1 -rw-r--r-- 1 root bin 1696732 Mar 14 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Apr 4 2000 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 root bin 1115336 Mar 14 2000 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/q/pd/mysql --sysconfdir=/etc/mysql --localstatedir=/var/mysql --enable-raid --without-debug --with-berkeley-db --with-innodb Perl: This is perl, version 5.005_03 built for sun4-solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Manual
Jeremy Zawodny wrote: > > On Thu, Apr 26, 2001 at 07:36:34PM -0700, Rodney D. Myers wrote: > > > > Is there a place to purchase the MySQL manual? > > The folks at NuSphere will sell you one for $79 or so. You'll get a > CD, printed manual, and support for the software. What? I hope you don't mean US-Dollars. If you do - it's much much too expensive, to express it in a friendly manner. I just took the PDF manual, burned a CD-ROM and went to a copy shop, where they printed and binded it. Robert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 start and stop automatically
Hi... i'd like to ask about how to set MySQL start and stop automatically when machine reboot. We are using Redhat 6.0 and MySQL 3.23.36 thankyou - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 a (better) query.
I have 3 tables that I am joining together based on that fact that one (or more) values appear in the 2nd table, but those values that need to appear are garnered from the 3rd table (and i want the id that is associated by the 1st table). Err well, an example would be better: Table 1: id -> int whatiwant -> int Table 2: id -> int table1_id -> int table3_id -> int Table 3: id -> int value -> varchar The relationship is for every record in table 1, you can have 0 to (as many different records their are in table 3) in table 2, and Table 3 is a seperate table that just holds a bunch of values. My query would be then, as such: ## SELECT ##COUNT(table1.id) AS total, ##table1.whatiwant ## FROM ##table1,table2,table3 ## WHERE ##table2.table1_id = table1.id ## AND ##(table3.id = table2.table3_id ## AND ##(table3.value = 'some' ## OR table3.value = 'needed' ## OR table3.value = 'values' ##) ##) ## GROUP BY ##table1.id ## HAVING ##total = 3; which basiclly is a way to get a correspondance between table3 and table1 via table2. What this will give me are all the record in table1 which have all the values i want from table3 associated via table2 (there can be more then 3, or less then 3). And the value I want is that record in table1 that satifies all those requirements. The above query does work. BUT!!! am I doing something laughably wrong? This query requires that for each "OR" statement in table3, all values are looked at in table2, then grouped, and then the only ones returned are those that group to the same number of OR's we are looking for. I have got to think this is inefficient. Anyone have suggestions? Comments? Anything? Thanks, --jim When I read about the evils of drinking, I gave up reading. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
