A CROSS JOIN in MySQL returns the Cartesian product of rows from the tables in the join. In other words, it will produce rows which combine each row from the first table with each row from the second table. If the first table has 'n' rows and the second table has 'm' rows, the result will be n*m rows.