Project

General

Profile

« Previous | Next » 

Revision 9230

web/links/index.htm: updated to Firefox bookmarks. added bash and MySQL-related bookmarks, including MySQL doc subfolder.

View differences:

index.htm
188 188
            <DL><p>
189 189
                <DT><a name="bash" href="#bash"><H3 ADD_DATE="1364942440">bash</H3></a>
190 190
                <DL><p>
191
                    <DT><A HREF="http://stackoverflow.com/questions/1835943/how-to-determine-function-name-from-inside-a-function" ADD_DATE="1364932631" 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;"/>bash - How to determine function name from inside a function - Stack Overflow</A>
192
                    <DT><A HREF="http://askubuntu.com/questions/98782/how-to-run-an-alias-in-a-shell-script" ADD_DATE="1364895890" ICON_URI="http://cdn.sstatic.net/askubuntu/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/askubuntu/img/favicon.ico" style="margin-right: 0.5em;"/>bash - How to run an alias in a shell script? - Ask Ubuntu</A>
193
                    <DT><A HREF="http://www.gnu.org/s/bash/manual/bash.html" ADD_DATE="1317673821" ICON_URI="http://www.gnu.org/favicon.ico" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="http://www.gnu.org/favicon.ico" style="margin-right: 0.5em;"/>Bash Reference Manual</A>
191
                    <DT><a name="doc" href="#doc"><H3 ADD_DATE="1368219023">doc</H3></a>
192
                    <DL><p>
193
                        <DT><A HREF="http://www.gnu.org/software/bash/manual/bash.html" ADD_DATE="1317673821" ICON_URI="http://www.gnu.org/favicon.ico"><img width="16" height="16" src="http://www.gnu.org/favicon.ico" style="margin-right: 0.5em;"/>Bash Reference Manual</A>
194 194
<DD>page's description: Bash Reference Manual
195
                    <DT><A HREF="http://blog.wains.be/2008/05/24/detaching-processes-from-the-current-bash-session/" ADD_DATE="1331603478" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Detaching processes from the current bash session | Sébastien Wains</A>
196
                    <DT><A HREF="http://stackoverflow.com/questions/13360091/how-to-reverse-array-in-bash-onliner-for-loop" ADD_DATE="1366867552" 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;"/>How to reverse array in bash onliner FOR loop? - Stack Overflow</A>
197
                    <DT><A HREF="http://stackoverflow.com/questions/1203583/how-do-i-rename-a-bash-function" ADD_DATE="1366892821" 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;"/>How do I rename a bash function? - Stack Overflow</A>
198
                    <DT><A HREF="http://mivok.net/2009/09/20/bashfunctionoverrist.html" ADD_DATE="1366893028" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Mivok.net - Bash function renaming and overriding</A>
199
                    <DT><A HREF="http://stackoverflow.com/questions/7518584/is-there-any-mechanism-in-shell-script-alike-include-guard-in-c" ADD_DATE="1366930192" 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;"/>Is there any mechanism in Shell script alike &quot;include guard&quot; in C++? - Stack Overflow</A>
200
                    <DT><A HREF="http://www.linuxjournal.com/content/bash-associative-arrays" ADD_DATE="1366930804" ICON_URI="http://www.linuxjournal.com/files/linuxjournal.com/ufiles/linuxjournal_favicon.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.linuxjournal.com/files/linuxjournal.com/ufiles/linuxjournal_favicon.png" style="margin-right: 0.5em;"/>Bash Associative Arrays | Linux Journal</A>
201
<DD>page's description: The bash man page has long had the following bug listed: &quot;It&#39;s too big and too slow&quot; (at the very bottom of the man page). If you agree with that, then you probably won&#39;t want to read about the &quot;new&quot; associative arrays that were added in version 4.0 of bash.
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
<DD>page's description: Question: I would like to terminate my Unix command line shell, when I don&#39;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 &gt; Aliases</A>
195
                        <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 &gt; Aliases</A>
205 196
<DD>page's description: Bash Reference Manual
206 197

  
207 198
&quot;Aliases are expanded when a command is read, not when it is executed&quot;
......
210 201
note that if statements are also &quot;compound commands&quot;, 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 202

  
212 203
&quot;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.&quot;
204
                        <DT><A HREF="http://www.gnu.org/software/bash/manual/bash.html#Filename-Expansion" ADD_DATE="1368209175" 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 &gt; Filename Expansion</A>
