Archive:PHP and MySQL Programming/Basic Queries: Difference between revisions
wikademia>The Kid New page: == Introduction == Here are a few basic queries to get you going. For more detailed information, have a look at the online documentation on the MySQL website http://dev.mysql.com/doc/refm... |
wikademia>Wikademia m moved PHP and MySQL Programming/Basic Queries to Archive:PHP and MySQL Programming/Basic Queries over redirect |
||
| (11 intermediate revisions by 4 users not shown) | |||
| Line 2: | Line 2: | ||
Here are a few basic queries to get you going. For more detailed information, have a look at the online documentation on the MySQL website http://dev.mysql.com/doc/refman/5.1/en/index.html . | Here are a few basic queries to get you going. For more detailed information, have a look at the online documentation on the MySQL website http://dev.mysql.com/doc/refman/5.1/en/index.html . | ||
{{?}} | |||
== SELECT == | == SELECT == | ||
| Line 100: | Line 100: | ||
| REBUILD PARTITION partition_names | | REBUILD PARTITION partition_names | ||
| REPAIR PARTITION partition_names | | REPAIR PARTITION partition_names | ||
| REMOVE PARTITIONING | | REMOVE PARTITIONING | ||
== DROP == | == DROP == | ||
| Line 114: | Line 114: | ||
mysql> TRUNCATE table_name; | mysql> TRUNCATE table_name; | ||
[[ | [[../Creating a Table/|Previous: Creating a Table]] | [[../|TOC]] | [[../Common Functions and Operators/|Next: Common Functions and Operators]] | ||
[[Category:MySQL]] | |||
[[Category:PHP and MySQL Programming|{{SUBPAGENAME}}]] | |||