insert query not inputing 1 million results

Asked Mar 24 '17 at 10:15

Active Mar 24 '17 at 10:15

Viewed 33 times

I am having trouble cross computing and inserting the results from 2 different tables into another one,

table structure

2_o contains 210 results

4_e contains 5985 results

all_combinations should theoretically contain after cross computing the results 210 * 5985 = 1,256,850 results

my query is working thus my only problem is that its not reaching the result that it should 1,256,850 and it seems that its not finishing and cutting every time on a different total. no idea why. 1,247,102 or 1,153,550 etc...

<?php
$sql = mysql_connect("localhost", "root", "mysql");
if (!$sql) {
    die("Could not connect: " . mysql_error());
}
mysql_select_db("numbers");
  $result = mysql_query("INSERT INTO all_combinations (o1,o2,e1,e2,e3,e4) SELECT n2.o1, n2.o2, n4.e1, n4.e2, n4.e3, n4.e4 FROM 2_o AS n2, 4_e AS n4");
  echo "done";
if (!$result) {
    die("Could not input results. " . mysql_error());
}

edited Jun 20 '20 at 09:12

Community

asked Mar 24 '17 at 10:15

shadow byentek

**STOP!** Before you go any further stop using Mysql_* as it is now deprecated. You need to look into using Mysqli or PDO. – Option Mar 24 '17 at 10:17
may be you need to increase php function execution time – krishn Patel Mar 24 '17 at 10:19
@Option no need, its a one time use query – shadow byentek Mar 24 '17 at 10:19
@knowledge.... how do i do that ? – shadow byentek Mar 24 '17 at 10:19
refere this http://stackoverflow.com/a/15776426/2286537 – krishn Patel Mar 24 '17 at 10:26

insert query not inputing 1 million results

0 Answers0