Get up to speed on MySQL basics with this step-by-step tutorial on how to create a database, add a table, and input data into the table.

Jack Wallen explains how to add data into a MySQL table from the command line.

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.

Next, we shall explore the MySQL database tables generated from the MySQL CLI (command-line interface). Start the MySQL CLI shell to display the mysql command prompt.

You will first need code for the forms, then code to make the connection to the database and write the data to MySQL and code for the reports to display static or dynamic information to site visitors.