Chapter 10 . Databases And Data 267 (Affordable web hosting) The
Chapter 10 . Databases And Data 267 The –line-and –fields-options require the use of the –tab=switch. Each option is sufficiently self-explanatory. If you want to terminate or enclose a field of the output with a string you can do so with these functions. Also, things like nfor newline and t for tabare supported, so you can separate fields or lines by those characters as well. The keyword OPTIONALLYused with ENCLOSEDcauses only CHARand VARCHARcolumn types to be enclosed in the specified manner. Examples of various mysqldumpcommands that use these switches are shown in Figures 10-33 through 10-36. Figure 10-33: Performing the command: mysqldump -p ecommerce –fields-terminated-by=+ –tab=outputdir to produce output with fields terminated by a plus sign (+) Figure 10-34: Running the command mysqldump -p ecommerce -fields- terminated-by= n –tab=outputdir to separate all fields by a newline (n)
Check Tomcat Web Hosting services for best quality webspace to host your web application.