Databases
StackOverflow2013
Usersdbo
USKDawg
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USKDawg
    primarykey
    data
    text
    plurals
    1. POHow to Tell The Difference Between An Associative and a Regular array
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. POPHP Mysql CodeIgniter Converting characters to symbols in very bizarre circumstances
      singulars
      1. PTQuestion
    1. PODynamically generating iframes causing previously generated iframes to refresh unwontedly - when using innerHTML
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. POwordpress plugin add_filter(login_redirect does not work
      singulars
      1. PTQuestion
    1. VO
      singulars
      1. POcode igniter php null values get submitted to mysql DB as zeros (0)
      1. USKDawg
      1. VTFavorite
    2. VO
      singulars
      1. POJQUERY caching if Back-button after posting to form - JQUERY fadeIn still visable
      1. USKDawg
      1. VTBountyStart
    3. VO
      singulars
      1. POPHP Mysql CodeIgniter Converting characters to symbols in very bizarre circumstances
      1. USKDawg
      1. VTBountyStart
    1. COI agree Leigh - it seemed like it was a good idea to store comma separated values that can be brought into JavaScript as strings or arrays, and used as temporary memory for the javascript to populate HTML drop lists etc. That is why I did it to begin with. For that purpose, it has worked very well, but now that I want to compare and discriminate with those values, I'm left importing the table to PHP to sort. Which brings me to my next question: Is it OK, or common procedure to loop through thousands of records with PHP? Is that too much a burden on the system? Will that slow it down too much?
      singulars
      1. POMySQL query how to get list of all distinct values from columns that contain multiple string values?
      1. USKDawg
    2. COThanks Jim - That link links to another and another question - yet it does look like it eventually gets down to some solution. yet it is looking to me like the answer to this question is "NO" so far. Maybe better just to get a hard answer to this question here, instead of linking people off to other questions and links. - So far I'm seeing that "NO" MySQL can not do this alone. And you are either left looping thorough the table results with PHP OR Having the MySQL creating new tables that then can be sorted.
      singulars
      1. POMySQL query how to get list of all distinct values from columns that contain multiple string values?
      1. USKDawg
    3. COI see Daryl - is that practical for thousands of records? Is it something that is typically done with thousands of records?
      singulars
      1. POMySQL query how to get list of all distinct values from columns that contain multiple string values?
      1. USKDawg
 

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