sorry i left the error on the line but with use mysql it works my
database is lower case mysql and not upper case MYSQL
On Mon, 7 Aug 2023 21:47:47 +0200
Rik van Kekem <r...@graficalc.nl> wrote:
> Op 07-08-2023 om 21:16 schreef paste...@gmx.com:
> > my MYSQL database is lowercase mysql and your code works
> > Writeln(MDB.Query('USE mysql'));
> > Writeln(MDB.Query('select host, user, password from user')); // db1,user
> > error
> You mean that you still get db1.user error after you did USE mysql ?
> For me that works.
>
> What was actually the use case?
>
> You can do a select but then you get the entire resultset back (which
> could be millions of records).
> You could also move those records to a memdataset.
>
> Or you could do a binary select (COM_STMT_EXECUTE) in which case you
> could do GetNext and retrieve a record per call.
> I haven't found a way to retrieve a few records at a time with the
> "text-protocol" but I could be missing it.
>
>
> Grtz,
> Rik
_______________________________________________
synalist-public mailing list
synalist-public@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/synalist-public