205
<DD>page's description: Bash Reference Manual
206

  
207
&quot;If GLOBIGNORE is set, each matching filename that also matches one of the patterns in GLOBIGNORE is removed from the list of matches. The filenames . and .. are always ignored when GLOBIGNORE is set and not null.&quot;
208
                        <DT><A HREF="http://www.gnu.org/software/bash/manual/bash.html#The-Set-Builtin" ADD_DATE="1368185741" 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 &gt; The Set Builtin</A>
209
<DD>page's description: Bash Reference Manual
210

  
211
-e:
212
&quot;The shell does not exit if the command that fails is part of the command list immediately following a while or until keyword, part of the test in an if statement, part of any command executed in a &amp;&amp; or || list except the command following the final &amp;&amp; or ||, any command in a pipeline but the last, or if the command’s return status is being inverted with !. A trap on ERR, if set, is executed before the shell exits.&quot;
213
                        <DT><A HREF="http://www.gnu.org/software/bash/manual/bash.html#GNU-Parallel" ADD_DATE="1368220408" 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 &gt; GNU Parallel</A>
214
<DD>page's description: Bash Reference Manual
215
                    </DL><p>
216
                    <DT><A HREF="http://stackoverflow.com/questions/1835943/how-to-determine-function-name-from-inside-a-function" ADD_DATE="1364932631" 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;"/>bash - How to determine function name from inside a function - Stack Overflow</A>
217
                    <DT><A HREF="http://askubuntu.com/questions/98782/how-to-run-an-alias-in-a-shell-script" ADD_DATE="1364895890" ICON_URI="http://cdn.sstatic.net/askubuntu/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/askubuntu/img/favicon.ico" style="margin-right: 0.5em;"/>bash - How to run an alias in a shell script? - Ask Ubuntu</A>
218
                    <DT><A HREF="http://unix.stackexchange.com/questions/39623/trap-err-and-echoing-the-error-line" ADD_DATE="1368186553" ICON_URI="http://cdn.sstatic.net/unix/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/unix/img/favicon.ico" style="margin-right: 0.5em;"/>bash - Trap, ERR, and echoing the error line - Unix &amp; Linux Stack Exchange</A>
219
                    <DT><A HREF="http://www.linuxjournal.com/content/bash-associative-arrays" ADD_DATE="1366930804" ICON_URI="http://www.linuxjournal.com/files/linuxjournal.com/ufiles/linuxjournal_favicon.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.linuxjournal.com/files/linuxjournal.com/ufiles/linuxjournal_favicon.png" style="margin-right: 0.5em;"/>Bash Associative Arrays | Linux Journal</A>
220
<DD>page's description: The bash man page has long had the following bug listed: &quot;It&#39;s too big and too slow&quot; (at the very bottom of the man page). If you agree with that, then you probably won&#39;t want to read about the &quot;new&quot; associative arrays that were added in version 4.0 of bash.
221
                    <DT><A HREF="http://blog.wains.be/2008/05/24/detaching-processes-from-the-current-bash-session/" ADD_DATE="1331603478" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Detaching processes from the current bash session | Sébastien Wains</A>
222
                    <DT><A HREF="http://stackoverflow.com/questions/1203583/how-do-i-rename-a-bash-function" ADD_DATE="1366892821" 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;"/>How do I rename a bash function? - Stack Overflow</A>
223
                    <DT><A HREF="http://stackoverflow.com/questions/13360091/how-to-reverse-array-in-bash-onliner-for-loop" ADD_DATE="1366867552" 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;"/>How to reverse array in bash onliner FOR loop? - Stack Overflow</A>
224
                    <DT><A HREF="http://stackoverflow.com/questions/7518584/is-there-any-mechanism-in-shell-script-alike-include-guard-in-c" ADD_DATE="1366930192" 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;"/>Is there any mechanism in Shell script alike &quot;include guard&quot; in C++? - Stack Overflow</A>
225
                    <DT><A HREF="http://superuser.com/questions/86340/linux-command-to-repeat-a-string-n-times" ADD_DATE="1368214857" 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;"/>Linux command to repeat a string n times - Super User</A>
226
                    <DT><A HREF="http://mivok.net/2009/09/20/bashfunctionoverrist.html" ADD_DATE="1366893028" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Mivok.net - Bash function renaming and overriding</A>
