Lire une table mysql directement dans le shel

#!/bin/sh 
#pas besoin de bash pour ça. 
user=toi 
pass=tonpasse 
hote=tonhote 
db=tabase 
nom_table=tatable 
mysql -H "$hote" -D "$db" -u "$user" -p "$pass" -e "SELECT * FROM $nom_table ORDER BY 'id' ASC LIMIT 0 , 1"

require ('login.php');
$link = mysql_connect("$hote", "$login", "$pass") or die("Erreur de connexion...") ; // Connexion à MySQL
$req = mysql_select_db($bdd, $link) or die("Erreur de connexion...") ; //Sélection de la base de donnée

/* ------------------ CONNEXION TABLE ------------------ */
$nom_table = ("modules_x10");
 
/* -------- REQUETE LECTURE DES NOM DE GROUPE DANS LE TABLEAU-------- */
$requete_0 = mysql_query("SELECT * FROM '$nom_table' ORDER BY 'id' ASC LIMIT 0 , 1"); // Requête SQL

#!/bin/bash

root@debian:/home/serveur# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
root@debian:/home/serveur#

serveur@debian:~$ sh mysql2.sh 
mysql  Ver 14.14 Distrib 5.1.61, for debian-linux-gnu (arm) using readline 6.1 
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. 

Oracle is a registered trademark of Oracle Corporation and/or its 
affiliates. Other names may be trademarks of their respective 
owners. 

Usage: mysql [OPTIONS] [database] 
  -?, --help          Display this help and exit. 
  -I, --help          Synonym for -? 
  --auto-rehash       Enable automatic rehashing. One doesn't need to use 
                      'rehash' to get table and field completion, but startup 
                      and reconnecting may take a longer time. Disable with 
                      --disable-auto-rehash. 
  -A, --no-auto-rehash  
                      No automatic rehashing. One has to use 'rehash' to get 
                      table and field completion. This gives a quicker start of 
                      mysql and disables rehashing on reconnect. 
  -B, --batch         Don't use history file. Disable interactive behavior. 
                      (Enables --silent.) 
  --character-sets-dir=name  
                      Directory for character set files. 
  --column-type-info  Display column type information. 
  -c, --comments      Preserve comments. Send comments to the server. The 
                      default is --skip-comments (discard comments), enable 
                      with --comments. 
  -C, --compress      Use compression in server/client protocol. 
  -#, --debug[=#]     This is a non-debug version. Catch this and exit. 
  --debug-check       Check memory and open file usage at exit. 
  -T, --debug-info    Print some debug info at exit. 
  -D, --database=name Database to use. 
  --default-character-set=name  
                      Set the default character set. 
  --delimiter=name    Delimiter to be used. 
  -e, --execute=name  Execute command and quit. (Disables --force and history 
                      file.) 
  -E, --vertical      Print the output of a query (rows) vertically. 
  -f, --force         Continue even if we get an SQL error. 
  -G, --named-commands  
                      Enable named commands. Named commands mean this program's 
                      internal commands; see mysql> help . When enabled, the 
                      named commands can be used from any line of the query, 
                      otherwise only from the first line, before an enter. 
                      Disable with --disable-named-commands. This option is 
                      disabled by default. 
  -g, --no-named-commands  
                      Named commands are disabled. Use \* form only, or use 
                      named commands only in the beginning of a line ending 
                      with a semicolon (;). Since version 10.9, the client now 
                      starts with this option ENABLED by default. Disable with 
                      '-G'. Long format commands still work from the first 
                      line. WARNING: option deprecated; use 
                      --disable-named-commands instead. 
  -i, --ignore-spaces Ignore space after function names. 
  --local-infile      Enable/disable LOAD DATA LOCAL INFILE. 
  -b, --no-beep       Turn off beep on error. 
  -h, --host=name     Connect to host. 
  -H, --html          Produce HTML output. 
  -X, --xml           Produce XML output. 
  --line-numbers      Write line numbers for errors. 
  -L, --skip-line-numbers  
                      Don't write line number for errors. 
  -n, --unbuffered    Flush buffer after each query. 
  --column-names      Write column names in results. 
  -N, --skip-column-names  
                      Don't write column names in results. 
  -O, --set-variable=name  
                      Change the value of a variable. Please note that this 
                      option is deprecated; you can set variables directly with 
                      --variable-name=value. 
  --sigint-ignore     Ignore SIGINT (CTRL-C). 
  -o, --one-database  Ignore statements except those that occur while the 
                      default database is the one named at the command line. 
  --pager[=name]      Pager to use to display results. If you don't supply an 
                      option, the default pager is taken from your ENV variable 
                      PAGER. Valid pagers are less, more, cat [> filename], 
                      etc. See interactive help (\h) also. This option does not 
                      work in batch mode. Disable with --disable-pager. This 
                      option is disabled by default. 
  --no-pager          Disable pager and print to stdout. See interactive help 
                      (\h) also. WARNING: option deprecated; use 
                      --disable-pager instead. 
  -p, --password[=name]  
                      Password to use when connecting to server. If password is 
                      not given it's asked from the tty. 
  -P, --port=#        Port number to use for connection or 0 for default to, in 
                      order of preference, my.cnf, $MYSQL_TCP_PORT, 
                      /etc/services, built-in default (3306). 
  --prompt=name       Set the mysql prompt to this value. 
  --protocol=name     The protocol to use for connection (tcp, socket, pipe, 
                      memory). 
  -q, --quick         Don't cache result, print it row by row. This may slow 
                      down the server if the output is suspended. Doesn't use 
                      history file. 
  -r, --raw           Write fields without conversion. Used with --batch. 
  --reconnect         Reconnect if the connection is lost. Disable with 
                      --disable-reconnect. This option is enabled by default. 
  -s, --silent        Be more silent. Print results with a tab as separator, 
                      each row on new line. 
  -S, --socket=name   The socket file to use for connection. 
  --ssl               Enable SSL for connection (automatically enabled with 
                      other flags).Disable with --skip-ssl. 
  --ssl-ca=name       CA file in PEM format (check OpenSSL docs, implies 
                      --ssl). 
  --ssl-capath=name   CA directory (check OpenSSL docs, implies --ssl). 
  --ssl-cert=name     X509 cert in PEM format (implies --ssl). 
  --ssl-cipher=name   SSL cipher to use (implies --ssl). 
  --ssl-key=name      X509 key in PEM format (implies --ssl). 
  --ssl-verify-server-cert  
                      Verify server's "Common Name" in its cert against 
                      hostname used when connecting. This option is disabled by 
                      default. 
  -t, --table         Output in table format. 
  --tee=name          Append everything into outfile. See interactive help (\h) 
                      also. Does not work in batch mode. Disable with 
                      --disable-tee. This option is disabled by default. 
  --no-tee            Disable outfile. See interactive help (\h) also. WARNING: 
                      Option deprecated; use --disable-tee instead. 
  -u, --user=name     User for login if not current user. 
  -U, --safe-updates  Only allow UPDATE and DELETE that uses keys. 
  -U, --i-am-a-dummy  Synonym for option --safe-updates, -U. 
  -v, --verbose       Write more. (-v -v -v gives the table output format). 
  -V, --version       Output version information and exit. 
  -w, --wait          Wait and retry if connection is down. 
  --connect_timeout=# Number of seconds before connection timeout. 
  --max_allowed_packet=#  
                      The maximum packet length to send to or receive from 
                      server. 
  --net_buffer_length=#  
                      The buffer size for TCP/IP and socket communication. 
  --select_limit=#    Automatic limit for SELECT when using --safe-updates. 
  --max_join_size=#   Automatic limit for rows in a join when using 
                      --safe-updates. 
  --secure-auth       Refuse client connecting to server if it uses old 
                      (pre-4.1.1) protocol. 
  --server-arg=name   Send embedded server this as a parameter. 
  --show-warnings     Show warnings after every statement. 

Default options are read from the following files in the given order: 
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf  
The following groups are read: mysql client 
The following options may be given as the first argument: 
--print-defaults        Print the program argument list and exit. 
--no-defaults           Don't read default options from any option file. 
--defaults-file=#       Only read default options from the given file #. 
--defaults-extra-file=# Read this file after the global files are read. 

Variables (--variable-name=value) 
and boolean options {FALSE|TRUE}  Value (after reading options) 
--------------------------------- ----------------------------- 
auto-rehash                       TRUE 
character-sets-dir                (No default value) 
column-type-info                  FALSE 
comments                          FALSE 
compress                          FALSE 
debug-check                       FALSE 
debug-info                        FALSE 
database                          domotique 
default-character-set             latin1 
delimiter                         ; 
vertical                          FALSE 
force                             FALSE 
named-commands                    FALSE 
ignore-spaces                     FALSE 
local-infile                      FALSE 
no-beep                           FALSE 
host                              (No default value) 
html                              TRUE 
xml                               FALSE 
line-numbers                      TRUE 
unbuffered                        FALSE 
column-names                      TRUE 
sigint-ignore                     FALSE 
port                              3306 
prompt                            mysql> 
quick                             FALSE 
raw                               FALSE 
reconnect                         FALSE 
socket                            /var/run/mysqld/mysqld.sock 
ssl                               FALSE 
ssl-ca                            (No default value) 
ssl-capath                        (No default value) 
ssl-cert                          (No default value) 
ssl-cipher                        (No default value) 
ssl-key                           (No default value) 
ssl-verify-server-cert            FALSE 
table                             FALSE 
user                              root 
safe-updates                      FALSE 
i-am-a-dummy                      FALSE 
connect_timeout                   0 
max_allowed_packet                16777216 
net_buffer_length                 16384 
select_limit                      1000 
max_join_size                     1000000 
secure-auth                       FALSE 
show-warnings                     FALSE 
serveur@debian:~$

root@debian:/home/serveur# /etc/init.d/mysql restart 
Stopping MySQL database server: mysqld. 
Starting MySQL database server: mysqld. 
Checking for corrupt, not cleanly closed and upgrade needing tables.. 
root@debian:/home/serveur#

