Where is Release mysql-4.1.2a-alpha-win.zip
Hi, searching for latest MySQL-Downloads I see there's no mysql-4.1.2a-alpha-win.zip available by now on - for example - ftp://ftp.fh-wolfenbuettel.de/pub/database/mysql/Downloads/MySQL-4.1/. http://dev.mysql.com/downloads/mysql/4.1.html links the file mysql-4.0.20a-win-noinstall.zip in the MySQL-4.1 directory on MySQL-Download FTP-Servers as 4.1 release without installe. Is that correct? Best, Bernhard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Subselect in aggregate function in MySQL 4.1.1a-alpha
Hi Victoria, that's exactly what I needed. Works fine. I know Subselects only from Intrbas/Firebird so far. I know that I can pass a SELECT to the list of columns of a SELECT if it only returns one result (one col, one row). So I thought/hoped/imagined/expected I can pass a SELECT returning multiple rows in only one col to an aggregate function. Thanks and bye, Bernhard - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 19, 2004 2:34 PM Subject: Re: Subselect in aggregate function in MySQL 4.1.1a-alpha [EMAIL PROTECTED] wrote: Hi, I have some logging data from a webserver in a table and want to do some analysis. I infact want to see how many files are requested at one time. To do this I SELECT COUNT(time) anz FROM table GROUP BY time ORDER BY anz DESC This gives me the number of requests at any time. I now want to see the average number of requests per time. I thus thought I can use a subselect like SELECT AVG(SELECT COUNT(time) anz FROM table GROUP BY time) FROM table That seems impossible, it in fact simply does not work. Is it wrong by my design or is it MySQL design not to pass a subselect to an aggregate function? If I've got you right you need: SELECT AVG(anz) FROM (SELECT COUNT(time) anz FROM table GROUP BY time) as table1; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: date_format function - German
Look in your my.ini file. There's maybe an entry: language=f:/mysql/share/german Set it to your favourit language! Bernhard - Original Message - From: Steve Vernon [EMAIL PROTECTED] To: Mysql List [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 4:47 PM Subject: date_format function - German I have read and searched the internet, but I cannot find much on getting mysql to return German and other languages months. Is there codes you use? I really would prefer to use the English MySQL (if there is such a one) as I don't know much German, and need the error messages in English! I suppose I could return the month as a number, and then output the text from that, but this seems a bit tacky! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cant connect to Mysql server on 'localhost' (10061)
Hi, have you setup a my.ini File? mine looks like: [mysqld] basedir=f:/mysql datadir=f:/mysql/data language=f:/mysql/share/german Bernhard - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 31, 2003 4:11 AM Subject: Cant connect to Mysql server on 'localhost' (10061) Does anyone else get this message after installing and attempting to run mysql (version 4.0.12)?? I downloaded and installed mysql-4.0.12-win.zip file. then from the command prompt, I typed mysqld to start the service. Then I typed mysql and I got the error message: Cant connect to Mysql server on 'localhost' (10061) Am I doing something wrong ?? I checked and confirmed that mysql is running as a service on my PC, but I noted when using the winmysqladmin tool that no mysql server was being specified - probably the cuase of the problem, but how do I fix it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Soon?
You have to compile loads of statically linked libraries before compiling and linking the app. Bernhard - Original Message - From: Martin Gainty [EMAIL PROTECTED] To: Michael Edlund [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, March 28, 2003 12:38 AM Subject: Re: Soon? Hej Michael- In order to to see 4.1 mysqladmin working I started to compiling the 4.1 source obtained from bitmaker Originally I had 1000 errors with 1000 unresolved link errors.. I am down to about 50 on both counts God Tur- Martin - Original Message - From: Michael Edlund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 2:41 PM Subject: Soon? http://www.mysql.com/downloads/mysql-4.1.html Binaries will be available soon. Soon has in this context shown to be very relative... :-) What milestones have yet to be reached before binaries for MySQL 4.1 are being made available? Michael Helloworld Media Box 13085, 103 02 Stockholm, Sweden Visitors: Nytorgsgatan 15, Stockholm Email: [EMAIL PROTECTED] Web: http://helloworld.se Mobile: +46-(0)70-370 19 99 Phone: +46-(0)8-644 10 23 Fax: +46-(0)8-643 96 76 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Fulltext search -- no wildcards in phrases?
I once got this answer to a similar question on another group. http://www.mail-archive.com/[EMAIL PROTECTED]/msg00280.html Bernhard - Original Message - From: Nick Arnett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 27, 2003 8:59 PM Subject: Fulltext search -- no wildcards in phrases? It appears to me that fulltext phrase searches cannot include wildcards. For example, I would expect app* serv* to match application server, application services, etc. But it returns no results, so I'm having to run each variation separately. Can anyone confirm that wildcards, indeed, can't be used in phrase searches. I'm doing these in Boolean mode because I need exact counts of occurrences. This is on MySQL-4.0.12-nt. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mySQL on Windows 2000 Server
Not only is MySQL a native Win2k app, but it also runs as a NT-Service... Bernhard - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 28, 2003 2:34 PM Subject: re: mySQL on Windows 2000 Server On Friday 28 March 2003 11:23, Neil Tompkins wrote: Has anyone installed mySQL on Windows 2000 server, can you tell me your experiences, or should I look for another option ? MySQL is a native win32 application and runs excellent on Win2k. It's a good choice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AW: InterBase vs. Mysql
Despite of this When I see your picture on: http://www.mysql.com/company/management.html I think you were the one to explain the relation between MySQL and Firebird.to me on CeBIT 2002 :-) Bernhard - Original Message - From: David Axmark [EMAIL PROTECTED] To: Bernhard Döbler [EMAIL PROTECTED] Sent: Monday, March 24, 2003 9:17 PM Subject: Re: AW: InterBase vs. Mysql The person booking CeBIT works in out Finnish office. And the Finnish boot had a good deal. So no special reasons. /David On Mon, 2003-03-24 at 09:18, Bernhard Döbler wrote: This Year MySQL booth on CeBit looked much more professional, but why was it feastured by MySQL Finland? Benrhard - Original Message - From: David Axmark [EMAIL PROTECTED] To: Bernhard Döbler [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, March 21, 2003 8:13 PM Subject: Re: AW: InterBase vs. Mysql On Hannover CeBit'2002 I talked to a guy from MySQL AB. It was the time the Firebird 1 release was delayed because of errors in the SQL engine. The guy told me he knew about the problem because MySQL follows the development of InterBase respective Firebird since it potentially would be a concurrent if more people knew about it. MySQL I went to dinner with two key Firebird people just a few weeks ago after FOSDEM in Brussles. So we are pretty friendly with the firebird people and we will try to move some of the features they have to MySQL. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: InterBase vs. Mysql
This Year MySQL booth on CeBit looked much more professional, but why was it feastured by MySQL Finland? Benrhard - Original Message - From: David Axmark [EMAIL PROTECTED] To: Bernhard Döbler [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, March 21, 2003 8:13 PM Subject: Re: AW: InterBase vs. Mysql On Hannover CeBit'2002 I talked to a guy from MySQL AB. It was the time the Firebird 1 release was delayed because of errors in the SQL engine. The guy told me he knew about the problem because MySQL follows the development of InterBase respective Firebird since it potentially would be a concurrent if more people knew about it. MySQL I went to dinner with two key Firebird people just a few weeks ago after FOSDEM in Brussles. So we are pretty friendly with the firebird people and we will try to move some of the features they have to MySQL. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqld-nt vs mysqld-max-nt
It's IMHO the only difference... Have you looked up the documentation? Bernhard - Original Message - From: Dan Cumpian [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 13, 2003 3:45 AM Subject: mysqld-nt vs mysqld-max-nt MyISAM tables) and I'm a bit confused by what's in the max binary. Is the biggest difference InnoDB tables? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Fw: phpMyAdmin
- Original Message - From: [EMAIL PROTECTED] To: Bernhard Döbler [EMAIL PROTECTED] Sent: Thursday, March 13, 2003 9:09 AM Subject: Re: Fw: phpMyAdmin Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query,queries,smallint If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi, again for the whole list... it's a feature introduced with later versions on phpMyAdmin. Book don't change as fast as software does. :-) I never used this feature an don't know what it's good for. phpMyAdmin works though! Bernhard - Original Message -=20 From: Stephen Tiano [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 08, 2003 9:29 PM Subject: phpMyAdmin =20 [bullet] Error The additional Features for working with linked Tables = have=20 been deactivated. To find out why, click here. =20 Clicking 'here' brings me to a link to 'Documentation' and a line=20 underneath saying 'General relation features Disabled'. Clicking on=20 'Documentation' brings me to what looks vaguely like directions for=20 altering various '$cfg' strings. =20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Simple C API question
Why is the standard-receiver of a reply to the list, the original poster, not the list itself? - Original Message - From: Bernhard Döbler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 9:58 AM Subject: Re: Simple C API question Hi Travis, so far I see, you cannot simply interpret 'length' as the length in bytes of the corresponding byte string in the MYSQL_ROW. Think of the Type VARCHAR. The length member of the FIELD tells you the maximum, the row gives you the string in the actual length. So far I know the Strings in the ROW are zero-terminated so you can use it with ease and the regular C-character-functions. http://www.mysql.com/doc/en/mysql_fetch_row.html Regards Bernhard - Original Message - From: Travis McLeskey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 10:04 PM Subject: Simple C API question Question: Can I reliably interpret 'length' as the length in bytes of the corresponding byte string in the MYSQL_ROW, and is there a usual way to extract these data into regular C datatypes? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Simple C API question
This mail is a repost using words like: sql,query,queries,smallint I have written the following: Hi, I experience it on some list! The problem is, someone posts a questions I cannot answer but I'm = interested in a solution. I never get it because the questioner gets the = answers via private mail. Bernhard - Original Message -=20 From: Andrew [EMAIL PROTECTED] To: Bernhard D=F6bler [EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 10:21 AM Subject: RE: Simple C API question because you are the sender! Not the list also not everyone wants to = see the replies to every message can you image the traffic and and ... the = emaisl you would receive if you saw all the replies to every thread as some lists = tend to be. =20 =20 -Original Message- From: Bernhard D=F6bler [mailto:[EMAIL PROTECTED] Sent: 26 February 2003 09:00 To: [EMAIL PROTECTED] Subject: Fw: Simple C API question Why is the standard-receiver of a reply to the list, the original poster, not the list itself? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hash-Functions
Hi, there's a Password()-Function in MySQL. Can somebody tell my on what standard is based (MD5 etc.) and if there's something similar in a DBMS that also supports triggers? InterBase does not support many functions... Thanks Bernhard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: libmysqld.lib
Hey, libmysqld is for a long time already part of the MySQL 4.x Source-Distribution. Bernhard - Original Message - From: Derick Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, February 19, 2003 11:35 PM Subject: libmysqld.lib Hi! I want to emebed libmysqld.lib into a DLL I am making for Visual Basic. I need to make the DLL in C because it is going to perform other functions (i.e I do not want to use the Public Declare in VB to access the DLL). I need the libmysqld.lib library. I could use LoadLibrary to load it dynamically, but I think this would be more work. Does anyone know where I can get it? Does anyone know when it will be available on the mysql.com website? Does anyone know when the source code for the libmysqld.dll will be distributed (Windows version)? (I thought mysql was open source?) Thanks Eric _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AW: InterBase vs. Mysql
Hi, the OpenSource GPL'd version of InterBase 6.01 is called Firebird and is available from: http://sourceforge.net/projects/firebird On Hannover CeBit'2002 I talked to a guy from MySQL AB. It was the time the Firebird 1 release was delayed because of errors in the SQL engine. The guy told me he knew about the problem because MySQL follows the development of InterBase respective Firebird since it potentially would be a concurrent if more people knew about it. MySQL IMHO very much develops it's feature-richness towards InterBase keeping it's own simplicity. InterBase for instance knows subselects but why use a complicated subselect if a MySQL (LEFT) JOIN is so fast and easy to write? Just my two Euro-cents :-) Regards Bernhard - Original Message - From: Ben Clewett [EMAIL PROTECTED] To: Rusch (ext) Reiner [EMAIL PROTECTED] Cc: Inandjo Taurel [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 18, 2003 1:29 PM Subject: Re: AW: InterBase vs. Mysql Here there are very little competitive DBMS systems. But there are some, and more each day. PostgreSQL, MSDE, SapDB, OpenInterbase (or what ever it's called). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Datentypen
http://www.mysql.com/doc/en/Column_types.html - Original Message - From: n etman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 14, 2003 9:13 AM Subject: Datentypen Hallo Liste, als MySql Einsteiger hätte ich gerne eine Liste der Datentypen mit Beschreibung. Leider kann ich diese nicht in der Doku finden. Schon mal vielen Dank im vorraus. Ingo Döring - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fulltext
Hi, is there a possibility to query a column with a FULLTEXT-INDEX for a word fragment? I mean if there's the word skyscraper in a column I want to find it looking for sky and also looking for crap. It seems to me it does not work with something like: match(column) against(*crap*) Regards Bernhard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 libmysqld - can't connect to remote DB as client.
Hi, I didn't get your code but I haven't read all mails received through the night... But I these days don't find the time to analyze it. I've only once experimented with libmysqld so far and didn't enjoy it very much since the INNO-tables storing the table-linking-information, the transactions etc. are at least 20 MB. Am I wrong? Is there a configuration option making libmysqld consuming less hard-disk-space? Bernhard - Original Message - From: Steven Webb [EMAIL PROTECTED] To: Bernhard_Döbler [EMAIL PROTECTED] Cc: Mysql list [EMAIL PROTECTED] Sent: Wednesday, November 06, 2002 8:09 PM Subject: Re: using libmysqld - can't connect to remote DB as client. Did you get my code? I sent it to the list, but the list bounced it because the list didn't allow attachments. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php