Difference between revisions of "MySQL"
Jump to navigation
Jump to search
(v 5.7) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 10: | Line 10: | ||
The MySQL package (at least in Linux) has a number of helper utilities available, including [[MySQL Workbench]] (a combination of the former [[MySQL Administrator]] and [[MySQL Query Browser]] applications). | The MySQL package (at least in Linux) has a number of helper utilities available, including [[MySQL Workbench]] (a combination of the former [[MySQL Administrator]] and [[MySQL Query Browser]] applications). | ||
==Articles== | ==Articles== | ||
| − | * ''Versions''': stuff particular to specific versions | + | * '''SQL Syntax''': |
| + | ** [[/GROUP_CONCAT]] | ||
| + | ** [[/INSERT]] | ||
| + | * '''Versions''': stuff particular to specific versions | ||
** [[/version/5.7]] | ** [[/version/5.7]] | ||
* '''Related''' | * '''Related''' | ||
| Line 29: | Line 32: | ||
** [http://dev.mysql.com/doc/refman/4.1/en/ Version 4.1 Manual] | ** [http://dev.mysql.com/doc/refman/4.1/en/ Version 4.1 Manual] | ||
* {{wikipedia}} | * {{wikipedia}} | ||
| − | * [http://hashmysql.org/ HashMySQL wiki]: official wiki of the unofficial-but-[http://dev.mysql.com/doc/refman/5.1/en/irc.html sanctioned] #mysql [[IRC]] channel on [[ | + | * [http://hashmysql.org/ HashMySQL wiki]: official wiki of the unofficial-but-[http://dev.mysql.com/doc/refman/5.1/en/irc.html sanctioned] #mysql [[IRC]] channel on [[freenode]] |
| + | |||
===How To=== | ===How To=== | ||
* '''repair munged tables''' | * '''repair munged tables''' | ||
Revision as of 16:37, 19 May 2021
About
MySQL is a FOSS database engine and server. It fills roughly the same niche as Microsoft SQL Server.
The MySQL package (at least in Linux) has a number of helper utilities available, including MySQL Workbench (a combination of the former MySQL Administrator and MySQL Query Browser applications).
Articles
- SQL Syntax:
- Versions: stuff particular to specific versions
- Related
- How-To:
- /porting/data: backing up and restoring
- /notes: disorganized information, mostly how-to
- Components:
- MySQL Administrator
- MySQL Query Browser - now replaced with Workbench
- MySQL Workbench
- /archive: older stuff that probably is no longer applicable
Links
Reference
- official site
- Wikipedia
- HashMySQL wiki: official wiki of the unofficial-but-sanctioned #mysql IRC channel on freenode
How To
- repair munged tables
- data recovery
- Chapter 7. Backup and Recovery
- How to recover MySQL data from Innodb? - if you have a copy of /var/www/lib/mysql but MySQL can't see the data
- The important thing to remember is that not all of the data is in the *.fr? files.