diff options
| -rw-r--r-- | Docs/manual.texi | 17 |
1 files changed, 9 insertions, 8 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi index db72cb92584..829c1becacb 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -33099,7 +33099,7 @@ simple rename should get your data back. @cindex changing, column order @cindex tables, changing column order @node Change column order, , ALTER TABLE problems, Problems -@Section How To Change the Order of Columns in a Table +@section How To Change the Order of Columns in a Table The whole point of SQL is to abstract the application from the data storage format. You should always specify the order in which you wish to @@ -33118,9 +33118,10 @@ SELECT col_name1, col_name3, col_name2 FROM tbl_name; will return columns in the order @code{col_name1}, @code{col_name3}, @code{col_name2}. You should @strong{NEVER}, in an application, use @code{SELECT *} and -retrieve the columns based on their position, because the order in which columns are -returned @strong{CANNOT} be guaranteed over time. A simple change to -your database may cause your application to fail rather dramatically. +retrieve the columns based on their position, because the order in which +columns are returned @strong{CANNOT} be guaranteed over time. A simple +change to your database may cause your application to fail rather +dramatically. If you want to change the order of columns anyway, you can do it as follows: @@ -33207,7 +33208,7 @@ you are making a copy of the files in the database directory. If you want to make a SQL level backup of a table, you can use @code{SELECT INTO OUTFILE}. Another way to back up a database is to use the @code{mysqldump} program: -@xref{mysqldump}: +@xref{mysqldump}. @enumerate @item @@ -33234,7 +33235,7 @@ If you have to restore something, try to recover your tables using @code{myisamchk -r} first. That should work in 99.9% of all cases. If @code{myisamchk} fails, try the following procedure: (This will only work if you have started @strong{MySQL} with -@code{--log-update}. @xref{Update log}): +@code{--log-update}. @xref{Update log}.): @enumerate @item @@ -33471,7 +33472,7 @@ when connecting to the @strong{MySQL} server. @item If your are using the @strong{MySQL} perl DBD module you can read the options -from the @strong{MySQL} option files. @xref{Option files}: +from the @strong{MySQL} option files. @xref{Option files}. @example $dsn = "DBI:mysql:test;mysql_read_default_group=client;" @@ -33731,7 +33732,7 @@ The number of decimals for numeric fields. The functions available in the C API are listed below and are described in greater detail in the next section. -@xref{C API functions}: +@xref{C API functions}. @multitable @columnfractions .3 .7 @item @strong{mysql_affected_rows()} @tab |