thank you
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
On Mon, 7 Aug 2023 20:20:27 +0200
Rik van Kekem <r...@graficalc.nl> wrote:
> Op 07-08-2023 om 20:07 schreef paste...@gmx.com:
> >> Second command does a select host, user, password from user on the mysql
> > with my database db1 i get error with
> > sending command select host, user, password from user
> > Columns # 255
> > Answer from server: FF 7A 04 23 34 32 53 30 32 54 61 62 6C 65 20 27 64 62
> > 31 2E 75 73 65 72 27 20 64 6F 65 73 6E 27 74 20 65 78 69 73 74
> > We have an error 255
> > Error code: 1146,
> > seehttps://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html
> > Error mess: Table 'db1.user' doesn't exist
> >
> > it appends .user to the table name which in database db1 is table named
> > just db1
> user table is only a table in the database mysql. The database with all
> the info of mysql itself. It's not a table of your own db1 database. So
> if you want to view the users of mysql you need to connect to the mysql
> database (with USE MYSQL or directly during login). If you want another
> select from a table in your own db1 you should create your own SQL
> statement. BTW. Next step would be to create some sort of FieldDefs and
> TField for the actual data. And also to do GetNextRow. Grtz, Rik
_______________________________________________
synalist-public mailing list
synalist-public@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/synalist-public