227
                    <DT><A HREF="http://stackoverflow.com/questions/369758/how-to-trim-whitespace-from-bash-variable" ADD_DATE="1368219012" 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;"/>string - How to trim whitespace from bash variable? - Stack Overflow</A>
228
<DD>-
229
the following *doesn&#39;t* work:
230
&quot;read -r var &lt;&lt; eof
231
$var
232
eof&quot;
233
                    <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>
234
<DD>page's description: Question: I would like to terminate my Unix command line shell, when I don&#39;t execute any command for N number of seconds. i.e How to automatically log out if
213 235
                </DL><p>
214 236
                <DT><a name="gnome-keyring" href="#gnome-keyring"><H3 ADD_DATE="1349231436">gnome-keyring</H3></a>
215 237
                <DL><p>
......
577 599
                    </DL><p>
578 600
                    <DT><a name="MySQL" href="#MySQL"><H3 ADD_DATE="1346354953">MySQL</H3></a>
579 601
                    <DL><p>
602
                        <DT><a name="doc" href="#doc"><H3 ADD_DATE="1368223591">doc</H3></a>
603
                        <DL><p>
604
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.1/en/load-data.html" ADD_DATE="1364880853" 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.1 Reference Manual :: 13.2.6 LOAD DATA INFILE Syntax</A>
605
<DD>&quot;file_name cannot be an existing file&quot;
606

  
607
&quot;The file is created on the server host, so you must have the FILE privilege to use this syntax&quot;
608

  
609
&quot;if the MySQL client software is installed on the remote machine, you can instead use a client command such as mysql -e &quot;SELECT ...&quot; &gt; file_name to generate the file on the client host&quot;
610
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.1/en/select-into.html" ADD_DATE="1364880728" 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.1 Reference Manual :: 13.2.8.1 SELECT ... INTO Syntax</A>
611
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/charset-convert.html" ADD_DATE="1366752059" 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 :: 10.1.9.2 CONVERT() and CAST()</A>
612
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/date-and-time-types.html" ADD_DATE="1345023577" 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 :: 11.3 Date and Time Types</A>
613
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/binary-varbinary.html" ADD_DATE="1366749860" 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 :: 11.4.2 The BINARY and VARBINARY Types</A>
614
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/create-procedure.html" ADD_DATE="1366898392" 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 :: 13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax</A>
615
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/sql-syntax-prepared-statements.html" ADD_DATE="1366898699" 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 :: 13.5 SQL Syntax for Prepared Statements</A>
616
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/resignal.html" ADD_DATE="1364942562" 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 :: 13.6.7.3 RESIGNAL Syntax</A>
617
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/signal.html" ADD_DATE="1364942396" 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 :: 13.6.7.4 SIGNAL Syntax</A>
618
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/grant.html" ADD_DATE="1366768685" 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 :: 13.7.1.3 GRANT Syntax</A>
619
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/show-create-procedure.html" ADD_DATE="1366898978" 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 :: 13.7.5.11 SHOW CREATE PROCEDURE Syntax</A>
620
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html" ADD_DATE="1366744812" 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.3.15 Limits on InnoDB Tables</A>
621
                            <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>
622
                            <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>
623
                            <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>
624
                            <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 &gt; POSTGRESQL</A>
625
<DD>&quot;Equivalent to PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_FIELD_OPTIONS.&quot;
626
                            <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>
627
                            <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>
628
                            <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>
629
<DD>&quot;Because modifying the columns of the clustered index is an expensive operation, choose primary columns that are rarely or never updated.&quot;
630
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.6/en/alter-database.html" ADD_DATE="1346340363" 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.6 Reference Manual :: 13.1.1 ALTER DATABASE Syntax</A>
631
                            <DT><A HREF="http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html" ADD_DATE="1346821922" 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.6 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program</A>
632
                        </DL><p>
580 633
                        <DT><a name="dynamic SQL" href="#dynamic SQL"><H3 ADD_DATE="1366898821">dynamic SQL</H3></a>
581 634
                        <DL><p>
582 635
                            <DT><A HREF="http://stackoverflow.com/questions/190776/how-to-have-dynamic-sql-in-mysql-stored-procedure" ADD_DATE="1366898705" 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;"/>How To have Dynamic SQL in MySQL Stored Procedure - Stack Overflow</A>
