the error said connection async function is not function. but definetly is a function. what the error is exatcly?

> 
> connection(...).execute is not a function
> 
> 
> 

```
const mysql = require('mysql2/promise');

const options =
{
    'host'              : '127.0.0.1',
    'port'              : 3306,
    'user'              : 'pandora',
    'password'          : 'pandora',
    'database'          : 'pandora',
    'supportBigNumbers' : true
};

async function connection(){
    return await mysql.createConnection(options);
}

```

route

```
app.get('/', async () => {
  const [rows] = await connection().execute('SELECT * FROM media');

  res.send(rows.length);
});

```