Mysql

De Linuxmemo.

Les commandes

• Connexion au shell

mysql -uuser -p

Util dans le shell: ego (\G) Send command to mysql server, display result vertically.

clear (\c) Clear the current input statement.

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