PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table test ( id int, data varchar(64) ); INSERT INTO test SELECT * FROM ( WITH RECURSIVE cte (depth, data) AS ( SELECT 0, 'data0' UNION DISTINCT SELECT depth+1, CONCAT('data', depth) FROM cte WHERE depth < 10 ) SELECT * FROM cte) t; SELECT * FROM test;
Copy Clear
Copy Format Clear
<?php $query = "SELECT MAX(id) AS max FROM test"; $stmt = $pdo->prepare($query); $stmt->execute(); $row = $stmt->fetch(PDO::FETCH_ASSOC); printf('Max id: %s', $row['max']); $query = "SELECT * FROM test WHERE id > ? LIMIT 1"; $stmt = $pdo->prepare($query); $stmt->execute([rand(0, $row['max']-1)]); $row = $stmt->fetch(PDO::FETCH_ASSOC); print_r($row);
Show:  
Copy Clear