hi all!
i have a question regardin subselects or subqueries in the SELECT statement
i searched the manual yesterday but did not find any answer to this
in my SELECT statement i would like to do a subselect like this
SELECT t1.field1, t1.field2, (SELECT count(t2.field1) FROM table2 t2 WHERE
t2.f
yeah
but that wont really do it since the names are in two columns
so, there must also be a UNION included
do a union and then select distinct on the result from the union
that should do it (eller hur?)
-Ursprungligt meddelande-
Från: Jonas Lindén [mailto:[EMAIL PROTECTED]
Skickat: den 17
hi!
i am looking for a good mySQL gui for windows
i have used mySQL front, which was an excellent free program, but i did not handle
relations and diagrams. also the program is no longer being developed
i have now found the prog mySQL tools (http://www.mysqltools.com/) and mySQL explorer
that w
hi all!
i am currently working on a community projekt
the DB is a mySQL DB but i am not sure which engine to use
i know that innoDB supports foreign keys which i really want i order to
keep the data consistent since there will be a lots of insert, delete
and update activity with forums and guestbo
hi!
maybe i can help here
this is how to do it:
open up 2 connection windows with your source and destination databases
then click on im/export in the menu
select "export tables"
select which database and check the table/tables you want to export
in the output section on the same dialog select whe
