MySQL Forums
Forum List  »  Newbie

How do I insert and view data from Classic Tables using python in MySQL Shell?
Posted by: Cameron Wright
Date: June 05, 2017 01:04PM

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

Options: ReplyQuote


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.