......
642 695
                        <DT><A HREF="http://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes#comment-18031137" ADD_DATE="1366748108" 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;"/>mysql - #1071 - Specified key was too long; max key length is 767 bytes - Stack Overflow</A>
643 696
                        <DT><A HREF="http://blog.tsheets.com/2008/tips-tricks/extract-a-single-table-from-a-mysqldump-file.html" ADD_DATE="1361398908" ICON_URI="http://blog.tsheets.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://blog.tsheets.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL – Extract or Restore a Single Table From a Huge mysqldump File</A>
644 697
<DD>page's description: A while back, I wrote an article that explained some awk magic for extracting the restore information for a single table from a mysqldump file.  Since then I&#39;ve created a Perl script that accomplishes the same thing, but is a little more flexible.
645
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.1/en/load-data.html" ADD_DATE="1364880853" 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.1 Reference Manual :: 13.2.6 LOAD DATA INFILE Syntax</A>
646
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.1/en/select-into.html" ADD_DATE="1364880728" 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.1 Reference Manual :: 13.2.8.1 SELECT ... INTO Syntax</A>
647
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/charset-convert.html" ADD_DATE="1366752059" 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 :: 10.1.9.2 CONVERT() and CAST()</A>
648
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/date-and-time-types.html" ADD_DATE="1345023577" 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 :: 11.3 Date and Time Types</A>
649
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/binary-varbinary.html" ADD_DATE="1366749860" 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 :: 11.4.2 The BINARY and VARBINARY Types</A>
650
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/create-procedure.html" ADD_DATE="1366898392" 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 :: 13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax</A>
651
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/sql-syntax-prepared-statements.html" ADD_DATE="1366898699" 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 :: 13.5 SQL Syntax for Prepared Statements</A>
652
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/resignal.html" ADD_DATE="1364942562" 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 :: 13.6.7.3 RESIGNAL Syntax</A>
653
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/signal.html" ADD_DATE="1364942396" 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 :: 13.6.7.4 SIGNAL Syntax</A>
654
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/grant.html" ADD_DATE="1366768685" 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 :: 13.7.1.3 GRANT Syntax</A>
655
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/show-create-procedure.html" ADD_DATE="1366898978" 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 :: 13.7.5.11 SHOW CREATE PROCEDURE Syntax</A>
656
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.5/en/innodb-restrictions.html" ADD_DATE="1366744812" 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.3.15 Limits on InnoDB Tables</A>
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>
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>
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 &gt; POSTGRESQL</A>
661
<DD>&quot;Equivalent to PIPES_AS_CONCAT, ANSI_QUOTES, IGNORE_SPACE, NO_KEY_OPTIONS, NO_TABLE_OPTIONS, NO_FIELD_OPTIONS.&quot;
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>
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>
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>
665
<DD>&quot;Because modifying the columns of the clustered index is an expensive operation, choose primary columns that are rarely or never updated.&quot;
666
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.6/en/alter-database.html" ADD_DATE="1346340363" 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.6 Reference Manual :: 13.1.1 ALTER DATABASE Syntax</A>
667
                        <DT><A HREF="http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html" ADD_DATE="1346821922" 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.6 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program</A>
668 698
                        <DT><A HREF="http://forums.mysql.com/read.php?28,243757,245694" ADD_DATE="1361398973" 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: How to Restore a particular table from the mysqldump of a whole database?</A>
669 699
                        <DT><A HREF="http://forums.mysql.com/read.php?22,153445,153938" ADD_DATE="1366747353" 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: latin1_bin vs latin1_general_cs</A>
670 700
                        <DT><A HREF="http://forums.mysql.com/read.php?103,187048,188748" ADD_DATE="1366744312" 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: utf8_unicode_ci vs utf8_general_ci</A>
......
675 705
                        <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>
676 706
                        <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>
677 707
                        <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&#39;s the opposite of mysqldump to load data back into a database? | drupal.org</A>
708
                        <DT><A HREF="http://bugs.mysql.com/bug.php?id=44732" ADD_DATE="1368250469" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #44732: mysql client should printing warnings on stderr in batch mode</A>
678 709
                    </DL><p>
679 710
                    <DT><a name="PostgreSQL" href="#PostgreSQL"><H3 ADD_DATE="1333386475">PostgreSQL</H3></a>
680 711
                    <DL><p>
