Editing InnoDB
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
| Latest revision | Your text | ||
| Line 1: | Line 1: | ||
{{Draft}} | {{Draft}} | ||
| − | [[wikipedia:InnoDB]] | + | [[wikipedia:InnoDB]] |
InnoDB supports: | InnoDB supports: | ||
| − | * Both SQL and XA | + | * Both SQL and XA transactions |
* [[Tablespaces]] | * [[Tablespaces]] | ||
* [[Foreign keys]] | * [[Foreign keys]] | ||
| Line 10: | Line 10: | ||
* Spatial operations, following the OpenGIS standard | * Spatial operations, following the OpenGIS standard | ||
* Virtual columns, in [[MariaDB]] | * Virtual columns, in [[MariaDB]] | ||
| − | |||
== Activities == | == Activities == | ||
| − | * Show | + | * Show database engine: <pre>show table status like '<table name>';</pre> |
| + | |||
== Related commands == | == Related commands == | ||
* <code>[[mariadbcheck]]</code>, can checked InnoDB tables with CHECK TABLE, but not repaired them with REPAIR TABLE | * <code>[[mariadbcheck]]</code>, can checked InnoDB tables with CHECK TABLE, but not repaired them with REPAIR TABLE | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
== Activities == | == Activities == | ||
| Line 43: | Line 23: | ||
== See also == | == See also == | ||
| − | * {{ | + | * {{DBs}} |
| − | * | + | * [[primary keys]] |
| − | |||
[[Category:Databases]] | [[Category:Databases]] | ||
Advertising:
