That is quite different, as I suspected :-)
Referential keys require an index on the target table that begins with the
referenced field, so you'll need to add one on user, as was specified in the
create table you originally posted.
On 28 April 2017 01:21:39 CEST, David Mehler wrote:
>Hello,
>
Dear MySQL Users,
MySQL Connector/J 5.1.42, a maintenance release of the production 5.1
branch has been released. Connector/J is the Type-IV pure-Java JDBC
driver for MySQL.
MySQL Connector Java is available in source and binary form from the
Connector/J download pages at
http://dev.mysql.com/dow
Hello,
Here's the output of the command show create table virtual_users:
create table virtual_users;
+---+--
