I am new in SQL programming, I have a problem:
(Note: I can read/write a local paradox table in Delphi, I can read a Mysql table from Delphi, and I can read/write a MySQL database From PHP These are on same PC), I want to insert a new record (with MySQL ODBC) into a MySql Table, but the system message is: Table not open for insert or append...
query1.add (select * from table)
I think my user(root) has all privilages.
Plz Help Me!!!!