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 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
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
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!
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
