Script Stop Working!

[angel_scream]

I have a script in mode:

Select * from t1 join t2 on t1.Station=”Kneja” and t1.SendingDate=”31.11.2006″ and t1.Station=t2.Station and t1.SendingDate=t2SendingDate join t3 on t1.Station=t3.Station and t1.SendingDate=t3.SendingDate

Before preinstalling Windows it has working properly and I have a generated rezult from this query! But after preinstalling Windows 2002 SP3 on MySQL 5.0.27 server version with SQLyog 5.22 it gives me only column names on the three tables that combines and respectively there is no any data rezult viable!!! SQLyog didn't gave me any possible error code from this query. I rewrote the script with RIGHT JOIN syntax and then appeared a table with data in it, but also two additional empthy tabels.

I changed the data format from the Controll Panel Settings. But it is the same!!!

I think I gave you details about what I have done and have tryed script working,but it didn't execute like a query! May be the problem is something else? Please help me what can I do too?

I'm waiting for your replies! Thanks a lot in advance!!!

[peterlaursen]

It simply looks like the query returns an empty resultset! We cannot comment more as we do not have the data.

I do not understand 'preinstalling Windows' .. do you mean 'reinstalling Windows'? The only think I can think of is lattercase problems with databasenames and tablenames. Maybe the 'lower_case_table_names' variable has changed?

(read http://dev.mysql.com/doc/refman/5.0/en/ide…nsitivity.html).

I think you will need to 'break down' the query: first try one join, next another and next both.

[angel_scream]

peterlaursen wrote on Jul 9 2009, 05:01 PM:

It simply looks like the query returns an empty resultset! We cannot comment more as we do not have the data.

I do not understand 'preinstalling Windows' .. do you mean 'reinstalling Windows'? The only think I can think of is lattercase problems with databasenames and tablenames. Maybe the 'lower_case_table_names' variable has changed?

(read http://dev.mysql.com/doc/refman/5.0/en/ide…nsitivity.html).

I think you will need to 'break down' the query: first try one join, next another and next both.

Hi! And thanks a lot for the reply!

Yes it is about 'reinstalling Windows'. But I rewrote the query with 3 JOINS,the way you told me, and it worked, I got the rezult from my 3 tables!

I'm going to write you again if there arised any problems in similar case!

Regards,

Ina

[Author]

Posts