How to write and read list from mysql database?

Question

Python

I decided to ban some commands for the bot. According to the plan, the owner will use a command (for example /deactivate <command>), after which the bot pulls out a list from the database, writes the disabled command there and then sends the list back to the database. I don’t quite understand how to read the sheet normally, the output will be a string in the form["help", "info", ...]

Answer 1

import ast
    
data = '["help", "info"]'
result = ast.literal_eval(data)
print(type(result), result)

Ps Thanks to the kind reminder of my friend FanatPHP , here is a relatively safer option:

import json
    
data = '["help", "info"]'
result = json.loads(data)
print(type(result), result)