error in confguring mysql
Dear mysql, I have a problem when I want to configure mysql-3.23.32 from source distribution ( mysql-3.23.32.targz) . Below, I enclose the message after I configure mysql. For your information, I use DEC OSF/1 V4.0 878 alpha as my platform. Also, I have some question. Does mysql support for DEC OSF/1 V4.0 paltform. Because from your web site, I didn't see OSF/1 in list of OS that mysql suports. I just see that your site provide alppha version of mysql for OSF/1. Please, Correct me if I am wrong and please feel free to inform me. Best Regards, Syarief tabernakel.ai.astra.co.id ./configure --prefix=/usr/local/mysql loading cache ./config.cache checking host system type... alpha-dec-osf4.0d checking target system type... alpha-dec-osf4.0d checking build system type... alpha-dec-osf4.0d checking for a BSD compatible install... ./install-sh -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes checking for working aclocal... missing checking for working autoconf... missing checking for working automake... missing checking for working autoheader... missing checking for working makeinfo... missing checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for gawk... gawk checking for gcc... no checking for cc... cc checking whether the C compiler (cc ) works... yes checking whether the C compiler (cc ) is a cross-compiler... no checking whether we are using GNU C... no checking whether cc accepts -g... yes checking for c++... no checking for g++... no checking for gcc... no checking for CC... no checking for cxx... no checking for cc++... no checking for cl... no checking whether the C++ compiler (gcc ) works... no configure: error: installation or configuration problem: C++ compiler cannot create executables.
content of a MySQL-Database on searchable CD-ROM?
Good morning, we want to create a bibliographical database with ca. 500.000 entries and a very simple structure (3 tables) to publish it on the internet (with PHP and Apache). A second aim is to make a CD for those, who cannot always be online. It should be usable like the CD-ROMs you normally get with computer journals: put it into your CD-drive and open it with your browser on any operating system (at least Linux, Mac and Windows). Is there any tool to produce such a CD from a MySQL database, so that the user can browse through it and also search for specific items without installing any new software on the system? Of course, MySQL is free and so we could put it on the CD or ask the people to install it over the net, but I can imagine, that many people would not like to do so. Thanks for any suggestions Bernd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbee Question !
Dear lists members, I gonna download MySQL and PHP to install on my machine. But the problem is that I don't know which tarballs are required to do from mysql.com and php.net. I mean I would like to manage databases using HTML interface (MySQL/PHP). Any points or links to the web sites are highly appreciated. Thank you very much indeed. TK Tech (Linux Newbee) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql and transactions and perl DBI
Good morning! Where is mistake? my $dbh=DBI-connect("DBI:$driver:$database:$hostname",$user,$pass,{AutoCommit=0}); my $sth=$dbh-prepare(q{ insert into test.Pokus (a,b) values (?,?) }); foreach my $a ("a","b","c","d") { $sth-execute($a,$a); } $dbh-commit; $dbh-disconnect; Perl error: Transactions not supported by database at /usr/lib/perl5/5.6/i386-linux/DBI.pm line 433 I use: Debian GNU/Linux sid (i386) MySQL 3.23.31 DBI 1.14 BDB::mysql 1.2215 table Pokus is BerkeleyDB type Thanks for your answer. Bye Marek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newbee Question !
Oh...Yeah I forgot to mention it. It's Red Hat kernel 2.2.16. Apache x.x.19. Browser Mozilla/Netscape. I would like also to verify all users to give their Username/Password to access my database. This Computer gonna be both Server for my team project and Client for me. I mean I'll test and manage the databases too. Thanks again. On Thu, 25 Jan 2001, Jorma Jakowitsch wrote: It would be best to know what kind of Linux you have? SuSE? Mandrake? whatever.. What kind of Computer? Depending on this information it IS very easy to find the required tarballs Hope it helps - Jim -Original Message- From: Khuon Tech [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 10:10 AM To: MySQL forum Subject: Newbee Question ! Dear lists members, I gonna download MySQL and PHP to install on my machine. But the problem is that I don't know which tarballs are required to do from mysql.com and php.net. I mean I would like to manage databases using HTML interface (MySQL/PHP). Any points or links to the web sites are highly appreciated. Thank you very much indeed. TK Tech (Linux Newbee) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: content of a MySQL-Database on searchable CD-ROM?
if your going to view it with a browser why not include the browser on the CD? and set the home to the first page? At 10:02 AM +0100 1/25/01, Bernd Kulawik wrote: Good morning, we want to create a bibliographical database with ca. 500.000 entries and a very simple structure (3 tables) to publish it on the internet (with PHP and Apache). A second aim is to make a CD for those, who cannot always be online. It should be usable like the CD-ROMs you normally get with computer journals: put it into your CD-drive and open it with your browser on any operating system (at least Linux, Mac and Windows). Is there any tool to produce such a CD from a MySQL database, so that the user can browse through it and also search for specific items without installing any new software on the system? Of course, MySQL is free and so we could put it on the CD or ask the people to install it over the net, but I can imagine, that many people would not like to do so. Thanks for any suggestions Bernd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Apache - MySQL - PHP (Auto-start Apache)
You don't configure apache to do this, since apache has no idea when the server boots up... You have to edit your start-up scripts which are mostly in /etc/rc.d to start up apache. There's a huge number of ways to do this (to script it) ie with error checking/without error checking with mail on error etc etc depending on your distribution you then have to add files to run level directories (links) or have to do run level checking in the start-up scripts which isn't explained that easy. Knowing which distribution you use could prove very helpful :-) On Tue, 23 Jan 2001, John Halladay wrote: I'm currently running Apache 1.3.12, MySQL 3.22.32-1, and PHP 4.0.3 together on RedHat 7.0 and everything works fine, although every time I boot up I have to manually start the Web Server with command /usr/local/apache/bin/apachectl start. Does anyone know how to configure Apache so that it will start up automatically when I boot up Linux? (I know it's a little off the MySQL subject, but I figured someone would have a similar setup.) Thanks, John Halladay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Best way to duplicate a table in a running database?
What is wrong with the CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [select_statement] syntax. Note that you can append a SELECT statement to a CREATE statement to automatically add rows to the new table. Read the following manual sections: http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/S/i/Silent_column_changes.html Guy Waugh wrote: Hi there, One of my users wants to copy a large table. He normally does this through PHPMyAdmin, but the table seems too large for the web browser to handle, and it times out. I'm using mysql version 3.22.32-log on a RedHat Linux 6.2 (Intel) box. The file system is on a hardware RAID array. Can I simply copy the files associated with the table via the OS shell (e.g. 'cp table_name.ISD new_table_name.ISD' etc.) and expect MySQL to know about it? Will I need to create the indexes for the table manually, or will MySQL do that automatically? Do I need to update any database records so that MySQL will know about the table (and indexes)? Alternatively, is there an SQL command I could use to do this? If so, is it any better/worse/safer/unsafer than doing a file system copy? Please excuse my lack of knowledge - MySQL usually just runs along without any problems, so i haven't had to touch it much yet ;-) Thanks, Guy. -- Guy Waugh [EMAIL PROTECTED], tel. 61+2 6620 3196 Unix Team, Information Technology Services Southern Cross University Military Rd, Lismore NSW 2480 Australia. -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Ignoring duplicate records during bulk import
You will need to add a primary key to the column in your table that will uniquely identify a record. The IGNORE keyword only ignores records that would generate a "duplicate key" error if there is already a record in the table with the same key value. So, use ALTER TABLE and add a primary key to one of your columns. "---==[bolMyn]==---" wrote: Well, it seems like nobody wants to bite the question I posted a few days ago about ignoring duplicate records during bulk import. So I thought, that maybe answer was so obvious that I could not miss it. I found the following: "LOAD DATA [LOW_PRIORITY] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY '\t'] [[OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ] ] [LINES TERMINATED BY '\n'] [IGNORE number LINES] [(col_name,...)]" The part which I found confusing was: INFILE 'file_name.txt' [REPLACE | IGNORE] because there was 'IGNORE' clause down below. There is no better way to find out the results like testing. So, I exported first a few thousands records from one of my tables and then, imported them back using the above syntax. What I did was: LOAD DATA INFILE '/tmp/myfile.txt' INGORE INTO TABLE mytable If I understand this syntax correctly, MySQL was supposed to skip duplicate records from my import file which were identical to the ones in the table. Well, nothing like that happened. MySQL happily 'imported' all the records, consequently accepting duplicates. My question is: "What gives?" What is a correct syntax to avoid duplicates? MySQL version I'm running is 3.22.32, running on Linux kernel 2.2.18 (RH 6.2 distro). Sent via Deja.com http://www.deja.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: Select not working selectively
You have read the manual? http://www.mysql.com/doc/F/u/Full_table.html Nathan Cook wrote: When I run this query on a 20,000 record table with 18 fields. The table has some identical entries and I am trying to get a count of those entries descending. SELECT email, fname, lname, count(email) as emailcount FROM referralSpace GROUP BY email ORDER BY emailcount ASC LIMIT 0,10 I get the error: The table 'SQL4a5b_0' is full, Does this error mean a temporary table is full? What can I do to get this query to work. Thank You P.S. The query works on an similar table with 10 fields 10,000 records. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OT - Cron
Hi, I`ve been searching for hours now so I thought I`d ask some lists I belong to, does anyone know of a decent CRON tutorial??? TIA Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: OT - Cron
Actually now I look thats not the one i mean ;=( sorry - cant find the one i was looking for http://www.lfix.co.uk/oliver/linux.mail.crontab.html HTH D - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 9:56 AM Subject: OT - Cron Hi, I`ve been searching for hours now so I thought I`d ask some lists I belong to, does anyone know of a decent CRON tutorial??? TIA Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Drop Database
Hi! I was testing some queries and now I've created a database named "#Muffin", and I cannot drop it! I've tried the following: DROP DATABASE #Muffin DROP DATABASE '#Muffin' DROP DATABASE "#Muffin" But it doesn't work! Please help! / David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: OT - Cron
take your time and read man crontab - Original Message - From: "Derek Almond" [EMAIL PROTECTED] To: "Derek Almond" [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 1:25 PM Subject: Re: OT - Cron Actually now I look thats not the one i mean ;=( sorry - cant find the one i was looking for http://www.lfix.co.uk/oliver/linux.mail.crontab.html HTH D - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 9:56 AM Subject: OT - Cron Hi, I`ve been searching for hours now so I thought I`d ask some lists I belong to, does anyone know of a decent CRON tutorial??? TIA Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Drop Database
David, Firstly are you sure it`s a database you have created and not a table? Either way try the following DROP DATABASE #Muffin; or DROP TABLE #Muffin; HTH Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JDBC Driver
Hey dudes I'm having some troubles accessing a Mysql database with Java thru basic JDBC Drivers. Looks like when the java code doesn't receive any replies to its query, it stalls and I'm stuck with a dead process. Which basically annoys me :) Can anyone confirm or infirm the fact that JDBC driver with mysql doesn't work like a charm ? Later all And thanks -- Mark Villemade Hosting/Communication Tools Technical Manager Multimania - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Drop Database
Hi! Yes, it is a database. I recieve these errors, regardless if I use the semi-colon: Query: DROP DATABASE #Muffin Returns: ERROR 1064: You have an error in your SQL syntax near '' Query: DROP DATABASE '#Muffin' Returns: ERROR 1064: You have an error in your SQL syntax near ''#Muffin'' I assume the # character is the bandit I can also mention it's mysql-version 3.23.23-beta Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: den 25 januari 2001 11:45 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Drop Database David, Firstly are you sure it`s a database you have created and not a table? Either way try the following DROP DATABASE #Muffin; or DROP TABLE #Muffin; HTH Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with BDB Tables : some times mysqld down ...
Description : I am use mysql with bdb tables. My front end is make in PHP 4.0.4. And since i have installed bdb support, some times my ServerMysql (mysqld) down !!! And i lost all my data bases !! Before this, i dont can repair the tables which use bdb tables, and i lost every datas !! I sorry for my english ... but i try ... How-To-Repeat: I dont no !! Some times DOWN !! Fix: Its my question !! Submitter-Id: submitter ID Originator: Antonio Organization: Pessoal MySQL support: none Synopsis: Mysqld down when i use bdb tables Severity: critical Priority: high Category: mysql Class: support Release:mysql-3.23.29-gamma (Official MySQL binary) Environment: machine, os, target, libraries (multiple lines) System: Linux monsite_desenvolve 2.2.14-5.0 #1 Tue Mar 7 21:07:39 EST 2000 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors' LDFLAGS='-static' Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
isamchk / myisamchk return error 22
i am trying to run isamchk / myisamchk on some table files in my database. the tables are read just fine from the mysql terminal and the ANALYZE TABLE query returns no errors, yet the isamchk / myisamchk say"error: 22 when opening ISAM-table ... " the file name is correct ( i get a totaly different response when i try to run it on a wrong name or if i don't have permission fot that file. ) doesn't anyone have any idea how to deal with this ?
PROJECT (for perl/sed/regex person)
I've got a quickie project here, that's over my head, that I could pay a little something for: Can you set up a script that will take flat text files, (one file per record, many files per directory) - and do some sed/regex conditional replace, and turn it into MySQL statements? I've done one, below, but don't know how to automate the process. TIMELINE: by this weekend, January 27 PAYPOINT: $100 (done as a perl, shell, or PHP script that can scan a set directory for incoming text files, run your process on each one, then feed each one into MySQL.) - INCOMING FILE: name=John Jacob Schmidt addr=1313 Willamena Way username=asdfhjkl artistname=The Beatles albumname=Can't Get Enough description: One of the best albums they ever made. Really one of the finest. Oh yes i mean it truly. @END@ price=15 songs: track=1 title=Michelle track=2 title=Taxman track=3 title=Tomorrow Never Knows @END@ - OUTGOING FILE: insert into clientinfo ( name='John Jacob Schmidt', addr='1313 Willamena Way', username='asdfhjkl'); insert into albuminfo ( albumcode=concat('username', now()), artistname='The Beatles', albumname='Can\'t Get Enough', description='One of the best albums they ever made. Really one of the finest. Oh yes i mean it truly.', price='15'); insert into songs ( albumcode='$albumcode', // the auto-generated one track='1', title='Michelle') insert into songs ( albumcode='$albumcode', track='2', title='Taxman'); insert into songs ( albumcode='$albumcode', track='3', title='Tomorrow Never Knows'); NOTE: Most fields are only one line, so the carriage return is the stopping point. But as you see there are just a few that have carriage returns, so on those we do "fieldname:" instead of "fieldname=" - then end it with "@END@" -- Derek Sivers, CD Baby [EMAIL PROTECTED] (503)595-3000 www.cdbaby.com | www.cdbaby.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PROJECT: for perl/sed/regex type...
I've got a quickie project here, that's over my head, that I could pay a little something for: Can you set up a script that will take flat text files, (one file per record, many files per directory) - and do some sed/regex conditional replace, and turn it into MySQL statements? I've done one, below, but don't know how to automate the process. TIMELINE: by this weekend, January 27 PAYPOINT: $100 (done as a perl, shell, or PHP script that can scan a set directory for incoming text files, run your process on each one, then feed each one into MySQL.) - INCOMING FILE: name=John Jacob Schmidt addr=1313 Willamena Way username=asdfhjkl artistname=The Beatles albumname=Can't Get Enough description: One of the best albums they ever made. Really one of the finest. Oh yes i mean it truly. @END@END@ price=15 songs: track=1 title=Michelle track=2 title=Taxman track=3 title=Tomorrow Never Knows @END@END@ - OUTGOING FILE: insert into clientinfo ( name='John Jacob Schmidt', addr='1313 Willamena Way', username='asdfhjkl'); insert into albuminfo ( albumcode=concat('username', now()), artistname='The Beatles', albumname='Can\'t Get Enough', description='One of the best albums they ever made. Really one of the finest. Oh yes i mean it truly.', price='15'); insert into songs ( albumcode='$albumcode', // the auto-generated one we used in the previous table track='1', title='Michelle') insert into songs ( albumcode='$albumcode', track='2', title='Taxman'); insert into songs ( albumcode='$albumcode', track='3', title='Tomorrow Never Knows'); NOTE: Most fields are only one line, so the carriage return is the stopping point. But as you see there are just a few that have carriage returns, so on those we do "fieldname:" instead of "fieldname=" - then end it with "@END@END@" More details if you're interested, but that's about it. The actual file is twice as big, but with no other surprises. (That's an actual example, above, just with some lines taken out.). Please reply by email, not to the whole list. Thanks! -- Derek Sivers [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: Change character set
Firstly, upgrade to 3.23.x as with 3.22 you will need to compile from sources to change character sets. Next, read the following section in the manual: http://www.mysql.com/doc/L/a/Languages.html -- Richard Ellerbrock [EMAIL PROTECTED] [EMAIL PROTECTED] 2001/01/25 01:50:33 Hello, I am working with a MySQL 3.22.32 on Linux. I would like to change the character set of MySQL from latin1 to greek because it doesn't work right with the greek words and data. (sorting is not functioning well) Can you tell me how I can change the default character set from latin1 to greek. Thank you Spyridon N Kaparelis Computer Engineer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: write problems via MS Access 97 in table with timestamp and primary key
Ensure that your TIMESTAMP definition is a TIMESTAMP(14). If it is, identify which workstations are failing and compare MDAC versions against those that are not failing (we are using MDAC 2.5 ). Upgrade/downgrade MDAC as appropriate. In any case, be sure to refresh all the link tables in MS Access. If some workstations still fail, delete the link tables in MS Access and set up link tables again. I hope this helps... Pat... [EMAIL PROTECTED] - Original Message - From: "John Jensen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 1:55 PM Subject: Re: write problems via MS Access 97 in table with timestamp and primary key I used to get this all the time, myself, when I was trying to update a mysql database with Access 2000 through myodbc. Funny, at the time, nobody else seemed to understand what I was talking about. Once I got phpMyAdmin working, the problem became academic, but it never did get solved. I'm still trying to find a solution to my $FORMATQUERY ORDER BY problem with a logic function on two values. Baring a solution, I can only hope for a workaround before a year of effort is not wasted, because someone else beat me to market. Please, this does not need to be a volunteer effort. If anyone thinks they can solve this, contact me directly and we can work something out. On 24 Jan 2001, at 6:34, Bob Hall wrote: One of our users is getting the message "another user has changed this database..etc save changes to clipboard or drop changes... etc", when he tries to update certain fields in the table. The table has a timestamp and a primary key. In fact, this user can change certain fileds without difficulty for certain types of data and not for others (i.e. Access accepts changes when the data is a document but not when its a collection). To make things more confusing., other users can change all fields in the same table via Access without receiving the error message. Any one else had and solved this problem? Susan Albright Ma'am, this is an ODBC problem, not a MySQL problem. I assume that the table is a linked table in Access. How is it accessed? Directly, through a query, or through a form? Are there any joins? Does the problem occur only through a query or form that joins the table with another table? What do you mean by 'the data is a document' and 'its a collection'? These aren't MySQL or Jet datatypes. What is the user who's having problems doing that the other users aren't doing? Things that people have done to solve this include dropping and adding primary keys and timestamp fields, setting up relationships between tables as much as possible (you can set up a relationship between linked tables, but I don't think you can specify what the relationship is), and selecting UniqueRecords in queries (DISTINCTROW in SQL). 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 John Jensen 520 Goshawk Court Bakersfield, CA 93309 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
oriented objetc database
hello there; can someone give me any suggestions for what DBMS should i use for implantation of an oriented object databases. thank's - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 there;
i don't know what should i do to configurate the odbc driver with mysql. can somone give me a procedure for release this operation - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problem on installing MySQL in AIX powerPC
Hyup Cho writes: Dear MySQL supporter, I tried to install MySQL version 3.23.32 on our AIX machine but got errors. Source compilation also failed. Here are the situation I worked and attached are error log files. Binary Installation released file : mysql-3.23.32-ibm-aix4.3.3.0-rs6000.tar.gz error log from executing mysqlbug script : mysqlbug error display on monitor : mysqlCmdLog Source Compilation released file : mysql-3.23.32.tar.gz (tarball version) error log : mysqlSrcCmpErrLog Symptom : there is no libpthread.a in the system library. Instead, libpthreads.a in the /lib directory. I copied libpthreads.a to libpthread.a but it failed again. Thanks. Hyup Cho ([EMAIL PROTECTED]) Hi! All you have to do is build MySQL from the sources according to the manual. Regarding binary that yo uhave tried, is it the same AIX version and is it the same CPU ?? Seems like you are using powerPC, and a binary is built on RS/6000. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, 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: Apache - MySQL - PHP (Auto-start Apache)
(quicky coz this is way off topic): ln -s /usr/local/apache/bin/apachectl /etc/rc.d/init.d/httpd ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc3.d/S90httpd ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc5.d/S90httpd ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc6.d/K90httpd That should do it. Should bring up your httpd whether you're running runlevel 3 (command line) or runlevel 5 (X windows) on redhat whatever version. (I think). You can use the same scheme for starting mysqld too (excuse for posting to list) *duck* Freaked Personality wrote: You don't configure apache to do this, since apache has no idea when the server boots up... You have to edit your start-up scripts which are mostly in /etc/rc.d to start up apache. There's a huge number of ways to do this (to script it) ie with error checking/without error checking with mail on error etc etc depending on your distribution you then have to add files to run level directories (links) or have to do run level checking in the start-up scripts which isn't explained that easy. Knowing which distribution you use could prove very helpful :-) On Tue, 23 Jan 2001, John Halladay wrote: I'm currently running Apache 1.3.12, MySQL 3.22.32-1, and PHP 4.0.3 together on RedHat 7.0 and everything works fine, although every time I boot up I have to manually start the Web Server with command /usr/local/apache/bin/apachectl start. Does anyone know how to configure Apache so that it will start up automatically when I boot up Linux? (I know it's a little off the MySQL subject, but I figured someone would have a similar setup.) Thanks, John Halladay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
password mysql
we are just getting started using mysql and want to develop an admin password access section for our site using cold fusion mysql. Is thier a site with examples of this type of thing ? Thanks, Byron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_float::val_str crash in 3.23.32
Kevin Day writes: Description: I'm getting a pretty consistant crash in mysqld: /usr/ports/databases/mysql323-server/work/mysql-3.23.32/sql/mysqld: ready for connections Program received signal SIGSEGV, Segmentation fault. 0x282ae35c in bcopy () from /usr/lib/libc_r.so.4 (gdb) bt #0 0x282ae35c in bcopy () from /usr/lib/libc_r.so.4 #1 0x282c00a8 in _thread_autoinit_dummy_decl () from /usr/lib/libc_r.so.4 #2 0x282afcca in __dtoa () from /usr/lib/libc_r.so.4 #3 0x282adb3b in vfprintf () from /usr/lib/libc_r.so.4 #4 0x282abc56 in vfprintf () from /usr/lib/libc_r.so.4 #5 0x2829d4cd in sprintf () from /usr/lib/libc_r.so.4 #6 0x80633e0 in Field_float::val_str (this=0x9175410, val_buffer=0xbf7f046c, val_ptr=0xbf7f046c) at field.cc:1847 #7 0x8061921 in Field::send (this=0x9175410, packet=0x8adcc20) at field.cc:257 #8 0x8132c59 in Item_field::send (this=0x8e4ea70, str_arg=0x8adcc20) at item.h:119 #9 0x806ac67 in select_send::send_data (this=0x8e4e6a8, items=@0x8adca4c) at sql_class.cc:236 #10 0x809a36d in end_send (join=0xbf7f0778, join_tab=0x8b72868, end_of_records=false) at sql_select.cc:4521 #11 0x80998d6 in sub_select (join=0xbf7f0778, join_tab=0x8b72750, end_of_records=false) at sql_select.cc:4033 #12 0x8099567 in do_select (join=0xbf7f0778, fields=0x8adca4c, table=0x0, procedure=0x0) at sql_select.cc:3925 #13 0x8091957 in mysql_select (thd=0x8adc800, tables=0x8e4e0d8, fields=@0x8adca4c, conds=0x8e4e5c8, ftfuncs=@0x8adca80, order=0x8e4e688, group=0x0, having=0x0, proc_param=0x0, select_options=8950784, result=0x8e4e6a8) at sql_select.cc:755 #14 0x8079299 in mysql_execute_command () at sql_parse.cc:957 #15 0x807c29e in mysql_parse (thd=0x8adc800, inBuf=0x8e4e010 "SELECT * FROM cp WHERE C11=1 C12=1.0 C13=1.0 PL1 0 ORDER BY C4 DESC", length=80) at sql_parse.cc:2085 #16 0x8078458 in do_command (thd=0x8adc800) at sql_parse.cc:668 #17 0x8077800 in handle_one_connection (arg=0x8adc800) at sql_parse.cc:403 #18 0x282419a7 in _thread_start () from /usr/lib/libc_r.so.4 #19 0xbee93ffc in ?? () #20 0x80738db in create_new_thread (thd=0x8e27780) at mysqld.cc:2056 #21 0x81c2c00 in ?? () Error accessing memory address 0x2: Bad address. (gdb) up #1 0x282c00a8 in _thread_autoinit_dummy_decl () from /usr/lib/libc_r.so.4 (gdb) up #2 0x282afcca in __dtoa () from /usr/lib/libc_r.so.4 (gdb) up #3 0x282adb3b in vfprintf () from /usr/lib/libc_r.so.4 (gdb) up #4 0x282abc56 in vfprintf () from /usr/lib/libc_r.so.4 (gdb) up #5 0x2829d4cd in sprintf () from /usr/lib/libc_r.so.4 (gdb) up #6 0x80633e0 in Field_float::val_str (this=0x9175410, val_buffer=0xbf7f046c, val_ptr=0xbf7f046c) at field.cc:1847 warning: Source file is more recent than executable. 1847sprintf(to,"%.*f",dec,nr); (gdb) print dec $1 = 2 '\002' (gdb) print nr $2 = 999204736 (gdb) print to $3 = 0xbf7f047c "1" This bug was not present in 3.22.32, and only became evident when we skipped to 3.23. How-To-Repeat: Right now, using the "adcycle" package hits it within 10-15 minutes of use on a heavily loaded site. Fix: Submitter-Id: submitter ID Originator:Kevin Day Organization: stileproject.com MySQL support: none Synopsis: Crash in mysqld Field_float::val_str in 3.23.32 Severity: critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.32 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: FreeBSD server4.stileproject.com 4.2-RELEASE FreeBSD 4.2-RELEASE #0: Fri Sep 29 22:40:46 CDT 2000 [EMAIL PROTECTED] Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1169076 Nov 20 05:59 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Sep 26 19:13 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 559196 Nov 20 05:59 /usr/lib/libc.so.4 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl Perl: This is perl, version 5.005_03 built for i386-freebsd Hi! It could be a bug in FreeBSD C library. Also, you should not use MIT threads on FreeBSD 4.*. Please apply all available patches to your system, or try a contributed binary for FreeBSD that was uploaded on our site today. It is statically built, so it should work just fine. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
Re: Change character set
This problem is with charset support not by languages. I have also this problem, but at the moment nobody doesn't say anything about this. I am sure so this is a problem in new MySQL 3.23.xx, with oldes version everything was fine. Boril - Original Message - From: "Richard Ellerbrock" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 2:06 PM Subject: Re: Change character set Firstly, upgrade to 3.23.x as with 3.22 you will need to compile from sources to change character sets. Next, read the following section in the manual: http://www.mysql.com/doc/L/a/Languages.html -- Richard Ellerbrock [EMAIL PROTECTED] [EMAIL PROTECTED] 2001/01/25 01:50:33 Hello, I am working with a MySQL 3.22.32 on Linux. I would like to change the character set of MySQL from latin1 to greek because it doesn't work right with the greek words and data. (sorting is not functioning well) Can you tell me how I can change the default character set from latin1 to greek. Thank you Spyridon N Kaparelis Computer Engineer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
BDB Check tables
Hello monty, As I remember according to documentation MYSQL should support check table on BDB tables: `CHECK TABLE' only works on `MyISAM' and `BDB' tables. On `MyISAM' tables it's the same thing as running `myisamchk -m table_name' on the table. Therefore it does not: mysql check table layers_la01.g00layers_stat_hits; +-+---+--++ | Table | Op| Msg_type | Msg_text | | +-+---+--++ | layers_la01.g00layers_stat_hits | check | error| The handler for the table |doesn't support check/repair | +-+---+--++ 1 row in set (0.00 sec) and this is also thrue for any table mysql create table t (t int) type=BDB; Query OK, 0 rows affected (0.30 sec) mysql check table t; ++---+--++ | Table | Op| Msg_type | Msg_text | ++---+--++ | test.t | check | error| The handler for the table doesn't support check/repair | ++---+--++ 1 row in set (0.01 sec) -- Best regards, Peter mailto:[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: Drop Database
Yes I've tried that, but it didn't work either... But now I recieved a "Database Muffin doesn't exist"-error instead! /d -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mikel King Sent: den 25 januari 2001 09:14 To: David Lidstrm Cc: Mysql@Lists. Mysql. Com Subject: Re: Drop Database Hi David, Have you tried DROP DATABASE "\#Muffin" ; ? Cheers, Mikel David Lidstrm wrote: Hi! I was testing some queries and now I've created a database named "#Muffin", and I cannot drop it! I've tried the following: DROP DATABASE #Muffin DROP DATABASE '#Muffin' DROP DATABASE "#Muffin" But it doesn't work! Please help! / David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Drop Database
Outside of MySQL, use a native OS command to rename or remove the directory named '#Muffin' . If you rename it 'foobar', you should be able to DROP it with MySQL. Cheers, Kent Hoover - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Drop Database
Yes! This worked! I shut down mysqld, renamed the folder and then I could use a regular DROP query to get rid of the database! Thank you for the help, and all answers! Regards David -Original Message- From: Kent Hoover [mailto:[EMAIL PROTECTED]] Sent: den 25 januari 2001 14:55 To: [EMAIL PROTECTED] Subject: RE: Drop Database Outside of MySQL, use a native OS command to rename or remove the directory named '#Muffin' . If you rename it 'foobar', you should be able to DROP it with MySQL. Cheers, Kent Hoover - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Syntax problem: mysqladmin start-slave
What is the CORRECT syntax for the mysqladmin command to start the slave thread at a particular position in the log? Here's the situation I ran into. I got an error message in the slave's .err file that said the following: 010125 9:11:16 Error running query, slave aborted. Fix the problem, and re-start the slave thread with mysqladmin start-slave - log 'FIRST' position 1544 When I tried to restart the slave according to the syntax in the error, I get the following: mymach2:/usr/local/mysql/var $ mysqladmin start-slave - log 'FIRST' position 1811 Slave started ../bin/mysqladmin: Unknown command: '-' when I looked at the .err file, it said this: 010125 9:32:44 Slave: connected to master 'userrep@mymach1:3306', replication started in log 'FIRST' at position 0 The slave thread did not start at position 1811 as I intended to start it at. Any help is appreciated. Kannan _ 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: Best way to duplicate a table in a running database?
On Thu, Jan 25, 2001 at 01:43:17AM -0800, Richard Ellerbrock wrote: What is wrong with the CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [select_statement] syntax. Note that you can append a SELECT statement to a CREATE statement to automatically add rows to the new table. Read the following manual sections: http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/S/i/Silent_column_changes.html He said he is using 3.22.32. Does that work in 3.22.xx? I thought it was 3.23.xx specific. Guy Waugh wrote: Hi there, One of my users wants to copy a large table. He normally does this through PHPMyAdmin, but the table seems too large for the web browser to handle, and it times out. I'm using mysql version 3.22.32-log on a RedHat Linux 6.2 (Intel) box. The file system is on a hardware RAID array. Can I simply copy the files associated with the table via the OS shell (e.g. 'cp table_name.ISD new_table_name.ISD' etc.) and expect MySQL to know about it? Will I need to create the indexes for the table manually, or will MySQL do that automatically? Do I need to update any database records so that MySQL will know about the table (and indexes)? Alternatively, is there an SQL command I could use to do this? If so, is it any better/worse/safer/unsafer than doing a file system copy? Please excuse my lack of knowledge - MySQL usually just runs along without any problems, so i haven't had to touch it much yet ;-) Thanks, Guy. -- Guy Waugh [EMAIL PROTECTED], tel. 61+2 6620 3196 Unix Team, Information Technology Services Southern Cross University Military Rd, Lismore NSW 2480 Australia. -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: OT - Cron
Ade, Try: http://www.ocsny.com/main/index.ocs?url=osl It should have what you need. Cheers, Mikel [EMAIL PROTECTED] wrote: Hi, I`ve been searching for hours now so I thought I`d ask some lists I belong to, does anyone know of a decent CRON tutorial??? TIA Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
large tables?
hi, i've been asked to design a for a new web-based system which stores lots of data on it's members. There are currently about 500,000 member records. the problem is that i have to store at least 248 pieces of information on each user. i've made the system as relational as possible so that for each user record, i am only storing integers, for the most part tinyints and smallints. Is there a limit on the number of fields per record. I can easily see this new system requiring 300 fields(columns). what are the consequences for making a table with so many columns. this table will be updated very frequently - will access time degrade severely even though i use mainly ints in this table? thanks for your help. anna
Changing a Table name
Hi, Is there a quick and simple way to change the name of a Table that is contained within my database? Thanks, Don - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What now?
Is /usr/local/mysql/bin/ within your PATH environment? What happens when you type the full path to the command: /usr/local/mysql/bin/mysql ? Jonathan - Original Message - From: "Evan James Dembskey" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 9:24 AM Subject: What now? Hi, I followed the instructions in the manual for installing the MySQL source distribution. I used mysql-3.23.32.tar.gz under CLOS 1.2 and everything seems to have gone smoothly - there were no error messages. If I run ps I see that something called safe_mysqld is running. However, no matter in which directory or under which user I run mysql I get the error "command not found". However, the file mysql does exist in the /usr/local/mysql/bin directory. As I saw no error messages, and I don't know where to look for any, this is all the info I have. What could I have done wrong? Where can I start looking for a solution? Regards, Evan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Berkeley Tables under NT!
I'd like to know if is possible to use Berkeley Tables under MySql Nt version and if the answer is YES, I'd like to know how do I install and use these facility! Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Best way to duplicate a table in a running database?
Woops! Sorry, but I somehow missed the version number. Yes. You could probably shutdown the server, copy the relevant files making sure the permissions are correct and then restart the server. I would rather upgrade to 3.23.x though! -- Richard Ellerbrock [EMAIL PROTECTED] [EMAIL PROTECTED] 2001/01/25 04:42:43 On Thu, Jan 25, 2001 at 01:43:17AM -0800, Richard Ellerbrock wrote: What is wrong with the CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [select_statement] syntax. Note that you can append a SELECT statement to a CREATE statement to automatically add rows to the new table. Read the following manual sections: http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/S/i/Silent_column_changes.html He said he is using 3.22.32. Does that work in 3.22.xx? I thought it was 3.23.xx specific. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Changing a Table name
Of course there is... ALTER TABLE name RENAME newname ; Of course you can find this sort of thing in the manual of even on Quetin Smith's SQL reference site... http://comclub.dyndns.org:8081/sqlref/ Cheers, Mikel Don wrote: Hi, Is there a quick and simple way to change the name of a Table that is contained within my database? Thanks, Don - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: parallel Mysql ?
Hi! "Jeremy" == Jeremy D Zawodny [EMAIL PROTECTED] writes: Jeremy On Wed, Jan 24, 2001 at 10:04:36AM -0800, Steven Roussey wrote: Jeremy I'm not sure that this discussion belongs here anymore, so I'll set Jeremy the reply-to and hope the list software respects it. What about scaling read _and_ write performance? Is there a plan for allowing multiple master replication, or some other method of clustering? Jeremy Well, you can do that today (sort of) with 2-way replication, but that Jeremy depends on your implementation. The biggest issue, of course, is how Jeremy to resolve conflicts. Ideally there could be some user-supplied logic Jeremy to do that (maybe an add on foo.so can be used--in the same way that Jeremy you can build a UDF today and tell the server about it). Also related is how do we provide failover? If one machine goes down and repliction is active, then the slave can become the failover. But how do we bring the other server backup and take over master status? Jeremy Isn't that what the first entry here: Jeremy http://www.mysql.com/doc/T/O/TODO_future.html Jeremy is about? Jeremy Obviously it doesn't hint at the actual implementation. And I'm sure Jeremy several of us would like to understand it once it is figured out. It Jeremy has come up more than once in recent discussions here. We have folks Jeremy wondering how it will fit in with the way we'd like to see fail-over Jeremy work. We plan to use the following algorithm on top of our current replication code to achieve this: http://www.fault-tolerant.org/recall/ Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Q] I need to pass one database from the computer A to computer B, they have MySQL installed
Hi, I have been designing a database in a computer 'A' with MySQL, now i've finished and i need to copy the database to the computer 'B' which is also with MySQL. The computers operating system is Linux Mandrake 7.2. Where does it store the MySQL databases? , the name of the database is 'Administrator', so, suposse that it stores the databases in the directory /usr/mysql/databases/Administrator in the computer 'A', i copy the directory '/Administrator' to the computer 'B' in the same directory '/usr/mysql/databases/Administrator' (i don't know anything about, if i'm in a wrong way please make me know) How can i make mySQL know that in the computer 'B' there is a new Database to manage?. -i want to know which instruction do i have to use to make this- Well, Thank you William M. _ Do You Yahoo!? Get your free @yahoo.com address at http://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
Patch to add restart to mysql.server rc start script
Dear All Here is a quick / obvious hack to supportfiles/mysql.server.sh to add restart command. I added this as I sometimes do a hard restart, and thought it may be of use to others. Can this be patched to the one in the source by someone with CVS rights - it should not break anything ;-) Greg --- mysql.server.sh.bak Thu Jan 25 15:23:38 2001 +++ mysql.server.sh Thu Jan 25 15:29:50 2001 @@ -147,9 +147,14 @@ fi ;; + 'restart') +$0 stop +$0 start +;; + *) # usage -echo "usage: $0 start|stop" +echo "usage: $0 start|stop|restart" exit 1 ;; esac - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Changing a Table name
ALTER TABLE $old_name RENAME $new_name Boril - Original Message - From: "Don" [EMAIL PROTECTED] To: "msql list" [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 4:59 PM Subject: Changing a Table name Hi, Is there a quick and simple way to change the name of a Table that is contained within my database? Thanks, Don - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
OpenBSD 2.8 update / Add to FAQ please
Hi all. I had the OpenBSD problems others have reported, with slow response, high load/cpu usage, crashes, etc. Sinisa reported a month or so ago it was a bug in the 2.8 threading library. I wrote to the OpenBSD developers, and they had made changes to libc_r which solved mysql problems for another user. I updated my libc_r source code to -current, compiled and installed the new libc_r* files into /usr/lib, and my mysql problems seem to have disappeared. All problems we were having before have stopped, at least for the most part. I'd like to suggest two things are added to the FAQ. First, that OpenBSD 2.8 has a threading bug that will cause various problems with MySQL. That'd have saved me a lot of time. Secondly, also add that as of today's date the -current branch of libc_r mostly or completely fixes the problem for i386. A side note, when trying to work around this we were trying the mit-pthreads version we had trouble with the alias ALIGN() which OpenBSD also defines. The solution we used was just to add "#undef ALIGN" before the ALIGN declaration in the 4-5 .h files where it is used. After this, mit-pthreads compiled on 2.8 without any further problem. Considering mit-pthreads will never want to use an OS ALIGN() instead of it's own, perhaps add this #undef to the distribution, or add it conditional on detecting OpenBSD. Thanks, -Jonathan --- Jonathan Roy - [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: PROJECT: for perl/sed/regex type...
see LDIF parsing. Derek Sivers wrote: I've got a quickie project here, that's over my head, that I could pay a little something for: Can you set up a script that will take flat text files, (one file per record, many files per directory) - and do some sed/regex conditional replace, and turn it into MySQL statements? I've done one, below, but don't know how to automate the process. TIMELINE: by this weekend, January 27 PAYPOINT: $100 (done as a perl, shell, or PHP script that can scan a set directory for incoming text files, run your process on each one, then feed each one into MySQL.) - INCOMING FILE: name=John Jacob Schmidt addr=1313 Willamena Way username=asdfhjkl artistname=The Beatles albumname=Can't Get Enough description: One of the best albums they ever made. Really one of the finest. Oh yes i mean it truly. @END@END@ price=15 songs: track=1 title=Michelle track=2 title=Taxman track=3 title=Tomorrow Never Knows @END@END@ - OUTGOING FILE: insert into clientinfo ( name='John Jacob Schmidt', addr='1313 Willamena Way', username='asdfhjkl'); insert into albuminfo ( albumcode=concat('username', now()), artistname='The Beatles', albumname='Can\'t Get Enough', description='One of the best albums they ever made. Really one of the finest. Oh yes i mean it truly.', price='15'); insert into songs ( albumcode='$albumcode', // the auto-generated one we used in the previous table track='1', title='Michelle') insert into songs ( albumcode='$albumcode', track='2', title='Taxman'); insert into songs ( albumcode='$albumcode', track='3', title='Tomorrow Never Knows'); NOTE: Most fields are only one line, so the carriage return is the stopping point. But as you see there are just a few that have carriage returns, so on those we do "fieldname:" instead of "fieldname=" - then end it with "@END@END@" More details if you're interested, but that's about it. The actual file is twice as big, but with no other surprises. (That's an actual example, above, just with some lines taken out.). Please reply by email, not to the whole list. Thanks! -- Derek Sivers [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Berkeley Tables under NT!
Harja Robert writes: I'd like to know if is possible to use Berkeley Tables under MySql Nt version and if the answer is YES, I'd like to know how do I install and use these facility! Thanks! Hi! This feature for Win32 is in the works. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, 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: newbie question re: manual tutorial
Well, I loaded mySQL 3.23.32 onto my RedHat 6.2, kernel 2.2.14-5.0 box, and the installation appears to have gone well. I ran through the problem selects in the tutorial and of course it works properly. (Tutorial steps at http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#Exam ples ) (yes, some newbies read the docs!) I will now have to attempt removal of mySQL from my RH 7.0 box and install this latest version. What I find terribly troubling is that the 7.0 box is a straight off the disk install of Linux w/mySQL on a clean machine and this "silent" failure occurred. What if the error had not been so significant? Thanks for the suggestions I rec'd from this group. John Wallace - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Uninstalling and Troubleshooting RPM
I am very frusturated as of right now. I have a mysql database that doesn't work on Cobalt Raq3. I installed the RPM version and guess what the mysql.sock file isn't there and ther server gives me this error when starting: Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended Then it gives me when i connect with command prompt mysql Can't connect can't connect through mysql.sock and it may not exist I am so frusturated now all I want to do is uninstall this rpm and install the source files. The bottom line is that the command rpm -e filename doesn't work it gives me an error filename is not installed. The truth is it is installed and I want it to work. I will be happy for a solution to either to fix this sock problem or uninstall this software all 3 rpm's(client,server, and devel) so I can just install the source tarball. Any suggestions 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
RE: Uninstalling and Troubleshooting RPM
Sir, What OS are you running? What version of MySQL are you trying to install? What RPMs are you trying to install? - Scott -Original Message- From: lkeeton [mailto:[EMAIL PROTECTED]] Sent: January 25, 2001 10:56 AM To: [EMAIL PROTECTED] Subject: Uninstalling and Troubleshooting RPM I am very frusturated as of right now. I have a mysql database that doesn't work on Cobalt Raq3. I installed the RPM version and guess what the mysql.sock file isn't there and ther server gives me this error when starting: Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended Then it gives me when i connect with command prompt mysql Can't connect can't connect through mysql.sock and it may not exist I am so frusturated now all I want to do is uninstall this rpm and install the source files. The bottom line is that the command rpm -e filename doesn't work it gives me an error filename is not installed. The truth is it is installed and I want it to work. I will be happy for a solution to either to fix this sock problem or uninstall this software all 3 rpm's(client,server, and devel) so I can just install the source tarball. Any suggestions 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I am failing to optimize this left join ...
Hi. I have a query which works and is quick, but it misses a couple of records. SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Preview.Blurb FROM ArgumentCalendar , CaseID , Parties , Preview WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND Preview.CASEID = CaseID.CASEID AND '20001001' = ArgumentCalendar.Date AND ArgumentCalendar.Date = '20010630; I needed to _also_ select the records which don't have a corresponding record in Preview, so I threw in a left join: SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Blurb FROM ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date The second query works correctly with the left join, but now mysql looks at all 19000 records in Parties (according to EXPLAIN) and the query takes about 15 seconds to execute. I have fiddled and read fiddled more, but I have failed to speed up this query. If I change the order around or add another left join I have removed the problem with the Parties table, but then EXPLAIN says all 19000 CaseID records are being examined. Without the LEFT JOIN MySQL only looks at all the ArgumentCalendar all the Preview records, which are like 63 and 150 respectively. With the Left Join I select 61 records, without it 59 (which is as expected -- the issue is just speed). I am using MySQL 3.22.25. Am I screwed or is there some syntactic SQL point I am missing? - BLH - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: large tables?
Hi. I find that 1-to-1 relationships are often useful appropriate, and they would help you reduce the number of columns per row. For instance in some db of people, addresses, salary info, medical info, c, --although they could be jammed into one giant row per person, make perfect sense in separate tables with a person-key linking rows in these tables to rows in the person table in a one-to-one relationship. This assumes these 248 piece of data have some logical internal structure that would group them into sets that could describe some entity. My 2 cents. - Brian Hughes Web Developer/Programme Analyst LII, Cornell Law School At 02:52 PM 1/25/2001 +, you wrote: hi, i've been asked to design a for a new web-based system which stores lots of data on it's members. There are currently about 500,000 member records. the problem is that i have to store at least 248 pieces of information on each user. i've made the system as relational as possible so that for each user record, i am only storing integers, for the most part tinyints and smallints. Is there a limit on the number of fields per record. I can easily see this new system requiring 300 fields(columns). what are the consequences for making a table with so many columns. this table will be updated very frequently - will access time degrade severely even though i use mainly ints in this table? thanks for your help. anna - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
CREATE DATABASE not replicated in the slave server
CREATE DATABASE command is not replicated in the slave server. The database is created on the master but not on the slave. The SQL statement does not appear in the replication log file on the MASTER. I have set the master to ignore replicating one database on the master. Is this causing MySQL from replicating any new databases created onn the master? Any help is appreciated. Kannan my.cnf in the MASTER: log-bin=/usr/local/mysql/var/replication.log server-id=1 binlog-ignore-db=old my.cnf in the SLAVE: master-host=mymach1 master-user=userid master-password=passwd server-id=2 log-slave-updates log-bin=/usr/local/mysql/var/slave.log MYSQL Version Info: mysql Ver 11.11 Distrib 3.23.31, for hp-hpux11.00 (hppa2.0w) _ 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: OT - Cron
Don't you hate it when someone just tells you to read the man files? They seem to be written for C programmers with Unix background. Essential System Administration from O'Reilly has a pretty good tutorial. I just got through researching crontab to set up automatic backup on a new tape drive. (Talk about poor documentation!) Here is what worked for me: EDITOR=pico (or whatever you prefer) export EDITOR crontab -e (this creates a functional copy) It will look something like this: SHELL=/bin/bash PATH=/sbin:/bin:[put your run directory here] MAILTO=[username to send reports to] HOME=/ (if you are running as root, else use your own, but tape tar requires root access) # run-parts 01 03 * * * [path to file to execute] (this entry executes at 3:01 am every night.) The positions are as follows: minute hour day-of-month month weekday command (omit username) The command(s) you direct it to can be simple bash commands saved to a text file. Remember to chmod the last bit on with an odd number, so it will be recognized as executable i.e. chmod 665 (filename). My backup program consists of two lines: tar cvf /dev/st0 /var tar rvf /dev/st0 /etc which saves two directory trees to tape. To be kosher, it is supposed to start with: #!/bin/bash but I found it worked fine without. I can't tell you how many times I struggled with: tar cvf /dev/nst0 because tutorials told me it would save without rewinding. It executes as if nothing is wrong, but nothing gets saved. Good luck. Now if I can just find someone who can help me get over my hurdle. On 25 Jan 2001, at 4:56, [EMAIL PROTECTED] wrote: Hi, I`ve been searching for hours now so I thought I`d ask some lists I belong to, does anyone know of a decent CRON tutorial??? TIA Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen Jensen's Directories www.college-without-classes.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: I am failing to optimize this left join ...
Try this one: SELECT STRAIGHT_JOIN ArgumentCalendar.Docket , ArgumentCalendar.Date , DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Blurb FROM ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date On 25 Jan 2001 13:17:14 -0500, Brian Hughes wrote: Hi. I have a query which works and is quick, but it misses a couple of records. SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Preview.Blurb FROM ArgumentCalendar , CaseID , Parties , Preview WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND Preview.CASEID = CaseID.CASEID AND '20001001' = ArgumentCalendar.Date AND ArgumentCalendar.Date = '20010630; I needed to _also_ select the records which don't have a corresponding record in Preview, so I threw in a left join: SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Blurb FROM ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date The second query works correctly with the left join, but now mysql looks at all 19000 records in Parties (according to EXPLAIN) and the query takes about 15 seconds to execute. I have fiddled and read fiddled more, but I have failed to speed up this query. If I change the order around or add another left join I have removed the problem with the Parties table, but then EXPLAIN says all 19000 CaseID records are being examined. Without the LEFT JOIN MySQL only looks at all the ArgumentCalendar all the Preview records, which are like 63 and 150 respectively. With the Left Join I select 61 records, without it 59 (which is as expected -- the issue is just speed). I am using MySQL 3.22.25. Am I screwed or is there some syntactic SQL point I am missing? - BLH - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: simple SQL question
[EMAIL PROTECTED] wrote: Hi, Sorry for the possible offtopic question I'm going to ask. I have got something similar (this is very simplicated situation of my problem but this is the core of my headache): CREATE TABLE cityname ( id BIGINT NOT NULL AUTO_INCREMENT, cname CHAR(50), INDEX id_index(id) ); CREATE TABLE firms ( id BIGINT NOT NULL AUTO_INCREMENT, fname CHAR(50), city0 BIGINT, city1 BIGINT, INDEX id_index(id), INDEX city0_index(city0), INDEX city1_index(city1) ); Now I want to dump data out from my database with textual names of cities. if I do: SELECT * FROM firms; it's not good since I have to resolve the city names in further queries which seems to a bit expensive (inmagine that each record has got 6 cities. note that I had to use maximum of 6 cities so I don't want to create another table for the relation, but please ask me to this - and tell me how and why is it better - if it's better solution). What can I do to have something similar result: A+B company Dallas London New systems Ltd New YorkParis My knowledge in this situation is not enough for talking about mysql. Please help me, and CC the letter for me as well, since I'm not on any mysql mailing list. Maybe my SQL knowledge is not too good as well to ask such a stupid question :) By the way, where can I ask questions like this especially for MySQL? Maybe I should read some documents can be found on the net ... Tell URLs. Or whatever. I would suggest not having 2 cities in your firm record, and making fname,city your key. select * from firms order by fname,city would give you. A+B company Dallas A+B company London New systems Ltd New York New systems Ltd Paris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Uninstalling and Troubleshooting RPM
lkeeton wrote: I am very frusturated as of right now. I have a mysql database that doesn't work on Cobalt Raq3. I installed the RPM version and guess what the mysql.sock file isn't there and ther server gives me this error when starting: Starting mysqld daemon with databases from /var/lib/mysql mysqld daemon ended Then it gives me when i connect with command prompt mysql Can't connect can't connect through mysql.sock and it may not exist I am so frusturated now all I want to do is uninstall this rpm and install the source files. The bottom line is that the command rpm -e filename doesn't work it gives me an error filename is not installed. The truth is it is installed and I want it to work. I will be happy for a solution to either to fix this sock problem or uninstall this software all 3 rpm's(client,server, and devel) so I can just install the source tarball. Any suggestions Brent There is no mysql.sock because mysqld is not running. Did you check the log files to see what happened? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: I am failing to optimize this left join ...
Does this help? SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Blurb FROM ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Parties.CASEID = Preview.CASEID WHERE Preview.CASEID IS NULL AND CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date Hi. I have a query which works and is quick, but it misses a couple of records. SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Preview.Blurb FROM ArgumentCalendar , CaseID , Parties , Preview WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND Preview.CASEID = CaseID.CASEID AND '20001001' = ArgumentCalendar.Date AND ArgumentCalendar.Date = '20010630; I needed to _also_ select the records which don't have a corresponding record in Preview, so I threw in a left join: SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Blurb FROM ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date The second query works correctly with the left join, but now mysql looks at all 19000 records in Parties (according to EXPLAIN) and the query takes about 15 seconds to execute. I have fiddled and read fiddled more, but I have failed to speed up this query. If I change the order around or add another left join I have removed the problem with the Parties table, but then EXPLAIN says all 19000 CaseID records are being examined. Without the LEFT JOIN MySQL only looks at all the ArgumentCalendar all the Preview records, which are like 63 and 150 respectively. With the Left Join I select 61 records, without it 59 (which is as expected -- the issue is just speed). I am using MySQL 3.22.25. Am I screwed or is there some syntactic SQL point I am missing? - BLH - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie: difference between tinytext and varchar
I am trying to determine when it is best to use varchar and when it is appropriate to use tinytext. I have looked at the manual and have read the difference between them but would like to have an understanding of this in more practical, real-life terms. Is a space between characters considered a character in both column types or does one handle it differently? When I use a varchar I have to define its maximum length. I don't have to declare max length in tinytext. does this make a difference when it comes to storage space? Thanks, Karen McAdams = Karen McAdams http://kmcadams.com [EMAIL PROTECTED] __ 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
Problem with replication. :-(
Hi, I'm running linux, mysql 3.23.32 (latest stable) I have 2 servers running a circular master-slave. Server1 has: log-bin=/var/lib/mysql/binary_log master-host=server 1 host master-user=user master-password=password log-slave-updates Server2 has: log-bin=/var/lib/mysql/binary_log master-host=server 2 host master-user=user master-password=password log-slave-updates I've verified many times that replication works quite well. But both servers are frequently getting into a situation where I continuously get: --- (from server 1) --- 010125 11:08:36 Slave: reconnected to master,replication resumed in log 'binary_log.001 ' at position 1169067 010125 11:08:36 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) --- (from server 1) --- 010125 11:09:20 Slave: reconnected to master,replication resumed in log 'binary_log.002 ' at position 19702 010125 11:09:20 Error reading packet from server: Could not find first log (read_errno 0,server_errno=65535) This just goes on and on. How can I remedy this?? Thanks Ricardo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: parallel Mysql ?
Hi, - Original Message - From: Michael Widenius [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Steven Roussey [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 9:28 PM Subject: Re: parallel Mysql ? We plan to use the following algorithm on top of our current replication code to achieve this: http://www.fault-tolerant.org/recall/ What do you think about replication algorithm described in some RFC's drafts for replicating LDAP databases? WBR, Paul. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Resource id #2
When I run any kind of query this is the value of result Resource id #2 Example $result= mysql_query (" Select * from ACCT_TBL ") or die ("Error".mysql_error()); print result; any ideas? randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie: difference between tinytext and varchar
The answer to your question depends upon depends on the nature of the text information you are going to store: - The length of text you want to store. - Database size and fragmentation considerations. - Uppercase/Lower case significance - Indexing (prior to 3.23). I am trying to determine when it is best to use varchar and when it is appropriate to use tinytext. I have looked at the manual and have read the difference between them but would like to have an understanding of this in more practical, real-life terms. Is a space between characters considered a character in both column types or does one handle it differently? When I use a varchar I have to define its maximum length. I don't have to declare max length in tinytext. does this make a difference when it comes to storage space? Thanks, Karen McAdams = Karen McAdams http://kmcadams.com [EMAIL PROTECTED] __ 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Resource id #2
This is really more of a PHP question, than it is a MySQL question mysql_query returns an integer which is the identifier that you will use to call other mysql functions which utilize the results from your query. For example: $row_count = mysql_num_rows($result) ; ...this will set $row_count equal to the number of rows returned by your query identified by $result). See www.php.net/mysql for some good information on this as well. HTH Sam Masiello Systems Analyst Chek.Com (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 2:38 PM Cc: [EMAIL PROTECTED] Subject:Resource id #2 When I run any kind of query this is the value of result Resource id #2 Example $result= mysql_query (" Select * from ACCT_TBL ") or die ("Error".mysql_error()); print result; any ideas? randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: I am failing to optimize this left join ...
Hi. Thanks, I like that syntax, I didn't know I could put STRAIGHT_JOIN there after the SELECT. But it doesn't get me anything. EXPLAIN still says I am examining all 19,701 rows in CaseID: same problem as before. - BLH At 10:46 AM 1/25/2001 -0800, you wrote: Try this one: SELECT STRAIGHT_JOIN ArgumentCalendar.Docket , ArgumentCalendar.Date , DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Blurb FROM ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date On 25 Jan 2001 13:17:14 -0500, Brian Hughes wrote: Hi. I have a query which works and is quick, but it misses a couple of records. SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Preview.Blurb FROM ArgumentCalendar , CaseID , Parties , Preview WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND Preview.CASEID = CaseID.CASEID AND '20001001' = ArgumentCalendar.Date AND ArgumentCalendar.Date = '20010630; I needed to _also_ select the records which don't have a corresponding record in Preview, so I threw in a left join: SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Blurb FROM ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date The second query works correctly with the left join, but now mysql looks at all 19000 records in Parties (according to EXPLAIN) and the query takes about 15 seconds to execute. I have fiddled and read fiddled more, but I have failed to speed up this query. If I change the order around or add another left join I have removed the problem with the Parties table, but then EXPLAIN says all 19000 CaseID records are being examined. Without the LEFT JOIN MySQL only looks at all the ArgumentCalendar all the Preview records, which are like 63 and 150 respectively. With the Left Join I select 61 records, without it 59 (which is as expected -- the issue is just speed). I am using MySQL 3.22.25. Am I screwed or is there some syntactic SQL point I am missing? - BLH - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: I am failing to optimize this left join ...
Thanks, but not really. I wish to get all the cases, even when there is no Blurb in Preview. Your query only grabs cases where the Blurb in Preview is missing by adding WHERE Preview.CASEID IS NULL. - Brian - BLH At 01:00 PM 1/25/2001 -0600, you wrote: Does this help? SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Blurb FROM ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Parties.CASEID = Preview.CASEID WHERE Preview.CASEID IS NULL AND CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date Hi. I have a query which works and is quick, but it misses a couple of records. SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Preview.Blurb FROM ArgumentCalendar , CaseID , Parties , Preview WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND Preview.CASEID = CaseID.CASEID AND '20001001' = ArgumentCalendar.Date AND ArgumentCalendar.Date = '20010630; I needed to _also_ select the records which don't have a corresponding record in Preview, so I threw in a left join: SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Blurb FROM ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date The second query works correctly with the left join, but now mysql looks at all 19000 records in Parties (according to EXPLAIN) and the query takes about 15 seconds to execute. I have fiddled and read fiddled more, but I have failed to speed up this query. If I change the order around or add another left join I have removed the problem with the Parties table, but then EXPLAIN says all 19000 CaseID records are being examined. Without the LEFT JOIN MySQL only looks at all the ArgumentCalendar all the Preview records, which are like 63 and 150 respectively. With the Left Join I select 61 records, without it 59 (which is as expected -- the issue is just speed). I am using MySQL 3.22.25. Am I screwed or is there some syntactic SQL point I am missing? - BLH - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
BSDI 4.2?
Anyone have any luck building Mysql 3.32.23 on a BSDI 4.2 machine? I get an error during the make command. Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: simple SQL question
On Thu, Jan 25, 2001 at 12:52:11PM -0600, Gerald L. Clark wrote: I would suggest not having 2 cities in your firm record, and making fname,city your key. select * from firms order by fname,city would give you. A+B company Dallas A+B company London New systems Ltd New York New systems Ltd Paris Nice, but it has got some problems. If I correctly understand you, you suggest me to double records which have got multiple city entries. The problem is that firms table has got many fields even binary ones to hold picture data so it would be expensive to double them. And my other problem: indexing character types are more slower than just bigint values. By the way is there any ANSI SQL solution for it? I mean only in mySQL can't be implemented simply or this is a general SQL problem? PS: Maybe I should stop CC'ing this thread to the list, shouldn't I. - Gabor Lenart - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Berkeley Tables under NT!
I asked a week ago if BDB tables had ever been tested by the MySQL team on RedHat 7. Any ideas? - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [EMAIL PROTECTED] - -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 10:25 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Berkeley Tables under NT! Harja Robert writes: I'd like to know if is possible to use Berkeley Tables under MySql Nt version and if the answer is YES, I'd like to know how do I install and use these facility! Thanks! Hi! This feature for Win32 is in the works. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, 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
Can I do this in a SELECT
I have a need for a SELECT query... I don't really want any of the data from the select... Rather I need the size of the data basically I need SELECT sum(length(*)) FROM MyDB WHERE MyDB.Something LIKE 'this%' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I am failing to optimize this left join ...
Send the results of the EXPLAIN On 25 Jan 2001 15:15:35 -0500, Brian Hughes wrote: Hi. Thanks, I like that syntax, I didn't know I could put STRAIGHT_JOIN there after the SELECT. But it doesn't get me anything. EXPLAIN still says I am examining all 19,701 rows in CaseID: same problem as before. - BLH At 10:46 AM 1/25/2001 -0800, you wrote: Try this one: SELECT STRAIGHT_JOIN ArgumentCalendar.Docket , ArgumentCalendar.Date , DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Blurb FROM ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date On 25 Jan 2001 13:17:14 -0500, Brian Hughes wrote: Hi. I have a query which works and is quick, but it misses a couple of records. SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Preview.Blurb FROM ArgumentCalendar , CaseID , Parties , Preview WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND Preview.CASEID = CaseID.CASEID AND '20001001' = ArgumentCalendar.Date AND ArgumentCalendar.Date = '20010630; I needed to _also_ select the records which don't have a corresponding record in Preview, so I threw in a left join: SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Blurb FROM ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date The second query works correctly with the left join, but now mysql looks at all 19000 records in Parties (according to EXPLAIN) and the query takes about 15 seconds to execute. I have fiddled and read fiddled more, but I have failed to speed up this query. If I change the order around or add another left join I have removed the problem with the Parties table, but then EXPLAIN says all 19000 CaseID records are being examined. Without the LEFT JOIN MySQL only looks at all the ArgumentCalendar all the Preview records, which are like 63 and 150 respectively. With the Left Join I select 61 records, without it 59 (which is as expected -- the issue is just speed). I am using MySQL 3.22.25. Am I screwed or is there some syntactic SQL point I am missing? - BLH - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Big Integer
I don't know why you'd really want to store numbers that big. Since mysql's aggregate functions wouldn't work on them anyway, just store the numbers as strings. At 03:53 PM 1/25/2001 -0500, Ashutosh Somani wrote: Hi, I am working on an application where I need to be able to store 96 bit numbers. As I understand it, however, the largest size that can be stored in MySQL is 2^64 using Big Integer. Has anyone run into this problem before? Does anyone know of an easy work around for this? Thanks! Please CC me on any replies as I am not part of the mailing list yet. - Scott Baker - Webster Internet - Network Technician 503.266.8253 - [EMAIL PROTECTED] "Children today are tyrants. They contradict their parents, gobble their food, and tyrannize their teachers." - Socrates - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BSDI 4.2?
Hi Alan, I have uploaded a binary distribution to mysql.com, but they have not yet had time to post it. Here are my instructions for MySQL, Good Luck: My notes on building mysql gunzip mysql-3.23.xx.tar.gz | tar xvf - The default config works pretty well. I change into the directory just created and run ./configure --enable-large-files This enables files larger than 2GB then run (Do not use BSD make!) gmake -s su to root then: gmake -s install add the line /usr/local/lib/mysql to ld.so.conf and run ldconfig ~ - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Alan Halls" [EMAIL PROTECTED] To: "Mysql" [EMAIL PROTECTED] Sent: Thursday, January 25, 2001 3:25 PM Subject: BSDI 4.2? Anyone have any luck building Mysql 3.32.23 on a BSDI 4.2 machine? I get an error during the make command. Alan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OpenBSD 2.8 update / Add to FAQ please
Hi! "Jonathan" == Jonathan Roy [EMAIL PROTECTED] writes: Jonathan Hi all. I had the OpenBSD problems others have reported, with slow Jonathan response, high load/cpu usage, crashes, etc. Sinisa reported a month or Jonathan so ago it was a bug in the 2.8 threading library. I wrote to the OpenBSD Jonathan developers, and they had made changes to libc_r which solved mysql Jonathan problems for another user. Jonathan I updated my libc_r source code to -current, compiled and installed the Jonathan new libc_r* files into /usr/lib, and my mysql problems seem to have Jonathan disappeared. All problems we were having before have stopped, at least Jonathan for the most part. Jonathan I'd like to suggest two things are added to the FAQ. First, that Jonathan OpenBSD 2.8 has a threading bug that will cause various problems with Jonathan MySQL. That'd have saved me a lot of time. Secondly, also add that as of Jonathan today's date the -current branch of libc_r mostly or completely fixes the Jonathan problem for i386. We will add this to the documentation. Jonathan A side note, when trying to work around this we were trying the Jonathan mit-pthreads version we had trouble with the alias ALIGN() which OpenBSD Jonathan also defines. The solution we used was just to add "#undef ALIGN" before Jonathan the ALIGN declaration in the 4-5 .h files where it is used. After this, Jonathan mit-pthreads compiled on 2.8 without any further problem. Considering Jonathan mit-pthreads will never want to use an OS ALIGN() instead of it's own, Jonathan perhaps add this #undef to the distribution, or add it conditional on Jonathan detecting OpenBSD. Fixed. Jonathan Thanks, Jonathan -Jonathan Thanks! Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 the union of the values in a SET column ?
I have a column that is defined as a SET. For simplicity's sake, let's say the column is defined as: set_col SET ('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'Z') After entering a few hundred rows, I know that some but not all values of the SET have been used at least once. How can one work out which values have been used at least once ? Doing a SELECT DISTINCT(set_col) on the table might provide something like this: A,B,D A,C,G,N,M,P C,E,F,H,I,R,S C,E,G,I D,F G,H,L,M,O etc But it then requires processing to work out which values have been used at least once. It's not very scalable. Is there a method to retrieve a list of all the values that have been used at least once ? Thank you very much, chas ps. using an old version at the moment - 3.22.25 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BSDI 4.2?
"AH" == Alan Halls [EMAIL PROTECTED] writes: AH Anyone have any luck building Mysql 3.32.23 on a BSDI 4.2 machine? I get an AH error during the make command. Using extreme powers of mental telepathy, we might be able to guess your problem. However, if you told us exactly what the errors were, it would be much easier for those of us without such powers. My guess is you need to use "gmake" instead of "make". That always worked for me. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Apache - MySQL - PHP (Auto-start Apache)
Yes, but does it get cleanly stopped when you shutdown? put the start command in /etc/rc.d/rc.local, fine, but I think there needs to be a kill link added to /etc/rc.d/rc.3 dir. I like the link from apachectl to /etc/rc.d/init.d/ idea: ln -s /usr/local/apache/bin/apachectl /etc/rc.d/init.d/httpd this is correct, if you're in run level 3, to kill apache on shutdown: ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc3.d/K90httpd this will only work if you go into run level 6 (reboot), shutdown is run level 0 and won't call this script, may not always get executed: ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc6.d/K90httpd # BAD I don't recommend running X on a web server at all, so you should only really be running in multi-user networked mode, or run level 3, IMHO. Isn't this the MySQL mail list, BTW? I think there's a mail list or newsgroup for apache somewhere... perhaps even a linux admin newsgroup would be even more appropriate. HTH, -jp -Original Message-, From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 7:00 AM To: Mark Maunder Cc: Freaked Personality; John Halladay; "MySQL List (E-mail)" Subject: Re: Apache - MySQL - PHP (Auto-start Apache) You can put this in the /etc/rc.d/rc.local /usr/local/apache/bin/apachectl start Mensaje citado por: Mark Maunder [EMAIL PROTECTED]: (quicky coz this is way off topic): ln -s /usr/local/apache/bin/apachectl /etc/rc.d/init.d/httpd ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc3.d/S90httpd ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc5.d/S90httpd ln -s /etc/rc.d/init.d/httpd /etc/rc.d/rc6.d/K90httpd That should do it. Should bring up your httpd whether you\'re running runlevel 3 (command line) or runlevel 5 (X windows) on redhat whatever version. (I think). You can use the same scheme for starting mysqld too (excuse for posting to list) *duck* Freaked Personality wrote: You don\'t configure apache to do this, since apache has no idea when the server boots up... You have to edit your start-up scripts which are mostly in /etc/rc.d to start up apache. There\'s a huge number of ways to do this (to script it) ie with error checking/without error checking with mail on error etc etc depending on your distribution you then have to add files to run level directories (links) or have to do run level checking in the start-up scripts which isn\'t explained that easy. Knowing which distribution you use could prove very helpful :-) On Tue, 23 Jan 2001, John Halladay wrote: I\'m currently running Apache 1.3.12, MySQL 3.22.32-1, and PHP 4.0.3 together on RedHat 7.0 and everything works fine, although every time I boot up I have to manually start the Web Server with command /usr/local/apache/bin/apachectl start. Does anyone know how to configure Apache so that it will start up automatically when I boot up Linux? (I know it\'s a little off the MySQL subject, but I figured someone would have a similar setup.) Thanks, John Halladay -- --- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- --- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- --- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To
RE: Can I do this in a SELECT
no. You can do: SELECT sum(length(Something)) FROM MyDB WHERE MyDB.Something LIKE 'this%' But you will have to specify that for each field you want...then add them all up to get the length. Cal http://www.calevans.com -Original Message- From: Jason Terry [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 25, 2001 2:55 PM To: [EMAIL PROTECTED] Subject: Can I do this in a SELECT I have a need for a SELECT query... I don't really want any of the data from the select... Rather I need the size of the data basically I need SELECT sum(length(*)) FROM MyDB WHERE MyDB.Something LIKE 'this%' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Getting autoincrement value from insert using JDBC
Hi all, If I have an insert statement that adds data to a table that contains an autoincrement column, is there a way to get the value of the auto increment column without doing an additional query in JDBC ? . I am using the org.gjt.mm.mysql driver . Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How do I make a CSV dump
If you're running windows go to my.anse.de his client will do it. Scott At 02:54 PM 1/25/2001 -0700, Jason Terry wrote: Anybody have a quick way to make a CSV dump of a SELECT? If MySQL can't do it directly is there an easy way in PERL? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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] "Children today are tyrants. They contradict their parents, gobble their food, and tyrannize their teachers." - Socrates - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange behavior of MySQL 3.23.xx with GROUP BY ...
Hello, I found a very strange behaviour of MySQL 3.23.xx with GROUP BY clause ... I have a Table: CREATE TABLE groupbyTEST ( fldNAME varchar(20) NOT NULL, fldMONTH tinyint(4) DEFAULT '0' NOT NULL, fldSALARY decimal(10,0) DEFAULT '0' NOT NULL, fldDATE datetime DEFAULT '-00-00 00:00:00' NOT NULL, PRIMARY KEY (fldNAME, fldMONTH) ); with following records: INSERT INTO groupbyTEST VALUES ( 'stephan', '1', '1000', '2001-01-25 23:12:29'); INSERT INTO groupbyTEST VALUES ( 'boris', '1', '2000', '2001-01-25 23:12:45'); INSERT INTO groupbyTEST VALUES ( 'stephan', '2', '1200', '2001-01-25 23:12:56'); INSERT INTO groupbyTEST VALUES ( 'stephan', '3', '1000', '2001-01-25 23:13:08'); INSERT INTO groupbyTEST VALUES ( 'stephan', '4', '900', '2001-01-25 23:14:50'); INSERT INTO groupbyTEST VALUES ( 'boris', '2', '1200', '2001-01-25 23:15:01'); INSERT INTO groupbyTEST VALUES ( 'stephan', '5', '1900', '2001-01-25 23:15:16'); INSERT INTO groupbyTEST VALUES ( 'boris', '3', '2400', '2001-01-25 23:15:39'); INSERT INTO groupbyTEST VALUES ( 'boris', '4', '2100', '2001-01-25 23:15:50'); INSERT INTO groupbyTEST VALUES ( 'boris', '5', '2300', '2001-01-25 23:16:01'); INSERT INTO groupbyTEST VALUES ( 'boris', '6', '200', '2001-01-25 23:16:11'); A statement like: SELECT fldNAME, fldMONTH, sum(fldSALARY) FROM groupbyTEST GROUP BY fldNAME HAVING sum(fldSALARY)200 should cause an error because of the missing fldMONTH in the GROUP BY clause, but it is executed without an error and results: fldNAME fldMONAT sum(fldGEHALT) boris 1 10200 stephan 1 6000 ... makes not very much sense ... does it?? bye Stephan Skusa - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I am failing to optimize this left join ...
At 01:19 PM 1/25/2001 -0800, Ryan Wahle wrote: Send the results of the EXPLAIN table type possible_keys key key_len ref rows Extra ArgumentCalendar ALL Date [none] [none] [none] 63 where used CaseID ALL PRIMARY [none] [none] [none] 19701 where used Parties eq_ref PRIMARY PRIMARY 4 CaseID.CASEID 1 [none] Preview ALL [none] [none] [none] [none] 150 [none] (blank cells indicated by [none]) - BLH On 25 Jan 2001 15:15:35 -0500, Brian Hughes wrote: Hi. Thanks, I like that syntax, I didn't know I could put STRAIGHT_JOIN there after the SELECT. But it doesn't get me anything. EXPLAIN still says I am examining all 19,701 rows in CaseID: same problem as before. - BLH At 10:46 AM 1/25/2001 -0800, you wrote: Try this one: SELECT STRAIGHT_JOIN ArgumentCalendar.Docket , ArgumentCalendar.Date , DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Blurb FROM ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date On 25 Jan 2001 13:17:14 -0500, Brian Hughes wrote: Hi. I have a query which works and is quick, but it misses a couple of records. SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Preview.Blurb FROM ArgumentCalendar , CaseID , Parties , Preview WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND Preview.CASEID = CaseID.CASEID AND '20001001' = ArgumentCalendar.Date AND ArgumentCalendar.Date = '20010630; I needed to _also_ select the records which don't have a corresponding record in Preview, so I threw in a left join: SELECT ArgumentCalendar.Docket , ArgumentCalendar.Date , DATE_FORMAT(ArgumentCalendar.Date, '%W, %M %e, %Y') AS formatted_date , CaseID.CASEID , CONCAT(Party1, ' v. ', Party2) AS name , Blurb FROM ArgumentCalendar , CaseID , Parties LEFT JOIN Preview ON Preview.CASEID = Parties.CASEID WHERE CaseID.DocketNumber = ArgumentCalendar.Docket AND Parties.CASEID = CaseID.CASEID AND '20010125' = ArgumentCalendar.Date The second query works correctly with the left join, but now mysql looks at all 19000 records in Parties (according to EXPLAIN) and the query takes about 15 seconds to execute. I have fiddled and read fiddled more, but I have failed to speed up this query. If I change the order around or add another left join I have removed the problem with the Parties table, but then EXPLAIN says all 19000 CaseID records are being examined. Without the LEFT JOIN MySQL only looks at all the ArgumentCalendar all the Preview records, which are like 63 and 150 respectively. With the Left Join I select 61 records, without it 59 (which is as expected -- the issue is just speed). I am using MySQL 3.22.25. Am I screwed or is there some syntactic SQL point I am missing? - BLH - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Getting autoincrement value from insert using JDBC
On Thu, Jan 25, 2001 at 05:17:03PM -0500, Gary Lyons wrote: Hi all, If I have an insert statement that adds data to a table that contains an autoincrement column, is there a way to get the value of the auto increment column without doing an additional query in JDBC ? . I am using the org.gjt.mm.mysql driver . The MM.MySQL documentation says this in the section "Using MySQL specific functionality": MySQL has some features that cannot be accessed from the methods provided in the standard JDBC API. To access them, you need to cast the Statement or PreparedStatement object you are using to org.gjt.mm.mysql.Statement or org.gjt.mm.mysql.PreparedStatement respectively. From either of these classes you can call the methods getLastInsertID() to get the value created for any AUTO_INCREMENT field, and getLongUpdateCount() to get the larger update count that MySQL can produce as a long. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How do I make a CSV dump
As will the urSQL Utility (MS Windows): http://www.urbanresearch.com/ursql urSQL can export query results in a variety of formats: - HTML - CSV - Excel - Word - Text Depending on your data, you might also be able to use the SELECT INTO OUTFILE syntax: select * into outfile "tableout.txt" fields terminated by ',' enclosed by '"' lines terminated by '\n' from tableout; This should give you a file with each field enclosed with quotes and separated by commas, with each row delimited by a \n: "col1row1","col2row1","col3row1","col4row1","col5row1" "col1row2","col2row2","col3row2","col4row2","col5row2" "col1row3","col2row3","col3row3","col4row3","col5row3" See the manual: http://www.mysql.com/doc/S/E/SELECT.html On Thu, 25 Jan 2001, Scott Baker wrote: If you're running windows go to my.anse.de his client will do it. Scott At 02:54 PM 1/25/2001 -0700, Jason Terry wrote: Anybody have a quick way to make a CSV dump of a SELECT? If MySQL can't do it directly is there an easy way in PERL? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: simple SQL question
Hi, how about select fname, c1.cname, c2.cname, c3.cname from firms, cityname as c1, cityname as c2, cityname as c3 where first.city0 = c1.id and first.city1 = c2.id and first.city2 = c3.id; CC'ing the dialogue to the list lets us know that you have received the first reply, and what you made of it, allowing others, like me, to suggest other solutions. Regards Quentin -Original Message- From: Gbor Lnrt [mailto:[EMAIL PROTECTED]] Sent: Friday, 26 January 2001 09:20 To: Gerald L. Clark Cc: [EMAIL PROTECTED] Subject: Re: simple SQL question On Thu, Jan 25, 2001 at 12:52:11PM -0600, Gerald L. Clark wrote: I would suggest not having 2 cities in your firm record, and making fname,city your key. select * from firms order by fname,city would give you. A+B company Dallas A+B company London New systems Ltd New York New systems Ltd Paris Nice, but it has got some problems. If I correctly understand you, you suggest me to double records which have got multiple city entries. The problem is that firms table has got many fields even binary ones to hold picture data so it would be expensive to double them. And my other problem: indexing character types are more slower than just bigint values. By the way is there any ANSI SQL solution for it? I mean only in mySQL can't be implemented simply or this is a general SQL problem? PS: Maybe I should stop CC'ing this thread to the list, shouldn't I. - Gabor Lenart - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Version distribution
Hi, I wonder if any of the mySQL people have any guesses or real stats about the number of people using each version of mySQL. I am wondering if I develop a tool that only supports the latest 3.23 version will I cut out a whole lot of people? How long does it tend to take for most people to upgrade? I know my own upgrades tend to come when a get a chance, after a new version is considered stable. I would like to use Transactions with the mm.mysql driver, but it only supports that for 3.23. Thanks, Eric Frazier Consulting http://www.kwinternet.com/eric (250) 655 - 9513 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How do I make a CSV dump
mysqldump --tab=/tmp --no-create-info --fields-terminated-by=',' database table Should do the trick. This will create a file called /tmp/table.txt, containing the data. Use --where=".." to select from fields. For more complext selects, look at select field1, field2 into outfile '/path/to/file' from ... Regards Quentin -Original Message- From: Jason Terry [mailto:[EMAIL PROTECTED]] Sent: Friday, 26 January 2001 10:54 To: [EMAIL PROTECTED] Subject: How do I make a CSV dump Anybody have a quick way to make a CSV dump of a SELECT? If MySQL can't do it directly is there an easy way in PERL? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Large Table Problem
Hello there, I was hoping you guys could help me with a little problem I'm having with MySQL. I'm trying to dump the contents of one field of a multi-field table to a text file. The table is on the large side (about 3 million rows). Whenever I run: SELECT rowname FROM table INTO OUTFILE somefile.txt The entire server freezes for the duration and will not execute any other commands from any connection (other processes, users, etc.) until the this select is done. The DB server I'm running this on is mission critical - we can't afford for it to be unable to accept INSERTS for the duration of the command (about 30-45 minutes). Does anyone have any suggestions as to how I might be able to run this query without hanging the server (or copying the tables to another server and running it there) ? Alternatelly I was considering just parsing through the .ISD file for that table and extracting the field I need - if anyone could point me in the right direction as to which modules in the MySQL source I should look at for this functionality I would really appreciate it. Thanks in advance, Marius Wejman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Search engine database structure
As I understand it, search engines use a "special" type of database structure. They have a special table for common words/phrases and another one with all the data. They link theese together by a third one that contains only the ids from the other two, thus making the search much faster. How do they determine the common words? Is it done similar to the FULLTEXT search in Mysql, all words over three characters? I think I have heard someone call it "many to many", but am not sure. Anyway, is there any good tutorial out there so I can design my own? Or perhaps someone could take a few minutes of their time and explain some of it to me. Thanks, // Tobias - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Pub Crawl display
PUB TABLEEVENT TABLE |p_id|pub_name |address ||eventid|date |host_id| |13 |John Barleycorn's |1800 N. Lincoln ||321|2001-01-27 | 32| |26 |Harry Carry's |300 N. Dearborn ||198|2001-02-21 | 0 | |67 |Cubby Bear|3500 N. Clark ||369|2001-02-23 | 39 | |45 |Wrightwood Tap|600 Wrightwood | |21 |River Shannon |3500 N. Clark | HOST TABLE STOP TABLE |host_id|host_name |phone | |event_id|p_id |sequence || |39 |Pamela Anderson|562-698-5473 | |321 | 13 | 2 | |51 |Tom Cruise |212-369-2391 | |321 | 67 | 1 | |32 |Sammy Sosa |312-365- | |321 | 26 | 3 | |198 | 21 | 1 | |198 | 45 | 2 | |198 | 67 | 3 | |369 | 13 | 1 | |369 | 21 | 2 | |369 | 45 | 3 | I am trying to do a select that would allow me to display the following: ** UPCOMING PUB CRAWLS ** Event ID Beginning Ending DateHosted By 321 Cubby Bear Harry Carry's 01-27-01Sammy Sosa 198 River Shannon Cubby Bear 02-21-01unassigned 369 John Barleycorn Wrightwood Tap 02-23-01Pamela Anderson My select statement below is not cutting it and I beginning to wonder if what I want to do can be done with a select statement or a join. If it can some help me figure out how. If it can' can someone suggest some other way of going about it. SELECT e.eventid, e.date, e.host_id, p.name h.name FROM event e, pub p, host h, stop s WHERE e.eventid=s.event_id AND s.p_id=p.p_id AND e.host_id=h.host_id - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Upgrading to MySQL 3.23.32
Hi All, We are thinking to upgrade our MySQL servers to MySQL 3.23.32. Have any one experienced any unexpected problem due to upgrade. Thanks in advance for any comments. James R. Butzen NEBIS Tech. Support http://www.nebis.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
3.23.32 + FreeBSD 4.2 /w Lastest Snapshots - Still CoreDump
I'm using 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots on a Dual P2 Xeon 400MHz 1MB Cache, 1GB Ram on 3ware IDE RAID The traffic of it is about 300 queries/second on average, and keep staying at around 400 q/s at night. The problem is that, it core dumps in 5-10 mins, especially at night (high traffic?) I've tried to enable/disable SMP, modify the memory setting in my.cnf, concerrency thread setting etc. And apply the lastest snapshots and make world. Binary, compile by myself with and without -O cflags, all these give the same result - core dumps every 5-10 mins... It's core dumps due to bus error (that's what it report...), not segmentation fault. I've also tried to change the RAM, mother board and harddisk, but still... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SV: undefined reference to `uncompress' ?
Jarmo Paavilainen ([EMAIL PROTECTED]) writes: I could answer "read the manual", "look it up in the FAQ" and so on. But add "-lz" to you list of libraries to link in (ie libz.so). I couldn't find it in the manual, where did you find it hiding? Thank goodness for this list! -- Ed Carp, N7EKG [EMAIL PROTECTED] 940/367-2744 cell phone http://www.pobox.com/~erc [EMAIL PROTECTED] - text pager I sometimes wonder if the American people deserve to be free - they seem so unwilling to fight to preserve the few freedoms they have left. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help Pub Crawl display
Your Query is making me thirsty ;-) Unfortunately your tables got garbled so I had to improvise. Next time don't paste the tables beside each other... Also, I'm not sure if I understand your problem or what you are trying to accmplish. Are you trying to de-normalize your data and display the Beggining and Ending Pubs for each stop? - Scott I am trying to do a select that would allow me to display the following: ** UPCOMING PUB CRAWLS ** Event IDBeginning Ending DateHosted By 321 Cubby Bear Harry Carry's 01-27-01Sammy Sosa 198 River Shannon Cubby Bear 02-21-01unassigned 369 John Barleycorn Wrightwood Tap 02-23-01Pamela Anderson My select statement below is not cutting it and I beginning to wonder if what I want to do can be done with a select statement or a join. If it can some help me figure out how. If it can' can someone suggest some other way of going about it. SELECT e.eventid, e.date, e.host_id, p.name h.name FROM event e, pub p, host h, stop s WHERE e.eventid=s.event_id AND s.p_id=p.p_id AND e.host_id=h.host_id - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots - Still CoreDump
On Fri, Jan 26, 2001 at 09:41:09AM +0800, Sam Wong wrote: I'm using 3.23.32 + FreeBSD 4.2 /w Lastest Snapshots on a Dual P2 Xeon 400MHz 1MB Cache, 1GB Ram on 3ware IDE RAID The traffic of it is about 300 queries/second on average, and keep staying at around 400 q/s at night. The problem is that, it core dumps in 5-10 mins, especially at night (high traffic?) I've tried to enable/disable SMP, modify the memory setting in my.cnf, concerrency thread setting etc. And apply the lastest snapshots and make world. Binary, compile by myself with and without -O cflags, all these give the same result - core dumps every 5-10 mins... It's core dumps due to bus error (that's what it report...), not segmentation fault. I've also tried to change the RAM, mother board and harddisk, but still... See if increasing the size of MySQL's thread stack (in your my.cnf) makes the situation better... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help Pub Crawl display
Thanks for your reply. Believe I'm thristy two and if I ever get this thing to work I'm going to pub crawl all the way home. What I am trying to do is display the beginning and ending points for each pub crawl effedtively leaving out any intermediate stops so that the summary of the pub craw occupies only one row of the display. In addition, the diaplay needs to pickup various other pieces of data such as the hosts name and the events date. What seems to be making it difficult is grabbing only the begining and ending points of the crawl. I appreciate you help. Richard Scott Gerhardt wrote: Your Query is making me thirsty ;-) Unfortunately your tables got garbled so I had to improvise. Next time don't paste the tables beside each other... Also, I'm not sure if I understand your problem or what you are trying to accmplish. Are you trying to de-normalize your data and display the Beggining and Ending Pubs for each stop? - Scott I am trying to do a select that would allow me to display the following: ** UPCOMING PUB CRAWLS ** Event IDBeginning Ending DateHosted By 321 Cubby Bear Harry Carry's 01-27-01Sammy Sosa 198 River Shannon Cubby Bear 02-21-01unassigned 369 John Barleycorn Wrightwood Tap 02-23-01Pamela Anderson My select statement below is not cutting it and I beginning to wonder if what I want to do can be done with a select statement or a join. If it can some help me figure out how. If it can' can someone suggest some other way of going about it. SELECT e.eventid, e.date, e.host_id, p.name h.name FROM event e, pub p, host h, stop s WHERE e.eventid=s.event_id AND s.p_id=p.p_id AND e.host_id=h.host_id - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Converting a dump postgresql
Hello, I'm new with mysql and I've got a little problem. Somebody gave me a dump of a database made with postgresql. So I can't dump it it in my mysql database. Is there a utility that can convert a dump postgresql into a dump mysql? If not, where can I find the rules to convert it by hand. Thank you, -- Laurent Rathle - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php