*************

SQL code: Upload Copy Format Clear

DROP TABLE IF EXISTS `foo`; CREATE TABLE foo ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, firstname VARCHAR(100) NOT NULL, lastname VARCHAR(100) NOT NULL, address VARCHAR(100) DEFAULT NULL, tel VARCHAR(100) NOT NULL, size VARCHAR(100) NOT NULL, weight VARCHAR(100) NOT NULL ) ;

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php function implode_flds(array $row){ $str = ''; $del = ''; foreach ($row as $f) { if (is_null($f) or strtoupper($f) == 'NULL'){ $f = 'NULL'; } elseif (is_string($f)){ $f = '\'' . $f . '\''; } $str .= $del.$f; $del = ','; } return $str; } $names = array_fill(0, 50000, array('foofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoofoo', 'lnlnlnlnlnlnlnlnlnlnlnlnfoofoofoofoofoofoofoofoofoofoo', null, 'teltelteltelteltelteltelteltelteltelfoofoofoofoofoofoofoofoofoofoo', 'szszszszszszszszszszszszszszszszfoofoofoofoofoofoofoofoofoofoo', 'wghwghwghwghwghwghwghwwghwghwghwghwghwghwghwfoofoofoofoofoofoofoofoofoofoo')); $start = microtime(true); $insert = 'INSERT INTO `foo` (firstname, lastname, address, tel, size, weight) VALUES '; foreach ($names as $name) { $insert .= '('.implode_flds($name).'),'; } $pdo->query(trim($insert, ',')); $duration = microtime(true) - $start; echo 'Duration: '.$duration; echo PHP_EOL; $start = microtime(true); $insert = 'INSERT INTO `foo` (firstname, lastname, address, tel, size, weight) VALUES '; foreach($names as $name) $insert.= '(?,?,?,?,?,?),'; $names = array_merge(...$names); $stmt = $pdo->prepare(trim($insert, ',')); $stmt->execute($names); $duration = microtime(true) - $start; echo 'Duration: '.$duration;

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online