To be able to work with data of the database, it is important to gain basic knowledge of SQL language. In this part, we introduce you the basic sql statements commonly used. In this instruction, we use Tablename to refer to the table and fieldname to refer to the field of the table that we will work with.
Note: For DELETE and UPDATE statements, you should set conditions(s). If you don’t set condition(s), all of your data in a specified table will be deleted or updated.
This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: