SQL Injection

By | MYSQL, Programming | No Comments

An SQL Injection can destroy your database. SQL in Web Pages In the previous chapters, you have learned to retrieve (and update) database data, using SQL. When SQL is used to display data on a web page, it is common to let web users input their own search values. Since…

Read More

SQL UPDATE Statement

By | MYSQL, Programming | No Comments

SQL UPDATE Statement The UPDATE statement is used to update records in a table. The SQL UPDATE Statement The UPDATE statement is used to update existing records in a table. SQL UPDATE Syntax UPDATE table_name SET column1=value1,column2=value2,… WHERE some_column=some_value; Note Notice the WHERE clause in the SQL UPDATE statement! The…

Read More

SQL WHERE Clause

By | MYSQL, Programming | No Comments

SQL WHERE Clause The WHERE clause is used to filter records. The SQL WHERE Clause The WHERE clause is used to extract only those records that fulfill a specified criterion. SQL WHERE Syntax Demo Database In this tutorial we will use the well-known Northwind sample database. Below is a selection…

Read More

Database Tables

By | MYSQL, Programming | No Comments

Database Tables A database most often contains one or more tables. Each table is identified by a name (e.g. “Customers” or “Orders”). Tables contain records (rows) with data. In this tutorial we will use the well-known Northwind sample database (included in MS Access and MS SQL Server). Below is a…

Read More