Re: créer les entrée de tables pour MySQL

[bernard.schoenacker@free.fr]

----- Mail original -----
De: "bernard schoenacker" <bernard.schoenacker@free.fr>
À: "Debian User French" <debian-user-french@lists.debian.org>
Envoyé: Jeudi 6 Avril 2017 16:09:10
Objet: créer les entrée de tables pour MySQL

bonjour,

j'ai repris un exemple et je souhaiterai l'adapter à la situation :

+----+-------------------------+
| id | name                    |
+----+-------------------------+
|  1 | happy-tux.org           |
|  2 | brotsch.happy-tux.org   |
|  3 | brotsch                 |
|  4 | localhost.happy-tux.org |
+----+-------------------------+

et voici la syntaxe à vérifier :

INSERT INTO `mailserver`.`virtual_domains`
  (`name`)
VALUES
  ('happy-tux.org'),('brotsch.happy-tux.org'),('brotsch'),('localhost.happy-tux.org'); 


merci de votre aimable attention

slt
bernard

bonjour,


j'ai un code erreur : 

mysql -u root -p mailserver
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 168
Server version: 5.5.54-0+deb8u1 (Debian)

Copyright (c) 2000, 2016, 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.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> INSERT INTO `mailserver`.`virtual_domains`
    -> (`name`)
    -> VALUES
    -> (`happy-tux.org`)
    -> (`brotsch.happy-tux.org`)
    -> (`brotsch`)
    -> (`localhost.happy-tux.org`);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(`brotsch.happy-tux.org`)
(`brotsch`)
(`localhost.happy-tux.org`)' at line 5
mysql> 
mysql> SELECT * FROM mailserver.virtual_domains;
ERROR 1146 (42S02): Table 'mailserver.virtual_domains' doesn't exist
mysql> 

comment faire ?

slt
bernard