comandi in breve command line tool 7 MySQL language reference in locale in linea tutti i programmi

mysqlshow [database [tabella]]
mysqlimport --local database filename

mysql -e 'SQLstatement' database
mysql database < SQLscript

mysql [-u username -p password]
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1523 to server version: 3.22.25

Type 'help' for help.

mysql> use database [-A];
mysql> show databases|tables|columns from tabella|index from tabella;
mysql> show status|variables;
mysql> describe tabella;

mysql> select ...;

mysql> create table tabella (id INT, field1 VARCHAR(30));

mysql> create index indice ON tabella (field(dimensione));

mysql> insert INTO tabella VALUES (...);

mysql> update tabella SET field1=... WHERE ...;

mysql> delete FROM tabella WHERE ...;

mysql> create database database
 
mysql> status
mysql> quit

mysql -V
mysql  Ver 9.33 Distrib 3.22.25, for pc-linux-gnu (i686)
uname -a
Linux xxx.com 2.2.5-15 #1 Mon Apr 19 22:21:09 EDT 1999 i586 unknown

mysql -H (HTML output)
mysql -B (tab e silenzioso)