Re: Dba.createCluster: ERROR: 1 table(s) do not have a Primary Key

[Sivan Koren]

Sure. Thanks for your help. Output pasted below:


mysql> SELECT tables.table_schema , tables.table_name , tables.engine
-> FROM information_schema.tables
-> LEFT JOIN (
-> SELECT table_schema , table_name
-> FROM information_schema.statistics
-> GROUP BY table_schema, table_name, index_name HAVING
-> SUM( case when non_unique = 0 and nullable != 'YES' then 1 else 0 end ) = count(*) ) puks
-> ON tables.table_schema = puks.table_schema and tables.table_name = puks.table_name
-> WHERE puks.table_name is null
-> AND tables.table_type = 'BASE TABLE' AND Engine="InnoDB";
Empty set (0.05 sec)

mysql>