DSLContext dslContext = DSL.using(connection, SQLDialect.MYSQL); Result<Record> result = dslContext.select().from(TABLE_NAME).fetch(); <generator> <database> <name>org.jooq.meta.mysql.MySQLDatabase</name> <includes>.*</includes> <excludes></excludes> <inputSchema>public</inputSchema> </database> <target> <packageName>com.example.db</packageName> <directory>src/main/java</directory> </target> </generator> UsersRecord user = dslContext.selectFrom(USERS).where(USERS.ID.eq(1)).fetchOne();