Janusz Mordarski januszm

## mysql_table_size.sql
SELECT
  TABLE_NAME AS `Table`,
  ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = "mydatabase"
ORDER BY
  (DATA_LENGTH + INDEX_LENGTH)
DESC;

## mysql_json_data_where.rb
```ruby
record = Model.where("data->'$.somearray[0].email' = ?", email).first
```

## hash_array_to_csv.rb
class Array
  def to_csv(csv_filename="hash.csv")
    require 'csv'
    CSV.open(csv_filename, "wb") do |csv|
      csv << first.keys # adds the attributes name on the first line
      self.each do |hash|
        csv << hash.values
      end
    end
  end
	SELECT
	TABLE_NAME AS `Table`,
	ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`
	FROM
	information_schema.TABLES
	WHERE
	TABLE_SCHEMA = "mydatabase"
	ORDER BY
	(DATA_LENGTH + INDEX_LENGTH)
	DESC;
	```ruby
	record = Model.where("data->'$.somearray[0].email' = ?", email).first
	```
	class Array
	def to_csv(csv_filename="hash.csv")
	require 'csv'
	CSV.open(csv_filename, "wb") do \|csv\|
	csv << first.keys # adds the attributes name on the first line
	self.each do \|hash\|
	csv << hash.values
	end
	end
	end