Databases
StackOverflow2013
Postsdbo
POCreate a graph using mysql
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreate a graph using mysql
    primarykey
    data
    text
    <p>So , there is this interesting problem in front of me ,i have two tables one with information of user with host profiles on web and other stores profiles mentioned in the website , eg : on www.abc.com i have mentioned www.xyz.com so abc.com will be part of :</p> <pre><code>source table +----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | website | varchar(255) | YES | | NULL | | | user_id | varchar(25) | YES | MUL | NULL | | | web_name | varchar(255) | YES | | NULL | | +----------+--------------+------+-----+---------+----------------+ </code></pre> <p>mention table will have entries (like xyz.com mentioned above) </p> <pre><code>+----------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | web_link | varchar(255) | YES | | NULL | | | user_id | varchar(25) | YES | MUL | NULL | | | web_name | varchar(255) | YES | | NULL | | +----------+--------------+------+-----+---------+----------------+ </code></pre> <p>user_id is foreign key to these tables , <strong>now i want to generate a node based graph such that i select source.web_name and mention.webname and assign them ids such that they all be unique , eg: 0-> 1 because there can be chances of 1->0</strong> </p> <p>I want to know what can be the best possible way to achieve this, should i change the schema to get it done or using python selects this can be done. I am not able to figure out giving unique ids to both source.web_name and mention.webname when they reside in different table . </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USHarshit
    1. USHarshit
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCreate a graph using mysql
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POCreate a graph using mysql
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POCreate a graph using mysql
      1. USHarshit
      1. VTFavorite
    1. COJust to follow up even if I manage to make a dictionary like {website:weblibk} for all the mentions how can i assign them unique integer ids in either side of : in dictionary
      singulars
      1. POCreate a graph using mysql
      1. USHarshit
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload