Databases
StackOverflow2013
Usersdbo
USKarolos
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USKarolos
    primarykey
    data
    text
    plurals
    1. POWhat's the cheapest way to know if a path refers to a folder or a file in c++?
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CO@user1114409: Glad that it worked! I would advise to take a look at designing database schemes (e.g. http://www.databaseanswers.org/tutorial4_db_schema/index.htm) because this is a key part of using databases. For instance, the high amount of duplication between the two tables is suspicious: you have id and rid; what's the difference?
      singulars
      1. PO
      1. USKarolos
    2. COThis helps a bit but I'm not sure what you expect ? which of 299, 355 or 466 do you want to put in the three fields of ratemaster (replacing the 0s)? If your purpose is to update each row separately and have 299, 355 and 466 for each of the records of ratemaster, then I'm afraid the DB doesn't have enough information to do that, unless you do something like Sascha suggested, but you would have to execute this three times, to select each time the row from ratemaster with Rate=0 (the other would have been updated by the previous updates).
      singulars
      1. PO
      1. USKarolos
    3. CO@user1114409: Maybe it's simple to you but I don't seem to understand what it is you want after your explanations. You say "I need 3 values of Rates table(Rate) to be copied into Ratemaster field Rate where all 3 records are duplicates except for 1 field Rate column in it"; could you update your post with a few dummy rows as an example ? How do you expect that three _duplicate records_ from ratemaster be filled with three _different_ (?) rates from table rates ? How is the DB supposed to know which of the 3 values from table rates corresponds to those form ratemaster? Sorry I can't figure this
      singulars
      1. PO
      1. USKarolos
 

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