This morning, in #mysql
cornet — Thu, 2008-10-02 07:36
Some people are just too transparent :)
05:23 -|- MyName [n=MyName@********************] has joined #mySql
05:23 <MyName> if i have a table of 3 columns, and 3 rows, and i do a cartesian
product of the table with itself, do i get 6 columns and 9 rows?
05:24 <MyName> if the table originally have column names (A B C), do i get ( A
B C A B C) as the column names after the cartesian product?
05:24 <MyName> then all the entries are just each entry of the original tables
with each of the entreis again?
05:25 <MyName> or do i eliminate any duplicate columns?
... after no response for some time
06:21 <MyName> hello?
06:22 <pc_> hello
06:22 <Gm4n> hello!
06:27 <MyName> ok
06:27 <MyName> if i have two tables , one is movies(title, studio), and the other is stars(name, title)
06:28 <MyName> i want to find all stars who played in ALL movies by studio "ABC" for example
06:28 <MyName> not all stars who played in movies by studio ABC, but all stars who played in ALL movies by ABC
06:28 <pc_> MyName, when is it due?
06:28 <MyName> tomorrow
06:28 <pc_> lol
06:28 <Gm4n> haha
