Op 07-08-2023 om 21:16 schreef [email protected]:
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 [email protected] https://lists.sourceforge.net/lists/listinfo/synalist-public
