Warning Re: My details [INF2003082300000269]

... /Christian Andersson [EMAIL PROTECTED] wrote: Thanks for writing to [EMAIL PROTECTED] This is an auto-generated response to let you know that your message has reached our general information box on 8/23/2003 at 5:38:55 AM. Customer Service will be processing and, if necessary, responding to your

Problem with windows XP and mysql

at all would perheps be helpfull... Oh one more thing... now that 4.12 has been released.. how easy/hard is it to upgrade 4.10 gamma to 4.12 ? just stop the server, install the new version over the old, and start the server? /Christian Andersson

Re: creating update files

the exact same result? even eith line endings? or could they return 2 different queries and therefore making the md5 calculating prove worthless? or are there other ways to get to the database structure that work the same on different platforms...? /Christian Andersson

creating update files

of changes, but it requires more labour... so, how do you all manage this? /Christian Andersson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

test

Since just before christmas I have not gotten any e-mails from the mysql-mailing list... so I send this to test my access, can anyone see it? Please reply in private so that I know if it works or not... /Christian Andersson

Re: Executing a \. or source function from an API

./mysql -uuser -ppassword database script.sql might just do that! :-) - Original Message - From: Curtis Spencer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 21, 2001 11:56 AM Subject: Executing a \. or source function from an API I have a big file full of ANSI SQL

Re: Nested Queries.

Subqueries are not (yet)working in mysql, they will be implemented in the 4.0.x or is it 4.x which hopefully will be out very soon :-) so if you are using the 3.23.xxx you have to stick with temporary tables /Christian - Original Message - From: Larry Reiter [EMAIL PROTECTED] To:

group by, order by, temporary table

Hi there, I'm back with yet some questions about group by/order by in mysql.. My first question is how group by is beeing done if I have have columns in the select query that is not in the group by statement. Dring many test with 3.23-42 (Myisam tables) I found out that the content of the

Re: select 10 of each

hi there.. no solution from me, but I'm also interested in this type of query (although I only want 1 for each lang) I also wants it in 1 query, not multiple (it would be to many queries) so any answer to this one please please reply to me to :-) although I do read here also... /Christian -

Re: Sorting through results

Well there is one easy sollution (if I understand your qestion correctly) What I think you want is an history of old properties and values.. so what to do? well create a history table that hold all these old values and then the normal table only contains 1 value for each property.. So whenever

Re: Query Execution Time Perl/DBD

The obvious way to do this would be to get the time before and after the execution and then make a simple diff (after - before) I guess that is how the mysql client does it (butI'm not sure) I do not think that mysql itself provides this information.. how to get the time in Perl/DBD I do not

Re: order by, group by

Thank you for your responce, you have guessed it correctly the only difference is the usage of MAX which I cannot use (see my explenation on what I want to do in a seperate message) I'm not sure IF I can do it with sub-selects either, but when subselects is present in mysl, I could try that

Re: order by, group by

(if there is anyone reading this by now :-) someone out there knows how rows are inserted, retrieved from temporary tables and how group by works.. but I'd still would like to do this in a single query (order by before group by perhepes? :- /Christian Andersson

Idea about extending Limit/mysql query

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

order by, group by

in mysql it would be faster since there would atleast be less to transfer from mysql to my application (java/jdbc based) or are there other tricks I can use to get what I want? /Christian Andersson - Before posting, please check

Re: Connection timeout and pooling

for this last sollution.. hope it helps! /Christian Andersson - Original Message - From: Sylvain Hamel [EMAIL PROTECTED] To: MySQL Mailing list [EMAIL PROTECTED] Sent: Friday, November 09, 2001 3:50 PM Subject: Connection timeout and pooling IDE : JBuilder 4 prof I am using pooling in order

Re: java.util.Date, jdbc, and DATETIME

a datetime also, but not the mm.mysql jdbc.. if this is a bugor just a stricter handlingI do not know.. but that is most likely your problem /Christian Andersson - Before posting, please check: http://www.mysql.com/manual.php

looping

wanted 8 rows I would get 1, 5, 7, 1, 5, 7, 1, 5 as output.. I'm currently doing this looping in my application but it would speed things up if mysql could do this for me.. since I could then do some joins and retrieve values from other tables faster. /Christian Andersson

Linux mysql problems....

is not working...) If you ahve any ideas on these subjects I'd be glad to hear it! /Christian Andersson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list