Re: Index not used for order by when more than 1 field selected, no where clause
Benjamin Pflugmann wrote : Hi. [] If MySQL uses the index, it has one of two possibilities. First: 1. Read the whole isbn index, and for each row 2. seek the record in the data file and get author from it. This is quite slow because of the random file seeks needed. Second: 1. Read the whole isbn index (since you have no restricting WHERE clause) 2. Read isbn,author from the whole data file in unsorted order (you need isbn, too, else MySQL wouldn't know where the authors belong too) 3. Sort isbn,autor (using sorted isbn, so using selection sort?) This is still slower than MySQL's approch: Third: 1. Read isbn,author from the whole data file in unsorted order 2. Sort isbn,autor as "Second" additionally has to read the index file from disk with no additional benefit. I don't know how to express that elegant, but the problem is that by including author to the queried fields, you have an unsorted column which requires a full sort. "Second" is never the best way. MySQL uses "First" up to some percentage of the amount of records (30% I believe), then uses "Third", because reading the data in file order (unsorted) and sorting is usually faster than random seeks (due to index usage) over that percentage of records. Hi all, Sorry to jump in the middle of this thread but your comment make me think of a case where random seeks may still be better even if more than 30% of records are involved: When you set up your database server so that it has enough RAM to keep the whole database in main memory (buffer cache), random reads don't need to wait for physical disk seeks and can be very fast. This is actually the case of our database server (2Gb RAM, 500 Mb database); vmstat shows that MySQL can run for hours without any disk read even under high load (more than 300 queries/s). So my question is: Is it a way to tune this threshold ? (In the case described above, it may still be faster to use random seeks up to 60 a 70% instead of 30%). Bye, Thanks -- Joseph Bueno NetClub/Trader.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
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Tarmo Kähr Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.22.30 (Official MySQL RPM) Environment: System: Linux aleph.jarve.edu.ee 2.2.12-20 #1 Mon Sep 27 10:40:35 EDT 1999 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Fwd: storing files in database]
NOTE: Since iam not a member of this group, please reply by cc`ing to my mail id. -- Sivaramakrishnan I AdventNet (India) Development center. Madras, India. Phone: 91 44 243 2414 Hi all, Basically I have a requirement where I have to store xml files in the database. The table that I visualised for the purpose will contain two columns, one being the key (varchar) and the other for the xml file. What data type should I use for the second column. Are there any inherent problems with the above mentioned design like size of the file, or any other limitations that I don't foresee. Please let me know your thoughts. Awaiting your reply. Thanks Regards I. Siva -- Sivaramakrishnan I AdventNet (India) Development center. Madras, India. Phone: 91 44 243 2414 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 1114: The table 'SQLb07dc_0' is full
Hi, I have this error when I execute a query : ERROR 1114: The table 'SQLb07dc_0' is full I can execute other queries without problems but when I want to execute the query : SELECT DISTINCT person.* FROM person, training, cursus where training.BRANCH_ID=101 and training.CURSUS_SID=cursus.CURSUS_SID and cursus.STUDENT_SID=person.PERSON_SID; there is always the same error message. How can I do to reset the table 'SQLb07dc_0' or to reset the sql buffer ? Regards
DROP COLUMN
im new to this list and to the SQL language, id like to know if anyone knows how to drop a column from a SQL database,i currently have the following string: "ALTER TABLE WorkGroups DROP COLUMN Personnel" i read somewhere something about having to store the information in a temporary column before dropping it but cant rememebr where i read it, i get an error that says:Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Personnel'. thanx regards wernher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Optimal configuration
Hi. I have a server running mysql.From it reads data two web server wich has about 30.000 daily visits and 250.000 pages so the trafic to the mysql server is big. Can anybody tell me a optimal mysql configuration for this server?. Actually in the /etc/my.cnf i have: set-variable = max_connections=500 set-variable = wait_timeout=1000 set-variable = key_buffer=64M set-variable = table_cache=256 The server has 650M of ram and two HD of 17 GB. Thanks. PD:Excuse me for my poor english. ;) Jess Gmez Pastor [EMAIL PROTECTED] Equipo de Desarrollo Autocity Networks www.autocity.com wap.autocity.com
Binary installation of mysql 3.23.33
Okay, here's the deal. First I unpack the .tar.gz into /a-path-name/mysql-dir-name After that I should (atleast according to the readme) type ./configure --prefix=/usr/local/mysql That script tells me that this is a binary version and that I dont need to configure it, it's ready to rock as it is. Further down in the readme it tells me to run ./scripts/build_mysql_db or something like that. When I run that it says "you must install first, type make and make install blabla"... Ok, now I'm back to the ./configure again, cause I have to configure the install before I can actually install the program... Anyone knows what I'm doing wrong?... It feels like I'm running around in a circle Regards Peter [EMAIL PROTECTED]
Re: ERROR 1114: The table 'SQLb07dc_0' is full
On Fri, Feb 16, 2001 at 09:55:32AM +0100, Chappuis J.-Vincent wrote: Hi, I have this error when I execute a query : ERROR 1114: The table 'SQLb07dc_0' is full I can execute other queries without problems but when I want to execute the query : SELECT DISTINCT person.* FROM person, training, cursus where training.BRANCH_ID=101 and training.CURSUS_SID=cursus.CURSUS_SID and cursus.STUDENT_SID=person.PERSON_SID; there is always the same error message. How can I do to reset the table 'SQLb07dc_0' or to reset the sql buffer ? I've seen this when MySQL uses an internal table for temporary data. There is a limit on the size of these tables. You can force MySQL to use a file in its temporary directory to store the results: set SQL_BIG_TABLES = 1; An alternative is to do a SELECT SQL_BIG_RESULT ... instead of SELECT ... . Note that SELECT SQL_BIG_RESULT doesn't work in 3.22.x, though it is accepted by the parser. You don't mention which version you use. 'set SQL_BIG_TABLES' works fine in 3.22.x. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Some problems encountered when linked to glibc-2.2.1
Description: I built mysql-3.23.33 against glibc-2.2.1, under Linux, kernel 2.4.1 Although the server appeared to be functional, all "show" commands yielded blank lines, and mysqldump would not create a dump file for databases - it would still work for specified tables. Using mysqlshow, the output was the usual table, which contained a blank linex for each database Using mysqlshow mysql, the result was no tables. How-To-Repeat: I had exactly the same symptoms with both mysql-3.23.22-beta and with mysql-3.23.33, when built against the glic-2.2.1 libraries. Fix: Removed all the glibc-2.2.1.* libraries and restored the 2.1.2 libraries, rebuilt mysql, and the problem vanished. The problem does seem to be tied to the glibc-2.2.1 libraries, but whether "bug" lies in the libraries or in mysql is a more difficult question. Submitter-Id: submitter ID Originator:Pat Verner Organization: Isis Information Systems MySQL support: none [none | licence | email support | extended email support ] Synopsis: musql "show" functions not working Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.33 (Source distribution) Environment: System: Linux patspub 2.4.1 #5 Wed Jan 31 08:03:21 SAST 2001 i586 unknown Architecture: i586 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Feb 16 09:50 /lib/libc.so.6 - libc-2.1.2.so -rwxr-xr-x 1 root root 1008844 Sep 10 1999 /lib/libc-2.1.2.so -rw-r--r-- 1 root root 20019674 Sep 16 1999 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 16 1999 /usr/lib/libc.so Configure command: ./configure - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RedHat 7.0 and threading
Hi, we had a rather ... interesting ... problem with mysqld, compiled on a system with glibc-2.1.3. We tried to run the server on a RedHat 7.0 machine and had inexplicable pthread errors. The solutions turned out to be either to downgrade /lib/libpthreads.so.0 and /lib/librt.so.1 to the versions from a RH 6.4 system, which worked temporarily but is IMHO somewhat dangerous, or to upgrade glibc to the version from redhat's Rawhide (2.2.1-3 at the moment). We didn't try the 2.2 from redhat's 7.0 updates, because I follow the glibc mailing list. :-/ It's probably a compiler problem; Rh 7.0 used a rather buggy gcc :-( and the version -- Matthias Urlichs | noris network AG | http://smurf.noris.de/ -- If wishes were horses, then beggars would be thieves. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DROP COLUMN
hello list;) i have a SQL command to DROP a COLUMN from a mySQL database, the problem is that the syntax i am using doesnt seem to be the right syntax for mySQL, my statement currently read:"ALTER TABLE WorkGroups DROP COLUMN Personnel" and i get the error message: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Personnel'. please help thanx regards wernher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: storing files in database
On 16.02.2001 10:05:54 I.SivaramaKrishnan wrote: Hi all, Basically I have a requirement where I have to store xml files in the database. The table that I visualised for the purpose will contain two columns, one being the key (varchar) and the other for the xml file. What data type should I use for the second column. I always use a MEDIUMTEXT type for this, see: http://www.mysql.com/doc/C/o/Column_types.html . Although the column allows you to store 16 MB of data, it maybe that you need to start mysqld with a larger max packet size, as the default is 1 MB, which may not be enough. Further, I store the values base64 encoded in the column, so that I don't need to take care of special characters like ', " or \0. This will also increase the datasize by about 33%. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: [Fwd: storing files in database]
On 16.02.2001 10:08:26 I.SivaramaKrishnan wrote: NOTE: Since iam not a member of this group, please reply by cc`ing to my mail id. That's a behavior I never quite understood - you come to list seeking for advice. Fine. Next you say that you do not care at all about the list. Geez, if you want answers, it's *YOUR* responsibility to obtain them! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Restart MySQL after rebooting Linux
kentj [EMAIL PROTECTED] writes: I believe so. I was trying that and was missing something because I could not get it to work. If you've for it in init.d and "mysql stop" and "mysql start" work there, then make sure they're also symlinked into rc3.d directory. -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL statement in PHP
Can anybody help with this If I put the following statement in PHP my browser tells me that there is an error on the line. //create sql statement $sql = "select Business_Name,Trading_Details where Business_Type = "Consultancy" and Bassingbourn != "0" from Main"; If I remove where Business_Type = "Consultancy" and Bassingbourn != "0" It work fine, but no variation of the above line works. Am I missing something really obvious. Please help as I am very quickly becoming bald. Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DELETE FROM mergetable clears merge definition
Description: "DELETE FROM mergetable" clears merge definition How-To-Repeat: mysql use test; Database changed mysql CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, message CHAR(20)); Query OK, 0 rows affected (0.04 sec) mysql CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY, message CHAR(20)); Query OK, 0 rows affected (0.00 sec) mysql INSERT INTO t1 (message) VALUES ("Testing"),("table"),("t1"); Query OK, 3 rows affected (0.11 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql INSERT INTO t2 (message) VALUES ("Testing"),("table"),("t2"); Query OK, 3 rows affected (0.01 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql CREATE TABLE total (a INT NOT NULL, message CHAR(20), KEY(a)) TYPE=MERGE UNION=(t1,t2); Query OK, 0 rows affected (0.00 sec) mysql mysql select * from total; +---+-+ | a | message | +---+-+ | 1 | Testing | | 2 | table | | 3 | t1 | | 1 | Testing | | 2 | table | | 3 | t2 | +---+-+ 6 rows in set (0.03 sec) mysql delete from total; Query OK, 0 rows affected (0.01 sec) mysql select * from total; Empty set (0.00 sec) !!! you can now also check that totals.MRG is empty !!! mysql select * from t1; +---+-+ | a | message | +---+-+ | 1 | Testing | | 2 | table | | 3 | t1 | +---+-+ 3 rows in set (0.00 sec) mysql select * from t2; +---+-+ | a | message | +---+-+ | 1 | Testing | | 2 | table | | 3 | t2 | +---+-+ 3 rows in set (0.01 sec) mysql alter TABLE total UNION=(t1,t2); Query OK, 0 rows affected (1.00 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql select * from total; +---+-+ | a | message | +---+-+ | 1 | Testing | | 2 | table | | 3 | t1 | | 1 | Testing | | 2 | table | | 3 | t2 | +---+-+ 6 rows in set (0.01 sec) mysql Fix: Use a WHERE clause to specify which rows to delete. Submitter-Id: [EMAIL PROTECTED] Originator:Fred van Engen Organization: XO Communications B.V. MySQL support: none Synopsis: "DELETE FROM mergetable" clears merge definition Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.33 (Source distribution) Environment: System: SunOS lei 5.7 Generic_106541-07 sun4u sparc SUNW,Ultra-250 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc GCC: Reading specs from /opt/gcc/lib/gcc-lib/sparc-sun-solaris2.7/2.8.1/specs gcc version 2.8.1 Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1693556 Sep 22 1999 /lib/libc.a lrwxrwxrwx 1 root root 11 Oct 7 1999 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1115304 Sep 22 1999 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1693556 Sep 22 1999 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Oct 7 1999 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1115304 Sep 22 1999 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/opt/mysql-3.23 Perl: This is perl, version 5.005_03 built for sun4-solaris !!! The above is generated by mysqlbug on the system that MySQL runs on. The !!! MySQL source was compiled on an identical system with gcc 2.95.2. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: difference of two datetime values
select if(columnname now(), "future", "past") from tblname On Fri, 16 Feb 2001, Vyacheslav Chukin wrote: Please, tell me, how could I determine, which one of two datetime values is greater? In other words, how could I determine, is stored on db datetime value in future or past? Best regards, mailto:[EMAIL PROTECTED] Vyacheslav Chukin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: JDBC question?
If U R using some IDE, then there shd be a place to add on Ur classpaths. If not, from the prompt For Windows java -classpath "c:\JDBCdriver;c:\JDBCdriver\driver.jar;." file.java For Unix java -classpath "/tmp/JDBCdriver:/tmp/JDBCdriver/driver.jar:." file.java note: when including jar or zip U have to include the fileName. Cheers! Thiru PS: U find extensiv dos on setting classpath. go to www.javasoft.com On Fri, 16 Feb 2001 20:29:27 +0800 Chen Ka Pong [EMAIL PROTECTED] wrote: - I cannot use the jdbc connection which the driver is download - from mysql web site. The error message prompted that - "invalid JDBC Driver", what can cause this error? - I predict my classpath is wrong, but I would like to know - how to set the classpath? - (at this status, I am not sure if my classpath is correct or not) - - Thanks! - - Pong - -o0o "There is no finish line, you can always learn" "You have to keep pressure on yourself, you have to work on your weaknesses". Thiru S/W Engineer, Service Dvlpment Group Infoseek,Japan Voice - (81)-3-5453-2056 http://www.infoseek.co.jp - Click Here http://www.rakuten.co.jp - Click Here http://house.infoseek.co.jp - Click Here http://profile.infoseek.co.jp - Click Here http://chat.infoseek.co.jp - Click Here - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x
Hi, readers of the mailing list! Monty will roll a new distribution of MySQL 3.23.3x this weekend. Innobase will be included there and it will provide transactions, rollback, recovery, row level locking, and Oracle-like consistent read. Monty will leave for a vacation in Rio on Wednesday, so the new distribution should be ready at the latest on that day. Currently, Intel NT and Intel Linux versions have been tested. We will compile and test Solaris 32-bit and Linux Alpha 64-bit versions this weekend. Regards, Heikki Tuuri Innobase Oy Helsinki, Finland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL statement in PHP
Take a look at your query once again: "select/../"Consultancy"/.../" You can have "" inside "". The ways to do it, so that it would work: - use '$somethinghere' instead of "$something" or - use \"$somethinghere\" instead of second "$something" or - use '".$somthinghere."' instead of ... Cheers Siim Einfeldt Can anybody help with this If I put the following statement in PHP my browser tells me that there is an error on the line. //create sql statement $sql = "select Business_Name,Trading_Details where Business_Type = "Consultancy" and Bassingbourn != "0" from Main"; If I remove where Business_Type = "Consultancy" and Bassingbourn != "0" It work fine, but no variation of the above line works. Am I missing something really obvious. Please help as I am very quickly becoming bald. Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL statement in PHP
PHP sees the first " of "Consultancy" as being the end of the variable $sql. To get round this, change the " to ' inside the statement (e.g. ...where Business_Type = 'Consultancy' and...) HTH Jon -Original Message- From: Matt Davis [mailto:[EMAIL PROTECTED]] Sent: 16 February 2001 12:43 To: mysql Subject: SQL statement in PHP Can anybody help with this If I put the following statement in PHP my browser tells me that there is an error on the line. //create sql statement $sql = "select Business_Name,Trading_Details where Business_Type = "Consultancy" and Bassingbourn != "0" from Main"; If I remove where Business_Type = "Consultancy" and Bassingbourn != "0" It work fine, but no variation of the above line works. Am I missing something really obvious. Please help as I am very quickly becoming bald. Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL statement in PHP
On Fri, Feb 16, 2001 at 12:43:15PM -, Matt Davis wrote: Can anybody help with this If I put the following statement in PHP my browser tells me that there is an error on the line. //create sql statement $sql = "select Business_Name,Trading_Details where Business_Type = "Consultancy" and Bassingbourn != "0" from Main"; You need to escape the double-quotes in the double-quoted string. I don't know PHP, but usually something like below should work: //create sql statement $sql = "select Business_Name,Trading_Details where Business_Type = \"Consultancy\" and Bassingbourn != \"0\" from Main"; Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Table timestamps? More specific control of SHOW TABLE STATUS command
Why don't you : select timestampfield from mytable order timestampfield decs limit 1 Jay Lawrence wrote: Atle, your suggestion is for the last time a record was updated. I am interested in the entire table. The closest that I have seen thus far is: SHOW TABLE STATUS The Update_time field is most likely what I am after. However I was hoping to do something more like select Update_time from table(x) status Giving me one value back - the Update_time for table "x" of current database. Perhaps this is a candidate for function extension? Jay You might be able to use this, depending on your needs: from http://www.mysql.com/doc/D/A/DATETIME.html [snip] Automatic updating of the first TIMESTAMP column occurs under any of the following conditions: The column is not specified explicitly in an INSERT or LOAD DATA INFILE statement. The column is not specified explicitly in an UPDATE statement and some other column changes value. (Note that an UPDATE that sets a column to the value it already has will not cause the TIMESTAMP column to be updated, because if you set a column to its current value, MySQL ignores the update for efficiency.) You explicitly set the TIMESTAMP column to NULL. [/snip] .. Atle On Wed, 14 Feb 2001, Jay Lawrence wrote: Hey all, Is there a way to quickly obtain the last time a table was updated/touched? In my app I am caching queries so long as the table data has not changed. I'd like a quick check to see if a table has changed since the query was first executed. My perusal of documentation plus a few searches on mailing lists has not uncovered this matter - but I could have missed it. TIA, Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
installation on hpux10.20 ends with ./mysql_install_db[284]: 13980 Memory fault(coredump)
Description: After having installed binaries, or compiled source code, mysql_install_db ends in a coredump How-To-Repeat: Fix: Submitter-Id: [EMAIL PROTECTED] Originator: Organization: MySQL support: [none ] Synopsis: install ends in coredump Severity: [ critical ] Priority: [ high ] Category: mysql Class: [ sw-bug ] Release:mysql-3.23.33 (Source distribution) Environment: HP9000/D270, OS HPUX10.20, gcc System: HP-UX server B.10.20 A 9000/861 Some paths: /usr/local/bin/perl /usr/local/bin/make /opt/gcc/bin/gcc /opt/gcc/bin/cc GCC: Reading specs from /opt/gcc/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -r-xr-xr-x 1 binbin1863680 Nov. 10 1999 /lib/libc.1 -r--r--r-- 1 binbin2456532 Nov. 10 1999 /lib/libc.a lrwxr-xr-x 1 root sys 15 Juni 10 1996 /lib/libc.sl - /usr/lib/libc.1 -r-xr-xr-x 1 binbin1863680 Nov. 10 1999 /usr/lib/libc.1 -r--r--r-- 1 binbin2456532 Nov. 10 1999 /usr/lib/libc.a lrwxr-xr-x 1 root sys 15 Juni 10 1996 /usr/lib/libc.sl - /usr/lib/libc.1 Configure command: ./configure --with-pthread --with-named-thread-libs=-ldce --prefix=/usr/local/mysql --disable-shared --with-named-curses-libs=/usr/local/lib/libncurses.a --with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock --with-mysqld-user=mysql --with-libwrap Perl: This is perl, version 5.003 with EMBED - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Indefinite Timeouts
Mario Oschwald writes: Hi, Didnt find this anywhere in the documentation... does -1 work if I want to set a Mysql timeout variable to indefinite?? e.g. wait_timeout=-1 Thanks Mario Oschwald No, you will have to set a very large value. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: taxes
Unless you have a physical location in that state! If you are in a state where Dell has a location you must pay that state's sales tax. Hey Vivek do you ever sleep! :) Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "Vivek Khera" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 15, 2001 10:26 PM Subject: Re: taxes "MK" == Mikel King [EMAIL PROTECTED] writes: MK guys I think you are making this a way bigger problem than it MK really is...e-merce crap is generally taxed based on the location MK of the vendor; much the same way in which mail order businesses MK are taxed. You really only have to worry about the state/locality What world (or country) do you live in? When was the last time you ordered something from Dell or Apple on line? What tax rate did you pay? You pay your local rate; not the rate of the location of the store. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Can't connect to MySQL when using PHP
I'm start MySQL with 'mysqld-opt --default-character-set=gbk'. I can use mysql connect to MySQL,and query. But I use PHP,it display: Warning: MySQL Connection Failed: Can't initialize character set 28 (path: default) in Why??? WinMe+Apache 1.3.17(Win32)+PHP 4.04pl1+MySQL 3.23.33 [EMAIL PROTECTED]
show database does not work ;-(
Dear All I've just installed mysql on a new host (3.23.33) and show databases does not work ;-(. The data directory is thus: drwxrwsr-x5 mysqlmysql4096 Feb 16 14:06 mysql Inside it has: [root@server1 lib]# ls -l mysql/ total 28 drwx--S---2 mysqlmysql4096 Feb 16 13:43 foo drwxrwxr-x 24 mysqlmysql4096 Feb 16 13:23 mysql -rw-rw1 mysqlmysql5769 Feb 16 14:09 server1.log -rw-rw-r--1 mysqlmysql 780 Feb 16 14:06 server1.totallyradio.com.err -rw-rw1 mysqlmysql 4 Feb 16 14:06 server1.totallyradio.com.pid drwx--2 mysqlmysql4096 Feb 16 13:23 test Which all looks normal. I can connect etc but show does not work - if I do : SELECT * on mysql.users; I get results. Is this a bug (in which case I do a full bug report) -- I have a feeling I am doing something very wrong that must be obvious ? A rather dazed and confused, Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DROP COLUMN
hello list;) i have a SQL command to DROP a COLUMN from a mySQL database, the problem is that the syntax i am using doesnt seem to be the right syntax for mySQL, my statement currently read:"ALTER TABLE WorkGroups DROP COLUMN Personnel" and i get the error message: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Personnel'. please help me, tis urgent that it works soon thanx regards wernher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL statement in PHP
Matt Davis wrote: Check the manual. The manual shows where following from. Can anybody help with this If I put the following statement in PHP my browser tells me that there is an error on the line. //create sql statement $sql = "select Business_Name,Trading_Details where Business_Type = "Consultancy" and Bassingbourn != "0" from Main"; If I remove where Business_Type = "Consultancy" and Bassingbourn != "0" It work fine, but no variation of the above line works. Am I missing something really obvious. Please help as I am very quickly becoming bald. Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
transactions -- whole table locked from reads too?
If I start a transaction (set autocommit=0 in the command line utility), then do an "insert" in one session, then open a second session and try to do a select on that table, before the first session has committed, the select just hangs. Once I commit in the first session, my select proceeds fine. Is there some reason the whole table seems to be locked from reads just because someone has an uncommitted transaction? The table type is BDB, it's running on Solaris 7/SPARC. Thanks for any help you can offer! -Scott - Scott McCool [EMAIL PROTECTED] (703)847-3303x2051 -
Merge table problem.
Hello monty, I'm trying to use merge table for logging - to have a possibility to Rotate log files and to quickly delete old data - for this I'm goint to setup a number of merge tables where each contains data for one day, and the inserts are done to the last table using real table name, therefore the select runs on merged table to cover all data. Currently I found the followning problem which may lead to the problems: mysql create table t1 (val char(10)); Query OK, 0 rows affected (0.00 sec) mysql create table t2 (val char(10)); Query OK, 0 rows affected (0.00 sec) mysql create table test (val char(10)) type=merge union=(t1,t2); Query OK, 0 rows affected (0.00 sec) mysql insert into t1 values("a"); Query OK, 1 row affected (0.01 sec) mysql insert into t2 values("b"); Query OK, 1 row affected (0.00 sec) mysql select * from test; +--+ | val | +--+ | a| | b| +--+ 2 rows in set (0.00 sec) mysql as you see the result is correct and merge table reflects all changes: mysql insert into t2 values("b"); Query OK, 1 row affected (0.00 sec) mysql select * from test; +--+ | val | +--+ | a| | b| | b| +--+ 3 rows in set (0.00 sec) Dublicates are also wellcome. Let's add the key: mysql alter table t2 add key(val); Query OK, 2 rows affected (0.00 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql insert into t2 values("b"); Query OK, 1 row affected (0.00 sec) mysql select * from test; +--+ | val | +--+ | a| | b| | b| +--+ 3 rows in set (0.00 sec) As you see the're starting to get incorrect result. The same thing will be if I'll insert other different rows. The only thing to fix this is to flush table test; Other thing which also seems to be strange: mysql delete from t1; Query OK, 0 rows affected (0.00 sec) mysql delete from t2; Query OK, 0 rows affected (0.00 sec) mysql select count(*) from test; +--+ | count(*) | +--+ |2 | +--+ 1 row in set (0.00 sec) mysql select * from test; +--+ | val | +--+ | zzz | | zzz | +--+ 2 rows in set (0.00 sec) The last thing is unrepeatable. But I got this once during the tests. Other tests show even more strange ting (this seems not to be key related): mysql alter table t2 drop key val; Query OK, 0 rows affected (0.00 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql insert into t1 values("zzz"); Query OK, 1 row affected (0.00 sec) mysql insert into t2 values("zzz"); Query OK, 1 row affected (0.00 sec) mysql select * from test; +--+ | val | +--+ | zzz | +--+ 1 row in set (0.00 sec) mysql -- Best regards, Peter mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can't connect in Windows 2000
Sorry, thought you were just having trouble teleneting to W2K server to run mysql or other exe's at command prompt. We ran into this because appartently W2K supports a different telnet that has to be started as a service before you can connect. Once it was running we had no problem coming into MySQL server. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: difference of two datetime values
On 16.02.2001 13:27:58 Vyacheslav Chukin wrote: Please, tell me, how could I determine, which one of two datetime values is greater? Date1 Date2 In other words, how could I determine, is stored on db datetime value in future or past? Past: DbDateTime NOW() Present: DbDateTime = NOW() Future: DbDateTime NOW() Before posting, please check: http://www.mysql.com/manual.php (the manual) ^^ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: show database does not work ;-(
On Fri, Feb 16, 2001 at 02:18:11PM +, Greg Cope wrote: Dear All I've just installed mysql on a new host (3.23.33) and show databases does not work ;-(. Maybe it would help to read (or search) the list before posting. There are several mails regarding this problem, among them a mail with subject 'Some problems encountered when linked to glibc-2.2.1'. It suggests a fix I believe. If the fix isn't clear, please repost your (new) question. I'm not running MySQL on Linux, but someone else will probably be able to help implement the fix then. Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
test
dear Sir : MySQL 3.22 on my linux 486 PC seems work so good. when I compile a simple C API programe which catched from the MySQL tutorial, it chokes at the end of compile process . the programe is as follows: #include stdio.h #include mysql.h #define def_host_name NULL #define def_user_name NULL #define def_password NULL #define def_db_name NULL MYSQL *conn; int main(int argc,char *argv[]) { conn=mysql_init(NULL); mysql_real_connect( conn, def_host_name, def_user_name, def_password, def_db_name, 0, /*port defaut*/ NULL, /*socket default*/ 0);/*flag*/ mysql_close(conn); exit(0); } I compile as follows: gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \ -L/home/MySQL/MySQL/lib \ -lmysqlclient then I get : /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x14):undefined reference to 'open64' /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format': mf_format.o(.text+0x201):undefined reference to '__lxstat64' /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open': my_open.o(.text+0x21):undefined reference to 'fopen64' nothing left to do with the situation, I beg your help. anyway I'm a newcomer. thank you very much. please send message to [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: show database does not work ;-(
Rick Roberts wrote: SHOW DATABASES; Sorry my subject line had the last S missing: mysql 010216 15:29:14 1 Query SHOW DATABASES SHOW DATABASES; +--+ | Database | +--+ | | | | | | | | | test | +--+ 5 rows in set (0.01 sec) Are you using 3.23.33 ? Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: transactions -- whole table locked from reads too?
Scott, did you try to do the insert and select on the same database page? In BDB there is page level locking used, and the behavior you describe sounds like that the insert has placed a page level lock on the page where you try to do the select. Then it is correct behavior of the database that your select has to wait until the commit which releases the locks placed by the insert. A possible solution would be to use 'dirty read', i.e., non-locking read in select, but I do not know if BDB provides such. My own Innobase table handler allows you to read and insert data concurrently with no interference from locks, because Innobase does in a select a consistent non-locking read, in the style of Oracle. But MySQL/Innobase is not available yet, it will come out in MySQL 3.23.3x in a few days (see my posting a couple of hours ago). Regards, Heikki Tuuri Innobase Oy Helsinki, Finland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DROP COLUMN
Werner, Your syntax is correct and valid for MySQL. The problem could lie with your ODBC driver. What version are you on? Try downloading a utility for administering MySQL. UrbSQL is good from www.urbanresearch.com and see if that can drop the column. Good luck. Andy Woolley www.databasewatch.com - Original Message - From: "Wernher Korff" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 16, 2001 2:40 PM Subject: DROP COLUMN hello list;) i have a SQL command to DROP a COLUMN from a mySQL database, the problem is that the syntax i am using doesnt seem to be the right syntax for mySQL, my statement currently read:"ALTER TABLE WorkGroups DROP COLUMN Personnel" and i get the error message: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Personnel'. please help me, tis urgent that it works soon thanx regards wernher - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Possible SHOW DATABASE || TABLE bug in 3.23.33
Description: SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e a nice list of blanks - no of blank lines equals number of databases / tables) How-To-Repeat: Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33 Fix: Submitter-Id: submitter ID Originator:Greg Cope Organization: organization of PR author (multiple lines) MySQL support: none Synopsis: SHOW command possiblxky broken in 3.23.33 Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.33 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux server1.totallyradio.com 2.2.17-14 #1 Mon Feb 5 18:48:50 EST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O3 -malign-double -ffast-math -funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro -fomit-frame-pointer' CXX='c++' CXXFLAGS='-O3 -malign-double -ffast-math -funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro -fomit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Feb 13 10:46 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101836 Jan 15 15:49 /lib/libc-2.1.3.so -rw-r--r--1 root root 20273324 Jan 15 15:49 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 15 15:49 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql-3.23.33 --enable-assembler --with-mysqld-ldflags=-all-static --with-mysqld-user=mysql --localstatedir=/var/lib/mysql --sysconfdir=/etc --with-extra-charsets=complex --datadir=/var/lib/mysql --localstatedir=/var/lib/mysql --infodir=/usr/info --mandir=/usr/man --without-debug --without-bench Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Display information
Hello all, I have a database with a little over 2000 records. I want to be able to construct a query that says something like this... select id,lot_id,lot_type from scrap_table starting with record 1932 (part I need help with) order by id limit 10; which should give me records 1932 - 1942 like this... +--+--+--+ | id | lot_id | lot_type | +--+--+--+ | 1942 | 0034906 | F| | 1941 | 0100308 | F| | 1940 | 0036309 | S| | 1939 | 0033503 | F| | 1938 | 0034108E | D| | 1937 | 0034712 | F| | 1936 | 0029404 | F| | 1935 | 0032706 | F| | 1934 | 0029404 | F| | 1933 | 0100307 | F| | 1932 | 0100404 | F| +--+--+--+ any suggestions? Ron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: show database does not work ;-(
Fred van Engen wrote: On Fri, Feb 16, 2001 at 02:18:11PM +, Greg Cope wrote: Dear All I've just installed mysql on a new host (3.23.33) and show databases does not work ;-(. Maybe it would help to read (or search) the list before posting. I have already searched the list, and it has not helped. There are several mails regarding this problem, among them a mail with subject 'Some problems encountered when linked to glibc-2.2.1'. It suggests a fix I believe. If the fix isn't clear, please repost your (new) question. I'm not running MySQL on Linux, but someone else will probably be able to help implement the fix then. I'm on glibc-2.1.3 I've narrowed this down to a difference between the mysqld binary. I just tried it on two near identical machines and there appears to be a bug bug. 3.23.32 works as expected - 3.23.33 does not - here at least. Greg Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Switching from 3.22.32 to 3.23.33. What about the database files?
Hello, can anyone tell me whether or not I have to convert the database files when switching from MySQL Version 3.22.32 to Version 3.23.33. I am working on SuSe Linux 6.4. Is it sufficient just to copy the database files? Thanks, Tobias. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: COUNT(DISTINCT Column_Name)
You can use: SELECT Column_Name, count(Column_Name) FROM Table_Name GROUP BY Column_Name -Original Message- From: Franz, Fa. PostDirekt MA [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 3:02 AM To: [EMAIL PROTECTED] Subject: COUNT(DISTINCT Column_Name) Hi Everybody , I am using MySql 3.22.32 on LINUX. My problem is , that 'SELECT COUNT(DISTINCT Column_Name) FROM Table_Name doesn't work like described in the HTML-manual (7.4.13) . It even doesn't work at all. Is tthat a bug , am I stupid , or is there any workaround. Greetings Klaus Besuchen Sie uns auch im Internet: http://www.postdirekt.de Diese Mail ist von: Deutsche Post Direkt GmbH Beleglese Center Mannheim Klaus Franz Manager Abgleichsysteme Willy-Brandt-Platz 13 Tel. 06 21.129 56 436 68161 Mannheim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Different behaviour between 3.22.32 and 3.23.32
Description: "SELECT MAX (record_id) FROM record;" iworks in 3.22.32 but fails in 3.23.32 In v3.22.32, both the following SQL commands work: mysql SELECT MAX (record_id) FROM record; +-+ | MAX (record_id) | +-+ | 3010001 | +-+ 1 row in set (0.03 sec) mysql SELECT MAX(record_id) FROM record; ++ | MAX(record_id) | ++ |3010001 | ++ 1 row in set (0.02 sec) But in v3.23.32 only one works: mysql SELECT MAX (record_id) FROM record; ERROR 1064: You have an error in your SQL syntax near '(record_id) FROM record' at line 1 mysql SELECT MAX(record_id) FROM record; ++ | MAX(record_id) | ++ |5040003 | ++ 1 row in set (0.00 sec) How-To-Repeat: As above Fix: Check all scripts and modify where required :-( Submitter-Id: adsb Originator:Andrew Benham Organization: Nortel Networks Plc -- Andrew Benham [EMAIL PROTECTED] Nortel Networks Plc, London Road, Harlow, Essex CM17 9NA, United Kingdom Tel: +44 1279 402372Fax: +44 1279 405746 I speak for myself, my views are not necessarily the views of Nortel Networks or any other corporation. MySQL support: none Synopsis: Change in SQL syntax happened Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.32 (Official MySQL binary) Environment: System: HP-UX wharh05g B.10.20 A 9000/785 2016207775 two-user license Some paths: /usr/bin/perl /usr/bin/make /opt/corp/unsupported/bin/gmake /opt/corp/unsupported/gcc-2.8.1/bin/gcc /usr/bin/cc GCC: Reading specs from /opt/corp/unsupported/gcc-2.8.1/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.8.1/specs gcc version 2.8.1 Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include -fomit-frame-pointer -O6 -fpic' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O6 ' LDFLAGS='' LIBC: -r-xr-xr-x 1 binbin1863680 Oct 8 1999 /lib/libc.1 -r--r--r-- 1 binbin2456372 Oct 8 1999 /lib/libc.a lrwxr-xr-x 1 root sys 15 Mar 21 2000 /lib/libc.sl - /usr/lib/libc.1 -r-xr-xr-x 1 binbin1863680 Oct 8 1999 /usr/lib/libc.1 -r--r--r-- 1 binbin2456372 Oct 8 1999 /usr/lib/libc.a lrwxr-xr-x 1 root sys 15 Mar 21 2000 /usr/lib/libc.sl - /usr/lib/libc.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-pthread --with-named-thread-libs=-ldce --disable-shared Perl: This is perl, version 5.004 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 errors during high activity
I know this has come up before, but I couldn't find a satisfactory solution. I'm running MySQL 3.23.23 on mandrake linux. It's used by a web site that has very high activity. During times of high activity, I find my perl scripts generating two kinds of errors: DBD::mysql::db selectrow_array failed: Lost connection to MySQL server during query at ... DBI-connect(games) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at The MySQL log does not errors. This happens both with Apache::DBI and plain DBI run at the command line. Does anyone have advice on getting rid of these errors? Thanks. -- -- smalltime industries brings you the latest in games, information, art, and interplanetary transport. Visit us at www.smalltime.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: Possible SHOW DATABASE || TABLE bug in 3.23.33
Greg Cope writes: Description: SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e a nice list of blanks - no of blank lines equals number of databases / tables) How-To-Repeat: Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33 Fix: Submitter-Id: submitter ID Originator:Greg Cope Organization: organization of PR author (multiple lines) MySQL support: none Synopsis: SHOW command possiblxky broken in 3.23.33 Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.33 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux server1.totallyradio.com 2.2.17-14 #1 Mon Feb 5 18:48:50 EST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O3 -malign-double -ffast-math -funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro -fomit-frame-pointer' CXX='c++' CXXFLAGS='-O3 -malign-double -ffast-math -funroll-all-loops -fno-rtti -fno-exceptions -march=pentiumpro -fomit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Feb 13 10:46 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101836 Jan 15 15:49 /lib/libc-2.1.3.so -rw-r--r--1 root root 20273324 Jan 15 15:49 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 15 15:49 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql-3.23.33 --enable-assembler --with-mysqld-ldflags=-all-static --with-mysqld-user=mysql --localstatedir=/var/lib/mysql --sysconfdir=/etc --with-extra-charsets=complex --datadir=/var/lib/mysql --localstatedir=/var/lib/mysql --infodir=/usr/info --mandir=/usr/man --without-debug --without-bench Perl: This is perl, version 5.005_03 built for i386-linux Hi! As there are so many reports, we shall investigate a problem. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Display information
select id,lot_id,lot_type from scrap_table where id = 1932 order by id limit 10; select id,lot_id,lot_type from scrap_table order by id limit 1932,10; either should work, i think the first would be faster but I'm not positive how MySQL would handle the second in terms of optimization. -jm -Original Message- From: Ron Beck [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 8:23 AM To: [EMAIL PROTECTED] Subject: Display information Hello all, I have a database with a little over 2000 records. I want to be able to construct a query that says something like this... select id,lot_id,lot_type from scrap_table starting with record 1932 (part I need help with) order by id limit 10; which should give me records 1932 - 1942 like this... +--+--+--+ | id | lot_id | lot_type | +--+--+--+ | 1942 | 0034906 | F| | 1941 | 0100308 | F| | 1940 | 0036309 | S| | 1939 | 0033503 | F| | 1938 | 0034108E | D| | 1937 | 0034712 | F| | 1936 | 0029404 | F| | 1935 | 0032706 | F| | 1934 | 0029404 | F| | 1933 | 0100307 | F| | 1932 | 0100404 | F| +--+--+--+ any suggestions? Ron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 CRM
Does anybody know of any commercial or opensource CRM systems that run with MySQL on Linux (and/or FreeBSD)? Mainly I need canned responses and ticket management and some other standard features. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Display information
select id,lot_id,lot_type from scrap_table starting with record 1932 (part I need help with) order by id limit 10; which should give me records 1932 - 1942 like this... +--+--+--+ | id | lot_id | lot_type | +--+--+--+ | 1942 | 0034906 | F| | 1941 | 0100308 | F| | 1940 | 0036309 | S| | 1939 | 0033503 | F| | 1938 | 0034108E | D| | 1937 | 0034712 | F| | 1936 | 0029404 | F| | 1935 | 0032706 | F| | 1934 | 0029404 | F| | 1933 | 0100307 | F| | 1932 | 0100404 | F| +--+--+--+ If you simply needed the exact result here's the query SELECT id,lot_id,lot_type FROM scrap_table WHERE id BETWEEN 1932 AND 1942 ORDER BY id DESC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: There are no DB defined space limits on MySQL Databases ?
On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote: There are no DB defined space limits on MySQL Databases ?It's dangerours .How to control the database space on my database user? Filesystem quotas. -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: show database does not work ;-(
Rick Roberts wrote: mysql select version(); +---+ | version() | +---+ | 3.23.33 | +---+ 1 row in set (0.01 sec) mysql SHOW DATABASES; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.02 sec) I'm using Mandrake 7.2. I installed using the RPM MySQL-3.23.33-1.i386.rpm Thanks Not much help to me mind ... Thanks again ;-( Greg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Switching from 3.22.32 to 3.23.33. What about the database files?
Tobias - You can continue to use the ISAM format or convert to the new MYISAM format (and other formats such as HEAP, I believe). See the 'mysql_convert_table_format' script in the bin directory. -karl Tobias Wolff wrote: Hello, can anyone tell me whether or not I have to convert the database files when switching from MySQL Version 3.22.32 to Version 3.23.33. I am working on SuSe Linux 6.4. Is it sufficient just to copy the database files? Thanks, Tobias. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
interesting problem
I have a form on a webpage for a simple trouble ticket system. When requesting a computer be fixed, software be installed, etc...a faculty member can go to this website and type in the info via an HTML form. My problem is, the form needs to be submitted to two different tables. All of the faculty info(name, email, etc) goes into a faculty table. The actual description of the request goes into a request table. But I also need to insert the unique id that is given to the faculty member in the faculty table INTO the request table. Because this is how I've related the two tables. In the request table I have a foreign key(called requested_by) that is the primary key of the faculty table. Is it possible for me to get the primary key of the faculty table and insert it into the request table through the same HTML form? Thanks, chriz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Display information
Hello all again. I think I need to be a little more specific in describing my problem. So, let me try again. I have a database of scrap records. There are currently over 2000 records in this database. I have a web page that queries this database and displays the records in reverse order, newest to oldest. I use this query to do that... SELECT id,lot_id,lot_type FROM scrap_table ORDER BY id DESC LIMIT 0,10 which displays the last 10 records. If I want the next 10 records, I change the limit statement to look like this... LIMIT 10,10 which starts at the 10th record recovered and displays another 10, again from newest to oldest. I have a button on my web page that increments the number of records (LIMIT ##,10) with each click on the "Pg Up" or "Pg Dn" button. Now, I don't want to page through eight or nine pages to get down to the record I'm looking for. I want to generate a query to display a range of 10 records starting with my entry. Now, the following query will work... SELECT id,lot FROM scrap_table WHERE id =1880 and id = 1890 ORDER BY id desc; but I don't always have the starting record number to work with. Now, the following suggestion seemed promising... SELECT id,lot_id,lot_type FROM scrap_table ORDER BY id limit 1932,10; seemed promising but it put them in oldest-to-newest order (ascending), not newest-to-oldest order (desc). When the "desc" qualifier was added, I got records 122 thru 113. Again, not exactly what I was looking for. What I was actually hoping for was something I could add to my original SELECT statement to perform the task if someone entered the ID but would show all (limit 10) if there was no entry. And, I wanted to do it without rewriting my code. Unfortunately, it looks like I may have to do a code rewrite for that section, which means documenting, testing, acceptance... Anyway, thanks for all the suggestions Ron suggestions vie email * select id,lot_id,lot_type from scrap_table where id = 1932 order by id limit 10; select id,lot_id,lot_type from scrap_table order by id limit 1932,10; either should work, i think the first would be faster but I'm not positive how MySQL would handle the second in terms of optimization. -jm ** If you simply needed the exact result here's the query SELECT id,lot_id,lot_type FROM scrap_table WHERE id BETWEEN 1932 AND 1942 ORDER BY id DESC ** isn't it as simple as... select id,lot_id,lot_type from scrap_table where id = 1932 and id = 1942 order by id limit 10; ? cheers, P *** Have a look in the manual, it says LIMIT [offset], rows, so you should say: order by id limit 1932, 10; - Before posting, please check: http://www.mysql.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
Re: MySQL CRM
On Fri, 16 Feb 2001, Steve Ruby wrote: Does anybody know of any commercial or opensource CRM systems that run with MySQL on Linux (and/or FreeBSD)? Mainly I need canned responses and ticket management and some other standard features. Have a look at http://freshmeat.net/, where most of the OSC software is announced anyway. Regards, Jan-Aage -- Mr. Jan-Aage Bruvoll Managing Director Bruvoll Brains in Bits, 7a Neal's Yard, London WC2H 9DP, UK Office: +442072408283 Cell: +4792492482 Fax: +4792571158 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: taxes
Ran into an interesting twist on "presence" in a state. One client went to a trade show in Nevada. She was informed that for the next quarter she would have to consider herself "in" Nevada, even though she did not sell anyting at the show. I don't think she is going back. On Thu, 15 Feb 2001, Mike Wexler wrote: Date: Thu, 15 Feb 2001 14:03:33 -0800 From: Mike Wexler [EMAIL PROTECTED] To: Mikel King [EMAIL PROTECTED] Cc: Brady Orand [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: taxes Mikel King wrote: guys I think you are making this a way bigger problem than it really is...e-merce crap is generally taxed based on the location of the vendor; much the same way in which mail order businesses are taxed. You really only have to worry about the state/locality in which you are incorperated/operate from, and in many cases this only applies to transactions that occur within those bounds. Meaning that both the vendor and the customer are in the same state. Really this is a matter for the bean counters, but thus far I've yet to buy anything even from Amazon that I have to pay tax on unless they are in my state. Actually it gets complicated for two reasons. On the web site I run http://www.tias.com/ we have vendors in all 50 states. Second, if you have a business presence in the state the customer is located in, then you need to calculate the tax for *their* locality. So in the normal case where you are calculating the taxes for just 1 vendors. Who has only one location, then things can be simplified by dealing with only the rules of the state (and the localities within the state). cheers, mikel Mike Wexler wrote: Actually its even more complicated than this. There are city taxes and other taxes on other boundaries. In addition the rules as far as what things are taxable vary by locality. For example, some localities charge taxes on shipping and others don't. Brady Orand wrote: This is not as easy (conceptually) as it sounds. You have to know the current state tax plus any county taxes applicable. If you set up a table with this information, you can cross reference the location of the buyer with the table, calculate the appropriate taxes, and charge them accordingly. You must also make sure to record the taxes that were paid so they can be paid to the appropriate tax agency. Not an easy task. There are sources out there for all of this information and you can get tax tables on a CD that can be imported. Brady... Original Message Follows From: Mikel King [EMAIL PROTECTED] To: LDL Enterprise [EMAIL PROTECTED] CC: *MySQL mail list [EMAIL PROTECTED] Subject: Re: taxes Date: Wed, 14 Feb 2001 16:57:35 -0500 Wound't you just set a table with an id, state_abrev, tax columns. Then the id column will match the selection...et cettera...capisce LDL Enterprise wrote: does anyone know how to calculateg taxes for a shop cart that would set the tax depending on the state that they select when filling out their contact information? Thanks. _ ___ | | | \ | | | |__ | | || |__ |||___/ || Larry L. [EMAIL PROTECTED] www.ldlenterprise.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 _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Before posting, please check:
EXPLAIN output wierdness?
I have a concern regarding how an index is being used for a query. I've included the query (minus the fields) and the EXPLAIN output below. I'm curious why MySQL would indicate that it's using filesort for table 'd' since it's type is 'const.' The documentation indicates this means that only one row matched (which is true) and that it will use the fields from that table as constants through the rest of the query. Is this normal? The query is fast, but I want to make absolutely certain that it is perfectly optimized. select ...somefields... from thread a, user b, user c, forum d where d.forum_id=1 and a.forum_id=d.forum_id and a.forum_id = 1 and a.owner_id = b.user_id and a.reply_id = c.user_id order by modified desc limit 140,140 Here's the output of EXPLAIN: +---++-+-+-++--- ---++ | table | type | possible_keys | key | key_len | ref| rows | Extra | +---++-+-+-++--- ---++ | d | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort | | a | range | forumupdate | forumupdate | 4 | NULL | 849 | where used | | b | eq_ref | PRIMARY,user_id | PRIMARY | 4 | a.owner_id | 1 | where used | | c | eq_ref | PRIMARY,user_id | PRIMARY | 4 | a.reply_id | 1 | where used | +---++-+-+-++--- ---++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: There are no DB defined space limits on MySQL Databases ?
--- Brian Reichert [EMAIL PROTECTED] wrote: On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote: There are no DB defined space limits on MySQL Databases ?It's dangerours .How to control the database space on my database user? Filesystem quotas. But, to define filesystem quota, I will need to change de Owner of the file to the name of the respecive user right? Example: if the table belong to user max, I'll: chown max.users *.ISM Right?? []'s Fox W. Mulder __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JDBC question?
Had similar problem, get the current version of the driver. On Fri, 16 Feb 2001, Chen Ka Pong wrote: Date: Fri, 16 Feb 2001 20:29:27 +0800 From: Chen Ka Pong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: JDBC question? I cannot use the jdbc connection which the driver is download from mysql web site. The error message prompted that "invalid JDBC Driver", what can cause this error? I predict my classpath is wrong, but I would like to know how to set the classpath? (at this status, I am not sure if my classpath is correct or not) Thanks! Pong Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Please Help me ..Apache_1.3.17+php-3.0.16+mysql-3.23.32
I can't to compile this I'm getting the following error on my gmake (most snipped for brevity). gcc -DSOLARIS2=280 -DUSE_HSREGEX -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED -I/usr/local/include -I/usr/local/include/mysql `./apaci` -L/usr/local/lib -R/usr/local/lib \ -o httpd buildmark.o modules.o modules/php3/libphp3.a modules/standard/libstandard.a main/libmain.a ./os/unix/libos.a ap/libap.a regex/libregex.a lib/expat-lite/libexpat.a -R/usr/local/lib/mysql -L/usr/local/lib/mysql -Lmodules/php3 -L../modules/php3 -L../../modules/php3 -lmodphp3-lpam -lm -ldl -lsocket -lnsl -lresolv -lsocket -lnsl Undefined first referenced symbol in file mysql_get_client_info modules/php3/libphp3.a(mysql.o) mysql_drop_db modules/php3/libphp3.a(mysql.o) mysql_close modules/php3/libphp3.a(mysql.o) mysql_fetch_lengths modules/php3/libphp3.a(mysql.o) mysql_free_result modules/php3/libphp3.a(mysql.o) mysql_create_db modules/php3/libphp3.a(mysql.o) mysql_field_seekmodules/php3/libphp3.a(mysql.o) mysql_list_fields modules/php3/libphp3.a(mysql.o) mysql_fetch_row modules/php3/libphp3.a(mysql.o) mysql_real_querymodules/php3/libphp3.a(mysql.o) mysql_real_connect modules/php3/libphp3.a(mysql.o) mysql_stat modules/php3/libphp3.a(mysql.o) mysql_fetch_field modules/php3/libphp3.a(mysql.o) mysql_list_dbs modules/php3/libphp3.a(mysql.o) mysql_select_db modules/php3/libphp3.a(mysql.o) mysql_store_result modules/php3/libphp3.a(mysql.o) mysql_list_tables modules/php3/libphp3.a(mysql.o) mysql_data_seek modules/php3/libphp3.a(mysql.o) mysql_init modules/php3/libphp3.a(mysql.o) ld: fatal: Symbol referencing errors. No output written to httpd collect2: ld returned 1 exit status make[2]: *** [target_static] Error 1 make[2]: Leaving directory `/scratch/webdev/apache_1.3.12/src' make[1]: *** [build-std] Error 2 make[1]: Leaving directory `/scratch/webdev/apache_1.3.12' make: *** [build] Error 2 Thanks. Fabian Gonzalo [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
Perl DBI
Is it possible to connect to mysql without connecting directly to a database, check to see if a particular database exists, and if it doesn't exist create it? I have not been able to find a way of connecting to mysql without having a database already (I want perl to be able to make the db.. not have it already made before hand.) tia John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Still about libmysqlclient.a?
Hi, There is a mistake and my last question. I am asking about libmysqlclient.a, not libmysql.a. And this is the case: I am using Perl's MySQL module which upon installation always asks me where libmysqlclient.a or libmysqlclient.so is. So, I guess even Windows users need those too. In order to get libmysqlclient.a, I tried to compile MySQL source distribution, but it failed detecting my OS during configure and exited with a message: "Could not find the right ps switches. Which OS is this?" I am using Cygwin gcc. Does anybody know how to work around my problem? Note: config.log attached Thanks. ~Agus~ Hi! On Windows you should use libmysql.lib instead. You find it at /lib/opt directory. Regards, Miguel I installed MySQL 3.23.32 binary distribution for Windows. I can't find libmysql.a in the lib directory. Where is it? Can anybody send me one? --- ~Agus~ Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Different behaviour between 3.22.32 and 3.23.32
Description: "SELECT MAX (record_id) FROM record;" iworks in 3.22.32 but fails in 3.23.32 Well, that shouldn't really come as a surprise. The manual specifically says (Section "Functions for use in SELECT and WHERE clauses): Note: There must be no whitespace between a function name and the parenthesis following it. This helps the MySQL parser distinguish between function calls and references to tables or columns that happen to have the same name as a function. Spaces around arguments are permitted, though. You may be running your 3.22 version in ANSI mode, this would explain the seemingly strange behaviour. Or it may be, that the behaviour changed between 3.22 and 3.23, to allow for dramatic increase in the number of functions that were added. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JDBC question
I am , well I will have to wioork with oracle and jdeveloper, can some of you please please please telll me where canI find examples of conections to a database an oracle databse and if I use php again eh the same question where can I see examples of conections to an oralce data base using php... information about jdeveloper... and oracle , perhaps a user group, a mailling list... is jdeveloper hard to use? are jdevelopers graphical interfaces easy to understand? I am not a java programmer so I must ask how easy may jdeveloper be I only need to stablish conectivity to an oracle database, buid the interfaces for consulting the data base and adding datas to it... well thanks a lot inadvance, cheers On Fri, 16 Feb 2001, William R. Mussatto wrote: Date: Fri, 16 Feb 2001 10:48:57 -0800 (PST) From: William R. Mussatto [EMAIL PROTECTED] To: Chen Ka Pong [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: JDBC question? Had similar problem, get the current version of the driver. On Fri, 16 Feb 2001, Chen Ka Pong wrote: Date: Fri, 16 Feb 2001 20:29:27 +0800 From: Chen Ka Pong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: JDBC question? I cannot use the jdbc connection which the driver is download from mysql web site. The error message prompted that "invalid JDBC Driver", what can cause this error? I predict my classpath is wrong, but I would like to know how to set the classpath? (at this status, I am not sure if my classpath is correct or not) Thanks! Pong Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Perl DBI
Connect to the mysql database if you have access. It always exists. - Original Message - From: "John Tsangaris" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 16, 2001 1:58 PM Subject: Perl DBI Is it possible to connect to mysql without connecting directly to a database, check to see if a particular database exists, and if it doesn't exist create it? I have not been able to find a way of connecting to mysql without having a database already (I want perl to be able to make the db.. not have it already made before hand.) tia John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
MySQLGUI
Hi, I just started looking at the MySQLGUI tool in depth yesterday. I have one question for now. I'm able to save queries via the "Save Query" button but I don't see any facility to load the query back in from a file. Is this functionality missing or hidden? I've examined all the readme's and didn't see any reference to this functionality. Thanks, Shawn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQl with SSH
Hi, How can I configure MySQL to utilize the SSH package for encrypted TCP/IP connection between MySQL clients and server? Thanks in advance. Kuokai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Perl DBI
Hi, Eric. What I'm trying to do is have my install program check to see if a database of a certain name exists, if it does then the install needs to create another one (using a name given by the user), if not then it needs to create it with the original name. But I cannot figure out how to connect to mysql without already having a database setup. I'll use dbtemp as an example db. I can try to connect to dbtemp and if it successful, I know it exists. So I prompt the user to enter another db name. I can then check if this exists and if it doesn't I can use the dbi to create the new db WHILE I am still connected to dbtemp. If dbtemp does not exist I need to create it. The problem is dbi needs to connect to a database even to create another one. So what/how do I connect to initially to create that first database? I realize, for geeks (myself included), that you could simply create the db manually and then install the program.. but the program is to be usable by the layperson.. which means that there is a chance they don't know anything about mysql other than the guy on tech support said it's installed on the server. How do I connect to mysql without connecting to a database? John -Original Message- From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 1:21 PM To: John Tsangaris; [EMAIL PROTECTED] Subject: Re: Perl DBI Connect to the mysql database if you have access. It always exists. - Original Message - From: "John Tsangaris" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 16, 2001 1:58 PM Subject: Perl DBI Is it possible to connect to mysql without connecting directly to a database, check to see if a particular database exists, and if it doesn't exist create it? I have not been able to find a way of connecting to mysql without having a database already (I want perl to be able to make the db.. not have it already made before hand.) tia John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: setting key_buffer_size correctly
Hi. On Fri, Feb 16, 2001 at 03:05:35AM -0500, [EMAIL PROTECTED] wrote: Hello, I have a large database with a lot of queries and was trying to tune MySQL to get the best performance. I was reading the manuals and it said to set the key_buffer_size to the best value, you take the first two of the following values and divide by each other. I believe it said you should get less then 1%. I was not able to figure out what the best setting for me to be using was, so I am looking for help. Here are the values: | Key_read_requests| 2983998650 | | Key_reads| 2139560| This gets you less than 0.1%, i.e. good. | Key_write_requests | 744067782 | | Key_writes | 351704288 | The machine has 2 gigs of ram and currently the key_buffer_size is set to 800M. I was wondering if I should increase or decrease the value to get the best performance gain. Have a look at the status of Key_blocks_used. If it is far below the value of your key_buffer setting (regarding a key block has 1024 bytes), you want to decrease it (to let more memory for OS file system caching). Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compile error
Hello Running gcc 2.95.2 and gnumake 3.39. Attempting to build mysql v3.23.32 or v3.23.33. Getting error, during make sql_string.cc: In Method 'bool String::(double,unsigned int=2)': sql_string.cc:181 Implicit declaration of function 'int snprintf(...)' Running on an Alpha Tru64 V4.x Any insight would be greatly appreciated. Thank You John Markunas Williams College - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Index not used for order by when more than 1 field selected, no where clause
Hi. On Fri, Feb 16, 2001 at 09:42:02AM +0100, [EMAIL PROTECTED] wrote: Benjamin Pflugmann wrote : [...] "Second" is never the best way. MySQL uses "First" up to some percentage of the amount of records (30% I believe), then uses "Third", because reading the data in file order (unsorted) and sorting is usually faster than random seeks (due to index usage) over that percentage of records. [...] Sorry to jump in the middle of this thread but your comment make me think of a case where random seeks may still be better even if more than 30% of records are involved: You are completely right. That's why I said "usually" above. But it shouldn't make a too big difference generally. In the original problem, the speed difference was so huge, because MySQL could avoid reading the data file at all in one case. When you set up your database server so that it has enough RAM to keep the whole database in main memory (buffer cache), random reads don't need to wait for physical disk seeks and can be very fast. [...] So my question is: Is it a way to tune this threshold ? AFAIK, currently the only way is to change it within the source and recompile MySQL. Bye, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyODBC and JDBC Bridge Driver
Sorry people, I' ve some bad problems to run mysql with the Java JDBC ODBC Bridge Driver under Win89. Perhaps only a question of syntax, perhaps an internal Error, perhaps... I tried out lots of possibilities, but in the end the error of finding a nonexistant database was the closest thing of success, that is: it accepted the myodbc.dll but refused a connection because not finding the database I described. Is there anyone in the web who got a solution or suffers at the same problem. Please send me a mail. Thanks Thommy Thomas Krause Schellingstr.124 80798 München Tel.: 089/54212278
CREATE from a mysqldump won't CREATE a table in 3.23?
The following CREATE TABLE came from a mysqldump. When I use the same create statement to create the table under mysql 3.23 I get an error: # MySQL dump 8.12 # # Host: localhostDatabase: installers # # Server version3.23.32-log # # Table structure for table 'versions' # CREATE TABLE versions ( file_id int(9) NOT NULL auto_increment, languagecode varchar(10) NOT NULL default 'en', product varchar(100) NOT NULL default '', platform enum('WIN','MAC','LINUX','PALM') NOT NULL default 'WIN', version_num varchar(25) NOT NULL default '', type enum('BETA','RELEASE') NOT NULL default 'BETA', mode enum('PAY','FREE','AD','ALL') NOT NULL default 'PAY', date date default NULL, size int(9) default NULL, expires date default NULL, contact_info varchar(255) default NULL, ARL varchar(255) default NULL, URL varchar(255) default NULL, readme varchar(255) default NULL, relnotes varchar(255) default NULL, whatsnew varchar(255) default NULL, note_1 varchar(255) default NULL, note_2 varchar(255) default NULL, note_3 varchar(255) default NULL, note_4 varchar(255) default NULL, note_5 varchar(255) default NULL, patchURL varchar(255) default NULL, patchURLname varchar(255) default NULL, patchsize int(9) default NULL, patchnote_1 varchar(255) default NULL, patchnote_2 varchar(255) default NULL, manualURL varchar(255) default NULL, manualURLname varchar(255) default NULL, manualsize int(9) default NULL, manualnote_1 varchar(255) default NULL, manualnote_2 varchar(255) default NULL, PRIMARY KEY (file_id), KEY version(product,platform,version_num) ) TYPE=MyISAM; ERROR 1064 at line 11: You have an error in your SQL syntax near 'version(product,platform,version_num) ) TYPE=MyISAM' at line 34 What gives and is this a bug? How can it REJECT something it gave me as a mysqldump? Curious, isn't it? I believe this is a bug. Thanks for any info, Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
varchar and sql92
Hi, I am writing a program to do queries on a lot of different databases. I have run into something with varchar I didn't expect. With mySQL varchar is limited to 255 with postgress it is unlimited it seems. I only know because it seems to work, not because their stupid documentation told me, that you can have any length varchar. For instance I have a varchar 4000 in a postgress database. My question is, how standard is mySQL being by limiting varchar to 255 ? I will have to make some provision for this because I want my queries to work with postgress as well, but I wondered too if I should look into other issues like this with lengths of fields? Thanks, Eric Frazier Consulting http://www.kwinternet.com/eric (250) 655 - 9513 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting up Access 2000 to work using a mySQL db...
Kentj, I have a setup that differs in just a few ways. My server is Redhat7 Linux, on the Internet. It appears from the IP address that you gave, that yours in on an intranet. Judging by a lot of messages I have seen here, and by my own experience, a similar connection on the Internet is far less reliable, even if correctly configured. Access97 appears to be less of a problem, but I solved my problem by eliminating Access and using PhpMyAdmin. On 15 Feb 2001, at 14:35, kentj wrote: I have an Access 2000 Db on a Win98 system with tables linked to a MySql23.32-1 database on Suse Linux 7.0 using the latest MyODBC with a System DSN specifying anyname.dsn, the IP of 192.168.2.5 for the host, the database name of "metrics" and port 3306. I had to setup the privileges very carefully in the MySQL user table and to spell my database name correctly in order to make it work. Rodrigo Antonio Reyes Cabrera wrote: Hi I am using Access 2000 and I would like to configure it in order to use it as a interface to a mySQL db. Is this possible? I think it is, but I haven't been able to get it done so far. I am using the myODBC driver, but I get error messages when I try to import or link a table from my db into Access. Nevertheless, I can connect from PHP using the same ODBC connection. What could be wrong? Rodrigo - Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MyODBC Prompt on connect
Yes, Pay attention to the large number of problems mentioned regarding MyODBC connections, on this list. Also note that I am not the only one who keeps saying to use PhpMyAdmin. It is simply a better solution. On 15 Feb 2001, at 20:44, Juan Suris wrote: I've setup MyODBC (Win98) so I can access a MySQL db from Excel. It works fine, except that everytime I refresh the data, I get the MyODBC prompt, even when I select the option "Don't Prompt on Connect". This is kind of anoying, as I need to execute well over 700 queries. Anybody have any ideas? Thanks, JuanE -- http://FWDer.com -- FWD your way to a fun and SPAM-free mailbox. Unlimited email addresses at your domain yourname.FWDer.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 John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Try installing mySQL. Please help me out with these questions: 1) I am running RedHat 6.0 on a x86 machine. The file I downloaded was 'Linux (Intel libc6 systems) [pc-linux-gnu-i686]'. Is it the right one? 2) 'Linux (Intel libc6 systems) [pc-linux-gnu-i686]' seems to be the binary distribution because I don't see any make files after untar it. Is that right? 3) I treated it as a binary, and followed the instruction for binary installation. Then this command line puzzles me: shell bin/safe_mysqld --user=mysql the double dashes may not be right. What is that? Have a nice weekend. I come back next Monday hoping to get a good answer from you. Thanks. Kelly - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Perl DBI
Here is what I would do. There is always a database on every mysql installation called "mysql" This database is where your permissions tables and such are stored. Connect initially to that database. Then, try to create the new database. If you get an error back, prompt the user, rinse and repeat. Your connection string should look something like this: $dbh = DBI-connect('DBI:mysql:mysql;host=somehost','someuser','somepassword'); Of coarse, you could always connect to the mysql database and get a list of databases, and not have to expect an error back from mysql on connection... - Original Message - From: "John Tsangaris" [EMAIL PROTECTED] To: "Eric Fitzgerald" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, February 16, 2001 4:46 PM Subject: RE: Perl DBI Hi, Eric. What I'm trying to do is have my install program check to see if a database of a certain name exists, if it does then the install needs to create another one (using a name given by the user), if not then it needs to create it with the original name. But I cannot figure out how to connect to mysql without already having a database setup. I'll use dbtemp as an example db. I can try to connect to dbtemp and if it successful, I know it exists. So I prompt the user to enter another db name. I can then check if this exists and if it doesn't I can use the dbi to create the new db WHILE I am still connected to dbtemp. If dbtemp does not exist I need to create it. The problem is dbi needs to connect to a database even to create another one. So what/how do I connect to initially to create that first database? I realize, for geeks (myself included), that you could simply create the db manually and then install the program.. but the program is to be usable by the layperson.. which means that there is a chance they don't know anything about mysql other than the guy on tech support said it's installed on the server. How do I connect to mysql without connecting to a database? John -Original Message- From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 1:21 PM To: John Tsangaris; [EMAIL PROTECTED] Subject: Re: Perl DBI Connect to the mysql database if you have access. It always exists. - Original Message - From: "John Tsangaris" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 16, 2001 1:58 PM Subject: Perl DBI Is it possible to connect to mysql without connecting directly to a database, check to see if a particular database exists, and if it doesn't exist create it? I have not been able to find a way of connecting to mysql without having a database already (I want perl to be able to make the db.. not have it already made before hand.) tia John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ranking album plays by city, help me beat Oracle
This is the latest approach we're using now. It turns out that the query to get Total Plays for an Album per City can be taken out of the City for loop done only once as a GROUP BY. The worst case time for MySQL is now 16 seconds compared to Oracle's 8 seconds. On most cases MySQL is now faster than Oracle but once in a while it's slower. $query = "SELECT metro, sum(td_num) FROM album_by_metro WHERE same_album_id = $album AND rpt_dt = '$BeginDate' AND rpt_dt = '$EndDate' GROUP BY metro"; $start = time(); $result = mysql_query($query) or die ("Can't get $query" . mysql_error()); while ($row = mysql_fetch_array($result)) { $metro = $row[0]; $metros[] = $metro; $V_SUMS[$metro] = $row[1]; } // while mysql_free_result($result); // foreach ($metros as $metro) { $V_SUM = $V_SUMS[$metro]; $query = "SELECT same_album_id, SUM(td_num) FROM album_by_metro WHERE metro = '$metro' AND rpt_dt = '$BeginDate' AND rpt_dt = '$EndDate' GROUP BY same_album_id HAVING SUM(td_num) $V_SUM"; $result = mysql_query($query, $connection); if ($result) $rank = mysql_num_rows($result)+1; else $rank = 0; $ranks[$metro] = $rank; } Below is everything you asked for except the Oracle stored procedure which I can't send. thanks for your help, - Sam. mysql describe album_by_metro; +---+--+--+-++---+-- + | Field | Type | Null | Key | Default| Extra | Privileges | +---+--+--+-++---+-- + | rpt_dt| date | | MUL | -00-00 | | select,insert ,update | | region| varchar(50) | | || | select,insert ,update | | metro | varchar(100) | | MUL || | select,insert ,update | | same_album_id | int(11) | | MUL | 0 | | select,insert ,update | | td_num| int(11) | | | 0 | | select,insert ,update | mysql EXPLAIN SELECT same_album_id, SUM(td_num) FROM album_by_metro WHERE metro = 'Atlanta' AND rpt_dt = '2001-01-01' AND rpt_dt = '2001-02-14' GROUP BY same_album_id HAVING SUM(td_num) 500 mysql show index from album_by_metro; +++-+--+ ---+---+-+--++-+ | Table | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +++-+--+ ---+---+-+--++-+ | album_by_metro | 1 | rpt_dt |1 | rpt_dt | A |NULL | NULL | NULL | | | album_by_metro | 1 | rpt_dt |2 | region | A |NULL | NULL | NULL | | | album_by_metro | 1 | rpt_dt |3 | metro | A |NULL | NULL | NULL | | | album_by_metro | 1 | rpt_dt |4 | same_album_ id | A |NULL | NULL | NULL | | | album_by_metro | 1 | rpt_dt |5 | td_num | A |NULL | NULL | NULL | | | album_by_metro | 1 | album_by_metro_idx2 |1 | metro | A |NULL | NULL | NULL | | | album_by_metro | 1 | album_by_metro_idx2 |2 | rpt_dt | A |NULL | NULL | NULL | | | album_by_metro | 1 | album_by_metro_idx1 |1 | same_album_ id | A |NULL | NULL | NULL | | | album_by_metro | 1 | album_by_metro_idx1 |2 | rpt_dt | A |NULL | NULL | NULL | | +++-+--+ ---+---+-+--++-+ Benjamin Pflugmann [EMAIL PROTECTED] wrote: Hi. On Thu, Feb 15, 2001 at 09:25:56PM -0800, [EMAIL PROTECTED] wrote: Could you please post the result of "EXPLAIN" for both queries and "SHOW INDEX FROM album_by_city". I haven't used EXPLAIN before. Just put it before the SELECT in your query. I don't know whether this will work directly in your program (php?), you can do it another way, too. Let's take your first query: SELECT SUM(total_plays) FROM album_by_city WHERE album_id = $album_id AND city = $this_city AND date = $StartDate AND date = $EndDate; You have to replace all variables by some real values. (best if you simply put an additional echo in your php(?) program). Assume $album_id=10, $this_city="New York", $StartDate="2001-01-01" and $EndDate="2001-02-14" would be valid values (replace them by
Re: Compile error
Actually the function is called sprintf() rather than snprintf(), to the best of my recollection, and it's probably defined in either stdio.h/stdlib.h or string.h. Change snprintf to sprintf() and see what happens. - Original Message - From: "John Markunas" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 16, 2001 1:53 PM Subject: Compile error Hello Running gcc 2.95.2 and gnumake 3.39. Attempting to build mysql v3.23.32 or v3.23.33. Getting error, during make sql_string.cc: In Method 'bool String::(double,unsigned int=2)': sql_string.cc:181 Implicit declaration of function 'int snprintf(...)' Running on an Alpha Tru64 V4.x Any insight would be greatly appreciated. Thank You John Markunas Williams College - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: varchar and sql92
db2 is limited to 255. On Fri, 16 Feb 2001, Eric Frazier wrote: Date: Fri, 16 Feb 2001 14:13:00 -0800 From: Eric Frazier [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: varchar and sql92 Hi, I am writing a program to do queries on a lot of different databases. I have run into something with varchar I didn't expect. With mySQL varchar is limited to 255 with postgress it is unlimited it seems. I only know because it seems to work, not because their stupid documentation told me, that you can have any length varchar. For instance I have a varchar 4000 in a postgress database. My question is, how standard is mySQL being by limiting varchar to 255 ? I will have to make some provision for this because I want my queries to work with postgress as well, but I wondered too if I should look into other issues like this with lengths of fields? Thanks, Eric Frazier Consulting http://www.kwinternet.com/eric (250) 655 - 9513 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQl with SSH
On Fri, Feb 16, 2001 at 05:31:54AM -0800, Kuokai Shyu wrote: How can I configure MySQL to utilize the SSH package for encrypted TCP/IP connection between MySQL clients and server? Thanks in advance. What I do is setup port-forwarding. I forward a local port (say 12345) to port 3306 on the database server via an SSH connection: ssh -f -L 12345:server.foo.com:3306 sleep 9 (or something relatively similar) Then I just tell the client to connect to localhost on port 12345. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Conversion
I'm looking for a way to translate a database in ASCII form throw a MySQL database. Could you tell me how to do and if there is a special software to do it. Tank you Ragrads - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
On Fri, 16 Feb 2001, Kelly Zhu wrote: Try installing mySQL. Please help me out with these questions: 1) I am running RedHat 6.0 on a x86 machine. The file I downloaded was 'Linux (Intel libc6 systems) [pc-linux-gnu-i686]'. Is it the right one? Yes Youare right. beware of 386, 586, or 686 2) 'Linux (Intel libc6 systems) [pc-linux-gnu-i686]' seems to be the binary distribution because I don't see any make files after untar it. Is that right? you can copy to the right destination directory. It will be easy, if you download the rpm package such as MySQL-3.23.33-1.386.rpm, MySQL-client-3.23.33-1.386.rpm. you can execute: $ rpm -i rpm-files 3) I treated it as a binary, and followed the instruction for binary installation. Then this command line puzzles me: shell bin/safe_mysqld --user=mysql double dash is a long option. the short option maybe -u. --ilham-- the double dashes may not be right. What is that? Have a nice weekend. I come back next Monday hoping to get a good answer from you. Thanks. Kelly - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Conversion
bob, first build the tables, to match your ascii database structure, Next use LOAD_DATA INFILE option to load it up, See LOAD_DATA in the manual for a detailed explanation. g'luck bob wrote: I'm looking for a way to translate a database in ASCII form throw a MySQL database. Could you tell me how to do and if there is a special software to do it. Tank you Ragrads - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
libmysqlclient
I just installed MySQL version 3.23.32, and all appeared to go well. However, after installing PHP 4 and rebooting my server, when I tried to start Apache (1.3.14) I got the following message: /usr/libexec/ld.so: httpd: libmysqlclient.so.10.0: No such file or directory /usr/sbin/apachectl start: httpd could not be started I know that libmysqlclient.so.10.0 exists on my drive, under /home/packages/mysql-3.23.32/libexec/.libs/ (which is not my install dir; that's /usr/local/mysql). I tried copying it to /usr/libexec, and that didn't solve the problem. Even more strange, though, is the fact that I don't have anything in my httpd.conf file that references MySQL. Thank you for any help or direction you could provide. Alex Le Fevre __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
list of databases
Is there any way I can generate a list of the databases in mysql, perhaps with the mysqlshow command and some fancy grep? I'm looking for a list separated by spaces, something that I could use in a bash script. Thanks, Tim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: libmysqlclient
copy or link your libmysqlclient.so.10.0 to /usr/lib. Or edit /etc/ld.so.conf. Add path your libmysqlclient.so.10.0, and run ldconfig. You must have root access. --ilham-- On Fri, 16 Feb 2001, Alex Le Fevre wrote: I just installed MySQL version 3.23.32, and all appeared to go well. However, after installing PHP 4 and rebooting my server, when I tried to start Apache (1.3.14) I got the following message: /usr/libexec/ld.so: httpd: libmysqlclient.so.10.0: No such file or directory /usr/sbin/apachectl start: httpd could not be started I know that libmysqlclient.so.10.0 exists on my drive, under /home/packages/mysql-3.23.32/libexec/.libs/ (which is not my install dir; that's /usr/local/mysql). I tried copying it to /usr/libexec, and that didn't solve the problem. Even more strange, though, is the fact that I don't have anything in my httpd.conf file that references MySQL. Thank you for any help or direction you could provide. Alex Le Fevre __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
returning PID
Hi, wat command to type under linux to get the PID of the mysqld that is running? i tried : 'ps aux | grep mysqld' but this will list the mysqld information but ijust want it to show the PID thanks Teddy
Re: returning PID
Try this. ps aux | grep mysqld | cut -c 10,11,12,13,14 - Original Message - From: Teddy A Jasin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 16, 2001 7:32 PM Subject: returning PID Hi, wat command to type under linux to get the PID of the mysqld that is running? i tried : 'ps aux | grep mysqld' but this will list the mysqld information but ijust want it to show the PID thanks Teddy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: returning PID
PID is stored in a file in the datadir named hostname.pid [root@georgia data]# cat /usr/local/mysql/data/georgia.pid 19805 Teddy A Jasin wrote: Hi, wat command to type under linux to get the PID of the mysqld that is running? i tried : 'ps aux | grep mysqld' but this will list the mysqld information but ijust want it to show the PID thanks Teddy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ISM,FRM Problem plese help if possible
create directory in your mysql data directory, like /var/lib/mysql/mydatabase. copy your .frm, .ISD, ism to that directory. now you have database named mydatabase. --ilham-- On Fri, 16 Feb 2001, Ryan Ahmed wrote: Q:--have you heard about that guy who finally discovered what a woman is all about A:sadly,he died laughing before he could tell anybody (And one for the ladies) Q:---Why was moses wandering around in the desert for 40 years? A:---Coz even then men couldnt take directions!!! Hi Everyone, Now that I've hopefully got you in a nice mood, First a bit of history, I was hosting with a very bad hosting service and so had to move all my files and so my databases too. I moved all my files but had no idea on how to move my DB's so I contacted my hosting service and they sent me a zip file with the following extentions .ism .frm .isd Where am I supposed to dump them or what should I do? Kindly help, Thank you -Ryan. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
quick install question about phpMyAdmin
i must be really new! i had no idea and read nothing that said the entire phpMyAdmin directory needed to be in a website folder. (i figured the entire folder need to be in there, is there another way?) how do you folks usually set this up? i mean, do you setup a whole website just to do "admin via the web"? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php