The one place for your designs
To enable design management, you'll need to meet the requirements. If you need help, reach out to our support team for assistance.
Errors during initial creation of MySQL database cluster (1.6.0)
NOTE: I DO NOT KNOW IF THIS IS RELATED TO CHANGING THE MySQL "ENGINE" from INNODB to NDBCLUSTER, but anyone's knowledge of MySQL is going to be better than mine.
When running a slightly modified dhcpdb_create.mysql, there are some errors:
ERROR 1215 (HY000) at line 1034 in file: 'dhcpdb_create.mysql': Cannot add foreign key constraint
ERROR 1215 (HY000) at line 1305 in file: 'dhcpdb_create.mysql': Cannot add foreign key constraint
ERROR 1146 (42S02) at line 1440 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp4_options_server' doesn't exist
ERROR 1146 (42S02) at line 1443 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp4_options_server' doesn't exist
ERROR 1146 (42S02) at line 1485 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp6_options_server' doesn't exist
ERROR 1146 (42S02) at line 1488 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp6_options_server' doesn't existThe modification made is as follows:
sed s:INNODB:NDBCLUSTER: < /usr/share/kea/scripts/mysql/dhcpdb_create.mysql > ~/dhcpdb_create.mysqlSoftware Versions:
Kea 1.6, Docker 19.03.1 and mysql-5.7.27/ndb-7.6.11OS:
Linux debian-10 4.19.0-5-amd64 #1 SMP Debian 4.19.37-5+deb10u1 (2019-07-19) x86_64 GNU/LinuxSee currently un-published KB article "Testing Kea and MySQL Clustering using Docker"
Full output follows:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 45
Server version: 5.7.27-ndb-7.6.11-cluster-gpl MySQL Cluster Community Server (GPL)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]> connect kea;
Connection id: 46
Current database: kea
MySQL [kea]> source dhcpdb_create.mysql;
Query OK, 0 rows affected (0.155 sec)
Query OK, 0 rows affected (0.147 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.187 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.148 sec)
Query OK, 0 rows affected (0.176 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.151 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 1 row affected (0.003 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.145 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected, 3 warnings (0.201 sec)
Records: 0 Duplicates: 0 Warnings: 3
Query OK, 0 rows affected (0.153 sec)
Query OK, 1 row affected (0.003 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.004 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.189 sec)
Query OK, 0 rows affected (0.156 sec)
Query OK, 0 rows affected (0.206 sec)
Query OK, 0 rows affected (0.216 sec)
Query OK, 0 rows affected (0.009 sec)
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.383 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.376 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.213 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.183 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.170 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 1 row affected (0.003 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 0 rows affected (0.170 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.176 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.191 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.006 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.003 sec)
Query OK, 8 rows affected (0.463 sec)
Records: 8 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.218 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected, 1 warning (0.005 sec)
Query OK, 0 rows affected (0.004 sec)
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.003 sec)
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected, 1 warning (0.007 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 1 row affected (0.003 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.004 sec)
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.177 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.235 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.189 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.252 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.412 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.272 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.264 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 1 row affected (0.003 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.270 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (1.127 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (1.147 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (1.126 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.128 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.884 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.198 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.589 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.182 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.583 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected, 1 warning (0.146 sec)
Records: 0 Duplicates: 0 Warnings: 1
Query OK, 0 rows affected, 1 warning (0.135 sec)
Records: 0 Duplicates: 0 Warnings: 1
Query OK, 0 rows affected, 1 warning (0.139 sec)
Records: 0 Duplicates: 0 Warnings: 1
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 1 row affected (0.002 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.622 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.619 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.733 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.639 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.668 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.180 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.181 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.202 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.154 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.117 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.140 sec)
Query OK, 0 rows affected (0.013 sec)
Query OK, 0 rows affected (0.013 sec)
Query OK, 0 rows affected (0.012 sec)
Query OK, 1 row affected (0.006 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.664 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.613 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.003 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected (0.003 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected, 1 warning (0.144 sec)
Query OK, 0 rows affected (0.152 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected, 1 warning (0.136 sec)
Records: 0 Duplicates: 0 Warnings: 1
Query OK, 1 row affected (0.002 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 0 rows affected (0.017 sec)
Query OK, 1 row affected (0.003 sec)
Query OK, 1 row affected (0.004 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 0 rows affected (0.022 sec)
Query OK, 1 row affected (0.002 sec)
Query OK, 0 rows affected (0.032 sec)
Query OK, 0 rows affected (0.032 sec)
Query OK, 0 rows affected (0.035 sec)
Query OK, 0 rows affected (0.031 sec)
Query OK, 0 rows affected (0.034 sec)
Query OK, 0 rows affected (0.048 sec)
Query OK, 0 rows affected (0.023 sec)
Query OK, 0 rows affected (0.044 sec)
Query OK, 0 rows affected (0.029 sec)
Query OK, 0 rows affected (0.032 sec)
Query OK, 0 rows affected (0.661 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.604 sec)
Records: 0 Duplicates: 0 Warnings: 0
ERROR 1215 (HY000) at line 1034 in file: 'dhcpdb_create.mysql': Cannot add foreign key constraint
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.026 sec)
Query OK, 1 row affected (0.003 sec)
Query OK, 0 rows affected (0.035 sec)
Query OK, 0 rows affected (0.029 sec)
Query OK, 0 rows affected (0.030 sec)
Query OK, 0 rows affected (0.018 sec)
Query OK, 0 rows affected (0.031 sec)
Query OK, 0 rows affected (0.032 sec)
Query OK, 0 rows affected (0.037 sec)
Query OK, 0 rows affected (0.035 sec)
Query OK, 0 rows affected (0.028 sec)
Query OK, 0 rows affected (0.030 sec)
Query OK, 0 rows affected (0.027 sec)
Query OK, 0 rows affected (0.650 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.657 sec)
Records: 0 Duplicates: 0 Warnings: 0
ERROR 1215 (HY000) at line 1305 in file: 'dhcpdb_create.mysql': Cannot add foreign key constraint
Query OK, 0 rows affected (0.007 sec)
Query OK, 1 row affected (0.004 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.623 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.607 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.045 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.031 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.044 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.032 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.039 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.035 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.035 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.047 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.031 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.038 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.035 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.036 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.044 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.047 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.055 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.036 sec)
Records: 0 Duplicates: 0 Warnings: 0
ERROR 1146 (42S02) at line 1440 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp4_options_server' doesn't exist
ERROR 1146 (42S02) at line 1443 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp4_options_server' doesn't exist
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.047 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.042 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.008 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.051 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.052 sec)
Records: 0 Duplicates: 0 Warnings: 0
ERROR 1146 (42S02) at line 1485 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp6_options_server' doesn't exist
ERROR 1146 (42S02) at line 1488 in file: 'dhcpdb_create.mysql': Table 'kea.dhcp6_options_server' doesn't exist
Query OK, 0 rows affected (0.024 sec)
Query OK, 0 rows affected (0.034 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.033 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.048 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.009 sec)
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.010 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.015 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.004 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 1 row affected (0.001 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected (0.054 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.052 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.033 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.054 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.009 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.012 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.015 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.040 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.049 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.046 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.010 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.048 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.050 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.040 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.025 sec)
Query OK, 0 rows affected (0.037 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.028 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.044 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.010 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.008 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected, 1 warning (0.001 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected (0.009 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.008 sec)
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.034 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.036 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.034 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.053 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.742 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.004 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.007 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.037 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.004 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.003 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.008 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.010 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.044 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.039 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.043 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.027 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.032 sec)
Records: 0 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected (0.002 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.008 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.008 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.001 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 0 rows affected (0.005 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.006 sec)
Query OK, 0 rows affected (0.007 sec)
Query OK, 1 row affected (0.002 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MySQL [kea]> quit
Bye