Open MySQL Workbench and connect to your database server. From the database home screen (Figure A), right-click a blank spot under the SCHEMAS pane and select Create Schema.

Use those modifiers with any MySQL query to create tab-delimited files that Excel can open. After loading the data into Excel, you are free to save your new spreadsheet as an XLS or XLSX file as ...

BANGALORE, INDIA: If you're creating a dynamic web application using open-source tools, then you're probably going to be setting up a MySQL database. Getting the design of this database right for ...