mysql updatability +JDBC2
Hi all, It is possible supports mysql 3.23.40, scrollability and updatability width JDBC2? In what terms? Regards
RE: Query Not Using Indexing
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Adam Douglas writes: Sinisa cut Alright, but is there no way then to decrease my query time of 14 seconds (includes 3 queries) to something more reasonable for use on-line? 10 seconds according to stats is the maximum limit. Maybe I'm not understanding things correctly here, but I do not have a Cartesian product since my query will only return 1 result. Cartesian is when MySQL has to match row for row when tables do not have any relations correct (in brief)? Well that doesn't make sense to me, so how long should such a task take then? I've ran it all night and still it wasn't finished, seems to be hung not just taking to long. When you have a table with 42,000+ rows it should take more then 8 hours to update no? Sinisa If it returns one row only, then I was wrong, it is not Cartesion Sinisa product. Sinisa But your query is neither 1 - N - N join, that is resolved Sinisa faster. Sinisa As I told you before you do miss some indices. Sinisa You can also speed up things by using /* STRAIGHT_JOIN */ where possible. Adam, could you email us the output of SHOW CREATE TABLE for all your tables involved in the query together with an EXPLAIN SELECT for the query in question. This should help us understand better what is going on. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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: Query Not Using Indexing
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Adam Douglas writes: cut Another thing that happens is when I tried to ALTER PostalCodeInfo and PostalCodeReps table schemas MySQL seemed to be hung and put the CPU usage at 99.0% to 99.02% (never ending it seems). Both those tables only have 42657 rows each. Any ideas why these two tables seem to hang when anything major is done on them? Funny thing is it seems to be random when you execute a query that uses these two tables. Is there something I'm missing for MySQL configuration or bad table design? I'll post the table schema's below the explain query. cut Sinisa Regarding ALTER TABLE, that is also expected behaviour, as MySQL is Sinisa re-building indices and has to use lot's of CPU. Of course the ALTER TABLE should not take forever. How long did you try this ? If MySQL really would hang doing this, we would really like to take a look a this to find out what's wrong! Please check that you don't get 'disk full' when doing the ALTER TABLE. If you are sure this is a bug, please ftp the tables to ftp://support.mysql.com/pub/mysql/secret together with a description of how to repeat the problem. Regards, Monty PS: I assume you are using MySQL 3.23.40; If not, try to upgrade before submitting the files to us! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.39 slower that 3.22.27?
Hi1 Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Liz Marlow writes: We've upgraded from 3.22.27 to 3.23.39 to utilise replication but have found that this version is significantly slower that our old version (we haven't switched replication on yet either). Has anyone else noticed this or have any suggestions to improve performance. We upgraded MySQLdb from MySQLdb-0.1.2 to MySQL-python-0.9.0 and Python from 2.0 to 2.1 at the same time but we don't think it's these. When we're running a quite large series of updates the CPU usage is at 90ish% but memory seems ok. We're running on Linux - Red Hat Linux release 6.2 (Zoot) Kernel 2.2.14-5.0 on an i686. Any suggestions gratefully accepted:-) Many thanks Liz Sinisa 3.23.39 should be MUCH faster then 3.22, provided you have converted Sinisa your tables from ISAM to MyISAM. Even if you don't convert the tables to NISAM, MySQL 3.23 should be faster in most cases. Could you find out which queries that are slower in 3.23 ? We have added lots of more optimizations to MySQL 3.23, but there may always be some case that goes a bit slower. On the other hand, MySQL 3.23 provides a lot of workarounds, like 'ignore index' to solve these. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fwd: Re: win32 build process docs (was: Re: Why can't I compile the mysql workspace?)
Hi! miguel == miguel Angel =?iso-8859-1?Q?Sol=F3rzano?= [EMAIL PROTECTED] writes: miguel At 10:08 01/08/2001 +0200, Cynic wrote: miguel Hi Cynic, Hi Miguel, I'm forwarding you this as suggested by John Dean. Can you comment? miguel First I agree with you that is necessary to introduce in our miguel literature the instructions how to build from the source the miguel MySQL Win32 stuff. miguel However in my opinion, first I need to change the workspace miguel taking out the dependencies of the clients from the servers, miguel since the today workspace was structured for build the complete miguel binary distribution. miguel About the asm files, I don't know nothing about the assembler miguel language, so I can't to say you what are the advantages to miguel take out or to maintain them in the tree. I have myself limited to miguel read the articles from Microsoft and seems to me that the code miguel developed with the older masm.exe needs to be prepared for to miguel be compiled with the new ml.exe assembler shipped with the miguel vcpp.exe or vcpp5.exe packages. I will comment this issue with miguel Monty to decide how to handle the compilation or making the instructions miguel for the people that don't have or not want to use the assembler. What's the vcpp.exe package ? Is this VC++ 6.0 ? For normal users, we should make it trivial to build without assembler. One the other hand, the best thing would be if we could get the assembler functions to build with VC++ 6.0 Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQLd won't die under Darwin (Mac OS X 10.0.4)
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Mark Tully writes: From: Mark Tully [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mySQLd won't die under Darwin (Mac OS X 10.0.4) Description: Downloaded source archive, compiled as of instructions. The mySQLd server is started as root and it switches down to the mysql user. It can be started using the mysql.server start command or by safe_mysqld --user=mysql and it appears to work fine. However it just won't die! cut Sinisa Looks like a thread - related problem to me. Sinisa Simply signals are not wroking ... Mac OS X has a bug that it the thread library doesn't send signals properly to other threads. We are talking with Apple to get hold of an Mac OS X box of our own to be able to solve this properly. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysqldump
Hi, Agent Smith wrote: Hi everybody, I got a problem with the mysqldump function. I connect to mySql trough phpMyAdmin, select the database xyz, which is the only database on the server. Then I enter the following string into the text field Run SQL query/queries on database xyz:: mysqldump xyz | mysql --host=XXX.168.XXX.14 --port=3306 --socket=/var/mysql/mysql.sock --username=X --password[X] xyz I want to copy the whole databse from one server to the other, but i always get th error message, MySQL said: You have an error in your SQL syntax near 'mysqldump catfxpboard | mysql --host=194.168.102.14 --port=3306 --socket=/var/my' at line 1 mysqldump is not an SQL command. mysqldump is a program that must be run from the command line. But I can't find a mistake there!? Can you helpp me? Thanks! -- Joseph Bueno NetClub/Trader.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: libmysqlclient[_r].so + pthreads + gdb
Vladimir Zidar writes: Description: mysql refuses connection [local/unix-socket] when client is ran under GDB, and linked with pthread library. It doesn't need to call any pthread_*() function, it just fails when linked with it. How-To-Repeat: #include stdio.h #include mysql/mysql.h main() { MYSQL m; if(mysql_connect(m, NULL, root, mysqlroot)) { printf(Connect okay\n); mysql_close(m); } else { fprintf(stderr, MYSQL:%d %s\n, mysql_errno(m), mysql_error(m)); } } gcc m2.c -o m2 -D_REENTRANT -lmysqlclient_r gdb ./m2 run This looks most likely like gdb issue. Try the latest gdb snapshot available. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fwd: Re: win32 build process docs (was: Re: Why can't I compile the mysql workspace?)
At 17:04 8/4/2001, Michael Widenius wrote the following: -- What's the vcpp.exe package ? Is this VC++ 6.0 ? I guess that's the Processor Pack. It's a free download from Microsoft that contains a free version of MASM 6.xx. For normal users, we should make it trivial to build without assembler. So I guess we are agree on this. One the other hand, the best thing would be if we could get the assembler functions to build with VC++ 6.0 I'm no big coder, but it seemed like it shouldn't be too hard to adjust the code for MASM 6.xx. See the following quote from my earlier mail to Miguel. Note: the linker problem should be fixed in Visual Studio SP 3. * The MASM program converts command-line options from MASM style to ML style, adds options to maximize compatibility, and calls ML.EXE. Note MASM.EXE is provided to maintain compatibility with old makefiles. For new makefiles, use the more powerful ML driver. Well, the free version doesn't contain masm.exe, only ml.exe. Looks like ml supercedes masm. I changed the custom build steps for strings/strings.asm and strings/strxmov.asm to reflect ml's parameter syntax, i. e. masm -Mx -t -DDOS386 -DM_I386 $(InputPath),$(Outdir)\$(InputName).obj,,, = ml -Cx -Zm -nologo -DDOS386 -DM_I386 $(InputPath) $(OutDir)\$(InputName).obj and got this: Configuration: strings - Win32 Release Performing Custom Build Step on .\Strings.asm Assembling: .\Strings.asm Microsoft (R) Incremental Linker Version 6.00.8447 Copyright (C) Microsoft Corp 1992-1998. All rights reserved. /z2 Strings.obj+ .\release\Strings.obj Strings.exe NUL LINK : warning LNK4044: unrecognized option z2; ignored LINK : fatal error LNK1181: cannot open input file Strings.obj+ Error executing c:\winnt\system32\cmd.exe. mysqld-nt.exe - 1 error(s), 1 warning(s) Note the + sign appended to strings.obj name. I'm not faimiliar with VS enough to solve this. If this is solved, people interested in building MySQL on win32 machines will be able to benefit from the assembler code without the need to buy the commercial version of MASM. And that would be a Good Thing(tm), IMO. BTW, the -Zm option is required for compatibility with MASM 5.x, otherwise it emits A2032 on these lines (except ecx,P+SIZEPTR*2[ebp] is actually A2026): mov edi,P-SIZEPTR[esp] ;p1 mov edi,P-SIZEPTR[esp] ;to mov edi,P-SIZEPTR[esp] ;p1 mov edi,P-SIZEPTR[esp] ; str mov edi,P-SIZEPTR[esp] ; s1 mov ecx,P+SIZEPTR*2[ebp]; Length of memory-area mov edi,P-SIZEPTR[esp] ; EDI - s1 (see http://support.microsoft.com/support/kb/articles/Q119/8/72.asp) The index operator '[]' is now at the very top of the MASM operator precedence list, while the binary + and - operators are in the lower half. [EMAIL PROTECTED] - And the eyes of them both were opened and they saw that their files were world readable and writable, so they chmoded 600 their files. - Book of Installation chapt 3 sec 7 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help!
hi... i have a table as follows: refsmallint(5) product_refsmallint(5) ratingsmallint(1) is there any way i can get the average rating for each product_ref? for example... refp_refrating 114 215 313 415 524 625 733 832 so that i could find out that: product_ref 1, has an average rating of 4.25 product_ref 2, has an average rating of 4.5 product_ref 3, has an average rating of 2.5 and could i possibly return the 10 highest rows? any help with this would be really appreciated... jamie burns.
Re: help!
Jamie Burns wrote: hi... i have a table as follows: refsmallint(5) product_refsmallint(5) ratingsmallint(1) is there any way i can get the average rating for each product_ref? for example... refp_refrating 114 215 313 415 524 625 733 832 so that i could find out that: product_ref 1, has an average rating of 4.25 product_ref 2, has an average rating of 4.5 product_ref 3, has an average rating of 2.5 and could i possibly return the 10 highest rows? any help with this would be really appreciated... jamie burns. Hi, From MySQL documentation: AVG(expr) Returns the average value of expr: mysql select student_name, AVG(test_score) from student GROUP BY student_name; Regards -- Joseph Bueno NetClub/Trader.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with mysqldump
Dear Agent Smith, as said, mysqldump is a command line program, not an SQL command. In PhpMyAdmin, use the CSV or SQL dump function built in. To dump a database, select the database (left frame), then click dump database (right frame), best with options structure and data, with drop table statement and save to file. When prompted, select a file name on your local machine. Then have a look at the file on your machine, and you will find you have a perfect dump to import whereever you need it :) Regards, Stefan Hinz (Geschäftsleitung) iConnect e-commerce solutions GmbH www.iConnect.de - www.js-webShop.de TEL +49 30 46307-382 - FAX -388 --- - Original Message - From: Agent Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 05, 2001 4:28 AM Subject: problem with mysqldump Hi everybody, I got a problem with the mysqldump function. I connect to mySql trough phpMyAdmin, select the database xyz, which is the only database on the server. Then I enter the following string into the text field Run SQL query/queries on database xyz:: mysqldump xyz | mysql --host=XXX.168.XXX.14 --port=3306 --socket=/var/mysql/mysql.sock --username=X --password[X] xyz I want to copy the whole databse from one server to the other, but i always get th error message, MySQL said: You have an error in your SQL syntax near 'mysqldump catfxpboard | mysql --host=194.168.102.14 --port=3306 --socket=/var/my' at line 1 But I can't find a mistake there!? Can you helpp me? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Command.com Statement
Hi A few weeks back someone was kind enough to mail me the settings to change the command.com statement so that I didn't have to work out of the /mysql/bin directory. I have since had a fatal pc crash, and have managed to lost the email, and the hard copy. If anyone would be so kind as to set it out again, I would be very grateful - dos statements etc are a bit before my time in computing! Many thanks in anticipation Sara
Duplicate entry for SELECT query
Hi All. Strange thing.The query below: select concat(domain,path,file) as url, title, '' as blank1, docdate, size, date as lastmod, 'keywords' as keyw, description as descr, a.ID, sum((word like 'acc')) as r, ( sum(word like 'acc')) as qu, f.ID, author, class,charset,lang,'content' as content, count(*) as suma from words as w left join aname_word as aw on w.ID=aw.wordID left join anames as a on a.ID=aw.anameID left join files as f on f.ID=a.fileID left join paths as p on p.ID=f.pathID left join domains as d on d.ID=p.domainID left join file_names as fn on fn.ID=f.file_nameID left join path_names as pn on pn.ID=p.path_nameID left join charsets as c on c.ID=f.charsetID left join classes as l on l.fileID=f.ID left join class_names as ln on ln.ID=l.classID where ((word like 'acc')) group by f.ID having qu0 order by r desc answer me with ERROR 1062 at line 1: Duplicate entry '4783' for key 1 How can it be? Regards, Ivan Lulukyan ACC Armenia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compiling error in complete.c: filename_completion_function
Hi, i get the following error when trying to compile MYSQL 3.23.40 with only the --prefix option set: complete.c: In funtion `filename_completion_function´: complete.c:1467: syntax error before `*´ complete.c:1481: `directory´ undeclared (first use in this function) complete.c:1484: `DIR´ undeclared (first use in this function) but in complete.c these lines are as follows: 1463: filename_completion_function (text,state) 1464: char *text; 1465: int state; 1466: { 1467: static DIR *directory = (DIR *)NULL; . . . 1481: if (directory) It seems as if it doesn't get the DIR type. What's wrong with this ? I've read someone else that this can be because of a missing file libread.a, but this file is located at /usr/lib/libread.a Can someone help ? Thanks, Sebastian Kayser
Re: Command.com Statement
Sara ... Not sure what you're looking for, but I would put MYSQL\BIN in the DOS path ... PATH=%PATH%;C:\MYSQL\BIN There are a number of command-line optiosn with COMMAND.COM, but I'm not sure how any might relate to MySQL ... COMMAND [[drive:]path] [device] [/E:n] [/L:] [/U:nnn] [/P] [/MSG] [/LOW] [/Y [/[C|K] command]] [drive:]pathSpecifies the directory containing COMMAND.COM. device Specifies the device to use for command input and output. /E:nSets the initial environment size to n bytes. (n should be between 256 and 32,768). /L: Specifies internal buffers length (requires /P as well). ( should be between 128 and 1,024). /U:nnn Specifies the input buffer length (requires /P as well). (nnn should be between 128 and 255). /P Makes the new Command Interpreter permanent (can't exit). /MSGStores all error messages in memory (requires /P as well). /LOWForces COMMAND to keep its resident data in low memory. /Y Steps through the batch program specified by /C or /K. /C command Executes the specified command and returns. /K command Executes the specified command and continues running. Gerald Jensen - Original Message - From: Sara [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 05, 2001 10:38 AM Subject: Command.com Statement Hi A few weeks back someone was kind enough to mail me the settings to change the command.com statement so that I didn't have to work out of the /mysql/bin directory. I have since had a fatal pc crash, and have managed to lost the email, and the hard copy. If anyone would be so kind as to set it out again, I would be very grateful - dos statements etc are a bit before my time in computing! Many thanks in anticipation Sara - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Command.com Statement
The command is path=c:\mysql\bin * Earn a dime every time you receive email! Sign up FREE at: http://www.MintMail.com/?m=666501 * - Original Message - From: Sara [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 05, 2001 10:38 AM Subject: Command.com Statement Hi A few weeks back someone was kind enough to mail me the settings to change the command.com statement so that I didn't have to work out of the /mysql/bin directory. I have since had a fatal pc crash, and have managed to lost the email, and the hard copy. If anyone would be so kind as to set it out again, I would be very grateful - dos statements etc are a bit before my time in computing! Many thanks in anticipation Sara - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 : WELCOME to mysql@lists.mysql.com
Hi, I'd like to add a function MD5() to mysql with CREATE FUNCTION Someone can help me ? I know nothing in C 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
Limit in SELECT
Lets say i have 10.000 rows in a table and im searching for only one record(one row). Which one is faster: SELECT ... LIMIT 1 or just SELECT .. ?
Re: RE : WELCOME to mysql@lists.mysql.com
On Sun, 5 Aug 2001, SOHM Philippe wrote: Hi, I'd like to add a function MD5() to mysql with CREATE FUNCTION Someone can help me ? I know nothing in C Philippe That might be a problem if you wnat to compile in your own function. You might want to try a UDF instead. I don't use them much, but I hear they are pretty easy to write. Hope that helps. Brian Austin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 : WELCOME to mysql@lists.mysql.com
On 05-Aug-2001 SOHM Philippe wrote: Hi, I'd like to add a function MD5() to mysql with CREATE FUNCTION Someone can help me ? I know nothing in C Creating a user defined function (UDF) means compiling a shared library; most any language can be used if it supports C call/return conventions. But why 'MD5()' ? 'tis already in MySQL : mysql select md5('this'); +--+ | md5('this') | +--+ | 9e925e9341b490bfd3b4c4ca3b0c1ef2 | +--+ 1 row in set (0.00 sec) Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. (53kr33t w0rdz: sql table query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
quickie!
hi.. can someone tell me how i get the data from two tables, where table1 will have one row, and table2 will have many rows? eg: table1: idname 1barney 2fred 3wilma table2: idstudent_id subject 11 english 11 cookery 11 maths 11 science 12 woodwork 13 cookery do i have to use two queries to get all this data out in usable form? thanks, jamie.
Re: quickie!
Are you looking for: SELECT table1.name, table2.subject FROM table1, table2 WHERE table1.id=table2.student_id Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Original Message - From: Jamie Burns [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 05, 2001 2:25 PM Subject: quickie! hi.. can someone tell me how i get the data from two tables, where table1 will have one row, and table2 will have many rows? eg: table1: idname 1barney 2fred 3wilma table2: idstudent_id subject 11 english 11 cookery 11 maths 11 science 12 woodwork 13 cookery do i have to use two queries to get all this data out in usable form? thanks, jamie. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(almost) unable to compile with gcc 3.0
Description: When compiling with gcc-3.0 there are problems with libstdc++, which is not linked to the executables There also seems to be a problem with libwrap, who is complaining about functions being called with wrong number of arguments (this is not a prob with 2.95.4) How-To-Repeat: Compile mysql with gcc 3.0 Fix: set LDFLAGS=-lstdc++ Originator:Dennis Haney MySQL support: none Synopsis: (almost) unable to compile with gcc 3.0 Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.36 System: Linux cine 2.4.4-k7 #1 Sun Apr 29 13:48:07 EST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.0/specs Configured with: ../src/configure -v --enable-languages=c,c++,java,f77,proto,objc --prefix=/usr --infodir=/share/info --mandir=/share/man --enable-shared --with-gnu-as --with-gnu-ld --with-system-zlib --enable-long-long --enable-nls --without-included-gettext --disable-checking --enable-threads=posix --enable-java-gc=boehm --with-cpp-install-dir=bin --enable-objc-gc i386-linux Thread model: posix gcc version 3.0 (Debian) Compilation info: CC='gcc' CFLAGS='-mcpu=athlon -march=athlon -O6 -fomit-frame-pointer -g' CXX='g++' CXXFLAGS='-mcpu=athlon -march=athlon -O6 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='-lstdc++' LIBC: lrwxrwxrwx1 root root 13 Jun 25 18:46 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 1124904 Jun 10 16:50 /lib/libc-2.2.3.so -rw-r--r--1 root root 2543574 Jun 10 16:52 /usr/lib/libc.a -rw-r--r--1 root root 178 Jun 10 16:52 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --without-libwrap --enable-assembler --with-berkeley-db --without-innobase --enable-static --enable-shared --with-raid --with-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: (almost) unable to compile with gcc 3.0 Description: When compiling with gcc-3.0 there are problems with libstdc++, which is not linked to the executables There also seems to be a problem with libwrap, who is complaining about functions being called with wrong number of arguments (this is not a prob with 2.95.4) How-To-Repeat: Compile mysql with gcc 3.0 Fix: set LDFLAGS=-lstdc++ Originator:Dennis Haney MySQL support: none Synopsis: (almost) unable to compile with gcc 3.0 Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.36 System: Linux cine 2.4.4-k7 #1 Sun Apr 29 13:48:07 EST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.0/specs Configured with: ../src/configure -v --enable-languages=c,c++,java,f77,proto,objc --prefix=/usr --infodir=/share/info --mandir=/share/man --enable-shared --with-gnu-as --with-gnu-ld --with-system-zlib --enable-long-long --enable-nls --without-included-gettext --disable-checking --enable-threads=posix --enable-java-gc=boehm --with-cpp-install-dir=bin --enable-objc-gc i386-linux Thread model: posix gcc version 3.0 (Debian) Compilation info: CC='gcc' CFLAGS='-mcpu=athlon -march=athlon -O6 -fomit-frame-pointer -g' CXX='g++' CXXFLAGS='-mcpu=athlon -march=athlon -O6 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='-lstdc++' LIBC: lrwxrwxrwx1 root root 13 Jun 25 18:46 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 1124904 Jun 10 16:50 /lib/libc-2.2.3.so -rw-r--r--1 root root 2543574 Jun 10 16:52 /usr/lib/libc.a -rw-r--r--1 root root 178 Jun 10 16:52 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --without-libwrap --enable-assembler --with-berkeley-db --without-innobase --enable-static --enable-shared --with-raid --with-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request
Re: quickie!
that is the answer, but i think i was looking for something different. because i am using php, i am used to results being returned in an array, and was hoping to get this sort of thing out... $results[0]['id']// table1.id $results[0]['name']// table1.name $results[0]['subject'][0] // table2.subject $results[0]['subject'][1]// table2.subject $results[0]['subject'][2] // table2.subject i am guessing mysql doesnt have a notion of multidimensional results... i will sort them myself ;o) thanks anyway, just me trying to make things too efficient... jamie. - Original Message - From: Dennis Salguero [EMAIL PROTECTED] To: Jamie Burns [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, August 05, 2001 10:32 PM Subject: Re: quickie! Are you looking for: SELECT table1.name, table2.subject FROM table1, table2 WHERE table1.id=table2.student_id Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Original Message - From: Jamie Burns [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 05, 2001 2:25 PM Subject: quickie! hi.. can someone tell me how i get the data from two tables, where table1 will have one row, and table2 will have many rows? eg: table1: idname 1barney 2fred 3wilma table2: idstudent_id subject 11 english 11 cookery 11 maths 11 science 12 woodwork 13 cookery do i have to use two queries to get all this data out in usable form? thanks, jamie. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Command.com Statement
Dear Sara, was it PATH c:\mysql\bin ? This will set the DOS search path to the specified directory, so you can type mysql for instance and DOS will find mysql.exe, without changing to the specified directory with cd To permanently save the path settings, write them in c:\autoexec.bat. If there is a line there already with path ..., simply add a semicolon (;) and add the mysql-bin-path, something like this: PATH=c:\windows\whatever;c:\program files\whatever;c:\mysql\bin Hope that is what you were looking for, Stefan Hinz (Geschäftsleitung) iConnect e-commerce solutions GmbH www.iConnect.de - www.js-webShop.de TEL +49 30 46307-382 - FAX -388 --- - Original Message - From: Sara [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 05, 2001 5:38 PM Subject: Command.com Statement Hi A few weeks back someone was kind enough to mail me the settings to change the command.com statement so that I didn't have to work out of the /mysql/bin directory. I have since had a fatal pc crash, and have managed to lost the email, and the hard copy. If anyone would be so kind as to set it out again, I would be very grateful - dos statements etc are a bit before my time in computing! Many thanks in anticipation Sara - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Duplicate entry for SELECT query
Dear Ivan, I am full of admiration for your huge number of left joins in this query! :-) Looks quite funny to me how a SELECT can produce an error that you would expect from an INSERT query. Anyway, try to type this query into a multi-line command line (MySQL Monitor, the command line tool), and *do* use more than one line for your statement! This should at least give you (and us from the mailing list) a closer hint as to where exactly the error occurs! Regards, Stefan Hinz (Geschäftsleitung) iConnect e-commerce solutions GmbH www.iConnect.de - www.js-webShop.de TEL +49 30 46307-382 - FAX -388 --- - Original Message - From: Ivan Lulukyan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 05, 2001 6:28 PM Subject: Duplicate entry for SELECT query Hi All. Strange thing.The query below: select concat(domain,path,file) as url, title, '' as blank1, docdate, size, date as lastmod, 'keywords' as keyw, description as descr, a.ID, sum((word like 'acc')) as r, ( sum(word like 'acc')) as qu, f.ID, author, class,charset,lang,'content' as content, count(*) as suma from words as w left join aname_word as aw on w.ID=aw.wordID left join anames as a on a.ID=aw.anameID left join files as f on f.ID=a.fileID left join paths as p on p.ID=f.pathID left join domains as d on d.ID=p.domainID left join file_names as fn on fn.ID=f.file_nameID left join path_names as pn on pn.ID=p.path_nameID left join charsets as c on c.ID=f.charsetID left join classes as l on l.fileID=f.ID left join class_names as ln on ln.ID=l.classID where ((word like 'acc')) group by f.ID having qu0 order by r desc answer me with ERROR 1062 at line 1: Duplicate entry '4783' for key 1 How can it be? Regards, Ivan Lulukyan ACC Armenia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: quickie!
Dear Jamie, try a JOIN (LEFT JOIN I would suppose for your problem). Read the MySQL manual chapter 7 (look for the join syntax there). It is something like SELECT * FROM table1 LEFT JOIN table2 ON (table1.id = table2.id) Regards, Stefan Hinz (Geschäftsleitung) iConnect e-commerce solutions GmbH www.iConnect.de - www.js-webShop.de TEL +49 30 46307-382 - FAX -388 --- - Original Message - From: Jamie Burns [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 05, 2001 11:25 PM Subject: quickie! hi.. can someone tell me how i get the data from two tables, where table1 will have one row, and table2 will have many rows? eg: table1: idname 1barney 2fred 3wilma table2: idstudent_id subject 11 english 11 cookery 11 maths 11 science 12 woodwork 13 cookery do i have to use two queries to get all this data out in usable form? thanks, jamie. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: quickie!
Dear Jamie, in PHP, the mysql_query(SELECT ... LEFT JOIN ...) will return exactly what you need. Try something like WHILE ($i mysql_num_rows) { for ($j = 0; $j mysql_num_fields; $j++){ $i[$j]; } $i++; } Regards, Stefan Hinz (Geschäftsleitung) iConnect e-commerce solutions GmbH www.iConnect.de - www.js-webShop.de TEL +49 30 46307-382 - FAX -388 --- - Original Message - From: Jamie Burns [EMAIL PROTECTED] To: Dennis Salguero [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, August 05, 2001 11:48 PM Subject: Re: quickie! that is the answer, but i think i was looking for something different. because i am using php, i am used to results being returned in an array, and was hoping to get this sort of thing out... $results[0]['id']// table1.id $results[0]['name']// table1.name $results[0]['subject'][0] // table2.subject $results[0]['subject'][1]// table2.subject $results[0]['subject'][2] // table2.subject i am guessing mysql doesnt have a notion of multidimensional results... i will sort them myself ;o) thanks anyway, just me trying to make things too efficient... jamie. - Original Message - From: Dennis Salguero [EMAIL PROTECTED] To: Jamie Burns [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, August 05, 2001 10:32 PM Subject: Re: quickie! Are you looking for: SELECT table1.name, table2.subject FROM table1, table2 WHERE table1.id=table2.student_id Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Original Message - From: Jamie Burns [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, August 05, 2001 2:25 PM Subject: quickie! hi.. can someone tell me how i get the data from two tables, where table1 will have one row, and table2 will have many rows? eg: table1: idname 1barney 2fred 3wilma table2: idstudent_id subject 11 english 11 cookery 11 maths 11 science 12 woodwork 13 cookery do i have to use two queries to get all this data out in usable form? thanks, jamie. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Limit in SELECT
Lets say i have 10.000 rows in a table and im searching for only one record(one row). Which one is faster: SELECT ... LIMIT 1 or just SELECT .. The former, since MySQL stops after finding the first row. In the second query, MySQL prepares the entire result set even if you only fetch the first row. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with Domain name
I am trying to GRANT access to user [EMAIL PROTECTED] MYSQL has a problem with the white-home portion of the domain name. I have tried several ways to get around this including quoting the string. So I used the '%' to grant access but then the mm.mysql JDBC API uses xyz.white-home.com and not localhost so the authorization fails. This leads me to believe that MySQL has a basic problem with a hypnated domain name. This domain name is perfectly legal does anyone know of a fix or what I'm missing? The statement I'm using is: GRANT INSERT,UPDATE,DELETE,SELECT TO xyz.* FOR [EMAIL PROTECTED] IDENTIFIED BY 'a'; I get error 1064: you have an error in your SQL syntax near -white.com IDENTIFIED BY 'a'' at line 1 So I enclosed the user name stuff in double quotes as well as the password and get . GRANT INSERT,UPDATE,DELETE,SELECT TO xyz.* FOR [EMAIL PROTECTED] IDENTIFIED BY a; error 1145: The host or user argument to GRANT is too long I have MySQL-3.23.36-1 rpm installed on a Redhat 7.1 linux system. Regards, Mike White [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: Problem with Domain name
On Sun, Aug 05, 2001 at 06:07:36PM -0600, Mike White wrote: I am trying to GRANT access to user [EMAIL PROTECTED] MYSQL has a problem with the white-home portion of the domain name. I have tried several ways to get around this including quoting the string. So I used the '%' to grant access but then the mm.mysql JDBC API uses xyz.white-home.com and not localhost so the authorization fails. This leads me to believe that MySQL has a basic problem with a hypnated domain name. This domain name is perfectly legal does anyone know of a fix or what I'm missing? The statement I'm using is: GRANT INSERT,UPDATE,DELETE,SELECT TO xyz.* FOR [EMAIL PROTECTED] IDENTIFIED BY 'a'; I get error 1064: you have an error in your SQL syntax near -white.com IDENTIFIED BY 'a'' at line 1 So I enclosed the user name stuff in double quotes as well as the password and get . GRANT INSERT,UPDATE,DELETE,SELECT TO xyz.* FOR [EMAIL PROTECTED] IDENTIFIED BY a; error 1145: The host or user argument to GRANT is too long Quote the user and host parts separately: 'xyz'@'xyz.white-home.com' I have MySQL-3.23.36-1 rpm installed on a Redhat 7.1 linux system. Regards, Mike White [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: Problem with Domain name
That's it! Thanks so much for the help. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 05, 2001 6:27 PM To: Mike White Cc: [EMAIL PROTECTED] Subject: Re: Problem with Domain name On Sun, Aug 05, 2001 at 06:07:36PM -0600, Mike White wrote: I am trying to GRANT access to user [EMAIL PROTECTED] MYSQL has a problem with the white-home portion of the domain name. I have tried several ways to get around this including quoting the string. So I used the '%' to grant access but then the mm.mysql JDBC API uses xyz.white-home.com and not localhost so the authorization fails. This leads me to believe that MySQL has a basic problem with a hypnated domain name. This domain name is perfectly legal does anyone know of a fix or what I'm missing? The statement I'm using is: GRANT INSERT,UPDATE,DELETE,SELECT TO xyz.* FOR [EMAIL PROTECTED] IDENTIFIED BY 'a'; I get error 1064: you have an error in your SQL syntax near -white.com IDENTIFIED BY 'a'' at line 1 So I enclosed the user name stuff in double quotes as well as the password and get . GRANT INSERT,UPDATE,DELETE,SELECT TO xyz.* FOR [EMAIL PROTECTED] IDENTIFIED BY a; error 1145: The host or user argument to GRANT is too long Quote the user and host parts separately: 'xyz'@'xyz.white-home.com' I have MySQL-3.23.36-1 rpm installed on a Redhat 7.1 linux system. Regards, Mike White [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
link errors when compiling the client
I am getting link error when I try to compile with the mysqlclient library. I tried adding -lgz at the end of my link line as the documentation suggests. It cannot find -lgz What can I do to fix this? Thanks, Caryl Rahn Senior Operations Programmer Siemens Building Technologies, Inc. Security Systems Division (954) 377-5955 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Backup Scripts
Hello:-) A few days ago, I saw a lot of questions (and solutions) to backing up Mysql Databases and tables. One question kind of struck me and I did come up with a little python script if anyone is interested that is able to backup and/or restore the entire Mysql set of Databases. This is of course dependent up the creation of Tables of type MyIsam and as far as creating the necessary direcories in the target area, it would be required that you had root access. As far as recovering, it does prompt if you want to restore mysql and midgard since those are pretty much system databases? Also, in order to restore, the user would have to have create/alter access:-) At this point in time, the script is fairly basic, tho I do plan to add a few options to it in the near future. (selective backup/restore, logging capabilities, etc). Also, there is no Gui for it right now, but it runs great via crontab for nightly mysql backups:-) (Just wish I would have put this together before I lost most of my data:-( I went thru a bit of a hassle getting most of it back, (am still rebuilding the kmysql forms). But by use of the init_db script, I at least could get mysql back online, and then the rest was (is) just a matter of data entry. At any rate, thought I would post this just in case someone would be interested:-) -- cya l8r Leon D. McClatchey mailto:[EMAIL PROTECTED] ICQ:#112341159 Consultants are mystical people who ask a company for a number and then give it back to them. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need advice in Mysql-Perl development plaform
In the past few weeks, I tried to install the below development platform in order for me to do MYSQL and PERL and PHP web applicaton offline. 1. Linux 6.0 2. Mysql (Binary Version) 3. DBI 1.68 4. gcc 2.81 5. msql-mysyql perl module However, I still can't get No.5 to install on that system. I suspect my gcc version is not appropriate for the compilation and going to download one later. Since most of my applications were developed using Dreamweaver and Flash, it is sad that I can'l use this software on Linux platform. I was wondering am I doing the right think in choosing the web development platform?? Should I installed Acive Perl and Mysql (Windows Version) instead to develop web application that will be used on a FreeBSD system?? Any comment or suggestion is welcome. Thanks in advance. Have a nice day! :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: mysql updatability +JDBC2
Hi ! -Original Message- From: razvan [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 05, 2001 12:18 PM To: [EMAIL PROTECTED] Subject: mysql updatability +JDBC2 Hi all, It is possible supports mysql 3.23.40, scrollability and updatability width JDBC2? In what terms? Yes. Please download the latest version of MMMySQL JDBC Driver 2.0.6 from http://mmmysql.sourceforge.net. In this release you can also find the following two samples in 'testsuite' directory, which demonstrates the usage of scrolling and RS update. -- traversal.java ( for scrolling) -- updatability.java (RS update). Hope this helps you. Regards venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Redwood city, 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