How do I insert and view data from Classic Tables using python in MySQL Shell?
How do I insert/view data from classic tables in MySQL shell using python?
In the MySQL manual it says to use these operations.
>db.name.insert()
>db.name.select()
However when I attempt to use the operations I get this error:
>IndexError: unknown attribute: insert.
>IndexError: unknown attribute: select.
Operations such as MyTable = db.get_table('table_1') work fine. The tables are classic tables, which I believe may be apart of the issue. I have tried
>import classic
but received an error saying there was no module named classic
I am using the latest version of MySQL Shell, and version 5.7.18 of MySQLServer
Subject
Written By
Posted
How do I insert and view data from Classic Tables using python in MySQL Shell?
June 05, 2017 01:04PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.