Jan Hidders wrote:
SELECT COUNT(*) FROM linked;
and
SELECT COUNT(*) FROM linkes GROUP BY linked_from, linked_to ;
mysql> SELECT COUNT(*) FROM linked;
+----------+
| COUNT(*) |
+----------+
| 15380 |
+----------+
1 row in set (0.00 sec)
mysql> SELECT COUNT(*) FROM linked GROUP BY linked_from, linked_to ;
ERROR 1169: Can't write, because of unique constraint, to table
'#sql1112_aaaca_1'
(I assumed you meaned 'linked' instead of 'linkes', which doesn't work
either.