Insert

Generic placeholder image

Inserting rows into MySql can be done in a couple of ways. You can use the INSERT…VALUES and INSERT…SET commands. The first option INSERT…VALUES syntax is:

Example:

The second option INSERT…SET syntax alternative requires that you specify each field name with its counterpart in the same format as update queries.

If you are […]

Create Table

Generic placeholder image

You can create a table in a mysql database using the Create table tablename … command.

MySql

Generic placeholder image

MySql is probably the worlds most popular database engine.

Feedback

Generic placeholder image

Getting helpful feedback from MySQL when it errors is possible if you use the following: