This is the revision history for lolmysql in <matrix.org:#DYJOMClZbVOMHnzPQt:matrix.org>
factoid_id | subject | copula | predicate | author | namespace |
---|---|---|---|---|---|
15681 | lolmysql | is | `eval my $q = `quote d `get https://grinnz.com/stuff/lolmysql.txt .*!!; @ls=split /\r?\n/, $q; my $i = `call lenor [`arg!] [rand(@ls)+1]!; $ls[$i-1]! - The TIMESTAMP data type is internally stored as a UTC epoch timestamp, so will continue to refer to the same moment in time regardless of the time_zone setting when retrieving it. The DATETIME data type on the other hand is a calendar date and time stored with no time zone information, so is not particularly useful for storage unless you know what time zone was used to create each value. |
grinnz | <*:##NULL> |
15680 | lolmysql | is | `eval my $q = `quote d `get https://grinnz.com/stuff/lolmysql.txt .*!!; @ls=split /\r?\n/, $q; my $i = `call lenor [`arg!] [rand(@ls+1)]!; $ls[$i-1]! - Temporary tables (which are tables designed to be specific to ONE CONNECTION) get replicated to slave databases if you are using statement- or mixed-format replication, wasting everyone's time and CPU. The documented solution is to designate a prefix for your temporary tables and configure the replication to ignore tables with that prefix. |
grinnz | <*:##NULL> |
14292 | lolmysql | is | `eval my $q = `quote d `get http://grinnz.com/stuff/lolmysql.txt .*!!; @ls=split /\r?\n/, $q; my $i = `call lenor [`arg!] [rand(@ls+1)]!; $ls[$i-1]! - To change any part of a column's definition, you have to redefine the column entirely. Changing the column type, whether it's nullable, auto_increment, or default requires specifying all of those things again. |
pink_mist | <*:##NULL> |
14267 | lolmysql | is | `eval my $q = `quote d `get http://grinnz.com/stuff/lolmysql.txt .*!!; @ls=split /\r?\n/, $q; my $i = `quote d `arg!!; $i = rand(@ls+1) if $i eq ""; $ls[$i-1]! Not Available |
pink_mist | <*:##NULL> |
14265 | lolmysql | is | `eval my $q = `quote d `get http://grinnz.com/stuff/lolmysql.txt .*!!; @ls=split /\r?\n/, $q; my $i = `quote d `arg!!; $i //= rand(@ls+1); $ls[$i-1]! Not Available |
simcop2387 | <freenode.net:#perlbot> |
14264 | lolmysql | is | `eval my $q = `quote d `get http://grinnz.com/stuff/lolmysql.txt .*!!; @ls=split /\r?\n/, $q; my $i = `arg! $i //= rand(@ls+1); $ls[$i-1]! Not Available |
pink_mist | <*:##NULL> |
14253 | lolmysql | is | `eval my $q = `quote d `get http://grinnz.com/stuff/lolmysql.txt .*!!; @ls=split /\r?\n/, $q; $ls[`arg!rand(@ls)]! Not Available |
pink_mist | <*:##NULL> |
12718 | lolmysql | is | `eval my $q = `quote d `get http://grinnz.com/stuff/lolmysql.txt .*!!; @ls=split /\r?\n/, $q; $ls[`arg!-1]! Not Available |
simcop2387 | <*:##NULL> |
12717 | lolmysql | is | `eval my $q = `quote d `get http://grinnz.com/stuff/lolmysql.txt .*!!; @ls=split /\r?\n/, $q; $ls[`arg!-1]! Not Available |
simcop2387 | <freenode.net:#perlbot> |
12716 | lolmysql | is | `eval my $q = `quote d `get http://grinnz.com/stuff/lolmysql.txt .*!!; @ls=split /\r?\n/, $q; $ls[`arg!]! Not Available |
simcop2387 | <freenode.net:#perlbot> |