Create database schema document - Revision history

Unknown user: /* PostgreSQL: DDL document */

2022-11-10T09:59:50Z

PostgreSQL: DDL document

← Older revision		Revision as of 17:59, 10 November 2022
Line 73:		Line 73:
	</pre>		</pre>

	{{exclaim}} The parameter {{kbd \| key=<nowiki><MY_TABLE></nowiki>}} is before than ~~the~~ parameter {{kbd \| key=<nowiki><MY_DATABASE></nowiki>}}		{{exclaim}} The parameter {{kbd \| key=<nowiki><MY_TABLE></nowiki>}} is before than another parameter {{kbd \| key=<nowiki><MY_DATABASE></nowiki>}}

	== References ==		== References ==

2022-11-10T09:57:06Z

PostgreSQL: DDL document

← Older revision		Revision as of 17:57, 10 November 2022
Line 72:		Line 72:
	pg_dump -st <MY_TABLE> <MY_DATABASE> --schema-only > schema.sql		pg_dump -st <MY_TABLE> <MY_DATABASE> --schema-only > schema.sql
	</pre>		</pre>

			{{exclaim}} The parameter {{kbd \| key=<nowiki><MY_TABLE></nowiki>}} is before than the parameter {{kbd \| key=<nowiki><MY_DATABASE></nowiki>}}

	== References ==		== References ==

2022-10-12T10:57:41Z

2022-10-12T06:16:34Z

PostgreSQL: DDL document

