API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
458
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 62.25 KB | None | 0 0
raw download clone embed print report
  1. Consider turning off query caching ...
  2.  
  3. SELECT S_NO_CACHE settings.value.....
  4.  
  5. See if it goes away.....
  6.  
  7. [root@ace jams]# mysql mythconverg;
  8. Reading table information for completion of table and column names
  9. You can turn off this feature to get a quicker startup with -A
  10.  
  11. Welcome to the MySQL monitor. Commands end with ; or \g.
  12. Your MySQL connection id is 94
  13. Server version: 5.1.51 Source distribution
  14.  
  15. Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
  16. This software comes with ABSOLUTELY NO WARRANTY. This is free software,
  17. and you are welcome to modify and redistribute it under the GPL v2 license
  18.  
  19. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  20.  
  21. mysql> SELECT settings.value, @a:='ace' AS `hostname`, settings_a.data, @b:='ace2' AS `hostname`, settings_b.data FROM settings LEFT JOIN settings AS settings_a ON settings_a.value = settings.value AND settings_a.hostname = @a LEFT JOIN settings AS settings_b ON settings_b.value = settings.value AND settings_b.hostname = @b WHERE settings_a.data != settings_b.data OR (settings_a.data IS NULL AND settings_b.data IS NOT NULL) OR (settings_a.data IS NOT NULL AND settings_b.data IS NULL);Empty set (0.02 sec)
  22.  
  23. mysql> SELECT settings.value, @a:='ace' AS `hostname`, settings_a.data, @b:='ace2' AS `hostname`, settings_b.data FROM settings LEFT JOIN settings AS settings_a ON settings_a.value = settings.value AND settings_a.hostname = @a LEFT JOIN settings AS settings_b ON settings_b.value = settings.value AND settings_b.hostname = @b WHERE settings_a.data != settings_b.data OR (settings_a.data IS NULL AND settings_b.data IS NOT NULL) OR (settings_a.data IS NOT NULL AND settings_b.data IS NULL);
  24. Empty set (0.02 sec)
  25.  
  26. mysql> SELECT settings.value, @a:='ace' AS `hostname`, settings_a.data, @b:='ace2' AS `hostname`, settings_b.data FROM settings LEFT JOIN settings AS settings_a ON settings_a.value = settings.value AND settings_a.hostname = @a LEFT JOIN settings AS settings_b ON settings_b.value = settings.value AND settings_b.hostname = @b WHERE settings_a.data != settings_b.data OR (settings_a.data IS NULL AND settings_b.data IS NOT NULL) OR (settings_a.data IS NOT NULL AND settings_b.data IS NULL);
  27. Empty set (0.02 sec)
  28.  
  29. mysql> -- remove where clause
  30. mysql>
  31. mysql> SELECT settings.value, @a:='ace' AS `hostname`, settings_a.data, @b:='ace2' AS `hostname`, settings_b.data FROM settings LEFT JOIN settings AS settings_a ON settings_a.value = settings.value AND settings_a.hostname = @a LEFT JOIN settings AS settings_b ON settings_b.value = settings.value AND settings_b.hostname = @b ;
  32. +---------------------------------+----------+----------------------+----------+----------------------+
  33. | value | hostname | data | hostname | data |
  34. +---------------------------------+----------+----------------------+----------+----------------------+
  35. | AC3PassThru | ace | NULL | ace2 | NULL |
  36. | AC3PassThru | ace | 0 | ace2 | 0 |
  37. | AdjustFill | ace | 6 | ace2 | 6 |
  38. | AdjustFill | ace | 6 | ace2 | 6 |
  39. | AdvancedAudioSettings | ace | 0 | ace2 | 0 |
  40. | AdvancedAudioSettings | ace | 0 | ace2 | 0 |
  41. | AggressiveCommDetect | ace | NULL | ace2 | NULL |
  42. | AltClearSavedPosition | ace | 1 | ace2 | 1 |
  43. | AltClearSavedPosition | ace | 1 | ace2 | 1 |
  44. | AspectOverride | ace | 0 | ace2 | 0 |
  45. | AspectOverride | ace | 0 | ace2 | 0 |
  46. | Audio48kOverride | ace | 0 | ace2 | 0 |
  47. | Audio48kOverride | ace | 0 | ace2 | 0 |
  48. | AudioDefaultUpmix | ace | 1 | ace2 | 1 |
  49. | AudioDefaultUpmix | ace | 1 | ace2 | 1 |
  50. | AudioOutputDevice | ace | ALSA:default | ace2 | ALSA:default |
  51. | AudioOutputDevice | ace | ALSA:default | ace2 | ALSA:default |
  52. | AudioUpmixType | ace | 2 | ace2 | 2 |
  53. | AudioUpmixType | ace | 2 | ace2 | 2 |
  54. | AutoCommercialFlag | ace | NULL | ace2 | NULL |
  55. | AutoCommercialSkip | ace | 0 | ace2 | 0 |
  56. | AutoCommercialSkip | ace | 0 | ace2 | 0 |
  57. | AutoCommflagWhileRecording | ace | NULL | ace2 | NULL |
  58. | AutoExpireDayPriority | ace | NULL | ace2 | NULL |
  59. | AutoExpireDefault | ace | NULL | ace2 | NULL |
  60. | AutoExpireExtraSpace | ace | NULL | ace2 | NULL |
  61. | AutoExpireInsteadOfDelete | ace | NULL | ace2 | NULL |
  62. | AutoExpireLiveTVMaxAge | ace | NULL | ace2 | NULL |
  63. | AutoExpireMethod | ace | NULL | ace2 | NULL |
  64. | AutoExpireWatchedPriority | ace | NULL | ace2 | NULL |
  65. | AutomaticSetWatched | ace | 0 | ace2 | 0 |
  66. | AutomaticSetWatched | ace | 0 | ace2 | 0 |
  67. | AutoRunUserJob1 | ace | NULL | ace2 | NULL |
  68. | AutoRunUserJob2 | ace | NULL | ace2 | NULL |
  69. | AutoRunUserJob3 | ace | NULL | ace2 | NULL |
  70. | AutoRunUserJob4 | ace | NULL | ace2 | NULL |
  71. | AutoTranscode | ace | NULL | ace2 | NULL |
  72. | AutoTranscodeBeforeAutoCommflag | ace | NULL | ace2 | NULL |
  73. | BackendServerIP | ace | 127.0.0.1 | ace2 | 127.0.0.1 |
  74. | BackendServerIP | ace | 127.0.0.1 | ace2 | 127.0.0.1 |
  75. | BackendServerPort | ace | 6543 | ace2 | 6543 |
  76. | BackendServerPort | ace | 6543 | ace2 | 6543 |
  77. | BackendStartCommand | ace | NULL | ace2 | NULL |
  78. | BackendStatusPort | ace | 6544 | ace2 | 6544 |
  79. | BackendStatusPort | ace | 6544 | ace2 | 6544 |
  80. | BackendStopCommand | ace | NULL | ace2 | NULL |
  81. | BackupDBLastRunEnd | ace | NULL | ace2 | NULL |
  82. | BackupDBLastRunStart | ace | NULL | ace2 | NULL |
  83. | blockSDWUwithoutClient | ace | NULL | ace2 | NULL |
  84. | BrowseAllTuners | ace | 0 | ace2 | 0 |
  85. | BrowseAllTuners | ace | 0 | ace2 | 0 |
  86. | BrowseChannelGroup | ace | 0 | ace2 | 0 |
  87. | BrowseChannelGroup | ace | 0 | ace2 | 0 |
  88. | CategoryOverTime | ace | NULL | ace2 | NULL |
  89. | CCBackground | ace | 0 | ace2 | 0 |
  90. | CCBackground | ace | 0 | ace2 | 0 |
  91. | ChannelFormat | ace | <num> <sign> | ace2 | <num> <sign> |
  92. | ChannelFormat | ace | <num> <sign> | ace2 | <num> <sign> |
  93. | ChannelGroupDefault | ace | -1 | ace2 | -1 |
  94. | ChannelGroupDefault | ace | -1 | ace2 | -1 |
  95. | ChannelGroupRememberLast | ace | 0 | ace2 | 0 |
  96. | ChannelGroupRememberLast | ace | 0 | ace2 | 0 |
  97. | ChannelOrdering | ace | channum | ace2 | channum |
  98. | ChannelOrdering | ace | channum | ace2 | channum |
  99. | ClearSavedPosition | ace | 1 | ace2 | 1 |
  100. | ClearSavedPosition | ace | 1 | ace2 | 1 |
  101. | CommercialSkipMethod | ace | NULL | ace2 | NULL |
  102. | CommFlagFast | ace | NULL | ace2 | NULL |
  103. | CommSkipAllBlanks | ace | NULL | ace2 | NULL |
  104. | ContinueEmbeddedTVPlay | ace | 0 | ace2 | 0 |
  105. | ContinueEmbeddedTVPlay | ace | 0 | ace2 | 0 |
  106. | Country | ace | US | ace2 | US |
  107. | Country | ace | US | ace2 | US |
  108. | DataDirectMessage | ace | NULL | ace2 | NULL |
  109. | DateFormat | ace | ddd MMM d yyyy | ace2 | ddd MMM d yyyy |
  110. | DateFormat | ace | ddd MMM d yyyy | ace2 | ddd MMM d yyyy |
  111. | DBSchemaVer | ace | NULL | ace2 | NULL |
  112. | DecodeExtraAudio | ace | 1 | ace2 | 1 |
  113. | DecodeExtraAudio | ace | 1 | ace2 | 1 |
  114. | DefaultCCMode | ace | 0 | ace2 | 0 |
  115. | DefaultCCMode | ace | 0 | ace2 | 0 |
  116. | DefaultTranscoder | ace | NULL | ace2 | NULL |
  117. | DefaultTVChannel | ace | 3 | ace2 | 3 |
  118. | DefaultTVChannel | ace | 3 | ace2 | 3 |
  119. | DefaultVideoPlaybackProfile | ace | Normal | ace2 | Normal |
  120. | DefaultVideoPlaybackProfile | ace | Normal | ace2 | Normal |
  121. | DeletedFifoOrder | ace | NULL | ace2 | NULL |
  122. | DeletesFollowLinks | ace | NULL | ace2 | NULL |
  123. | DisableAutomaticBackup | ace | NULL | ace2 | NULL |
  124. | DisableFirewireReset | ace | 0 | ace2 | 0 |
  125. | DisableFirewireReset | ace | 0 | ace2 | 0 |
  126. | DisplayGroupDefaultViewMask | ace | 32777 | ace2 | 32777 |
  127. | DisplayGroupDefaultViewMask | ace | 32777 | ace2 | 32777 |
  128. | DisplayGroupTitleSort | ace | 0 | ace2 | 0 |
  129. | DisplayGroupTitleSort | ace | 0 | ace2 | 0 |
  130. | DisplayRecGroup | ace | All Programs | ace2 | All Programs |
  131. | DisplayRecGroup | ace | All Programs | ace2 | All Programs |
  132. | DisplayRecGroupIsCategory | ace | 0 | ace2 | 0 |
  133. | DisplayRecGroupIsCategory | ace | 0 | ace2 | 0 |
  134. | DispRecGroupAsAllProg | ace | 0 | ace2 | 0 |
  135. | DispRecGroupAsAllProg | ace | 0 | ace2 | 0 |
  136. | DTSPassThru | ace | 0 | ace2 | 0 |
  137. | DTSPassThru | ace | 0 | ace2 | 0 |
  138. | EITCrawIdleStart | ace | NULL | ace2 | NULL |
  139. | EITTransportTimeout | ace | NULL | ace2 | NULL |
  140. | EnableMHEG | ace | 0 | ace2 | 0 |
  141. | EnableMHEG | ace | 0 | ace2 | 0 |
  142. | EndOfRecordingExitPrompt | ace | 0 | ace2 | 0 |
  143. | EndOfRecordingExitPrompt | ace | 0 | ace2 | 0 |
  144. | EPGShowCategoryColors | ace | 1 | ace2 | 1 |
  145. | EPGShowCategoryColors | ace | 1 | ace2 | 1 |
  146. | ExactSeeking | ace | 0 | ace2 | 0 |
  147. | ExactSeeking | ace | 0 | ace2 | 0 |
  148. | FFRewReposTime | ace | 100 | ace2 | 100 |
  149. | FFRewReposTime | ace | 100 | ace2 | 100 |
  150. | FFRewReverse | ace | 1 | ace2 | 1 |
  151. | FFRewReverse | ace | 1 | ace2 | 1 |
  152. | FindOneRecordRecPriority | ace | NULL | ace2 | NULL |
  153. | FreqTable | ace | NULL | ace2 | NULL |
  154. | GlobalPKG_MIRROR | ace | 0 | ace2 | 0 |
  155. | GlobalPKG_MIRROR | ace | 0 | ace2 | 0 |
  156. | GlobalServiceHobbitserver | ace | NULL | ace2 | NULL |
  157. | GuiHeight | ace | 600 | ace2 | 600 |
  158. | GuiHeight | ace | 600 | ace2 | 600 |
  159. | GuiSizeForTV | ace | 1 | ace2 | 1 |
  160. | GuiSizeForTV | ace | 1 | ace2 | 1 |
  161. | GuiWidth | ace | 800 | ace2 | 800 |
  162. | GuiWidth | ace | 800 | ace2 | 800 |
  163. | HaveRepeats | ace | NULL | ace2 | NULL |
  164. | HDRingbufferSize | ace | NULL | ace2 | NULL |
  165. | HideMouseCursor | ace | 1 | ace2 | 1 |
  166. | HideMouseCursor | ace | 1 | ace2 | 1 |
  167. | HostActiveonboot | ace | | ace2 | |
  168. | HostActiveonboot | ace | | ace2 | |
  169. | HostActiveonbootath0 | ace | 0 | ace2 | 0 |
  170. | HostActiveonbootath0 | ace | 0 | ace2 | 0 |
  171. | HostActiveonbooteth0 | ace | 1 | ace2 | 1 |
  172. | HostActiveonbooteth0 | ace | 1 | ace2 | 1 |
  173. | HostActiveonbooteth1 | ace | 0 | ace2 | 0 |
  174. | HostActiveonbooteth1 | ace | 0 | ace2 | 0 |
  175. | HostActiveonbootwlan0 | ace | 0 | ace2 | 0 |
  176. | HostActiveonbootwlan0 | ace | 0 | ace2 | 0 |
  177. | HostActiveonbootwlan1 | ace | 0 | ace2 | 0 |
  178. | HostActiveonbootwlan1 | ace | 0 | ace2 | 0 |
  179. | HostAutodown | ace | 0 | ace2 | 0 |
  180. | HostAutodown | ace | 0 | ace2 | 0 |
  181. | HostCentralNFSIP | ace | file:nfsmap | ace2 | file:nfsmap |
  182. | HostCentralNFSIP | ace | file:nfsmap | ace2 | file:nfsmap |
  183. | HOSTdatafstype | ace | ext3 | ace2 | ext3 |
  184. | HOSTdatafstype | ace | ext3 | ace2 | ext3 |
  185. | HOSTDATAsize | ace | 2 | ace2 | 2 |
  186. | HOSTDATAsize | ace | 2 | ace2 | 2 |
  187. | HostDefaultath0 | ace | 0 | ace2 | 0 |
  188. | HostDefaultath0 | ace | 0 | ace2 | 0 |
  189. | HostDefaulteth0 | ace | 1 | ace2 | 1 |
  190. | HostDefaulteth0 | ace | 1 | ace2 | 1 |
  191. | HostDefaulteth1 | ace | 0 | ace2 | 0 |
  192. | HostDefaulteth1 | ace | 0 | ace2 | 0 |
  193. | HostDefaultwlan0 | ace | 0 | ace2 | 0 |
  194. | HostDefaultwlan0 | ace | 0 | ace2 | 0 |
  195. | HostDefaultwlan1 | ace | 0 | ace2 | 0 |
  196. | HostDefaultwlan1 | ace | 0 | ace2 | 0 |
  197. | HostDNSath0 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  198. | HostDNSath0 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  199. | HostDNSeth0 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  200. | HostDNSeth0 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  201. | HostDNSeth1 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  202. | HostDNSeth1 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  203. | HostDNSwlan0 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  204. | HostDNSwlan0 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  205. | HostDNSwlan1 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  206. | HostDNSwlan1 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  207. | Hostfoldingathome | ace | 0 | ace2 | 0 |
  208. | Hostfoldingathome | ace | 0 | ace2 | 0 |
  209. | Hostfoldingworksize | ace | big | ace2 | big |
  210. | Hostfoldingworksize | ace | big | ace2 | big |
  211. | Hostfuppes | ace | 0 | ace2 | 0 |
  212. | Hostfuppes | ace | 0 | ace2 | 0 |
  213. | HostGWath0 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  214. | HostGWath0 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  215. | HostGWeth0 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  216. | HostGWeth0 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  217. | HostGWeth1 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  218. | HostGWeth1 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  219. | HostGWwlan0 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  220. | HostGWwlan0 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  221. | HostGWwlan1 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  222. | HostGWwlan1 | ace | 192.168.1.1 | ace2 | 192.168.1.1 |
  223. | HostHaveCentralNFS | ace | no | ace2 | no |
  224. | HostHaveCentralNFS | ace | no | ace2 | no |
  225. | HOSTinstallationtype | ace | Full/Auto | ace2 | Full/Auto |
  226. | HOSTinstallationtype | ace | Full/Auto | ace2 | Full/Auto |
  227. | HostIPath0 | ace | 192.168.1.12 | ace2 | 192.168.1.12 |
  228. | HostIPath0 | ace | 192.168.1.12 | ace2 | 192.168.1.12 |
  229. | HostIPeth0 | ace | 192.168.1.12 | ace2 | 192.168.1.12 |
  230. | HostIPeth0 | ace | 192.168.1.12 | ace2 | 192.168.1.12 |
  231. | HostIPeth1 | ace | 192.168.1.12 | ace2 | 192.168.1.12 |
  232. | HostIPeth1 | ace | 192.168.1.12 | ace2 | 192.168.1.12 |
  233. | HostIPwlan0 | ace | 192.168.1.12 | ace2 | 192.168.1.12 |
  234. | HostIPwlan0 | ace | 192.168.1.12 | ace2 | 192.168.1.12 |
  235. | HostIPwlan1 | ace | 192.168.1.12 | ace2 | 192.168.1.12 |
  236. | HostIPwlan1 | ace | 192.168.1.12 | ace2 | 192.168.1.12 |
  237. | HostMiro | ace | 0 | ace2 | 0 |
  238. | HostMiro | ace | 0 | ace2 | 0 |
  239. | HostMyhostname | ace | Envy | ace2 | Envy |
  240. | HostMyhostname | ace | Envy | ace2 | Envy |
  241. | HostMysqlserver | ace | localhost | ace2 | localhost |
  242. | HostMysqlserver | ace | localhost | ace2 | localhost |
  243. | HostNetDevice | ace | eth0 | ace2 | eth0 |
  244. | HostNetDevice | ace | eth0 | ace2 | eth0 |
  245. | HostNETMASKath0 | ace | /24 255.255.255.0 | ace2 | /24 255.255.255.0 |
  246. | HostNETMASKath0 | ace | /24 255.255.255.0 | ace2 | /24 255.255.255.0 |
  247. | HostNETMASKeth0 | ace | /24 255.255.255.0 | ace2 | /24 255.255.255.0 |
  248. | HostNETMASKeth0 | ace | /24 255.255.255.0 | ace2 | /24 255.255.255.0 |
  249. | HostNETMASKeth1 | ace | /24 255.255.255.0 | ace2 | /24 255.255.255.0 |
  250. | HostNETMASKeth1 | ace | /24 255.255.255.0 | ace2 | /24 255.255.255.0 |
  251. | HostNETMASKwlan0 | ace | /24 255.255.255.0 | ace2 | /24 255.255.255.0 |
  252. | HostNETMASKwlan0 | ace | /24 255.255.255.0 | ace2 | /24 255.255.255.0 |
  253. | HostNETMASKwlan1 | ace | /24 255.255.255.0 | ace2 | /24 255.255.255.0 |
  254. | HostNETMASKwlan1 | ace | /24 255.255.255.0 | ace2 | /24 255.255.255.0 |
  255. | HostNFSmountpoint | ace | /data/media | ace2 | /data/media |
  256. | HostNFSmountpoint | ace | /data/media | ace2 | /data/media |
  257. | HOSTOSsize | ace | 2 | ace2 | 2 |
  258. | HOSTOSsize | ace | 2 | ace2 | 2 |
  259. | Hostpluginmythappletrailers | ace | 0 | ace2 | 0 |
  260. | Hostpluginmythappletrailers | ace | 0 | ace2 | 0 |
  261. | Hostpluginmythstream | ace | 0 | ace2 | 0 |
  262. | Hostpluginmythstream | ace | 0 | ace2 | 0 |
  263. | HOSTrootfstype | ace | ext3 | ace2 | ext3 |
  264. | HOSTrootfstype | ace | ext3 | ace2 | ext3 |
  265. | HOSTrootSSH | ace | 0 | ace2 | 0 |
  266. | HOSTrootSSH | ace | 0 | ace2 | 0 |
  267. | HostRunFrontend | ace | 1 | ace2 | 1 |
  268. | HostRunFrontend | ace | 1 | ace2 | 1 |
  269. | HostServiceHobbitclient | ace | | ace2 | |
  270. | HostServiceHobbitclient | ace | | ace2 | |
  271. | HostShowToolTips | ace | 1 | ace2 | 1 |
  272. | HostShowToolTips | ace | 1 | ace2 | 1 |
  273. | HostShutdownTime | ace | 2 | ace2 | 2 |
  274. | HostShutdownTime | ace | 2 | ace2 | 2 |
  275. | HostShutdownTime2 | ace | 2 | ace2 | 2 |
  276. | HostShutdownTime2 | ace | 2 | ace2 | 2 |
  277. | HOSTSWAPsize | ace | 16060 | ace2 | 16060 |
  278. | HOSTSWAPsize | ace | 16060 | ace2 | 16060 |
  279. | HostSystemType | ace | Standalone | ace2 | Standalone |
  280. | HostSystemType | ace | Standalone | ace2 | Standalone |
  281. | HOSTtemplatetype | ace | Do Nothing | ace2 | Do Nothing |
  282. | HOSTtemplatetype | ace | Do Nothing | ace2 | Do Nothing |
  283. | HostTimeZone | ace | US/Samoa | ace2 | US/Samoa |
  284. | HostTimeZone | ace | US/Samoa | ace2 | US/Samoa |
  285. | HostTimeZoneRegion | ace | US | ace2 | US |
  286. | HostTimeZoneRegion | ace | US | ace2 | US |
  287. | HostTimezoneRegion_Africa | ace | Windhoek | ace2 | Windhoek |
  288. | HostTimezoneRegion_Africa | ace | Windhoek | ace2 | Windhoek |
  289. | HostTimezoneRegion_America | ace | Yellowknife | ace2 | Yellowknife |
  290. | HostTimezoneRegion_America | ace | Yellowknife | ace2 | Yellowknife |
  291. | HostTimezoneRegion_Antarctica | ace | Vostok | ace2 | Vostok |
  292. | HostTimezoneRegion_Antarctica | ace | Vostok | ace2 | Vostok |
  293. | HostTimezoneRegion_Arctic | ace | Longyearbyen | ace2 | Longyearbyen |
  294. | HostTimezoneRegion_Arctic | ace | Longyearbyen | ace2 | Longyearbyen |
  295. | HostTimezoneRegion_Asia | ace | Yerevan | ace2 | Yerevan |
  296. | HostTimezoneRegion_Asia | ace | Yerevan | ace2 | Yerevan |
  297. | HostTimezoneRegion_Atlantic | ace | Stanley | ace2 | Stanley |
  298. | HostTimezoneRegion_Atlantic | ace | Stanley | ace2 | Stanley |
  299. | HostTimezoneRegion_Australia | ace | Yancowinna | ace2 | Yancowinna |
  300. | HostTimezoneRegion_Australia | ace | Yancowinna | ace2 | Yancowinna |
  301. | HostTimezoneRegion_Brazil | ace | West | ace2 | West |
  302. | HostTimezoneRegion_Brazil | ace | West | ace2 | West |
  303. | HostTimezoneRegion_Canada | ace | Yukon | ace2 | Yukon |
  304. | HostTimezoneRegion_Canada | ace | Yukon | ace2 | Yukon |
  305. | HostTimezoneRegion_Chile | ace | EasterIsland | ace2 | EasterIsland |
  306. | HostTimezoneRegion_Chile | ace | EasterIsland | ace2 | EasterIsland |
  307. | HostTimezoneRegion_Etc | ace | Zulu | ace2 | Zulu |
  308. | HostTimezoneRegion_Etc | ace | Zulu | ace2 | Zulu |
  309. | HostTimezoneRegion_Europe | ace | Zurich | ace2 | Zurich |
  310. | HostTimezoneRegion_Europe | ace | Zurich | ace2 | Zurich |
  311. | HostTimezoneRegion_Indian | ace | Reunion | ace2 | Reunion |
  312. | HostTimezoneRegion_Indian | ace | Reunion | ace2 | Reunion |
  313. | HostTimezoneRegion_Mexico | ace | General | ace2 | General |
  314. | HostTimezoneRegion_Mexico | ace | General | ace2 | General |
  315. | HostTimezoneRegion_Mideast | ace | Riyadh89 | ace2 | Riyadh89 |
  316. | HostTimezoneRegion_Mideast | ace | Riyadh89 | ace2 | Riyadh89 |
  317. | HostTimezoneRegion_Pacific | ace | Yap | ace2 | Yap |
  318. | HostTimezoneRegion_Pacific | ace | Yap | ace2 | Yap |
  319. | HostTimezoneRegion_US | ace | Samoa | ace2 | Samoa |
  320. | HostTimezoneRegion_US | ace | Samoa | ace2 | Samoa |
  321. | Hostupdateplan | ace | None | ace2 | None |
  322. | Hostupdateplan | ace | None | ace2 | None |
  323. | HOSTuprootfstype | ace | ext3 | ace2 | ext3 |
  324. | HOSTuprootfstype | ace | ext3 | ace2 | ext3 |
  325. | HostUseALLdata | ace | 1 | ace2 | 1 |
  326. | HostUseALLdata | ace | 1 | ace2 | 1 |
  327. | HostUseDHCPath0 | ace | 0 | ace2 | 0 |
  328. | HostUseDHCPath0 | ace | 0 | ace2 | 0 |
  329. | HostUseDHCPeth0 | ace | 0 | ace2 | 0 |
  330. | HostUseDHCPeth0 | ace | 0 | ace2 | 0 |
  331. | HostUseDHCPeth1 | ace | 0 | ace2 | 0 |
  332. | HostUseDHCPeth1 | ace | 0 | ace2 | 0 |
  333. | HostUseDHCPwlan0 | ace | 0 | ace2 | 0 |
  334. | HostUseDHCPwlan0 | ace | 0 | ace2 | 0 |
  335. | HostUseDHCPwlan1 | ace | 0 | ace2 | 0 |
  336. | HostUseDHCPwlan1 | ace | 0 | ace2 | 0 |
  337. | HostUseMythWelcome | ace | 0 | ace2 | 0 |
  338. | HostUseMythWelcome | ace | 0 | ace2 | 0 |
  339. | HostUseSWAP | ace | 1 | ace2 | 1 |
  340. | HostUseSWAP | ace | 1 | ace2 | 1 |
  341. | HostUseXLargeMouse | ace | 1 | ace2 | 1 |
  342. | HostUseXLargeMouse | ace | 1 | ace2 | 1 |
  343. | HostUseXvnc | ace | 0 | ace2 | 0 |
  344. | HostUseXvnc | ace | 0 | ace2 | 0 |
  345. | Hostwebmin | ace | 0 | ace2 | 0 |
  346. | Hostwebmin | ace | 0 | ace2 | 0 |
  347. | HostXcardtype | ace | nVidia | ace2 | nVidia |
  348. | HostXcardtype | ace | nVidia | ace2 | nVidia |
  349. | HostXIgnoreConfig | ace | 0 | ace2 | 0 |
  350. | HostXIgnoreConfig | ace | 0 | ace2 | 0 |
  351. | HostXine | ace | 0 | ace2 | 0 |
  352. | HostXine | ace | 0 | ace2 | 0 |
  353. | HostXModelineCatagory | ace | Auto | ace2 | Auto |
  354. | HostXModelineCatagory | ace | Auto | ace2 | Auto |
  355. | HostXnVidia1080i | ace | 1 | ace2 | 1 |
  356. | HostXnVidia1080i | ace | 1 | ace2 | 1 |
  357. | HostXnVidia1080p | ace | 1 | ace2 | 1 |
  358. | HostXnVidia1080p | ace | 1 | ace2 | 1 |
  359. | HostXnVidia480p | ace | 1 | ace2 | 1 |
  360. | HostXnVidia480p | ace | 1 | ace2 | 1 |
  361. | HostXnVidia720p | ace | 1 | ace2 | 1 |
  362. | HostXnVidia720p | ace | 1 | ace2 | 1 |
  363. | HostXNvidiaConnection | ace | Auto | ace2 | Auto |
  364. | HostXNvidiaConnection | ace | Auto | ace2 | Auto |
  365. | HostXNvidiaModelineCatagory | ace | Auto | ace2 | Auto |
  366. | HostXNvidiaModelineCatagory | ace | Auto | ace2 | Auto |
  367. | HostXnVidiaTVformat | ace | AUTOSELECT | ace2 | AUTOSELECT |
  368. | HostXnVidiaTVformat | ace | AUTOSELECT | ace2 | AUTOSELECT |
  369. | HostXnVidiaTVstandard | ace | PAL-B | ace2 | PAL-B |
  370. | HostXnVidiaTVstandard | ace | PAL-B | ace2 | PAL-B |
  371. | HostXres | ace | 800x600 | ace2 | 800x600 |
  372. | HostXres | ace | 800x600 | ace2 | 800x600 |
  373. | HostXUseAdvanced | ace | 0 | ace2 | 0 |
  374. | HostXUseAdvanced | ace | 0 | ace2 | 0 |
  375. | idleWaitForRecordingTime | ace | NULL | ace2 | NULL |
  376. | ISO639Language0 | ace | NULL | ace2 | NULL |
  377. | ISO639Language1 | ace | NULL | ace2 | NULL |
  378. | JobAllowCommFlag | ace | 1 | ace2 | 1 |
  379. | JobAllowCommFlag | ace | 1 | ace2 | 1 |
  380. | JobAllowTranscode | ace | 1 | ace2 | 1 |
  381. | JobAllowTranscode | ace | 1 | ace2 | 1 |
  382. | JobAllowUserJob1 | ace | 0 | ace2 | 0 |
  383. | JobAllowUserJob1 | ace | 0 | ace2 | 0 |
  384. | JobAllowUserJob2 | ace | 0 | ace2 | 0 |
  385. | JobAllowUserJob2 | ace | 0 | ace2 | 0 |
  386. | JobAllowUserJob3 | ace | 0 | ace2 | 0 |
  387. | JobAllowUserJob3 | ace | 0 | ace2 | 0 |
  388. | JobAllowUserJob4 | ace | 0 | ace2 | 0 |
  389. | JobAllowUserJob4 | ace | 0 | ace2 | 0 |
  390. | JobQueueCheckFrequency | ace | 60 | ace2 | 60 |
  391. | JobQueueCheckFrequency | ace | 60 | ace2 | 60 |
  392. | JobQueueCommFlagCommand | ace | NULL | ace2 | NULL |
  393. | JobQueueCPU | ace | 0 | ace2 | 0 |
  394. | JobQueueCPU | ace | 0 | ace2 | 0 |
  395. | JobQueueMaxSimultaneousJobs | ace | 1 | ace2 | 1 |
  396. | JobQueueMaxSimultaneousJobs | ace | 1 | ace2 | 1 |
  397. | JobQueueTranscodeCommand | ace | NULL | ace2 | NULL |
  398. | JobQueueWindowEnd | ace | 23:59 | ace2 | 23:59 |
  399. | JobQueueWindowEnd | ace | 23:59 | ace2 | 23:59 |
  400. | JobQueueWindowStart | ace | 00:00 | ace2 | 00:00 |
  401. | JobQueueWindowStart | ace | 00:00 | ace2 | 00:00 |
  402. | JobsRunOnRecordHost | ace | NULL | ace2 | NULL |
  403. | JumpToProgramOSD | ace | 1 | ace2 | 1 |
  404. | JumpToProgramOSD | ace | 1 | ace2 | 1 |
  405. | Language | ace | en_US | ace2 | en_US |
  406. | Language | ace | en_US | ace2 | en_US |
  407. | LastFreeCard | ace | NULL | ace2 | NULL |
  408. | LCDBacklightOn | ace | 1 | ace2 | 1 |
  409. | LCDBacklightOn | ace | 1 | ace2 | 1 |
  410. | LCDBigClock | ace | 0 | ace2 | 0 |
  411. | LCDBigClock | ace | 0 | ace2 | 0 |
  412. | LCDEnable | ace | 0 | ace2 | 0 |
  413. | LCDEnable | ace | 0 | ace2 | 0 |
  414. | LCDHeartBeatOn | ace | 0 | ace2 | 0 |
  415. | LCDHeartBeatOn | ace | 0 | ace2 | 0 |
  416. | LCDKeyString | ace | ABCDEF | ace2 | ABCDEF |
  417. | LCDKeyString | ace | ABCDEF | ace2 | ABCDEF |
  418. | LCDPopupTime | ace | 5 | ace2 | 5 |
  419. | LCDPopupTime | ace | 5 | ace2 | 5 |
  420. | LCDShowChannel | ace | 1 | ace2 | 1 |
  421. | LCDShowChannel | ace | 1 | ace2 | 1 |
  422. | LCDShowGeneric | ace | 1 | ace2 | 1 |
  423. | LCDShowGeneric | ace | 1 | ace2 | 1 |
  424. | LCDShowMenu | ace | 1 | ace2 | 1 |
  425. | LCDShowMenu | ace | 1 | ace2 | 1 |
  426. | LCDShowMusic | ace | 1 | ace2 | 1 |
  427. | LCDShowMusic | ace | 1 | ace2 | 1 |
  428. | LCDShowMusicItems | ace | ArtistTitle | ace2 | ArtistTitle |
  429. | LCDShowMusicItems | ace | ArtistTitle | ace2 | ArtistTitle |
  430. | LCDShowRecStatus | ace | 0 | ace2 | 0 |
  431. | LCDShowRecStatus | ace | 0 | ace2 | 0 |
  432. | LCDShowTime | ace | 1 | ace2 | 1 |
  433. | LCDShowTime | ace | 1 | ace2 | 1 |
  434. | LCDShowVolume | ace | 1 | ace2 | 1 |
  435. | LCDShowVolume | ace | 1 | ace2 | 1 |
  436. | LetterboxColour | ace | 0 | ace2 | 0 |
  437. | LetterboxColour | ace | 0 | ace2 | 0 |
  438. | LircSocket | ace | /var/run/lirc/lircd | ace2 | /var/run/lirc/lircd |
  439. | LircSocket | ace | /var/run/lirc/lircd | ace2 | /var/run/lirc/lircd |
  440. | LiveTVPriority | ace | NULL | ace2 | NULL |
  441. | LogCleanDays | ace | 14 | ace2 | 14 |
  442. | LogCleanDays | ace | 14 | ace2 | 14 |
  443. | LogCleanEnabled | ace | 0 | ace2 | 0 |
  444. | LogCleanEnabled | ace | 0 | ace2 | 0 |
  445. | LogCleanMax | ace | 30 | ace2 | 30 |
  446. | LogCleanMax | ace | 30 | ace2 | 30 |
  447. | LogCleanPeriod | ace | 14 | ace2 | 14 |
  448. | LogCleanPeriod | ace | 14 | ace2 | 14 |
  449. | LogEnabled | ace | NULL | ace2 | NULL |
  450. | LogMaxCount | ace | 100 | ace2 | 100 |
  451. | LogMaxCount | ace | 100 | ace2 | 100 |
  452. | LogPrintLevel | ace | 8 | ace2 | 8 |
  453. | LogPrintLevel | ace | 8 | ace2 | 8 |
  454. | LongChannelFormat | ace | <num> <name> | ace2 | <num> <name> |
  455. | LongChannelFormat | ace | <num> <name> | ace2 | <num> <name> |
  456. | MasterBackendOverride | ace | NULL | ace2 | NULL |
  457. | MasterMixerVolume | ace | 70 | ace2 | 70 |
  458. | MasterMixerVolume | ace | 70 | ace2 | 70 |
  459. | MasterServerIP | ace | NULL | ace2 | NULL |
  460. | MasterServerPort | ace | NULL | ace2 | NULL |
  461. | MaxChannels | ace | 2 | ace2 | 2 |
  462. | MaxChannels | ace | 2 | ace2 | 2 |
  463. | MaximumCommercialSkip | ace | NULL | ace2 | NULL |
  464. | MediaChangeEvents | ace | 0 | ace2 | 0 |
  465. | MediaChangeEvents | ace | 0 | ace2 | 0 |
  466. | MenuTheme | ace | defaultmenu | ace2 | defaultmenu |
  467. | MenuTheme | ace | defaultmenu | ace2 | defaultmenu |
  468. | MixerControl | ace | PCM | ace2 | PCM |
  469. | MixerControl | ace | PCM | ace2 | PCM |
  470. | MixerDevice | ace | /dev/mixer | ace2 | /dev/mixer |
  471. | MixerDevice | ace | /dev/mixer | ace2 | /dev/mixer |
  472. | MonitorDrives | ace | 0 | ace2 | 0 |
  473. | MonitorDrives | ace | 0 | ace2 | 0 |
  474. | MultiChannelPCM | ace | 0 | ace2 | 0 |
  475. | MultiChannelPCM | ace | 0 | ace2 | 0 |
  476. | MythArchiveDateFormat | ace | %a %b %d %Y | ace2 | %a %b %d %Y |
  477. | MythArchiveDateFormat | ace | %a %b %d %Y | ace2 | %a %b %d %Y |
  478. | MythArchiveTimeFormat | ace | %I:%M %p | ace2 | %I:%M %p |
  479. | MythArchiveTimeFormat | ace | %I:%M %p | ace2 | %I:%M %p |
  480. | MythArchiveVideoFormat | ace | NTSC | ace2 | NTSC |
  481. | MythArchiveVideoFormat | ace | NTSC | ace2 | NTSC |
  482. | MythControlsVolume | ace | 1 | ace2 | 1 |
  483. | MythControlsVolume | ace | 1 | ace2 | 1 |
  484. | mythfilldatabaseLastRunEnd | ace | NULL | ace2 | NULL |
  485. | mythfilldatabaseLastRunStart | ace | NULL | ace2 | NULL |
  486. | mythfilldatabaseLastRunStatus | ace | NULL | ace2 | NULL |
  487. | MythFillDatabasePath | ace | NULL | ace2 | NULL |
  488. | MythFillEnabled | ace | NULL | ace2 | NULL |
  489. | MythFillGrabberSuggestsTime | ace | NULL | ace2 | NULL |
  490. | MythFillMaxHour | ace | NULL | ace2 | NULL |
  491. | MythFillMinHour | ace | NULL | ace2 | NULL |
  492. | MythFillPeriod | ace | NULL | ace2 | NULL |
  493. | NetworkControlEnabled | ace | 0 | ace2 | 0 |
  494. | NetworkControlEnabled | ace | 0 | ace2 | 0 |
  495. | NetworkControlPort | ace | 6546 | ace2 | 6546 |
  496. | NetworkControlPort | ace | 6546 | ace2 | 6546 |
  497. | NoPromptOnExit | ace | 1 | ace2 | 1 |
  498. | NoPromptOnExit | ace | 1 | ace2 | 1 |
  499. | OSDCC708TextZoom | ace | 100 | ace2 | 100 |
  500. | OSDCC708TextZoom | ace | 100 | ace2 | 100 |
  501. | OSDSubFont | ace | FreeSans | ace2 | FreeSans |
  502. | OSDSubFont | ace | FreeSans | ace2 | FreeSans |
  503. | OverrideExitMenu | ace | 2 | ace2 | 2 |
  504. | OverrideExitMenu | ace | 2 | ace2 | 2 |
  505. | PassThruDeviceOverride | ace | 0 | ace2 | 0 |
  506. | PassThruDeviceOverride | ace | 0 | ace2 | 0 |
  507. | PassThruOutputDevice | ace | Default | ace2 | Default |
  508. | PassThruOutputDevice | ace | Default | ace2 | Default |
  509. | PCMMixerVolume | ace | 70 | ace2 | 70 |
  510. | PCMMixerVolume | ace | 70 | ace2 | 70 |
  511. | PersistentBrowseMode | ace | 1 | ace2 | 1 |
  512. | PersistentBrowseMode | ace | 1 | ace2 | 1 |
  513. | PIPLocation | ace | 0 | ace2 | 0 |
  514. | PIPLocation | ace | 0 | ace2 | 0 |
  515. | PlaybackBoxStartInTitle | ace | 1 | ace2 | 1 |
  516. | PlaybackBoxStartInTitle | ace | 1 | ace2 | 1 |
  517. | PlaybackExitPrompt | ace | 0 | ace2 | 0 |
  518. | PlaybackExitPrompt | ace | 0 | ace2 | 0 |
  519. | PlaybackWatchList | ace | 1 | ace2 | 1 |
  520. | PlaybackWatchList | ace | 1 | ace2 | 1 |
  521. | PlaybackWLAutoExpire | ace | 0 | ace2 | 0 |
  522. | PlaybackWLAutoExpire | ace | 0 | ace2 | 0 |
  523. | PlaybackWLBlackOut | ace | 2 | ace2 | 2 |
  524. | PlaybackWLBlackOut | ace | 2 | ace2 | 2 |
  525. | PlaybackWLMaxAge | ace | 60 | ace2 | 60 |
  526. | PlaybackWLMaxAge | ace | 60 | ace2 | 60 |
  527. | PlaybackWLStart | ace | 0 | ace2 | 0 |
  528. | PlaybackWLStart | ace | 0 | ace2 | 0 |
  529. | PlayBoxEpisodeSort | ace | Date | ace2 | Date |
  530. | PlayBoxEpisodeSort | ace | Date | ace2 | Date |
  531. | PlayBoxOrdering | ace | 1 | ace2 | 1 |
  532. | PlayBoxOrdering | ace | 1 | ace2 | 1 |
  533. | Prefer708Captions | ace | 1 | ace2 | 1 |
  534. | Prefer708Captions | ace | 1 | ace2 | 1 |
  535. | PrefInputPriority | ace | NULL | ace2 | NULL |
  536. | QueryInitialFilter | ace | 0 | ace2 | 0 |
  537. | QueryInitialFilter | ace | 0 | ace2 | 0 |
  538. | RealtimePriority | ace | 1 | ace2 | 1 |
  539. | RealtimePriority | ace | 1 | ace2 | 1 |
  540. | RememberRecGroup | ace | 1 | ace2 | 1 |
  541. | RememberRecGroup | ace | 1 | ace2 | 1 |
  542. | RerecordWatched | ace | NULL | ace2 | NULL |
  543. | RunFrontendInWindow | ace | 0 | ace2 | 0 |
  544. | RunFrontendInWindow | ace | 0 | ace2 | 0 |
  545. | SaveTranscoding | ace | NULL | ace2 | NULL |
  546. | SchedMoveHigher | ace | NULL | ace2 | NULL |
  547. | SchedOpenEnd | ace | NULL | ace2 | NULL |
  548. | ScreenShotPath | ace | /tmp/ | ace2 | /tmp/ |
  549. | ScreenShotPath | ace | /tmp/ | ace2 | /tmp/ |
  550. | SelChangeRecThreshold | ace | 16 | ace2 | 16 |
  551. | SelChangeRecThreshold | ace | 16 | ace2 | 16 |
  552. | ServerHaltCommand | ace | NULL | ace2 | NULL |
  553. | SetupPinCodeRequired | ace | 0 | ace2 | 0 |
  554. | SetupPinCodeRequired | ace | 0 | ace2 | 0 |
  555. | ShortDateFormat | ace | M/d | ace2 | M/d |
  556. | ShortDateFormat | ace | M/d | ace2 | M/d |
  557. | SingleRecordRecPriority | ace | NULL | ace2 | NULL |
  558. | SmartForward | ace | 0 | ace2 | 0 |
  559. | SmartForward | ace | 0 | ace2 | 0 |
  560. | SRCQuality | ace | 1 | ace2 | 1 |
  561. | SRCQuality | ace | 1 | ace2 | 1 |
  562. | SRCQualityOverride | ace | 0 | ace2 | 0 |
  563. | SRCQualityOverride | ace | 0 | ace2 | 0 |
  564. | StartupSecsBeforeRecording | ace | NULL | ace2 | NULL |
  565. | StorageScheduler | ace | NULL | ace2 | NULL |
  566. | SubtitleCodec | ace | UTF-8 | ace2 | UTF-8 |
  567. | SubtitleCodec | ace | UTF-8 | ace2 | UTF-8 |
  568. | ThemePainter | ace | qt | ace2 | qt |
  569. | ThemePainter | ace | qt | ace2 | qt |
  570. | ThemeUpdateStatus | ace | | ace2 | crap |
  571. | ThemeUpdateStatus | ace | | ace2 | crap |
  572. | TimeFormat | ace | h:mm AP | ace2 | h:mm AP |
  573. | TimeFormat | ace | h:mm AP | ace2 | h:mm AP |
  574. | TimeOffset | ace | NULL | ace2 | NULL |
  575. | TruncateDeletesSlowly | ace | 0 | ace2 | 0 |
  576. | TruncateDeletesSlowly | ace | 0 | ace2 | 0 |
  577. | TVFormat | ace | NULL | ace2 | NULL |
  578. | UDPNotifyPort | ace | 6948 | ace2 | 6948 |
  579. | UDPNotifyPort | ace | 6948 | ace2 | 6948 |
  580. | UPnP/RebuildDelay | ace | 30 | ace2 | 30 |
  581. | UPnP/RebuildDelay | ace | 30 | ace2 | 30 |
  582. | UPnP/WMPSource | ace | NULL | ace2 | NULL |
  583. | UseArrowAccels | ace | 1 | ace2 | 1 |
  584. | UseArrowAccels | ace | 1 | ace2 | 1 |
  585. | UseFixedWindowSize | ace | 0 | ace2 | 0 |
  586. | UseFixedWindowSize | ace | 0 | ace2 | 0 |
  587. | UseOutputPictureControls | ace | 0 | ace2 | 0 |
  588. | UseOutputPictureControls | ace | 0 | ace2 | 0 |
  589. | UserJobDesc1 | ace | NULL | ace2 | NULL |
  590. | UserJobDesc2 | ace | NULL | ace2 | NULL |
  591. | UserJobDesc3 | ace | NULL | ace2 | NULL |
  592. | UserJobDesc4 | ace | NULL | ace2 | NULL |
  593. | UseVirtualKeyboard | ace | 1 | ace2 | 1 |
  594. | UseVirtualKeyboard | ace | 1 | ace2 | 1 |
  595. | VbiFormat | ace | NULL | ace2 | NULL |
  596. | WakeupTimeFormat | ace | NULL | ace2 | NULL |
  597. | WatchTVGuide | ace | 0 | ace2 | 0 |
  598. | WatchTVGuide | ace | 0 | ace2 | 0 |
  599. | WOLbackendConnectRetry | ace | NULL | ace2 | NULL |
  600. | XineramaMonitorAspectRatio | ace | 1.3333 | ace2 | 1.3333 |
  601. | XineramaMonitorAspectRatio | ace | 1.3333 | ace2 | 1.3333 |
  602. | XineramaScreen | ace | 0 | ace2 | 0 |
  603. | XineramaScreen | ace | 0 | ace2 | 0 |
  604. +---------------------------------+----------+----------------------+----------+----------------------+
  605. 569 rows in set (0.01 sec)
  606.  
  607. mysql>
  608. mysql>
  609. mysql>
  610. mysql> SELECT settings.value, @a:='ace' AS `hostname`, settings_a.data, @b:='ace2' AS `hostname`, settings_b.data FROM settings LEFT JOIN settings AS settings_a ON settings_a.value = settings.value AND settings_a.hostname = @a LEFT JOIN settings AS settings_b ON settings_b.value = settings.value AND settings_b.hostname = @b WHERE settings_a.data != settings_b.data OR (settings_a.data IS NULL AND settings_b.data IS NOT NULL) OR (settings_a.data IS NOT NULL AND settings_b.data IS NULL);
  611. +-------------------+----------+------+----------+------+
  612. | value | hostname | data | hostname | data |
  613. +-------------------+----------+------+----------+------+
  614. | ThemeUpdateStatus | ace | | ace2 | crap |
  615. | ThemeUpdateStatus | ace | | ace2 | crap |
  616. +-------------------+----------+------+----------+------+
  617. 2 rows in set (0.02 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!