There are many reasons to use MySQL database software. One, is that its free, you can download it to your PC and be up an running in very little time. Secondly, MySQL databases are needed to build many apps. The data in MySQL databases are needed to for dashboard development in almost every app. There is more, but before going there lets not forget about the database’s cousin, the spreadsheet. Data in an Excel spreadsheet can be imported into a MySQL database and vice versa, data in a MySQL database can be “easily” transferred to an Excel spreadsheet.
Just how easy is it? It takes just a few clicks, less than a minute, requires no code, no CVS file, no exporting and no importing and no special MySQL connecter!!!
Here are the easy to follow select, copy and paste steps
- Open up MySQL Workbench database in Result Grid view.
- Click anywhere within the database grid view.
- Press Control A (on Windows). Note every record (row) in the database is selected.
- Press Control C to copy all the data
- Open up a blank Excel spreadsheet.
- Press Control V to paste all the data into the Excel spreadsheet. Note that all the record and field data in the database is correctly formatted in all the rows and columns of the Excel file
- Save your Excel file and you are done.
If you are interested in learning more about SQL and the different databases. the The SQLMatrix: Concepts poster is one place to start. It covers the basics needed to understand how SQL statements are used to develop and work with SQL based databases. The SQLMatrix Poster can be found at our SQLMatrix Redbubble Store along with scores of other products based on the SQLMatrix design.
