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

n any information 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

Re: creating update files

me on different os:s ie if I have the same table on a windows machine and on a linux machine, does the above query return 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 o

creating update files

care of all type 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/

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 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 and a I want a script to be able to > tell Mysql to read this ANSI SQL file every few days because it

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:

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 wheneve

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

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 colum

Re: NULL Strings

Well considering that you are searching for the text 'NULL' and not a null value haveyou tried " level2 is null" ? :-) - Original Message - From: "Ward, Mark" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 6:37 PM Subject: NULL Strings > I don't know

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 kno

Idea about extending Limit/mysql query

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 .-)

Re: order by, group by

esc; select * from tmp_articles group by id; will do what I want, however if the temporary table:s rows are not retrieved inthe same order that they were inserted, or if the insert is not donw ordered or if the group by does not take the first row it finds for each group... then I'm at loss

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 one..

order by, group by

do 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

sql query help

I know, I know... this is not really an MySQL question but an ordinary SQL question.. but I need help with it.. Lets say that I have a table called test that has 3 columns test1,test2,test3 (what type they are are not interesting) columns test1 and test2 makes the primary key what I would like i

Re: Connection timeout and pooling

or sql/database I myself had to go 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: Conn

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

e :-) other jdbc:s this might set 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, ple

looping

example if i 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. /Chri

Linux mysql problems....

gain I CAN recreate the data even if the backup 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