tailieunhanh - Mysql your visual blueprint for creating open source databases- P10

Mysql your visual blueprint for creating open source databases- P10:The show tables command displays a list of tables available in the currently selected database. You can use this command when you are unsure of the exact name of a table within the database. | IMPORT AND EXPORT DATA 8 You can also import a text file you created with the SELECT INTO OUTFILE option in MySQL into Microsoft Access. To import a text file select Get External Data and then Import from the File menu. From the file selection dialog box select Text Files as the file type. Select the text file to import and click OK. Access now starts the Import Text Wizard to prompt you for information about the text file. In the first dialog box choose between Delimited and Fixed width fields. Choose Delimited for most MySQL export files. You can also choose a starting row for the import. Click Next to display the next dialog box. Choose the character that delimits the fields typically Tab for MySQL files. You can also choose Text Qualifier if your text file encloses fields in quotation marks. Click Next to continue. In the next dialog box choose whether to add the data to a new table or an existing table in the current database. Click Next to display another dialog box which prompts you for the name and data type of each field. The next dialog box lets you choose a field to act as primary key. Finally enter a table name and click Finish to complete the import. Q From the Export Text Wizard select the Delimited option. Click Next to Q Select Tab as the delimiting character. -O Select none as the Text Qualifier option. Click Next. L Click Finish to save the file. You can now import the resulting text file into MySQL. 167 MySQL BACK UP DATA FROM A TABLE While you can export data to a text file using SELECT and the INTO OUTFILE option this process creates a simple text file. MySQL includes a separate utility mysqldump that you can use from the command line to back up a database to a text file. The output file includes SQL statements and can be used to rebuild the database or tables. To use mysqldump specify a database name and one or more table names. The following example dumps the mail and address tables from the testdb database mysqldump testdb mail address If .