Differences

This shows you the differences between two versions of the page.

--- v5:userguide:learn_abstraction:record_insertion [2016/03/15 17:50] – [Updating Multiple Records] use a complete PHP statement for multiple records update dregad
+++ v5:userguide:learn_abstraction:record_insertion [2016/03/20 16:48] (current) – [Inserting A Record] mnewnham
@@ Line 26: / Line 26: @@
 /*
- * result executes "INSERT INTO people (first_name,last_name) values ('Carol',Smith')";
+ * result executes "INSERT INTO people (first_name,last_name)
+                                values ('Carol',Smith')";
  */
 </code>
+AutoExecute helps, because it can automatically determine the type of the field to be created, quoting data appropriately, and can even handle special characters in the fields.
 ==== Updating A Record ====
 To update a record, we must also know how to retrieve the record uniquely, for example there might be a sequence number on the table that uniquely identifies each one. In the following example, the requested record is identified by an id number of 305:
@@ Line 42: / Line 45: @@
 /*
- * result executes "UPDATE people SET first_name='Caroline',last_name='Jones' WHERE id=305";
+ * result executes "UPDATE people SET first_name='Caroline',
+*                                     last_name='Jones'
+*                                     WHERE id=305";
  */
 </code>
@@ Line 56: / Line 61: @@
 <WRAP info 300px center>
-**End Of Lesson 1**
+**End Of Lesson**
 </WRAP>