Mysql
De Linuxmemo.
(Différences entre les versions)
(→Les commandes) |
|||
| Ligne 6 : | Ligne 6 : | ||
mysql -uuser -p | mysql -uuser -p | ||
| - | + | * Utile dans le shell: | |
| - | + | ||
| - | clear (\c) Clear the current input statement. | + | ego (\G) Send command to mysql server, display result vertically. |
| - | + | clear (\c) Clear the current input statement. | |
| - | help commande_sql | + | '''help contents''' |
| + | '''help commande_sql''' | ||
* Verification des droits: | * Verification des droits: | ||
mysqlacces user base -U root -P | mysqlacces user base -U root -P | ||
| - | |||
* Dump des bases et/ou tables: | * Dump des bases et/ou tables: | ||
Version du 26 mars 2012 à 11:59
Les commandes
- Connexion au shell
mysql -uuser -p
- Utile dans le shell:
ego (\G) Send command to mysql server, display result vertically. clear (\c) Clear the current input statement. help contents help commande_sql
- Verification des droits:
mysqlacces user base -U root -P
- Dump des bases et/ou tables:
mysqldump [options] db_name [tables]
- display database, table, and column information
mysqlshow
