它可能会要求太多的MySQL期望它直接从查询生成格式正确的json。 相反,可以考虑使用CSV(使用INTO OUTFILE '/path/to/output.csv' FIELDS TERMINATED BY ','你已经知道INTO OUTFILE '/path/to/output.csv' FIELDS TERMINATED BY ','片段INTO OUTFILE '/path/to/output.csv' FIELDS TERMINATED BY ','来生成更方便的东西,然后将结果转换成带有内置支持的语言为它,像Python或PHP。
编辑 Python的例子,使用罚款SQLAlchemy:
class Student(object): '''The model, a plain, ol python class''' def __init__(self, name, email, enrolled): self.name = name self.email = email self.enrolled = enrolled def __repr__(self): return "" % (self.name, self.email) def make_dict(self): return {'name': self.name, 'email': self.email} import sqlalchemy metadata = sqlalchemy.MetaData() students_table = sqlalchemy.Table('students', metadata, sqlalchemy.Column('id', sqlalchemy.Integer, primary_key=True), sqlalchemy.Column('name', sqlalchemy.String(100)), sqlalchemy.Column('email', sqlalchemy.String(100)), sqlalchemy.Column('enrolled', sqlalchemy.Date) ) # connect the database. substitute the needed values. engine = sqlalchemy.create_engine('mysql://user:pass@host/database') # if needed, create the table: metadata.create_all(engine) # map the model to the table import sqlalchemy.orm sqlalchemy.orm.mapper(Student, students_table) # now you can iss