MySql – Insert
Inserting rows into MySql can be done in a couple of ways. You can use the INSERT…VALUES and INSERT…SET commands.
MySql is the worlds second most popular database engine (July 2013) and its open source. It is based on SQL (Sequential Query Language). Unlike MS Access it does not run as a stand-alone application. It runs as a background service on a computer (typically called ‘a server’) and you connect to it using a username and password. Once you have connected to the MySql server you can query it using SQL or Structured Query Language. The server will respond with the results of your query.
Python is a highly readable language that is easy to use and learn hence it is gaining popularity as an education language. However, this should not lead anyone to consider it a child’s language for it is not. It is very powerful, flexible and platform independent. It supports many styles of programming from scripting and web design to GUI/Game development.
MySql – Feedback
Getting helpful feedback from MySQL when it errors is possible if you use the following:
mysql_query($sql) or die('Some useful message:' . mysql_error() );
MySql – Relationships
Dealing with relationships in MySql is not as straightforward as either MS Access or as you would have hoped for. Creating simple primary keys isn’t too difficult