Mysql

De Linuxmemo.

Client du démon "sqld"

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