......
724 755

  
725 756
&quot;special backslash sequences are recognized by COPY FROM&quot; (only in text mode)
726 757

  
758
&quot;The following special backslash sequences are recognized by COPY FROM:
759
[...]
760
\digits 	Backslash followed by one to three octal digits specifies the character with that numeric code
761
&quot;
762
this includes \0
763

  
727 764
CSV format:
728 765

  
729 766
&quot;any occurrence within the value of a QUOTE character or the ESCAPE character is preceded by the escape character&quot;
......
983 1020

  
984 1021
Suppose I have given a read-only key to 10 other people, and now I want it stored in a different place on my machine. Is there any way of doing that without having them all delete the old and add a new key?
985 1022
            </DL><p>
1023
            <DT><a name="software concepts" href="#software concepts"><H3 ADD_DATE="1368357824">software concepts</H3></a>
1024
            <DL><p>
1025
                <DT><A HREF="http://en.wikipedia.org/wiki/Scope_%28programming%29#Dynamic_scoping" ADD_DATE="1368357608" ICON_URI="http://bits.wikimedia.org/favicon/wikipedia.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bits.wikimedia.org/favicon/wikipedia.ico" style="margin-right: 0.5em;"/>Dynamic scoping &lt; Scope (computer science) - Wikipedia, the free encyclopedia</A>
1026
<DD>&quot;Dynamic scoping also voids all the benefits of referential transparency&quot;
1027

  
1028
&quot;Dynamic scoping provides an excellent abstraction for thread local storage, but if it is used that way it cannot be based on saving and restoring a global variable&quot;
1029
                <DT><A HREF="http://en.wikipedia.org/wiki/Hamming_distance" ADD_DATE="1350020460" ICON_URI="http://en.wikipedia.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://en.wikipedia.org/favicon.ico" style="margin-right: 0.5em;"/>Hamming distance - Wikipedia, the free encyclopedia</A>
1030
            </DL><p>
986 1031
            <DT><A HREF="https://bugs.launchpad.net/ubuntu/+source/inkscape/+bug/788256" ADD_DATE="1365526570" ICON_URI="https://bugs.launchpad.net/@@/launchpad.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://bugs.launchpad.net/@@/launchpad.png" style="margin-right: 0.5em;"/>Bug #788256 “inkscape cannot dock toolbars” : Bugs : “inkscape” package : Ubuntu</A>
987 1032
<DD>page's description: Binary package hint: inkscape
988 1033

  
......
999 1044
<DD>page's description: The Acrolaw Blog is a resource for lawyers, law firms, paralegals, legal IT pros and anyone interested in the use of Acrobat in the legal community.   Rick Borstein– the author of the blog– is the Business Development Manager for Acrobat in the Legal Market for Adobe Systems.
1000 1045
            <DT><A HREF="http://www.wordreference.com/" ADD_DATE="1343685419" ICON_URI="http://www.wordreference.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.wordreference.com/favicon.ico" style="margin-right: 0.5em;"/>English to French, Italian, German &amp; Spanish Dictionary - WordReference.com</A>
1001 1046
<DD>page's description: Free online Oxford dictionaries - Spanish, French, Italian, German and more. Conjugations, audio pronunciations and forums for your questions.
1002
            <DT><A HREF="http://en.wikipedia.org/wiki/Hamming_distance" ADD_DATE="1350020460" ICON_URI="http://en.wikipedia.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://en.wikipedia.org/favicon.ico" style="margin-right: 0.5em;"/>Hamming distance - Wikipedia, the free encyclopedia</A>
1003 1047
            <DT><A HREF="http://www.makeuseof.com/tag/create-image-map-gimp/" ADD_DATE="1365521872" ICON_URI="http://main.makeuseoflimited.netdna-cdn.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://main.makeuseoflimited.netdna-cdn.com/favicon.ico" style="margin-right: 0.5em;"/>How To Create An Image Map Using GIMP</A>
1004 1048
<DD>page's description: Have you ever wanted to add an image map to your web site? An image map is a graphic that contains hotspots that link to URLs. They are used as a means t
1005 1049
            <DT><A HREF="http://stackoverflow.com/questions/50524/what-is-a-regex-independent-capturing-group" ADD_DATE="1357210205" 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;"/>java - What is a regex &quot;independent capturing group&quot;? - Stack Overflow</A>

Also available in: Unified diff