Re: créer les entrée de tables pour MySQL
----- 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
Reply to: