Revision 8948
Added by Aaron Marcuse-Kubitza over 11 years ago
| index.htm | ||
|---|---|---|
| 23 | 23 |
<DL><p> |
| 24 | 24 |
<DT><A HREF="https://pods.iplantcollaborative.org/wiki/display/iptol/BIEN+Database+3.0" ADD_DATE="1362528622" ICON_URI="https://pods.iplantcollaborative.org/wiki/s/2035/11/_/images/logo/confluence_16.png"><img width="16" height="16" src="https://pods.iplantcollaborative.org/wiki/s/2035/11/_/images/logo/confluence_16.png" style="margin-right: 0.5em;"/>Wiki</A> |
| 25 | 25 |
<DT><A HREF="http://vegpath.org/twiki/" ADD_DATE="1366412217" ICON_URI="http://vegpath.org/twiki/pub/Main/WebPreferences/favicon.ico"><img width="16" height="16" src="http://vegpath.org/twiki/pub/Main/WebPreferences/favicon.ico" style="margin-right: 0.5em;"/>TWiki</A> |
| 26 |
<DT><A HREF="http://twiki.org/cgi-bin/view/TWiki/TextFormattingRules" ADD_DATE="1366410442" ICON_URI="http://twiki.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://twiki.org/favicon.ico" style="margin-right: 0.5em;"/>syntax</A>
|
|
| 26 |
<DT><A HREF="http://vegpath.org/twiki/do/view/TWiki/TextFormattingRules" ADD_DATE="1368120736" ICON_URI="http://vegpath.org/twiki/pub/TWiki/WebPreferences/favicon.ico"><img width="16" height="16" src="http://vegpath.org/twiki/pub/TWiki/WebPreferences/favicon.ico" style="margin-right: 0.5em;"/>syntax</A>
|
|
| 27 | 27 |
<DT><A HREF="http://www.redmine.org/projects/redmine/wiki/RedmineTextFormatting" ADD_DATE="1318963452" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>syntax</A> |
| 28 | 28 |
<DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Database_development" ADD_DATE="1318376026" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715" style="margin-right: 0.5em;"/>Wiki</A> |
| 29 | 29 |
<DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/To_Do" ADD_DATE="1342214119" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715" style="margin-right: 0.5em;"/>To do</A> |
| ... | ... | |
| 201 | 201 |
<DD>page's description: The bash man page has long had the following bug listed: "It's too big and too slow" (at the very bottom of the man page). If you agree with that, then you probably won't want to read about the "new" associative arrays that were added in version 4.0 of bash. |
| 202 | 202 |
<DT><A HREF="http://www.thegeekstuff.com/2010/05/tmout-exit-bash-shell-when-no-activity/" ADD_DATE="1367746583" ICON_URI="http://static.thegeekstuff.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://static.thegeekstuff.com/favicon.ico" style="margin-right: 0.5em;"/>TMOUT – Automatically Exit Unix Shell When there is No Activity</A> |
| 203 | 203 |
<DD>page's description: Question: I would like to terminate my Unix command line shell, when I don't execute any command for N number of seconds. i.e How to automatically log out if |
| 204 |
<DT><A HREF="http://www.gnu.org/software/bash/manual/bash.html#Aliases" ADD_DATE="1368084838" ICON_URI="http://www.gnu.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.gnu.org/favicon.ico" style="margin-right: 0.5em;"/>Bash Reference Manual > Aliases</A> |
|
| 205 |
<DD>page's description: Bash Reference Manual |
|
| 206 |
|
|
| 207 |
"Aliases are expanded when a command is read, not when it is executed" |
|
| 208 |
|
|
| 209 |
"Aliases are expanded when a function definition is read, not when the function is executed, because a function definition is itself a compound command" |
|
| 210 |
note that if statements are also "compound commands", which have aliases expanded when their definition is read (i.e. at the beginning of the if statement, for the entire if statement), not when they are executed, and any aliases for function names in them need to be unaliased *before* the if statement containing the function definition. this is necessary even if the if statement is *not* executed, because the expansion of such aliases will cause syntax errors in the parsing of the if statement itself. |
|
| 211 |
|
|
| 212 |
"If the last character of the alias value is a space or tab character, then the next command word following the alias is also checked for alias expansion." |
|
| 204 | 213 |
</DL><p> |
| 205 | 214 |
<DT><a name="gnome-keyring" href="#gnome-keyring"><H3 ADD_DATE="1349231436">gnome-keyring</H3></a> |
| 206 | 215 |
<DL><p> |
| ... | ... | |
| 260 | 269 |
</DL><p> |
| 261 | 270 |
<DT><a name="Mac" href="#Mac"><H3 ADD_DATE="1361008732">Mac</H3></a> |
| 262 | 271 |
<DL><p> |
| 272 |
<DT><a name="10.8 Mountain Lion" href="#10.8 Mountain Lion"><H3 ADD_DATE="1368126870">10.8 Mountain Lion</H3></a> |
|
| 273 |
<DL><p> |
|
| 274 |
<DT><A HREF="https://discussions.apple.com/docs/DOC-3761" ADD_DATE="1368126846" ICON_URI="https://ssl.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://ssl.apple.com/favicon.ico" style="margin-right: 0.5em;"/>Mountain Lion 10.8 Updating requirements: Apple Support Communities</A> |
|
| 275 |
<DD>"the installer takes 3 minutes before rebooting itself, and 33 minutes after rebooting to complete the installation on an iMac 11,2" |
|
| 276 |
<DT><A HREF="http://lifehacker.com/5928763/should-i-upgrade-to-mountain-lion" ADD_DATE="1368132025" ICON_URI="http://lifehacker.com/assets/images/logos/favicons/lifehacker.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://lifehacker.com/assets/images/logos/favicons/lifehacker.ico" style="margin-right: 0.5em;"/>Should I Upgrade to Mountain Lion?</A> |
|
| 277 |
<DD>page's description: Dear Lifehacker, |
|
| 278 |
Mountain Lion is out, and I'm seeing it has some pretty cool new features! Should I upgrade? |
|
| 279 |
<DT><A HREF="http://www.apple.com/osx/whats-new/features.html" ADD_DATE="1368132184" ICON_URI="http://www.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.apple.com/favicon.ico" style="margin-right: 0.5em;"/>Apple - OS X Mountain Lion - See everything the new OS X can do.</A> |
|
| 280 |
<DD>page's description: Play iOS gamers in Game Center. Share right from your apps. Send iMessages. And more. Over 200 more features, in fact. All part of OS X Mountain Lion. |
|
| 281 |
</DL><p> |
|
| 263 | 282 |
<DT><a name="MacFusion" href="#MacFusion"><H3 ADD_DATE="1367739060">MacFusion</H3></a> |
| 264 | 283 |
<DL><p> |
| 265 | 284 |
<DT><A HREF="http://code.google.com/p/macfuse/wiki/OPTIONS" ADD_DATE="1367738659" ICON_URI="http://www.gstatic.com/codesite/ph/images/phosting.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.gstatic.com/codesite/ph/images/phosting.ico" style="margin-right: 0.5em;"/>OPTIONS - macfuse - Commonly useful mount-time options available in MacFUSE - The Easiest and Fastest Way to Create File Systems for Mac OS X - Google Project Hosting</A> |
| ... | ... | |
| 268 | 287 |
<DT><A HREF="http://code.google.com/p/macfusion/issues/detail?id=257" ADD_DATE="1367739032" ICON_URI="http://www.gstatic.com/codesite/ph/images/phosting.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.gstatic.com/codesite/ph/images/phosting.ico" style="margin-right: 0.5em;"/>Issue 257 - macfusion - SSHFS | Finder | copy | Administrator password requested | fails | Finder Error code -43 - General GUI for Fuse Filesystems to be used with MacFUSE - Google Project Hosting</A> |
| 269 | 288 |
<DD>"-o defer_permissions" |
| 270 | 289 |
</DL><p> |
| 290 |
<DT><a name="recovery partition" href="#recovery partition"><H3 ADD_DATE="1368131131">recovery partition</H3></a> |
|
| 291 |
<DL><p> |
|
| 292 |
<DT><A HREF="http://apple.stackexchange.com/questions/19145/how-can-i-create-or-recreate-a-lion-recovery-partition" ADD_DATE="1368131142" ICON_URI="http://cdn.sstatic.net/apple/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/apple/img/favicon.ico" style="margin-right: 0.5em;"/>How can I create or recreate a Lion recovery partition? - Ask Different</A> |
|
| 293 |
<DT><A HREF="http://support.apple.com/kb/DL1464" ADD_DATE="1368131153" ICON_URI="http://support.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://support.apple.com/favicon.ico" style="margin-right: 0.5em;"/>Lion Recovery Update v1.0</A> |
|
| 294 |
</DL><p> |
|
| 271 | 295 |
<DT><a name="sleep" href="#sleep"><H3 ADD_DATE="1366920274">sleep</H3></a> |
| 272 | 296 |
<DL><p> |
| 273 | 297 |
<DT><a name="wake for network access" href="#wake for network access"><H3 ADD_DATE="1366920286">wake for network access</H3></a> |
| ... | ... | |
| 284 | 308 |
<DT><A HREF="http://www.tuaw.com/2011/08/22/why-hibernate-or-safe-sleep-mode-is-no-longer-necessary-in-os/" ADD_DATE="1366917543" ICON_URI="http://www.blogsmithmedia.com/www.tuaw.com/media/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.blogsmithmedia.com/www.tuaw.com/media/favicon.ico" style="margin-right: 0.5em;"/>Why hibernate or 'safe sleep' mode is no longer necessary in OS X Lion (Updated) | TUAW - The Unofficial Apple Weblog</A> |
| 285 | 309 |
<DD>page's description: Update: Several commenters expressed concern that disabling safe sleep could expose you to the possibility of drive corruption if you lose power or |
| 286 | 310 |
</DL><p> |
| 311 |
<DT><a name="Time Machine" href="#Time Machine"><H3 ADD_DATE="1368130723">Time Machine</H3></a> |
|
| 312 |
<DL><p> |
|
| 313 |
<DT><A HREF="https://discussions.apple.com/thread/3824441?start=0&tstart=0" ADD_DATE="1368130607" ICON_URI="https://ssl.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://ssl.apple.com/favicon.ico" style="margin-right: 0.5em;"/>Can I boot from an time machine backup...: Apple Support Communities</A> |
|
| 314 |
<DT><A HREF="http://www.macworld.com/article/1165784/how_to_restore_data_from_time_machine.html" ADD_DATE="1368130704" ICON_URI="http://www.macworld.com/www.mw/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.macworld.com/www.mw/favicon.ico" style="margin-right: 0.5em;"/>How to restore data from Time Machine in Mountain Lion | Macworld</A> |
|
| 315 |
<DD>page's description: If you use Time Machine regularly, you're ready for whatever technological mishaps life throws at you. Restoring data from Time Machine is just as easy as backing things up in the first place. |
|
| 316 |
|
|
| 317 |
"start up your Mac from the Mountain Lion recovery partition by pressing (and holding down) Command-R at startup. This launches Recovery Mode, a portion of your drive that Mountain Lion treats as a separate volume" |
|
| 318 |
<DT><A HREF="http://support.apple.com/kb/HT5096" ADD_DATE="1347325122" ICON_URI="http://support.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://support.apple.com/favicon.ico" style="margin-right: 0.5em;"/>Time Machine: How to transfer backups from the current backup drive to a new backup drive</A> |
|
| 319 |
<DD>page's description: <p>If you want to switch to a different TIme Machine backup drive, use this article to learn how to transfer your existing Time Machine backups to the new backup drive, and then use it for regular Time Machine backups.</p> |
|
| 320 |
</DL><p> |
|
| 287 | 321 |
<DT><A HREF="http://www.danbishop.org/2011/09/10/how-to-mount-sftp-ssh-shares-in-os-x-lion/" ADD_DATE="1363045253" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Dan Bishop » How to mount SFTP/SSH shares in OS X NOW UPDATED to include OS X 10.8</A> |
| 322 |
<DT><A HREF="http://www.macworld.com/article/1138403/dockbounce.html" ADD_DATE="1367786323" ICON_URI="http://www.macworld.com/www.mw/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.macworld.com/www.mw/favicon.ico" style="margin-right: 0.5em;"/>Disable the Dock’s ‘bounce to alert’ behavior | Macworld</A> |
|
| 323 |
<DD>page's description: Learn how to prevent icons from bouncing in the Dock to get your attention |
|
| 288 | 324 |
<DT><A HREF="https://discussions.apple.com/thread/3324489?start=0&tstart=0" ADD_DATE="1363328233" ICON_URI="https://ssl.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://ssl.apple.com/favicon.ico" style="margin-right: 0.5em;"/>firewall blocks ssh since Sept 12 update: Apple Support Communities</A> |
| 289 | 325 |
<DT><A HREF="http://forums.macrumors.com/showthread.php?t=1281546" ADD_DATE="1367490962" ICON_URI="http://forums.macrumors.com/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://forums.macrumors.com/favicon.ico" style="margin-right: 0.5em;"/>Force every folder to be arranged by kind and sorted by name? - MacRumors Forums</A> |
| 290 | 326 |
<DD>page's description: Force every folder to be arranged by kind and sorted by name? Mac OS X 10.7 Lion |
| 327 |
<DT><A HREF="http://www.ehow.com/how_8529147_stop-icons-bouncing.html" ADD_DATE="1367786460" ICON_URI="http://test7-v5-static.ehowcdn.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://test7-v5-static.ehowcdn.com/favicon.ico" style="margin-right: 0.5em;"/>How to Stop Icons From Bouncing | eHow.com</A> |
|
| 328 |
<DD>page's description: How to Stop Icons From Bouncing. The dock is a distinctive feature of the Mac operating system. It keeps icons of commonly used and currently open programs visible at the bottom of your screen for quick access. When programs first open, or need to alert the user of some new update, the icons in the dock bounce. Many people find this helpful when... |
|
| 291 | 329 |
<DT><A HREF="http://inner.geek.nz/archives/2011/08/10/howto-fix-file-sorting-in-finders-column-view-on-mac-os-x-lion/" ADD_DATE="1367490710" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>HOWTO: Fix file sorting in Finder’s column view on Mac OS X Lion « inner.geek</A> |
| 292 | 330 |
<DT><A HREF="http://hints.macworld.com/article.php?story=20040203002020660" ADD_DATE="1367385714" ICON_URI="http://hints.macworld.com/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://hints.macworld.com/favicon.ico" style="margin-right: 0.5em;"/>Lock the keychain when the screensaver activates - Mac OS X Hints</A> |
| 293 | 331 |
<DT><A HREF="http://support.apple.com/kb/HT5343" ADD_DATE="1363155945" ICON_URI="http://support.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://support.apple.com/favicon.ico" style="margin-right: 0.5em;"/>OS X: How to reset the DNS cache</A> |
| 294 | 332 |
<DD>page's description: <p>Learn how to reset (flush) the DNS cache. </p> |
| 295 | 333 |
<DT><A HREF="http://superuser.com/questions/279891/list-all-members-of-a-group-mac-os-x" ADD_DATE="1361008714" ICON_URI="http://cdn.sstatic.net/superuser/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/superuser/img/favicon.ico" style="margin-right: 0.5em;"/>osx - List all members of a group (Mac OS X) - Super User</A> |
| 296 | 334 |
<DT><A HREF="http://hints.macworld.com/article.php?story=2005070300463515" ADD_DATE="1362840189" ICON_URI="http://hints.macworld.com/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://hints.macworld.com/favicon.ico" style="margin-right: 0.5em;"/>Prevent .DS_Store file creation on network volumes - Mac OS X Hints</A> |
| 297 |
<DT><A HREF="http://support.apple.com/kb/HT5096" ADD_DATE="1347325122" ICON_URI="http://support.apple.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://support.apple.com/favicon.ico" style="margin-right: 0.5em;"/>Time Machine: How to transfer backups from the current backup drive to a new backup drive</A> |
|
| 298 |
<DD>page's description: <p>If you want to switch to a different TIme Machine backup drive, use this article to learn how to transfer your existing Time Machine backups to the new backup drive, and then use it for regular Time Machine backups.</p> |
|
| 299 |
<DT><A HREF="http://www.macworld.com/article/1138403/dockbounce.html" ADD_DATE="1367786323" ICON_URI="http://www.macworld.com/www.mw/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.macworld.com/www.mw/favicon.ico" style="margin-right: 0.5em;"/>Disable the Dock’s ‘bounce to alert’ behavior | Macworld</A> |
|
| 300 |
<DD>page's description: Learn how to prevent icons from bouncing in the Dock to get your attention |
|
| 301 |
<DT><A HREF="http://www.ehow.com/how_8529147_stop-icons-bouncing.html" ADD_DATE="1367786460" ICON_URI="http://test7-v5-static.ehowcdn.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://test7-v5-static.ehowcdn.com/favicon.ico" style="margin-right: 0.5em;"/>How to Stop Icons From Bouncing | eHow.com</A> |
|
| 302 |
<DD>page's description: How to Stop Icons From Bouncing. The dock is a distinctive feature of the Mac operating system. It keeps icons of commonly used and currently open programs visible at the bottom of your screen for quick access. When programs first open, or need to alert the user of some new update, the icons in the dock bounce. Many people find this helpful when... |
|
| 303 | 335 |
</DL><p> |
| 304 | 336 |
<DT><a name="svn" href="#svn"><H3 ADD_DATE="1367370827">svn</H3></a> |
| 305 | 337 |
<DL><p> |
| ... | ... | |
| 552 | 584 |
<DT><A HREF="http://forums.mysql.com/read.php?125,127701,127719#msg-127719" ADD_DATE="1366898787" ICON_URI="http://forums.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://forums.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: Re: Dynamic SQl in Triggers/Procdures</A> |
| 553 | 585 |
<DD>"Stored procedures called from triggers operate under the same restrictions as triggers, i.e., no dynamic SQL is allowed." |
| 554 | 586 |
</DL><p> |
| 587 |
<DT><a name="enum" href="#enum"><H3 ADD_DATE="1367823275">enum</H3></a> |
|
| 588 |
<DL><p> |
|
| 589 |
<DT><A HREF="http://komlenic.com/244/8-reasons-why-mysqls-enum-data-type-is-evil/" ADD_DATE="1367823304" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>8 Reasons Why MySQL's ENUM Data Type Is Evil - Chris Komlenic</A> |
|
| 590 |
<DD>page's description: The pros and (mostly) cons of MySQL's ENUM data-type (as compared to reference tables), as well as when it is okay to use and how to use it if you must. |
|
| 591 |
|
|
| 592 |
"With an ENUM we're actually storing pieces of data in a place that was only intended to hold crucial information about the model" |
|
| 593 |
|
|
| 594 |
"in large systems the effect of normalization can already tax the limits of human comprehension and complicate queries" |
|
| 595 |
|
|
| 596 |
"Programmers waste enormous amounts of time thinking about, or worrying about, the speed of noncritical parts of their programs, and these attempts at efficiency actually have a strong negative impact when debugging and maintenance are considered." [Donald Knuth] |
|
| 597 |
<DT><A HREF="http://www.kawoolutions.com/SQL_Database_Design/8._User-Defined_Types/8.3_Enumerated_Types" ADD_DATE="1367824491" ICON_URI="http://www.kawoolutions.com/images/favicon.gif" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.kawoolutions.com/images/favicon.gif" style="margin-right: 0.5em;"/>Kawoolutions - SQL Database Design - 8. User-Defined Types - 8.3 Enumerated Types</A> |
|
| 598 |
<DD>page's description: Kawoolutions,,SQL Database Design,8. User-Defined Types,8.3 Enumerated Types |
|
| 599 |
|
|
| 600 |
"some people claim, that MySQL ENUMs are much faster than separate tables, especially on large databases. Furthermore, enums can give you some savings in database size, depending on the implementation. For example, a MySQL ENUM occupies only one byte for up to 255 values and two bytes for up to 65535 values." |
|
| 601 |
</DL><p> |
|
| 555 | 602 |
<DT><a name="MySQL Workbench" href="#MySQL Workbench"><H3 ADD_DATE="1366740023">MySQL Workbench</H3></a> |
| 556 | 603 |
<DL><p> |
| 557 | 604 |
<DT><a name="exporting indexes separately" href="#exporting indexes separately"><H3 ADD_DATE="1367759236">exporting indexes separately</H3></a> |
| ... | ... | |
| 586 | 633 |
<DT><A HREF="http://stackoverflow.com/questions/989643/how-to-use-the-cast-function-correctly-in-a-mysql-select-statement" ADD_DATE="1366752124" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>casting - How to use the CAST function correctly in a MySql SELECT statement? - Stack Overflow</A> |
| 587 | 634 |
<DD>"VARCHAR isn't a valid type for the CAST function, but CHAR is." |
| 588 | 635 |
<DT><A HREF="http://skyontech.com/blog/create-MySQL-view-in-phpMyAdmin" ADD_DATE="1364874584" ICON_URI="http://skyontech.com/blog/misc/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://skyontech.com/blog/misc/favicon.ico" style="margin-right: 0.5em;"/>Creating a MySQL View directly in phpMyAdmin | Sky on Tech</A> |
| 636 |
<DT><A HREF="http://www.devcha.com/2008/01/extend-phpmyadmin-session-timeout-value.html" ADD_DATE="1331080013" ICON_URI="http://www.devcha.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.devcha.com/favicon.ico" style="margin-right: 0.5em;"/>Extend phpMyAdmin Session Timeout Value (Expired Session)</A> |
|
| 589 | 637 |
<DT><A HREF="http://www.bluebox.net/about/blog/2009/07/mysql_encoding/" ADD_DATE="1366749540" ICON_URI="http://www.bluebox.net/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.bluebox.net/favicon.ico" style="margin-right: 0.5em;"/>Getting out of MySQL Character Set Hell < Blue Box Blog</A> |
| 590 | 638 |
<DT><A HREF="http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html" ADD_DATE="1366764865" ICON_URI="http://s0.cyberciti.org/static/legacy/i/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://s0.cyberciti.org/static/legacy/i/favicon.ico" style="margin-right: 0.5em;"/>How Do I Enable Remote Access To MySQL Database Server?</A> |
| 591 | 639 |
<DD>page's description: MySQL Remote Access - A step-by-step guide to enable remote access to a MySQL database server under Linux, UNIX and BSD operating systems. |
| ... | ... | |
| 609 | 657 |
<DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/innodb-create-index-overview.html" ADD_DATE="1366895888" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 14.4.2.1 Overview of Fast Index Creation</A> |
| 610 | 658 |
<DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html" ADD_DATE="1366893751" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.1 mysql Options</A> |
| 611 | 659 |
<DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/mysql-commands.html" ADD_DATE="1364873441" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.2 mysql Commands</A> |
| 660 |
<DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html#sqlmode_postgresql" ADD_DATE="1368048993" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 5.1.7 Server SQL Modes > POSTGRESQL</A> |
|
| 661 |
<DD>"Equivalent to PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_FIELD_OPTIONS." |
|
| 612 | 662 |
<DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/index-btree-hash.html" ADD_DATE="1366865295" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 8.3.8 Comparison of B-Tree and Hash Indexes</A> |
| 613 | 663 |
<DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/identifiers.html" ADD_DATE="1366748434" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: 9.2 Schema Object Names</A> |
| 614 | 664 |
<DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/glossary.html#glos_clustered_index" ADD_DATE="1366896044" ICON_URI="http://dev.mysql.com/common/themes/sakila/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://dev.mysql.com/common/themes/sakila/favicon.ico" style="margin-right: 0.5em;"/>MySQL :: MySQL 5.5 Reference Manual :: MySQL Glossary :: clustered index</A> |
| ... | ... | |
| 625 | 675 |
<DT><A HREF="http://mysql-python.sourceforge.net/MySQLdb.html" ADD_DATE="1323978074" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>MySQLdb</A> |
| 626 | 676 |
<DT><A HREF="http://stackoverflow.com/questions/553369/need-mysql-4-to-ignore-alter-table-errors" ADD_DATE="1366897937" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>Need MySQL 4 to ignore ALTER TABLE errors - Stack Overflow</A> |
| 627 | 677 |
<DT><A HREF="http://drupal.org/node/306156" ADD_DATE="1364875790" ICON_URI="http://drupal.org/misc/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://drupal.org/misc/favicon.ico" style="margin-right: 0.5em;"/>What's the opposite of mysqldump to load data back into a database? | drupal.org</A> |
| 628 |
<DT><A HREF="http://www.devcha.com/2008/01/extend-phpmyadmin-session-timeout-value.html" ADD_DATE="1331080013" ICON_URI="http://www.devcha.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.devcha.com/favicon.ico" style="margin-right: 0.5em;"/>Extend phpMyAdmin Session Timeout Value (Expired Session)</A> |
|
| 629 |
<DT><a name="enum" href="#enum"><H3 ADD_DATE="1367823275">enum</H3></a> |
|
| 630 |
<DL><p> |
|
| 631 |
<DT><A HREF="http://komlenic.com/244/8-reasons-why-mysqls-enum-data-type-is-evil/" ADD_DATE="1367823304" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>8 Reasons Why MySQL's ENUM Data Type Is Evil - Chris Komlenic</A> |
|
| 632 |
<DD>page's description: The pros and (mostly) cons of MySQL's ENUM data-type (as compared to reference tables), as well as when it is okay to use and how to use it if you must. |
|
| 633 |
|
|
| 634 |
"With an ENUM we're actually storing pieces of data in a place that was only intended to hold crucial information about the model" |
|
| 635 |
|
|
| 636 |
"in large systems the effect of normalization can already tax the limits of human comprehension and complicate queries" |
|
| 637 |
|
|
| 638 |
"Programmers waste enormous amounts of time thinking about, or worrying about, the speed of noncritical parts of their programs, and these attempts at efficiency actually have a strong negative impact when debugging and maintenance are considered." [Donald Knuth] |
|
| 639 |
<DT><A HREF="http://www.kawoolutions.com/SQL_Database_Design/8._User-Defined_Types/8.3_Enumerated_Types" ADD_DATE="1367824491" ICON_URI="http://www.kawoolutions.com/images/favicon.gif" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.kawoolutions.com/images/favicon.gif" style="margin-right: 0.5em;"/>Kawoolutions - SQL Database Design - 8. User-Defined Types - 8.3 Enumerated Types</A> |
|
| 640 |
<DD>page's description: Kawoolutions,,SQL Database Design,8. User-Defined Types,8.3 Enumerated Types |
|
| 641 |
|
|
| 642 |
"some people claim, that MySQL ENUMs are much faster than separate tables, especially on large databases. Furthermore, enums can give you some savings in database size, depending on the implementation. For example, a MySQL ENUM occupies only one byte for up to 255 values and two bytes for up to 65535 values." |
|
| 643 |
</DL><p> |
|
| 644 | 678 |
</DL><p> |
| 645 | 679 |
<DT><a name="PostgreSQL" href="#PostgreSQL"><H3 ADD_DATE="1333386475">PostgreSQL</H3></a> |
| 646 | 680 |
<DL><p> |
Also available in: Unified diff
web/links/index.htm: updated to Firefox bookmarks. added Mac upgrade and recovery-related bookmarks.