SELECT wird unterschiedlich ausgeführt

2006-09-29 Thread Peter Stöcker
Hallo zusammen! Ich habe die Frage vor ein paar Tagen bereits ins MySQL-Forum gestellt, aber leider hat da noch niemand geantwortet. Jetzt versuche ich es mal mit der Liste. Wäre super, wenn mit jemand von Euch helfen könnte, weil ich hier nach Wochen des Probierens nicht weiterkomme: Ich hab

Number of tables

2002-10-14 Thread Peter Stöcker
Hi there! Does anybody know whether it is possible for MySQL to handle round about 500-600 tables in one database or not (Win2k)? Where is the maximum? I want to work with dynamically created tables. Thanks, Peter Keine verlorene

mysql@lists.mysql.com

2002-09-24 Thread Peter Stöcker
Hi there! Does anybody knows if there is a maximum in the number of tables for a database in MySQL. Of course it depends on the filesystem. But I want it to know for Win9x and Win2k. Thanks, Peter __ WEB.DE Club -

Re: Re: JOIN-Question

2002-09-19 Thread Peter Stöcker
ed. > > select t1.name, t1.f1, t1.f2, t2.f3, t2.f4, t3.f5, t3.f6 > from t1 left join t2 on (t1.name = t2.name) > left join t3 on (t1.name = t3.name) > where t2.f3 = 5 or t3.f6 = 16 > > cheers, > CH > > Peter Stöcker wrote: > > > Hi Mikhail! &g

Re: Re: JOIN-Question

2002-09-19 Thread Peter Stöcker
ldn't help you to implement this query (I don't know how to group by > rows). > Please, give more information about why do you need exactly this resultset. > > Best regards, > Mikhail. > > - Original Message - > From: "Peter Stöcker" <[EMAIL PROTECTED]

JOIN-Question

2002-09-19 Thread Peter Stöcker
Hi there! I have a question on JOINs. First the system: table1: name: t1 entries: name field1 field2 test 1 2 test2 3 4 table2: name t2

mysql-sc.1024928769.oooonpfpimocdimcncji-peter_stoecker=web.de@lists.mysql.com

2002-06-25 Thread Peter Stöcker
[EMAIL PROTECTED] schrieb am 24.06.02 16:38:01: > Hi! This is the ezmlm program. I'm managing the > [EMAIL PROTECTED] mailing list. > > To confirm that you would like > >[EMAIL PROTECTED] > > added to the mysql mailing list, please send > an empty reply to this address: > >[EMAIL PROT

RecordCount

2002-06-24 Thread Peter Stöcker
Hi there! I'm using MySQL with Delphi 5. After running a query i get a recordcount of -1. But when I check the result there are records. Can anybody help me? Thanks, peter __ FreeMail in der Premiumversion! Mit mehr