View Single Post
  #11  
Old 02-20-2016, 07:50 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

What do these queries return:
Code:
SELECT `id`, `enabled` FROM `spawn2` WHERE `id` IN (59297,59298);
SHOW KEYS FROM `guild_members` WHERE `Key_name` LIKE 'PRIMARY';
SHOW KEYS FROM `group_id` WHERE `Key_name` LIKE 'PRIMARY';

Quote:
Originally Posted by `spawn2`
id,enabled
59297,1
59298,1
Quote:
Originally Posted by `guild_members` - should be no results
Quote:
Originally Posted by `group_id`
Table,Non_unique,Key_name,Seq_in_index,Column_name ,Collation,Cardinality,Sub_part,Packed,Null,Index_ type,Comment,Index_comment
group_id,0,PRIMARY,1,groupid,A,1,\N,\N,,BTREE,,
group_id,0,PRIMARY,2,charid,A,1,\N,\N,,BTREE,,
group_id,0,PRIMARY,3,name,A,1,\N,\N,,BTREE,,
group_id,0,PRIMARY,4,ismerc,A,1,\N,\N,,BTREE,,
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote