You are right.
This was exactly temporary table:
$table = 'temp_products_orig_names'; $this->db->query(" CREATE TEMPORARY TABLE IF NOT EXISTS ?# ( `product_id` bigint(20) NOT NULL, `name` varchar(512) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; ", $table)
But this was only for second statement.
What about first one ? suppliers_delivery_speed is permanent table.
You are right.
This was exactly temporary table:
$table = 'temp_products_ orig_names' ; >db->query( "
$this-
CREATE TEMPORARY TABLE IF NOT EXISTS ?# (
`product_id` bigint(20) NOT NULL,
`name` varchar(512) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
", $table)
But this was only for second statement.
What about first one ? suppliers_ delivery_ speed is permanent table.