```sql
CREATE TABLE users (
id int NOT NULL,l
name varchar(255) NOT NULL,
date date,
datetime datetime,
bool boolean
) ENGINE=InnoDB;
INSERT INTO users VALUES
(1,'one','2024-11-26', '2024-11-26 00:03:00', true),
(2,'two', NULL, NULL, false),
(3,'three', NULL, NULL, NULL);
```
```typescript
import { Client } from "https://deno.land/x/mysql/mod.ts";
const client = await new Client().connect({
hostname: "db",
port: 3306,
username: "user",
db: "bruno",
password: "password",
});
async function handler(request: Request): Promise<Response> {
const url = new URL(request.url);
const table = url.searchParams.get("table");
const result = await client.execute(`select * from ??`, [table]);
return Response.json(result.rows);
}
Deno.serve(handler);
```
```json
[
{
"id": 1,
"name": "one",
"date": "2024-11-26T00:00:00.000Z",
"datetime": "2024-11-26T00:03:00.000Z",
"bool": 1
},
{
"id": 2,
"name": "two",
"date": null,
"datetime": null,
"bool": 0
},
{
"id": 3,
"name": "three",
"date": null,
"datetime": null,
"bool": null
}
]
```