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:


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.


Generic placeholder image

MySql is probably the worlds most popular database engine.


Generic placeholder image

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