Re: Putting PCRE in MySQL?
On Wed, Nov 28, 2001 at 11:41:49PM -0800, Brian Aker wrote: On Wed, 2001-11-28 at 22:40, Jeremy Zawodny wrote: Has anyone considered optionally putting PCRE (Phil Hazel's Perl Compatible Regular Expressions -- http://www.pcre.org/) in MySQL so that someone could write: SELECT * FROM mytable WHERE myfield PCRE some_complex_perl_regex; select * FROM table WHERE (myperl(expression, row, row,...)=1); http://software.tangent.org/download/myperl-0.5.tar.gz I should have stated that the reason I want PCRE in MySQL is for those cases when having All Of Perl in MySQL would be a bit of overkill. :-) I've considered using myperl on one of our servers, my I'd like something I can put on all the servers. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 84 days, processed 1,818,725,880 queries (250/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error2
Does anyone know what this error means - General error: Can't find file: 'A.MYD' (errno: 2) I have just installed the InnoDB Database. When I created the table, Mysql created just A.frm file. 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: Date Differance in MySQL
Hi, Select unix_timestamp(Now()) - unix_timestamp(datetime_column) from table_name; At 08:50 AM 29/11/2001 +0100, you wrote: Hi Could i in some way find out the seconds between to datetimes I.E. I have a DATETIME in a table and i want to find out how many second it is from that DATETIME to NOW() Does anyone have an idea? /Jonas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Transferra ing data between mysql and SQL Server 6.5
Hi all! I am trying to get rid of SQL Server 6.5(NT 4.0 server) and replacing it with mysql(Linux 7.0).As an initial step i have to transfer data daily from mysql to SQL 6.5. If anybody know an efficient way to do this.The size of data is 1.5 GB. Regards Manzoor -- ___ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup 1 cent a minute calls anywhere in the U.S.! http://www.getpennytalk.com/cgi-bin/adforward.cgi?p_key=RG9853KJurl=http://www.getpennytalk.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: MySQL 3.23 Manual - PDF
If you wouldn't mind, though I think the folks at MySQL.Com should consider throwing a copy back up. Maybe I'm just a nervous nelly, but I won't be I agree with that. It wasn't really a problem using a manual for a subrevision higher than the version I used, but to V4, some things changed, so the V4 manual is not really helpful. Perhaps the guys at MySQL could just make an additional Sourceforge project (mysql-doc) and dump the old manuals there before removing them from the website. BTW: If you have all the programs available, try a make manual in the Docs subdir. Jens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Beginner - Updating a Table from a File
On Wed, 28 Nov 2001, john wrote: mysql load data local infile '/tmp/Parts.txt' - replace - into table Parts - fields - optionally enclosed by '' - terminated by ',' - ('PN','APN','C','Q','D') Query OK, 100946 rows affected (39.66 sec) Records: 100946 Deleted: 0 Skipped: 0 Warnings: 2 This has only been appended! There has been no update! Effectively, I have just doubled the size of my inventory. I could have accomplished that with out using REPLACE. I believe the reason for not replacing the data is the command does not know how to align itself with CUST_ID = '1'. Does this sound correct? John, is one of your columns in ('PN','APN','C','Q','D') a unique key? REPLACE will check for this. Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Beginner - Updating a Table from a File
On Wed, 28 Nov 2001, john wrote: Yes, but won't this only replace and not load the rest of the items in the file? This is my code, but it only updates the existing items. load data local infile '/tmp/Parts.txt' replace into table Parts fields optionally enclosed by '' terminated by ',' ('PN','APN','C','Q','D'); I have had that chunk of code working for a while, with the exception that sometimes it only appends the items in the file and ignores the replace switch? Wierd, huh? John, The `REPLACE' and `IGNORE' keywords control handling of input records that duplicate existing records on unique key values. If you specify `REPLACE', new rows replace existing rows that have the same unique key value. If you specify `IGNORE', input rows that duplicate an existing row on a unique key value are skipped. If you don't specify either option, an error occurs when a duplicate key value is found, and the rest of the text file is ignored. (quoted from the manual) The file has the twelve fields, five are listed above. I need to add a stipulation to make the CUST_ID = 1. Would that be to add the following line: set CUST_ID = '1' [placed before the replace switch] Is it the IGNORE switch that adds the rest of the items? When using the IGNORE switch, should I use the | between REPLACE | IGNORE as you have done? No '|' means OR, use one switch or the other. If you want to alter data contents while loading it might be better to LOAD into a fresh table and then INSERT ... SELECT from this table. Regards, Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, Red Hat Linux and php
Hello, Which version of MySQL ( RPM packages ) is good for work with php 4.0.6 and Linux Red Hat 6.2 ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GUIfront-end in Linux?
I'm moving from Win2k to Linux and was wondering if there was a GIU MySQL front-end in Linux similar to Mascon or mysqlfront for the windoz Oss. Thanks Frank - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can't make after ./configure
Chang-Ping Hsiao writes: Hi! Thanks for the help. Tried both and both failed. Still get the following. [skip] make[2]: Entering directory `/tmp/mysql-3.23.45/client' /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o mysqlbinlog mysqlbinlog.o ../lib mysql/libmysqlclient.la -lcrypt -lgen -lsocket -lnsl -lm gcc -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o .libs/mysqlbinlog mysqlbinlog.o ../libmysql/.libs/libmysqlclient.so -lcrypt -lgen -lsocket -lnsl -lm -lcrypt -lgen -lsocket -lnsl -lm -R/usr/local/lib/mysql Undefined first referenced symbol in file __cxa_pure_virtual mysqlbinlog.o ld: fatal: Symbol referencing errors. No output written to .libs/mysqlbinlog collect2: ld returned 1 exit status make[2]: *** [mysqlbinlog] Error 1 make[2]: Leaving directory `/tmp/mysql-3.23.45/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/tmp/mysql-3.23.45' make: *** [all-recursive-am] Error 2 Just do what I told you: gcc 3.0.2 is just fine, only set the following : export CXXLD=g++ -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23 Manual - PDF
On Wed, 28 Nov 2001, A. Clausen wrote: That is the MySQL 4.x manual, I'm looking for the 3.23.x PDF-formatted manual. The HTML and text versions supplied with the 3.23 distributions are way too unwieldly, and I'm not going to upgrade my mission critical app to what is apparently alpha software, just so I can have an up-to-date manual. The very fine manual is not distributed in PDF format, because it's much too big in this format. However, you may get your copy without upgrading your software. Just get the latest mysql-3.23.45.tar.gz, unzip, untar, go to the mysql-3.23.45 directory and type: me@host:~/mysql-3.23.45 ./configure to create the Makefiles. Then go to the Docs/ directory and me@host:~/mysql-3.23.45/Docs make manual.pdf ... and have a cup of coffee. You need the GNU TeX-info and pdftex (available from the teTeX package). In case all else fails I put a copy of the manual in PDF format on: http://www.polyreg.ch/ssl/misc/mysqlmanual/ To use the manual on the screen without printing I recommend the pinfo viewer (ver 6.3) and mysql.info This provides for the ease of lynx and the speed of light. Regards, Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 apache php
On Thursday 29 November 2001 02:01, Auri Net SAC wrote: Hi please who knows a package that install apache + php + mysql in linux, i know phptriad but its for windows Thanks for your answer rvj ApacheToolBox http://www.apachetoolbox.com -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Reappraisal, n.: An abrupt change of mind after being found out. */ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: socket filename is truncated in error message
Brian Bartholomew writes: Description: My correct socket filename is: /home/bb/depot/mysql-3.23.43-9a7c0100047f2d1b5c72210d23df8448/tmp/mysql.sock However, the socket filename is truncated in the error message when the database isn't started: % mysqlshow ./mysqlshow: Can't connect to local MySQL server through socket '/home/bb/depot/mysql-3.23.43-9a7c0100047f2d1b5c72210d23df8448/tm' (111) ^ Note that only the error message is truncated, not the filename itself; when the database is running, the connection works. This is simply because we have to limit our errors buffers to some reasonable values. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
please help me
Hi all Iam new to php and iam learning that from scratch.I came across a problem in connecting mysql from php script.I run php in windows2000 under IIS configured to personal web server.I have installed mysql with server and client and both are running in the same machine(ofcourse, i can you use the ipaddress of localhost).I didn't set any username or password with mysql. This is my php script: $link=mysql_connect(localhost); if($link) die(Couldn't connect to mysql.mysql_error() ); print Successfully connected to server; when i execute this program iam getting the following message: Couldn't connect to mysql Anyone please help me as this is very urgent. thanks in advance Regards shahjahan __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Transferra ing data between mysql and SQL Server 6.5
Hi. There may be tools out there but I tend to avoid paying or evaluating a shareware package. There may also be open source that would do it. If you don't find anything and are interested in a Java solution let me know because I have written code to not only transfer data but the (relational) database structure and metadata first and then the data. I can easily modify it to do just the data part after an initial structure transfer. I would like to test it on other scenarios than my own. If you decide to try this solution I will provide the java source code provided you give me feed back on it. Where is a jdbc driver for SQL Server? Regards, Roger - Original Message - From: manzoor sultan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 6:06 AM Subject: Transferra ing data between mysql and SQL Server 6.5 Hi all! I am trying to get rid of SQL Server 6.5(NT 4.0 server) and replacing it with mysql(Linux 7.0).As an initial step i have to transfer data daily from mysql to SQL 6.5. If anybody know an efficient way to do this.The size of data is 1.5 GB. Regards Manzoor -- ___ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup 1 cent a minute calls anywhere in the U.S.! http://www.getpennytalk.com/cgi-bin/adforward.cgi?p_key=RG9853KJurl=http:// www.getpennytalk.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
median function?
Is there a SQL function available for finding the median value from a column of numbers? I see AVG() but no reference to medians. 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: median function?
Hi, Median as a function in sql does not exests that I know of. But if you get a resultset ordered by the column of numbers, you can then pick the median at the row index=n/2 where n is the total number of values in the column? Roger - Original Message - From: Michael [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 8:00 AM Subject: median function? Is there a SQL function available for finding the median value from a column of numbers? I see AVG() but no reference to medians. 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
unicode charset support ?
hi mysql guru's, does anyone put light on the unicode charset support of MYSQL? i searced everywhere in the archives and the docs , but couldn't find a related thing.It seems that it doesn't support, however i am asking you to be sure. My application needs to save both japanese and chinese charsets, thus i must use unicode to support both of those charsets. So far i was using mysql jsut for big5(traditional chinese ) charset, it was working okey.When i try to save japanese characters i am having trouble, the characters become garbled.??? Any one who knows the solution for this. thanks for helping me. (note: my mysql version is 3.23, os is win2000) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: median function?
Roger I Martin PhD writes: Hi, Median as a function in sql does not exests that I know of. But if you get a resultset ordered by the column of numbers, you can then pick the median at the row index=n/2 where n is the total number of values in the column? Roger Nope . Median depends on statistical distribution. There is one that is valid for sampling distribution, but there are still many alternatives. This is something that could be done as an UDF. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: median function?
median (Websters) 1. being in the middle; medial, middle. 2. Statistics. Designating a point so chosen in a series that half of the individuals in the series are on one side of it, and half on the other. To illustrate the distinction between median and average, suppose five persons have wages respectively of $3, $4, $5, $7 and $11. The average wage is $6; the median wage is $5. What statistical distribution is going to change the median from $5? What is the dependency? Redundant numbers do not change the median? Roger P.S. In this case I prefer the max function.:) - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 8:19 AM Subject: Re: median function? Roger I Martin PhD writes: Hi, Median as a function in sql does not exests that I know of. But if you get a resultset ordered by the column of numbers, you can then pick the median at the row index=n/2 where n is the total number of values in the column? Roger Nope . Median depends on statistical distribution. There is one that is valid for sampling distribution, but there are still many alternatives. This is something that could be done as an UDF. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: timely backup
On Thu, 29 Nov 2001, sreedhar wrote: Can you tell how can i do my database backup timely i mean in regular intervals with out explicitly doing by us. Sreedhar, It depends. You have not been extremely verbose describing your actual requirements or your system, but you might look into - a cron job doing the backup by starting a script regularly - replication Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, Red Hat Linux and php
The RPMS that are available from the MySQL WebSite are OK to use on 6.2. I personnaly prefer to use the source or .src RPMS. But the RPMS work fine on my 6.2 box. [EMAIL PROTECTED] wrote: Hello, Which version of MySQL ( RPM packages ) is good for work with php 4.0.6 and Linux Red Hat 6.2 ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
GUIfront-end in Linux?
I'm moving from Win2k to Linux and was wondering if there was a GIU MySQL front-end in Linux similar to Mascon or mysqlfront for the windoz Oss. Thanks Frank Try MySQLnavigator binaries: http://ftp.kde.com/Database/MySQL_Navigator/mysqlnavigator-1.3.3.3.binary.tar.gz sources: http://ftp.kde.com/Database/MySQL_Navigator/mysqlnavigator-1.3.3.3.tar.gz It is not Mascon (BTW, they are planning a Linux version, but I don't know when), but it has a nice graphical interface. Giuseppe Maxia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Beginner - Updating a Table from a File
yes, the PN field is a part number and is intently unique. But this seems to load into CUST_ID=NULL, instead of CUST_ID=1. What can I do to update only for CUST_ID=1? -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 4:26 AM To: john Cc: MySQL Lists Subject: RE: Beginner - Updating a Table from a File On Wed, 28 Nov 2001, john wrote: mysql load data local infile '/tmp/Parts.txt' - replace - into table Parts - fields - optionally enclosed by '' - terminated by ',' - ('PN','APN','C','Q','D') Query OK, 100946 rows affected (39.66 sec) Records: 100946 Deleted: 0 Skipped: 0 Warnings: 2 This has only been appended! There has been no update! Effectively, I have just doubled the size of my inventory. I could have accomplished that with out using REPLACE. I believe the reason for not replacing the data is the command does not know how to align itself with CUST_ID = '1'. Does this sound correct? John, is one of your columns in ('PN','APN','C','Q','D') a unique key? REPLACE will check for this. Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: socket filename is truncated in error message
Sinisa Milivojevic [EMAIL PROTECTED] writes: This is simply because we have to limit our errors buffers to some reasonable values. Are there so many of these filename buffers that they can't be sized to MAXPATHLEN? Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Update not occurring, but myisamchk reports corruption - bug?
Ishis a bug? My table has one row, and my update says it has updated one row, but the data doesn't change. After the update, myisamchk reports the table as crashed. Possibly related, we have occurrences of mysql saying it is unable to open clips.MYD, errno 145. clips.MYD still exists. mysql select version() ; ++ | version() | ++ | 4.0.0-alpha-max-nt | ++ 1 row in set (0.00 sec) mysql show columns from clips ; +-+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-+---+ | ClipID | int(11) | | PRI | 0 | | | Created | datetime | | | -00-00 00:00:00 | | | Modified| timestamp(14) | YES | | NULL| | | Server | int(11) | | | 0 | | | Deleted | datetime | YES | | NULL| | | Frames | int(11) | | | 0 | | | Title | tinytext | YES | MUL | NULL| | | Number | smallint(6) | YES | MUL | NULL| | | Category| tinytext | YES | MUL | NULL| | | Owner | tinytext | YES | MUL | NULL| | | JobID | int(11) | YES | MUL | NULL| | | Tape| tinytext | YES | MUL | NULL| | | Destination | int(11) | YES | | NULL| | | Expiry | datetime | YES | MUL | NULL| | | Description | tinytext | YES | | NULL| | | Register| int(11) | | | 0 | | | RegisterMOD | int(11) | | | 0 | | +-+---+--+-+-+---+ 17 rows in set (0.00 sec) mysql select clipId, owner from clips ; ++---+ | clipId | owner | ++---+ | 2 | NULL | ++---+ 1 row in set (0.00 sec) mysql update clips set owner = him where clipid = 2 ; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql select clipId, owner from clips ; ++---+ | clipId | owner | ++---+ | 2 | NULL | ++---+ 1 row in set (0.00 sec) mysql -- After doing this, the table appears to be crashed: C:\mysql\data\alecmyisamchk clips Checking MyISAM file: clips Data records: 1 Deleted blocks: 0 myisamchk: warning: Table is marked as crashed - 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 data record references index: 3 - check data record references index: 4 - check data record references index: 5 - check data record references index: 6 - check data record references index: 7 - check data record references index: 8 - check record links MyISAM-table 'clips' is usable but should be fixed C:\mysql\data\alec -- This e-mail is intended for the named addressees only. Its contents may be privileged or confidential and should be treated as such. If you are not an intended recipient please notify the sender immediately; do not copy, distribute, or take any action based on this e-mail; and then delete it. In the pursuit of its legitimate business activities and its conformance with relevant legislation, Quantel Ltd. may access any e-mail (including attachments) it originates and receives, for potential scrutiny. Check out Quantel's new website, packed full of information, at : http://www.quantel.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: Re: in_array function?
Steve Werby [EMAIL PROTECTED] schrieb am 28.11.01: Steve Osborne [EMAIL PROTECTED] wrote: Simple question for one of you I am sure. I'm new to mysql (and php) and I am hoping someone can explain exactly what the 'in_array' function does. I have to assume this is a PHP question since it has nothing to do with MySQL. Probably would be more suitable for the php-general list at php.net, but... 1. It returns true if a value is found in the supplied array, false otherwise. 2. See the PHP manual entry for in_array() for details and examples. http://us.php.net/manual/en/function.in-array.php Hi! Is there a similiar function for MySql which could be used in a WHERE-clause in a query like WHERE field in_array $thisstringarray. Thank you Dieter Hansen [EMAIL PROTECTED] __ E*TRADE - neu in Deutschland. Jetzt Depot eröffnen + Prämie erhalten http://etrade.web.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB inserts slow?
Hi there, Was using BDB tables for some full text indexing schema I've got. Indexing a document involves inserting a whole lot of rows in one table, having done some selects and possibly inserts on another table. With BDB, this was averaging 1.5 seconds a document. Thought I'd try InnoDB since the selects are proving a bit too slow with BDB. Howver, with InnoDB this has dropped to almost 30 seconds per document. I'm guessing something is very badly wrong here for this degredation in performance. Anyone got any ideas? If you need mroe info, just ask :-) cheers, Chris PS: If anyone has any good, scalable schemas for full text indexing with phrase matching, I'm all ears :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
date calculation
Dear Sirs: Please I am facing the follow problem: I need to calculate the difference in seconds for two registers type datetime, My question is if exists some function or trick on mysql for perform it? I need this for calculate some information about time for a billing system so I need precision of seconds. Thank you for your replies Ernesto Freyre Get your free email with GroupWeb Worldmailer at http://www.worldmailer.com. Send and receive e-mail from any computer with a web browser. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: date calculation
On 29 Nov 2001, [EMAIL PROTECTED] wrote: I need to calculate the difference in seconds for two registers type datetime, My question is if exists some function or trick on mysql for perform it? I need this for calculate some information about time for a billing system so I need precision of seconds. If you are developing on a *nix system and are able to do this at all, I find that the easiest way is to store a unixtime integer and to do the conversion to/from real dates in the application. my 2 cents, Sincerely, Jan -- Mr. Jan-Aage Bruvoll IT Project Manager 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich Zurich office: +41 1 307 4293, fax: +41 1 307 4281 Office/fax: +44 2072408283 Mobile: +44 7740291600 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Possible bug - further refinement
I have pared down my bug scenario to a single script, at the end of which I have failed to update my table, and have reports that the MYD file cannot be opened. Here it is: #This script file for mysql shows a possible bug. #The update statement near the bottom of the file (a) appears not to #work (as shown by the fact that the two selects return the same result) #(b) leaves the table clips in a state which myisamchk describes as #crashed, and (c) after a flush leaves clips.MYD unreadable #Drop and re-create the test table DROP TABLE IF EXISTS Clips ; CREATE TABLE Clips ( ClipID INTEGER NOT NULL, Owner TINYTEXT DEFAULT NULL, PRIMARY KEY (ClipID), FULLTEXT (Owner) ) ; #Create a single row INSERT INTO clips SET clipID = 2 ; #Display it SELECT ClipID, Owner FROM clips ; #Owner should be NULL #Update it #This is the line which causes the damage UPDATE Clips SET Owner = me WHERE ClipID = 2 ; #Display it agaim SELECT ClipID, Owner FROM clips ; #Owner should be me but is NULL #This works at this point SHOW COLUMNS FROM Clips ; FLUSH TABLE Clips ; #So myisamchk sees a clean file #This fails after the flush - errno 145 SHOW COLUMNS FROM Clips ; Alec Cawley -- This e-mail is intended for the named addressees only. Its contents may be privileged or confidential and should be treated as such. If you are not an intended recipient please notify the sender immediately; do not copy, distribute, or take any action based on this e-mail; and then delete it. In the pursuit of its legitimate business activities and its conformance with relevant legislation, Quantel Ltd. may access any e-mail (including attachments) it originates and receives, for potential scrutiny. Check out Quantel's new website, packed full of information, at : http://www.quantel.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
Another Lack of InnoDB ...... comparing to MyISAM
After having experience with InnoDB and MyISAM.. There's lack in MySQL engine with InnoDB comparing to MySQL with MyISAM the problem exists when you do wrong with my.cnf configuration file for example do wrong in max_connections, table_cache Using MyISAM although with configuration key_buffer_size + (record_buffer + sort_buffer)*max_connections is greater than existing physical memory, MySQL server never crash BUT using InnoDB when you do key_buffer_size + (record_buffer + sort_buffer)*max_connections greater than memory could use by MySQL, it will crash in very heavy load for example here. RAM 256 Mbyte, Swap 512 Mbyte with the same configuration using MyISAM, never crash, but with InnoDB crashed 011127 21:09:51 InnoDB: Started /usr/sbin/mysqld-max: ready for connections A mysqld process already exists at Wed Nov 28 13:45:03 EST 2001 InnoDB: Assertion failure in thread 2096211 in file trx0trx.c line 178 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=33550336 record_buffer=131072 sort_buffer=1048568 max_used_connections=281 max_connections=400 threads_connected=159 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 493560 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: InnoDB: Thread 2051 stopped in file os0sync.c line 115 0x8078ee0 0x824829a 0x81b17d1 0x81b2284 0x80ca6e4 0x8091e31 0x808ed2e 0x8073696 0x8078bf2 0x807e197 Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=5577 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 5577 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash Number of processes running now: 0 011128 14:40:34 mysqld restarted InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 114006046 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Question; Backups?
How do I make a Backup of a MYSQL database ,,, It is simple as just copying the files of each table ? or exists a command to make backup ( including TEXT Fields ) ? Thanks -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:51 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Proposal for two (or more) new time and date functions Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Wed, Nov 28, 2001 at 01:30:42PM -0800, [EMAIL PROTECTED] wrote: I think while you've got the hood up, a better method of doing the difference between two dates should be derived. Unless I'm going about this all wrong, the only way to get the time difference between two values currently is: UNIX_TIMESTAMP(end_datetime) - UNIX_TIMESTAMP(start_datetime) Wouldn't something like SECONDS_DIFF(start,end) make more sense? Or perhaps TIME_DIFF(start,end)? Jeremy It's not the only way, but none of them are as simple as a Jeremy SELECT date1 - date2 The problem with implementing the above simple expression is that you can easily run into problems because of the automatic convert of strings to numbers. For example: What should we do if one of the strings is a date and the other is a number or a string ? If we would do the above, then we would also be able to handle: SELECT 2001-01-01 - date from table_name; SELECT 2001-01-01 - 2000-01-01; One simple solution is to to only do this if both columns are of type DATE. You can always 'cast' a column to date with: SELECT DATE 2001-01-01 - DATE 2000-01-01; How would this sound? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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; Backups?
mysqldump -uusername -ppassword -hhostname dbname dbname.sql That will dump the database 'dbname' into the file 'dbname.sql' Tyler Longren - Original Message - From: ROGGER ALEXIS VASQUEZ MARTINEZ [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 9:40 AM Subject: NewBie Question; Backups? How do I make a Backup of a MYSQL database ,,, It is simple as just copying the files of each table ? or exists a command to make backup ( including TEXT Fields ) ? Thanks -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:51 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Proposal for two (or more) new time and date functions Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Wed, Nov 28, 2001 at 01:30:42PM -0800, [EMAIL PROTECTED] wrote: I think while you've got the hood up, a better method of doing the difference between two dates should be derived. Unless I'm going about this all wrong, the only way to get the time difference between two values currently is: UNIX_TIMESTAMP(end_datetime) - UNIX_TIMESTAMP(start_datetime) Wouldn't something like SECONDS_DIFF(start,end) make more sense? Or perhaps TIME_DIFF(start,end)? Jeremy It's not the only way, but none of them are as simple as a Jeremy SELECT date1 - date2 The problem with implementing the above simple expression is that you can easily run into problems because of the automatic convert of strings to numbers. For example: What should we do if one of the strings is a date and the other is a number or a string ? If we would do the above, then we would also be able to handle: SELECT 2001-01-01 - date from table_name; SELECT 2001-01-01 - 2000-01-01; One simple solution is to to only do this if both columns are of type DATE. You can always 'cast' a column to date with: SELECT DATE 2001-01-01 - DATE 2000-01-01; How would this sound? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQL, Red Hat Linux and php
Brian P. Austin wrote: The RPMS that are available from the MySQL WebSite are OK to use on 6.2. I personnaly prefer to use the source or .src RPMS. But the RPMS work fine on my 6.2 box. [EMAIL PROTECTED] wrote: Hello, Which version of MySQL ( RPM packages ) is good for work with php 4.0.6 and Linux Red Hat 6.2 ? Thank for your help ! Edward. Hello, So, can you tell me which version of MySQL is good for work with Red Hat Linux 6.2 ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RESTORE ??? RE: NewBie Question; Backups?
Thanks and How DO I RESTORE IT ??? -Original Message- From: Tyler Longren [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:43 AM To: ROGGER ALEXIS VASQUEZ MARTINEZ; [EMAIL PROTECTED] Subject: Re: NewBie Question; Backups? mysqldump -uusername -ppassword -hhostname dbname dbname.sql That will dump the database 'dbname' into the file 'dbname.sql' Tyler Longren - Original Message - From: ROGGER ALEXIS VASQUEZ MARTINEZ [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 9:40 AM Subject: NewBie Question; Backups? How do I make a Backup of a MYSQL database ,,, It is simple as just copying the files of each table ? or exists a command to make backup ( including TEXT Fields ) ? Thanks -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:51 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Proposal for two (or more) new time and date functions Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Wed, Nov 28, 2001 at 01:30:42PM -0800, [EMAIL PROTECTED] wrote: I think while you've got the hood up, a better method of doing the difference between two dates should be derived. Unless I'm going about this all wrong, the only way to get the time difference between two values currently is: UNIX_TIMESTAMP(end_datetime) - UNIX_TIMESTAMP(start_datetime) Wouldn't something like SECONDS_DIFF(start,end) make more sense? Or perhaps TIME_DIFF(start,end)? Jeremy It's not the only way, but none of them are as simple as a Jeremy SELECT date1 - date2 The problem with implementing the above simple expression is that you can easily run into problems because of the automatic convert of strings to numbers. For example: What should we do if one of the strings is a date and the other is a number or a string ? If we would do the above, then we would also be able to handle: SELECT 2001-01-01 - date from table_name; SELECT 2001-01-01 - 2000-01-01; One simple solution is to to only do this if both columns are of type DATE. You can always 'cast' a column to date with: SELECT DATE 2001-01-01 - DATE 2000-01-01; How would this sound? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: NewBie Question; Backups?
- Original Message - From: ROGGER ALEXIS VASQUEZ MARTINEZ [EMAIL PROTECTED] How do I make a Backup of a MYSQL database ,,, At 9:42 AM -0600 11/29/01, Tyler Longren wrote: mysqldump -uusername -ppassword -hhostname dbname dbname.sql That will dump the database 'dbname' into the file 'dbname.sql' If using at least version 3.23.25, then you can also use a BACKUP TABLE statement. See Chapter.Section 7.13 BACKUP TABLE Syntax (is pp 244 on my copy) for more details. The question I asked before is which is better? BACKUP TABLE allows for an easier restore perhaps? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: RESTORE ??? RE: NewBie Question; Backups?
At 9:51 AM -0600 11/29/01, ROGGER ALEXIS VASQUEZ MARTINEZ wrote: Thanks and How DO I RESTORE IT ??? IF using at least version 3.23.25, then you can use RESTORE TABLE (described just after BACKUP TABLE). -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: NewBie Question; Backups?
Yes I've seen most of MySQL USERS use BACKUP tables instead of mysqldump ... I don't know if it's for the fact the is easieste to restore? -Original Message- From: Michael Collins [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:59 AM To: MySQL List Cc: ROGGER ALEXIS VASQUEZ MARTINEZ Subject: Re: NewBie Question; Backups? - Original Message - From: ROGGER ALEXIS VASQUEZ MARTINEZ [EMAIL PROTECTED] How do I make a Backup of a MYSQL database ,,, At 9:42 AM -0600 11/29/01, Tyler Longren wrote: mysqldump -uusername -ppassword -hhostname dbname dbname.sql That will dump the database 'dbname' into the file 'dbname.sql' If using at least version 3.23.25, then you can also use a BACKUP TABLE statement. See Chapter.Section 7.13 BACKUP TABLE Syntax (is pp 244 on my copy) for more details. The question I asked before is which is better? BACKUP TABLE allows for an easier restore perhaps? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: RESTORE ??? RE: NewBie Question; Backups?
mysql -u username -p -h newdbname dbname.sql -Original Message- From: ROGGER ALEXIS VASQUEZ MARTINEZ [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 3:51 PM To: Tyler Longren; ROGGER ALEXIS VASQUEZ MARTINEZ; [EMAIL PROTECTED] Subject: RESTORE ??? RE: NewBie Question; Backups? Thanks and How DO I RESTORE IT ??? -Original Message- From: Tyler Longren [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:43 AM To: ROGGER ALEXIS VASQUEZ MARTINEZ; [EMAIL PROTECTED] Subject: Re: NewBie Question; Backups? mysqldump -uusername -ppassword -hhostname dbname dbname.sql That will dump the database 'dbname' into the file 'dbname.sql' Tyler Longren - Original Message - From: ROGGER ALEXIS VASQUEZ MARTINEZ [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 9:40 AM Subject: NewBie Question; Backups? How do I make a Backup of a MYSQL database ,,, It is simple as just copying the files of each table ? or exists a command to make backup ( including TEXT Fields ) ? Thanks -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:51 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Proposal for two (or more) new time and date functions Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Wed, Nov 28, 2001 at 01:30:42PM -0800, [EMAIL PROTECTED] wrote: I think while you've got the hood up, a better method of doing the difference between two dates should be derived. Unless I'm going about this all wrong, the only way to get the time difference between two values currently is: UNIX_TIMESTAMP(end_datetime) - UNIX_TIMESTAMP(start_datetime) Wouldn't something like SECONDS_DIFF(start,end) make more sense? Or perhaps TIME_DIFF(start,end)? Jeremy It's not the only way, but none of them are as simple as a Jeremy SELECT date1 - date2 The problem with implementing the above simple expression is that you can easily run into problems because of the automatic convert of strings to numbers. For example: What should we do if one of the strings is a date and the other is a number or a string ? If we would do the above, then we would also be able to handle: SELECT 2001-01-01 - date from table_name; SELECT 2001-01-01 - 2000-01-01; One simple solution is to to only do this if both columns are of type DATE. You can always 'cast' a column to date with: SELECT DATE 2001-01-01 - DATE 2000-01-01; How would this sound? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
How To Install Under MacOS X?
I'm stuck trying to figure out how to install this thing. What I've tried: * The download doesn't contain a standard MacOS .pkg so I can't do a GUI install. * The command-line instructions require the groupadd command in step #1, but MacOS doesn't support this due to the existence of the NetInfo system. * Turning to the manual.html included in the MacOS X build, only Linux and Windows are mentioned. Can anyone who has successfully installed MySQL under MacOS X tell me how they did so?? Thanks, -Kurt -- I haven't failed, I've found 10,000 ways that don't work. -- Benjamin Franklin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 id or record just inserted
Hello: Can anyone tell me how to get the id of a row just inserted? In MS-SQL I recall something about @@Identity. Does MySQL have something similar? I know I can always just query Max(ID), but that's not always the safest bet. reply to [EMAIL PROTECTED] as I have not subscribed to the mailing list...yet. Thank you, Robert Matt Graham, Esq. Product Manager THE AGOS GROUP, LLC [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mySql vs Interbase
Hello, I saw somewhere that this comparaison existed but I can't remember where. Does it talk to anyone ? TIA, Fabien (mysql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: please help me
Although this is not a php list... mysql_connect() returns TRUE on success and FALSE on failuer, so testing $link like if($link) means it did connect. your script should read: $link=mysql_connect(localhost) // the !(bang as it is called) means NOT // so !TRUE == FALSE if(!$link) { printf(Could not connect to mysql server: %s,mysql_error()); } else { //connection is good } or, better yet: if(!$link=mysql_connect(localhost)) { printf(Could not connect:\n%s : %s\n,mysql_errno(),mysql_error()); } else { //connection is good } hope it helps. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: anandakkumar araskumar [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 6:37 AM To: [EMAIL PROTECTED] Subject: please help me Hi all Iam new to php and iam learning that from scratch.I came across a problem in connecting mysql from php script.I run php in windows2000 under IIS configured to personal web server.I have installed mysql with server and client and both are running in the same machine(ofcourse, i can you use the ipaddress of localhost).I didn't set any username or password with mysql. This is my php script: $link=mysql_connect(localhost); if($link) die(Couldn't connect to mysql.mysql_error() ); print Successfully connected to server; when i execute this program iam getting the following message: Couldn't connect to mysql Anyone please help me as this is very urgent. thanks in advance Regards shahjahan __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Re: in_array function?
Dieter Hansen [EMAIL PROTECTED] wrote: Steve Werby [EMAIL PROTECTED] schrieb am 28.11.01: Steve Osborne [EMAIL PROTECTED] wrote: Simple question for one of you I am sure. I'm new to mysql (and php) and I am hoping someone can explain exactly what the 'in_array' function does. I have to assume this is a PHP question since it has nothing to do with MySQL. Probably would be more suitable for the php-general list at php.net, but... 1. It returns true if a value is found in the supplied array, false otherwise. 2. See the PHP manual entry for in_array() for details and examples. http://us.php.net/manual/en/function.in-array.php Hi! Is there a similiar function for MySql which could be used in a WHERE-clause in a query like WHERE field in_array $thisstringarray. SELECT * FROM table_name WHERE my_field IN ('dog','cat','mouse') will return all records where the value of my_field is in the set in the list above. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: socket filename is truncated in error message
Brian Bartholomew writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: This is simply because we have to limit our errors buffers to some reasonable values. Are there so many of these filename buffers that they can't be sized to MAXPATHLEN? Yes, and we try to use as little stack as possible. Pushing everything to heap, on the other hand, would cause some speed penalties. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: getting id or record just inserted
Take a look at the LAST_INSERT_ID() function. -bryanw HalfPriceNames Domain Registry http://www.halfpricenames.com/ -Original Message- From: Matt Graham [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:12 AM To: '[EMAIL PROTECTED]' Subject: getting id or record just inserted Hello: Can anyone tell me how to get the id of a row just inserted? In MS-SQL I recall something about @@Identity. Does MySQL have something similar? I know I can always just query Max(ID), but that's not always the safest bet. reply to [EMAIL PROTECTED] as I have not subscribed to the mailing list...yet. Thank you, Robert Matt Graham, Esq. Product Manager THE AGOS GROUP, LLC [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: getting id or record just inserted
Matt Graham [EMAIL PROTECTED] asked Can anyone tell me how to get the id of a row just inserted? In MS-SQL I recall something about @@Identity. Does MySQL have something similar? I know I can always just query Max(ID), but that's not always the safest bet. reply to [EMAIL PROTECTED] as I have not subscribed to the mailing list...yet. Check out: last_insert_id() --- Fulko Hew, Voice: 905-681-5570 Senior Engineering Designer, Fax:905-681-5556 SITA (Burlington)Email: [EMAIL PROTECTED] 777 Walkers Line, Burlington, Ontario, Canada, L7N 2G1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: median function?
Christopher R. Jones writes: Correct The mean (average) depends on the distribution. If the distribution is either positively or negatively skewed, then the median will not equal the mean. The median of an ordered list is the middle value if the number of elements is odd. If the number of elements is even, then the median is the average of the two middle values. Yes, this is correct, but it is still sampling median. On the other hand, some non-parametric test might rule out some of the values, so we are again in the beginning. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: getting id or record just inserted
last_insert_id() should work D Alast_insert_id() MG: recall something about @@Identity. Does MySQL have something similar? I MG: know I can always just query Max(ID), but that's not always the safest bet. MG: MG: reply to [EMAIL PROTECTED] as I have not subscribed to the mailing MG: list...yet. MG: MG: Thank you, MG: MG: MG: Robert Matt Graham, Esq. MG: Product Manager MG: THE AGOS GROUP, LLC MG: [EMAIL PROTECTED] MG: MG: MG: - MG: Before posting, please check: MG:http://www.mysql.com/manual.php (the manual) MG:http://lists.mysql.com/ (the list archive) MG: MG: To request this thread, e-mail [EMAIL PROTECTED] MG: To unsubscribe, e-mail [EMAIL PROTECTED] MG: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php MG: -- sherzodR [EMAIL PROTECTED] use CGI::Session; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Never mind: How To Install Under MacOS X?
Sorry--found the info: http://www.latencyzero.com/macosx/mysql.html http://www.entropy.ch/software/macosx/mysql/ -Kurt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
You could treate those delimited columsn just like SET() columns and pass the following query: SELECT * FROM cats WHERE category LIKE %christmas%; Graham Nichols wrote: GN: Hi, GN: GN: I have a table which contains a column 'category' GN: GN: GN: 'category' can be made up as records such as: GN: GN: christmas|birthday|easter GN: easter|thanksgiving GN: birthday|christmas|thanksgiving|easter GN: GN: etc . GN: GN: As you can see, items are delimited with a '|' in the fields. If I wish to GN: select all records which contain 'christmas', what is the correct sql syntax GN: please? GN: (This should return records 1 and 3 from the example shown above) GN: GN: I've tried several approaches, but have failed so far. GN: GN: Thanks for any pointers. GN: GN: kind regards, Graham Nichols GN: GN: GN: GN: - GN: Before posting, please check: GN:http://www.mysql.com/manual.php (the manual) GN:http://lists.mysql.com/ (the list archive) GN: GN: To request this thread, e-mail [EMAIL PROTECTED] GN: To unsubscribe, e-mail [EMAIL PROTECTED] GN: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php GN: -- sherzodR [EMAIL PROTECTED] use CGI::Session; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: RESTORE ??? RE: NewBie Question; Backups?
You can restore it by just doing: $ mysql dbname dbnams.sql ROGGER ALEXIS VASQUEZ MARTINEZ wrote: :Thanks and :How DO I RESTORE IT ??? : : :mysqldump -uusername -ppassword -hhostname dbname dbname.sql : :That will dump the database 'dbname' into the file 'dbname.sql' : :Tyler Longren : -- sherzodR [EMAIL PROTECTED] use CGI::Session; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PHP / MySQL username and password creation
Hi everyone, Is there an online tutorial out there that can help me to create a PHP page that will accept a users new username and password which is then dumped with MySQL ? Your help would be most appreciated. Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 vs Interbase
On Thursday 29 Nov 2001 16:18, Fabien R. wrote: I saw somewhere that this comparaison existed but I can't remember where. Does it talk to anyone ? I haven't seen one between InterBase and MySQL, but I do remember seeing one between PostgreSQL and InterBase. Allegedly, they thought that InterBase was faster in the single-user scenario. However, in my personal comparative test as of a few weeks ago, I have seen MySQL to be about twice as fast as PostgreSQL, and about 5-10 times as fast as InterBase. Unless you have a particular need for InterBase, I'd stay away from it. It doesn't particularly exceed the features of MySQL or PostgreSQL, and it is MUCH slower... It could be a performance issue due to Perl DBI, but I doubt it - just about all the CPU time was consumed by the database back ends. Additionally, InterBase, according even to their own documentation, doesn't scale very well with SMP. Since it didn't measure up even in the single-user scenario, I never got as far as testing it in the SMP type environment. Regards. Gordan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on new connection socket: Invalid argument
-Original Message- From: Cindy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 5:49 PM To: MySQL List Subject: Re: Error on new connection socket: Invalid argument Jeff Hinds writes: I have an application that is developed in perl using dbi and mysql that has been working well for some time now. However, I have received emails and phone calls asking if the server is down. I look at the service and the system is up however, the mysql error log reports the following message: Error on new connection socket: Invalid argument Once I stop and restart the mysqld process all is well again. But I need to prevent the error from happening over and over. I could not find any mention of the message above in the documentation. Has anyone run into this problem and found out what is causing it, and how to correct it? Sometimes the file /tmp/mysql.sock is removed by a cron job clearing out /tmp. In which case you may want to redefine socket=/usr/local/mysql/mysql.sock or whatever to avoid that problem. Okay . . . This has been done. The mysql.sock file is in a dedicated area for MySQL on our system. We have been looking for problems with applications that may be terminating before close any connection it may have open. A short term fix of increasing the Max Connections has been considered, but we want to make this a final option. What else could be causing this problem? Thanks in advance. Jeff Hinds - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
On Thursday 29 November 2001 23:50, Graham Nichols wrote: Hi, I have a table which contains a column 'category' 'category' can be made up as records such as: christmas|birthday|easter easter|thanksgiving birthday|christmas|thanksgiving|easter etc . As you can see, items are delimited with a '|' in the fields. If I wish to select all records which contain 'christmas', what is the correct sql syntax please? (This should return records 1 and 3 from the example shown above) SELECT * FROM table WHERE category LIKE '%christmas%' should do the trick. hth -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Horngren's Observation: Among economists, the real world is often a special case. */ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Install Under MacOS X?
I am going to take a stab at this... Since MacOS X is actually an open sourced kernel, I would assume you could use the Linux or Unix version to install it. I have not worked with MacOS X, but if I remember correctly it had a command prompt. Let me know if it works Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Kurt Tappe [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:14 AM To: [EMAIL PROTECTED] Subject: How To Install Under MacOS X? I'm stuck trying to figure out how to install this thing. What I've tried: * The download doesn't contain a standard MacOS .pkg so I can't do a GUI install. * The command-line instructions require the groupadd command in step #1, but MacOS doesn't support this due to the existence of the NetInfo system. * Turning to the manual.html included in the MacOS X build, only Linux and Windows are mentioned. Can anyone who has successfully installed MySQL under MacOS X tell me how they did so?? Thanks, -Kurt -- I haven't failed, I've found 10,000 ways that don't work. -- Benjamin Franklin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
ASP pages and ADO recordsets
Hi, I am trying to modify some ASP pages that (already) work with an Access database so that they will work with mySQL database instead. (an example is below) I have been able to read data from mysql and the edit page SEEMS to work - no errors from ASP - however the database is not updated. My first thought is that the ADO recordset is actually NOT updating because the parameters are not right. the 1, and the 3 in CmdUpdateRecord.Open MYSQL, DataConn, 1, 3 is not correct. My second thought is that mysql is not going to allow ASP to update the record via ADO with a select statement. The sql statement will have to be update etc etc rather than Select etc etc Obviously I am hoping the first thought is right - less editing ;-) SO Does anyone out there have experience (and an answer) to how to properly use ASP, ADO vbscript code with mySQL? thanks Harry PS PLEASE EMAIL ME directly along with a post to the group. The digest version comes late in the day and is hard to search thru. (You guys POST ALOT of emails!) There is the example editing page in its original form. ** % ID = 7 % % NAME = Joe Smoe % % MESSAGE = This is another test % % ' declaring variables ' not neccesary but a good habit Dim DataConn Dim CmdUpdateRecord Dim MYSQL Set DataConn = Server.CreateObject(ADODB.Connection) Set CmdUpdateRecord = Server.CreateObject(ADODB.Recordset) ' The line below shows how to use a system DSN instead of a DNS-LESS connection ' DataConn.Open DSN=System_DSN_Name DataConn.Open DBQ= Server.Mappath(../_database/database.mdb) ;Driver={Microsoft Access Driver (*.mdb)}; MYSQL = SELECT some_table.* FROM some_table WHERE (ID = ID ) CmdUpdateRecord.Open MYSQL, DataConn, 1, 3 CmdUpdateRecord.Fields(NAME) = NAME CmdUpdateRecord.Fields(MESSAGE) = MESSAGE CmdUpdateRecord.Update ' closing objects and setting them to nothing ' not neccesary but a good habit CmdUpdateRecord.Close Set CmdUpdateRecord = Nothing DataConn.Close Set DataConn = Nothing % - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PHP / MySQL username and password creation
What do you mean accept new users? Via adding new people to the MySQL user list or to a web application? Please specify.. Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Anthony Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:41 AM To: MYSQL help Subject: PHP / MySQL username and password creation Hi everyone, Is there an online tutorial out there that can help me to create a PHP page that will accept a users new username and password which is then dumped with MySQL ? Your help would be most appreciated. Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PHP / MySQL username and password creation
sorry Todd, i meant into my own users table that i have created. - Original Message - From: Todd Williamsen [EMAIL PROTECTED] To: 'Anthony Evans' [EMAIL PROTECTED]; 'MYSQL help' [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 5:12 PM Subject: RE: PHP / MySQL username and password creation What do you mean accept new users? Via adding new people to the MySQL user list or to a web application? Please specify.. Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Anthony Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:41 AM To: MYSQL help Subject: PHP / MySQL username and password creation Hi everyone, Is there an online tutorial out there that can help me to create a PHP page that will accept a users new username and password which is then dumped with MySQL ? Your help would be most appreciated. Anthony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
R: mySql vs Interbase
Why are you sending email to me. -Messaggio originale- Da: Gordan Bobic [mailto:[EMAIL PROTECTED]] Inviato: giovedì 29 novembre 2001 17.45 A: Fabien R.; [EMAIL PROTECTED] Oggetto: Re: mySql vs Interbase On Thursday 29 Nov 2001 16:18, Fabien R. wrote: I saw somewhere that this comparaison existed but I can't remember where. Does it talk to anyone ? I haven't seen one between InterBase and MySQL, but I do remember seeing one between PostgreSQL and InterBase. Allegedly, they thought that InterBase was faster in the single-user scenario. However, in my personal comparative test as of a few weeks ago, I have seen MySQL to be about twice as fast as PostgreSQL, and about 5-10 times as fast as InterBase. Unless you have a particular need for InterBase, I'd stay away from it. It doesn't particularly exceed the features of MySQL or PostgreSQL, and it is MUCH slower... It could be a performance issue due to Perl DBI, but I doubt it - just about all the CPU time was consumed by the database back ends. Additionally, InterBase, according even to their own documentation, doesn't scale very well with SMP. Since it didn't measure up even in the single-user scenario, I never got as far as testing it in the SMP type environment. Regards. Gordan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQL 3.23 Manual - PDF
Well there is a 4.x manual, and I know from a few months ago that there was a 3.23 manual on the site which I foolishly decided I didn't need. Do the developers of MySQL just delete all copies of manuals for previous version when they move to new software? I mean, what is a 3 or 4mb file nowadays? A. Clausen [EMAIL PROTECTED] - Original Message - From: Thomas Spahni [EMAIL PROTECTED] To: A. Clausen [EMAIL PROTECTED] Cc: MySQL Mailing List [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 03:24 Subject: Re: MySQL 3.23 Manual - PDF On Wed, 28 Nov 2001, A. Clausen wrote: That is the MySQL 4.x manual, I'm looking for the 3.23.x PDF-formatted manual. The HTML and text versions supplied with the 3.23 distributions are way too unwieldly, and I'm not going to upgrade my mission critical app to what is apparently alpha software, just so I can have an up-to-date manual. The very fine manual is not distributed in PDF format, because it's much too big in this format. However, you may get your copy without upgrading your software. Just get the latest mysql-3.23.45.tar.gz, unzip, untar, go to the mysql-3.23.45 directory and type: me@host:~/mysql-3.23.45 ./configure to create the Makefiles. Then go to the Docs/ directory and me@host:~/mysql-3.23.45/Docs make manual.pdf ... and have a cup of coffee. You need the GNU TeX-info and pdftex (available from the teTeX package). In case all else fails I put a copy of the manual in PDF format on: http://www.polyreg.ch/ssl/misc/mysqlmanual/ To use the manual on the screen without printing I recommend the pinfo viewer (ver 6.3) and mysql.info This provides for the ease of lynx and the speed of light. Regards, Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LIMIT by column return
I'm trying to write a query that will limit the results but not by the total amount returned like a normal LIMIT. It's an invoice database and I would like to return the last to invoices for a certain job. So if there are 100 jobs with several invoice dates I would like to return a web page displaying a table of invoice dates ordered by job name and LIMIT the invoice dates to the last two invoice dates for each job. Here's my query so far; SELECT site_service.id, site_service.service_date, site_service.invoice_date, site.site_id, site.name, site.state, site.status FROM site_service, site WHERE site_service.site_id = site.id AND site.company = 'Nextel' If I add LIMIT 2, I only get two invoices. I'm trying to get the last to invoices for each site. Is this possible or is there another direction I should go? I checked out the MySQL site without any luck. Thanks, Tom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What is errno: 13
The files aren't owned by mysql. Venu Allavatam wrote: Hello All: I am working on a particular database, which I created some days ago in mysql ver. 3.23.36. I am quite sure that I have not made any changes to the system (Dell WS with Red Hat Linux 7.1) either. What I see is this... ### [Venu@localhost Venu]$ db Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'ecg_datafile' Didn't find any fields in table 'event_info' Didn't find any fields in table 'event_lookup' Didn't find any fields in table 'lead_lookup' Didn't find any fields in table 'properties_info' Didn't find any fields in table 'record_info' Didn't find any fields in table 'subject_info' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql use sadms Database changed mysql mysql mysql select * from ecg_datafile; ERROR 1017: Can't find file: './sadms/ecg_datafile.frm' (errno: 13) mysql quit Bye [Venu@localhost Venu]$ # what is this error? I created all these tables a few days back and now I am unable to view them. Could anyone suggest what is going and what the solution is? Thanks Venu __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - Before posting, please check: http://www.mysql.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-##L=##[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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to log connexion and trying of connexion
Hi all, I'm trying to have logs of mySQL activity, I read that I need the option --log[=file] for mysqld but I can't understand where I must add this argument. (in my.conf ?) Thanks in advance, Nicolas Beaumont - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23 Manual - PDF
start paste message From: Thomas Spahni [EMAIL PROTECTED] 6:24 AM Subject: Re: MySQL 3.23 Manual - PDF To: A. Clausen [EMAIL PROTECTED] CC: MySQL Mailing List [EMAIL PROTECTED] On Wed, 28 Nov 2001, A. Clausen wrote: [deleted] ... and have a cup of coffee. You need the GNU TeX-info and pdftex (available from the teTeX package). In case all else fails I put a copy of the manual in PDF format on: http://www.polyreg.ch/ssl/misc/mysqlmanual/ To use the manual on the screen without printing I recommend the pinfo viewer (ver 6.3) and mysql.info This provides for the ease of lynx and the speed of light. Regards, Thomas end paste message it's all there! Etienne A. Clausen wrote: Well there is a 4.x manual, and I know from a few months ago that there was a 3.23 manual on the site which I foolishly decided I didn't need. Do the developers of MySQL just delete all copies of manuals for previous version when they move to new software? I mean, what is a 3 or 4mb file nowadays? A. Clausen [EMAIL PROTECTED] - Original Message - From: Thomas Spahni [EMAIL PROTECTED] To: A. Clausen [EMAIL PROTECTED] Cc: MySQL Mailing List [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 03:24 Subject: Re: MySQL 3.23 Manual - PDF On Wed, 28 Nov 2001, A. Clausen wrote: That is the MySQL 4.x manual, I'm looking for the 3.23.x PDF-formatted manual. The HTML and text versions supplied with the 3.23 distributions are way too unwieldly, and I'm not going to upgrade my mission critical app to what is apparently alpha software, just so I can have an up-to-date manual. The very fine manual is not distributed in PDF format, because it's much too big in this format. However, you may get your copy without upgrading your software. Just get the latest mysql-3.23.45.tar.gz, unzip, untar, go to the mysql-3.23.45 directory and type: me@host:~/mysql-3.23.45 ./configure to create the Makefiles. Then go to the Docs/ directory and me@host:~/mysql-3.23.45/Docs make manual.pdf ... and have a cup of coffee. You need the GNU TeX-info and pdftex (available from the teTeX package). In case all else fails I put a copy of the manual in PDF format on: http://www.polyreg.ch/ssl/misc/mysqlmanual/ To use the manual on the screen without printing I recommend the pinfo viewer (ver 6.3) and mysql.info This provides for the ease of lynx and the speed of light. Regards, Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: source command problem
sherzodR wrote: Well, Paul, i think he means using source in an .sql script. Yes you can, Shankar. I used it several times for several reasons :) And u can envoke your sql script the same as you use your other scripts. [EXAMPLE] [...] -- in source.sql file: source query.sql # or \. query.sql [/EXAMPLE] Thanks - that last one (using \.) worked. Using source doesn't. In the above example, if you had the line source query.sql in source.sql, then you can't do % mysql mysql source source.sql ERROR 1064: You have an error in your SQL syntax near 'source query.sql' on line 1. But using \. query.sql works. So that lets me get on with the scripts.. Thanks again. -- Shankar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: source command problem
At 10:33 AM -0800 11/29/01, Shankar Unni wrote: sherzodR wrote: Well, Paul, i think he means using source in an .sql script. Yes you can, Shankar. I used it several times for several reasons :) And u can envoke your sql script the same as you use your other scripts. [EXAMPLE] [...] -- in source.sql file: source query.sql # or \. query.sql [/EXAMPLE] Thanks - that last one (using \.) worked. Using source doesn't. In the above example, if you had the line source query.sql in source.sql, then you can't do % mysql mysql source source.sql ERROR 1064: You have an error in your SQL syntax near 'source query.sql' on line 1. But using \. query.sql works. So that lets me get on with the scripts.. Thanks again. -- Shankar. Ah. If that's the case, then perhaps you are being bitten by the --no-named-commands option: % mysql --help snip -g, --no-named-commands Named commands are disabled. Use \* form only, or use named commands only in the beginning of a line ending with a semicolon (;) Since version 10.9 the client now starts with this option ENABLED by default! Disable with '-G'. Long format commands still work from the first line. -G, --enable-named-commands Named commands are enabled. Opposite to -g. snip Note that the source line you show above doesn't end with a semicolon. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
conceptual question.
hello all! i have a question regarding the storage of data. The doubt is... Should the data (mostly binary files) be stored in the database as a field or a link(a path) to the data be stored. i have read some of the pros and cons on both the issues and am confused. what is the practice usually and what are you guys doing in this matter? please suggest and in case you have good references to look into i would be eager to read them too. thanks venu __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: conceptual question.
Recommend that you store the link/url in lieu of the actual files. cheers, mikel Venu Allavatam wrote: hello all! i have a question regarding the storage of data. The doubt is... Should the data (mostly binary files) be stored in the database as a field or a link(a path) to the data be stored. i have read some of the pros and cons on both the issues and am confused. what is the practice usually and what are you guys doing in this matter? please suggest and in case you have good references to look into i would be eager to read them too. thanks venu __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LIMIT by column return
Tom, Restating the problem, you want the last two from the set ordered by invoice date. So, add ORDER BY site_service.invoice_date DESC LIMIT 2; Probably just a typo, but I note your statement selects site_service.id and site.site_id but has site_service.site_id = site.id in the WHERE clause. Michael On Thu, 29 Nov 2001, Tom Beidler wrote: I'm trying to write a query that will limit the results but not by the total amount returned like a normal LIMIT. It's an invoice database and I would like to return the last two invoices for a certain job. So if there are 100 jobs with several invoice dates I would like to return a web page displaying a table of invoice dates ordered by job name and LIMIT the invoice dates to the last two invoice dates for each job. Here's my query so far; SELECT site_service.id, site_service.service_date, site_service.invoice_date, site.site_id, site.name, site.state, site.status FROM site_service, site WHERE site_service.site_id = site.id AND site.company = 'Nextel' If I add LIMIT 2, I only get two invoices. I'm trying to get the last to invoices for each site. Is this possible or is there another direction I should go? I checked out the MySQL site without any luck. Thanks, Tom Michael Stassen University Information Technology Services Indiana University Bloomington [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: conceptual question.
I store links instead of the data. I don't know I seem to prefer a light database and the retreival of images/others from the server itself instead of pulling it from the database. There are a lot of debates on this, I'm only telling you what I prefer to use:) Etienne Venu Allavatam wrote: hello all! i have a question regarding the storage of data. The doubt is... Should the data (mostly binary files) be stored in the database as a field or a link(a path) to the data be stored. i have read some of the pros and cons on both the issues and am confused. what is the practice usually and what are you guys doing in this matter? please suggest and in case you have good references to look into i would be eager to read them too. thanks venu __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LIMIT by column return
hum, I think it won't acheive his goal:) Let's say you have this as data: | id |date| whatever | || | 1 | 2001-11-26 | | | 2 | 2001-11-27 | | | 3 | 2001-11-25 | | | 4 | 2001-11-27 | | | 5 | 2001-11-26 | | | 6 | 2001-11-26 | | | 7 | 2001-11-25 | | | 8 | 2001-11-26 | | | 9 | 2001-11-27 | | he wants to have the data for the two last dates. so it would be in that case: | id |date| whatever | || | 2 | 2001-11-27 | | | 4 | 2001-11-27 | | | 9 | 2001-11-27 | | | 1 | 2001-11-26 | | | 5 | 2001-11-26 | | | 6 | 2001-11-26 | | | 8 | 2001-11-26 | | means all invoices from the two last days where there are incvoices. I don't think he want's to use date sub from NOW() sine the two last invoice dates might be variable.. Etienne Michael Stassen wrote: Tom, Restating the problem, you want the last two from the set ordered by invoice date. So, add ORDER BY site_service.invoice_date DESC LIMIT 2; Probably just a typo, but I note your statement selects site_service.id and site.site_id but has site_service.site_id = site.id in the WHERE clause. Michael On Thu, 29 Nov 2001, Tom Beidler wrote: I'm trying to write a query that will limit the results but not by the total amount returned like a normal LIMIT. It's an invoice database and I would like to return the last two invoices for a certain job. So if there are 100 jobs with several invoice dates I would like to return a web page displaying a table of invoice dates ordered by job name and LIMIT the invoice dates to the last two invoice dates for each job. Here's my query so far; SELECT site_service.id, site_service.service_date, site_service.invoice_date, site.site_id, site.name, site.state, site.status FROM site_service, site WHERE site_service.site_id = site.id AND site.company = 'Nextel' If I add LIMIT 2, I only get two invoices. I'm trying to get the last to invoices for each site. Is this possible or is there another direction I should go? I checked out the MySQL site without any luck. Thanks, Tom Michael Stassen University Information Technology Services Indiana University Bloomington [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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: conceptual question.
Amen to that... I would think file storage within a database other than the file system would be a configuration control nightmare. Using links rather than embedding files in a DB field allows the files to be maintained by their owners without affecting the validity of or requiring revision to the linking database. Fred Woolsey -Original Message- From: A. Clausen [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 2:35 PM To: [EMAIL PROTECTED] Subject: Re: conceptual question. I was taught that when it comes to files, use the DBMS designed for files, namely the file system. A. Clausen [EMAIL PROTECTED] - Original Message - From: Etienne Marcotte [EMAIL PROTECTED] To: Venu Allavatam [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 11:14 Subject: Re: conceptual question. I store links instead of the data. I don't know I seem to prefer a light database and the retreival of images/others from the server itself instead of pulling it from the database. There are a lot of debates on this, I'm only telling you what I prefer to use:) Etienne Venu Allavatam wrote: hello all! i have a question regarding the storage of data. The doubt is... Should the data (mostly binary files) be stored in the database as a field or a link(a path) to the data be stored. i have read some of the pros and cons on both the issues and am confused. what is the practice usually and what are you guys doing in this matter? please suggest and in case you have good references to look into i would be eager to read them too. thanks venu __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
MySQL Problems - Still Rebooting
Please please please take the time to look at this problem. I'm running MySQL 3.23.36 on FreeBSD 4.2. The only application that connects and manipulates MySQL is a single PHP application running on PHP 4.0.3. I've eliminated all the errors I can think of and tried to optimize all queries. CPU usage never goes about 10-20% tops. However, MySQL continues to restart randomly and I cannot detect a pattern. And each time it restarts, it appears as though it doesn't close the socket or something. If I run netstat on my machine, I see this near the bottom: Address Type Recv-Q Send-QInode Conn Refs Nextref Addr d56998c0 stream 0 0 d5a12d40000 /tmp/mysql.sock d5888680 stream 0 0 d5695900000 /var/run/ndc d5920f40 stream 0 00000 /tmp/mysql.sock d5699e80 stream 0 00000 /tmp/mysql.sock d5888f80 stream 0 00000 /tmp/mysql.sock d5699880 stream 0 00000 /tmp/mysql.sock d5920e00 stream 0 00000 /tmp/mysql.sock d5920340 stream 0 00000 /tmp/mysql.sock d5699280 stream 0 00000 /tmp/mysql.sock d5888280 stream 0 00000 /tmp/mysql.sock d5920b40 stream 0 00000 /tmp/mysql.sock That list of mysql.sock entries continues to grow slowly until I start getting errors about sockets. I can't JUST shut down MySQL and start it up again - the sockets stay there. I have to reboot the whole server to make the socket entries go away. There are no specific errors in the error log file - only mysql got signal 11 and it says something about checking the backtrace but it doesn't give me the actual backtrace data - just a message saying that I should check it. The binary logs don't hold any clues either. There's no pattern in the last queries before or beginning queries after the mySQL server restarts. They change each time. Help help help help help. - Jonathan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: GUIfront-end in Linux?
On Thursday 29 November 2001 04:02 am, Frank J. Schmuck wrote: I'm moving from Win2k to Linux and was wondering if there was a GIU MySQL front-end in Linux similar to Mascon or mysqlfront for the windoz Oss. Thanks Frank MySQLNavigator is quite nice. Got a decent write-up in Linux Journel. I don't use Linux, rather FreeBSD and use MySQLNavigator on FBSD. I like it. There are many others you could look at. Check the mysql.com site, I believe they reference some. -- Chip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: kaka's query speed is slow
Hi, Upon closer examination of the query, it seems that both ensembl_object_type, and xref_index does not have ensembl_id in the 1st position for the index. So the hints would not work any way. I would still appreciate if someone points out the syntax error I got. Looking at the new schemaCore table at http://www.ensembl.org/Docs/wiki/html/EnsemblDocs/SchemaCore.html ensembl_id is the referred by transcript_stable_id:stable_id, etc. This points to the problem of incompatible format between ensembl_id (number e.g. 7263) and stable_id (string e.g. ENSX000...). Will this be resolved? Thanks Wilfred On Thu, 29 Nov 2001, Wilfred Li, Ph.D. wrote: Hi, Philip, Here is the query as you suggested: SELECT ox.ensembl_id, x.dbprimary_id, x.display_id, db.db_name FROM objectXref ox, Xref x, externalDB db WHERE ox.ensembl_id IN ('7263', '7318', '8991', '17508') AND x.xrefid = ox.xrefid AND db.externalDBId = x.externalDBId; Maybe WHERE ... IN ('7263', '7318', '8991', '17508') This change descreased the time between 20.21 sec to 23.71 sec. But repeating the original query (no single quote) only used 21.63 sec. The differences may be due to server load at execution time. So string or number datatype is not the cause. EXPLAIN SELECT your whole SQL statement here Here is the explain result: +---++---+-+-+++-+ | table | type | possible_keys | key | key_len | ref| rows | Extra | +---++---+-+-+++-+ | ox| index | NULL | ensembl_object_type | 45 | NULL | 133764 | where used; Using index | | x | eq_ref | PRIMARY | PRIMARY | 4 | ox.xrefId | 1 | | | db| eq_ref | PRIMARY | PRIMARY | 4 | x.externalDBId | 1 | | +---++---+-+-+++-+ 3 rows in set (0.17 sec) mysql show index from objectXref; +++-+--+-+---+-+--++-+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +++-+--+-+---+-+--++-+ | objectXref | 0 | ensembl_object_type |1 | ensembl_object_type | A |NULL | NULL | NULL | NULL| | objectXref | 0 | ensembl_object_type |2 | ensembl_id | A |NULL | NULL | NULL | NULL| | objectXref | 0 | ensembl_object_type |3 | xrefId | A |NULL | NULL | NULL | NULL| | objectXref | 1 | xref_index |1 | objectxrefId | A |NULL | NULL | NULL | NULL| | objectXref | 1 | xref_index |2 | xrefId | A |NULL | NULL | NULL | NULL| | objectXref | 1 | xref_index |3 | ensembl_object_type | A |NULL | NULL | NULL | NULL| | objectXref | 1 | xref_index |4 | ensembl_id | A |NULL | NULL | NULL | NULL| +++-+--+-+---+-+--++-+ 7 rows in set (0.18 sec) It seems that mysql is not using the index xref_index, but using ensembl_object_type. I tried to use hint (mysql version 3.23.25 beta) SELECT ox.ensembl_id, x.dbprimary_id, x.display_id, db.db_name FROM Xref x, externalDB db, objectXref ox USING INDEX (xref_index) WHERE ox.ensembl_id IN ('7263', '7318', '8991', '17508') AND x.xrefid = ox.xrefid AND db.externalDBId = x.externalDBId; ERROR 1064: You have an error in your SQL syntax near 'USING INDEX (xref_index) WHERE ox.ensembl_id IN ('7263', '7318', '8991', '17508'' at line 3 Anyone has tried using index hint before? Thanks Wilfred - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: kaka's query speed is slow
Hi, Philip, Here is the query as you suggested: SELECT ox.ensembl_id, x.dbprimary_id, x.display_id, db.db_name FROM objectXref ox, Xref x, externalDB db WHERE ox.ensembl_id IN ('7263', '7318', '8991', '17508') AND x.xrefid = ox.xrefid AND db.externalDBId = x.externalDBId; Maybe WHERE ... IN ('7263', '7318', '8991', '17508') This change descreased the time between 20.21 sec to 23.71 sec. But repeating the original query (no single quote) only used 21.63 sec. The differences may be due to server load at execution time. So string or number datatype is not the cause. EXPLAIN SELECT your whole SQL statement here Here is the explain result: +---++---+-+-+++-+ | table | type | possible_keys | key | key_len | ref| |rows | Extra | +---++---+-+-+++-+ | ox| index | NULL | ensembl_object_type | 45 | NULL | |133764 | where used; Using index | | x | eq_ref | PRIMARY | PRIMARY | 4 | ox.xrefId | | 1 | | | db| eq_ref | PRIMARY | PRIMARY | 4 | x.externalDBId | | 1 | | +---++---+-+-+++-+ 3 rows in set (0.17 sec) mysql show index from objectXref; +++-+--+-+---+-+--++-+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | |Collation | Cardinality | Sub_part | Packed | Comment | +++-+--+-+---+-+--++-+ | objectXref | 0 | ensembl_object_type |1 | ensembl_object_type | |A |NULL | NULL | NULL | NULL| | objectXref | 0 | ensembl_object_type |2 | ensembl_id | |A |NULL | NULL | NULL | NULL| | objectXref | 0 | ensembl_object_type |3 | xrefId | |A |NULL | NULL | NULL | NULL| | objectXref | 1 | xref_index |1 | objectxrefId| |A |NULL | NULL | NULL | NULL| | objectXref | 1 | xref_index |2 | xrefId | |A |NULL | NULL | NULL | NULL| | objectXref | 1 | xref_index |3 | ensembl_object_type | |A |NULL | NULL | NULL | NULL| | objectXref | 1 | xref_index |4 | ensembl_id | |A |NULL | NULL | NULL | NULL| +++-+--+-+---+-+--++-+ 7 rows in set (0.18 sec) It seems that mysql is not using the index xref_index, but using ensembl_object_type. I tried to use hint (mysql version 3.23.25 beta) SELECT ox.ensembl_id, x.dbprimary_id, x.display_id, db.db_name FROM Xref x, externalDB db, objectXref ox USING INDEX (xref_index) WHERE ox.ensembl_id IN ('7263', '7318', '8991', '17508') AND x.xrefid = ox.xrefid AND db.externalDBId = x.externalDBId; ERROR 1064: You have an error in your SQL syntax near 'USING INDEX (xref_index) WHERE ox.ensembl_id IN ('7263', '7318', '8991', '17508'' at line 3 Anyone has tried using index hint before? Thanks Wilfred - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Solaris, JDBC and MySQL
Hi, Can anyone point me, a humble C programmer, to a tutorial for setting up and using JDBC and MySQL. We are having the following problem, which boils down to libobdcinst.so.1 not being found - where can I find it? SKYROAD#mercury1:/mercury/home/morgan/javatrial:java SimpleSelect DriverManager.getConnection(jdbc:odbc:mercury1) trying driver[className=sun.jdbc.odbc.JdbcOdbcDriver,context=null,sun.jdbc.odbc.Jdb cOdbcDriver@1bccd4ba] *Driver.connect (jdbc:odbc:mercury1) JDBC to ODBC Bridge: Checking security No SecurityManager present, assuming trusted application/applet JDBC to ODBC Bridge 1.1001 Current Date/Time: Fri Nov 30 12:30:09 GMT+12:00 2001 Loading JdbcOdbc library ld.so.1: /usr/bin/../java/bin/../bin/i386/native_threads/java: fatal: libodbcinst.so.1: open failed: No such file or directory (/usr/bin/../java/bin/../lib/i386/native_threads/libJdbcOdbc.so) ld.so.1: /usr/bin/../java/bin/../bin/i386/native_threads/java: fatal: libodbcinst.so.1: open failed: No such file or directory (/usr/bin/../java/bin/../lib/libJdbcOdbc.so) Unable to load JdbcOdbc library java.sql.SQLException: Unable to load JdbcOdbc library at java.lang.Throwable.init(Compiled Code) at java.lang.Exception.init(Compiled Code) at java.sql.SQLException.init(Compiled Code) at sun.jdbc.odbc.JdbcOdbc.init(Compiled Code) at sun.jdbc.odbc.JdbcOdbcDriver.initialize(Compiled Code) at sun.jdbc.odbc.JdbcOdbcDriver.connect(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at SimpleSelect.main(Compiled Code) Unable to load JdbcOdbc library Unable to allocate environment getConnection: no suitable driver java.sql.SQLException: No suitable driver at java.lang.Throwable.init(Compiled Code) at java.lang.Exception.init(Compiled Code) at java.sql.SQLException.init(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at SimpleSelect.main(Compiled Code) SQLException: SQLState(08001) *** SSQLException caught *** SQLState: 08001 Message : No suitable driver Vendor : 0 Thanks in advance Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 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
MySQL and RAID question
Just one quick question... I've heard that running a database in a system using RAID isn't a good idea on RAID 5, but works fine with mirroring (0, 0/1, 0/5). Does anyone out there have experience with MySQL on RAID 5, or know how MySQL performs in a RAID 5 environment? My concern is loss of data due to a drive going bad. At least that what I've heard could happen. Thanks, 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
General database design
1- What should I index? Index is for speed.. Should I mainly index the columns where I do often searches on them? Should I index all not null columns event if I rarely search using them? Should I index enum columns even if there is a lot of identical data. Will a search using only indexed columns be faster, or it will still go into the table itself to get the data? I read some about it in the guide, but still not clear. 2- Do you think it's better to have 4 small queries or one huge one that returns tons of lines? Let me explain. I have let's say, a main table events with fields evtID, evtName, etc. I have 3 smaller tables outlets, promoters and artists. Those are n:n relations with the events table. An event may have multiple artists, and an artist may be in multiple events. So I created 3 link tables eventoutlets with columns eoEvtID and eoOutID eventpromoters with columns epEvtID and epProID eventartists with columns eaEvtID and eaArtID So, if you still follow me, I want to get the list of artists playing at an event, plus the outlets for tickets and the promoters throwing the event. I can do a HUGE select statement, or make a couple of small ones. select epProID from eventpromoters where epEvtID = '3' select eoProID from eventpromoters where epEvtID = '3' select eaProID from eventpromoters where epEvtID = '3' (some script to store those results) select proName, proInfo from promoters where promoterID = '5' or promoterID = '6' or promoterID = '12' (etc) same for the artists, outlets.. ideally, something like select proName, proInfo from promoters where promoterID = (select eaProID from eventpromoters where epEvtID = '3') would be perfect, assuming it selects for all the occurences where epEvtID is 3 and not just the first one. Anyways, I'm pretty sure nobody went reading this far, I'd just like some input as how you're doing your things with n:n tables. And if you have any mailinglist you know that is more about database design itself.. Etienne -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 table name case sensitivity
Since Mac OS X is Unix it should use the same rules as a Unix machine when it comes to MySQL and case sensitivity of table and database names. According to Dubois: DB and tables in MySQL correspond to directories and files in the underlying file system on the server host. As a result, case sensitivity of db and table names depends on the way the OS on the host treats filenames. A server running on UNIX treats db and table names as case sensitive since UNIX filenames are case sensitive. However, I don't find this to be true on Mac OS X. In the following, I show that I have a table Menu (with capital M) but am able to insert or select using the lower case menu. Is there any explanation for this? mysql show tables; +--+ | Tables_in_bPublished | +--+ | Menu | +--+ 1 row in set (0.00 sec) mysql select * from menu; snip ... etc ... 6 rows in set (0.01 sec) mysql INSERT INTO menu VALUES ('',3,1,'Cat Stuff','Cat Stuff','/images/icons/Cat.gif',2), ('',4,1, 'Zebra Stuff','Zebra Stuff','/images/icons/Zebra.gif',2); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 2 mysql select * from Menu; snip ... etc ... 8 rows in set (0.00 sec) -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: How To Install Under MacOS X?
Try installing by fink.. http://fink.sourceforge.net/ If you have worked on debian, you will appreciate it. Regards, Kundan On 11/30/01 12:13 AM, Kurt Tappe [EMAIL PROTECTED] wrote: I'm stuck trying to figure out how to install this thing. What I've tried: * The download doesn't contain a standard MacOS .pkg so I can't do a GUI install. * The command-line instructions require the groupadd command in step #1, but MacOS doesn't support this due to the existence of the NetInfo system. * Turning to the manual.html included in the MacOS X build, only Linux and Windows are mentioned. Can anyone who has successfully installed MySQL under MacOS X tell me how they did so?? Thanks, -Kurt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Subtracting Dates
Oh, well, I didn't really have a solution. I just took it all out in seconds, and did the math inside the application. On Thursday 29 November 2001 01:12 pm, Mark Rissmann wrote: It would be beneficial to the group if everyone would post their solutions to the list if they solve it on their own. IMHO, Mark -Original Message- From: Ken Kinder [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:10 AM To: Walter D. Funk; [EMAIL PROTECTED] Subject: Re: Subtracting Dates Well, I really do need the exact timespan in human-readable format. What I did do was get the difference in seconds, then properly format that manually. :/ Thanks anyway though. On Friday 16 November 2001 07:24 am, Walter D. Funk wrote: Why don´t you try select TO_DAYS(end_date)-TO_DAYS(start_date) as duration : this will return the difference in days if you need mor accuracy i.e. difference in hours, you should word on a TIMESTAMP 14 instead of date ; this data type holds up to seconds and is mathematically easy to operate ... i hope it helps - Original Message - From: Ken Kinder [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 8:32 PM Subject: Subtracting Dates The date addition and subtraction functions in mysql don't seem to quiet do this. I was wondering if anyone know a way I could do this in the query: Say you have two fields, start_time, and end_time, representing the start and end of a period of time. Both are datetime datatypes. What I want is the logical equivalent of: select end_time - start_time as duration from I want the difference between those two, such that it would say 0 days, 4 hours or something. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: timely backup
hi Thomas, Thanks for advice. My database is on LINUX. Can give bit details of cron. Even link regarding that also sufficient. thanks in advance. regards, sreedhar - Original Message - From: Thomas Spahni [EMAIL PROTECTED] To: sreedhar [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 6:20 PM Subject: Re: timely backup On Thu, 29 Nov 2001, sreedhar wrote: Can you tell how can i do my database backup timely i mean in regular intervals with out explicitly doing by us. Sreedhar, It depends. You have not been extremely verbose describing your actual requirements or your system, but you might look into - a cron job doing the backup by starting a script regularly - replication Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 vs Interbase
At 16:44 2001-11-29 +, you wrote: On Thursday 29 Nov 2001 16:18, Fabien R. wrote: I saw somewhere that this comparaison existed but I can't remember where. Does it talk to anyone ? I am a 2 weeks old newbee I did try interbase because it came with staroffice 5.2 never been able to make it start never been able to read a table from StarOffice The interface look like old DBASE! One one thing to say: The best part is when you delete it I just install easyphp (I am on winNT 4.0) in a few clic, it work in a few clic you install myodbc in a few clic StatOffice read MySQL table. in a few clic, I install mySQL-Front Hope that help... Ray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: please help me
On Thu, 29 Nov 2001, anandakkumar araskumar wrote: Hi all Iam new to php and iam learning that from scratch.I came across a problem in connecting mysql from php script.I run php in windows2000 under IIS configured to personal web server.I have installed mysql with server and client and both are running in the same machine(ofcourse, i can you use the ipaddress of localhost).I didn't set any username or password with mysql. This is my php script: $link=mysql_connect(localhost); if($link) die(Couldn't connect to mysql.mysql_error() ); Perhaps you meant if(!$link) ... Notice the not ! operand. If a link is established then the $link PHP variable will no longer hold the empty string. In PHP all varaibles are automatically initialized to hold an empty string which can also be used interchangeably with the boolean false value. The standard way of connecting is: $link = mysql_connect($db_host, $db_user, $db_pass) OR die(Could not connect to database server.); Here the stuff after OR is executed only if mysql_connect returns false which is the way the C || operator works. Regards, Neil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, Red Hat Linux and php
If I were you I would simply upgrade to Red Hat 7.1 or better 7.2. It probably takes just as much time to install a whole distro than having to worry about installing apache, then mysql, then php, all over again, and most likely getting something wrong and having to go back. Also there may be problems with compatibility etc... I remember having some problem compiling php with mysql support when mysql was not installed under /usr/local (something like the php configure option did not allow to specify a directory for the mysql installation). But perhaps this has changed in php 4.0.6. Regards, Neil On Thu, 29 Nov 2001 [EMAIL PROTECTED] wrote: Hello, Which version of MySQL ( RPM packages ) is good for work with php 4.0.6 and Linux Red Hat 6.2 ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Suggestion: Formatting TimeStamp columns
In message [EMAIL PROTECTED], Thomas Spahni [EMAIL PROTECTED] writes On Mon, 26 Nov 2001, Brent wrote: A Select statement will display the TmeStamp as 2005095105. Now I ask you, how many users will understand this format? Why not display TimeStamp in the same format as DateTime? At least then the TimeStamp is in a meaningful representation that users can understand. I'm not saying to change the input format. Inputting the TimeStamp data can be kept the same, but it should have a default display format similar to DateTime. The actual format for TimeStamp and DateTime could be stored in the my.cnf or my.ini file so the display format can be adjusted on the server. This format string could be the parameter used in the Date_Format function. What do you think? Changing the default output format is a very bad idea because it will break every client application depending on the current format. The default format has to be controlled by the client software at table creation time and not on a per user basis in the config files. The remaining option I can see is to ADD a new display format and define TIMESTAMP(1) or possibly TIMESTAMP(15) to display a string like a DATETIME column. Well till then... but I have some perl bits that you can have it you want? M. -- Work:- postmasterAThinwick.demon.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
CPU consumption on sorting
[table] Is there a significant CPU consumption difference between this: SELECT * FROM posts ORDER BY lastPostTime, id compared to this: SELECT * FROM posts ORDER BY lastPostTime My gut feeling tells me that they should almost take the same amount of time to execute, because 'id' only needs to be compared if 'lastPostTime' is the same (when comparing two rows to decide which ones go first) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: timely backup
$ man cron sreedhar wrote: hi Thomas, Thanks for advice. My database is on LINUX. Can give bit details of cron. Even link regarding that also sufficient. thanks in advance. regards, sreedhar - Original Message - From: Thomas Spahni [EMAIL PROTECTED] To: sreedhar [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 6:20 PM Subject: Re: timely backup On Thu, 29 Nov 2001, sreedhar wrote: Can you tell how can i do my database backup timely i mean in regular intervals with out explicitly doing by us. Sreedhar, It depends. You have not been extremely verbose describing your actual requirements or your system, but you might look into - a cron job doing the backup by starting a script regularly - replication Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: GUIfront-end in Linux?
Check out MySQL Navigator at http://sql.kldp.org/mysql/ I use it almost every day, and find it does everything I need in a GUI MySQL client. j- k- On Thursday 29 November 2001 03:02, Frank J. Schmuck wrote: I'm moving from Win2k to Linux and was wondering if there was a GIU MySQL front-end in Linux similar to Mascon or mysqlfront for the windoz Oss. Thanks Frank - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
TEXT v.s. VARCHAR
[table] Does TEXT have any significant disadvantages compared to VARCHAR? We need to store a bit of text, but in some cases it can exceed 255 characters, so we have to use TEXT. I'm guessing that the only difference is that the length counter needs 2 bytes instead of 1 byte of space, right? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 installing MySQL-3.23.45-1.i386.rpm
hey, i'm having trouble installing MySQL-3.23.45-1.i386.rpm already installed MySQL-client-3.23.45-1.i386.rpm MySQL-devel-3.23.45-1.i386.rpm when i try to install MySQL-3.23.45-1.i386.rpm i get the following: [root@localhost rpms]#rpm -U --force --replacefiles MySQL-3.23.45-1.i386.rpm error: failed dependencies: libmysqlclient.so.10 is needed by php-mysql-4.0.4pl1-9 could you tell me how to get around this problem? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
update date problem
can i do this? content in field=aaa,bbb,ccc,hhh new content=aaa,bbb,ccc,hhh,fff can i append new word fff into the old field .by use update command in 1 query :) it's like UPDATE persondata SET age=age+1 but i want to append new value into old field... what should i do . help me help me plsss ^_^ __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqldump: problem/question
Okay, I know you guys have been wracking your brains for the last two days trying to solve my problem of mysqldump running out of memory while dumping a large table. I figured it out, so you can all go on with your lives. My copy of Paul DuBois' MySQL book came today and immediately solved my problem. Cool book. Now I have something to do this weekend. Thanks, --Walt Weaver Bozeman, Montana Oracle smart, MySQL dumb (for now) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Install Under MacOS X?
I saw that someone posted a question about how to install MySQL under Mac OS X. I found a great tutorial and I haven't had any problems yet, 4 weeks after I installed. http://www.entropy.ch/software/macosx/ Good luck! --- Daryl C. DuLong http://daryldulong.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: Subtracting Dates
It would be beneficial to the group if everyone would post their solutions to the list if they solve it on their own. IMHO, Mark -Original Message- From: Ken Kinder [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:10 AM To: Walter D. Funk; [EMAIL PROTECTED] Subject: Re: Subtracting Dates Well, I really do need the exact timespan in human-readable format. What I did do was get the difference in seconds, then properly format that manually. :/ Thanks anyway though. On Friday 16 November 2001 07:24 am, Walter D. Funk wrote: Why don´t you try select TO_DAYS(end_date)-TO_DAYS(start_date) as duration : this will return the difference in days if you need mor accuracy i.e. difference in hours, you should word on a TIMESTAMP 14 instead of date ; this data type holds up to seconds and is mathematically easy to operate ... i hope it helps - Original Message - From: Ken Kinder [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 8:32 PM Subject: Subtracting Dates The date addition and subtraction functions in mysql don't seem to quiet do this. I was wondering if anyone know a way I could do this in the query: Say you have two fields, start_time, and end_time, representing the start and end of a period of time. Both are datetime datatypes. What I want is the logical equivalent of: select end_time - start_time as duration from I want the difference between those two, such that it would say 0 days, 4 hours or something. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LIMIT by column return
Hi Tom, I don't think there is a straight way in Mysql to accomplish this. It would have been great if Mysql included this provision. I suggest you to use temporary tables. First make a temporary table inserting values of job and the maximum date of inv for the job. Create temporary table temp1 select max(date) dt , job from tbl group by job; Now create another temp table with vaulues of job and maximum date but which is not in the temporary table created first. Outer join can be used here. Create temporary table temp2 select max(date) dt, job from tbl a left join temp1 b on a.job = b.job and a.date = b.dt where b.job is null group by job; Insert one temp into the other (insert into temp1 select * from temp2). Querying this table along with the original tables will yield the result. I hope there would be more elegant solution to this problem. Note : The date, job combination should be unique for this to work correctly. Anvar. At 09:22 AM 29/11/2001 -0800, you wrote: I'm trying to write a query that will limit the results but not by the total amount returned like a normal LIMIT. It's an invoice database and I would like to return the last to invoices for a certain job. So if there are 100 jobs with several invoice dates I would like to return a web page displaying a table of invoice dates ordered by job name and LIMIT the invoice dates to the last two invoice dates for each job. Here's my query so far; SELECT site_service.id, site_service.service_date, site_service.invoice_date, site.site_id, site.name, site.state, site.status FROM site_service, site WHERE site_service.site_id = site.id AND site.company = 'Nextel' If I add LIMIT 2, I only get two invoices. I'm trying to get the last to invoices for each site. Is this possible or is there another direction I should go? I checked out the MySQL site without any luck. Thanks, Tom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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