This is the revision history for lolmysql in <matrix.org:#rAnyijhRxzFRfdjSHl:matrix.org>

factoid_idsubjectcopulapredicateauthornamespace
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>
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>