Instantly share code, notes, and snippets.

maximal/table-structure.my.sql

CreatedJuly 5, 2022 08:35

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/maximal/d713223dd716af0934ed6dd95076082d.js"></script>
Save maximal/d713223dd716af0934ed6dd95076082d to your computer and use it in GitHub Desktop.

Clone this repository at <script src="https://gist.github.com/maximal/d713223dd716af0934ed6dd95076082d.js"></script>

Save maximal/d713223dd716af0934ed6dd95076082d to your computer and use it in GitHub Desktop.

Структура таблиц MariaDB / MySQL

	-- Структура таблиц MariaDB / MySQL
	-- Порядок колонок не сохранён, таблицы и колонки отсортированы в алфавитном порядке
	-- Удобно для сравнения структур нескольких баз, можно делать дифф
	--
	-- @since 2022-07-05
	-- @author MaximAL

	SELECT table_name, column_name, column_default, is_nullable, data_type,
	character_maximum_length, character_octet_length, numeric_precision, numeric_scale,
	datetime_precision, character_set_name, collation_name
	FROMINFORMATION_SCHEMA.columns
	WHERE table_schema='database_name'
	ORDER BY table_name, column_name

Movatterモバイル変換