Re: Looking for a bona fide distributed database that is open source
Hi Bruce, - Original Message - From: Bruce Feist [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Sunday, March 16, 2003 7:03 AM Subject: Re: Looking for a bona fide distributed database that is open source Gelu Gogancea wrote: You make confusion between terms, CONCEPTS and TECHNOLOGIES.Is not yet invented the tools which should THINK instead of our BRAIN when must design a system...any kind of. You are mistaken if you think that I am confused about this. ...maybe...but from what you describe in your messages that is understandable. There are RDBMS's out there that support the features that I described. Yes, of course. An example is CA-OpenIngres. They are good for building distributed databases because they allow the implementer to work at a higher and more appropriate level, concentrating on the distribution appropriate instead of the mechanism for implementing distribution, and because they let the application developer ignore the fact that the database happens to be distributed. Ah...:)...so, now o lot of things began to be jointlyi agree. MySQL don't have implemented such a *powerful tool*(ad-literam copy words, from Ingres website). I made no claim that these other tools think or design; they simply You understand me wrong...it's was like example to be obvious the difference between, concepts and technologies(or tools, if i can said in this way) have extra functionality which implements distribution ...i guess that you wish to said : functionality which are permissive for implementing the distribution. Functionality, which must be able to manage two/more tables on the heterogeneous network environment.With this capabilites it's more easy to implement the distribution.Quite true. -- which is what the original poster was asking about. A human being still must figure out what the most effective distribution strategy is. Yes.It seems that we begin to talk about the same things.And now become the correct answer: MYSQL CAN BE USED IN THE DISTRIBUTED ENVIRONMENT SYSTEMS. MySQL is a fine RDBMS; it simply does not implement distribution in its engine. By claiming that it does, you do a disservice to other RDBMSs which *do*, and to people looking for such a solution. This is not was my intention.The result of this kind of discussions, always should go to some things which must be more clearly.Every project leader,manager...whatever...must be able to make out the correct decision, depend on his needs pertain to his knowledge,experince. Bruce Feist Regards, Gelu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql and asp web hosting
dear all, i'm looking for a good service/performance for web hosting which support mysql for database and asp for web programming. would you give me some suggestions to choose the web hosting? thanks a lot cheers, Ivan Paul MySQL, Query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Locating Duplicate records always results in Error 127
I am locating 'duplicate entries in a table and updating a status field accordingly. The idea is to locate rows which have a matching 'Name' field, and mark them for subsequent processing. However, my update query *ALWAYS* returns Error 127, even on a newly created table if the matching name field is 8 characters or more???. Below is a minimum script which always results in the error Got error 127 from table handler, with only two records in the table. Change the name fields from (8 chars) to AAA (7 chars) and no error. I would appreciate any help in tracking this down, or a suggestion for another way of detecting duplicate records which doesn't cause the problem. Ian # --- USE test; # # Table structure for table 'error127' # DROP TABLE IF EXISTS `error127`; CREATE TABLE `error127` ( `ItemID` int(11) NOT NULL default '0', `Name` varchar(70) NOT NULL default '', `Status` int(11) NOT NULL default '0', PRIMARY KEY (`ItemID`), KEY `Name` (`Name`) ) TYPE=MyISAM; # # Dumping data for table 'error127' # INSERT INTO `error127` (`ItemID`, `Name`) VALUES(1, ); INSERT INTO `error127` (`ItemID`, `Name`) VALUES(2, ); # # Set status # UPDATE error127 AS a,error127 AS b SET a.status=2 WHERE a.name = b.name AND a.itemid != b.itemid; # --- MySQL 4.011g, WinXP Prof -- Ian Wall - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySql++ compilation error on Aix with gcc3.2.1 (default argument given]
I tried to integrate, MySql++-1.7.9 with mysql-max-3.23.55-ibm-aix4.3.2.0-powerpc. I compiled with gcc3.2.1, and i passed the 2 patches for gcc3.0 and gcc3.2, on Aix4.3.2 How-To-Repeat: My configure contains: setenv CC /opt/gcc-3.2.1/usr/local/bin/gcc setenv CXX /opt/gcc-3.2.1/usr/local/bin/g++ setenv CFLAGS '-Wno-deprecated' setenv CXXFLAGS '-Wno-deprecated' setenv MAKE /opt/bin/make ./configure --srcdir=/opt/mysql++-1.7.9.src/mysql++-1.7.9 --with-mysql-include=/opt/mysql/include --prefix=/opt/mysql++-1.7.9_gcc3.2 And at compilation time i obtain this error: connection.cc:26: default argument given for parameter 6 of ` MysqlConnection::MysqlConnection(const char*, const char*, const char*, const char*, unsigned int, char = 0, unsigned int = 60, bool = true, const char* = , unsigned int = 0)' Could you give me an advice, to correct this error. Thanks, Olivier -- * * * Olivier HARDOUIN [TRANSICIEL - TECHNOLOGIES] * * * * sgl: 8is - Bur: M077 - Tel: 05 62 14 34 87 * * * ---end of your message--- MySQL Development Team -- * * * Olivier HARDOUIN [TRANSICIEL - TECHNOLOGIES] * * * * sgl: 8is - Bur: M077 - Tel: 05 62 14 34 87 * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Foreign Key and default action/RESTRICT behaviour?
Paul, - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 17, 2003 1:05 AM Subject: Re: Foreign Key and default action/RESTRICT behaviour? At 23:12 +0200 3/16/03, Heikki Tuuri wrote: Tor, - Original Message - From: Tor R. Skoglund (NextG) [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Sunday, March 16, 2003 10:11 PM Subject: Foreign Key and default action/RESTRICT behaviour? Hi List, regarding the foreign key definitions: [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE {CASCADE | SET NULL | NO ACTION | RESTRICT}] [ON UPDATE {CASCADE | SET NULL | NO ACTION | RESTRICT}] Is there a default action for ON DELETE and ON UPDATE if no action is specified in the database definition? RESTRICT is, of course, the default 'action'. ON DELETE and ON UPDATE are later additions. I see in the change notes that ON UPDATE was implemented in 4.0.8. But how can ON DELETE be a later addition than RESTRICT? I was under the impression that RESTRICT wasn't even implemented. CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB; CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ) TYPE=INNODB; CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE RESTRICT ON UPDATE RESTRICT ) TYPE=INNODB; the two definitions of 'child' above are equivalent. RESTRICT simply guards the referential integrity constraint. Also, the manual lists SET DEFAULT as a reference option for the general CREATE TABLE syntax. Does that come into play for InnoDB at all? ON ... SET DEFAULT is not implemented in InnoDB. ... Best regards, Tor Rune Skoglund [EMAIL PROTECTED] Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-4.0 from http://www.mysql.com -- Paul DuBois http://www.kitebird.com/ sql, query Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, foreign keys, and a hot backup tool for MySQL sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql and processor utilization
I installed mysql on Redhat Linux, I have a problem that it uses 85% of the processor making the idle time of the processor = 0 while I just hosted 1 site with php Is that normal or I have something wrong ? Best Regards Sherif Mohamad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 JDBC driver problem
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Shu-Ping Lin wrote: Hi, How are you? I have a problem to jdbc driver. My paltform is win2000 professional and MySQL Server's version is 3.23.55. I use jdbc driver of mysql-connector-java-3.0.6-stable.jar and i find some problems to this jdbc driver version. When i use some method about setting or getting String such like setString(1,kkk) in PrepareStatement or getTableName(1) in ResultMetaData, these methods do not work correctly. I can not get correct String by some getting String method, so do others setting String method. Strange, when i change JDBC driver to mysql-connector-java-2.0.14.jar everything is right. All programs work, so i report this problem to you and wish to find the reason of causing the problem. Thanks! My guess is that your JVM platform encoding is multibyte, while the one in MySQL is not. You will need to upgrade to a nightly snapshot of Connector/J 3.0 for the fix to this (until 3.0.7 is released). Please see http://mmmysql.sourceforge.net/snapshots/stable/ -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+dc6ytvXNTca6JD8RAvlbAJ9lWuibvd4mAfSqudHfMQDM6bXc1ACdFpD7 lrjMGVMVDae+1BdDaMkmX6U= =uWfH -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 QUERY
Problem with the following SQL Query: How do I combine DISTINCT with the SELECT * ? Is it SELECT DISTINCT * FROM...? This doesn´t work in my project. Best regards, Martin Schaller -- +++ GMX - Mail, Messaging more http://www.gmx.net +++ Bitte lächeln! Fotogalerie online mit GMX ohne eigene Homepage! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/InnoDB-3.23.56 is released
Hi! InnoDB is a MySQL table type which provides transactions, foreign key constraints, and a non-free Hot Backup tool. InnoDB is included in MySQL-Max-3.23.56 which you can download from http://www.mysql.com/downloads/mysql-3.23.html. MySQL-Max-3.23 is the stable version which is recommended for production use. The changelog for InnoDB-3.23.56: * Fixed a major bug in InnoDB query optimization: SQL queries of type SELECT ... WHERE indexcolumn x and SELECT ... WHERE indexcolumn x could cause a table scan even if the selectivity would have been very good. * Fixed a potential bug if MySQL calls store_lock with TL_IGNORE in the middle of a query. * An outstanding bug: MySQL can erroneously return 'Empty set' if InnoDB estimates an index range size to 0 records though the range is not empty; MySQL also fails to do the next-key locking in the case of an empty index range. Fixed in 3.23.57. * An outstanding bug: GROUP BY or DISTINCT may fail to group all NULLs to the same group. Fixed in 3.23.57. Best regards, Heikki Innobase Oy http://www.innodb.com Read the up-to-date InnoDB manual at http://www.innodb.com/ibman.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: mySQL activity logging on a dual prozessor maschine
Hi Gelu, thanks for your message. But I'm not confused about the timeformat, I'm confused of the order the logs are. 1st: 19:31:18 2nd: 19:31:20 3rd: 19:31:18 (!) 4th: 19:31:20 (!) ... I don't know, what the problem is. Rgds, Peter -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:34 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mySQL activity logging on a dual prozessor maschine Hi, Maybe it's funny...but this is MySQL date/time format which is used in log files.On my MySQL servers date/time are formated in the same way. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Peter Stoehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:52 PM Subject: mySQL activity logging on a dual prozessor maschine Hi list, few days ago, I have installed a 2nd CPU in my ProLiant380. I recompiled a new kernel (2.4.17) for Debian 3.0. On the machine there is mySQL 3.23.52-2 installed (deb). Every thing works fine, just the logging of mySQL looks a little funny to me, especially the time: 030314 19:31:189745 Query SELECT de FROM b... 9745 Query SELECT gid FROM ... 030314 19:31:209745 Query SELECT gid FROM ... 030314 19:31:189745 Query SELECT gid FROM ... 9745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 9745 Query SELECT de FROM b... 9745 Query SELECT gid FROM ... 030314 19:31:209745 Query SELECT gid FROM ... The websites still grow up without errors and there is also nothing in the errorlogs. Did someone of you ever had this interesting thing? I could not find anything about that with Google or in the mailarchive here at mySQL. Thanks for your help, regards, Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
problème d'install de mysql sur hp-ux
Bonjour , J'essai d'installer Mysql sur un serveur HP-UX B.10.20 U 9000/800 unlimited-user license, et lors du lancement de celui ci , j'ai la creation d'un fichier core /scripts/mysql_install_db[292]: 22671 Memory fault(coredump) . Y a t'il une configuration a prendre en compte au niveau de du noyau ou autre ?? Cordialement Jérôme JAMET Atos Origin Infogérance Tour Manhattan - 21ème étage 5/6 , Place de l'Iris - La Défense 2 92067 Paris La Défense Cedex Tél : 01 73 29 32 50 06 14 39 55 52 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.52 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.52, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.52-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 3 days 2 hours 32 min 39 sec Threads: 1 Questions: 4 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.000 Environment: System: Linux localhost.localdomain 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux 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/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' CXX='g++' CXXFLAGS='-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Feb 25 19:25 /lib/libc.so.6 - libc-2.2.93.so -rwxr-xr-x2 root root 1235468 Sep 6 2002 /lib/libc-2.2.93.so -rw-r--r--1 root root 2233342 Sep 6 2002 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 6 2002 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Feb 25 20:16 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --datadir=/usr/share --libdir=/usr/lib --mandir=/usr/share/man --infodir=/usr/share/info --without-readline --without-debug --enable-shared --with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/tmp/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --with-innodb --enable-local-infile --enable-large-files=yes --enable-largefile=yes --with-berkeley-db --with-thread-safe-client 'CFLAGS=-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE' 'CXXFLAGS=-O2 -march=i386 -mcpu=i686 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-rtti -fno-exceptions' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
remote connection with JDBC
I can connect to MySQL through JDBC with the following URL without any problem: jdbc:mysql://localhost:3306/mydatabase However, when I simulate the above URL as though I'm calling from a remote machine using the following URL, jdbc:mysql://192.168.0.10:3306/mydatabase I got the following exception (the file name is Lookup.java) : Exception in thread main java.sql.SQLException: Communication link failure: java.io.IOException at com.mysql.jdbc.MysqlIO.init(Unknown Source) at com.mysql.jdbc.Connection.connectionInit(Unknown Source) at com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source) at com.mysql.jdbc.Driver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at Lookup.main(Lookup.java:16) I would very much appreciate if anybody could tell me how to connect the database from a remote machine (if possible with which library to import from). Thank you very much in advance. _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: VB6 ODBC Memory problems
My first recommendation is to switch to ADO. It is much faster. Bruce Lewis - Original Message - From: Thomas Bein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 16, 2003 12:55 PM Subject: VB6 ODBC Memory problems Hello, I have been developing an application in VB60 (SP5) which seems to eat up my memory after running some time. The programm is just doing a SELECT in a loop. When the programm is stopped, the memory is freed. Developement environment: WinNT40 SP6a VB60 SP5 DAO 3.6 MySql 2.23.54-nt MySql-ODBC 3.51.04 (using no transactions) Are there known problems ? Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
column named force not allowed
Description: When creating a table with a column named force an error is shown and the table is not created. How-To-Repeat: When trying to do this : CREATE TABLE testcase ( force int default NULL ) TYPE=MyISAM; I get this : ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'force int default NULL, ) TYPE=MyISAM' at line 2 Is this related to the FORCE INDEX feature ? Fix: Change columnname to something different, but this often requires changes to software which is not always possible. Submitter-Id: Originator: Peter O Organization: MySQL support: none Synopsis: column named force not allowed Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release:mysql-4.0.9-gamma (Official MySQL RPM) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux 2.4.18-14bigmem #1 SMP Wed Sep 4 11:58:10 EDT 2002 i686 i686 i386 GNU/Linux 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/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redha t-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' -O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Jan 17 17:35 /lib/libc.so.6 - libc-2.2.93.so -rwxr-xr-x1 root root 1235468 Sep 6 2002 /lib/libc-2.2.93.so -rw-r--r--1 root root 2233342 Sep 6 2002 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 6 2002 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-embedded-server' '--enable-thread-safe-client' '--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-e xceptions -fno-rtti -mpentium' 'CXX=gcc' Kind regards, Peter O *** Peter O, Software Developer MrBookmaker NV, Bijenstraat 11, B-9051 Sint-Denijs-Westrem, Belgium Tel:+32-(0)9-245.44.44, fax:+32-(0)9-245.44.45 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: remote connection with JDBC
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Erwin Adi wrote: I can connect to MySQL through JDBC with the following URL without any problem: jdbc:mysql://localhost:3306/mydatabase However, when I simulate the above URL as though I'm calling from a remote machine using the following URL, jdbc:mysql://192.168.0.10:3306/mydatabase I got the following exception (the file name is Lookup.java) : Exception in thread main java.sql.SQLException: Communication link failure: java.io.IOException at com.mysql.jdbc.MysqlIO.init(Unknown Source) at com.mysql.jdbc.Connection.connectionInit(Unknown Source) at com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source) at com.mysql.jdbc.Driver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at Lookup.main(Lookup.java:16) I would very much appreciate if anybody could tell me how to connect the database from a remote machine (if possible with which library to import from). Thank you very much in advance. What OS is running on the remote machine? It looks like it is RedHat-8.0. On RedHat 8.0, if you use RedHat's mysql binaries, remote TCP/IP connections won't work. If this is the case, please try one of our binaries, and also look at the directions here: http://www.mysql.com/doc/en/Linux-x86.html -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+deX2tvXNTca6JD8RArUNAJ4vIuve3vU697q3GlwqQRw0/19BfwCfVt9z OdIEp97O8cLJAEdoOtcoYeM= =sZDH -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Update to one of three values.
Maybe I am missing something, but why not: UPDATE T SET T.Data = 1 WHERE . . . With only 2 fields, what could be in your WHERE clause? Hu Qinan wrote: A table T contains two fields: T.ID, T.Data. I want to set its T.Data to one of three values: NULL, 0, 1 according to its T.ID. This is what I have done: 1. Set all Data to be NULL: UPDATE T SET Data = NULL; 2. Create a temporary table Temp to store some selected T.ID. Then update the Data of these records to 1. SELECT ID FROM T WHERE ...; UPDATE T INNER JOIN Temp1 ON T.ID = Temp1.ID SET T.Data = 1; 3. Create another tempory table Temp2 to store selected T.ID. Then update these Data to be 0. SELECT ID FROM Temp1 WHERE... UPDATE T INNER JOIN Temp2 ON T.ID = Temp2.ID SET T.Data = 0; The above sqls are quite efficient, becasue some values are updated three times. Any suggestions for me to simply the above operations? Thanks a lot. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL activity logging on a dual prozessor maschine
Hi Peter, - Original Message - From: Peter Stoehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Gelu Gogancea [EMAIL PROTECTED] Sent: Monday, March 17, 2003 3:56 PM Subject: RE: mySQL activity logging on a dual prozessor maschine Hi Gelu, thanks for your message. But I'm not confused about the timeformat, I'm confused of the order the logs are. 1st: 19:31:18 2nd: 19:31:20 3rd: 19:31:18 (!) 4th: 19:31:20 (!) Indeed...this is a little strange.If we suppose that your computer clock work fine,remain only idea about time processing.It's possible to be some shorter processes which can running on the same period of time with the longer processes.That means can be a process(shorter time running/easy process) which is started after another process is already started(longer time running/heavy) but is finished before the process which was already started.In this situation can make sense because this processes write on the log file (the starting time) after *they* are succesfully finished. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] ... I don't know, what the problem is. Rgds, Peter -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:34 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mySQL activity logging on a dual prozessor maschine Hi, Maybe it's funny...but this is MySQL date/time format which is used in log files.On my MySQL servers date/time are formated in the same way. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Peter Stoehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 14, 2003 10:52 PM Subject: mySQL activity logging on a dual prozessor maschine Hi list, few days ago, I have installed a 2nd CPU in my ProLiant380. I recompiled a new kernel (2.4.17) for Debian 3.0. On the machine there is mySQL 3.23.52-2 installed (deb). Every thing works fine, just the logging of mySQL looks a little funny to me, especially the time: 030314 19:31:189745 Query SELECT de FROM b... 9745 Query SELECT gid FROM ... 030314 19:31:209745 Query SELECT gid FROM ... 030314 19:31:189745 Query SELECT gid FROM ... 9745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 030314 19:31:209745 Query SELECT de FROM b... 030314 19:31:189745 Query SELECT de FROM b... 9745 Query SELECT de FROM b... 9745 Query SELECT gid FROM ... 030314 19:31:209745 Query SELECT gid FROM ... The websites still grow up without errors and there is also nothing in the errorlogs. Did someone of you ever had this interesting thing? I could not find anything about that with Google or in the mailarchive here at mySQL. Thanks for your help, regards, Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.56 has been released
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL 3.23.56, a new version of the popular Open Source Database, has been released. It is now available in source and binary form for a number of platforms from our download pages at http://www.mysql.com/downloads/ and mirror sites. Note that not all mirror sites may be up to date at this point of time - if you can't find this version on some mirror, please try again later or choose another download site. This is a bugfix/security enhancement release for the current production version. News from the ChangeLog: * Fixed `mysqld' crash on extremely small values of `sort_buffer' variable. * Fixed a bug in privilege system for `GRANT UPDATE' on column level. * Fixed a rare bug when using a date in `HAVING' with `GROUP BY'. * Fixed checking of random part of `WHERE' clause (Bug #142). * Fixed MySQL (and `myisamchk') crash on artificially corrupted `.MYI' files. * Security enhancement: `mysqld' no longer reads options from world-writeable config files. * Security enhancement: `mysqld' and `safe_mysqld' now only use the first `--user' option specified on the command line. (Normally this comes from `/etc/my.cnf') * Security enhancement: Don't allow `BACKUP TABLE' to overwrite existing files. * Fixed unlikely deadlock bug when one thread did a `LOCK TABLE' and another thread did a `DROP TABLE'. In this case one could do a `KILL' on one of the threads to resolve the deadlock. * `LOAD DATA INFILE' was not replicated by slave if `replicate_*_table' was set on the slave. * Fixed a bug in handling `CHAR(0)' columns that could cause wrong results from the query. * Fixed a bug in `SHOW VARIABLES' on 64-bit platforms. The bug was caused by wrong declaration of variable `server_id'. * The Comment column in `SHOW TABLE STATUS' now reports that it can contain `NULL' values (which is the case for a crashed `.frm' file). * Fixed the `rpl_rotate_logs' test to not fail on certain platforms (e.g. Mac OS X) due to a too long file name (changed `slave-master-info.opt' to `.slave-mi'). * Fixed a problem with `BLOB NOT NULL' columns used with `IS NULL'. * Fixed bug in `MAX()' optimization in `MERGE' tables. * Better `RAND()' initialization for new connections. * Fixed bug with connect timeout. This bug was manifested on OS's with `poll()' system call, which resulted in timeout the value specified as it was executed in both `select()' and `poll()'. * Fixed bug in `SELECT * FROM table WHERE datetime1 IS NULL OR datetime2 IS NULL'. * Fixed bug in using aggregate functions as argument for `INTERVAL', `CASE', `FIELD', `CONCAT_WS', `ELT' and `MAKE_SET' functions. * When running with `--lower-case-table-names' (default on windows) and you had tables or databases with mixed case on disk, then executing `SHOW TABLE STATUS' followed with `DROP DATABASE' or `DROP TABLE' could fail with `Errcode 13'. * Fixed bug in logging to binary log (which affects replication) a query that inserts a `NULL' in an `auto_increment' field and also uses `LAST_INSERT_ID()'. * Fixed bug in `mysqladmin --relative'. * On some 64 bit systems, `show status' reported a strange number for `Open_files' and `Open_streams'. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD4DBQE+de/TSVDhKrJykfIRAgExAJ9h76Xz2YGyu15uVE1dcw/Rhhz10ACY5YtF OIW1rk3kRmLVMopl9/Tcug== =rn7W -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 stops responding in the morning
I have an app running on Tomcat 4.0.6. The app access mySQL Ver 11.18 Distrib 3.23.54, for sun-solaris2.9 (sparc) on Solaris 9. the app runs fine during the day, but when I come back to work in the morning, I see that the database connection has died and mySQL does not respond anymore. What needs to be done to make keep it alive ? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
EMS MySQL Manager for Linux 1.15 released!
EMS HiTech company is very glad to announce MySQL Manager for Linux 1.15 -- the next version of our powerful MySQL administration and development tool! You can download the latest version and user's guide from http://www.mysqlmanager.com/download.phtml What's new in version 1.15? 1. Export Data Dialog: export to PDF added. Now you can export data to one of the most popular document formats as well as to the other supported formats. 2. Export Data Dialog - export to HTML: a possibility of customizing navigation links for multi-file export and a possibility to define a background picture for the result table added. 3. Import Data Wizard: import modes are implemented - now you can define an action to be executed with the concurrent records in the source file and the target table. You can either update these records, delete them, insert only new records, and more. For these purpose you should define key columns as primary key. 4. Import Data Wizard: added a possibility of defining a way to add data to the destination table - insert or append. 5. Several small improvements and minor bugfixes. What is MySQL Manager? EMS MySQL Manager provides powerful tools for MySQL Server administration and object management. Its Graphical User Interface (GUI) allows you to create/edit all MySQL database objects in a simple and direct way, run SQL scripts, manage users and administer user privileges, extract, print, and search metadata, create database structure reports in HTML format, export/import data, and supplies many more services that will make your work with the MySQL server as easy as it can be... Don't forget to check out other our products: http://www.ems-hitech.com/sqlmanagers Powerful database administration tools for InterBase/FireBird, MySQL and PostgreSQL servers http://www.ems-hitech.com/sqlutils/ Cross-platform data management utilities http://www.ems-hitech.com/components/ Powerful components for Delphi/C++ Builder developers We hope you'll like our products. Thank you for your attention. Best Regards, EMS HiTech Team http://www.ems-hitech.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mySQL activity logging on a dual prozessor maschine
Hi again, I don't think, that there are longer or shorter processes. Since I installed the 2nd CPU (933MHz for Compaq ProLaint380), I have these logenties. For example, I have a site, which supports more languages (at this time english and german only). On one site, I installed a JavaScript-Calender and the name of the months will be selected from the database in the correct language the customer wanted it. The mysql-logs look like this, when I called the calender and the name of month should be in german: 030317 16:09:54 22669 Init DB calenderDB 22669 Query SELECT de FROM general_lang WHERE def = 'jan' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'feb' 030317 16:09:54 22669 Query SELECT de FROM general_lang WHERE def = 'mar' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'apr' 22669 Query SELECT de FROM general_lang WHERE def = 'mai' 030317 16:09:54 22669 Query SELECT de FROM general_lang WHERE def = 'jun' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'jul' 030317 16:09:54 22669 Query SELECT de FROM general_lang WHERE def = 'aug' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'sep' 030317 16:09:54 22669 Query SELECT de FROM general_lang WHERE def = 'okt' 22669 Query SELECT de FROM general_lang WHERE def = 'nov' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'dez' I don't think, that selecting the german word for february, april and july needs more cpu than march, june or october. There is also another thing; I in one database some ISO short forms, which stands for some languages. For example: de - german, en - english, it - italian and so on. So, if one customer wants to see details of one person which works for our office, he maybe doesn't know the meaning of de, en, it. So this shortforms will also translated to his prefered language. The mysql-logs looks like this: 030317 15:20:58 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'en' 030317 15:20:57 22560 Query SELECT en FROM general_lang WHERE def = 'englisch' 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'hr' 030317 15:21:00 22560 Query SELECT en FROM general_lang WHERE def = 'kroatisch' 030317 15:20:57 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'fr' 030317 15:21:00 22560 Query SELECT en FROM general_lang WHERE def = 'franzoesisch' 030317 15:20:57 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'it' 030317 15:21:00 22560 Query SELECT en FROM general_lang WHERE def = 'italienisch' 030317 15:20:57 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'ru' 030317 15:21:00 22560 Query SELECT en FROM general_lang WHERE def = 'russisch' A PHP script split the language-string which was for this example: en,hr,fr,it,ru. Then the script initialize a mysql query (look for the definition of _en_). mysql sends back: _englisch_. Then the script initialize a translation query (look for the english word for _englisch_). mysql send back _english_. Only after this steps, the php-script starts again with _hr_ and so on. So when mysql made the logentry _SELECT en FROM general_lang WHERE def = 'englisch'_, mysql got the the query result from _SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'en'_. But this query result was in the past and not in the future. That's the funny thing I'm thinking of. Before I upgraded my server with the 2nd cpu, the logs where _normal_. Rgds, Peter -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 4:48 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mySQL activity logging on a dual prozessor maschine Hi Peter, - Original Message - From: Peter Stoehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Gelu Gogancea [EMAIL PROTECTED] Sent: Monday, March 17, 2003 3:56 PM Subject: RE: mySQL activity logging on a dual prozessor maschine Hi Gelu, thanks for your message. But I'm not confused about the timeformat, I'm confused of the order the logs are. 1st: 19:31:18 2nd: 19:31:20 3rd: 19:31:18 (!) 4th: 19:31:20 (!) Indeed...this is a little strange.If we suppose that your computer clock work fine,remain only idea about time processing.It's possible to be some shorter processes which can running on the same period of time with the longer processes.That means can be a process(shorter time running/easy process) which is started after another process is already started(longer time running/heavy) but is finished before the process which was already started.In this situation can make sense because this processes write on the log file (the starting time) after *they* are succesfully finished.
AW: EMS MySQL Manager for Linux 1.15 released!
Hi, is anyone interested in commercial use/spam of this list? If not, I would prefer to throw them out of the list. Regards, Reiner -Ursprungliche Nachricht- Von: EMS HiTech Team [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. Marz 2003 17:05 An: [EMAIL PROTECTED] Betreff: EMS MySQL Manager for Linux 1.15 released! EMS HiTech company is very glad to announce MySQL Manager for Linux 1.15 -- the next version of our powerful MySQL administration and development tool! You can download the latest version and user's guide from http://www.mysqlmanager.com/download.phtml What's new in version 1.15? 1. Export Data Dialog: export to PDF added. Now you can export data to one of the most popular document formats as well as to the other supported formats. 2. Export Data Dialog - export to HTML: a possibility of customizing navigation links for multi-file export and a possibility to define a background picture for the result table added. 3. Import Data Wizard: import modes are implemented - now you can define an action to be executed with the concurrent records in the source file and the target table. You can either update these records, delete them, insert only new records, and more. For these purpose you should define key columns as primary key. 4. Import Data Wizard: added a possibility of defining a way to add data to the destination table - insert or append. 5. Several small improvements and minor bugfixes. What is MySQL Manager? EMS MySQL Manager provides powerful tools for MySQL Server administration and object management. Its Graphical User Interface (GUI) allows you to create/edit all MySQL database objects in a simple and direct way, run SQL scripts, manage users and administer user privileges, extract, print, and search metadata, create database structure reports in HTML format, export/import data, and supplies many more services that will make your work with the MySQL server as easy as it can be... Don't forget to check out other our products: http://www.ems-hitech.com/sqlmanagers Powerful database administration tools for InterBase/FireBird, MySQL and PostgreSQL servers http://www.ems-hitech.com/sqlutils/ Cross-platform data management utilities http://www.ems-hitech.com/components/ Powerful components for Delphi/C++ Builder developers We hope you'll like our products. Thank you for your attention. Best Regards, EMS HiTech Team http://www.ems-hitech.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Locating Duplicate records always results in Error 127
Hi! On Mar 17, mySQL list wrote: Below is a minimum script which always results in the error Got error 127 from table handler, with only two records in the table. Change the name fields from (8 chars) to AAA (7 chars) and no error. I tried it on both 4.0.11 and 4.0.12. It, indeed, prodeces error 127 on 4.0.11, but works ok on 4.0.12. Probably, one of the bugfixes fixed this bug as a side effect :) So - just upgrade. 4.0.12 will be out this week. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 stops responding in the morning
At 10:58 -0500 3/17/03, [EMAIL PROTECTED] wrote: I have an app running on Tomcat 4.0.6. The app access mySQL Ver 11.18 Distrib 3.23.54, for sun-solaris2.9 (sparc) on Solaris 9. the app runs fine during the day, but when I come back to work in the morning, I see that the database connection has died and mySQL does not respond anymore. What needs to be done to make keep it alive ? Thanks First you should determine whether this is really a MySQL problem or a Tomcat problem. When Tomcat cannot access the MySQL server, is it that the server itself is unresponsive, or can other clients connect to it still. For example, if you attempt to connect with the mysql client, can you? Or does that fail as well? -- Paul DuBois http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: AW: EMS MySQL Manager for Linux 1.15 released!
I second that. Rusch (ext) Reiner wrote: Hi, is anyone interested in commercial use/spam of this list? If not, I would prefer to throw them out of the list. Regards, Reiner -Ursprungliche Nachricht- Von: EMS HiTech Team [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. Marz 2003 17:05 An: [EMAIL PROTECTED] Betreff: EMS MySQL Manager for Linux 1.15 released! EMS HiTech company is very glad to announce MySQL Manager for Linux 1.15 -- the next version of our powerful MySQL administration and development tool! You can download the latest version and user's guide from http://www.mysqlmanager.com/download.phtml What's new in version 1.15? 1. Export Data Dialog: export to PDF added. Now you can export data to one of the most popular document formats as well as to the other supported formats. 2. Export Data Dialog - export to HTML: a possibility of customizing navigation links for multi-file export and a possibility to define a background picture for the result table added. 3. Import Data Wizard: import modes are implemented - now you can define an action to be executed with the concurrent records in the source file and the target table. You can either update these records, delete them, insert only new records, and more. For these purpose you should define key columns as primary key. 4. Import Data Wizard: added a possibility of defining a way to add data to the destination table - insert or append. 5. Several small improvements and minor bugfixes. What is MySQL Manager? EMS MySQL Manager provides powerful tools for MySQL Server administration and object management. Its Graphical User Interface (GUI) allows you to create/edit all MySQL database objects in a simple and direct way, run SQL scripts, manage users and administer user privileges, extract, print, and search metadata, create database structure reports in HTML format, export/import data, and supplies many more services that will make your work with the MySQL server as easy as it can be... Don't forget to check out other our products: http://www.ems-hitech.com/sqlmanagers Powerful database administration tools for InterBase/FireBird, MySQL and PostgreSQL servers http://www.ems-hitech.com/sqlutils/ Cross-platform data management utilities http://www.ems-hitech.com/components/ Powerful components for Delphi/C++ Builder developers We hope you'll like our products. Thank you for your attention. Best Regards, EMS HiTech Team http://www.ems-hitech.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 -- Barry Marler Plant Genome Mapping Laboratory University of Georgia Room 229, Center for Applied Genetics Technology 111 Riverbend Road Athens, GA 30602 706.583.0164[office] 706.583.0160[fax] http://www.plantgenome.uga.edu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: AW: EMS MySQL Manager for Linux 1.15 released!
Greetings: 1. They only post when it deals with new software or upgrades which is less than once per quarter (if that). 2. The information involves mySQL. 3. We find the posts helpful and not SPAM. Thank you. At 05:27 PM 3/17/2003 +0100, you wrote: Hi, is anyone interested in commercial use/spam of this list? If not, I would prefer to throw them out of the list. Regards, Reiner -Ursprungliche Nachricht- Von: EMS HiTech Team [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. Marz 2003 17:05 An: [EMAIL PROTECTED] Betreff: EMS MySQL Manager for Linux 1.15 released! EMS HiTech company is very glad to announce MySQL Manager for Linux 1.15 -- the next version of our powerful MySQL administration and development tool! Peter M. Abraham President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL stops responding in the morning
[EMAIL PROTECTED] wrote: I have an app running on Tomcat 4.0.6. The app access mySQL Ver 11.18 Distrib 3.23.54, for sun-solaris2.9 (sparc) on Solaris 9. the app runs fine during the day, but when I come back to work in the morning, I see that the database connection has died and mySQL does not respond anymore. What needs to be done to make keep it alive ? If it is indeed MySQL that stops responding, I'd recommend to set up a script that would periodically try to connect to MySQL, and restarts it if it stops accepting connections. But try to find the real cause - I had the same problem previously using 3.23.53, which was solved after I have upgraded to a 3.23.55 RPM install. Switch on your logs and see what's happening. - Cs. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 QUERY
At 14:40 +0100 3/17/03, [EMAIL PROTECTED] wrote: Problem with the following SQL Query: How do I combine DISTINCT with the SELECT * ? Is it SELECT DISTINCT * FROM...? This doesn´t work in my project. SELECT DISTINCT * FROM ... should work. What is your exact query, and what error message do you see? -- Paul DuBois http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: Connect to mysql server fail!
hi,experts: I installed mysql (3.23.56, server client) at my NT4.0 machine. As I unziped and set up mysql, everything seemed fine ( I used winmysqladmin to start mysqld-nt server). That mean that the mysql server is running. However, when I create 'root' with mysqladmin command as follows: --g:\mysql\bin\mysqladmin -u root password 'therootpassword' and then try to see the status og mysql using following command: --g:\mysql\bin\mysqladmin -u root -p status Enter Password: I got the error message: mysqladmin: coonect to server at 'localhost' failed error: 'Access denied for user:[EMAIL PROTECTED]' ,Using password: Yes' Are there any mis-configuration in my installing process. Can anyone show me how to fix this problem? Thanks. Chien-Lung - 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
oracle.
hi, m a frequent user of mysql. i was trying to use show tables on oracle(sql), but it dint work :( How do list tables in oracle? Thanks anil. p.s. sorry for the out of list question. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: oracle.
'select table_name from user_tables' to see your own tables. To see all tables you have to select from dba_tables. -- anthony -Original Message- From: Anil Garg [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 9:35 AM To: [EMAIL PROTECTED] Subject: oracle. hi, m a frequent user of mysql. i was trying to use show tables on oracle(sql), but it dint work :( How do list tables in oracle? Thanks anil. p.s. sorry for the out of list question. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Process Limit on Linux ?
Philipp wrote: Hi there, i wrote several times to the list asking for help with a problem regarding process limits on linux, but never got an answer. today i found this story: http://www.mysql.com/press/user_stories/handy.de.html here are the relevant sentences: We had some process limit problems on our Linux Systems, but thanks to your support we where able to patch the linux boxes and move the limit to a size that meets our needs (we've got an average of about 1600 concurrent threads per server). These people use 2.2 Kernels so i dont know if the mentioned kernel and glibc patching is also relevant for me, as i am using 2.4 kernels only. Here is my problem in detail: i am using mysql-3.23.55 binary packages on linux 2.4.20 and i raised ulimit values and configuration in my.conf to allow more then 1500 threads. but when there are around 750 threads a new client connecting is told something like that (dont have the errno at the moment, i think its 11): cant create new thread, perhaps you are out of memory or there is a os-depended bug. The machine only runs apache and mysql and is a Xeon 2x2 2.4 Gz with 2 GB of RAM. cat /proc/meminfo sais that more then 1 Gig is used for caching, so memory should be no problem . Please, if you have any ideas, let me know. If it is a kernel issue, tell me to go to linux mailing lists or if its some kind of secret issue only the support will be able to answer let me know that. Thanks in advance, Philipp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Philipp, Did you check /proc/sys/kernel/threads-max? I know with oracle 8i, you are supposed to increase /proc/sys/kernel/shmmax as well as some other values. You might check into that and see if changing those values will help. Does your syslog say anything when these problems occur? walt walt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and processor utilization
Sherif Diaa Mohamad wrote: I installed mysql on Redhat Linux, I have a problem that it uses 85% of the processor making the idle time of the processor = 0 while I just hosted 1 site with php Is that normal or I have something wrong ? Best Regards Sherif Mohamad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sherif, What version of RH and what version of mysql? Does the mysql error log show anything? Does the syslog show anything strange? walt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: oracle.
thanks, that helped anil :) -Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 12:51 PM To: Anil Garg Subject: Re: oracle. Anil, I do not remember correct but you need to look at the user_tables. 'desc user_tables' One of the fields mught be owner or something then you can do select * from user_tables where owner='SCOTT'; Now, I am not 100% sure on htat command but you need to key on somethin gin the user_tables :-) ---Original Message--- From: Anil Garg [EMAIL PROTECTED] Sent: 03/17/03 09:34 AM To: [EMAIL PROTECTED] Subject: oracle. hi, m a frequent user of mysql. i was trying to use show tables on oracle(sql), but it dint work :( How do list tables in oracle? Thanks anil. p.s. sorry for the out of list question. - Before posting, please check: a target=_blank href=http://www.mysql.com/manual.php;http://www.mysql.com/manual.php/a (the manual) a target=_blank href=http://lists.mysql.com/;http://lists.mysql.com//a (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: a target=_blank href=http://lists.mysql.com/php/unsubscribe.php;http://lists.mysql.com/php /unsubscribe.php/a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: Connect to mysql server fail!
hi,experts: I installed mysql (3.23.49, server client) at my NT4.0 machine. As I unziped and set up mysql, everything seemed fine ( I used winmysqladmin to start mysqld-nt server). That mean that the mysql server is running. However, when I create 'root' with mysqladmin command as follows: --g:\mysql\bin\mysqladmin -u root password 'therootpassword' and then try to see the status og mysql using following command: --g:\mysql\bin\mysqladmin -u root -p status Enter Password: I got the error message: mysqladmin: coonect to server at 'localhost' failed error: 'Access denied for user:[EMAIL PROTECTED]' ,Using password: Yes' Are there any mis-configuration in my installing process. Can anyone show me how to fix this problem? Thanks. Chien-Lung - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FW: Connect to mysql server fail!
You did not create 'root'. You set the root password to 'therootpassword' Did you enter the same password you set? Enter Password : therootpassword Chien-Lung Wu wrote: hi,experts: I installed mysql (3.23.49, server client) at my NT4.0 machine. As I unziped and set up mysql, everything seemed fine ( I used winmysqladmin to start mysqld-nt server). That mean that the mysql server is running. However, when I create 'root' with mysqladmin command as follows: --g:\mysql\bin\mysqladmin -u root password 'therootpassword' and then try to see the status og mysql using following command: --g:\mysql\bin\mysqladmin -u root -p status Enter Password: I got the error message: mysqladmin: coonect to server at 'localhost' failed error: 'Access denied for user:[EMAIL PROTECTED]' ,Using password: Yes' Are there any mis-configuration in my installing process. Can anyone show me how to fix this problem? Thanks. Chien-Lung - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Recent crash with 3.23.56
Description: I installed the most recent rpm for RedHat Linux 7.2. After running for no more than 10 minutes, it crashed. safe_mysqld failed to restart the daemon. How-To-Repeat: I don't know. Here is all the information I have on the problem: Stack Trace: 0x806fc04 char_val + 44 0x8121588 _ufc_doit_r + 184 0x80d8d28 remove_key + 220 0x80d9cab nisam_create + 2491 0x80e2f17 mi_lock_database + 1031 0x80e2fb9 mi_copy_status + 1 0x80e2fb9 mi_copy_status + 1 0x80e313f _mi_writeinfo + 79 0x80e306a _mi_readinfo + 122 0x80bb82c mysql_load__FP3THDP12sql_exchangeP13st_table_listRt4List1Z4Item15enum_duplicatesb13thr_lock_type + 1052 0x80b1c8b optimize__9ha_myisamP3THDP15st_ha_check_opt + 111 0x80b3157 create__9ha_myisamPCcP8st_tableP24st_ha_create_information + 1547 0x80aeb25 make_sortkey__FP13st_sort_paramPUcPc + 589 0x808efb8 create_tmp_field__FP8st_tableP4ItemQ24Item4TypePPP17Item_result_fieldPP5FieldbT5 + 836 0x808d676 make_join_readinfo__FP4JOINUi + 862 0x8076860 add_join_on__FP13st_table_listP4Item + 64 0x807a91c yyparse__Fv + 15644 0x8075a15 mysql_init_query__FP3THD + 137 0x8074db7 mysql_execute_command__Fv + 10163 Query in log: thd-query at 0x8382ec0 = SELECT challenge FROM ladder_rules WHERE ladder='dartpros' thd-thread_id=1915 I should note that ladder_rules is actually a symlinked file to another file on an NFS share. We do this on all machines that are read-only queries for that table. Fix: Submitter-Id: submitter ID Originator:root Organization: Mikel Tidwell, Case's Ladder MySQL support: none Synopsis: mysqld crash Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.56 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.56, for pc-linux on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.56 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 8 min 13 sec Threads: 9 Questions: 10938 Slow queries: 13 Opens: 156 Flush tables: 1 Open tables: 150 Queries per second avg: 22.187 Environment: System: Linux cgi3 2.4.7-10smp #1 SMP Thu Sep 6 17:09:31 EDT 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/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Apr 5 2002 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x2 root root 1282588 Sep 4 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 Sep 4 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 4 2001 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--without-innodb' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' 'CXX=gcc' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: problème d'install de mysql sur hp-ux
Bonjour Jérôme, En premier cette liste est en anglais pourtant j'ai plusieurs questions de te demander. As tu essayé de compiler MySQL sur HPUX ou utiliser l'édition precompilé sure le page de télécharger? Je te conseil de employer la version compiler par le groupe de mysql. En plus y-a-t'il des messages dans le fichier d'erreur de MySQL? Amicalement, Ken On peut trouver la liste français à : Liens utils : Poster un message: [EMAIL PROTECTED] S'abonner: [EMAIL PROTECTED] Se désabonner : [EMAIL PROTECTED] Ecrire au proprio : [EMAIL PROTECTED] URL sur Yahoo : http://fr.groups.yahoo.com/group/mysql-france/ - Original Message - From: Jerome JAMET [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 17, 2003 9:00 AM Subject: problème d'install de mysql sur hp-ux Bonjour , J'essai d'installer Mysql sur un serveur HP-UX B.10.20 U 9000/800 unlimited-user license, et lors du lancement de celui ci , j'ai la creation d'un fichier core /scripts/mysql_install_db[292]: 22671 Memory fault(coredump) . Y a t'il une configuration a prendre en compte au niveau de du noyau ou autre ?? Cordialement Jérôme JAMET Atos Origin Infogérance Tour Manhattan - 21ème étage 5/6 , Place de l'Iris - La Défense 2 92067 Paris La Défense Cedex Tél : 01 73 29 32 50 06 14 39 55 52 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: oracle.
Some people have already mentioned the answer but forgot to mention one point. If you do a select owner, table_name from user_tables; It will show you all the tables you have access to, not necessarily ones owned by you. If you want to see tables you have created add a where clause WHERE owner = 'YOUR NAME' If you want to see all the tables in the database use dba_tables but you'll need to be granted access to it. Dave From: Anil Garg [EMAIL PROTECTED] Date: 2003/03/17 Mon PM 12:34:32 EST To: [EMAIL PROTECTED] Subject: oracle. hi, m a frequent user of mysql. i was trying to use show tables on oracle(sql), but it dint work :( How do list tables in oracle? Thanks anil. p.s. sorry for the out of list question. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
The error on compiling the MySQL source
I'm trying to compile MySQl 4.0.12 from BK three... and the error is: Making all in libmysql make[2]: Entering directory `/temp/mysql-development/mysql-4.0/libmysql' source='libmysql.c' object='libmysql.lo' libtool=yes \ depfile='.deps/libmysql.Plo' tmpdepfile='.deps/libmysql.TPlo' \ depmode=gcc /bin/sh ../depcomp \ @LIBTOOL@ --mode=compile gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql4\ -DDATADIR=\/usr/local/mysql4/var\ -DSHAREDIR=\/usr/local/mysql4/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I. -I. -I.. -I./../include -I../include -I./.. -I.. -I.. -g -O -DDBUG_ON -DSAFE_MUTEX -O6 -mpentiumpro -c -o libmysql.lo `test -f libmysql.c || echo './'`libmysql.c ../depcomp: @LIBTOOL@: command not found make[2]: *** [libmysql.lo] Error 127 make[2]: Leaving directory `/temp/mysql-development/mysql-4.0/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/temp/mysql-development/mysql-4.0' make: *** [all] Error 2 on make command. My system is Linux 2.4.21-pre5-ac3 The last bk pull is: 16:20 today sql,query - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 --ICQ : 221602060 $ look into my eyes Phone : +55 041 296-2311 r.112 look: cannot open my eyes Fax : +55 041 296-6640 - Reply: [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: mySQL activity logging on a dual prozessor maschine
Hi again Peter, I talk about processes which running in milliseconds. I don't know what to say further.Anyhow, i guess(...in my opinion) this happened because of processing time(especially that you have to 2 CPU mounted in your system).I think is not other reason because MYSQL, purely read the time from the system and write to the log file.The question is : When ? Best regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Peter Stoehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Gelu Gogancea [EMAIL PROTECTED] Sent: Monday, March 17, 2003 6:28 PM Subject: RE: mySQL activity logging on a dual prozessor maschine Hi again, I don't think, that there are longer or shorter processes. Since I installed the 2nd CPU (933MHz for Compaq ProLaint380), I have these logenties. For example, I have a site, which supports more languages (at this time english and german only). On one site, I installed a JavaScript-Calender and the name of the months will be selected from the database in the correct language the customer wanted it. The mysql-logs look like this, when I called the calender and the name of month should be in german: 030317 16:09:54 22669 Init DB calenderDB 22669 Query SELECT de FROM general_lang WHERE def = 'jan' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'feb' 030317 16:09:54 22669 Query SELECT de FROM general_lang WHERE def = 'mar' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'apr' 22669 Query SELECT de FROM general_lang WHERE def = 'mai' 030317 16:09:54 22669 Query SELECT de FROM general_lang WHERE def = 'jun' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'jul' 030317 16:09:54 22669 Query SELECT de FROM general_lang WHERE def = 'aug' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'sep' 030317 16:09:54 22669 Query SELECT de FROM general_lang WHERE def = 'okt' 22669 Query SELECT de FROM general_lang WHERE def = 'nov' 030317 16:09:58 22669 Query SELECT de FROM general_lang WHERE def = 'dez' I don't think, that selecting the german word for february, april and july needs more cpu than march, june or october. There is also another thing; I in one database some ISO short forms, which stands for some languages. For example: de - german, en - english, it - italian and so on. So, if one customer wants to see details of one person which works for our office, he maybe doesn't know the meaning of de, en, it. So this shortforms will also translated to his prefered language. The mysql-logs looks like this: 030317 15:20:58 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'en' 030317 15:20:57 22560 Query SELECT en FROM general_lang WHERE def = 'englisch' 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'hr' 030317 15:21:00 22560 Query SELECT en FROM general_lang WHERE def = 'kroatisch' 030317 15:20:57 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'fr' 030317 15:21:00 22560 Query SELECT en FROM general_lang WHERE def = 'franzoesisch' 030317 15:20:57 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'it' 030317 15:21:00 22560 Query SELECT en FROM general_lang WHERE def = 'italienisch' 030317 15:20:57 22560 Query SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'ru' 030317 15:21:00 22560 Query SELECT en FROM general_lang WHERE def = 'russisch' A PHP script split the language-string which was for this example: en,hr,fr,it,ru. Then the script initialize a mysql query (look for the definition of _en_). mysql sends back: _englisch_. Then the script initialize a translation query (look for the english word for _englisch_). mysql send back _english_. Only after this steps, the php-script starts again with _hr_ and so on. So when mysql made the logentry _SELECT en FROM general_lang WHERE def = 'englisch'_, mysql got the the query result from _SELECT def FROM lang_sprachkuerzel WHERE isoKuerzel = 'en'_. But this query result was in the past and not in the future. That's the funny thing I'm thinking of. Before I upgraded my server with the 2nd cpu, the logs where _normal_. Rgds, Peter -Original Message- From: Gelu Gogancea [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 4:48 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mySQL activity logging on a dual prozessor maschine Hi Peter, - Original Message - From: Peter Stoehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Gelu Gogancea [EMAIL PROTECTED] Sent:
Re: AW: EMS MySQL Manager for Linux 1.15 released!
Absent a list for MySQL-centred products their support, I appreciate occasional product book announcements. PB - 1. They only post when it deals with new software or upgrades which is less than once per quarter (if that). 2. The information involves mySQL. 3. We find the posts helpful and not SPAM. Thank you. At 05:27 PM 3/17/2003 +0100, you wrote: Hi, is anyone interested in commercial use/spam of this list? If not, I would prefer to throw them out of the list. Regards, Reiner -Ursprungliche Nachricht- Von: EMS HiTech Team [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. Marz 2003 17:05 An: [EMAIL PROTECTED] Betreff: EMS MySQL Manager for Linux 1.15 released! EMS HiTech company is very glad to announce MySQL Manager for Linux 1.15 -- the next version of our powerful MySQL administration and development tool! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: EMS MySQL Manager for Linux 1.15 released!
Why such a hater? This is not SPAM. It's totally relevant to this list, and I for one am glad to see all new mySQL related products announced here. In fact, I just set them color coded to green in my Outlook, so that EMS's post will be highlighted for me in the future. d -Original Message- From: Rusch (ext) Reiner [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 8:28 AM To: [EMAIL PROTECTED] Subject: AW: EMS MySQL Manager for Linux 1.15 released! Hi, is anyone interested in commercial use/spam of this list? If not, I would prefer to throw them out of the list. Regards, Reiner -Ursprungliche Nachricht- Von: EMS HiTech Team [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. Marz 2003 17:05 An: [EMAIL PROTECTED] Betreff: EMS MySQL Manager for Linux 1.15 released! EMS HiTech company is very glad to announce MySQL Manager for Linux 1.15 -- the next version of our powerful MySQL administration and development tool! You can download the latest version and user's guide from http://www.mysqlmanager.com/download.phtml What's new in version 1.15? 1. Export Data Dialog: export to PDF added. Now you can export data to one of the most popular document formats as well as to the other supported formats. 2. Export Data Dialog - export to HTML: a possibility of customizing navigation links for multi-file export and a possibility to define a background picture for the result table added. 3. Import Data Wizard: import modes are implemented - now you can define an action to be executed with the concurrent records in the source file and the target table. You can either update these records, delete them, insert only new records, and more. For these purpose you should define key columns as primary key. 4. Import Data Wizard: added a possibility of defining a way to add data to the destination table - insert or append. 5. Several small improvements and minor bugfixes. What is MySQL Manager? EMS MySQL Manager provides powerful tools for MySQL Server administration and object management. Its Graphical User Interface (GUI) allows you to create/edit all MySQL database objects in a simple and direct way, run SQL scripts, manage users and administer user privileges, extract, print, and search metadata, create database structure reports in HTML format, export/import data, and supplies many more services that will make your work with the MySQL server as easy as it can be... Don't forget to check out other our products: http://www.ems-hitech.com/sqlmanagers Powerful database administration tools for InterBase/FireBird, MySQL and PostgreSQL servers http://www.ems-hitech.com/sqlutils/ Cross-platform data management utilities http://www.ems-hitech.com/components/ Powerful components for Delphi/C++ Builder developers We hope you'll like our products. Thank you for your attention. Best Regards, EMS HiTech Team http://www.ems-hitech.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
odd user/permissions/table access problem
I just upgraded to mysqladmin Ver 8.23 Distrib 3.23.55, for apple-darwin6.3 on powerpc from 3.23.52. Both packages are via Marc Liyanage's binary distribution from http://www.entropy.ch/. following the upgrade, one (and only one) of the databases is affected such that its' user access is disrupted. --- Error (1044) : Access denied for user: '[EMAIL PROTECTED]' to database 'primaryuserdatabase' --- root-level or widely privileged users can access the database without difficulty. if a given user, with tight access to another database, is granted access to the database, the granted access will not work, and the user access request will generate this error: --- Error (1044) : Access denied for user: '[EMAIL PROTECTED]' to database 'primaryuserdatabase' --- I've established to my own satisfaction that this problem is specific to primaryuserdatabase; however, I don't understand why top-level users with global privs can access the database when the restricted users cannot. please advise, and feel free to request more data. Thank you for your time! -- Mike Whybark - [EMAIL PROTECTED] http://mike.whybark.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: Recent crash with 3.23.56
Linux systems normally run with file locking off. With NFS shares, this can allow the server to read the index file as it is being updated. This can cause the crash make sure you don't use --skip-locking. root wrote: Description: I installed the most recent rpm for RedHat Linux 7.2. After running for no more than 10 minutes, it crashed. safe_mysqld failed to restart the daemon. How-To-Repeat: I don't know. Here is all the information I have on the problem: Stack Trace: 0x806fc04 char_val + 44 0x8121588 _ufc_doit_r + 184 0x80d8d28 remove_key + 220 0x80d9cab nisam_create + 2491 0x80e2f17 mi_lock_database + 1031 0x80e2fb9 mi_copy_status + 1 0x80e2fb9 mi_copy_status + 1 0x80e313f _mi_writeinfo + 79 0x80e306a _mi_readinfo + 122 0x80bb82c mysql_load__FP3THDP12sql_exchangeP13st_table_listRt4List1Z4Item15enum_duplicatesb13thr_lock_type + 1052 0x80b1c8b optimize__9ha_myisamP3THDP15st_ha_check_opt + 111 0x80b3157 create__9ha_myisamPCcP8st_tableP24st_ha_create_information + 1547 0x80aeb25 make_sortkey__FP13st_sort_paramPUcPc + 589 0x808efb8 create_tmp_field__FP8st_tableP4ItemQ24Item4TypePPP17Item_result_fieldPP5FieldbT5 + 836 0x808d676 make_join_readinfo__FP4JOINUi + 862 0x8076860 add_join_on__FP13st_table_listP4Item + 64 0x807a91c yyparse__Fv + 15644 0x8075a15 mysql_init_query__FP3THD + 137 0x8074db7 mysql_execute_command__Fv + 10163 Query in log: thd-query at 0x8382ec0 = SELECT challenge FROM ladder_rules WHERE ladder='dartpros' thd-thread_id=1915 I should note that ladder_rules is actually a symlinked file to another file on an NFS share. We do this on all machines that are read-only queries for that table. Fix: Submitter-Id: submitter ID Originator: root Organization: Mikel Tidwell, Case's Ladder MySQL support: none Synopsis: mysqld crash Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.56 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.56, for pc-linux on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.56 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 8 min 13 sec Threads: 9 Questions: 10938 Slow queries: 13 Opens: 156 Flush tables: 1 Open tables: 150 Queries per second avg: 22.187 Environment: System: Linux cgi3 2.4.7-10smp #1 SMP Thu Sep 6 17:09:31 EDT 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/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Apr 5 2002 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x2 root root 1282588 Sep 4 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 Sep 4 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 4 2001 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--without-innodb' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' '--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--with-comment=Official MySQL RPM' 'CC=gcc' 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' 'CXX=gcc' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Problems with the api c++
Hello! I have problems in compiling my program which uses the mysql++-library. I have red hat 8.0, gcc-3.2-7, gcc-c++-3.2-7 and mysql++-1.7.9-3.rh8x.i386.rpm. When I use the command g++ -I/usr/include/sqlplus myfirstdatabaseprogram.cpp, I get several basic errors concerning the include file sqlplus.hh (for example, semicolon is missing from exceptions.hh 134 and so on). Could somebody tell me what would be the solution. I have istalled the mysql++- package with rpm -i -commmand. Tuomas Heroja [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: AW: EMS MySQL Manager for Linux 1.15 released!
Agreed... Pat... - Original Message - From: Peter Brawley [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 17, 2003 2:52 PM Subject: Re: AW: EMS MySQL Manager for Linux 1.15 released! Absent a list for MySQL-centred products their support, I appreciate occasional product book announcements. PB - 1. They only post when it deals with new software or upgrades which is less than once per quarter (if that). 2. The information involves mySQL. 3. We find the posts helpful and not SPAM. Thank you. At 05:27 PM 3/17/2003 +0100, you wrote: Hi, is anyone interested in commercial use/spam of this list? If not, I would prefer to throw them out of the list. Regards, Reiner -Ursprungliche Nachricht- Von: EMS HiTech Team [mailto:[EMAIL PROTECTED] Gesendet: Montag, 17. Marz 2003 17:05 An: [EMAIL PROTECTED] Betreff: EMS MySQL Manager for Linux 1.15 released! EMS HiTech company is very glad to announce MySQL Manager for Linux 1.15 -- the next version of our powerful MySQL administration and development tool! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Problem matching on only part of a field
I've been reading through documentation (including the O'Reilly book links on the mysql.com website), and I'm sure this is simple, but I can't seem to find it. I'm managing a mailing list for a client and I want to match on United States zip codes that correspond to different areas. (For non-US residents, the USPS used a 5 digit system for decades, then started a +4 system, which added 4 more digits to the original, so if your old zip was 12345, that would still work, but you could add 4 more digits to help for faster sorting -- like 12345-6789.) I'm using 2 tables, MailingList and ZipCodes. In MailingList I have the regular exepected columns -- Name, Street, City, State, and Zip. In ZipCodes I have ZipCodes, Name, District. The name is for the area the zip code covers and the district is the city or county it is in. For example, I am in the Bon Air zip code, but I'm in Chesterfield County, so the Name is Bon Air, but the District is Chesterfield. I want to be able to select all the names in MailingList in a specific county. Here is what I tried first: SELECT Name, City, Zip FROM MailingList AS M, ZipCodes AS Z, WHERE (M.Zip = Z.ZipCodes) AND (Z.District = Chesterfield); I did this and it pulled out 1 name, so I looked and realized a LOT of records had Zip+4, so they were 9 digit zip codes. So I tried to match only the first 5 characters of the Zip and ZipCode fields like this: SELECT Name, City, Zip FROM MailingList AS M, ZipCodes AS Z, WHERE ( left(M.Zip, 5) = left(Z.ZipCodes,5) ) AND (Z.District = Chesterfield); And it returns the same record, and nothing more. I tried it on 4 digits: SELECT Name, City, Zip FROM MailingList AS M, ZipCodes AS Z, WHERE ( left(M.Zip, 4) = left(Z.ZipCodes,4) ) AND (Z.District = Chesterfield); And it returned all the records it should have returned on 5 digits, but some of the records were retruned 6 times, some were returned only 1 time. So how can I select on a limited part of a field and why doesn't the 2nd line -- selecting the left 5 characters of both Zip and ZipCode work? Thank you! Hal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: odd user/permissions/table access problem
At 12:10 -0800 3/17/03, Mike Whybark wrote: I just upgraded to mysqladmin Ver 8.23 Distrib 3.23.55, for apple-darwin6.3 on powerpc from 3.23.52. Both packages are via Marc Liyanage's binary distribution from http://www.entropy.ch/. following the upgrade, one (and only one) of the databases is affected such that its' user access is disrupted. --- Error (1044) : Access denied for user: '[EMAIL PROTECTED]' to database 'primaryuserdatabase' --- root-level or widely privileged users can access the database without difficulty. if a given user, with tight access to another database, is granted access to the database, the granted access will not work, and the user access request will generate this error: --- Error (1044) : Access denied for user: '[EMAIL PROTECTED]' to database 'primaryuserdatabase' --- I've established to my own satisfaction that this problem is specific to primaryuserdatabase; however, I don't understand why top-level users with global privs can access the database when the restricted users cannot. Is the primaryuser account specified with Host value in the user table? And after the upgrade do you have an entry in the user table that has Host = localhost and User = blank? please advise, and feel free to request more data. Thank you for your time! -- Mike Whybark - [EMAIL PROTECTED] http://mike.whybark.com/ -- Paul DuBois http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: AW: EMS MySQL Manager for Linux 1.15 released!
Rusch (ext) Reiner wrote: Hi, is anyone interested in commercial use/spam of this list? If not, I would prefer to throw them out of the list. Regards, Reiner If it offends you so then set up a filter to deal with it. MySQL-related software releases can't be considered spam. Focus your attention on real spam. There's plenty to go after without taking things out on people providing software for our favourite database. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.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: AW: EMS MySQL Manager for Linux 1.15 released!
Peter Brawley wrote: Absent a list for MySQL-centred products their support, I appreciate occasional product book announcements. I agree. Bruce Feist - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
converting an existing column to auto increment
I have an table with a column numberINT NOT NULL PRIMARY KEY This table contains many records and there are gaps in the number sequence. I would like to modify this column to use the AUTO INCREMENT feature but I need to preserve the present numbering sequence (which is monotonically increasing) including the holes. It is not clear from the manual or my MySQL book exactly how to do this. Is this possible? if so what is the correct ALTER TABLE command? Thanks Liz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: buffer overflows in MySQL error messages (e.g. in 4.0.10-gamma)
Sergei Golubchik wrote: Ok, I took a look at this. (btw, this was not a diff at all, but rather tarball of new and old files. Having a real unified diff would make your changes MUCH easier to understand). Hi, I did not want to force a particular diff format on the reader; having the original and the new sources, one can run diff with any options desired... Though your changes looked innocent - that is they most probably could do no harm - I failed to understand when they'll do any good. You replaced a set of checks for buffer overflow by some other set of checks, which looked equivalent to the old one. Please, show at least one single test case where old code gets buffer overflow. First of all I must _apologize_ that in my bug report I _mixed_ remarks about the behavior of MySQL with those for MyODBC: it is in fact MyODBC which evidently does not do any overflow checks for error messages! MyODBC version 3.51.06 uses a buffer twice the original size, which in practice probably is enough to avoid the problem, though it _still_ does not do explicit checks (I have reported that). MySQL _does_ check for overflows, but _not_ 100% correctly... I will try to reproduce the problem that I observed a few weeks ago, but I will show you one problem right now. Look in mysys/my_error.c: - char ebuff[ERRMSGSIZE+20]; /* ... */ olen=(uint) strlen(tpos=my_errmsg[nr / ERRMOD][nr % ERRMOD]); endpos=ebuff; while (*tpos) { if (tpos[0] != '%') { *endpos++= *tpos++; /* Copy ordinary char */ olen++; continue; } - Now what if olen = ERRMSGSIZE+20 i.e. olen = 276? Then the above code could overflow the buffer. It would be ridiculous if an error message were that long, right? Well, the longest message in sql/share/romanian/errmsg.txt is _318_ characters long... Regards, Maarten - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB Problem
Hello, I´m having some troubles when creating the foreign key constraints in a InnoDB database. The problem is, i can create the InnoDB table, but i´m having a little difficult to make the connections with other tables. The error that apears is like that: Erro Comando SQL : alter table tab3 add constraint foreign key (cod2) references tab2 (cod2) on update cascade on delete cascade; Mensagens do MySQL : Can't create table '.\ola\#sql-52c_9e.frm' (errno: 150) Therefore, I can´t garantie the integraty of my data like it was suppose to do. I have made some modifications to the my.ini file. this was i´ve modify: innodb_data_home_dir =.\ innodb_log_arch_dir =.\ innodb_data_file_path = ibdata1:10M:autoextend set-variable = innodb_buffer_pool_size=70M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_log_file_size=20M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 I saw these instructions in the mysql help. I have the 3.23.55 version of mysql running in windows 2000 professional. Please, Help. - Email Enviado utilizando o serviço MegaMail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Indices in querys using OR...
I have trouble figuring out how the indices are used when making a query that uses OR-operator. If I have the following table: create table testing( id int unsigned not null primary key auto_increment, idx1 int unsigned not null, idx2 int unsigned not null, index(idx1), index(idx2)); In this query i expect mySQL to use one of the two indices to speed up the query, but It doesn't.. :( select * from testing where idx1=0 or idx2=1; The thing I'm thinking about instead is the following query: select * from testing where idx1=0 UNION select * from testing where idx2=1; It looks like this does speed up the query, but is this the way to go??? Is this a weaknes in mySQL or have I forgotten something? _ Hitta rätt på nätet med MSN Sök http://search.msn.se/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help with Query
I have a table that keeps track of when members of my site are mailed. The important fields in the table are: member_id, mail_id I need to write a query that will return the # of members and # of mailings, like the table below: # of mailings sent # of members --- 1 10,000 2 20,000 ...... Meaning, there are 10,000 members that have been sent 1 mailing, and 20,000 members that have been sent 2 mailings. Is this possible in one query? TIA, Daren __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.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: converting an existing column to auto increment
Hello. On Mon 2003-03-17 at 18:08:08 -0600, [EMAIL PROTECTED] wrote: I have an table with a column numberINT NOT NULL PRIMARY KEY This table contains many records and there are gaps in the number sequence. I would like to modify this column to use the AUTO INCREMENT feature but I need to preserve the present numbering sequence (which is monotonically increasing) including the holes. It is not clear from the manual or my MySQL book exactly how to do this. Is this possible? if so what is the correct ALTER TABLE command? Yes. First, make a backup of your tables. Although I don't expect any problems: Better safe than sorry. AUTO_INCREMENT columns won't reuse gaps. If you add a new value, it will be at least MAX(value)+1. Could be higher, if you deleted some rows in-between. The command is ALTER TABLE your_table MODIFY number INT NOT NULL AUTO_INCREMENT PRIMARY KEY Done. Note that if your column wouldn't be NOT NULL already and indeed contain some NULL values, I would expect them to be handled like a NULL for the AUTO_INCREMENT in a normal INSERT, i.e. it would get MAX(value)+1 (and so on for all other rows where number=NULL). As I said, this is not an issue in your current case. HTH, Benjamin. -- [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: column named force not allowed
At 15:58 +0100 3/17/03, Peter O wrote: Description: When creating a table with a column named force an error is shown and the table is not created. How-To-Repeat: When trying to do this : CREATE TABLE testcase ( force int default NULL ) TYPE=MyISAM; I get this : ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'force int default NULL, ) TYPE=MyISAM' at line 2 Is this related to the FORCE INDEX feature ? Yeah, the addition of this feature would have the effect of making FORCE a reserved wordl. You can write it using backticks: `force` -- Paul DuBois http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
store an array of double to mysql, How?
Hi. I am writing a program to do pattern recognition. I decide to use mysql to store the features calculated. The features are stored as an array of double in my c program. But now I do think about it, I don't know how. I've searched the internet, none really fit my problem. Is there a way to do this? Thank you - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: converting an existing column to auto increment
At 18:08 -0600 3/17/03, Liz Buckley-Geer wrote: I have an table with a column numberINT NOT NULL PRIMARY KEY This table contains many records and there are gaps in the number sequence. I would like to modify this column to use the AUTO INCREMENT feature but I need to preserve the present numbering sequence (which is monotonically increasing) including the holes. It is not clear from the manual or my MySQL book exactly how to do this. Is this possible? if so what is the correct ALTER TABLE command? Interesting question. My tests suggest that, yes, you can do this. But make sure you backup the table first. The statement I used was ALTER TABLE tbl_name MODIFY number INT NOT NULL AUTO_INCREMENT; Thanks Liz -- Paul DuBois http://www.kitebird.com/ sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Modifying table causes insert delayed queries to fail
Description This may be by design, but I figured I'd bring it up because it caused less-than-desirable behaviour for me. I executed an alter table query, designed to change the length of a fixed width char field to 128 from 255. The alter occured fine, with no problems, except that there were apparently some insert delayed queries that I guess were queued for execution before the alter, and tried to execute after. Since I did not remove any columns, and none of the char data that was being inserted was over 20 chars, I do not understand why the inserts failed... I noticed the problem thanks to my monitoring system telling me that the slave had stopped. How-To-Repeat: CREATE TABLE test ( id int(10) unsigned AUTO_INCREMENT, test char(255) NOT NULL default '', PRIMARY KEY(id) ); INSERT DELAYED INTO test VALUES (0, 'This is a test'); INSERT DELAYED INTO test VALUES (0, 'This is a test'); INSERT DELAYED INTO test VALUES (0, 'This is a test'); INSERT DELAYED INTO test VALUES (0, 'This is a test'); INSERT DELAYED INTO test VALUES (0, 'This is a test'); INSERT DELAYED INTO test VALUES (0, 'This is a test'); INSERT DELAYED INTO test VALUES (0, 'This is a test'); INSERT DELAYED INTO test VALUES (0, 'This is a test'); INSERT DELAYED INTO test VALUES (0, 'This is a test'); INSERT DELAYED INTO test VALUES (0, 'This is a test'); INSERT DELAYED INTO test VALUES (0, 'This is a test'); ALTER TABLE test change column text text char(128) NOT NULL default ''; If you do it all quickly enough, the problem will occur. It may not be evident unless you have a slave to fail. The slave will stop with the following error: Slave: query 'INSERT DELAYED INTO searches ( terms,category,date_created,id,modifiers ) VALUES ( 'jacob and co',0104,NOW(),0,'cat:1-4' )' partially completed on the master and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; SLAVE START; Fix: Either: 1) Execute all insert delayed queries before executing the alter table command, or 2) allow the query to execute normally after the alter IF the tables structure is not fundamentally changed. By fundamentally changed, I mean that columns that are necessary for the insert were not removed, and they didn't change type. In the case of my insert, I consider that there was no fundamental change because in a char field if I try to insert greater than char(128) characters, it is truncated and the query completes. Submitter-Id: submitter ID Originator:root Organization: MySQL support: none Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-4.0.11a-gamma (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.40 Distrib 4.0.11a-gamma, for pc-linux on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.11a-gamma-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 18 days 19 hours 30 min 14 sec Threads: 101 Questions: 9558361 Slow queries: 8453 Opens: 22074 Flush tables: 1 Open tables: 262 Queries per second avg: 5.881 C compiler:gcc (GCC) 3.1.1 C++ compiler: gcc (GCC) 3.1.1 Environment: IBM Netfinity 4500, Debian Potato System: Linux 2.4.19pre1 #2 SMP Sun Jun 30 03:54:52 CDT 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.1.1/specs Configured with: /mnt/data/gcc-3.1/gcc-3.1-3.1.1ds3/src/configure -v --enable-languages=c,c++,java,f77,proto,objc,ada --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-gxx-include-dir=/usr/include/c++/3.1 --enable-shared --with-system-zlib --enable-long-long --enable-nls --without-included-gettext --enable-clocale=gnu --enable-__cxa_atexit --enable-threads=posix --enable-java-gc=boehm --enable-objc-gc i386-linux Thread model: posix gcc version 3.1.1 Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 24 15:27 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root
subselect
does subselect work in mySQL 3.23 ...i'm trying to exceute the following query ... Select can_reg_no from candidate where (pres_org_curr_desig like '%sales%' or pres_org_curr_desig like '%marketing%') AND can_reg_no in ( Select can_reg_no from candidate where (pres_org_curr_desig like '%telecom%' or pres_org_curr_desig like '%software%')) if no! any solutions please... its urgent __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.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
subselect
does subselect work in mySQL 3.23 ...i'm trying to exceute the following query ... Select can_ID from TABLE1 where (designation like '%sales%' or designation like '%marketing%') AND can_ID in (Select can_ID from TABLE1 where (designation like '%telecom%' or designation like '%software%')) if no! any solutions please... its urgent __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with Query
This should get you close: SELECT mail_id, count(member_id) AS `# of members` FROM yourtable GROUP BY mail_id; At 18:44 -0800 3/17/03, Daren Cotter wrote: I have a table that keeps track of when members of my site are mailed. The important fields in the table are: member_id, mail_id I need to write a query that will return the # of members and # of mailings, like the table below: # of mailings sent # of members --- 1 10,000 2 20,000 ...... Meaning, there are 10,000 members that have been sent 1 mailing, and 20,000 members that have been sent 2 mailings. Is this possible in one query? TIA, Daren -- _ ____ +--+ / | / /__ _/ /_ _|Jeff Shapiro | / |/ / _ \/ __ \/ ___/ __ \/ __ `/|Photography and Graphic Design| / /| / __/ / / (__ ) / / / /_/ / |Colorado Springs, CO, USA | /_/ |_/\___/_/ /_//_/ /_/\__,_/ |www.nensha.com ||| [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: Help with Query
Jeff, That query simply gives me each mailing ID, along with the # of members associated with that mailing ID. What I NEED is to return the # of mailings sent to a member, and the number of members associated with that number. I.e., if I do: SELECT count(*) FROM member_mailings WHERE member_id = 1 That returns the number of mailings for member 1, say it's 25. That would be one tally in the 25 field for # of mailings sent. It's tough to explain, so I'm thinking I won't be able to accomplish it in one query? --- Jeff Shapiro [EMAIL PROTECTED] wrote: This should get you close: SELECT mail_id, count(member_id) AS `# of members` FROM yourtable GROUP BY mail_id; At 18:44 -0800 3/17/03, Daren Cotter wrote: I have a table that keeps track of when members of my site are mailed. The important fields in the table are: member_id, mail_id I need to write a query that will return the # of members and # of mailings, like the table below: # of mailings sent # of members --- 1 10,000 2 20,000 ...... Meaning, there are 10,000 members that have been sent 1 mailing, and 20,000 members that have been sent 2 mailings. Is this possible in one query? TIA, Daren -- _ ____ +--+ / | / /__ _/ /_ _|Jeff Shapiro | / |/ / _ \/ __ \/ ___/ __ \/ __ `/|Photography and Graphic Design| / /| / __/ / / (__ ) / / / /_/ / |Colorado Springs, CO, USA | /_/ |_/\___/_/ /_//_/ /_/\__,_/ |www.nensha.com ||| [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 __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with Query
On Mon, Mar 17, 2003 at 09:52:44PM -0800, Daren Cotter wrote: Jeff, That query simply gives me each mailing ID, along with the # of members associated with that mailing ID. What I NEED is to return the # of mailings sent to a member, and the number of members associated with that number. I.e., if I do: SELECT count(*) FROM member_mailings WHERE member_id = 1 That returns the number of mailings for member 1, say it's 25. That would be one tally in the 25 field for # of mailings sent. It's tough to explain, so I'm thinking I won't be able to accomplish it in one query? Hello Daren, Assuming that your table looks something like this: +-+---+-+-+ | ... | member_id | mail_id | ... | +-+---+-+-+ | ... | 1 | 1 | ... | | ... | 2 | 1 | ... | | ... | 3 | 1 | ... | | ... | 1 | 2 | ... | | ... | 2 | 2 | ... | | ... | 3 | 3 | ... | +-+---+-+-+ Then this query should return the information that you desire: SELECT COUNT(member_id), COUNT(mail_id) FROM member_mailings GROUP BY mail_id; Cheers! -- Zak Greant MySQL AB Community Advocate - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with Query
This seems to be doing the same thing as the previously mentioned query...simply listing all mailing IDs, along with the # of members it was sent to. I've included both queries with their results below. mysql SELECT COUNT(member_id), COUNT(mailing_id) FROM member_mailings GROUP BY mailing_id; +--+---+ | COUNT(member_id) | COUNT(mailing_id) | +--+---+ |1 | 1 | |25000 | 25000 | |1 | 1 | |25000 | 25000 | |53855 | 53855 | |53897 | 53897 | |53247 | 53247 | |15000 | 15000 | |1 | 1 | |1 | 1 | | 140901 |140901 | |1 | 1 | +--+---+ 12 rows in set (0.57 sec) mysql select mailing_id, count(*) from member_mailings group by mailing_id; ++--+ | mailing_id | count(*) | ++--+ | 1 |1 | | 2 |25000 | | 3 |1 | | 4 |25000 | | 6 |53855 | | 7 |53897 | | 8 |53247 | | 11 |15000 | | 12 |1 | | 13 |1 | | 15 | 140901 | | 16 |1 | ++--+ 12 rows in set (0.56 sec) --- Zak Greant [EMAIL PROTECTED] wrote: On Mon, Mar 17, 2003 at 09:52:44PM -0800, Daren Cotter wrote: Jeff, That query simply gives me each mailing ID, along with the # of members associated with that mailing ID. What I NEED is to return the # of mailings sent to a member, and the number of members associated with that number. I.e., if I do: SELECT count(*) FROM member_mailings WHERE member_id = 1 That returns the number of mailings for member 1, say it's 25. That would be one tally in the 25 field for # of mailings sent. It's tough to explain, so I'm thinking I won't be able to accomplish it in one query? Hello Daren, Assuming that your table looks something like this: +-+---+-+-+ | ... | member_id | mail_id | ... | +-+---+-+-+ | ... | 1 | 1 | ... | | ... | 2 | 1 | ... | | ... | 3 | 1 | ... | | ... | 1 | 2 | ... | | ... | 2 | 2 | ... | | ... | 3 | 3 | ... | +-+---+-+-+ Then this query should return the information that you desire: SELECT COUNT(member_id), COUNT(mail_id) FROM member_mailings GROUP BY mail_id; Cheers! -- Zak Greant MySQL AB Community Advocate - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.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
[MySQL] InnoDB - Updating a parent table won't update the child table
Hi all, I created 2 tables in MySQl with the following statements == CREATE TABLE employees ( emp_id INT NOT NULL AUTO_INCREMENT, emp_last_name TINYTEXT NOT NULL, emp_first_name TINYTEXT NOT NULL, emp_nick_name TINYTEXT NOT NULL, emp_date_joined DATE NOT NULL, emp_date_left DATE, emp_title TINYTEXT NOT NULL, emp_group CHAR(50), emp_address TINYTEXT NOT NULL, emp_city TINYTEXT NOT NULL, emp_phone CHAR(7) NULL, emp_mobile CHAR(7) NULL, emp_national_id CHAR(14) NOT NULL, emp_social_security CHAR(8) NOT NULL, emp_tax_ac CHAR(8) NULL, PRIMARY KEY (emp_id), KEY (emp_group), FOREIGN KEY (emp_group) REFERENCES employee_groups(grp_name) ON DELETE SET NULL ON UPDATE CASCADE ) TYPE=InnoDB COMMENT=Stores information about employees in company CREATE TABLE employee_groups ( grp_id INT UNSIGNED NOT NULL AUTO_INCREMENT, grp_name CHAR(50) NOT NULL, grp_overtime_paid BOOL NOT NULL, PRIMARY KEY (grp_id), INDEX (grp_name)) TYPE=InnoDB COMMENT=Stores group names and their properties == The field employee_groups.grp_name is 'mapped' to employees.emp_group and the referential integrity is set all the associated fileds to NULL when the parent record is DLETED and to CASCADE when the parent record is UPDATED. Creating the tables is fine. Inserting data in the tables is fine too. But when I try to update a record in employee_groups, MySQL returns the following error mysql UPDATE employee_groups SET grp_name = FOO WHERE grp_id = 1; ERROR 1217: Cannot delete a parent row: a foreign key constraint fails Why is it telling me that I'm trying to delete the record when I'm only doing a simple update? Deleting the records is ok, MySQl sets the associated fields to NULL. But the update WON'T work... Any clue? Thanks in advance Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php