Re:crashes when executing query on innodb table; probably corrupted table
Hi! In 3.23.41 there was a serious BLOB bug which corrupted the table if you updated the primary key of a long row. There was also another bug in 3.23.41 which could crash a query if you selected two long columns in the same query. There is a special page for bug reports at the InnoDB website: http://www.innodb.com/bugfixes.html That often helps in this kind of situation. These bugs are fixed in 3.23.42. Please download it and try again! Heikki Innobase Oy postgres wrote in message 9oo5et$2n6m$[EMAIL PROTECTED]... Description: This is the log file (some characters are cyrillic KOI8): Number of processes running now: 0 010924 21:57:51 mysqld restarted InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 3160039 010924 21:57:52 InnoDB: Started /usr/local/libexec/mysqld: îÁ Ó×ÑÚÉ! InnoDB: Assertion failure in thread 9226 in file btr0cur.c line 3032 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=12288 record_buffer=131072 sort_buffer=65528 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 19211 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x80c9628 0x4002c552 0x81e91fb 0x81e9350 0x81cd5dd 0x81cebff 0x8119ff4 0x810c506 0x80eda6d 0x80ed7a6 0x80e6d76 0x80cfe09 0x80d3c3d 0x80cf219 0x80ce73b Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x839fba8 = select product_id,name,size,description,price,weight,active,availability,image from products thd-thread_id=1 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 1 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash Number of processes running now: 0 010924 21:59:43 mysqld restarted InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 3160049 010924 21:59:44 InnoDB: Started /usr/local/libexec/mysqld: îÁ Ó×ÑÚÉ! InnoDB: Assertion failure in thread 9226 in file btr0cur.c line 3032 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=12288 record_buffer=131072 sort_buffer=65528 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 19211 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x80c9628 0x4002c552 0x81e91fb 0x81e9350 0x81cd5dd 0x81cebff 0x8119ff4 0x810c506 0x80f739c 0x80d0f48 0x80d3c3d 0x80cf219 0x80ce73b Stack trace seems successful - bottom reached Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x839fba8 = update products set image=NULL
RE: Oracle CONNECT BY
This will get a manager of a team which contains a team which contains individual nr 5. SELECT I.Name FROM TEAMREPORT T3 TEAMREPORT T2 TEAMREPORT T, INDIVIDUAL I, WHERE T.individualId = 5 AND t.teamid = t2.indivdualID AND t3.IndividualId = t2.teamID AND T3.IndividualID = I.IndividualID AND I.Manager = 1. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: maandag 24 september 2001 17:40 To: [EMAIL PROTECTED] Subject: Oracle CONNECT BY Howdy all... New to MySQL and I've got a question. I have an application that does a good deal of hierarchical reporting. In order to do this one of the tables in my database contains nothing more than an individuals id and the team to which that individual reports TABLE - TEAMREPORT e.g. Individual ID(PK,FK) Team ID _ |1 |123 | _ |2 |123 | _ |3 |456 | _ |4 |789 | _ |5 |789 | _ I can get much more information by linking this table to another table: TABLE - INDIVIDUAL IndividualID Date Name Manager _ |1|2001-09-01|Smith |1 | _ |2|2001-09-01|Black |0 | _ |3|2001-09-01|Anderson |1 | _ |4|2001-09-01|Paul |1 | _ |5|2001-09-01|Wells |0 | _ (The Manager field tells me if that person is the manager of the team; 1=Manager, 0=NotManager) So if I wanted to find out what team individual #4 reported to I would simply SELECT TEAMID FROM table WHERE INDIVIDUAL ID = 4. If I wanted to find out who was the manager of team 789: SELECT I.Name FROM TEAMREPORT T, INDIVIDUAL I, WHERE T.IndividualID = I.IndividualID AND Manager = 1. Of course the problem at hand is a little more complex. It is possible to have more than 1 level of hierarchy. In other words, team 789 reports to team 123. So, in plain English, Individual 5 reports to Team 789 which, in turn, reports to Team 123. What I would like to find out is, if I start with individual #5 and #5 reports to team 789, which also reports to team 123, who is the Manger of team 123 (I need the manager 2 levels up rather than 1)? Of course a subquery would be ideal in this situation, but obviously this cannot happen. I know that many subqueries can be turned into a join (or multiple join) statement but I cannot figure out that statement for the life of me. I'd hate to turn one query into two, but at this point my SQL inexperience is forcing me to do so. Any SQL wizards have any ideas? If I was using Oracle, the CONNECT BY clause would be an option. Is there anything similar in MySQL? Hope this makes sense and I would love to hear any thoughts. T.J. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
[Q]How to delete recursively
Hi. I came across serious problem. There is hierarchy among groups listed below like directory structure. A(group)-B(group) | -C(group) D(group) | E(group) | F(group) I want to delete A group. This requires deletion of all child groups. Above figure is a little simple but if this tree grows large that's my problem. Would you please tell me the answer? For reference table is like this. Field Type groupname varchar(50) groupno int p_groupno int - This means parent group no. Thanks in advance!! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to add mysql to my startup
From: Bertrand TACHAGO [EMAIL PROTECTED] % cp /usr/local/mysql/support-files/mysql.server \ /etc/rc.d/init.d/mysql.server % chmod 544 /etc/rc.d/init.d/mysql.server I had done it but it doesn't work % ln -s /etc/rc.d/init.d/mysql.server \ /etc/rc.d/rc3.d/S99mysql What is the importance of this command? It links one file to another. Try this: % man ln --- Rodney Broom Programmer: Desert.Net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Info Needed to Promote MySQL!!
Adam Douglas wrote: 1. Replication between 2 sites via the internet over a VPN or just using a secure connection. Chapter 11 in the manual (p. 354 of the PDF). You're set. SSH will get you the secure connection. 2. Transaction processing capabilities with the ability to roll-back a transaction. I've been informed that the innodb table type supports transactions. 3. A Windows based interface that is easy to use, similar to Access look/feel. Others are answering this. Of course, if it's just for users to pull info out of, you could build an intranet front-end with your favorite scripting (PHP/ASP/Perl) or tag-based (Blueworld Lasso) language. 4. ODBC compliant database and drivers Lots of 'em: http://www.mysql.com/downloads/index.html 5. Ability to provide connections to website via PHP And it does it extremely well and blazing fast. 6. Commercial support.. consultants, services, etc. Just ask on this list, plus there are links at the MySQL site. Of course, I'd wait until 4.0 is out in a week or so and then ask these questions again. The answers are sure to be even more positive then. Frank. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to add mysql to my startup
On Tue, Sep 25, 2001 at 01:16:05AM -0700, Rodney Broom wrote: From: Bertrand TACHAGO [EMAIL PROTECTED] % cp /usr/local/mysql/support-files/mysql.server \ /etc/rc.d/init.d/mysql.server % chmod 544 /etc/rc.d/init.d/mysql.server I had done it but it doesn't work % ln -s /etc/rc.d/init.d/mysql.server \ /etc/rc.d/rc3.d/S99mysql What is the importance of this command? It links one file to another. Try this: % man ln Also see 'man chkconfig' and 'man ntsysv' which can simplify the maintenance of those links. For example, you should be able to run this to add mysql to the default run levels: /usr/sbin/chkconfig --add mysql.server And run this to check it: /usr/sbin/chkconfig --list mysql.server Maurice - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: last week, this week (fwd)
-Original Message- From: Adrian D'Costa [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 12:56 AM To: Mysql Mailing List Subject: last week, this week Hi, I have a table that hold a lot of information about pricing and dates. I would like to list the of differnce of prices between last week and this week. Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication
Why, when doing replication, would some queries to a replicated database get logged to the binlog, but not others? Is replication still very beta, or is it considered to be stable now? The slave of course falls behind because of the queries that don't go to the binlog versions 3.23.42 and 3.23.41, and/or mixtures of them both jason - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: My SELECT is still returning the same rows
Scott Mebberson writes: AND (words.word LIKE '%award%' OR words.word LIKE '%section%') ## - difference between 1 and 2 word search What do you mean by that comment? I can't make any real sense out of it, and it doesn't seem to have much to do with the actual query (which returns rows that contain 'award' or 'section'). AND (words.word LIKE '%award%') The only problem is, it is still returning the same rows. As in, returning rows that are exactly the same? Well, do you have any rows that contain 'award' but not 'section' and that match the other criteria? Could it be that you're confusing OR with some other operator, like XOR or AND NOT? //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Date entry problem after upgrading to MySQL 3.23.42
Hi, I've just upgraded from MySQL 3.22.32 to MySQL 3.23.42 and almost all of my date related database entry tables have broken. I have been submitting datetime's in the format 2001 09 25 11:35:00 to a standard Datetime field and now after upgrading to MySQL 3.23.42 datetime's entered in this format are appearing as -00-00 00:00:00 in the database. Entering dates as 2001-09-25 11:35:00 fixes the problem but it will take ages for me to find all entries which use this code. I have potentially hundreds of references across many sites which have been broken by this Is there a way it can be fixed at the server end ? Otherwise it may be weeks until all references to this code can be eliminated. Thanks in advance. Phil Ellett, Technimode Internet Ltd, Sheffield. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RedHat 7.1 refuses to open mysqld]
Description: I upgraded from RedHat7.0 to 7.1. Now when I start safe_mysqld it says it starts mysql with databases from /var/lib/mysql, but it can't start completelety as it says it refers to /var/mysql/mysql.sock, which does not exist. Please help. /var/mys How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Hamisi Organization: TTCL/SIMUNET MySQL support: [none | licence | email support | extended email support ] Synopsis: mysqld does not start with Linux RedHat 7.1 Severity: Priority: Category: mysql Class: Release: mysql-3.23.36 (Source distribution) Environment: System: Linux malipula.ttcl.co.tz 2.4.2-2 #1 Sun Apr 8 20:41:30 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-81) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Sep 7 15:17 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1236396 Apr 7 00:58 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 Apr 6 22:27 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 6 22:27 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --with-berkeley-db - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
need for strength
Hi We have a sophisticated Underwiting management system written in MS Access. The programs and the data are in separate mdb's. The time has come to improve the product's client/server and web strengths. We came across mysql whilst investigating MS SQL server. Can we upsize our Access database to mysql easily and continue to use the Access programs to work with the mysql data? Thank you Chris Needs Peter Jacobsohn Telek Systems - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: need for strength
Hi Yes very easy. We develop database in Access and export them to MySQL all the time. One way to do this is down load the tools that are on the web site... Note MySQL is very fast and very reliable. It has throw to get the speed a reduced SQL set. Simon -Original Message- From: Chris Needs [mailto:[EMAIL PROTECTED]] Sent: 25 September 2001 11:52 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: need for strength Hi We have a sophisticated Underwiting management system written in MS Access. The programs and the data are in separate mdb's. The time has come to improve the product's client/server and web strengths. We came across mysql whilst investigating MS SQL server. Can we upsize our Access database to mysql easily and continue to use the Access programs to work with the mysql data? Thank you Chris Needs Peter Jacobsohn Telek Systems - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
ANN: EMS MySQL Manager 0.95 released
Dear Sirs and Madams, EMS HiTech company is announcing the next version (0.95) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 0.95? 1. MySQL server of version 3.22.xx is now supported! Now you can work with previous version of MySQL server using almost all features of EMS MySQL Manager. 2. ALL EDITORS: Hyperlinks were added to all editor windows, such as SQL Script or SQL Editor. Now you can easily jump to any object of the current database just from SQL text by pressing Ctrl+Enter or mouse left button with holding a Control key on a hyperlinking object name. 3. ADD COLUMN dialogue: Insert Mode was added. Now you can add column to the table in three modes: insert last, insert first and insert after specified column. 4. SQL EDITOR: Explain Query feature is now available. Check the Explain Queries option is in Options-Environment options-Tools-SQL Editor to activate Explain mode. 5. Possibilities of Ping and Shutdown of MySQL server were added to the Service menu. 6. A few small improvements and minor bugfixes. What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development 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
Moving data from Filemaker to MySQL
Hi all, I wish to migrate some Filemaker 5 databases over to MySQL on NT. Some of the databases have hundreds of fields, so it would be great if I could export in a format that I can just import without having to pre-set all the fields. Any experience/suggestions? George Pitcher in Edinburgh _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Select Insert
Is there any way to select insert at the same time? What I want to do is select say 10 out 13 field values from one table and dump it into another table. Would it be possible to do this via a select and an insert at the same time and how exactly would the sql statement look? OR do I have to write a script and store the values in an array and go from there? Also, is there any way without me creating new tables with all its fields all the time to copy over the fields from certain tables to new tables? That is copy over its attributes, etc.? Thanks.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: need for strength
Hi We have a sophisticated Underwiting management system written in MS Access. The programs and the data are in separate mdb's. The time has come to improve the product's client/server and web strengths. We came across mysql whilst investigating MS SQL server. Can we upsize our Access database to mysql easily and continue to use the Access programs to work with the mysql data? Thank you Chris Needs Peter Jacobsohn Telek Systems Chris Peter, The code will work with slight modifications AS LONG AS the database doesn't use subselects, stored procedures, stored queries, or (I just learned - thanks, Will!) joins in updates or deletes. I had to convert a 'sophisticated' website from Access to MySQL about a year ago, and there are many times that I felt I'd be better off recreating the database from scratch. The sheer volume of data (and the extremely denormalized structure of the original db) kept me from doing just that. There is no clear-cut yes or no here. You will have to look closely at the code and the original database. Yes, it can be done, but there is the possibility of a major rewrite of your code. Good Luck! Jay Fesco - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Use of MySQL with large tables
We have a table with over 27 Million rows and have had trouble with the JDBC with large queries. Our solution has been to use loops with a more restrictive where clause. Its not mission critical so I have not investigated very sincerely. But I recently ran across the --quick option for the mysql client. We began to implement this, but noticed that it prevented large updates ( 50,000 rows) when using our application, so we had to turn it off, but it might work for you. Kevin Kotun Hydrologist Everglades National Park We are encountering two issues when using MySQL with large tables (by large, we're talking 1 million rows). Our application is written in Java and we are using the mm.mysql JDBC driver. We run our applications using both Oracle and MySQL. Below are issues that we have experienced. 1. The mm.mysql driver caches all results from a large selection in memory before returning the ResultSet to the calling method. This means that any select returning a lot of rows runs the risk of getting an OutOfMemoryError. Oracle doesn't have this problem, as the ResultSet only contains some of the rows matching the query, and more are retrieved as ResultSet.next() is called. One of our developers has already discussed the issue with Mark Matthews, and the impression seems to be that MySQL does not support true cursors. Once you start a query, you must read the entire result set before issuing any other queries. The lack of cursors seems to really limit what types of applications can be implemented using MySQL as a backend. Are there any discussions regarding the implementation of cursors which would support canceling and scrolling, or is the solution to just keep adding memory (we're running on a PII 450 w/ 128MB RAM)? 2. After we incurred problem number 1, we decided to work around it by using the LIMIT directive and retrieving the entire table in chunks of 25000 rows by issuing a series of queries. Unfortunately, each LIMIT query takes longer and longer to return results, which means the overall select proceeds in exponential time. As an example, we tried to query all of the rows for a table containing 18 columns with 1.8 million rows (on a PII 450 w/ 128M). A partial summary of the results is in the following table: Selected rows Time for this selectCumulative Time 0-24999 00:00:2900:00:29 25000-4 00:00:3000:00:59 5-74999 00:00:3200:01:31 ... 50-524999 00:05:5201:01:04 525000-54 00:06:0301:07:07 ... 100-1024999 00:11:1003:50:07 ... 1775000-179 0:27:50 14:15:34 Is this phenomena expected behavior and will it be addressed sometime in the future, or is it just the way it goes? Stephen L. Faustino Senior Software Engineer SecureLogix Corporation Direct/Vmail (210)402-9669x949 mailto:[EMAIL PROTECTED] This email is intended for the named recipient(s) only and may contain information that is privileged and/or confidential. Nothing in this email is intended to constitute a waiver of any privilege or the confidentiality of this message. If you have received this email in error, please notify me immediately by reply and delete this message. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Question about mysql server Installation
Dear Anyone I am one of the Linux user. I use the freebsd operating system. I have one main problem. After installation completed , I put the command mysql in #prompt. But some error message will shows, I don't know how to solve it. The Error message is ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.socket ' (2) Please mail me regarding this problem. One of the mysql user from India. plakshmanan __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.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
Update Logging on Windows 2000 Service
Hello I need to setup update logging for Mysql running on Windows 2000, I read in the manual that this cannot be done when you are using mysql as a service (as any startup parameters are ignored). Ideally I would like to do this, so if the machine is restarted mysql starts automatically as a service. Does anyone know if there is a craftly way to do this? Thanks for any help John. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select Insert
Hi. On Tue, Sep 25, 2001 at 08:39:01AM -0300, [EMAIL PROTECTED] wrote: Is there any way to select insert at the same time? Yes. Have a look at INSERT ... SELECT and CREATE TABLE ... SELECT in the manual. Bye, Benjamin. What I want to do is select say 10 out 13 field values from one table and dump it into another table. Would it be possible to do this via a select and an insert at the same time and how exactly would the sql statement look? OR do I have to write a script and store the values in an array and go from there? Also, is there any way without me creating new tables with all its fields all the time to copy over the fields from certain tables to new tables? That is copy over its attributes, etc.? -- [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
Errcode
When I try to alter a field in my table, I get the following error. I have all permissions. Please Help Failed to save field : SQL alter table employees modify employee_id smallint(4) unsigned not null auto_increment failed : Can't create/write to file './employees/#sql-13c_ab.frm' (Errcode: 13) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: very strange query behavior
select count(*) from members where country_id = 1 and read_array is NULL ; Daren Cotter wrote: can anybody explain this to me? mysql select count(*) from members where country_id = 1 and read_array not like '%20270%'; +--+ | count(*) | +--+ |34884 | +--+ mysql select count(*) from members where country_id = 1 and read_array like '%20270%'; +--+ | count(*) | +--+ |13554 | +--+ mysql select count(*) from members where country_id = 1; +--+ | count(*) | +--+ |63546 | +--+ 34884 + 13554 63546 This is a very important aspect of our business, can anyone offer any insight as to what may be wrong? TIA, Sincerely, Daren Cotter CEO, InboxDollars.com [EMAIL PROTECTED] http://www.inboxdollars.com (507) 382-0435 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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: Errcode
The file permissions are wrong. Log in as root change to the directory where the mysql databases are stored, and reset the file permissions. something like cd /usr/local/var/mysql #make this line where ever you databases are chown -R mysqluser * # change mysqluser to the username you use to run mysql This will set permissions on all log files and databases. Ken - Original Message - From: Wild ! [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 9:23 AM Subject: Errcode When I try to alter a field in my table, I get the following error. I have all permissions. Please Help Failed to save field : SQL alter table employees modify employee_id smallint(4) unsigned not null auto_increment failed : Can't create/write to file './employees/#sql-13c_ab.frm' (Errcode: 13) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
DBI.pm
/usr/bin/mysql_setpermission returns the following: Can't locate DBI.pm in @INC (@INC contains: ) Perl 5 is installed. What do I do? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select Insert
Hi Ashwin! Is there any way to select insert at the same time? What I want to do http://www.mysql.com/doc/I/N/INSERT_SELECT.html there? Also, is there any way without me creating new tables with all its fields all the time to copy over the fields from certain tables to new tables? That is copy over its attributes, etc.? http://www.mysql.com/doc/C/R/CREATE_TABLE.html Have a :) day! jb -- jim barchuk [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: RedHat 7.1 refuses to open mysqld]
HiHi! I upgraded from RedHat7.0 to 7.1. Now when I start safe_mysqld it says it starts mysql with databases from /var/lib/mysql, but it can't start completelety as it says it refers to /var/mysql/mysql.sock, which does not exist. Please help. /var/mys It's probably in /tmp, which you should change anyway. http://www.mysql.com/doc/P/r/Problems_with_mysql.sock.html Have a :) day! jb -- jim barchuk [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
Upgrading Mysql from 3.22 to 3.23
Hi there, Looking at upgrading from version 3.22.27 to the current release of 3.23 on Solaris 2.7 platform. We successfully built from built the 3.22.27 and looking to do the same with 3.23. Are there any gottcha's out there that I should be aware of? I looked at the Mysql documentation and see in the upgrade information on what changes there are in the new server ( http://www.mysql.com/doc/U/p/Upgrading-from-3.22.html) . I guess what I'm looking for is the upgrade instructions on how to do the upgrade (building compiling, and installing) a step by step if there is one over an existing Mysql install? Or does the install process just overwrite the old Mysql version if installed in same directory? If you need more detail let me know, Thanks in advance, Pat Pat Militzer Tech Support Supervisor Metro/MLS Inc. 11430 W North Ave Wauwatosa, WI 53226 414-778-5400 ext. 124 Fax 778-6143 email: [EMAIL PROTECTED] web site: www.metromls.com www.wihomes.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
Installation Problem with 3.23.40 on SunOS 5.6
Hi, I have exactly the same problem as a previous list user (David Kuo Fri, 6 Jul 2001 15:28:35) except I am using 3.23.40 Sorry for re-posting but I never saw any replies to his original so here it is again ... I am trying to install mySQL mysql-3.23.39-sun-solaris2.7-sparc on my solaris(sparc)2.6 box [actually SunOS 5.6 sun4u sparc SUNW, Ultra-1]. scripts/mysql_install_db ld.so.1: ./bin/my_print_defaults: fatal: libcrypt_i.so.1: open failed: No such file or directory WARNING: The host snip could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ld.so.1: ./bin/mysqld: fatal: libpthread.so.1: version `SUNW_1.2' not found required by file ./bin/mysqld) Killed Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant etc ... I have checked the environment variables contain a path to /usr/lib/ and that libpthread.so.1 exists however, there is libcrypt_i.a but NOT libcrypt_i.so.1 ... could this be it? I'm not a unix guru! David - did you get anywhere with this? Many thanks Mike Environmental Change Research Centre / ENSIS Ltd 26 Bedford Way, London. WC1H 0AP. UK - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
hi.
Hello everyone, We have been using the mysql database for our placement division of our company. I have been facing with the problem of slowness of retrieving the results from the database. Right now there are only 1000 records and it is taking quiet an amount of time to retrieve the results. What will happen in future when the records are going to increase.? I have tried using INDEX to improve the performance. But did not find any change/improvement. If anyone of u can suggest me some other means of improving the query time/ retrieving the results from the database. i shall be very thankful. waiting to hear about this. warm regards, Raj = RAJ.. __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.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: Major MySQL problem
Quickly what needs to be accomplished? On Tue, Sep 25, 2001 at 09:00:08AM -0600, Virag, Thomas wrote: Hello, The recently upgraded MySQL denies any access to my previously perfectly working database. I learned that in this version new Privilege/Grant tables have to be set up before database and table can be accessed. But I don't have access to these Grant Tables. I would like to know how to set up a database and user privileges correctly at NetKnow with this version of MySQL? Do I have access to user: root or only to my default: tvirag ? When I try to access the Grant Tables get the I get the following message: doctor: {36} % mysql -u root mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'columns_priv' Didn't find any fields in table 'db' Didn't find any fields in table 'func' Didn't find any fields in table 'host' Didn't find any fields in table 'tables_priv' Didn't find any fields in table 'user' If I try to add my user id (tvirag) to the grant tables - it is denied: GRANT command is not available. If I connect as tvirag to the database mercury (as I used to) I get the following message: mysql connect mercury; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'associator' Didn't find any fields in table 'audit' Didn't find any fields in table 'codes' Didn't find any fields in table 'contract' Didn't find any fields in table 'hits' Didn't find any fields in table 'journal' Didn't find any fields in table 'product' Didn't find any fields in table 'provider' Didn't find any fields in table 'request' Didn't find any fields in table 'session' Didn't find any fields in table 'users' Connection id:299 Current database: mercury Tables are not accessible, I can't drop and re-create tables, I can't drop and re-create database. I can't drop and re-create my own default MySQL user id. What can I do? Probably the best would be to delete my mercury database and delete and reset all my MySQL setting. Could you do this for me? Does NetKnow have some - site specific - instruction how to set up a database and MySQL user privileges? What are the assumptions and restrictions? What NetKnow will set up and what I'm supposed to set up? Thank you Thomas Virag Tel: 412-3659 -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: DBI.pm
cedric wrote: /usr/bin/mysql_setpermission returns the following: Can't locate DBI.pm in @INC (@INC contains: ) Perl 5 is installed. What do I do? This is really a perl question. But... su - perl -MCPAN -e 'install DBI' Or d/l the DBI code from your favorite CPAN mirror and install it manually. If you do not understand either of those, please direct your question to a perl list. Thanks. --Bill mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DBI on FreeBSD MySQL
Chris Aitken wrote: I am writing a perl script on FreeBSD 4.3 running PHP and MySQL, however i get the following error message when I try and use DBI to connect to a MySQL database to pull some data. Can't locate DBI.pm in @INC (@INC contains: /usr/libdata/perl/5.00503/mach /usr/libdata/perl/5.0 0503 /usr/local/lib/perl5/site_perl/5.005/i386-freebsd /usr/local/lib/perl5/site_perl/5.005 .) a t /usr/sbin/scriptname line 9. Is there something I have not installed or do i have to modify a setup file? I have installed mod_perl and p5_apache_DBI and still getting this error. Any suggestions would be welcomed. This is really a perl/BSD question but... I doubt that p5_apache_DBI is the right port. You want pure 'DBI' and 'DBD::mysql' ports. Of course you can always either d/l the source for DBI, et. all from your favorite cpan mirror or do: su - perl -MCPAN -e 'install DBI' If you have further questions, please direct them to a perl or FreeBSD list. Thanks. --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: hi.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 25 Sep 2001, kurelli rajashaker wrote: Hello everyone, We have been using the mysql database for our placement division of our company. I have been facing with the problem of slowness of retrieving the results from the database. Right now there are only 1000 records and it is taking quiet an amount of time to retrieve the results. What will happen in future when the records are going to increase.? I have tried using INDEX to improve the performance. But did not find any change/improvement. If anyone of u can suggest me some other means of improving the query time/ retrieving the results from the database. i shall be very thankful. waiting to hear about this. warm regards, Raj I think unless you provide the table definition and the query which is so slow, little help could come from the list. - -- Marco Bizzarri - Responsabile Tecnico - Icube S.r.l. Sede: Via Ridolfi 15 - 56124 Pisa (PI), Italia E-mail: [EMAIL PROTECTED] WWW: www.icube.it Tel:(+39) 050 97 02 07 Fax: (+39) 050 31 36 588 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE7sKQ4XhfyAQQVoaIRApIUAKCoEekNICS63WNSdV4d3qJUh8SPBwCeKyjq EsJ9/pe7LrBa8PUpbR5y5DE= =D0is -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
creating database
Hi there, I'm having a hard time creating a databae... My db name is pool and my mySql username is contact. This is what I did... GRANT ALL ON pool.* TO contact CREATE DATABASE pool; The result was access denied... What do I do? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can I update more than one row with UPDATE stmt.?
Dear Sirs, I have a form that gets generated based on various conditions for mysql database; it may contain one or many independent records/rows. Each row has unique id. I dont have any problem updating one record but having trouble to update multiple records with one submit button. Is there as way to update all these records/rows with one click of submit button? I am using PHPMySQL. Greatly appreciate any comments or suggestions. John _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can any one help please?
Hello, Can someone who has successfully created a MySQL database for a virtual hosting account show me how to connect! I can always connect as root ... but when I try to connect as the user its get a permission error. I went to the database and gave the user of that virtual account all permissions in the USER table in the MYSQL database. But that did not help. Here is the error I get: mysql use bcwdb; ERROR 1044: Access denied for user: '@localhost' to database 'bcwdb' I tried two ways. by the shell. This is what I get: [lindab lindab]$ mysql -u lindab -p Enter password: ERROR 1045: Access denied for user: 'lindab@localhost' (Using password: YES) and via my VBB install script .. which gives the same type error I looked in the Mysql database and I think I have each required record ie user table | localhost | lindab | host table | localhost | bcwdb | Y | Y | Y | Y ... db table | localhost | bcwdb | lindab | Y ... and the above does not seem to work I am loosing my mind thanks David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [Q]How to delete recursively
In MySQL the best (only?) solution I know of is to write a script (e.g. in perl or python) that will traverse the tree for you. e.g: select a_keys from A foreach key ( a_keys ){ select c_keys from B ... etc. delete from b where key in ( a_keys ) If you were really looking for punishment you could create a table of meta-data that descibed how the tables were related and then use that to do the cascade delete. And of course, LEFT JOIN is your friend for finding reocrds in lower tables that do not have a matching reocrod in the parent table, e.g.: SELECT b_keys FROM B LEFT JOIN A on ( common_key ) where A.common_key IS NULL;. --Bill ½ÉÃ溸 wrote: Hi. I came across serious problem. There is hierarchy among groups listed below like directory structure. A(group)-B(group) | -C(group) D(group) | E(group) | F(group) I want to delete A group. This requires deletion of all child groups. Above figure is a little simple but if this tree grows large that's my problem. Would you please tell me the answer? For reference table is like this. Field Type groupname varchar(50) groupno int p_groupno int - This means parent group no. Thanks in advance!! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Bill Adams TriQuint Semiconductor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: can any one help please?
David Iyoha wrote: and the above does not seem to work I am loosing my mind Did you do a 'mysqladmin reload' after you added the permissions? --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: can any one help please?
Hello Bill, NO! That might be it ... will try now thanks David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Bill TQO Sent: Tuesday, September 25, 2001 12:11 PM To: David Iyoha Cc: [EMAIL PROTECTED] Subject: Re: can any one help please? David Iyoha wrote: and the above does not seem to work I am loosing my mind Did you do a 'mysqladmin reload' after you added the permissions? --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Major MySQL problem
You should have acess to your own MYsql DB. Attn Mysql users, is that a change from 3.23.41 to 3.23.42? On Tue, Sep 25, 2001 at 09:32:08AM -0600, Virag, Thomas wrote: Probably the best would be to delete my mercury database and reset all my (tvirag) MySQL settings. Do I have to set up my own userid and privileges in MySQL or NetKnow does it?? I have to know this -Original Message- From: System Administrator a.k.a. The Root of the Problem [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 9:21 AM To: Virag, Thomas Cc: [EMAIL PROTECTED] Subject:Re: Major MySQL problem Quickly what needs to be accomplished? On Tue, Sep 25, 2001 at 09:00:08AM -0600, Virag, Thomas wrote: Hello, The recently upgraded MySQL denies any access to my previously perfectly working database. I learned that in this version new Privilege/Grant tables have to be set up before database and table can be accessed. But I don't have access to these Grant Tables. I would like to know how to set up a database and user privileges correctly at NetKnow with this version of MySQL? Do I have access to user: root or only to my default: tvirag ? When I try to access the Grant Tables get the I get the following message: doctor: {36} % mysql -u root mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'columns_priv' Didn't find any fields in table 'db' Didn't find any fields in table 'func' Didn't find any fields in table 'host' Didn't find any fields in table 'tables_priv' Didn't find any fields in table 'user' If I try to add my user id (tvirag) to the grant tables - it is denied: GRANT command is not available. If I connect as tvirag to the database mercury (as I used to) I get the following message: mysql connect mercury; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'associator' Didn't find any fields in table 'audit' Didn't find any fields in table 'codes' Didn't find any fields in table 'contract' Didn't find any fields in table 'hits' Didn't find any fields in table 'journal' Didn't find any fields in table 'product' Didn't find any fields in table 'provider' Didn't find any fields in table 'request' Didn't find any fields in table 'session' Didn't find any fields in table 'users' Connection id:299 Current database: mercury Tables are not accessible, I can't drop and re-create tables, I can't drop and re-create database. I can't drop and re-create my own default MySQL user id. What can I do? Probably the best would be to delete my mercury database and delete and reset all my MySQL setting. Could you do this for me? Does NetKnow have some - site specific - instruction how to set up a database and MySQL user privileges? What are the assumptions and restrictions? What NetKnow will set up and what I'm supposed to set up? Thank you Thomas Virag Tel: 412-3659 -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: can any one help please?
Hi Do you have 'the book' MySQl if so read pages 464-465. if not try deleting the anonymous entries in the user table. They can cause this error. Hope that helps Richard - Original Message - From: David Iyoha [EMAIL PROTECTED] To: Adams, Bill TQO [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: 25 September 2001 17:16 Subject: RE: can any one help please? Hello Bill, NO! That might be it ... will try now thanks David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Bill TQO Sent: Tuesday, September 25, 2001 12:11 PM To: David Iyoha Cc: [EMAIL PROTECTED] Subject: Re: can any one help please? David Iyoha wrote: and the above does not seem to work I am loosing my mind Did you do a 'mysqladmin reload' after you added the permissions? --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: creating database
Hi Look at the sample database. try this create.sql== # Change user and password to add privileges for different user. # Note that user with no hostname given is equivalent to specifying # % as the hostname. GRANT ALL ON pool.* TO contact; DROP DATABASE IF EXISTS contact; CREATE DATABASE aardwolf; === use something like the line below should do the trick :-) mysql -u root create.sql Also make sure you have deleted the anonymous users in the user data base they cause alsorts of problems Richard - Original Message - From: Jeremy Morano [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 25 September 2001 16:38 Subject: creating database Hi there, I'm having a hard time creating a databae... My db name is pool and my mySql username is contact. This is what I did... GRANT ALL ON pool.* TO contact CREATE DATABASE pool; The result was access denied... What do I do? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: creating database
Jeremy Morano writes: GRANT ALL ON pool.* TO contact CREATE DATABASE pool; The result was access denied... What do I do? A user can of course not grant himself access to things. You need to do those things as a user with global CREATE and GRANT privileges. Read the manual on how GRANT works and things may become a little clearer (although that part of the manual _does_ need more information. But _I_ ain't gonna write it. Not today, anyway.) //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sorting apples and bananas
Hello I have a table that I want to sort. I want to sort the table according to a text field that might contain text or numbers The sort results sould look like this: 50 100 aaa bbb I want the numbers to sort like numbers and text like text. I cannot split the content of the text field to a text field and a numbers field. Does anyone have an idea how to do that? Thanks, = Hanan Cohen Personal site - http://www.info.org.il (Hebrew) ***Love and Peace*** __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.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: can any one help please?
Thanks Bill, That worked. David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Bill TQO Sent: Tuesday, September 25, 2001 12:11 PM To: David Iyoha Cc: [EMAIL PROTECTED] Subject: Re: can any one help please? David Iyoha wrote: and the above does not seem to work I am loosing my mind Did you do a 'mysqladmin reload' after you added the permissions? --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can I update more than one row with UPDATE stmt.?
Hello. On Tue, Sep 25, 2001 at 03:56:30PM +, [EMAIL PROTECTED] wrote: Dear Sirs, I have a form that gets generated based on various conditions for mysql database; it may contain one or many independent records/rows. Each row has unique id. I dont have any problem updating one record but having trouble to update multiple records with one submit button. Is there as way to update all these records/rows with one click of submit button? I am using PHPMySQL. It depends. If you want to update each to different values, the answer is no. You have to use several update statements. If you want to set them all to the same value, you just have to write the WHERE clause appropriately, as you would do for an SELECT. E.g. UPDATE table1 SET value1='new_value' WHERE id=500 OR id=1000 or even better UPDATE table1 SET value1='new_value' WHERE id IN (500,1000,1050) Bye, 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
Q: problem with MySQL syntax in Apple WebObjects
Hello, I am using mm mysql JDBC driver to connect WO5 to MySQL, but I am having a problem with INSERT. It seems like WO is executing this command for inserting a new field. INSERT INTO test(ID, abc, def, ghi) VALUES (129, '', 'test', 'test') But MySQL does not understand it. It needs a space between the table and fields. This command will work INSERT INTO test (ID, abc, def, ghi) VALUES (129, '', 'test', 'test') Is this MySQL or WO's problem? Best, Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is MySQL 3.23.27 compatible with AFS 3.5 3.46?
Hi, We have MySQL 3.23.27 stalled and running on a Solaris 2.7 machine. We are planning to move our server to AFS school system (OS version is Sparc Solaris 2.7). The AFS version is 3.5 or 3.46. Is anybody know whether MySQL 3.23.27 is compatible with AFS 3.5 3.46? Can we do the moving. Have a nice day, Suping __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.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
C++ connecting to a MySQL database
HELP! I have had zero luck in finding a working example of C++ opening/connecting/anything to a MySQL database. Now before you send me to things like example.c, references I've found on mysql.com mention either things like sqlplus.hh or other .hh includes (which for some reason are not installed when we fully installed MySQL), or I find examples using mysql.h but the makefiles for them have parms in them like CC, CPPFLAGS, etc., which when I execute the makefile, it blows up saying I have no flippin' idea what CC is (or something like that ;-) ). Can someone point me to a C++ example that will work? Sincerely, George Graham [EMAIL PROTECTED] __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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: BUG: unlock tables causes hang
At 10:40 AM 9/25/2001 -0700, Jon Drukman wrote: Description: mysql apparently gets stuck when unlocking tables i have several applications that do: LOCK TABLES pv WRITE LOAD DATA LOCAL INFILE 'pageview.data' INTO TABLE pv (id,count,date) UNLOCK TABLES hmmm, i took out the LOCK and UNLOCK commands, and now it hangs on the LOAD DATA... argh. i am reverting back to an old version of mysql for now. :( -jsd- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Inserting Numeric Data with the C API
Hi, Is there anyway to do this other then copying a representation of the data into the query string? This just seems pretty inneffiecient (making an extra copy of the data) error prone (getting the representation right when you copy it to the string). Thanks Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Inserting Numeric Data with the C API
I searched pretty thoroughly for a way to access mysql data in their native field types (e.g. an int field I wouldn't have to use atoi()/itoa() on) and came up with nothing. If you are processing large amounts of data you may want to do what I did which was to make my program build a load file (and then load it, of course). I found this method had performance advantages. -Original Message- From: George Eric R Contr AFSPC/CVYZ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 3:00 PM To: [EMAIL PROTECTED] Subject: Inserting Numeric Data with the C API Hi, Is there anyway to do this other then copying a representation of the data into the query string? This just seems pretty inneffiecient (making an extra copy of the data) error prone (getting the representation right when you copy it to the string). Thanks Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
database documentation
What tools do people use to document their databases? Are there graphical tools that will generate relational diagrams of a database (like in Access)? One of the databases I've been developing is starting to grow as I add additional tables to hold different pieces of data. At the moment, my documentation comes from adding comments and CREATE statements to the result of an earlier mysqldump file. Back when I only had 7 or 8 tables, this was fine, but now my database is starting to approach 25 tables, so some of the relationships are starting to get a little hard to keep track of. Many thanks Eugene -- To put my contact info into your Palm device, click here: http://signature.coola.com/?[EMAIL PROTECTED] Personal Signature Coolet - Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology For I am a Bear of Very Little Medical University of South Carolina Brain, and long words Bother Charleston, South Carolina me. Winnie the Pooh http://home.netcom.com/~eugenem/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Inserting Numeric Data with the C API
Yea, that's about what I've come up with myself, but I thought I'd ask. I have found that the strstream class works very nicely for building queries though. If you're willing to use C++ of course. Thanks -Original Message- From: Will French [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 1:12 PM To: George Eric R Contr AFSPC/CVYZ; [EMAIL PROTECTED] Subject: RE: Inserting Numeric Data with the C API I searched pretty thoroughly for a way to access mysql data in their native field types (e.g. an int field I wouldn't have to use atoi()/itoa() on) and came up with nothing. If you are processing large amounts of data you may want to do what I did which was to make my program build a load file (and then load it, of course). I found this method had performance advantages. -Original Message- From: George Eric R Contr AFSPC/CVYZ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 3:00 PM To: [EMAIL PROTECTED] Subject: Inserting Numeric Data with the C API Hi, Is there anyway to do this other then copying a representation of the data into the query string? This just seems pretty inneffiecient (making an extra copy of the data) error prone (getting the representation right when you copy it to the string). Thanks Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: RE: Info Needed to Promote MySQL!! - Solved
What I did to handle global changes was have one access file on the fileserver that everyone had a shortcut to. That way the updates were global since they were all to the same file. How is the speed of running Queries, Forms and Reports from Access using linked tables to MySQL? I've found it quite slow. Tasks that use to take a few seconds now takes 3 minutes or more. On Mon, Sep 24, 2001 at 04:19:55PM -0600, Adam Douglas wrote: Another small research in Access made me to see the changed table structure completely. Please use this procedure to view or to refresh links when the structure or location of a linked table has changed. 1. Open the database in access that contains links to tables. 2. On the Tools menu, point to Database Utilities, and then click Linked Table Manager. 3. Select the check box for the tables whose links you want to refresh. 4. Click OK to refresh the links. All I can say is, Wow! Excellent response! Thanks! So, this solves all your problems. Let me know whether it helps you or not. Looks like it works great but how about this (smile).. Is there a way to have this update done on linked tables automatically and is it possible to have this done on a global scale. Meaning that the linked tables would work on all machines not a specific machine? Would having a general ODBC username/password setup on multiple machines resolve the problem? Sorry meant to ask this question before. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Access Links to Mysql
Hello again folks I am using MS Access as the front end to my database, but after a while of use, I get a prompt as follows, when I try to close a table in datasheet view or when I try to close a form: The action will reset the current code in break mode {blah blah blah} Then I have to choose yes or no. (I don't have any VBA code running that could be halted anyway when this happens) Either way this doesn't close the object I have open and I have to resort to killing the application from the task manager. Does anyone else have the same problem?, anyone have any ideas of how I can overcome it? Thanks for any help. John. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Inserting Numeric Data with the C API
I find that the sprintf function is quite accurate and very fast. Yea, that's about what I've come up with myself, but I thought I'd ask. I have found that the strstream class works very nicely for building queries though. If you're willing to use C++ of course. Thanks -Original Message- From: Will French [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 1:12 PM To: George Eric R Contr AFSPC/CVYZ; [EMAIL PROTECTED] Subject: RE: Inserting Numeric Data with the C API I searched pretty thoroughly for a way to access mysql data in their native field types (e.g. an int field I wouldn't have to use atoi()/itoa() on) and came up with nothing. If you are processing large amounts of data you may want to do what I did which was to make my program build a load file (and then load it, of course). I found this method had performance advantages. -Original Message- From: George Eric R Contr AFSPC/CVYZ [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 3:00 PM To: [EMAIL PROTECTED] Subject: Inserting Numeric Data with the C API Hi, Is there anyway to do this other then copying a representation of the data into the query string? This just seems pretty inneffiecient (making an extra copy of the data) error prone (getting the representation right when you copy it to the string). Thanks Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Christopher R. Jones, P.Eng. 14 Oneida Avenue Toronto, Ontario M5J 2E3 Tel. 416 203-7465 Fax. 416 203-8249 Email [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
Newsgroup ???
MySQL Gurus: Is there a newsgroup server for this discussion list? Thanks, Christopher Raymond - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Insert records in a VB5 recordset
Dear members, I'm new to MySQL and I'm using MyODBC. I can connect to my MySQL localhost from a VB5 appusing MyODBC. I can open a recordset (using RDO) and when I try to add a new record I got the following error msg: Run-time error 40069 Client Cursor: 40 - Assigned data exceeds defined column size. The value has 4 chars long and the database field is 10 chars long. In this table I have a primary key defined and a timestamp field. Any help ? Thanks to all of you. GUSTAVO. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
copy tables to another db
Hi there I was wondering how to copy tables from one db to the another? can't find it in the manual... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: copy tables to another db
There are a number of ways to do this. Not being sure exactly what you want, a live copy (replication) or a transfer (mysqldump), it's tough for me to say which method would be best. Look in the manual under mysqldump or replication and see if those fit your needs. Steve At 04:19 PM 9/25/01 -0400, Jeremy Morano wrote: Hi there I was wondering how to copy tables from one db to the another? can't find it in the manual... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: database documentation
hi. i went looking all over the place for an ER diagramming tool that could read mysql dumps, and found this: http://www.datanamic.com/importerscripts/ which will connect to a mysql database and generate a diagram, guessing the foreign key relationships. this script is not free. the program the diagram is generated for, unfortunately, is as well not free. the evaluation versions seem to work okay, overlooking the missing functionality. if you (or anyone else) finds/has found anything better i'd be interested to know. -ravi. -Original Message- From: Eugene Mah [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 3:13 PM To: [EMAIL PROTECTED] Subject: database documentation What tools do people use to document their databases? Are there graphical tools that will generate relational diagrams of a database (like in Access)? One of the databases I've been developing is starting to grow as I add additional tables to hold different pieces of data. At the moment, my documentation comes from adding comments and CREATE statements to the result of an earlier mysqldump file. Back when I only had 7 or 8 tables, this was fine, but now my database is starting to approach 25 tables, so some of the relationships are starting to get a little hard to keep track of. Many thanks Eugene -- To put my contact info into your Palm device, click here: http://signature.coola.com/?[EMAIL PROTECTED] Personal Signature Coolet - Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology For I am a Bear of Very Little Medical University of South Carolina Brain, and long words Bother Charleston, South Carolina me. Winnie the Pooh http://home.netcom.com/~eugenem/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - limits?
Hi, how can i check the performance of my mysql db? Would a MySQL DB work well as a offline machine to store a huge amount of data (up to 2.000.000 measurements) to generate time controlled output... I am a Newby in using MySQL with that big amount of data, so it would be nice if someone of u could tell me some major Problems i could get, things i have to look for or required hardware structures i do need to handle this thanx in advance bye Rüdi -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- [EMAIL PROTECTED] / [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
Features in 4.0
What will this thing have? i know Union tables will be present :) . What else? I'm very anctious to get my hands on it. thanx ^_^ ** - Deryck Henson - http://www.comp-u-exchange.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: database documentation
From: Ravi Raman [EMAIL PROTECTED] if you (or anyone else) finds/has found anything better i'd be interested to know. I've used Visio here and again, mostly V.6. It involves a lot of legwork since I have to manually deal with all of the lines representing relationships, but it creates a very nice output that I can export in many formats. I know that Visio Professional 5.0c can use some interesting relationship tools that handle most of the line manipulation between items. I've tried the same tools in later versions and they plainly didn't work (erred out). I've thought of getting and installing that older version just for the DB support. I've also looked at several levels of software on these download sites. Not even the pay-ware offerings looked worth having. My Dad sais that ERWin is very powerful and suggested that I buy myself a copy. Then I heard that it runs about 3K and opted not to. --- Rodney Broom Programmer: Desert.Net Spam filter: sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: C++ connecting to a MySQL database
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 25 Sep 2001 [EMAIL PROTECTED] wrote: HELP! I have had zero luck in finding a working example of C++ opening/connecting/anything to a MySQL database. Now before you send me to things like example.c, references I've found on mysql.com mention either things like sqlplus.hh or other .hh includes (which for some reason are not installed when we fully installed MySQL), or I find examples using mysql.h but the makefiles for them have parms in them like CC, CPPFLAGS, etc., which when I execute the makefile, it blows up saying I have no flippin' idea what CC is (or something like that ;-) ). Can someone point me to a C++ example that will work? Did you downloaded the mysql++ package? Inside there is documentation describing how to connect/query a database... Sincerely, George Graham [EMAIL PROTECTED] - -- Marco Bizzarri - Responsabile Tecnico - Icube S.r.l. Sede: Via Ridolfi 15 - 56124 Pisa (PI), Italia E-mail: [EMAIL PROTECTED] WWW: www.icube.it Tel:(+39) 050 97 02 07 Fax: (+39) 050 31 36 588 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE7sPZXXhfyAQQVoaIRAqtDAJ96tbvQIXkZM8DNZgd4TeA3V1/NwACdGRjr hU0nxKktB9ItQCjewhOAi5w= =dPQc -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
Client-side developing
Hi. Please, excuse me for this Off topic message. I want to develop Windows-based client to interact with linux-based MySQL and I can't realize the best programming language suitable for that task. Clients must be run in Windows because customer requirement. I need your suggestions. Please, excuse my bad english. Omar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Insert records in a VB5 recordset
Hi !!! -Original Message- From: Ing. Gustavo Edelstein [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 1:24 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Insert records in a VB5 recordset Dear members, I'm new to MySQL and I'm using MyODBC. I can connect to my MySQL localhost from a VB5 appusing MyODBC. I can open a recordset (using RDO) and when I try to add a new record I got the following error msg: Run-time error 40069 Client Cursor: 40 - Assigned data exceeds defined column size. The value has 4 chars long and the database field is 10 chars long. In this table I have a primary key defined and a timestamp field. Any help ? Yes, this is because of invalid( accurately, the attributes that are not supported by the driver) result set properties set by the application, is it possible for you to send the code snippet that opens the rs with all properties ? Also, verify the results by toggling Don't optimize column width option in the DSN setup. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu mailto:[EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Features in 4.0
Take a look at this :) http://www.mysql.com/doc/N/e/News-4.0.0.html I'm currently using MySQL 4.0 on two servers, and it works great :) Union seems also to work really fine now although it remains some features to be added before beeing perfect. Jocelyn Fournier Presence-PC - Original Message - From: Deryck Henson [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 11:15 PM Subject: Features in 4.0 What will this thing have? i know Union tables will be present :) . What else? I'm very anctious to get my hands on it. thanx ^_^ ** - Deryck Henson - http://www.comp-u-exchange.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: Client-side developing
On Tue, Sep 25, 2001 at 06:26:58PM -0300, Walter Omar Autalán wrote: Hi. Please, excuse me for this Off topic message. I want to develop Windows-based client to interact with linux-based MySQL and I can't realize the best programming language suitable for that task. Clients must be run in Windows because customer requirement. I need your suggestions. Please, excuse my bad english. Omar most reasonable languages have either a mysql module or a way to link with C routines, and hence to call mysql. so the best language will be the one you are the most knowledgeable about/comfortable with. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Client-side developing
From: Walter Omar Autalán [EMAIL PROTECTED] I want to develop Windows-based client to interact with linux-based MySQL and I can't realize the best programming language suitable for that task. Clients must be run in Windows because customer requirement. There's an ODBC driver for MySQL. I've had folks using it for things like Crystal Reports and it works OK. That is, I haven't seen any problems in the driver itself. However, I remember both Crystal Reports and MS Access having problems with the size of the intergers returned from MySQL. My guess from there (since I don't program outside of *NIX) would be something like C++ (MS or Borland are two big names that come to mind), or even MS Visual Basic. bashing MickySoft You remember what BASIC stands for, right? Beginner /bashing MickySoft --- Rodney Broom Programmer: Desert.Net Spam filter: sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
join optimization
I would like to make a query that give me the following result: 2 tables: call phone_number,dest_number,durantion extention phone_number,employee I would like to have the following result: phone_number, employee, total call made I'm running the following query select call.phone_number,extention.employee,count(call.Phone_number) from call left join extention on extention.phone_number=call.phone_number goup by call.phone_number. This query is taking for ever if I got 200.000 records in call. It look like it's doing the join on the call table and the grouping. Is there a way to have the geoupping done that return me 200 row and the the join. Thanks in advance for your help Philippe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Client-side developing
Delphi 6 is very good It has the advantage that you can use dbexpress and write an app which will run under windows AND linux This is what I am using (along with Visual C++ and VB) -Original Message- From: Rodney Broom [mailto:[EMAIL PROTECTED]] Sent: 25 September 2001 22:50 To: [EMAIL PROTECTED] Subject: Re: Client-side developing From: Walter Omar Autalán [EMAIL PROTECTED] I want to develop Windows-based client to interact with linux-based MySQL and I can't realize the best programming language suitable for that task. Clients must be run in Windows because customer requirement. There's an ODBC driver for MySQL. I've had folks using it for things like Crystal Reports and it works OK. That is, I haven't seen any problems in the driver itself. However, I remember both Crystal Reports and MS Access having problems with the size of the intergers returned from MySQL. My guess from there (since I don't program outside of *NIX) would be something like C++ (MS or Borland are two big names that come to mind), or even MS Visual Basic. bashing MickySoft You remember what BASIC stands for, right? Beginner /bashing MickySoft --- Rodney Broom Programmer: Desert.Net Spam filter: sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Client-side developing
At 02:56 PM 9/25/2001, Walter Omar Autalán wrote: I want to develop Windows-based client to interact with linux-based MySQL and I can't realize the best programming language suitable for that task. Clients must be run in Windows because customer requirement. Hi Walter, I have been developing tools using JPython/ JDBC/ MySQL. I have a pure backend/internals bacground, ie,very little GUI background, but using JPython (recently renamed Jython) I have been able to develop GUI apps very easily. I highly recommend it. The MM MySQL JDBC driver is pretty stable, as is zxJDBC (but I have used MM). Raj - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
compile problems
Does anyone have a solution? The following are the compiler, utils and O/S. I have tried using gun ld and the ld supplied by sun. Thanks. -Trevor [EMAIL PROTECTED] SunOS solo 5.8 Generic_108529-09 i86pc i386 i86pc gcc-3.0.1 gnu fileutils-4.1 gnu autoconf-2.50 gun automake-1.4-p5 export CC=gcc CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql --enable-assembler --with-libwrap --with-gnu-ld --with-mysqld-ldflags=-all-static make make[2]: Entering directory `/usr/local/src/mysql-3.23.42/client' /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/usr/local/src/mysql-3.23.42/include -DHAVE_RWLOCK_T -o mysqlbinlog mysqlbinlog.o ../libmysql/libmysqlclient.la -lz -lcrypt -lgen -lsocket -lnsl -lm gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/usr/local/src/mysql-3.23.42/include -DHAVE_RWLOCK_T -o .libs/mysqlbinlog mysqlbinlog.o ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lgen -lsocket -lnsl -lm -lz -lcrypt -lgen -lsocket -lnsl -lm -Wl,--rpath -Wl,/usr/local/mysql/lib/mysql mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0xc): undefined reference to `__cxa_pure_virtual' mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x1c): undefined reference to `__cxa_pure_virtual' collect2: ld returned 1 exit status make[2]: *** [mysqlbinlog] Error 1 make[2]: Leaving directory `/usr/local/src/mysql-3.23.42/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/mysql-3.23.42' make: *** [all-recursive-am] Error 2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Client-side developing
On Tue, Sep 25, 2001 at 02:50:09PM -0700, Rodney Broom wrote: From: Walter Omar Autalán [EMAIL PROTECTED] I want to develop Windows-based client to interact with linux-based MySQL and I can't realize the best programming language suitable for that task. Clients must be run in Windows because customer requirement. Have you thought about a web based app? I've successfull steered customers from an Access/MDB or VB/MDB applications to HTML based apps talking to *nix/apache/php/mysql. -- Regards, Doug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyODBC vs. iODBC
Is there any advantage of using MyODBC vs. iODBC with MySQL as the backend and M$ Access as the front end? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Client-side developing
From: Doug Poland [EMAIL PROTECTED] Have you thought about a web based app? I've successfull steered customers from an Access/MDB or VB/MDB applications to HTML based apps talking to *nix/apache/php/mysql. Here, here. I think this is the way to go if you can. --- Rodney Broom Programmer: Desert.Net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: copy tables to another db
Hi, Just dump the tables from the original database: % mysqldump -h yourhost -u root -p yourpass existing_dbname dbname.sql Then import the dump into your new database: % mysql -h yourhost -u root -p yourpass new_dbname dbname.sql Should get you started. Nick - Original Message - From: Jeremy Morano [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 25, 2001 4:19 PM Subject: copy tables to another db Hi there I was wondering how to copy tables from one db to the another? can't find it in the manual... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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??
I've just recently heard about InnoDB. Correct me if I'm wrong here but does InnoDB just enable MySQL to have transactions and row level locking? Is there more to InnoDB.. I went to the web site and didn't see any explanation of what InnoDB is other then the title on the first page. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB??
On Tue, Sep 25, 2001 at 04:11:02PM -0600, Adam Douglas wrote: : I've just recently heard about InnoDB. Correct me if I'm wrong here : but does InnoDB just enable MySQL to have transactions and row level : locking? Is there more to InnoDB.. I went to the web site and didn't see any : explanation of what InnoDB is other then the title on the first page. Well, transactions, row-level locking, multi-version concurrency. The list goes on. Oh yeah, it's blazingly fast for most applications. We've been pounding on it for a couple of months now and the performance is incredible. It's young, though. Bugs are still being found and not everything is implemented perfectly yet. * Philip Molter * DataFoundry.net * http://www.datafoundry.net/ * [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
Reset Auto Increment
Hi All, I seen a post a few days ago on how to set the auto increment value back to one after deleting all the data from a table. I suppose I could just re-create the table, but thought it be simpler to just alter the table to reset the auto increment value back to 1. what exactly is the alter syntax to reset it?? thx's mysql database Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
REGEXP and PHP Forms
Hi listfellows! Okay, I'm trying to make a form talk to a SELECT query using PHP. How do I make input from a form become a PHP variable? This is how far I've gotten: ?php function search_records() { ? form name=form1 method=post action=?php echo $PHP_SELF?action=list_recordstitle=$formtitle; ? input type=text name=$formtitleinput type=submit name=Submit value=GO /form ? } ? Now underneath this I have a function list_records() with a page that is supposed to list the records. $query = SELECT title FROM $user_tablename WHERE title REGEXP '$formtitle' $order_by_str $sort_order_str $limit_str; This will work if I tell it to select all the records and display them, but if told to use the $formtitle information it says empty (sub) expression from REGEXP. Any help is appreciated! Thanks! Nate - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't connect
At first I thought this was a MyODBC problem but further investigation proved otherwise... I can't connect to my MySQL server from a Windows box. When I run telnet server 3306, I get the following response (* is some unprintable character): D*Host '192.168.2.7' is not allowed to connect to this MySQL server I've fed the following into the 'host' table (radius is the database I want to connect to) to no avail. Yes, I remembered to FLUSH PRIVILEGES and even restarted MySQL in desperation. Any clues? +-++-+-+-+-+-+---++-+++ | Host| Db | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-++-+-+-+-+-+---++-+++ | 192.168.2.7 | radius | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | +-++-+-+-+-+-+---++-+++ Thanks all, -- Juan Carlos Castro y Castro | Standing up to an evil system is [EMAIL PROTECTED] | exhilarating. -Richard Stallman Rio de Janeiro - Brazil | http://www.vialink.com.br/~jcastro DC4DC #25 | chmod a+x /bin/laden - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: My SELECT is still returning the same rows
Hmm, the words table is just a table with an id field and a word field, the word field only contains one word in it and then the id field is that words id. There is only one word per row. The searchwords table is a long list of keywords that relate to that field, i.e. it contains the pdf id, the words, id and it's ranking. They row duplication problem is occuring when a pdf has both the words that the query is searching for. Does that make sense? Thanks Scott. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Carl Troein Sent: Tuesday, 25 September 2001 3:34 AM To: [EMAIL PROTECTED] Subject: Re: My SELECT is still returning the same rows Scott Mebberson writes: AND (words.word LIKE '%award%' OR words.word LIKE '%section%') ## - difference between 1 and 2 word search What do you mean by that comment? I can't make any real sense out of it, and it doesn't seem to have much to do with the actual query (which returns rows that contain 'award' or 'section'). AND (words.word LIKE '%award%') The only problem is, it is still returning the same rows. As in, returning rows that are exactly the same? Well, do you have any rows that contain 'award' but not 'section' and that match the other criteria? Could it be that you're confusing OR with some other operator, like XOR or AND NOT? //C -- Carl Troein - Cmrdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [Q]How to delete recursively
What I say will not help you since this is a MySQL limitation. However, on more fully-featured SQL systems, you can specify a referential constraint that will delete child rows when the parent row is deleted. You might have something like this on table C (assumes table A is the master): create table c ( groupno int not null constraint cgroup_ref references a on update cascade on delete cascade, otherfield... This creates a referential constraint between tables A and C. Now, what happens is you cannot even create a new groupno in C until it exists in A. This assures the database does not have orphaned child rows. Then, when you delete from A where groupno=1, the groupno delete will propagate downward to all tables that have a referential constraint of DELETE CASCADE automatically. (This is handled by the database engine, not the application.) One question I have about your table diagram below is: are tables A and B really joint owners of the groupno? It would be even better if a SINGLE table was the master that owned the groupno. When/if MySQL offers referential integrity, you could take advantage of the above. Don't get me wrong, I'm not disparaging MySQL. I use it on my personal website and dabbling with web applications with it and PHP. But, I work with 2 other database systems on a daily basis (DB2 and MS-SQL Server) that allow the above solution to your problem. HTH, Loyd On Tue, 25 Sep 2001 09:09:31 -0700, Adams, Bill TQO [EMAIL PROTECTED] wrote: In MySQL the best (only?) solution I know of is to write a script (e.g. in perl or python) that will traverse the tree for you. e.g: select a_keys from A foreach key ( a_keys ){ select c_keys from B ... etc. delete from b where key in ( a_keys ) If you were really looking for punishment you could create a table of meta-data that descibed how the tables were related and then use that to do the cascade delete. And of course, LEFT JOIN is your friend for finding reocrds in lower tables that do not have a matching reocrod in the parent table, e.g.: SELECT b_keys FROM B LEFT JOIN A on ( common_key ) where A.common_key IS NULL;. --Bill ½ÉÃ溸 wrote: Hi. I came across serious problem. There is hierarchy among groups listed below like directory structure. A(group)-B(group) | -C(group) D(group) | E(group) | F(group) I want to delete A group. This requires deletion of all child groups. Above figure is a little simple but if this tree grows large that's my problem. Would you please tell me the answer? For reference table is like this. Field Type groupname varchar(50) groupno int p_groupno int - This means parent group no. Thanks in advance!! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- How much would you pay for your life? More than I would take to give it up. [EMAIL PROTECTED] ICQ#504581 http://lgoodbar2.pointclark.net/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Prob mysql win2000
Upgraded win98 to win2000. Now unable to log onto mysql as previously did mysql -h localhost -u me -p. Have tried several diff host names to no avail. How can I correct? Frank - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: REGEXP and PHP Forms
Nate Fowler writes: Okay, I'm trying to make a form talk to a SELECT query using PHP. How do I make input from a form become a PHP variable? This is explained in great detail in the PHP manual at http://www.php.net form name=form1 method=post action=?php echo $PHP_SELF?action=list_recordstitle=$formtitle; ? input type=text name=$formtitleinput type=submit name=Submit value=GO This looks very very broken. Head over to the php manual and look at the examples there. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Disk-bound joins
Hi all, I have two very large tables (4 million recs each) where the records from each have a 1-to-1 relationship. They share a primary key (int) and there are no unmatched records in either table (i.e. it is a true 1-to-1). I am trying to combine a few columns from each of the two tables into a new third table. No matter what I do, the select statement process becomes disk-bound (low processor utilization despite no competition, tons of disk activity, excrutiatingly slow). Why is this? Has anyone else encountered this kind of trouble? I have gobs of memory (1.25Gb) and I am using the settings from my-huge.cnf. I have a reasonable processor - 733Mhz (not that its doing anything). I have a ATA-100 IDE hard disk, on a dedicated controller completely devoted to mysql. I am using mysql 3.23.41 on Win2k. My tables are as follows: CREATE TABLE zipwork1 ( runid int not null primary key, zip char(5), plus4 char(4), addrerr tinyint ); /* This table has 4,014,438 records */ CREATE TABLE pctwork1 ( runid int not null primary key, cnty char(3) not null, precinct char(3) not null, cd tinyint, sd tinyint, hd tinyint ); /* This table also has 4,014,438 records */ CREATE TABLE zippctmapwork ( runid int not null, zip char(5), plus4 char(4), addrerr tinyint, cnty char(3), precinct char(3), cd tinyint, sd tinyint, hd tinyint ); /* This is the table I am trying to populate (starts out empty) */ Here is my statement: INSERT INTO zippctmapwork (runid, zip, plus4, addrerr, cnty, precinct, cd, sd, hd) SELECT z.runid, z.zip, z.plus4, z.addrerr, p.cnty, p.precinct, p.cd, p.sd, p.hd FROM zipwork1 AS z INNER JOIN pctwork1 as p ON z.runid = p.runid; This is taking almost 20 minutes to execute. 20 minutes is great compared to when I try this on the 2 tables that zipwork1 and pctwork1 are originated from (zipwork1 and pctwork1 are subset tables I created to try and speed this thing up). When I ran it on the original tables, I had to kill it after 100 minutes and it had not even begun writing to the result table yet. Anyone have any ideas... anyone? Thanks in advance for your help Will French - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php