← Older revision		Revision as of 14:16, 12 October 2022
Line 67:		Line 67:

	== PostgreSQL: DDL document ==		== PostgreSQL: DDL document ==
	[https://serverfault.com/questions/231952/is-there-an-equivalent-of-mysqls-show-create-table-in-postgres postgresql - Is there an equivalent of MySQL's SHOW CREATE TABLE in Postgres? - Server Fault]		[https://www.postgresql.org/docs/current/app-pgdump.html PostgreSQL: Documentation: 14: pg_dump]<ref>[https://serverfault.com/questions/231952/is-there-an-equivalent-of-mysqls-show-create-table-in-postgres postgresql - Is there an equivalent of MySQL's SHOW CREATE TABLE in Postgres? - Server Fault]</ref>

	<pre>		<pre>
	pg_dump -st <MY_TABLE> <MY_DATABASE> --schema-only > schema.sql		pg_dump -st <MY_TABLE> <MY_DATABASE> --schema-only > schema.sql

2022-10-05T02:33:11Z

2022-10-05T02:31:40Z

PostgreSQL: Table document (Schema)

← Older revision		Revision as of 10:31, 5 October 2022
Line 63:		Line 63:
	WHERE		WHERE
	a.table_name = '<MY_TABLE>';		a.table_name = '<MY_TABLE>';
			</pre>


			== PostgreSQL: DDL document ==
			[https://serverfault.com/questions/231952/is-there-an-equivalent-of-mysqls-show-create-table-in-postgres postgresql - Is there an equivalent of MySQL's SHOW CREATE TABLE in Postgres? - Server Fault]
			<pre>
			pg_dump -st <MY_TABLE> <MY_DATABASE> --schema-only > schema.sql
	</pre>		</pre>

2022-10-04T10:52:50Z

@@ Line 2: / Line 2: @@
 Create database schema document from existing MySQL database.
-== Table document ==
+== MySQL: Table document (Schema) ==
 Sample result of mysql query using {{kbd | key=EXPLAIN}} syntax<ref>[https://dev.mysql.com/doc/refman/8.0/en/explain.html MySQL :: MySQL 8.0 Reference Manual :: 13.8.2 EXPLAIN Syntax]</ref>: {{kbd | key =<nowiki>EXPLAIN <table></nowiki>}}
 <pre>
@@ Line 18: / Line 18: @@
 # Copy the table to other word processors
-== DDL document ==
+== MySQL: DDL document ==
 [https://en.wikipedia.org/wiki/Data_definition_language Data definition language] (DDL): Sample result of mysql query: {{kbd | key =<nowiki>SHOW CREATE TABLE <table></nowiki>}}
 <pre>
@@ Line 32: / Line 32: @@
 * [http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]
 == References ==

2020-06-01T09:12:54Z

← Older revision		Revision as of 17:12, 1 June 2020
Line 13:		Line 13:

	Steps of create database schema document for MySQL		Steps of create database schema document for MySQL
	# Using [https://www.phpmyadmin.net/ phpMyAdmin]		# Using web-based database management software such as: [https://www.phpmyadmin.net/ phpMyAdmin] or [https://www.adminer.org/ Adminer]
	# SQL query: {{kbd \| key =<nowiki>EXPLAIN <table></nowiki>}} or {{kbd \| key =<nowiki>SHOW FULL COLUMNS FROM <table></nowiki>}}		# SQL query: {{kbd \| key =<nowiki>EXPLAIN <table></nowiki>}} or {{kbd \| key =<nowiki>SHOW FULL COLUMNS FROM <table></nowiki>}}
	# Click "Print view (with full texts)"		# (for phpMyAdmin) Click "Print view (with full texts)"
	# Copy the table to other word processors		# Copy the table to other word processors

2018-10-30T10:23:34Z

Table document

← Older revision		Revision as of 18:23, 30 October 2018
Line 3:		Line 3:

	== Table document ==		== Table document ==
	Sample result of mysql query<ref>[https://dev.mysql.com/doc/refman/8.0/en/~~show-columns~~.html MySQL :: MySQL 8.0 Reference Manual :: 13.~~7.6~~.~~5 SHOW COLUMNS~~ Syntax]</ref>: {{kbd \| key =<nowiki>EXPLAIN <table></nowiki>}}		Sample result of mysql query using {{kbd \| key=EXPLAIN}} syntax<ref>[https://dev.mysql.com/doc/refman/8.0/en/explain.html MySQL :: MySQL 8.0 Reference Manual :: 13.8.2 EXPLAIN Syntax]</ref>: {{kbd \| key =<nowiki>EXPLAIN <table></nowiki>}}
	<pre>		<pre>
	Field \| Type \| Null \| Key \| Default \| Extra		Field \| Type \| Null \| Key \| Default \| Extra
	</pre>		</pre>
	~~sample~~ result of mysql query: {{kbd \| key =<nowiki>SHOW FULL COLUMNS FROM <table></nowiki>}}		Sample result of mysql query using {{kbd \| key=SHOW}} syntax<ref>[https://dev.mysql.com/doc/refman/8.0/en/show-columns.html MySQL :: MySQL 8.0 Reference Manual :: 13.7.6.5 SHOW COLUMNS Syntax]</ref>: {{kbd \| key =<nowiki>SHOW FULL COLUMNS FROM <table></nowiki>}}
	<pre>		<pre>
	Field \| Type \| Collation \| Null \| Key \| Default \| Extra \| Privileges \| Comment		Field \| Type \| Collation \| Null \| Key \| Default \| Extra \| Privileges \| Comment

2018-10-30T08:07:55Z

← Older revision		Revision as of 16:07, 30 October 2018
Line 3:		Line 3:

	== Table document ==		== Table document ==
	Sample result of mysql query: {{kbd \| key =<nowiki>EXPLAIN <table></nowiki>}}		Sample result of mysql query<ref>[https://dev.mysql.com/doc/refman/8.0/en/show-columns.html MySQL :: MySQL 8.0 Reference Manual :: 13.7.6.5 SHOW COLUMNS Syntax]</ref>: {{kbd \| key =<nowiki>EXPLAIN <table></nowiki>}}
	<pre>		<pre>
	Field \| Type \| Null \| Key \| Default \| Extra		Field \| Type \| Null \| Key \| Default \| Extra
Line 31:		Line 31:
	Tools: SQL syntax beautifier		Tools: SQL syntax beautifier
	* [http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]		* [http://www.dpriver.com/pp/sqlformat.htm Instant SQL Formatter]


			== References ==
			<references />


	Related pages:		Related pages: