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.

Connect to the MySQL database. The following code connects to a database server named "myserver:"mysql_connect ('myserver', 'user', 'password') Retrieve a list of tables from the database.

We can now view the inserted data with the command: SELECT * FROM MEMBERS2; You should see the data listed (Figure A). Figure A Continue adding data to the table in the same fashion.

The MySQL Database can be used to create a free online or offline mailing list. A basic mailing list database contains two tables. One table contains the name, email address, street address and ...