And that’s all there is to creating a table and inserting data into it on MySQL. Once you have all the data necessary, your database is ready for usage by your web-based tool.

Click the database you want to use to insert data. Type the MySQL insert statement that inserts the characters, placing a backslash in front of any commas or quotes.

Select the mysql-connector-java-XXX-bin.jar file (where XXX is the release number) and click OK. Click OK to exit out of the Options window and you’re ready to connect to your remote database.

The basic form is as follows: Data Entry Form FIELD1: FIELD2: Create the PHP file to read the form fields, make the connection to the database and insert the data into the database.