----- Mail original ----- De: "bernard schoenacker" <bernard.schoenac...@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