$sql";
$con->query($sql);
$sql = "CREATE TABLE $tname"
. " (name VARCHAR(30) DEFAULT NULL,"
. " vorname VARCHAR(25) DEFAULT NULL,"
. " personalnummer INT(11) NOT NULL,"
. " gehalt DOUBLE DEFAULT NULL,"
. " geburtstag DATE DEFAULT NULL,"
. " PRIMARY KEY (personalnummer)"
. " ) ENGINE=InnoDB DEFAULT CHARSET=UTF8";
echo "$sql
";
$con->query($sql);
$sql = "INSERT INTO $tname VALUES"
. " ('Maier', 'Hans', 6714, '3500', '1962-03-15'),"
. " ('Schmitz', 'Peter', 81343, '3750', '1958-04-12'),"
. " ('Mertens', 'Julia', 2297, '3621.5', '1959-12-30')";
echo "$sql
";
$con->query($sql);
$con->close();
?>