Re: median function?
Michael writes: > Umm does this mean there is no way to do what I need? Is it inappropiate > to ask if it'd be difficult for such a function to be added into MySQL if > it is the case that this is an impossible thing to do (or even just very > challenging)? A median is a very common function to need in accounting I > think. Thanks. > > > *^*^*^* > Michael McGlothlin <[EMAIL PROTECTED]> > http://mlug.missouri.edu/~mogmios/projects/ No, it is very easy to do. Add it as an UDF. This will not work on server running on Windows, though. Take a look at udf_example.cc in sql/ subdir of the source. Most notably, analyse : CREATE AGGREGATE FUNCTION avgcost RETURNS REAL SONAME "udf_example.so"; -- 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: mysqldump: problem/question
Weaver, Walt writes: > I knew it. Nobody bothered to read my post. > > The original problem involved running a lightweight version of mysqldump in > a simulated nanokernel environment with reduced power resources. The > ultimate result, we hope, is to use it to record Quidditch matches being > played in Afghanistan. > > Thanks, > > --Walt Weaver > Bozeman, Montana, USA > I hope you have found --quick option. Sorry, but what is Quidditch ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: median function?
Christopher R. Jones writes: > Correct > The mean (average) depends on the distribution. If the distribution is > either positively or negatively skewed, then the median will not equal the > mean. The median of an ordered list is the middle value if the number of > elements is odd. If the number of elements is even, then the median is the > average of the two middle values. > > Yes, this is correct, but it is still sampling median. On the other hand, some non-parametric test might rule out some of the values, so we are again in the beginning. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: socket filename is truncated in error message
Brian Bartholomew writes: > Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > > > This is simply because we have to limit our errors buffers to some > > reasonable values. > > Are there so many of these filename buffers that they can't be sized > to MAXPATHLEN? Yes, and we try to use as little stack as possible. Pushing everything to heap, on the other hand, would cause some speed penalties. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: median function?
Roger I Martin PhD writes: > Hi, > > Median as a function in sql does not exests that I know of. But if you get a > resultset ordered by the column of numbers, you can then pick the median at > the row index=n/2 where n is the total number of values in the column? > > Roger Nope . Median depends on statistical distribution. There is one that is valid for sampling distribution, but there are still many alternatives. This is something that could be done as an UDF. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: socket filename is truncated in error message
Brian Bartholomew writes: > >Description: > > My correct socket filename is: > > /home/bb/depot/mysql-3.23.43-9a7c0100047f2d1b5c72210d23df8448/tmp/mysql.sock > > However, the socket filename is truncated in the error message when > the database isn't started: > > % mysqlshow > ./mysqlshow: Can't connect to local MySQL server through socket >'/home/bb/depot/mysql-3.23.43-9a7c0100047f2d1b5c72210d23df8448/tm' (111) > ^ > > Note that only the error message is truncated, not the filename itself; > when the database is running, the connection works. > This is simply because we have to limit our errors buffers to some reasonable values. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can't make after ./configure
Chang-Ping Hsiao writes: > Hi! > > Thanks for the help. Tried both and both failed. Still get the > following. > [skip] > make[2]: Entering directory `/tmp/mysql-3.23.45/client' > /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -fno-implicit-templates > -fno-exceptions -fno-rtti -DHAVE_RWLOCK_T -o mysqlbinlog mysqlbinlog.o > ../lib > mysql/libmysqlclient.la -lcrypt -lgen -lsocket -lnsl -lm > gcc -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti > -DHAVE_RWLOCK_T -o .libs/mysqlbinlog mysqlbinlog.o > ../libmysql/.libs/libmysqlclient.so > -lcrypt -lgen -lsocket -lnsl -lm -lcrypt -lgen -lsocket -lnsl -lm > -R/usr/local/lib/mysql > Undefined first referenced > symbol in file > __cxa_pure_virtual mysqlbinlog.o > ld: fatal: Symbol referencing errors. No output written to .libs/mysqlbinlog > collect2: ld returned 1 exit status > make[2]: *** [mysqlbinlog] Error 1 > make[2]: Leaving directory `/tmp/mysql-3.23.45/client' > make[1]: *** [all-recursive] Error 1 > make[1]: Leaving directory `/tmp/mysql-3.23.45' > make: *** [all-recursive-am] Error 2 Just do what I told you: > > > > gcc 3.0.2 is just fine, only set the following : > > > > export CXXLD=g++ > > -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GUI
Simon Green writes: > Hi all > This is probably a silly question but > Can MySQL GUI connect from my windoz desktop to my Unix box? > Just can not seem to get it working! > > Simon Yes, of course it can. Start "Options", fill it up correctly and click to "Save" if you wish to connect always that way or to "Apply" if it is one-time only variant. -- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL strange error: lost connection during query
Zeus Gómez Marmolejo writes:
> SEND-PR: -*- send-pr -*-
> SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
> SEND-PR: will all comments (text enclosed in `<' and `>').
> SEND-PR:
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: MySQL strange error: lost connection during query
>
> >Description:
>When 2 concurrent processes access the database 'sometimes' MySQL
> reports this error to both processes at the same time. It happens very
> rarely and about 10 seconds later they continue with its normal work.
> When we increase the number of processes accessing the database this
> happens more often.
>Following queries after this error return 'MySQL server has gone
> away'. The processes access the database stored at localhost.
>It is possible that the tables involved in the queries could get
> corrupted after this error. Then, database must be repaired before any
> successive inserts in the table.
>
> >How-To-Repeat:
>
> void insercion(MYSQL mysql_h1, int orden)
> {
> int i=1;
>
> if( mysql_query(&mysql_h1, "insert into conexiones values ('', \
> 'a5sbue123', 'f3089047', 'fassion', '', NULL, 'P', 0)") )
>
>do {
> printf("%d ERROR %s, n.try %d\n", orden,
>mysql_error(&mysql_h1), ++i );
> sleep( rand() % 5 +1 );
>
>} while( mysql_query(&mysql_h1, "insert into conexiones values ('', \
> 'a5sbue123', 'f3089047', 'fassion', '', NULL, 'P', 0)") );
>
> else
>printf("%d Correct!\n", orden);
>
> }
>
>This is the possible fix in the user code, retrying some times and
> about a random time (in order to avoid another concurrent error). But it
> doesn't work. Sometimes reports: 'Database not selected' maybe because
> after a bad query the connection to the database has been lost?
>I have tested this code in a linux machine with 15 simultaneus
> processes and it doesn't happen at all. Could be a problem with the
> architecture?
>
The errors you are getting are most probably a consequence of the
differences between OSF on which MySQL was built and your OSF.
See what .err log contains ..
--
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: INNER JOIN doesn't work correctly..
Sergey S. Kostyliov writes: > >Description: > Query with INNER JOIN return 0 rows, but the same query + yet another > WHERE condition return 1 row > >How-To-Repeat: > Query: > SELECT orders_common.vendor_id >FROM orders_common > INNER JOIN orders_common_count > ON (orders_common.id=orders_common_count.orders_id) > WHERE orders_common_count.clients_names_id in (3639) > AND orders_common.vendor_id=95 > Result - 0 rows > but, > SELECT orders_common.vendor_id >FROM orders_common > INNER JOIN orders_common_count > ON (orders_common.id=orders_common_count.orders_id) > WHERE orders_common_count.clients_names_id in (3639) > AND orders_common.vendor_id=95 > AND and orders_common.id=1060340 > Result - 1 row You have two AND's one after another. Try with one AND and tell us what you get ... -- 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: Install mysqlgui
Urtzi Larrazabal writes: > > > Dear friend, > > I am planning to install mysqlgui in my Solaris 2.8 O.S. but I haven't any idea what >steps should I follow to install it. I would be gratefull if you could help me. > > Best regards, > > Urtzi Larrazabal. > If you have SPARC, try the existing binary for Solaris from mysqlgui page. You will also need to install libstdc++ library from GNU 2.95.2 package. -- 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: VC++ - MFC Question
Mike Gleason Jr Couturier writes:
> Hello all !
>
> I'm creating an MFC program with the mySQL API.
> Everything is working fine but when exceptions
> occurs (ie when connecting, changing databases...),
> I can't display the er.error message to the user...
>
> How can I convert the error message to a char * or
> a CString ?!?!
>
> [...]
> catch (BadQuery er) {
> AfxMessageBox((CString)er.error); // Error !
> }
>
> Error :
> cannot convert from 'class std::basic_string std::char_traits,class std::allocator >'
> to 'class CString'
>
> Thanks !!
>
Hi!
First of all, you are not using MySQL API but MySQL++ API.
You should know STL better then MFC, as STL is standard and works
(more or less) everywhere, while MFC works with VC++ / Windows
only. You can always use c_str() method to get char * from
basic_string
--
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: How to install mysqlgui?
Peter Smith writes: > Hello, I would like to know how to install mysqlgui and also fltk, flek, > mysql++ > > I have been to mysqlgui's install.txt, but not enough information on > installation, it only gives info on what you need to have to make mysqlgui > work. > > Could you get back to me asap, as I need to do this for my work > Thanks > > Regards > Peter > > Peter Smith > Creative Designer > Dfx-IT > SMS: 0414 516 094 > URL: www.dfx-it.com > What OS / CPU are you using. If Linux or Windows , then just install and use our static binary. After that follow instructions in README on how to configure and run it properly. -- 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: Can't make after ./configure
Gordan Bobic writes: > On Tuesday 27 Nov 2001 23:33, you wrote: > > > gcc version 3.0.2 > > It would appear that you tried compiling using the GCC 3.0.2 compiler. Try > downgrading to 2.95.3 (the last stable release) and try again. > > Regards. > > Gordan > gcc 3.0.2 is just fine, only set the following : export CXXLD=g++ -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Failure to enforce length of fields to index corrupts tables
You wrote: >Description: > Documentation section 6.5.7 regarding create index states: "For CHAR and >VARCHAR columns, indexes can be created that use only part of a column, using >col_name(length) syntax. (On BLOB and TEXT columns the length is required.)" > It's still possible in the mysql client to request the creation of an index >with indexlength NULL on TEXT fields. This apparently works okay on creation of the >index, insert and select operations, but breaks horribly (marks table as crashed with >corrupted indexes) on update or delete operations. > Same problem occurs with fulltext indexes -- indeed, I had an index created as >a concatenation of two text fields (Name,Description). On running check-table and >then show index, this fulltext index had a null cardinality; and, when dropped, it >dropped immediately (too quickly to have data in it). > > We're using mysql4 in production since we need the fast fulltext indexing. >http://ftp.avsim.com/library/ is the site running your backend. > >How-To-Repeat: > Create table with field-type of TEXT. > CREATE INDEX AnyName ON Table(TextField); > Issue an update to a pre-existing record for the incorrectly indexed TextField. Hi! I have tested your case. The above bug was already fixed in our BK repository. Fix will come up in 4.0.1, that is scheduled to come out soon. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and .Net
Vaijayanthi writes: > Sir, > We are working in .Net environment. We could not use the MySQL database > in the .Net platform. The MySQL ODBC (MYODBC) does not work with the > OleDBProvider of .Net. > We tried with the myOleDB provided by MySQL which is also not working > in .Net environment. Please provide us a solution to work with MySQL and > .Net > > regards, > Vaijayanthi.M Hi! You will find a link to the OleDB driver on our site. Try it out. We are planning of making a proper support for C# in the future. -- 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: patch: manpage safe_mysql(1)
Thank you for your contribution. -- 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: Mac OS X and MySQL
Michael Collins writes: > Now that the shutdown command has been repaired, are there other > outstanding issues specific to Mac OS X that the MySQL AB team has > under development for MySQL 3.x? > > -- > Michael > __ > ||| Michael Collins ||| > ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] > ||| Seattle, WA, USA ||| http://www.lassodev.com No, there are no outstanding OS X issues on our TODO. -- 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: API documentation issue : inconsistency in mysql_real_connectdocumentation
M. A. Alves writes: > On Sat, 24 Nov 2001, Sinisa Milivojevic wrote: > Not quite: > > "For a successful connection, the return value is the same as the value > of the first parameter, unless you pass NULL for that parameter." (Manual) > > > Cheers, > > -- >, > M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 > A M A D O Rua Campo Alegre, 823 fax 351+226003654 > A L V E S P-4150-180 PORTO, Portugalmob 351+939354002 > This SHOULD be fixed. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4 UNION problem
Tony Bailey writes: > I've been trying MySQL 4 alpha (Windows build) as I need UNION but can't work out >how to get the query I > need against the version without the union > [skip] > 2) > select count(docs.docid) as score, docs.docdate, docs.docid, docs.docsection, >docs.docsubdir, docs.docmsgid, > docs.sendername, DATE_FORMAT(docs.docdate, '%W %M %D %Y') as thedate, doctitle from >docs, > wdocid_pa where wdocid_pa.docid = docs.docid and docs.docdate > >FROM_UNIXTIME(975228544) > AND wdocid_pa.wordid=495 GROUP by docs.docid UNION ALL select count(docs.docid) as >score, > docs.docdate, docs.docid, docs.docsection, docs.docsubdir, docs.docmsgid, >docs.sendername, DATE_FORMAT > (docs.docdate, '%W %M %D %Y') as thedate, doctitle from docs, wdocid_ca where >wdocid_ca.docid = > docs.docid and docs.docdate > FROM_UNIXTIME(975228544) AND wdocid_ca.wordid=136 >GROUP by > docs.docid UNION ALL select count(docs.docid) as score, docs.docdate, docs.docid, >docs.docsection, > docs.docsubdir, docs.docmsgid, docs.sendername, DATE_FORMAT(docs.docdate, '%W %M %D >%Y') as thedate, > doctitle from docs, wdocid_bo where wdocid_bo.docid = docs.docid and docs.docdate > > FROM_UNIXTIME(975228544) AND wdocid_bo.wordid=1646 GROUP by docs.docid ORDER by >score DESC, > docdate DESC, docid DESC LIMIT 0, 10 > > > TIA > > Tony > What exactly does not work with query number 2 ??? Please explain in more detail. Also, upload your tables to ftp://support.mysql.com:/pub/mysql/secret tarred and gzipped and let me know a filename. -- 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: The source lacks of flex source
Francis S.Lin writes: > Hello, > > I'm trying to build MySQL from source. > I've noticed in whether MySQL 3.23.43 or 4.0, > for sql/lex.cc and lex.h -- > The source for flex to generate these two files is missing!! > Although the yacc file (sql_yacc.yy) still exists, > I need the lex source because I want to change some token names. > > Would you please publish the lex source , or it's already published > but in somewhere that I've ignored? > > Thanks, > -- > piaip, Francis.S.Lin lex.h was not generated, but written by us. lex.cc does not exist. -- 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: API documentation issue : inconsistency in mysql_real_connect documentation
Quentin Bennett writes: > So, if you pass NULL in as the first parameter to mysql_real_connect, a > possibility opened up by the manual, what is the return. If it is "a MYSQL* > connection handle if the connection was successful", where did the space for > that handle come from. > > I agree with Mario - if someone is going to go through the documentation, as > recommended on every post, the least that can be expected is that the > documentation should be un-ambiguous. > > Regards > > Quentin > Hi! There is no indication in our documentation that NULL should be passed as a first parameter in mysql_real_connect. -- 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: Failure to enforce length of fields to index corrupts tables
Thank you for your report. We shall check it out. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL 4.0 in production?
johnlucas-Arluna writes: > Hi folks > > I really need to use some of the new features of version 4, particularly the > UNION joins. > > Has anyone had any experience with using the UNION, does it work ok and > fast? > > Also, could you indicate your confidence level with regard to running ver > 4.0 in production even though it's only beta? I know it's recommended for > development use now, do we know when it will be declared a stable release? > > We would want to change to 4.0 very quickly, is migrating a ver 3.23.32 > straightforward? > > Many thanks for any help and advice. > > John > Hi! There are (still) no reported problems with UNION's. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Field Names
David Ayliffe writes: > Can I assume that you can't have a field in a table which is named > 'Integer' or 'Datetime' or 'Byte' > > Any input? > I've had a quick look but I can't see much > > Thanks lots > David Ayliffe Hi! BYTE should be quite possible. -- 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: mysqlgui
Glenn English writes:
> RH7.2
>
> When I run 1.7.5 either static or semi static, I get
>
>Can't connect to local MySQL server through socket " (111)
>
> Host name is "localhost" ("120.0.0.1" doesn't work either).
>
> I do have access rights - running as root.
> --
> Glenn English
> [EMAIL PROTECTED]
Hi!
All you have to do is follow instructions from README that came with
distro.
Here is a relevant part :
When you start mysqlgui for the first time, you'll need to tell it how to
connect to the MySQL server. To do this, click on the ``Options'' button.
Select the ``Server'' tab and fill in the fields that indicate where to
find the server. On Unix, if you have problems with mysqlgui not knowing
the location of the socket file for connections to localhost, enter the
full pathname of the socket file in the ``SQL command on the start-up''
field. On Windows, this field is used if you wish to specify the named pipe
option. Then select the ``Client'' tab and fill in your MySQL user name.
Take care to select the right value for the ``Ask for password'' button,
depending on whether or not you want mysqlgui to prompt you for your
MySQL password. After you have filled in the server and client values,
click on the ``Save'' button. From then on, each time mysqlgui starts up,
it will connect to the MySQL server automatically.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-4 compile / configure error
dan writes: > Towards the end of running the end of the configure script (./configure > --prefix=/usr/local/mysql - and yes I know I can optimise better than > this), I get: > > creating ./config.status > creating Makefile > sed: file conftest.s1 line 6: Unterminated `s' command > creating os/Makefile > sed: file conftest.s1 line 6: Unterminated `s' command > creating ut/Makefile > sed: file conftest.s1 line 6: Unterminated `s' command > creating btr/Makefile > sed: file conftest.s1 line 6: Unterminated `s' command > creating buf/Makefile > sed: file conftest.s1 line 6: Unterminated `s' command > creating com/Makefile > sed: file conftest.s1 line 6: Unterminated `s' command > > etc ... it goes on & on but you get the idea. > > I'm running Slackware 8 with Autoconf 2.13 (not sure if this is > relevant, but anyway I had to downgrade it to be able to compile > Enlightenment 0.17 cvs) > Anyone know what's happening? Alternatively, has anyone made a package > for Slackware? The rpms segfault on executing. > Please email me if you want more info (I tried attaching the config.log > but apparently it's too big...). I'm subscribed to the digest - but that > will take a day, and I'd like to get this show on the road [;)] > Thanks in advance! > > Dan Hi! I have no problems with autoconf 2.13. This is a recommended version. It is with sed that you experience problems. For Slackware download binary .tar.gz package. -- 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: Problem with Result class
thomas WOLFF writes:
> Y have make a function like
>
> Result CSql_tools::SendaQuery(CString request)
> {
> Result res;
>
> Query query = GetQuery();
> // This creates a query object that is bound to con.
>
> query<
> res=query.store();
> // Query::store() executes the query and returns the results
>
> return res;
> }
>
> when y run the programm he made a access violation, when he return the
> result why
> Please help !
> thanks.
>
>
> Thomas Wolff
> -
> Akosystem
> Am Tiefen Weg 17b
> 76547 Sinzheim
>
> Email: mailto:[EMAIL PROTECTED]
> Telefon: +49 (0) 7221 / 98 78 40
> Fax: +49 (0) 72 21/98 78 42
> Handy France : +33 (0)6 84 20 50 86
Hi!
Are you using MySQL++ ??
If so which compiler did you build it with.
Next, you must check the errors. Best way to do it is with C++
exceptions.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql++ linker errors with VC++ ver6
Patrick Sherrill writes: > NODEFAULT would cause all the MSVCRT functions to become unresolved, would > it not? > > Pat... > Beats me, but I know who could help you. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql++ linker errors with VC++ ver6
Patrick Sherrill writes: > Any clues on : > > "LINK : warning LNK4098: defaultlib "MSVCRT" conflicts with use of other > libs; use /NODEFAULTLIB:library" > > when attempting to link an MFC program using Mysql++ tweaked for MSVC? > > Thanks, > > Pat... > [EMAIL PROTECTED] Hi! The latest VC++ version of MySQL++ available from MySQL++ page was fully tested with all MFC classes and worked just fine. And you could set the above NODEFAULT... -- 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: HANDLER strange behaviour
Ian Collins writes: > If you open a table using HANDLER, > > e.g, HANDLER MYTABLE OPEN; > > then during the course of your application truncate that table, > > e.g, TRUNCATE TABLE MYTABLE; > > then you get some really wierd behaviour (my wierd behaviour was the > application rolling on a free in a completely different part of the > program). > > I hadn't even used a HANDLER READ when it had crashed - just the OPEN. > > I guess it's kind of understandable, and not something that happens a lot, > but it may be worth adding this caveat to the documentation (to save some > other lost soul hours of screen kicking). > > Regards, > Ian Collins. > Thank you for your report. -- 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: mysqldump and a running mysql
Chris Aitken writes: > Hi all, > > > Just a real quick question about using mysqldump. Should I shutdown mysql > before running mysqldump, or can I successfully do a mysqldump of my whole > database while mysql is still running/processing records. > > > I have a very big database, and want to go a daily dump backup, but I > really dont want to have any downtime to process the backup. > > > > Any info would be appreciated. > > > > Chris > > > > -- > Chris Aitken - Administration/Database Designer - IDEAL Internet > email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890 > __-__ > # ln -s /dev/null /bin/laden > If you don't like my typing, all flames to /bin/laden Hi! mysqldump will not work without mysql server. Just use --opt option when running mysqldump. -- 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: Help? create function returns errno 0: unsupported file type
Troy Bowman writes: > > System: FreeBSD 4.4-STABLE > MySQL version: 3.23.43 > UDF code: http://www.aros.net/~lump/udf_int_ip.cc > > I've been trying to implement my own loadable function for mysql. I needed > a function which converts a 4-byte integer into an IP address. I wrote a > UDF for mysql, and It compiles fine, but when I try to create the function > in mysql, it tells me that the type is unsupported. i.e.: > > mysql> CREATE FUNCTION int2ip RETURNS STRING SONAME "libudf_int_ip.so"; > ERROR 1126: Can't open shared library 'libudf_int_ip.so' (errno: 0 > /usr/lib/libudf_int_ip.so: unsupported file type) > > I figured it might be my code, and tried compiling the udf_example, and it > gives me the same thing, i.e.: > > mysql> CREATE FUNCTION lookup RETURNS STRING SONAME "libudf_example.so"; > ERROR 1126: Can't open shared library 'libudf_example.so' (errno: 0 > /usr/lib/libudf_example.so: unsupported file type) > > I don't get why it would be unsupported, and need some outside help :) > Please? Pretty please? > > thanks, > > ...troy. > Hi! Please check a type of the above ...so file with a file command. Also check execute permissions. -- 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: shutdown still a problem on Darwin
Erik Price writes: > Sinisa, everyone, > > That's great news! I'm excited to hear that. Which version would that > be... 4.0? Or perhaps another 3.x version? > > In the meantime, my boss is going to wonder why I'm not populating a > database for him. He will make me use Access if I don't get cracking, > so... do you know of a working version of MySQL for Darwin 1.4.1 ? > > Alternatively, I am open to a workaround until the working version is > released. I can actually use MySQL (as far as I know), it's just the > "shutdown" that hangs. I have to use "kill -9" in order to kill the > daemon. This makes me worry about my data, since this command has the > potential to cause corruption. Is there some way that I can preserve > the data, or protect it from corruption, so that at the end of the day > when I shut down my laptop I can use "kill -9" without fear of damaging > the contents? > > Or is the best policy to just back up the data directory and then go > ahead and kill the daemon, then in the morning when I get to work move > the backup back into the working directory? > > I admit that I'm still new to MySQL so I'm not sure exactly what the > best course of action would be. > > Thanks to Sinisa, Sasha and to anyone who has input on this situation, > > > Erik > > PS: do you advise that I beta-test the upcoming MySQL version? I would > be open to this idea, especially if it fixes my problem, but I am > working in a production environment and so would be best served with as > stable a release as is available. Hi! I am not sure, but I think it will appear in 3.23.45. Watch our for both 3.23.45 and 4.0.1 and read Changelog. -- 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: SupportWizard: bug in mysql: "ALTER TABLE CHANGE COLUMN A" can damage autoincrement column B!
Max writes:
> >Description:
> I am using russian values(cp1251 charset) for ENUM items.
> Here is an example how to damage ID field by query to change
> F_Category Enum.
> >How-To-Repeat:
> # Create tableA with ID field.
> CREATE TABLE tableA (
> ID int(11) NOT NULL auto_increment,
> F_ReportID bigint(20) NOT NULL default '0',
> F_Response_to varchar(99) NOT NULL default '',
> F_More_reports mediumtext NOT NULL,
> F_Linked_Reports mediumtext NOT NULL,
> F_Responses mediumtext NOT NULL,
> F_Summary varchar(99) NOT NULL default '',
> F_Description mediumtext NOT NULL,
> F_Solution mediumtext NOT NULL,
> F_Category enum('Bug','Question','Documentation','Enhancement Request','Web
>Error','User Error','Unknown') NOT NULL default 'Question',
> F_Attached_file mediumtext NOT NULL,
> F_Severity enum('Critical','High','Medium','Low') NOT NULL default 'Medium',
> F_User varchar(99) NOT NULL default '',
> F_EndUser varchar(99) NOT NULL default 'nobody',
> F_FullName varchar(99) NOT NULL default '',
> F_E_mail varchar(99) NOT NULL default '',
> F_Telephone varchar(99) NOT NULL default '',
> F_Group varchar(99) NOT NULL default '',
> F_Internal_analysis mediumtext NOT NULL,
> F_State enum('Open','Assigned','In-progress','In-testing','Closed') NOT NULL
>default 'Open',
> F_Std_Solution enum('Yes','No') NOT NULL default 'No',
> F_Accepted enum('Yes','No') NOT NULL default 'No',
> F_Date datetime NOT NULL default '1990-01-01 00:00:00',
> F_Thread_owner varchar(99) NOT NULL default '',
> F_Creator_E_mail varchar(99) NOT NULL default '',
> F_Modified_by varchar(99) NOT NULL default '',
> F_Modification_date datetime NOT NULL default '1990-01-01 00:00:00',
> F_Route mediumtext NOT NULL,
> F_History mediumtext NOT NULL,
> F_E_mail_History mediumtext NOT NULL,
> F_CorrectSolutionCount bigint(20) NOT NULL default '0',
> F_CorrectSolutionCount bigint(20) NOT NULL default '0',
> F_AdjustedSolutionCount bigint(20) NOT NULL default '0',
> F_Assign_date datetime NOT NULL default '1990-01-01 00:00:00',
> UNIQUE KEY ID (ID),
> KEY F_ReportID (F_ReportID),
> KEY F_Category (F_Category),
> KEY F_Severity (F_Severity),
> KEY F_User (F_User),
> KEY F_State (F_State),
> KEY F_Std_Solution (F_Std_Solution),
> KEY F_Accepted (F_Accepted),
> KEY F_Date (F_Date),
> KEY F_Thread_owner (F_Thread_owner),
> KEY F_Modified_by (F_Modified_by),
> KEY F_Modification_date (F_Modification_date),
> KEY F_Assign_date (F_Assign_date),
> KEY F_Assigned_to (F_Assigned_to,F_State)
> ) TYPE=MyISAM;
>
Hi!
We would very much like to solve a problem, but your test case is
faulty.
First, you have two columns of the same name :
> F_CorrectSolutionCount bigint(20) NOT NULL default '0',
> F_CorrectSolutionCount bigint(20) NOT NULL default '0',
second , you have a key using non-existent column :
> KEY F_Assigned_to (F_Assigned_to,F_State)
Please provide us with a working example.
--
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: shutdown still a problem on Darwin
Erik Price writes: > Hello all, > > Some of you may recognize this post somewhat, I've asked about this > problem before: > > I am unable to execute the "shutdown" command with mysqladmin, running > on Darwin 1.4.1 (from Mac OS X 10.1.0). > > Originally, I had compiled MySQL 3.23.44 from source code, specifying > the following options during ./configure : > > --prefix=/usr/local/mysql > --with-unix-socket-path=/usr/local/mysql/run/mysql_socket > --with-mysqld-user=mysql --with-comment --with-debug > > And I started the daemon with > > bin/safe_mysqld --socket=/usr/local/mysql/run/mysql_socket & > > Everything worked great, but when I tried to use > > mysqladm@localhost$ mysqladmin -u root -p shutdown > > I would end up just "hanging" there. Eventually, the only way I could > take down the daemon was with a kill -9 (regular "kill" wouldn't work). > I posted to this list about my problem a few times, and discussed some > possibilities with some others on this list (thanks everyone who had > input). Some suggested trying a recompile without the "--with-debug" > option, which I did. The exact same problem persisted. > > So then I used > > root@localhost# rm -R /usr/local/mysql > > and proceeded to download the binary from my local mirror. The binary > for Darwin is a hair older than the source code I had tried, > mysql-3.23.43-apple-darwin . > > I put the tarball into /usr/local and extracted it, then went about the > usual permissions-changing and ran scripts/mysql_install_db . > Everything was good to go. I started the daemon with > > bin/safe_mysqld & > > (no specifying the socket this time because it was in the default > location, wherever that is.) Started up great, no problems. So I > decided to test the shutdown command again. I executed the exact same > command: > > mysqladm@localhost$ bin/mysqladmin -u root -p shutdown > > and once again, after entering the password, it just hung. Just like > with my source install, I had to use a kill -9 to get the daemon to > shut down. > > I'm really excited about working with MySQL, I just need to get it up > and running! Well, that's not actually the problem, but I need to be > able to shut it down. This is being run on my G3 "bronze" laptop with > OS X 10.1 / Darwin 1.4.1 . I'm very surprised that the binary didn't > work correctly, since according to mysql.com, it has been configured > with the best options for my platform. > > Does anyone have any advice? Suggestions? Input? Help? I really > appreciate anyting anyone can add to this situation. > > Thanks in advance, > > > Erik > > > PS: if you respond directly to the list, please CC me as I am a > "digester" and won't get your response until the digest comes out... Hi! Our colleague Sasha Pachev has made some changes in the signal handling part of our server that should solve your problems. Those fixes should come up in the next MySQL version. -- 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: FROM clause order matters?
Hi! I have tested your test case of two SELECT's producing different outputs depending on the table ordering. Those two queries were a problem : -:- SELECT link.titel,link.id FROM link, ord as o1,ord AS o2 WHERE o1.ord like 'bethanias%' AND o2.ord like 'unge%' AND o1.kilde_id=o2.kilde_id AND o1.kilde_id=link.id; ++-+ | titel | id | ++-+ | Bethanias Unge | 404 | ++-+ 1 row in set (0.01 sec) mysql> SELECT link.titel,link.id FROM ord as o1,ord AS o2, link WHERE o1.ord like 'bethanias%' AND o2.ord like 'unge%' AND o1.kilde_id=o2.kilde_id AND o1.kilde_id=link.id; Empty set (0.01 sec) -:- I have tested it all with the latest MySQL version and both queries produced the following result: ++-+ | titel | id | ++-+ | Bethanias Unge | 404 | ++-+ So, this must have been some bug that was fixed meanwhile. -- 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: users@localhost problems
Alex Kirk writes: > > What version of MySQL are you using and is it our binary ?? > > It's 3.23.37. I built it from source on my OpenBSD-2.9 box (i386 > architecture). It didn't appear to have any trouble when I built it. > > > > > Also check the integrity in mysql database with CHECK TABLE. > > mysql> check table user; > ++---+--+--+ > | Table | Op| Msg_type | Msg_text | > ++---+--+--+ > | mysql.user | check | status | OK | > ++---+--+--+ > 1 row in set (0.05 sec) > > All the other tables in MySQL show up with equivalent resutls. > > Hmmm...that seems OK to me...but then again, I can't really say much, since > I don't really know. > > Any further tests I should run? > > Thanks, > Alex Kirk Looks like an error in compilation. Use gcc 2.95.2 and build it again as per instructions in our manual, section on OpenBSD. -- 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: Problems with static binary of mysqlgui 1.6 for Solaris 7
Garry Madrone writes: > I've downloaded the static binary mysqlgui-solaris-2.7-sparc-static-1.6. Although > this appears to be a gzip file, it did not have a .gz extention. It also seems > to be only a single file. I gunzipped the file and tried to execute it on > Solaris 7. The result is: > ./mysqlgui-solaris-2.7-sparc-static-1.6 > ld.so.1: ./mysqlgui-solaris-2.7-sparc-static-1.6: fatal: libstdc++.so.2.10.0: open >failed: > No such file or directory > > It looks like I need libstdc++.so.2.10.0. Can someone tell me what I need to get > the GUI running on Solaris 7? Thanks. > > Garry > Hi! You need to install libstdc++ package that is a part of GNU GCC 2.95.2. -- 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: users@localhost problems
Alex Kirk writes: > I'm sure this question has been answered a million times, so please pardon > it again. If there's an appropriate FAQ, please point me to it. > > My problem is fairly simple: I've set up a couple of users of the form > username@localhost. When I run a 'SELECT * FROM USER;' in mysql, they show > up, with the appropriate values in the host and user columns. When I attempt > to grant priviliges to them, though, I get this error: > > mysql> grant all on testdb.* to alex@localhost; > ERROR 1133: Can't find any matching row in the user table > > Like I said, though, I *know* the user is in the user table, as shown by > 'SELECT HOST, USER FROM USER;': > > +---++ > | host | user | > +---++ > | localhost || > | localhost | alex | > | localhost | apache | > | localhost | root | > | www || > | www | alex | > | www | root | > +---++ > 7 rows in set (0.00 sec) > > Also, if I try to connect to any databases as a non-root user, MySQL sees me > solely as '@localhost' -- i.e., it doesn't see my UNIX user name. What's up > with that? > > Thanks in advance. > > Alex Kirk Hi! The above is indeed weird. What version of MySQL are you using and is it our binary ?? Also check the integrity in mysql database with CHECK TABLE. The fact that MySQL can't see your UNIX username is probably a consequence of the bad build. -- 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: Error
Bauer, Rich writes:
> I am building mysql 3.22.26a with gnu cc 2.95.3 and gnu make under solaris 8
> and get the following error. How do I fix this ?
>
> # make
> make all-recursive
> make[1]: Entering directory `/opt/ftp/mysql-3.22.26a'
> Making all in Docs
> make[2]: Entering directory `/opt/ftp/mysql-3.22.26a/Docs'
> make[2]: Nothing to be done for `all'.
> make[2]: Leaving directory `/opt/ftp/mysql-3.22.26a/Docs'
> Making all in readline
> make[2]: Entering directory `/opt/ftp/mysql-3.22.26a/readline'
> make[2]: Nothing to be done for `all'.
> make[2]: Leaving directory `/opt/ftp/mysql-3.22.26a/readline'
> Making all in client
> make[2]: Entering directory `/opt/ftp/mysql-3.22.26a/client'
> c++ -DUNDEF_THREADS_HACK -I./../include -I../include
> -I./.. -I.. -I..-O -fno-implicit-templates -DDBUG_OFF
> -D_LARGEFILE_SOURCE
> -D_FILE_OFFSET_BITS=64 -c mysql.cc
> In file included from mysql.cc:54:
> /usr/include/term.h:1060: syntax error before `,'
> /usr/include/term.h:1081: syntax error before `;'
> /usr/include/term.h:1082: syntax error before `;'
> /usr/include/term.h:1101: syntax error before `['
> /usr/include/term.h:1108: syntax error before `*'
> /usr/include/term.h:: syntax error before `;'
> /usr/include/term.h:1115: syntax error before `;'
> /usr/include/term.h:1116: syntax error before `;'
> /usr/include/term.h:1207: `chtype' was not declared in this scope
> /usr/include/term.h:1207: parse error before `('
> make[2]: *** [mysql.o] Error 1
> make[2]: Leaving directory `/opt/ftp/mysql-3.22.26a/client'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory `/opt/ftp/mysql-3.22.26a'
> *** Error code 2
> make: Fatal error: Command failed for target `all-recursive-am'
> # pwd
> /opt/ftp/mysql-3.22.26a
> #
Hi!
Solution for the above problem is thoroughly described in our fine
manual.
If your Solaris is on SPARC, you are better of by using our binary.
--
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: mac
MWP writes: > DO you have a MySQL download that works for Mac OS 9 or above, but below > OS X? I don't see it. > And you will not. Pre OS X systems did not have many things, including threads that could make MySQL running possible. There is in our manual a link to a site making MySQL clients for OS 9. -- 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: TCP_NODELAY: what systems?
Andrew Schmidt writes: > Hi guys, > > In the latest MySQL release (3.23.44) it was noted: > > o TCP_NODELAY was not used on some systems > > Which systems would this affect? and is this client side or server side? > > thanks, > > -- Andrew > SCO Unix. Both sides. -- 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: SSL Support
Joachim Wickman writes: > Hello > > I've tried to configure and compile latest MySQL 3.23 source with SSL and it didn't >complain or anything, > but didn't support SSL either when I check the have_ssl variable. > > So, am I doing anything wrong? > Is there any sources of MySQL 4.00 and MySQL-Max 4.00? > > // Joachim > You will find links to MySQL 4.0 sources on our front page. -- 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: Idea about extending Limit/mysql query
Christian Andersson writes:
> I'm not sure if this is a good idea or bad, but I have one idea about the
> Limit funtionallity
>
> (which incidently might solve my order by, group by problem :-)
>
> I KNOW that it is NOT possible to do this now, so no RTFM :-) this is just
> an idea..
>
> LIMIT is as I understand it something that is mysql specific (I know
> informix has something similiar but they write it some other way)
>
> so adding functionallity here would not break any existing rule
>
> anyway, my idea is this..
>
> LIMIT columnname 1
>
> would return only 1 row for each unique value in the columnname
>
> LIMIT columnname1,columnname2 2
>
> would return max 2 rows for each unique combination of values in the
> columnname1+columnname2
>
> or perheps have a different name for this..
>
>
> Another way to solve my problem would be if there was some sort of
> FIRST_IN_SET functionallity that I could use on the where clause
> select * from articles where language = FIRST_IN_SET('en,sv,no')
>
> remember these are just ideas, that might be scratched or remembered
> If I know how to do it, I would perheps implement this myself in my own
> version of mysql, but I'm not THAT good .-)
>
> /Christian Andersson
>
>
Hi!
Just a small note. LIMIT is defined in ANSI SQL standard.
--
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: Cannot access my MySQL
SAE's System Administrator writes: > Hello all, > > I just installed a Suse 7.2 Linux, with MySql.. > MySQL runs, but when i try to access it, i get the following message: > > cleopatra:/usr/bin # mysql -h localhost -u root -p > Enter password: > ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) > cleopatra:/usr/bin # mysql -h localhost -u root -p > Enter password: > ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) > > is there any way to change/reset the password if any or am i doing > something wrong ? > > > > > > -- > Best regards, > SAE's System Administrator > [EMAIL PROTECTED] > World Council of Hellenes Abroad > 2 Komotinis str. > 54655 - Thessaloniki > GREECE HI! There is a chapter in our manual on what to do when you have forgotten root password. It resolves to starting mysqld with --skip-grant-tables option, UPDATEing root password with PASSWORD() function and restarting MySQL server. -- 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: Same table aliased twice causes infinite loop
Nick de Voil writes: > I am running MySQL 3.23 on Windows 2000. > > I have a SQL statement which looks fine to me, although it does reference > the same table twice. > > Here it is: > > SELECT DISTINCT u.inserted_usr_id, g.inserted_ugp_id FROM raw_users u, > raw_data d, raw_groups g, raw_groups gg WHERE u.forename = d.forename AND > u.surname = d.surname AND g.group_name = CONCAT(d.subject,' ',d.set_name) > AND d.yr_and_reg = gg.group_name AND gg.parent_ugp_id = g.parent_ugp_id; > > When I try to run this, either from the Java servlet where it lives, or just > via the mysql command line, my PC goes into a tailspin. > > Does MySQL not support aliasing the same table twice in one SQL statement? > > Thanks > > Nick > Hi! MySQL allows as many aliases as there could be tables in the join. Look for the tailspin somewhere else ... Try executing the above query from mysql.exe program. -- 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: Problem: myisamchk: error: Checksum for key....
Grzegorz Paszka writes: > On Mon, Nov 12, 2001 at 07:21:07PM +0200, Sinisa Milivojevic wrote: > > Before I wrote to this list I read manual. Especially chapter 4.4 . > > I've done what You suggested but it didn't help. (Stage 3: Difficult repair). > That's one problem. > > Another is as I wrote above. New database with content from > data source is also broken. I know that is sounds strange but it's true. > I'll try to set up database on another computer and I'll see if it's data related >problem or hardware (I don't believe) or configuration. > If I will have more information I'll write on list and to You. > > If You have another suggestions don't hesitate to write it to me. > > Best regards. > -- > Grzegorz > If restoring tables from mysqldumps also leads to corruption, then you should definitely check your hardware, OS and filesystem. -- 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: Problem: myisamchk: error: Checksum for key....
Grzegorz Paszka writes: > > Yes, I say more, that I created new database and filled it by perl script from data >source and I have the same situation. I think that is the best way of rebuild index >file :) > > So what I should do in this case ? > > -- > Grzegorz > See in our manual what to do when index file is not there, so try to follow those instructions. Backup your table first !! -- 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: Any possibility for "userstamp" column type?
Rich Bartell writes: > It occurred to me that a column type that functioned similar to timestamp > but for the id of user initiating the update would be very useful. What I > mean is a column that would automatically capture the userid that last > changed a row, much as a first timestamp column is automatically updated to > reflect the time a row was last changed. Is such a column type possible in > MySQL and > are there any plans to implement it? > > Thanks, > Rich No, no plans. This feature is very easy to implement in the application program and there are not many users that have asked for it. -- 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: Compiling of Mysql++ 1.7.9 under RH7.1
Rasmus Theede writes: > When I try to compile any of the examples in mysql++ I get the errors > (RedHat 7.1): > > > > In file included from /usr/local/include/sqlplus.hh:9, > from simple1.cc:3: > /usr/local/include/defs:5:19: mysql.h: No such file or directory > In file included from /usr/local/include/coldata1.hh:8, > from /usr/local/include/sqlplus.hh:12, > from simple1.cc:3: > /usr/local/include/type_info1.hh:10:19: mysql.h: No such file or > directory > In file included from /usr/local/include/vallist1.hh:6, > from /usr/local/include/row1.hh:11, > from /usr/local/include/compare1.hh:5, > from /usr/local/include/sqlplus.hh:13, > from simple1.cc:3: > /usr/local/include/manip1.hh:10:19: mysql.h: No such file or directory > In file included from /usr/local/include/sqlplus.hh:14, > from simple1.cc:3: > /usr/local/include/connection1.hh:10:19: mysql.h: No such file or > directory > In file included from /usr/local/include/connection1.hh:20, > from /usr/local/include/sqlplus.hh:14, > from simple1.cc:3: > /usr/local/include/query1.hh:10:19: mysql.h: No such file or directory > In file included from /usr/local/include/query1.hh:13, > from /usr/local/include/connection1.hh:20, > from /usr/local/include/sqlplus.hh:14, > from simple1.cc:3: > /usr/local/include/result1.hh:12:19: mysql.h: No such file or directory > In file included from /usr/local/include/sqlplus.hh:57, > from simple1.cc:3: > /usr/local/include/coldata3.hh:10:19: mysql.h: No such file or directory > > > > > > Where do I go wrong?? > > > > Regards > > Hi! You have to provide a full path to C API includes and libs, as explained in our manual. You will find proper options for path names to be passed to configure. Although MySQL++ 1.7.9 works with latest 2.96 compilers, we would still recommend any from 2.95 or 3.* series ... -- 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: updating cached query results as database changes?
Bennett Haselton writes: > I don't know if MySQL handles this, but if a database system knows about a > particular type of query that is executed very often (either you enter this > query manually as a "common query", or the database detects it), can you > instruct the DBMS to cache the results of the query -- and to examine all > updates to the data, so if an update causes the query results to change, > the cached results will be changed accordingly? Is there a name for this > kind of practice, some word that I could look up in the index of a book > about databases? [skip] > -Bennett > > [EMAIL PROTECTED] http://www.peacefire.org > (425) 649 9024 Hi! Query cacheing is right now in the works in 4.0. -- 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: Problem: myisamchk: error: Checksum for key....
Grzegorz Paszka writes: > Hi. > > I've problem with mysql. > > I had i386 RH71 (kernel 2.4.13, 1.5GB RAM, single procesor) with mysql 3.23.36 (now >I have 3.23.41 and problem still exists). > I run myisamchk on table zawartosc: > > [root@tygrys rpm]# myisamchk -c -i -v -w zawartosc > Checking MyISAM file: zawartosc > Data records: 6995929 Deleted blocks: 0 > - check file-size > - check key delete-chain > block_size 1024: > - check record delete-chain > No recordlinks > - check index reference > - check data record references index: 1 > Key: 1: Keyblocks used: 98% Packed:0% Max levels: 4 > - check data record references index: 2 > Key: 2: Keyblocks used: 65% Packed: 60% Max levels: 7 > Total:Keyblocks used: 69% Packed: 56% > > - check record links > myisamchk: error: Checksum for key: 2 doesn't match checksum for records > > Record blocks: 6995929Delete blocks: 0 > Record data: 398291567Deleted data: 0 > Lost space:5259802Linkdata: 26232723 > MyISAM-table 'zawartosc' is corrupted > Fix it using switch "-r" or "-o" > > Of course I used switch -r and problem still exists. > Second I used switch -o and problem still exists. > Hi! I hope you have not run myisamchk while server was running If yes, then that would explain things. Try using CHECK TABLE SQL command instead. Do you want to say that there is no way that you can repair MyISAM table ?? In that case there is in our fine manual a description of how to solve most critical table corruption. This basically involves rebuilding of entire index file. -- 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: FROM clause order matters?
[EMAIL PROTECTED] writes: > >Description: > We recently tried to upgrade from mysql 3.23.27 to 3.23.43 - we switched > back caused by we sometimes recieved different results with 3.23.43. The > statements below gives the same result with 3.23.27 but not with > 3.23.43. Apperently it matters in what order the tables are written in > the FROM clause. > I have tried to narrow it down to two simple tables, but then the > problem disappeared. > > >How-To-Repeat: > mysql> SELECT link.titel,link.id FROM link, ord as o1,ord AS o2 WHERE o1.ord like >'bethanias%' AND o2.ord like 'unge%' AND o1.kilde_id=o2.kilde_id AND >o1.kilde_id=link.id; > ++-+ > | titel | id | > ++-+ > | Bethanias Unge | 404 | > ++-+ > 1 row in set (0.01 sec) > > mysql> SELECT link.titel,link.id FROM ord as o1,ord AS o2, link WHERE o1.ord like >'bethanias%' AND o2.ord like 'unge%' AND o1.kilde_id=o2.kilde_id AND >o1.kilde_id=link.id; > Empty set (0.01 sec) > > mysql> explain SELECT link.titel,link.id FROM link, ord as o1,ord AS o2 WHERE o1.ord >like 'bethanias%' AND o2.ord like 'unge%' AND o1.kilde_id=o2.kilde_id AND >o1.kilde_id=link.id; > >+---++---+-+-+-+--++ > | table | type | possible_keys | key | key_len | ref | rows | >Extra | > >+---++---+-+-+-+--++ > | o1| range | iord,kilde_id,ord | iord| 61 | NULL|1 | >where used | > | link | eq_ref | PRIMARY | PRIMARY | 4 | o1.kilde_id |1 | > | > | o2| range | iord,kilde_id,ord | iord| 61 | NULL| 121 | >where used | > >+---++---+-+-+-+--++ > 3 rows in set (0.00 sec) > > mysql> explain SELECT link.titel,link.id FROM ord as o1,ord AS o2, link WHERE o1.ord >like 'bethanias%' AND o2.ord like 'unge%' AND o1.kilde_id=o2.kilde_id AND >o1.kilde_id=link.id; > >+---++---+-+-+-+--++ > | table | type | possible_keys | key | key_len | ref | rows | >Extra | > >+---++---+-+-+-+--++ > | o1| range | iord,kilde_id,ord | iord| 61 | NULL|1 | >where used | > | o2| range | iord,kilde_id,ord | iord| 61 | NULL| 121 | >where used | > | link | eq_ref | PRIMARY | PRIMARY | 4 | o1.kilde_id |1 | > | > >+---++---+-+-+-+--++ > 3 rows in set (0.00 sec) > > mysql> > > > > >Fix: Hi! Can you tar and gzip your tables and upload them to : ftp://support.mysql.com:/pub/mysql/secret so that we can check it out ?? After you upload them, please let us know a filename. -- 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: Using MySQL++ with CodeWarrior 7
Brice Ruth writes: > Greetings list members. I'm trying to build an application for OS X using > CW7 - and though I've gotten mysql++ to build and install properly (from the > command line, using configure & gcc) - I can't seem to get CW happy with > using mysql++ ... when I include the sqlplus header, I get about 300+ errors > (and numerous warnings) about things that the CW compiler apparently doesn't > care for. Does anyone know what might be going on? I'm not really > interested in rewriting copious amounts of mysql++ to make it compatible - > since I don't consider my C++ experience to be quite up to that level! > > Any help would be appreciated! > > Sincerely, > Brice Ruth > > p.s. please cc: me directly, as I'm not currently on the list. Also - > apologies if this isn't the correct place to post, please let me know if it > isn't. > -- > WebProjkt, Inc. > VP, Director of Internet Technology > http://www.webprojkt.com/ Hi! I have not tested MySQL++ with CodeWarrior, but I heard that it could be feasible. Are you sure that you can build MySQL++ with GNU and use it with CW ?? I am not so sure. I think you will have to port MySQL++ to CW Take a look at other ports, like Compaq's, Borland's, VC++'s You will simply have to resolve all the errors that you have. I have never used CW, nor do I have Mac (;-() so I can be of some theoretical help to you only. -- 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: MySQLGUI hangs on certain commands
David Wolf writes: > Yes.. It is the windows version of MySQLGUI that I am using. Windows 2000 > SP2 > > David Thanks, I will check it out ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql as an Embedded Java Database
Al Giacomucci writes: > We are developing an application for commercial distribution using a Java > client, JDBC, and an SQL database . It will come in 2 versions - a > standalone single-user version that will run on a PC and multi-user version > where the database will run on a separate server. > > For the standalone version we started using an embedded Java database. A > number of issues are now causing me to look at MySql for both versions. For > MySql to work, we need to --- > > 1. Install MySql "silently" along with the Java application - basically a > one-click install. > > 2. Be able to start and shutdown MySql server when the application is > started and shut-down. > > 3. No database maintenance - or able to automate whatever maintenance there > is - preferably using a Java interface. > > Can MySql do the job? And if so, can someone point me in the right > direction? > > For example, embedded MySql appears to require a C interface - could it also > be made to work with JDBC? What is required for a silent install? > > Thanks for your insights. > Hi! All that you ask for is, of course, possible. Only it would ask for some additional installation scripts, which will depend a lot on the OS to which it will install. If you will be selling your product, you will also require MySQL licence. Regarding embedded server, it works with C , but it could be made linkable in java application, with some additonal work. -- 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: MySQLGUI hangs on certain commands
[EMAIL PROTECTED] writes: > MySQL is working perfectly on my Linux box. I downloaded MySQLGUI, and ran it. > It connects fine, I can view a table, etc.. But, when I click on the > GRANT/REVOKE menu, it hangs on the Windows side. When I go to the Linux side and > issue SHOW PROCESSLIST, there are as many processes connected as I have ports > open. When I forcibly kill the MySQLGUI, and issue SHOW PROCESSLIST, it's back > to 'normal'. > > The above happens as SOON as a I click the GRANT/REVOKE menu item! I can view > the mysql.user table (by using the view table button), but, it dies when I go to > the GRANT/REVOKE menu item. > > David > Hi! If I understand you well, you are talking about Windows version of MySQLGUI ?? Please clear it out. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock deletes itself on Solaris
[EMAIL PROTECTED] writes: > >Description: > /tmp/mysql.sock is there and then apparently randomly its removed without > warning.. mysql still accepts TCP connections and theres no log comment > to indicate an error. > > >How-To-Repeat: > It seems random.. Hi! The above is a consequence of a cron job that regularly deletes files in /tmp directory. Find that cron job and change it. -- 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: Help - Migration to mysql from a legacy ISAM
Ian Collins writes:
> So how do you use the HANDLER command in a C program?
> I perused the code for 3.2x for this, and ended up installing mysql-4.0.0.
> I found what I believe to be the code for HANDLER in
> libmysqld/sql_handler.cc
> in the functions,
> mysql_ha_open, mysql_ha_close, mysql_ha_read
>
> Am I correct (or, as I surmise, off on a tangent)?
>
> Are there any examples anywhere of how to use these?
>
> Many regards,
> Ian Collins.
>
Hi!
You do not use HANDLER command in C program.
You run a query with a HANDLER command, like :
if (mysql_query(mysql,"HANDLER OPEN ...")
{
if (mysql_query(mysql,"HANDLER READ ..")
{
mysql_store_result ... etc etc etc
}
}
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL ignoring writes
Erik G. Burrows writes: > > I'm having a wierd problem with MySQL, that seems to be begging that I > wait for the next release, but I wonder if anyone else is getting this. > > I'm running MySQL 3.23.42, and using the Berkeley DB table type to get > transactional ability. Occasionally, MySQL will simply stop accepting > INSERTs and UPDATEs to my tables! DELETEs work, but UPDATESs and INSERTs > don't. > > All the actual data files are owned by mysql, group mysql, read/write > for user and group, there's nothing in the mysqld.log or the error log, > and there's plenty of space on the disk. Very wierd. > > It seems to be a datafile corruption problem, because I can restore the > files from backup and the database will run fine, for a while. > > Any clues or workarrounds out there? > > -Erik G. Burrows > Hi! To help us find a solution to this, please follow the information at http://www.mysql.com/doc/B/u/Bug_reports.html to make a complete bug report that we can easily reproduce at our end, preferably by just piping to the 'mysql' command line tool. If you manage to do this, then you should email it to [EMAIL PROTECTED] All repeatable bug reports posted to this list will be handled promptly. -- 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: MySQLGUI?
Henrik Holmberg writes: > Hi > > Can MySQLGUI start and stop the daemon? > > > /Henrik It can stop it if you have root privileges on the server. -- 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: Programming with C API question
Li, Robert writes: > Hi, > I am a programmer. Now i want to know how to know > whether MySQL server is down or not through C API. > For me, i know if we use mysql_real_connect() to > connect MySQL server, when error returns we can not > distinguish it's due to authentation error or mysql server down. > Can we use mysql_error() after mysql_real_connect? > But what's the error code for mysql server down or > authentation error. > Thanks and regards. > Robert Li > Computer Associates > Programmer, R&D Beijing (China) > tel: +86 10 65611136 ext 852 > fax: +86 10 85298979 > [EMAIL PROTECTED] > Hi! You can try using our C API function mysql_ping(). Here is a description: int mysql_ping(MYSQL *mysql)' Description ... Checks whether or not the connection to the server is working. If it has gone down, an automatic reconnection is attempted. This function can be used by clients that remain idle for a long while, to check whether or not the server has closed the connection and reconnect if necessary. Return Values . Zero if the server is alive. Non-zero if an error occurred. Errors .. `CR_COMMANDS_OUT_OF_SYNC' Commands were executed in an improper order. `CR_SERVER_GONE_ERROR' The *MySQL* server has gone away. `CR_UNKNOWN_ERROR' An unknown error occurred. Would you be so nice to tell us what is Computer Associates of China using MySQL for ?? -- 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: MySQLGUI hangs on certain commands
[EMAIL PROTECTED] writes: > MySQL is working perfectly on my Linux box. I downloaded MySQLGUI, and ran it. > It connects fine, I can view a table, etc.. But, when I click on the > GRANT/REVOKE menu, it hangs on the Windows side. When I go to the Linux side and > issue SHOW PROCESSLIST, there are as many processes connected as I have ports > open. When I forcibly kill the MySQLGUI, and issue SHOW PROCESSLIST, it's back > to 'normal'. > > The above happens as SOON as a I click the GRANT/REVOKE menu item! I can view > the mysql.user table (by using the view table button), but, it dies when I go to > the GRANT/REVOKE menu item. > > David > Thanks. I will check it out. -- 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: Can't create a table with MySQLGUI
Scott Seong writes: > Hi, > > I'm newly acquinted with MySQL today, and made a very first attempt to > create a table with MySQLGUI. However, the "Commands-Tables-Create Tables" > menu option doesn't seemed implemented -- nothing happens. Is this something > that hasn't been implemented, or am I not using the tool correctly? I'm > using the Win32 Static Binary of MySQLGUI 1.7.5-2. Can you please help? > > Thank you, > Scott Seong > Hi! Create Table is on TODO -- 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: installations
Nathan A. Saint Clair writes: > I'm looking for instructions on installing the mysql GUI interface on a unix system. > Is that possible? Thank you, > > Nathan Of course it is possible. What Unix system. There are binaries for Linux and some other Unix systems ready so that you can download the one for your Unix. If there is not one, you have to download a source, and follow instructions in INSTALL file, which imply download and build of several libraries. -- 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: BUG: Need option to disable "tty" check in mysql client
Shankar Unni writes: > Please treat this as a fairly urgent problem. It's simple to fix, but the > effects of the bug are a severe loss of functionality under Win32. > > Several options in the mysql client (--batch, --silent, etc.) have no > corresponding options to reverse that behavior (e.g. --no-batch, > --no-silent, etc.), which is generally accepted option style. > [skip] > > Thanks much in advance, > -- > Shankar Unni. Thank you for your recommandations, we shall definitely implement, some of those, especially the one on TTY check. -- 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: installing mysql 3.23.43 - unrecognized option
Douglas B. Jones writes: > Hi, > > On Tru64 5.1, I am trying to install mysql 3.23.43. I follow > the steps in section 2.3 of running scripts/mysql_install_db. > It comes back with the error: > > /usr/local/mysql-test/libexec/mysqld: unrecognized option `--password=reqid' > > a password I never typed in. After that, it gives the usage > help for the command. Does anyone have any pointers to what > I am doing wrong? > > Thanks, > Cheers, > Douglas > Hi! Please check out whether you have some global config file, like /etc/my.cvf with password option under [mysqld] options header. -- 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: Re: SSL in version 3 and 4
Joel Rees writes: > Hi. > > My coworker needs to check how well SSL is supported in which versions. > > Any comments on SSL in v. 3? or about the stability of v. 4? > > Joel Rees > [EMAIL PROTECTED] > SSL i supported in MySQL 4, which is now in alpha stability phase. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MySQL 4.0 compile fails on Linux]
Ed Carp writes: > >Description: > > make[3]: Entering directory `/usr/local/src/mysql-4.0.0-alpha/sql' > gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local\"" - > DDATADIR="\"/usr/local/var\"" -DSHAREDIR="\"/usr/local/share/mysql > \"" -DHAVE_CONFIG_H -I../innobase/include -I./ > ../include -I./../regex-I. -I../include -I. > -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c sql_lex.c > c > sql_lex.cc: In function `void lex_init()': > sql_lex.cc:85: `symbols' undeclared (first use this function) > sql_lex.cc:85: (Each undeclared identifier is reported only once > sql_lex.cc:85: for each function it appears in.) > sql_lex.cc:85: confused by earlier errors, bailing out > make[3]: *** [sql_lex.o] Error 1 > Hi! Do: bk -r edit The above is defined in lex.h -- 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: MySQLGUI hangs on certain commands
David Wolf writes: > I've been trying to play with MySQLGUI lately (running the win32 version of > the GUI, Linux version of the server). I can connect fine. Run queries fine. > But, when I try to do any grants on a database or edit a table, the client > connects to the server as many times as it can (before the server runs out > of connections available) and hangs until I forcibly kill it. Does anyone > know why that would happen?? > > Thanks, > > David Hi! Editing table in MySQLGUI should make no problems, since it does nothing. It has not been done yet. Regarding grants, GRANT / REVOKE dialogu does not connect to database until you click on 'Apply' button. Then a command is executed and connection is closed. Can you describe in more detail how you managed to run out of connections only with MySQLGUI, so that I might repeat a case. -- 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: make fails on AIX 4.3.3 using the IBM xlc/xlC compiler
Thank you for your report. -- 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: Problems with TCP Wrappers
Thank you for your notes. I do not think, however that logging of successfull connections will be added, as we have many installations which operate in LAN/WAN environment with many users. Not to mention that sites that have highest load have separate servers for MySQL and separate for WWW server. In shout, it would make a mess. -- 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: Memory allocators / STL
Sander Pilon writes: > > [skip] > > I don't know if it works with the standard mysql++, as we use an > internal mysql++ clone. > > Regards, > > Sander > Hi! There is a patch for standard MySQL++ to enable it to be built and used with STLPort. I do not think that latest GNU 3 STL is any worse then STLPort. But I do know one thing for sure. Multi-threaded application that utilizes C++ exceptions and libstdc++ will have terrible problems, when many threads are generated and when there is lot of context switching. It is enough to build MySQL server with libstdc++ linked in, to experience problems. -- 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: Sun/Solari 8 64bit and Mysql
[EMAIL PROTECTED] writes: > Hello, > > sorry that I'm bothering you, but I havent fount answer to question: > Does MySQL take any advantage from SUN SPARC/Solaris 8 64bit > architecture. I think there may be little adavatage when I compile mysql > with 64bit Forthe compiler than 32bit gcc, because Forthe uses then > 64bit librarys. But best result will encounter when mysql is designed > for 64bit archidecture. > > With best regards, > Andres Ma"gi Hi! Yes, MySQL will take full advantage of SPARC's 64 bit architecture. Latest GNU compilers also support full 64 bits on SPARC. -- Consider taking our support. Visit : https://order.mysql.com 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: Update JDBC Driver (gweMysql Driver)
TAKAHASHI, Tomohiro writes: > Hi, All > I Fixed two bugs. > > 1. If LoginUser has empty password, Driver can not connect to MySQL. > 2. Connection Pool does not work correctly. ;-) > > > Check this URL out for new Driver. :-) > http://www.t3-jpn.com/jdbc/jdbcmysql.html > Thank you so much. -- 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: C++ Newbie
Francois Barnard writes: > Hi i have got borland 5.5 commandline compiler and i have just downloaded > c++ api for mysql.What must i do with the include files to get it to work > > Francois > > Hi! Just include sqlplus.hh -- 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: Memory allocators / STL
[EMAIL PROTECTED] writes: > Do you know if this is the case even with the GCC v3.0.1? > What is the "recommended" combination of compiler / STL implementation in order > to work properly with MySQL client? > > Thanks! > > /Stefan > Yes, it is as I use the same compiler. MySQL client can be used with plethora of compilers. Of the GNU family, any from 2.95 or 3.* series will be just fine. Regarding STL, it MUST be the one that came with the corresponding compiler version. Mixing GNU compiler versions with libstdc+ from some other version leads straight to catastrophe ... -- 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: Memory allocators / STL
[EMAIL PROTECTED] writes: > Hi! > > We are currently developing a MT server (pthreads based, the main thread > does accept() and push_back to a vector that the threads pick up work from, > the threads share a global hash_map of cached information protected by a > pthread_rwlock) and we seem to have an issue with confliting memory allocators > (locking). > > Our server is based purely on STL and we can get desent performance if we > compile it using the GCC/libstd++ flag __USE_MALLOC but this seems to lead > to high level of memory defragmentation since the server is bogged down > after a while of high load. From time to time we alse get memory leaks that > we can't pinpoint to anything else than fragmentation... > > Has anyone had this problem? I am sending this to the MySQL list since it > seems like the problem arises in combination with the mysql client library. > How does mysql allocate memory (treadsafety) and how could this collide with > the approach that the STL/GCC 3.0.1 does things? > > Thanks! > > /Stefan Hi! It is very well known that most C++ compilers have huge problems with threads when used in conjuction with C++ exceptions. GNU has this problem even agravated, as even if you do not use C++ exceptions, libstdc++ does, so you will have problems. The only solution is not to use C++ exceptions and not to use libstdc++ with GNU C++. -- 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: MySQLGUI for MacOS 10.1
Garry Nevin writes: > Can anyone advise which, if any versions of the MySQLGUI posted can be run > under MacOS 10.1 please? > > Garry Nevin > -- > No, there is none. But it would not be impossible to build one, if you get in touch with developer that ported FLTK to Mac. You can find him at www.fltk.org under Bazaar. If you use X server under 10.1, then it would be trivial to build it. -- 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: mysqlcheck and mysql_convert_table don't quote table names
[EMAIL PROTECTED] writes:
> >Description:
> mysql-utilities mysqlcheck and mysql_convert_table don't quote
> table names and so fail in converting/checking/repairing
> specially named tables.
>
> >How-To-Repeat:
> create e.g. a table `A-22bd` and run mysqlcheck on it:
>
> # mysqlcheck test
> mysqlcheck: Got error: 1064: You have an error in your SQL syntax near '-22bd
>' at line 1 when executing 'CHECK TABLE ...
>
> The same problem exists in mysql_convert_table.
> When quoting the table name, everything works fine from the mysql
> monitor.
>
> >Fix:
> Changing line 72 in mysql_convert_table from
>if (!$dbh->do("ALTER TABLE $table type=$opt_type"))
> to
>if (!$dbh->do("ALTER TABLE \`$table\` type=$opt_type"))
> fixes the problem for mysql_convert_table.
>
> It would also a nice idea to include '--quote-names' as a default
> in mysqldump since without this option above mentioned tables
> aren't dumpable.
>
> >Submitter-Id:
> >Originator: Anders Henke
> >Organization: Schlund+Partner AG
> >MySQL support: none
> >Synopsis:mysqlcheck and mysql_convert_table don't quote table names
> >Severity:serious
> >Priority:low
> >Category:mysql
> >Class: sw-bug
> >Release: mysql-3.23.43 (Source distribution)
> >Server: /usr/bin/mysqladmin Ver 8.21 Distrib 3.23.43, for pc-linux-gnu on i686
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
>
> Server version3.23.43-Max-log
> Protocol version 10
> ConnectionLocalhost via UNIX socket
> UNIX socket /var/run/mysqld/mysqld.sock
> Uptime: 9 hours 37 min 2 sec
>
> Threads: 6 Questions: 1516479 Slow queries: 234 Opens: 239639 Flush tables: 2
>Open tables: 64 Queries per second avg: 43.801
> >Environment:
> System: Linux rdb6 2.4.10 #1 SMP Thu Oct 4 14:29:57 CEST 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/2.95.2/specs
> gcc version 2.95.2 2220 (Debian GNU/Linux)
> Compilation info: CC='gcc' CFLAGS='-O6 -fomit-frame-pointer' CXX='gcc'
>CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
>LDFLAGS='-static'
> LIBC:
> lrwxrwxrwx1 root root 13 Jun 7 19:47 /lib/libc.so.6 ->
>libc-2.1.3.so
> -rwxr-xr-x1 root root 888192 Jun 9 17:39 /lib/libc-2.1.3.so
> -rw-r--r--1 root root 2090160 Jun 9 17:40 /usr/lib/libc.a
> -rw-r--r--1 root root 178 Jun 9 17:40 /usr/lib/libc.so
> Configure command: ./configure --prefix=/usr --libexecdir=/usr/sbin
>--localstatedir=/var/mysql/data --enable-shared --without-perl --without-readline
>--without-docs --without-bench --with-mysqld-user=mysql --with-extra-charsets=all
>--enable-assembler --with-raid --with-mysqld-ldflags=-all-static
>--with-client-ldflags=-all-static --with-charset=latin1 --with-bench
> Perl: This is perl, version 5.005_03 built for i386-linux
>
Hi!
Thank you for your bug report.
--
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: query memory problem
Elm Gysel writes:
> Hello,
>
> I have a memory problem when added records to a table.
> The situation is like this (simplyfied) :
>
> query << "select id, symbol from " << STOCKS_TABLE_NAME << std::ends;
> std::vector symbols;
> query.storein(symbols);
> std::vector::iterator I;
> for(I = symbols.begin(); I != symbols.end(); I++) {
> query.reset();
> query << "select max(date_time) from " << HISTORY_TABLE_NAME <<
> " where symbol_id='" << I->id << "'";
> Result result = query.store();
>
> query << "insert into " << HISTORY_TABLE_NAME <<
>" values(%0, %1, %2, %3, %4, %5, %6)";
> /** let query object know this is a template and not a normal query */
> query.parse();
>
> (for loop that will insert 2000 records each time)
> for(.) {
> /** get date */
>
>/* perform query */
>query.execute(nr, Date.str(), Op, Hi, Lo, Cl, Vo);
> The problem is in the above line I think. If I comment it out the memory
> usage doesn't explode.
> I get around 1.5MB more mem usage each time I insert 2000 records.
> I have no clue what might go wrong here.
>}
> }
>
>
> After 10 times adding 2000records I have a memory usage of like 30MB. Are
> there any memory leaks involved in using the query object? Am I doing
> something wrong?
>
>
> Thanks for any help!
>
> Elm
Hi!
The only possible cause for memory being used more, is in member field
str of the type SQLString. If your query object is local, or that
memory will be freed automatically at the end of the block.
It is possible that it is a memory leak, and it would be nice if you
could try out one thing. If you would add str.empty() in the execute
method in query2.hh and re-build MySQL++ and your program and check
memory usage then, that would be very nice of you.
--
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: Problem
piyush shrivastav writes: > Hi > I am student of Indian institute Of Technology > Madras(India) I downloaded your beta version of > MySqlGui for linux. But it is saying cannot connect to > server. even after i edited .cnf files. Further i am > unable to set password for any of clients i made. > please help me to get through it > > yours truely > Piyush Shrivastav > Ch99082 > IIT Madras > Chennai > T.N > India Hi! mysqlgui does not set password. You can turn on "Ask for password" button, so that mysqlgui always asks you for password. You can also store your password in .my.ini file, as explained in the manual. -- 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: Instant Mysql server crash problem with berkeley db enabled
Please try to reproduce a bug with our MySQL-Max binary for Linux. Your compiler and glibc versions are a bit too old for the current MySQL sources. -- 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: GNU question
Anthony Evans writes: > Hi all, > > I am using the MySQL book by Paul DuBois. Apparently on page 74 mysql has > the GNU Readline library built in. When trying an input edit command such as > 'Up arrow, Ctrl-P' to recall the previous line when I am at the Dos prompt > within MySQL all I ever get is a right triangle. None of the commands seem > to work, they only ever come up with the right triangle. > > What am I doing wrong ? > > Your help would be most appreciated. > > Regards, > > Anthony Use mysqlc.exe, while first copying cygwin.dll to DLL directory. -- 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: Query Analyzer
Moshe Gurvich writes: > Are there tools for MySQL like MS SQL Query Analyzer, that can analyze and > estimate effectivity of a query? > > Or is it possible to approximate execution plan of queries that will be run > on MySQL with above mentioned utility? > > Thank you. > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.281 / Virus Database: 149 - Release Date: 9/18/2001 > > > Hi! In order to find out how MySQL will process a query, run EXPLAIN on the query. If you would like to know how to improve stuff, add "..procedure analyse" at the end of your query. -- 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: Problem compiling MySQL 4.0 with GCC 3.0.1
Fournier Jocelyn [Presence-PC] writes: > Hi, > > I know this problem has already been reported (but I don't remember the > solution :( ) : > > I encounter the following error after installing gcc 3.0.1 and trying to > compile MySQL 4.0 : > > mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x14): undefined reference to > `__cxa_pure_virtual' > mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x18): undefined reference to > `__cxa_pure_virtual' > mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x30): undefined reference to > `__cxa_pure_virtual' > collect2: ld returned 1 exit status > gmake[2]: *** [mysqlbinlog] Error 1 > > What should I do to make MySQL compile ? > > Thank you ! > > Jocelyn Fournier > Presence-PC Hi! Edit client/Makefile and sql/Makefile and set CXXLD=g++ That is all. -- 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: ORDER BY bug; must also select column that is being ordered by
Hi! Try our 3.23.44 binary for Linux as soon as it is out, and let us know if the problem persists. -- 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: Could not load module libz.a(shr.o) for run scripts/mysql_install_db
[EMAIL PROTECTED] writes: > >Description: >The following is the error message: > #scripts/mysql_install_db > Could not load program ./bin/my_print_defaults: > Dependent module libz.a(shr.o) could not be loaded. > Could not load module libz.a(shr.o). [skip] Hi! This is a known deficiency which we shall try to avoid in the next AIX build. -- 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: MyISAM API
DL Neil writes: > > Wendy Dillon writes: > > Sinisa, > > On behalf of those of us who take advantage of the 'ready made' versions (eg my Win >download) [or who should not be > allowed near naked flames, C compilers, or buttons marked "Do NOT press"], could >these examples of 'internal > documentation' be reproduced and made available on a suitable website please? > > =dn > It is actually publicly available in our BitKeeper repository. -- 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: import fails when lines are too long
Hi! Please upload your file.sql, gzipped or zipped, to: ftp://support.mysql.com:/pub/mysql/secret and let me know the filename. -- 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: MyISAM API
Wendy Dillon writes: > Hi everyone, > > I realise that a number of people have already asked this but as it was a > while ago thought more info may now be available: > > Is there any documentation for the MyISAM C API yet apart from the source > code? > > In previous discussions of accessing MyISAM directly I see 2 issues that are > frequently highlighted, the first being that the API is not available in > client/server mode which does not affect my project and the second being > that it is not possible to access the same data through SQL and MyISAM at > the same time because of concurrency problems. This could be a major issue. > Could anyone expand on this point? I can see from the source code that > there is locking provided through calls to the MyISAM library, does anyone > have any info on this? > > I would be grateful for any information, particularly from anyone who has > directly accessed (or attempted to directly access) MyISAM databases, > reading and writing records. > > Thanks, > > Wendy > Hi! In 4.0.0 source code, you will find Docs subdir and in it myisam.txt. Rest is up to you ... -- 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: Utilizing the Database Server's Cache
Jeremy Zawodny writes: > > Monty recently proposed some changes to MySQL's client/server protocol > which will enable "real" prepared statements. So I'd guess it'll > happen somewhere in the 4.x tree. > > > Also just out of curiousity, how much of a performance hit does > > mysql take in compiling an execution plan? > > My understanding is that it's not a big deal unless you want to really > pound your server with queries. My gut feel is that the effort which > goes into parsing the query is similar (in order of magnitude) to > actually deciding how to execute the query. The query cache will help > the parsing overhead and the prepared queries will help the execution > planning. > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.41-max: up 44 days, processed 980,576,760 queries (254/sec. avg) Just for the uninitiated : MySQL++ supports prepared queries through it's template queries classes. -- 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: Installation from Source
On Sun, 21 Oct 2001 14:24:12 -0700 (PDT) Deepanshu Shukla <[EMAIL PROTECTED]> wrote: Hi! This list, [EMAIL PROTECTED] is devoted to the internal functioning of MySQL server. -- Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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: Possible bug in self-join order optimization
On Sat, 20 Oct 2001 12:48:36 -0500 Eric <[EMAIL PROTECTED]> wrote: I wouldn't be opposed to implementing this as a part of the join optimizer in MySQL, in fact, I've been reading through it for a few days now... However, it seems like it would be a large project as the join optimizer does not take WHERE conditions on the joins into account at all when estimating number of rows coming from a table. In addition, I would probably need to start storing some more metadata in order to facillitate the kind of optimization I need... has anyone thought We will definitely take a look at this optimizer glitch. -- Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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: Possible bug in self-join order optimization
Eric writes: > I have no problem using STRAIGHT_JOIN, etc. My problem is really just > figuring out the optimal join order. Is doing a "SELECT COUNT" on > each of the tables I'm going to join the way to do it? Isn't there > potential for the count to take as long as the full query processing > would take (especially since the attribute I'm doing a range on is not > indexed)? > > eric. > > -- > _ _ > | |(_) http://ir.iit.edu/~ej > | _| | | Page me via ICQ at > | |___ | | http://wwp.mirabilis.com/19022931 > |__/ | or by mailing [EMAIL PROTECTED] > |__/ > Well , first of all this is recommandation only until we further improve the optimiser. In most applications relative sizes of tables do not change drastically. It is extremely rare that a tabla A that has 1000 times less rows then table B would in short time have 1000 times more rows then table B. -- 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: Possible bug in self-join order optimization
Eric writes: > Well, answering my own email, what I thought was a bug is not one at > all. I was mistaken in thinking that MySQL paid any attention to the > WHERE conditions when optimizing the join order beyond determining > which keys are used for the join, correct? > > This is really terrible for queries like mine where the query could be > sped up by orders of magnitude if the join optimizer would just > determine which table in the join to scan and which to do the key > lookup on based on a more intelligent estimation of the number of rows > from each table. It would have to go beyond looking at what keys are > used in the join (since each of the tables in my query can be looked > up by the same key) and account for the WHERE conditions placed on the > tables in the join. > > Is there sufficient metadata to estimate rows coming from a table > based on conditions placed on the attributes of that table? Where is > it? Has anyone ever thought of coding this? Can anyone give me a > place to start? > > eric. > > > -- > _ _ > | |(_) http://ir.iit.edu/~ej > | _| | | Page me via ICQ at > | |___ | | http://wwp.mirabilis.com/19022931 > |__/ | or by mailing [EMAIL PROTECTED] > |__/ > What information do you precisely require ?? The answer also depends on the API you are using and a method of retrieval. For example, you can know how many rows you get if you use _store_ instead of _use_ method, but that method is not applicable in the case of larger result sets. -- 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: Possible bug in self-join order optimization
On Fri, 19 Oct 2001 13:03:02 -0500 Eric <[EMAIL PROTECTED]> wrote: > Well, answering my own email, what I thought was a bug is not one at > all. I was mistaken in thinking that MySQL paid any attention to the > WHERE conditions when optimizing the join order beyond determining > which keys are used for the join, correct? > > This is really terrible for queries like mine where the query could be > sped up by orders of magnitude if the join optimizer would just > determine which table in the join to scan and which to do the key > lookup on based on a more intelligent estimation of the number of rows > from each table. It would have to go beyond looking at what keys are > used in the join (since each of the tables in my query can be looked > up by the same key) and account for the WHERE conditions placed on the > tables in the join. > > Is there sufficient metadata to estimate rows coming from a table > based on conditions placed on the attributes of that table? Where is > it? Has anyone ever thought of coding this? Can anyone give me a > place to start? > > eric. HI! At least, with LEFT JOIN you can always specify precisely which table is to be scanned and which to be searched by key. In other joins, you can use STRAIGHT_JOIN with correct order of tables in order to achieve the same. Yes, the above is little bit harder to be done with dynamically created queries, but it is still possible, as you can always get number of rows. -- Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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: MySQLGUI problem
cedric writes: > MySQLGUI-1.7.5 was working. > Now, when I start it and put the mouse pointer over it, it disappears. > Reinstalled only to get the same thing. > > Any ideas? > > cedric > What operating system do you use ?? Have you changed X version or window manager ?? I never heard of something like that. -- 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: Two bugs with complex aggregate functions.
Philip Lijnzaad writes: > > > Upload your file to this directory : > > >ftp://support.mysql.com:/pub/mysql/secret > > Done. > > -- > The mail transport agent is not liable for any coffee stains in this message > - > Philip Lijnzaad, [EMAIL PROTECTED] European Bioinformatics Institute,rm A2-08 > +44 (0)1223 49 4639 Wellcome Trust Genome Campus, Hinxton > +44 (0)1223 49 4468 (fax) Cambridgeshire CB10 1SD, GREAT BRITAIN > > Sorry, it is 0 bytes long !! -- 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
