mysql 输出json_如何将MySQL数据库导出为JSON？

如果您使用的是Ruby，另一个解决方案是使用ActiveRecord将连接脚本写入数据库。您需要安装第一

安装了activerecord

# ruby ./export-mysql.rb

require 'rubygems'

require 'active_record'

ActiveRecord::Base.establish_connection(

:adapter => "mysql",

:database => "database_name",

:username => "root",

:password => "",

:host => "localhost"

)

class Event < ActiveRecord::Base; end

class Person < ActiveRecord::Base; end

File.open("events.json", "w") { |f| f.write Event.all.to_json }

File.open("people.json", "w") { |f| f.write Person.all.to_json }

您还可以，如果你想先处理数据或包含或排除某些列方法添加到ActiveRecord的类。

Person.all.to_json(:only => [ :id, :name ])

有了ActiveRecord，您不仅限于JSON。您可以轻松导出为XML或YAML

Person.all.to_xml

Person.all.to_yaml

您不仅限于MySQL。任何由ActiveRecord支持的数据库(Postgres，SQLite3，Oracle ...等)。

而且值得一提的，你可以打开另一个句柄到数据库

require 'active_record'

ActiveRecord::Base.configurations["mysql"] = {

:adapter => 'mysql',

:database => 'database_name',

:username => 'root',

:password => '',

:host => 'localhost'

}

ActiveRecord::Base.configurations["sqlite3"] = {

:adapter => 'sqlite3',

:database => 'db/development.sqlite3'

}

class PersonMySQL < ActiveRecord::Base

establish_connection "mysql"

end

class PersonSQLite < ActiveRecord::Base

establish_connection "sqlite3"

end

PersonMySQL.all.each do |person|

PersonSQLite.create(person.attributes.except("id"))

end