MySQL - Revision history

Paul at 15:35, 5 December 2019

2019-12-05T15:35:21Z

← Older revision		Revision as of 15:35, 5 December 2019
Line 21:		Line 21:
	* [https://github.blog/2016-08-01-gh-ost-github-s-online-migration-tool-for-mysql/ gh-ost: GitHub’s online schema migration tool for MySQL]		* [https://github.blog/2016-08-01-gh-ost-github-s-online-migration-tool-for-mysql/ gh-ost: GitHub’s online schema migration tool for MySQL]
	* [https://www.red-gate.com/simple-talk/cloud/cloud-data/designing-highly-scalable-database-architectures/ Designing Highly Scalable Database Architectures] - Not specific to MySQL.		* [https://www.red-gate.com/simple-talk/cloud/cloud-data/designing-highly-scalable-database-architectures/ Designing Highly Scalable Database Architectures] - Not specific to MySQL.
			* [https://mariadb.com/kb/en/library/backup-and-restore-overview/ MariaDB: Backup and restore overview]

	[[Category:MySQL]]		[[Category:MySQL]]

Paul at 14:28, 10 October 2019

2019-10-10T14:28:23Z

← Older revision		Revision as of 14:28, 10 October 2019
Line 10:		Line 10:
	REFERENCED_TABLE_SCHEMA = 'database' AND		REFERENCED_TABLE_SCHEMA = 'database' AND
	REFERENCED_TABLE_NAME = 'table';		REFERENCED_TABLE_NAME = 'table';

			== Update a random selection of rows ==

			To update approximately 50% of rows:

			UPDATE table SET column = 'value' WHERE RAND() < 0.5

	== Links ==		== Links ==

Paul: /* Show foreign keys for a given table */

2019-06-10T13:23:25Z

Show foreign keys for a given table

← Older revision		Revision as of 13:23, 10 June 2019
Line 3:		Line 3:
	https://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column		https://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column

	SELECT		SELECT
	TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME		TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
	FROM		FROM
	INFORMATION_SCHEMA.KEY_COLUMN_USAGE		INFORMATION_SCHEMA.KEY_COLUMN_USAGE
	WHERE		WHERE
	REFERENCED_TABLE_SCHEMA = 'database' AND		REFERENCED_TABLE_SCHEMA = 'database' AND
	REFERENCED_TABLE_NAME = 'table';		REFERENCED_TABLE_NAME = 'table';

	== Links ==		== Links ==

Paul at 13:23, 10 June 2019

2019-06-10T13:23:11Z

← Older revision		Revision as of 13:23, 10 June 2019
Line 1:		Line 1:
			== Show foreign keys for a given table ==

			https://stackoverflow.com/questions/201621/how-do-i-see-all-foreign-keys-to-a-table-or-column

			SELECT
			TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME
			FROM
			INFORMATION_SCHEMA.KEY_COLUMN_USAGE
			WHERE
			REFERENCED_TABLE_SCHEMA = 'database' AND
			REFERENCED_TABLE_NAME = 'table';

	== Links ==		== Links ==

Paul at 15:13, 18 April 2019

2019-04-18T15:13:46Z

← Older revision		Revision as of 15:13, 18 April 2019
Line 2:		Line 2:

	* [https://github.blog/2016-08-01-gh-ost-github-s-online-migration-tool-for-mysql/ gh-ost: GitHub’s online schema migration tool for MySQL]		* [https://github.blog/2016-08-01-gh-ost-github-s-online-migration-tool-for-mysql/ gh-ost: GitHub’s online schema migration tool for MySQL]
			* [https://www.red-gate.com/simple-talk/cloud/cloud-data/designing-highly-scalable-database-architectures/ Designing Highly Scalable Database Architectures] - Not specific to MySQL.

	[[Category:MySQL]]		[[Category:MySQL]]

Paul: Created page with "== Links == * [https://github.blog/2016-08-01-gh-ost-github-s-online-migration-tool-for-mysql/ gh-ost: GitHub’s online schema migration tool for MySQL] Category:MySQL"

2019-03-26T15:26:39Z

Created page with "== Links == * [https://github.blog/2016-08-01-gh-ost-github-s-online-migration-tool-for-mysql/ gh-ost: GitHub’s online schema migration tool for MySQL] Category:MySQL"

New page

== Links ==

* [https://github.blog/2016-08-01-gh-ost-github-s-online-migration-tool-for-mysql/ gh-ost: GitHub’s online schema migration tool for MySQL]

[[Category:MySQL]]