eSQL modification (Introduction to the database of the increase, deletion, use of law)

Take the Help module under the system directory (e.g. D:/webeasy) as an example to introduce the usage of increment, delete and change

Add a record：

Insert a record into table messages, subject= ' My subject ', writer= ' visitors ', body= ' here is content ', daytime is @{sys:date:datetime}. When inserting or modifying a field of a date type (or other non-string type) in a database, specify the corresponding type
(example file: _samples/esql_insert.html)
To modify a record:
Modify the contents of a id=2 in a messages table
(example file: _samples/esql_update.html)
To delete a record:
Delete id=2 records from the messages table
(example file: _samples/esql_delete.html)
In addition to the above, esql tags are capable of executing most SQL statements, such as building tables, modifying tables, etc., and you can test different databases according to your development needs.
Download and description of light-open platform resources
Platform Free Download: http://download.csdn.net/detail/tx18/8381859
Latest Development Manual Download: http://download.csdn.net/detail/tx18/8411089
Development example: Light Open e-commerce website , free download: http://download.csdn.net/detail/tx18/8318585
The light-open platform will be upgraded to provide you with more powerful and easy features, please note the latest development manuals
eSQL modification (Introduction to the database of the increase, deletion, use of law)