root@debian:~# mysql -h "localhost" -D "domotique" -u "root" -p "xxxxxx" -e "SELECT * FROM modules_x10 ORDER BY '1' ASC LIMIT 0 , 1" 
Enter password: 
ERROR 1049 (42000): Unknown database 'xxxxxx' 
root@debian:~#

ERROR 1049 (42000): Unknown database 'xxxxxx'

id 
nom_module 
code_maison_unité 
code_maison 
code_unité

root@debian:~# mysql -h "localhost" -D "domotique" -u "root" -p"xxxxxx" -e "SELECT * FROM modules_x10 ORDER BY '1' ASC LIMIT 0 , 1" 
+----+------------+-------------------+-------------+------------+-----------------+------------------+----------------+-----------------+-----------------------+------+-------+-------------+----------+-----------+---------+---------------+----------+----------------+----------------+ 
| id | nom_module | code_maison_unit? | code_maison | code_unit? | nom_commande_On | nom_commande_Off | variateur_plus | variateur_moins | variateur_automatique | type | macro | emplacement | concerne | puissance | name_on | input_name_on | name_off | input_name_off | nom_groupe     | 
+----+------------+-------------------+-------------+------------+-----------------+------------------+----------------+-----------------+-----------------------+------+-------+-------------+----------+-----------+---------+---------------+----------+----------------+----------------+ 
|  1 | Panique    | 000               | 0           | 00         | Marche          | Arr?t            | Plus           | Moins           | 50%                   |      |       |             |          |           |         |               |          |                | Touche panique | 
+----+------------+-------------------+-------------+------------+-----------------+------------------+----------------+-----------------+-----------------------+------+-------+-------------+----------+-----------+---------+---------------+----------+----------------+----------------+ 
root@debian:~# 

SELECT id,nom_module,code_maison_unité,code_maison,code_unité FROM modules_x10 ORDER BY '1' ASC LIMIT 0 , 1"

root@debian:/home/serveur# mysql -h "localhost" -D "domotique" -u "root" -p"azerty" -e SELECT id,nom_module,code_maison_unite,code_maison,code_unite FROM modules_x10"  
> ^C  
root@debian:/home/serveur#

mysql -h "localhost" -D "domotique" -u "root" -p"xxxxxx" -e "SELECT id,nom_module,code_maison_unite,code_maison,code_unite FROM modules_x10 ORDER BY '1' ASC LIMIT 0 , 17"

root@debian:/home/serveur# mysql -h "localhost" -D "domotique" -u "root" -p"xxxxxx" -e "SELECT id,nom_module,code_maison_unite,code_maison,code_unite FROM modules_x10" 
+----+-----------------------------+-------------------+-------------+------------+ 
| id | nom_module                  | code_maison_unite | code_maison | code_unite | 
+----+-----------------------------+-------------------+-------------+------------+ 
|  0 | Panique                     | 000               | 0           | 00         | 
|  1 | D?tecteur boite au lettre   | A1                | A           | 1          | 
|  2 |                             | A2                | A           | 2          | 
|  3 |                             | A3                | A           | 3          | 
|  4 |                             | A4                | A           | 4          | 
|  5 |                             | A5                | A           | 5          | 
|  6 |                             | A6                | A           | 6          | 
|  7 |                             | A7                | A           | 7          | 
|  8 |                             | A8                | A           | 8          | 
|  9 |                             | A9                | A           | 9          | 
| 10 |                             | A10               | A           | 10         | 
| 11 |                             | A11               | A           | 11         | 
| 12 |                             | A12               | A           | 12         | 
| 13 |                             | A13               | A           | 13         | 
| 14 | Macro lave linge 2 vers D13 | A14               | A           | 14         | 
| 15 | Macro s?che linge vers D15  | A15               | A           | 15         | 
| 16 | Macro lave linge 1 Vers D16 | A16               | A           | 16         | 
| 17 | Lumi?re du salon            | B1                | B           | 1          | 
| 18 | Lumi?re chemin?             | B2                | B           | 2          | 
| 19 | Lumi?re meuble TV           | B3                | B           | 3          | 
| 20 | Horloge Bleu du salon       | B4                | B           | 4          | 
| 21 | Ordinateur du salon         | B5                | B           | 5          | 
+----+-----------------------------+-------------------+-------------+------------+ 
root@debian:/home/serveur#

root@debian:/home/serveur# mysql -h "localhost" -D "domotique" -u "root" -p"xxxxxx" -e "SELECT id,nom_module,code_maison_unite,code_maison,code_unite FROM modules_x10 ORDER BY '1' ASC LIMIT 0 , 1" 
+----+------------+-------------------+-------------+------------+ 
| id | nom_module | code_maison_unite | code_maison | code_unite | 
+----+------------+-------------------+-------------+------------+ 
|  0 | Panique    | 000               | 0           | 00         | 
+----+------------+-------------------+-------------+------------+ 
root@debian:/home/serveur#

mysql -h "localhost" -D "domotique" -u "root" -p"xxxxxx" -e "UPDATE modules_x10 SET code_maison_unite='B12' WHERE nom module='test-modification-nom-module' '");