MySQL WorkBench; Pulling data from Multiple tables; Read Only?

LT Mote

Enthusiast
Joined
Jul 21, 2006
Messages
124
I am trying to pull data from multiple MYSQL tables using MySQL WorkBench v6.3.6.

I can get the data to pull and associate correctly with the other table; however I can't seem to EDIT the data... It's like it's in Read Only mode.

If I change my select statement to only pull from one table; I can edit it no problem... But pulling from 2; no luck... Thoughts?

Code:
SELECT
    main_roster.id,
    main_roster.member as 'R-Member',
    main_roster.status as 'R-Status',
    main_roster.appid as 'R-AppID',
    main_applications.id as 'A-ID',
    main_applications.member as 'A-Member',
    main_applications.status as 'A-Status'
    FROM main_roster, main_applications
    where (main_applications.member = main_roster.member)
    and main_roster.status ='Active';

ai.gyazo.com_bd9dc2182fea137628b76f635e6915c4.png
 

Veryard

Neophyte
Joined
Aug 5, 2013
Messages
1
If the table does not have a primary key or unique non-nullable defined, MySQL Workbench won't be able to edit the data.

You can also try loading the schema after table names for example:
Code:
SELECT
    main_roster.id,
    main_roster.member as 'R-Member',
    main_roster.status as 'R-Status',
    main_roster.appid as 'R-AppID',
    main_applications.id as 'A-ID',
    main_applications.member as 'A-Member',
    main_applications.status as 'A-Status'
    FROM SCHEMA.main_roster, SCHEMA.main_applications
    where (main_applications.member = main_roster.member)
    and main_roster.status ='Active';
 
Top