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
