Re: Plus sign doesn't concatenate strings in MySQL?
At 07:37 -0500 2005/01/15, Dave Merrill wrote: I thought string concatenation w '+' was totally standard SQL. Hmmm, this is the first I've heard of + being used for concatenation (in SQL). Then again, I've never used MS SQL Server. :-) Each language is going to have its own personality. If they all did things the same way, we wouldn't have the wealth of different ones to choose from. Might not be a good idea, Dave, to take MS products as examples of what accepted standards are. MS has a long history of lack of respect for established standards. I suspect MySQL is more ANSI compliant than MS SQL Server. Rob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Plus sign doesn't concatenate strings in MySQL?
At 18:04 +0100 2005/01/15, Jochem van Dieten wrote: On Sat, 15 Jan 2005 11:11:05 -0500, Robert Alexander wrote: Each language is going to have its own personality. If they all did things the same way, we wouldn't have the wealth of different ones to choose from. DBMS's are not languages, they are implementations. We're not talking about a DBMS engine, Jochem, we're talking about SQL: the Structured Query *Language*. The language used to access the DBMS engine. I suspect MySQL is more ANSI compliant than MS SQL Server. Can you substantiate that suspicion? No I can't. As stated, is is a *suspicion*. Something I think may be true, but I'm not sure, and may be incorrect. If I were sure, I would have stated it as fact. I have neither the time nor the inclination to do the research to substantiate my impression. It's just not that important. Do feel free, though. :-) Rob Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ABOUT: Guidelines for Posting to the MySQL list
Hi everybody, I proposed these posting guidelines some time ago, and there was some discussion on the list about them. Thanks for the input, everyone. Since then there has been discussion and some fine tuning with the MySQL folks, and we have come up with the final version that you'll see in the accompanying email. I'll be maintaining these Guidelines, and posting them to the list about twice a month. I sincerely hope you'll take the time to read the Guidelines, and that you'll try to follow them. We'll all benefit. This document will probably evolve over time as the character of the list does. Feedback is welcome and encouraged. Flames /dev/null : Regards, Robert Alexander Maintainer of the MySQL Posting Guidelines. [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
4.0.1 Linux binary won't launch
Hi all, Downloaded the binary distribution of 4.0.1 for Linux, and am attempting to launch on an HP laptop with RedHat 7.0. This will replace my already functional installation of 3.23.46. When I go to launch, it gives me the Starting mysqld daemon with databases... etc. message. It then fails immediately with the message mysqld ended. Here's the content of the error file in the data directory: 011230 12:14:48 mysqld started /usr/local/mysql/bin/mysqld: Fatal error: Can't find messagefile '/usr/local/mysql-4.0.1-alpha-pc-linux-gnu-i686/mysql-4.0.1-alpha-pc-linux-gnu-i686/share/mysql/english/errmsg.sys' 011230 12:14:48 Aborting 011230 12:14:48 mysqld ended So, the error is pretty obvious -- the mysql directory is named twice in the path. My question: where do I go to change this? Any other suggestions? Thanks all, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 4.0.1 Linux binary won't launch
Hey Hank, guess what? G It worked. Thanks for the nudge. Adding the symlink did exactly the expected things, and 4.0.1 is now launched. Now I wonder what the actual *cause* of the problem is... Thanks, buddy, all the best, /Rob At 14:27 -0500 2002/01/02, Hank Leininger wrote: On 2002-01-02, Robert Alexander [EMAIL PROTECTED] wrote: When I go to launch, it gives me the Starting mysqld daemon with databases... etc. message. It then fails immediately with the message mysqld ended. Here's the content of the error file in the data directory: /usr/local/mysql/bin/mysqld: Fatal error: Can't find messagefile '/usr/local/mysql-4.0.1-alpha-pc-linux-gnu-i686/mysql-4.0.1-alpha-pc-lin ux-gnu-i686/share/mysql/english/errmsg.sys' Possible stupid workaround: create a symlink in /usr/local/mysql-4.0.1-alpha-pc-linux-gnu-i686/ called mysql-4.0.1-alpha-pc-linux-gnu-i686 pointing to . This way attempts to look up paths with extra mysql-4... elements will loop back to the toplevel install dir and find what they think they want. -- Hank Leininger [EMAIL PROTECTED] -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error Code 13 when using ALTER TABLE
I'd suggest checking to see if you (or the user MySQL is running as) have the necessary permissions to alter or rename a file in that directory. /Rob At 12:16 -0800 2002/01/02, Fletcher Sandbeck wrote: This is with MySQL 3.23.42-nt on Windows 2000. I am issuing the following SQL statement and getting back an error message. ALTER TABLE Database.Table ADD COLUMN Field VARCHAR(255) error: 7, Error on rename of '.\Database\Table.MYI' to '.\Database\#sql2-538-1.MYI' (Errcode: 13) A CHECK TABLE of the table says that it is OK, but a REPAIR TABLE reports an error '13 when fixing table' and 'Operation Failed' as the final status. Any ideas of what is going wrong? [fletcher] -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
4.0.1 Linux binary won't launch
Hi all, Downloaded the binary distribution of 4.0.1 for Linux, and am attempting to launch on an HP laptop with RedHat 7.0. This will replace my already functional installation of 3.23.46. When I go to launch, it gives me the Starting mysqld daemon with databases... etc. message. It then fails immediately with the message mysqld ended. Here's the content of the error file in the data directory: 011230 12:14:48 mysqld started /usr/local/mysql/bin/mysqld: Fatal error: Can't find messagefile '/usr/local/mysql-4.0.1-alpha-pc-linux-gnu-i686/mysql-4.0.1-alpha-pc-linux-gnu-i686/share/mysql/english/errmsg.sys' 011230 12:14:48 Aborting 011230 12:14:48 mysqld ended So, the error is pretty obvious -- the mysql directory is named twice in the path. My question: where do I go to change this? Thanks all, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL RPM Install Problem - Ignorance
Hi Dennis, There's several ways you can move the datafile location: 1. create a symlink at /var/lib/mysql that points to your data directory 2. you can change or add the 'datadir' variable in your my.cnf file (usually /etc/my.cnf) see: http://www.mysql.com/doc/C/o/Configuring_MySQL.html 3. you can specify the data directory location as a configure option before compiling. Lots about this issue in the archives, too. Take a look. Hope this helps, /Rob At 09:56 -0600 2001/12/30, DWilliams wrote: Hi all, I have recently installed a MySQL server and client RPM 3.23.47 on a Linux system. The system that I am setting up is a Cobalt RAQ4, first time for me to install MySQL on Linux. The installed datadir turned out to be /var/lib/mysql. I get errors when trying to move a very large MySQL data (800MB) directory from a previous host system. It turns out that the /var directory has it's own partition, I think. A 'df' command shows not enough room on the /var directory for the MySQL data files. I am thinking I need to change the datadir variable to somewhere on the /home directory, where I have 15GB free. How can I achieve this? Or is this the right approach? I think I understood that the server can be started up with a different --datadir option, but I would like this to be more permanent in case of system reboots. Thanks, Dennis Williams -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL RPM Install Problem - Ignorance
At 14:37 -0600 2001/12/30, DWilliams wrote: Robert, Thanks for the tips... 1. create a symlink at /var/lib/mysql that points to your data directory I had read that this was not the best way prior to v4.0, something about an alter table statement might ignore the symlink? I've used symlinks a lot and have never had any problems. I usually just install the binary distro, and symlink from /usr/local/mysal/data - my/data/location. 2. you can change or add the 'datadir' variable in your my.cnf file (usually /etc/my.cnf) see: I apparently don't have a 'my.cnf' file after install...I found the following in /usr/share/mysql/: my-huge.cnf my-large.cnf my-medium.cnf my-small.cnf I guess these are example my.cnf files to use...If so, the next question which is the appropriate/best type? Just open them up in an editor and read what it says at the top. Then copy the one you want to /etc/my.cnf I guess whatever choice should be renamed and located as 'my.cnf' in /var/lib/mysql directory? I'm assuming the server on start-up reads this file and overrides compiled commands. Not in the data dir. You're telling it where to *look* for the data, right? This would be your global settings and goes into /etc/my.cnf. Which section does the 'datadir=path/to/data/' command go...to the [mysqld] section? Yup. There is no mention of this command on: http://www.mysql.com/doc/O/p/Option_files.html In a browser, open up the manual that came with your distro and do a search for 'my.cnf' Lots o' good stuff... : 3. you can specify the data directory location as a configure option before compiling. Eventually, I will learn how to do this...but I opted for the RPM instead. I guess that is why I have these sort of configuration difficulties. Thanks again, Dennis Williams Regards, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Possible Values of an Enum Field
Thanks very much for sharing this, Paul. I got a couple other ideas from it, too. :
Regards,
/Rob
At 09:40 -0600 2001/12/21, Paul DuBois wrote:
Here's an example in Perl.
It actually gets more than the list of values, and it works for
SET columns, too.
# Take a database connection, a table name, and a column name.
# Return a reference to a hash with name, type, values, default,
# and nullable keys.
sub get_enumorset_info
{
my ($dbh, $tbl_name, $col_name) = @_;
my $info = {};
$info-{name} = $col_name;
# escape any SQL pattern characters in column name
$col_name =~ s/([_%])/\\$1/g;
my @row = $dbh-selectrow_array (
SHOW COLUMNS FROM $tbl_name LIKE '$col_name'
);
return undef unless @row;
return undef unless $row[1] =~ /^(enum|set)\((.*)\)$/;
$info-{type} = $1;
# split value list on commas, trim quotes from end of each word
my @val = split (,, $2);
s/^'(.*)'$/$1/ foreach (@val);
$info-{values} = [ @val ];
# determine whether or not column can contain NULL values
$info-{nullable} = ($row[2] eq YES);
# get default value (undef represents NULL)
$info-{default} = $row[4];
return $info;
}
--
Robert Alexander ([EMAIL PROTECTED]) 416-823-6599
http://www.workmate.ca WWW Database Applications and Web Hosting
Searchable MySQL List Archive: http://archive.workmate.ca/myarchive
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
At 20:18 -1000 2001/12/15, Peter Reck wrote: Rob, THANK YOU for putting this together. You're welcome. Glad you like it. : I am a complete newbie to MySQL, and have a VERY BASIC question: In the future, Peter, please direct questions to the MySQL list, and not to me personally. Thanks! - How do I go into the db and clear and/or edit what has been written to it thus far? Maybe you can point me in a useful direction to learn about the basics of MySQL? The MySQL manual, either on-line (http://www.mysql.com/doc/) or in the distribution you got, is *very* good. Take a bit of time to get to know it. For a basic start on logging-in, and inserting and deleting data, take a look at the tutorial in the manual, Chapter 3 Introduction to MySQL: A MySQL Tutorial. I am now looking at a nice summary on developer shed right now, which gives me a basic intro. The stuff on DevShed is generally quite good. It's a good resource. Thanks a lot Rob, Peter Hope this helps, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
At 09:33 -0500 2001/12/17, Etienne Marcotte wrote: This is a very very good search engine for the mailing list!!! Great work Thank you! Two things: 2- Put the Any Date checked by default so we don'T have to always click it:-) (I'm lay) You could add some javascript so that the range is celected when something is entered in the from or to fields Second one first: Any Date is already checked by default. What browser/OS are you using? 1- Is it possible to remove our full email adresses? To put like emarcott@... or emarcott at itl dot ca (like the mysqldeveloper archive. my 2 cents #2 is not a big thing, but #1 is pretty important against spam and spam bots. Etienne A valid concern, Etienne, and one that's very important to me, too. Word's fail me in describing how much I detest spam -- well, at least polite ones do. :-/ I believe our information is safe in this case, though. Let me explain why: To the best of my knowledge, Email harvesting 'bots (spambots) use technology similar to that used by the big web search engines. Those companies, like Google, Yahoo, etc., run two main pieces of software; one (a 'spider') that continually accesses all the sites on the web -- well, they hope it's all of them -- and stores information about, or a complete copy of, each page they find. These pages are stored in their database on their big, fire-breathing computers (it's a staggering amount of data) and that's what the _other_ piece of software, the search engine, looks through when you do a search. The spambots do basically the same thing -- they gather up web pages. They, however, simply extract anything that looks like an email address. These lower-than-pond-scum then add that to their database (350 MILLION TARGETTED EMAIL ADDRSSES FOR ONLY $399.00!) and lie that you 'opted-in' or 'expressed an interest.' Fortunately, search engine page gatherers and spambots can access only 'static' html pages that exist on a server and can be searched. The pages you see when you search the email archive are safe from 'bots because they don't even _exist_ until you ask for them -- they're generated on-the-fly, on demand, and they're sent directly to your computer. The content of the archive is visible only to the person doing the search. So, it's a 99% solution. There's still the chance that an unscrupulous person could go to the effort of doing an archive search in the hopes of getting some email addresses to spam, but that's simply not their style; that's too much like legitimate work. Pirating email addresses is 'profitable' (I guess) if they let a computer do all the work; it's not if a person has to write them down or type them in. There are places that DO put the contents of mailing lists up on the web on static, searchable pages. You should be aware of them so you can make better-informed decisions, and thereby have more control over where your address appears. One site with the MySQL list is http://dbforums.com/f114/. Or try, for example, http://www.mail-archive.com/dbi-users@perl.org/msg06361.html For an interesting exercise, you should try going to www.google.com, or your favourite search engine, and doing a web search on your email address and/or your phone number. The hits you get on that search are the prime places where spambots are getting your email address from. I truly believe we're safe, though I'd love to hear more comments. All the best, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
At 12:10 -0500 2001/12/17, Etienne Marcotte wrote: Netscrap 4.78 oops sorry mispelled that one.. Netscape :) Hmmm. I see you're using Netscape on NT. [X-Mailer: Mozilla 4.78 [en]C-CCK-MCD (WinNT; U)] Haven't tested with that -- I don't have a BillWare OS here -- but friends have accessed the archive from 95, 98, 2000, and XP that I know of. This is the first report that the 'Any Date' selection has not appeared checked by default. Wonder what could be causing it...? The archive has been tested with Netscape 4.0-4.78 on Solaris, Linux (RedHat 7.0), and MacOS; with Mozilla on Linux; with IE on MacOS; with Lynx and even with the browser in 'StarOffice' on Solaris. : I do loads of html and I hate Netscape with a passion, I think 6.2 renders pages like IE4, but I'm not even sure, and only .2% of websurfer use it. www.technodium.net/kira/kira.htm check this out with IE = perfect.. chek it out with NS, different for every version, even if all the tags are ok As for email spamming, you are right, since it's taken from a database. Unless the archive was called e-may, I think we might not have to protect the emails beyond leaving them outside of static webpages:-) That's my thinking... At 12:16 -0500 2001/12/17, Etienne Marcotte wrote: grr e-may my bad meant e-bay two keys beside.. I think I have the shake sorry! Having a bad spelling day, my friend? G Etienne Regards, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Altering an index?
At 11:46 -0500 2001/12/17, Roger Karnouk wrote: Is there a way to alter an index on a table without dropping it and recreating it? I don't think so. See: http://www.mysql.com/doc/A/L/ALTER_TABLE.html HTH, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1006: Can't create database 'mynewdb'. (errno: 28)
Hi John, Just listing the files and directories in your data directory won't tell you (or anyone else here) if you're out of disk space. Try: $ df -k to show your disk free space in K. or, if you're in a directory, try $ du -sk * to show you a disk usage summary, in K, of the things in the directory. At 14:41 -0600 2001/12/17, John Lepone wrote: I don't think I'm out of room on the volume. Below is the directory listing: -rw-rw1 mysqlmysql 0 Dec 13 07:09 mandrake-bin.001 -rw-rw1 mysqlmysql 0 Dec 13 07:12 mandrake-bin.002 -rw-rw1 mysqlmysql 0 Dec 13 07:17 mandrake-bin.003 -rw-rw1 mysqlmysql 0 Dec 13 14:42 mandrake-bin.004 -rw-rw1 mysqlmysql 0 Dec 13 15:25 mandrake-bin.005 -rw-rw1 mysqlmysql 0 Dec 14 03:20 mandrake-bin.006 -rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake-bin.007 -rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake-bin.index -rw-r--r--1 mysqlroot 2874 Dec 17 02:31 mandrake.err -rw-rw1 mysqlmysql 0 Dec 17 02:31 mandrake.pid -rwxr-xr-x1 root root 2530 Dec 13 07:08 my.cnf* drwx--x--x2 mysqlmysql4096 Dec 12 00:24 mysql/ srwxrwxrwx1 mysqlmysql 0 Dec 17 02:31 mysql.sock= drwxr-xr-x2 mysqlmysql4096 Dec 17 09:17 test/ HTH /rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installation trouble with PHP Mysql
Hi Luis, Did you compile PHP to include MySQL? At 13:46 -0800 2001/12/17, Luis A wrote: I have just installed the current version of php and mysql server plus the client. I had apache running already, so that means that I did not have to install it again. When I did a test on mysql to connect i get this error Fatal error: Call to undefined function: mysql_connect() in /var/www/html/test.php on line 3 HTH, /rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: installing solaris binary
Re: MySQLGUI At 17:05 +0200 2001/12/14, Sinisa Milivojevic wrote: Very soon there will be a new executable available. Great news! Thanks very much, Sinisa. /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: sub selects
At 12:50 -0800 2001/12/14, Joel Wickard wrote: can you perform sub selects in mysql? The quick answer is coming soon. Please see: http://www.mysql.com/doc/D/i/Differences_from_ANSI.html and http://www.mysql.com/doc/T/O/TODO_future.html HTH /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Fw: timestamp additional info
At 12:18 -0800 2001/12/14, Steve Osborne wrote:
Timestamp additional info:
INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
VALUES ('$NameID','1','$RegNumc','NULL');
ProdRegDate is the field that I want to timestamp. (Again, I've tried
passing '', NULL, and 'NULL').
Steve
Hi Steve,
You don't need to (and shouldn't) specify the timestamp field in your query at all. If
it's defined in the table, it'll update automatically when you insert or update the
record.
In the example above, you're specifically setting it to NULL or an empty string --
it's taking it's best shot, and filling the column with '0's. :
HTH
/Rob
~
Robert Alexander, Alpha Geek, Workmate.ca
WWW Database Applications and Web Hosting
http://www.workmate.ca 416-823-6599
mailto:[EMAIL PROTECTED]
Life's unfair - but root password helps!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 Searchable Mailing List Archive now up.
Hi everyone, Just want to make a very brief announcement. I've seen a few mentions in the recent past of the desire for a searchable archive of the MySQL list. I've wanted one, too. So, being ahem 'between contracts' right now, I decided finally to write one. I've actually been keeping an archive of the MySQL list for quite a while in anticipation of doing this some day. Just doin' my bit... The archive is at http://archive.workmate.ca/myarchive It's still in BETA, so this is a test release to see how it holds up. It's fully searchable on Subject or Body, on the From address, and by date range. It's running on a reasonably decent box (a Sun Ultra 1), but on a fairly slow connection (for now). The pages are quite compact, though, so as long as not everybody hits it at once, it should give pretty decent performance. : Written in Perl with MySQL as the backend, of course. : The archive is updated in real-time as the mails arrive, so it should always be up-to-the-minute. Take a minute and let me know what you think -- it's a work in progress, and feedback is appreciated. Thanks, all! /Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Alpha Linux binary distribution: Core dumped onAlphaServer 1200
Sinisa Milivojevic [EMAIL PROTECTED] writes: Ron Jamison writes: Using MySQL 3.23.46 from: http://prdownloads.sourceforge.net/mysql/mysql-3.23.46-unknown-linux-gnu-alp Try a binary from our site. The above one _is_ your site, isn't it? -- Trond Eivind Glomsrød Red Hat, Inc. The actual MySQL site is, predictably enough, www.mysql.com. For downloads, try: http://www.mysql.com/downloads/ HTH, /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Alpha Linux binary distribution: Core dumped onAlphaServer 1200
At 14:51 -0500 2001/12/13, Trond Eivind Glomsrød wrote: I know that, but I'm pretty sure sourceforge is one of their mirrors. -- Trond Eivind Glomsrød Red Hat, Inc. At 12:04 -0800 2001/12/13, Ron Jamison wrote: SourceForge is indeed one of their mirrors. Robert if you look you'll see Monty listed as a project admin. I find it easier to download direct from the sourceforge mirror than to navigate through the new download system on mysql.com. I hate it when I wget an html file instead of the tarball I'm seeking. Ahh, OK. Didn't know about the SourceForge site. I've always just used the 'home' site. Thanks, /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: adding space fill to field
I need to suuply an exact number of bytes in a database dump. When using VARCHAR(21) and only using 18 characters, how do you fill in the rest with forced spaces? Take a look at the LPAD() and RPAD() functions. HTH /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql 4.0
I'm getting the exact same error when trying to install MySQL 4.0 on RedHat 7.0 -- both the binary distribution and the RPM. Previous binary versions of MySQL have worked just fine on the same machine. /Rob At 10:07 -0800 2001/12/06, em huynh wrote: I also tried using the binary distribution. and get the following error when trying to start Starting mysqld daemon with databases from /usr/local/mysql/data /usr/local/mysql/bin/mysqld_safe: line 278: 9578 Illegal instruction $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 011206 02:51:49 mysqld ended ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mail_to_db.pl to ReRoute Misdirected Mail
At 16:58 -0700 2001/12/06, Van wrote: Over the past weekend I pulled a server off-line and about a hundred messages got misrouted to the postmaster. Has anyone ever used the mysql perl scripts for mail to manipulate mail messages for rerouting? I'd like to strip all the administrative notices from the messages and have them forwarded off to their proper owners brand new. Hi Van, I've played with the mail_to_db.pl script a fair amount -- I've created a searchable mailing list archive that uses that script, with some mods, to populate the database. Be sure you're using a fairly recent version of the script, I started with v2.3. Close to the beginning of the program you'll see where an array called '@remove_tail' is defined. It contains the REGEX strings to be matched, and then stripped, from the end of the message. Just edit the elements of the array to be whatever you need, and you should be fine. HTH, /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL graphical front-end for Mac OSX
At 18:07 -0700 2001/12/06, René Fournier wrote: Does anyone know if such a thing exists? (Especially a freeware one?) I'd like to be able to create and modify table structures without hitting Terminal everytime. I was using MySQLFront on Windows for this, and it was quite nice. The only problem is... It's only available for Windows. ...Rene For Mac Classic environment - MacSQL Monitor. Shareware and very good. http://www.rtlabs.com/ For OS-X, any of a great variety of Unix/Linux tools. How about MySQL GUI? MyPHPAdmin? : HTH /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error trying to create InnoDB database. HELP
At 10:08 -0700 2001/12/05, Weaver, Walt wrote: When I start up mysqld, the datafiles and logfiles are created just fine. But, when everything is done the following error appears: /usr/local/mysql/mysql-3.23.44-innodb/libexec/mysqld: Table 'mysql.host' doesn't exist This may be an obvious one, Walt, but did you run the mysql_install_db script as part of your installation? This script creates the basic tables MySQL needs. It's in .../scripts/mysql_install_db You also need to edit the my.cnf file. See section 2.3.1 Quick Installation Overview in the manual. If you've done all this stuff, then you may want to check for proper pathnames and permissions. HTH /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: optimize for SELECTs on multiple large tables
At 14:45 -0800 2001/12/05, Florin Andrei wrote: The problem is, MySQL-3.23.46 takes forever to return from SELECT (i let it run over night, in the morning i still didn't got any results, so i killed the query). Hi Florin, It would help if you could also provide: the hardware and OS the actual query (formatted to be readable, please : ) There's not really enough info in your posting to hazard a guess on a solution. Regards, /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: queries on particular table produce errors
At 15:55 -0700 2001/12/05, Alex Pukinskis wrote: group is a reserved word, use groups as table name That being the case, how do I drop or rename a table called group? Try: ALTER TABLE 'group' RENAME new_table_name HTH, /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Very large table load/index questions
Hi Barry, It is, indeed, faster to load the data then create the indexes. Instead of 'disable' and 'enable', you could try: - ALTER TABLE DROP index (or drop the table and create it without indexes.) - load your data - ALTER TABLE ADD index HTH, /Rob At 09:40 -0500 2001/12/04, Barry Roomberg wrote: The actual load of a single table takes about 1/2 hour, but indexing takes DAYS. I've recompiled '--with-raid' which allows me to create a table big enough. snip According to the docs, it seems that the following sequence should be faster: Create WITH indexes defined. Alter table disable indexes. Load data. Alter table enable indexes. The 'enable' and 'disable' seem to be strictly a MySQL 4.0 command, which I didn't initially DL, so I'm setting that up now. ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Settings
Hi, Take a look at the files: -rw-r--r-- 1 root other 2534 Oct 11 22:40 my-huge.cnf -rw-r--r-- 1 root other 2512 Oct 11 22:40 my-large.cnf -rw-r--r-- 1 root other 2496 Oct 11 22:40 my-medium.cnf -rw-r--r-- 1 root other 2211 Oct 11 22:40 my-small.cnf found in the support-files directory in your MySQL installation (usually /usr/local/mysql/support-files) and read about the my.cnf file in the manual at: 4. MySQL Database Administration - 4.1 Configuring MySQL - 4.1.2 my.cnf Option Files. This will give you a good start on setting up your server. All the best, /Rob What information would you need to recommend the initial settings for a MySQL server. We are about to deploy a new server and move our website over to the server and I would like to have a somewhat optimized configuration from the start. Let me know what you need, and I'll provide it. Thanks, P ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mac OSX and MySQL
At 22:24 -0700 2001/12/04, René Fournier wrote: The migration continues... Now I have to get my mysql database running under MySQL 3.23.46 on OSX 10.1.1. I've dumped the structure and contents of the database (on Windows) into a text file, and now I'd like to recreate it in the new enivronment. I think I can use the mysql admin tools via command line (but really, what is the syntax for piping a 'dumped' database into a new database? mysqladmin create database dumpeddb.sql??), but one question about users... Allo René, Depending on the command you used to dump the data, the table creation commands will already be in the mysqldump file. You can look at it with a text editor. Your guess was almost right. : To bring the dump into your new database, just do: mysql database_name -p backup_file.sql The '-p' will prompt for your password. There's a bunch of good info in the manual about this. Check out 4.8.5 mysqldump, Dumping Table Structure and Data. I have to create a MySQL for my PHP scripts. How do I do this in Mac OSX? There are a bunch of command line tools, but I'm not sure which one[s] to use. Not sure I understand this question. What do you mean by create a MySQL for my PHP? Thanks. ...Rene Hope this helps, /Rob ~ Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 to add NOT NULL to a column in my table
At 15:34 -0500 2001/11/24, Barbara Ferrell wrote: it is a primary key..i did not assign either NULL or NOT NULL when i created it. i tried all kinds of commands in the MYSQL books.. i am in Linux... Try the most excellent documentation, either online at www.mysql.com or the one that came with your distribution. Look for 'Alter Table.' HTH, /Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 to Access MySql Database?
Did you *start* mysqld? : Sounds to me like mysqld hasn't been launched. Check to make sure the server software is actually running. HTH /Rob Hi: I telnet to the server. But I can not get into MySql database. What's the problem? % mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' -- Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: myisamchk/corrupt tables
At 04:38 -0500 2001/11/16, Jennifer Slis wrote: when I type myisamchk my server claims command not found. Check to see that myisamchk is in your path. Or go directly to the /usr/local/mysql/bin directory (or where ever it's installed) and type ./myisamchk [options] HTH /Rob -- Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: why ever use TINYBLOB/TEXT -- isn't VARCHAR same size? (fwd)
At 16:07 + 2001/11/13, Carl Troein wrote: //C - with a runny nose, a cup of tea, and a glass of Laphroaig ...for medicinal purposes, of course. : My choice was McClellands, when reduced last week to a sorry-ass blob of protoplasm by the worst cold I've had in years. Feeling much better now. Hope you are, too. Yours in fine malts, /Rob -- Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Show query page by page
Hi, I have a query result with 50 register and i want to show them in 5 pages, every page show 10 register. Thanks , for your answers Rhony http://www.mysql.com/doc/S/E/SELECT.html See 'LIMIT' /Rob -- Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Search Engines
Hello Karl, Try the 'FULLTEXT' section of the manual. I've used the fulltext index to create a search engine for a mailing list archive, and I'm quite pleased with how it works. http://www.mysql.com/doc/F/u/Fulltext_Search.html /Rob Karl J. Stubsjoen wrote: Hello, I need to create a search engine out of a few MySQL tables I should say: I need to search MySQL records like a search engin might. However, my first go ended up as a complete failure because it is highly un-optimized to search for (as an example) %apple% in all of the available text fields. Any ideas about where I can look to set up a database optimized for searching in this way? -- Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] Life's unfair - but root password helps! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 to Get the New Number inserted in a AutoIncrement Field
http://www.mysql.com/doc/G/e/Getting_unique_ID.html HTH, /Rob I know that this is a old question, but I really need to know how can I get the number that Mysql use in a autoincrement field of a record I just inserted ... Is there any function like LAST_INSERTED or something like that ... Thanks a lot - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 FOUND_ROWS() function -- documented anywhere?
Hi all, In the 4.0 manual, section F.1.1 Changes in release 4.0 it says: Added SQL_CALC_FOUND_ROWS and FOUND_ROWS(). This makes it possible to know how many rows a query would have returned without a LIMIT clause. Unfortunately, I can't find any other references to FOUND_ROWS() in the manual, or when I do a search for it in the documentation on the MySQL site. This function would be very handy for me in an application I'm working on. I tried it in the client, for example: mysql select col1, col2 - from tbl - where col2 5 - limit 10; And I got 10 rows back. I then did: mysql select found_rows(); - 10 then; mysql select col1, col2 - from tbl - where col2 5 and got back 32 rows mysql select found_rows(); - 32 This doesn't seems to be working as the brief description would seem to indicate. What am I missing? Thanks! /Rob -- Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
the FOUND_ROWS() function -- documented anywhere?
Hi all, In the 4.0 manual, section F.1.1 Changes in release 4.0 it says: Added SQL_CALC_FOUND_ROWS and FOUND_ROWS(). This makes it possible to know how many rows a query would have returned without a LIMIT clause. Unfortunately, I can't find any other references to FOUND_ROWS() in the manual, or when I do a search for it in the documentation on the MySQL site. This function would be very handy for me in an application I'm working on. I tried it in the client, for example: mysql select col1, col2 - from tbl - where col2 5 - limit 10; And I got 10 rows back. I then did: mysql select found_rows(); - 10 then; mysql select col1, col2 - from tbl - where col2 5 and got back 32 rows mysql select found_rows(); - 32 This doesn't seems to be working as the brief description would seem to indicate. What am I missing? Thanks! /Rob -- Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SUMMARY: the FOUND_ROWS() function -- documented anywhere?
My thanks to Paul DuBois, who responded within about a minute of my first posting. : (Original question below.) The solution is that SQL_CALC_FOUND_ROWS needs to be included in the original SELECT query in order for FOUND_ROWS() to have the proper value. SELECT SQL_CALC_FOUND_ROWS col1, col2 FROM tbl WHERE col2 2 LIMIT 10; You'll get back 10 rows. SELECT FOUND_ROWS(); You should get back a value of 32. Note that there's no comma after SQL_CALC_FOUND_ROWS. original question --- At 11:21 PM -0500 10/31/01, Robert Alexander wrote: Hi all, In the 4.0 manual, section F.1.1 Changes in release 4.0 it says: Added SQL_CALC_FOUND_ROWS and FOUND_ROWS(). This makes it possible to know how many rows a query would have returned without a LIMIT clause. Unfortunately, I can't find any other references to FOUND_ROWS() in the manual, or when I do a search for it in the documentation on the MySQL site. This function would be very handy for me in an application I'm working on. I tried it in the client, for example: mysql select col1, col2 - from tbl - where col2 5 - limit 10; And I got 10 rows back. I then did: mysql select found_rows(); - 10 then; mysql select col1, col2 - from tbl - where col2 5 and got back 32 rows mysql select found_rows(); - 32 This doesn't seems to be working as the brief description would seem to indicate. What am I missing? -- Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Index problem (I think) with MySQL 3.23.36 on Solaris
Hi all, mysqld seems to 'hang' under certain circumstances when I'm doing a fairly large ALTER TABLE -- adding or dropping an Index, repair etc. The server and client are still 'alive' and I can do simple things like show processlist, or selecting a count(0) from another table, but other selects or updates of other tables just sit there forever in the process list. mysqld's server usage goes up to over 99%, and the files for the table being ALTERed (in the data directory) are no longer being updated -- the size, last modified time, etc, do not change. It seems that if I issue just the ALTER TABLE statement, and then don't try to do ANYTHING else, it'll complete successfully (eventually), but if I issue ANY other select/update statement on another table, the CPU goes up to 99% and everything just stops. I'm running MySQL v.3.23.36 binary on an UltraSparc 1 with Solaris 8 (patched to 2001/04 IIRC). Any hints, ideas, suggestions? Any additional info I can provide? Thanks much, everyone. I'll summarize. Best, /Rob ~ Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Index problem (I think) with MySQL 3.23.36 on Solaris -- hang
Responding to my own email... sheesh. It's just that kinda day. : I found reference in the archives to what seems to be the same problem. Monty replied to a thread entitled I got it hanged ! on 2001-07-17, and agreed that it shouldn't be happening. Unfortunately, I can't find a solution in the archives. I've had to shutdown mysqld. mysqladmin -p shutdown prevents the client from connecting, but the process still shows up with ps -ef | grep mysql. I eventually had to issue a kill -9 finally to remove it. Think I'm gonna install 4.0, but I'm still interested in a solution to this problem. Thanks all, /Rob At 15:05 -0500 2001/10/30, Robert Alexander wrote: Hi all, mysqld seems to 'hang' under certain circumstances when I'm doing a fairly large ALTER TABLE -- adding or dropping an Index, repair etc. The server and client are still 'alive' and I can do simple things like show processlist, or selecting a count(0) from another table, but other selects or updates of other tables just sit there forever in the process list. mysqld's server usage goes up to over 99%, and the files for the table being ALTERed (in the data directory) are no longer being updated -- the size, last modified time, etc, do not change. It seems that if I issue just the ALTER TABLE statement, and then don't try to do ANYTHING else, it'll complete successfully (eventually), but if I issue ANY other select/update statement on another table, the CPU goes up to 99% and everything just stops. I'm running MySQL v.3.23.36 binary on an UltraSparc 1 with Solaris 8 (patched to 2001/04 IIRC). Any hints, ideas, suggestions? Any additional info I can provide? Thanks much, everyone. I'll summarize. Best, /Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
just found out this list is being published on the web
Hi all, I just found out, while looking for other things, that what seems to be the entire content of the MySQL list is being published on the web. I, for one, really don't like this idea. I have a reasonable expectation that what I post here is for viewing by subscribers to this list, the MySQL community, not the whole world. I realize that a mailing list is not *real* private -- anyone can subscribe, after all -- but I sure don't like discovering, for example, my personal email addresses on web pages that are available to spambots. The site in question is http://dbforums.com. Try, for example, http://dbforums.com/t147187.html I certainly haven't consented to my personal speech and writing being used as a commercial operation's content. I don't consider publishing my writing on a public web page without my knowledge or consent to be fair use. I'm not talking about a searchable mailing list archive; that is certainly reasonable fair use. A searchable archive creates pages on demand for the person requesting them, and doesn't leave them on the web to be found by search engines and 'bots. Dear MySQL folks, Have you given permission to dbforums.com to publish the content of this list? Thanks everyone. Best, /Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SUMMARY: Problem with myisamchk -- what am I missing?
Hi all, I'd like to thank Gordon Burditt for responding to my question. (Original question below.) It seems I was invoking myisamchk incorrectly. Rather than doing: # myisamchk mailtable ...I was specifying both the data and index files, like this: # myisamchk mailtable.MYD mailtable.MYI I think what confused me was this sentence from the manual (Chapter 15.1 Using myisamchk for Table Maintenance and Crash Recovery, 2nd paragraph): To check/repair MyISAM tables (.MYI and .MYD) you should use the myisamchk utility. Thanks, Gordon, for clarifying that for me. : Best, /Rob At 00:43 -0500 2001/10/21, Gordon Burditt wrote: As near as I can tell, you DON'T pass *.MYD files to myisamchk, just *.MYI files. What's wrong with the *.MYD file is that it is not and never was an index. --- original question --- At 15:50 -0400 2001/10/20, Robert Alexander wrote: Hi all, I'm in the process of writing a searchable mailing list archive in Perl MySQL. I'm using Monty's old mail_to_db.pl script (which I got from the MySQL site long ago) to load emails from their mailbox into MySQL. Runs just fine, BTW. However, when I run myisamchk on the mail table, it says: # myisamchk mailtable.MYD mailtable.MYI myisamchk: error: 'mailtable.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair - Checking MyISAM file: mailtable.MYI Data records: 99 Deleted blocks: 0 - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links ...but for the life of me, I can't see what's wrong with the index definition. (See info below.) I've read all the pertinent manual chapters (I think), I've dropped and recreated the table several times, and imported the data by a couple different methods. Still keep getting the error. The table in question has only 99 records in it right now. Can anyone spot what I'm missing? Or point to towards some more info? Thanks very much! All the best, /Rob Here's the vital information: MySQL 3.23.36. Solaris 8 on a Sun UltraSparc 1. Perl 5.6 Table: DROP TABLE IF EXISTS mailtable; CREATE TABLE mailtable ( msg_nromediumint unsigned NOT NULL auto_increment, date DATETIME NOT NULL, time_zone varchar(6) NOT NULL, mail_from varchar(120) NOT NULL, reply varchar(120), mail_toTEXT, cc TEXT, sbjvarchar(200), txtMEDIUMTEXT NOT NULL, file varchar(32) NOT NULL, hash INT NOT NULL, KEY (msg_nro), PRIMARY KEY (mail_from, date, time_zone, hash) ); desc mailtable; +---+---+--+-+ -++ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+ -++ | msg_nro | mediumint(8) unsigned | | MUL | 0 | auto_increment | | date | datetime | | PRI | -00-00 00:00:00 | | | time_zone | varchar(6)| | PRI | || | mail_from | varchar(120) | | PRI | || | reply | varchar(120) | YES | | NULL || | mail_to | text | YES | | NULL || | cc| text | YES | | NULL || | sbj | varchar(200) | YES | | NULL || | txt | mediumtext| | | NULL || | file | varchar(32) | | | || | hash | int(11) | | PRI | 0 || +---+---+--+-+ -++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Proposed Guidelines for Posting to the MySQL list
on the list would not be able to read easily. Also, the business language of MySQL is English, so please post in English. You're also much less likely to get a response to your question in other languages. Please note that we are not saying these postings are necessarily bad or stupid. They are not. They are merely inappropriate for this list. There are many other lists and newsgroups for which the question may be completely appropriate, and we encourage you to submit the posting there. Note also that there's a good chance your question has been answered in the past. Please spend a minute or two checking one of the MySQL List archives, eg. the one at the MySQL site (http://lists.mysql.com/). Here's an example of an appropriate question: I have a SuperServer X99 running BigLinux 9.8.7 with the fizbozz patch and the jumbo kernel patch version 158. I'm using MySQL v.52.4.1 After I installed the MySQL-WonderTable plug-in version 343.2, the machine locks up every couple of hours. When it locks up, the following message appears on the console: zz0: out of futzbufs. WonderTable space is full. This isn't covered in the manual, and I need to get this database back online as soon as possible. Has anyone encountered this? Please send email and I will summarize to the list. When you submit a question, please indicate all relevant information, including machine type, OS, MySQL version and patches, the table structure, and the query, if appropriate. Collect email replies, and then summarize them to the list. If your question was posted with a subject of foobar, for example, then please post your summary with a subject of SUMMARY: foobar. Why are we asking that only certain types of postings be submitted to the list? Very simply, the reason is this: we want the list to have a very short turnaround time, and the only reasonable way to do this is to keep it unmoderated. But this means that every message sent to the list ends up in the mailboxes of all the list members. To keep all the members of the list from being deluged by inappropriate messages, we need everyone's co-operation in ensuring that only appropriate messages are sent to the list. Please remember, the person reading your message may be your boss, your future boss, your customer, your seminar instructor, your colleague, or someone else that you work with today or may find yourself working with tomorrow. We do not want you to embarrass yourself by sending an inappropriate or poorly thought-out posting. Regards, /Rob Robert Alexander [EMAIL PROTECTED] Proposed MySQL Posting Guidelines Maintainer http://www.ra1.net http://www.workmate.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Proposed Guidelines for Posting to the MySQL list
Robert Alexander wrote: - Replies are directed to the POSTER and not to the list. This keeps traffic and clutter down. At 22:12 +0100 2001/10/21, Mark Maunder wrote: Other authors wont be able to participate in a discussion and there wont be the public aggregation of viewpoints - just a reliance on the original poster (many of whom are newbies) to consolidate all replies they receive and post a coherent summary based on individual emails. At 14:45 -0700 2001/10/21, Dennis Salguero wrote: This is one of the few points I disagree with. The archives of this list, if used properly, is probably one of the best support resources out there right now. One of the reasons is because there tends to be some back-and-forth until a correct answer is determined. Following the thread of responses to a particular query can be of great benefit. At 18:19 -0400 2001/10/21, Victor wrote: This I think is the only point that I have an issue with. If you look above, there are two (at least right now) replies posting that this is a bad idea. however if all those replies went to the recepient, I wouldn't have known that this is posted and would post the same thing again. Thanks so much for taking the time to respond, guys. There does seem to be a general consensus about keeping more discussion on the list. I confess it's one of the points I thought longest about. The SunManagers list is much more of an I need a solution NOW kind of list, whereas the MySQL list has always had more open discussion. As a matter of fact, the SunManagers list has no discussion whatsoever. Ideally, the only postings there are question and summary. It doesn't always happen that way, of course, but that's what's strived for in that list. I don't think I'd want the MySQL list to be completely 'discussion free' either. That's why I included this: In particular, the following kinds of postings are NOT appropriate: snip - Extended discussions about anything, including discussions about the list itself, or numerous followups to any posting. Which would allow for some discussion, just not long, wandering, rambles. : Is that enough? Do we need more? How do we walk the line between keeping lively discussion, and reducing the bulk of postings? (open for ideas...) --- At 14:45 -0700 2001/10/21, Dennis Salguero wrote: That's great! Overall, I think that these guidelines have a lot of merit, but I can't help but feel that they should be coming more from MySQL AB, than the list itself. If they have a vision for the resource that the mailing lists should provide, then its guidelines should come from MySQL AB. Thanks Dennis. IRT MySQL AB, I don't think I'm stepping on anyone's toes, here, and it's certainly not my intent to dictate policy to the list or anyone else. If I am, I'm sure someone from MySQL will let me know, at which point I'll gracefully bow out. This is simply a proposed set of guidelines, meant to stimulate an exchange of ideas, and lead to an even better discussion group. This is an Open Source community, after all, : and I think it's important to contribute. I'm just trying to do a bit of my part, even if it's a relatively small task like this. Whatever 'culture' or 'style' our on-line list community has is ultimately determined by the actions of the individual people involved. If we can collectively agree on some basic rules, we all benefit. --- At 18:19 -0400 2001/10/21, Victor wrote: Another problem: suppose there are two solutions: a well known and not so well known. Suppose someone asks something and the first thing people do is send the well known idea. However if that doesn't work, since there is no feedback, noone even thinks to send the secondary rare idea (that might not even come to mind). Also, someones reply might be helpful but not great and someone else on the list might, looking at the reply, come up with an even better posting. The problem here is that usually posters will get a gazillion mails with same reply instead of two or three with possibly unique solutions. At 14:45 -0700 2001/10/21, Dennis Salguero wrote: See above; this archive is a great resource because all answers stay on the list - we should definitely try to keep it this way. Well, if people post their summaries, then the answers WILL always be in the archives, won't they. : And in a more concise, usable form because you won't need to search through multiple messages to find that bit of wisdom you need. Also, I've seen it happen often that someone may read a SUMMARY and realize that they have something to add to the solution. That idea is also sent off the original question-asker, who posts another summary. It's not uncommon to see second, and sometimes even third, summaries to the same question. Thanks, /Rob - Before
Problem with myisamchk -- what am I missing?
Hi all, I'm in the process of writing a searchable mailing list archive in Perl MySQL. I'm using Monty's old mail_to_db.pl script (which I got from the MySQL site long ago) to load emails from their mailbox into MySQL. Runs just fine, BTW. However, when I run myisamchk on the mail table, it says: # myisamchk mailtable.MYD mailtable.MYI myisamchk: error: 'mailtable.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair - Checking MyISAM file: mailtable.MYI Data records: 99 Deleted blocks: 0 - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 - check record links ...but for the life of me, I can't see what's wrong with the index definition. (See info below.) I've read all the pertinent manual chapters (I think), I've dropped and recreated the table several times, and imported the data by a couple different methods. Still keep getting the error. The table in question has only 99 records in it right now. Can anyone spot what I'm missing? Or point to towards some more info? Thanks very much! All the best, /Rob Here's the vital information: MySQL 3.23.36. Solaris 8 on a Sun UltraSparc 1. Perl 5.6 Table: DROP TABLE IF EXISTS mailtable; CREATE TABLE mailtable ( msg_nromediumint unsigned NOT NULL auto_increment, date DATETIME NOT NULL, time_zone varchar(6) NOT NULL, mail_from varchar(120) NOT NULL, reply varchar(120), mail_toTEXT, cc TEXT, sbjvarchar(200), txtMEDIUMTEXT NOT NULL, file varchar(32) NOT NULL, hash INT NOT NULL, KEY (msg_nro), PRIMARY KEY (mail_from, date, time_zone, hash) ); desc mailtable; +---+---+--+-+ -++ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+ -++ | msg_nro | mediumint(8) unsigned | | MUL | 0 | auto_increment | | date | datetime | | PRI | -00-00 00:00:00 || | time_zone | varchar(6)| | PRI | || | mail_from | varchar(120) | | PRI | || | reply | varchar(120) | YES | | NULL || | mail_to | text | YES | | NULL || | cc| text | YES | | NULL || | sbj | varchar(200) | YES | | NULL || | txt | mediumtext| | | NULL || | file | varchar(32) | | | || | hash | int(11) | | PRI | 0 || +---+---+--+-+ -++ ~ Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: REMOVE NOW THIS IS THE SECOND TIME
Good words, Mauricio. /Rob Toronto, Ontario, Canada Ob. MySQL: database, sql, query, table ;-) and can't read either ;) c'mon guys... lets keep the ethnic humour down... i'm sure it does not do any good to business, although it sure, well, tingles sometimes... we all have our natures, cultures, surroundings, and, understanding and respecting, clears boundaries and improve overall communicability. my warmest regards to all mauricio portasio [EMAIL PROTECTED] sao paulo - brazil ~ Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: command line open source ARRRGGGGGG!!!!!!
At 23:07 -0700 2001/09/06, Chadrick Mahaffey wrote: I realize that I'm going to be in the minority here but I have to say it. Open source would go much farther if they had self explanatory GUIs and had basic pre-setup apps that were ready for the average user to use. I program in Java and I feel the same about the JDK Sun produces. I use JCreator because it has an easy to follow GUI interface. Most open source apps I have attempted to use have some of the worse documentation around. The writers assume so much about the users. OK - call me inept, stupid, or whatever but I had to say it. Thanks, THE chad Hi Chad, I feel your pain... : I come from a predominately GUI environment, too. But, if you've gotten this far, I doubt very much that you're stupid -- just inexperienced with this type of app and these methods. MySQL actually has very good documentation; you're just looking in the wrong area. Try the Windows-specific installation instructions instead of the Unix ones. Granted, working at the command-line can be daunting at first with all those cryptic and arcane instructions, *but* it's also very powerful; you can accomplish difficult things very quickly once you're used to it. (Definitely true in Unix, I'm unsure about Windows.) Both GUIs and the command-line have their place, and their strengths and weaknesses. I wouldn't want to do without either. I learned 'command-line stuff' on Sun Solaris and Linux. What a bitch it was the first time I installed one of those boxes from scratch (and then learned how to compile and build software). But, ya know, even though it may (initially) be a lot of difficult work to configure and set one up, there's a big pay-back. Once it's done, you've got a nearly bulletproof, rock-solid, absolutely dependable computer. My Sun boxes simply *never* crash. Hell, I'd be frustrated and pulling my hair, too, if I had to sit down and attempt an install on Windows. I've never done it, so it'd be a completely new, confusing, and seemingly idiotic procedure for me. But I'm pretty sure I'd eventually get through it. : So dive in, get your hands dirty, read lots, and it'll start to make sense pretty quickly. Good luck. May the foo be with you. : /Rob ~ Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Let's approach stored procedures
Hi Claudio, I think having the functionality of stored procedures would be a wonderful addition to MySQL. Let me be the first to say a hearty 'Thank you!' for your very generous offer to devote your vacation time to this task. I like Oracle's PL/SQL. I've used it a fair amount, and it get's the job done. PL/SQL = Procedural SQL -- SQL plus procedural logic. This has the advantage of being a language that uses the SQL that we all already know and love, plus enough procedural things -- loops, conditionals, etc. -- to implement logic. It's more a programming language than just a query language. This is a good thing. That being said, I don't think re-implementing PL/SQL is necessarily the way to go for MySQL. There may indeed be proprietary issues (though I'm not sure) and I think it'd be possible to take a more 'open source' approach. Let's remember what we want to accomplish with stored procs; that is, the ability to store server-side logic where we can implement such things as business rules, and ensure consistency in the way 'front-ends' of whatever flavour (and probably written by different programmers) perform transactions with the dataset. In my opinion, it'd be great if the choice of the server-side procedural language could be left up to the developer/DBA. Perhaps a method whereby the stored proc would then call a script in [language-of-choice] and then accept the returned results. I realize that that method is not as tightly 'married' to MySQL as an internal PL/SQL-like language would be and, depending on the scripting language, may have a bit of a performance hit, but it does allow more freedom for the DBA in the tools to choose from. Just some thoughts. They're open-source, of course, so do with them what you will. : Best, /Rob Ob. MySQL: database, sql, query, table ~ Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQLGUI
As Ed said, you need to make sure that ld.so.1 is in your path. At 09:03 -0500 2001/09/06, Ed Carp wrote: Isn't there an ldconfig or similar for Solaris? You'd need to configure /etc/ld.so (or whatever the equivalent is on Solaris), then run ldconfig to tell the run-time library loaded where to look for the required libraries. In Solaris, the environment variable is LD_LIBRARY_PATH. Try man ld.so.1. [EMAIL PROTECTED] ([EMAIL PROTECTED]) writes: First, if there is an FAQ or installation documentation please direct me there and I'll review before requesting assistance. If there is neither, I am unable to successfully run mysqlgui on the following platform: Sun Ultra 10 running Solaris 8 with current Recommended installed, mysql version MySQL3.23.41, and mysqlgui-solaris-2.7-sparc-static-1.6.gz. mysqlgui is installed in /usr/local/mysql/bin. I receive the following error when starting the gui: ld.so.1: mysqlgui: fatal: libstdc++.s0.2.10.0: open failed: No such file or directory Killed /usr/local/lib is in the PATH and this file exist with mod = 555. Try man ldconfig. Good luck! -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc ~ Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Licensing terms for an Intranet site
Hi Jay, I'd definitely suspect Outlook (or LOOKOUT! as a few of my network support buddies call it) as the source of the problem, rather than anything to do with Jeremy's emails. I'm having no problems here -- but then again, I don't use any Microsoft products. : Good luck, /Rob As Rob Glaser, a former Microsoft exec, told Time magazine last year, Gates is relentless. He's Darwinian. He doesn't look for win-win situations with others, but for ways to make others lose. Success is defined as flattening the competition, not creating excellence. Ob. MySQL: database, sql, query, table Is anyone else getting a strange flag associated with Jeremy's email, or is it just me? Every one of his posts comes in flagged in Outlook, and the headers have a line which reads: X-message-flag: Mailbox corrupt. Please upgrade your mail software. This is definitely OT for this forum, but this forum is the only place where I see the problem. Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.org
Monty et al and fellow list people, I've been following this thread with interest for the last couple days, have read all the postings (unfortunate flames included), and my opinion has generally been: well, there's been an unfortunate break down in communication between MySQL and NuSphere, I'm sure it's just a mis-understanding, and it'll get sorted out amicably soon. Then I actually went and looked at the mysql.org site. Now I find I must strongly agree with what Andy Wooley wrote: At 15:05 +0100 2001/07/15, Andy Woolley wrote: The impression I get from the .org site, is that they are promoting a product called MySQL, and that MySQL AB (found at mysql.com) is a different product all together. This, is in my opinion is simply not on. I have been using MySQL for many years and I am now wondering if there actually is a difference between MySQL and MySQL AB simply because mysql.org are implying such a fact. Their web site is also giving me the impression that they are responsible for the development of MySQL.I know Nusphere have given both time and money to the development of MySQL but I really don't think it quite justifies building a web site with the intention of deceiving users that may not know the full history of MySQL. I'm no lawyer but I would say that the content on mysql.org is very misleading and should be changed, pronto. I got very much the same impression. Let me expand a bit... 1. it makes sense for an 'Open Source' project to have a .org TLD, many of them do. 2. on the Home page it says: - its a center for free downloads, information and communication, as well as all the files you need to build applications based on MySQL, the #1 open source database. - mySQL.org offers easy access to the best binaries and source available to database programmers. - For those willing to help maintain the code, documentation, or support resources, please email [EMAIL PROTECTED] - For those of you interested in getting other sites or books added to our list of MySQL resources, please send email to [EMAIL PROTECTED] Then, at the bottom, it says that it's not affiliated with some company called 'MySQL AB.' Nowhere does it say that 'MYSQL AB' *is* MySQL: the company that has created, developed, promoted, and is the *owner* of the MySQL database engine. It looks very much like 'MySQL AB' is some other company that happens to have a similar name, especially considering that most people will know it simply as MySQL, not by the formal 'MySQL AB.' So it would be very easy for a recent arrival to assume that mysql.org is *the* MySQL site -- there's really nothing telling them otherwise. The creators of the mysql.org site did not go to any effort to make the situation clear -- on the contrary, it seems to step very carefully *around* mentioning that MySQL is someone else's property. Something like this doesn't happen by accident and, legal-babble aside, these are, quite simply, not the actions of one who's respectful of other's work and property, and not the actions of one who's dedicated to open communication and a win/win partnership. I find it dishonourable. It leaves a pretty bad taste in my mouth. /Robert Alexander Ob. MySQL content: database, sql, query, table ~ Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca The edifice of civil rights has degenerated into a naked spoils system. ... laws have come close to outlawing undesired thought. The iron rule of political correctness has distinct resemblance to Soviet-style social control. Much of this is imposed less by the official government than by the meta- government of academia, media, and Hollywood. Yet it's there. -- Fred Reed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: good backup and maintain scripts
DBS=genldgr ap ar corp misc DUMP=$HOME/archive/dump cd $DUMP DIR=`date | cut -d -f1` mkdir -p $DIR rm -f Today ln -sf $DIR Today cd $DIR for K in $DBS do TBLS=`mysql -N -e show tables $K` for I in $TBLS do mysql -e repair table $I $K mysqldump -q --add-drop-table $K $I $K.$I.dmp rm -rf $K.$I.dmp.gz gzip $K.$I.dmp done done Regards, -- Don Read [EMAIL PROTECTED] Thanks for posting this, Don. I got a lot out of it. Nothing like seeing a good example of commands actually being used. Much appreciated. /Rob ~ Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca The edifice of civil rights has degenerated into a naked spoils system. ... laws have come close to outlawing undesired thought. The iron rule of political correctness has distinct resemblance to Soviet-style social control. Much of this is imposed less by the official government than by the meta- government of academia, media, and Hollywood. Yet it's there. -- Fred Reed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: urgent!!
I don't see how this could possibly be an urgent request. You haven't even started the project design yet. Now, if the project were all done, and you're scheduled to go live with it tomorrow, and you suddenly discover that all your indexes are corrupt, and the boss is cursing your name -- well _that's_ urgent. : Saying I want to build a database someday is not urgent. Please don't cry wolf. Anyway, start with the MySQL manual, and any of a great number of basic books on data design and SQL. Can anybody please help me with the making of this database or atleast guide me with the making of this..please. Thank You good luck, /Rob ~ Robert Alexander ~~ Software Designer/Analyst/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca I give you this one rule of conduct. Do what you will, but speak out always. Be shunned, be hated, be ridiculed, be scared, be in doubt, but don't be gagged. -- John Jay Chapman, commencement address to the Graduating Class, Hobart College, 1900 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Info on using MySQL with Java
Hi all, I'm looking for some pointers towards some good information on accessing and using MySQL with Java/Javascript. Can anyone point me towards a book you like, or some good web resources? Thanks much, /Rob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
