Pivot tables can be confusing and a little hard to wrap your head around at first. In this quick article we are going to dive into what a pivot table is, how to create one and finally how to use the pivot table. Let's dive in!
A pivot table is used to connect relationships between two tables. Laravel provides a Many To Many relationship where you can use a pivot table.
| SELECT | |
| tmp.ipAddress, | |
| -- Calculate how many connections are being held by this IP address. | |
| COUNT( * ) AS numConnections, | |
| -- For each connection, the TIME column represent how many SECONDS it has been in | |
| -- its current state. Running some aggregates will give us a fuzzy picture of what | |
| -- the connections from this IP address is doing. | |
| FLOOR( AVG( tmp.time ) ) AS timeAVG, |
| """""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""" | |
| " Font | |
| :set guifont=Source\ Code\ Pro:h14 | |
| """""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""" | |
| " Hide pointless junk at the bottom, doesn't work in .vimrc for some reason? | |
| :set laststatus=0 | |
| :set noshowmode "don't show --INSERT-- | |
| :set noruler "don't show line numbers/column/% junk |
