对结果使用此查询
SELECT GROUP_CONCAT(CONCAT(`username` , '-',`id`) SEPARATOR ',')
FROm table1;
结果
GROUP_CONCAT(CONCAT(`username` , '-',`id`) SEPARATOR ',')
rap-1,dafy-2,kay-3 .
示例PHP代码wuth PDO
<?php
try {
$pdo = new PDO('mysql:host=localhost;dbname=databasename', 'username', 'password');
} catch (PDOException $e) {
echo 'Verbindung fehlgeschlagen: ' . $e->getMessage();
}
$sql = "SELECT GROUP_CONCAT(CONCAT(`username` , '-',`id`) SEPARATOR ',') user FROM Table1";
foreach ($pdo->query($sql) as $row) {
echo $row['user']."<br />";
}
$pdo ->close();
?>