Cara menggunakan php sqlite3 delete
SQLite DELETE Query Syntax: Example 1: Example: Explanation: Output:
Example 2: Explanation: SQL DELETE KeywordThe The following SQL statement deletes the customer "Alfreds Futterkiste" from the "Customers" table: ExampleDELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste'; Try it Yourself » Note: Be careful when deleting records in a table! Notice the WHERE clause in the DELETE statement. The WHERE clause specifies which record(s) should be deleted. If you omit the WHERE clause, all records in the table will be deleted! It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact: The following SQL statement deletes all rows in the "Customers" table, without deleting the table. This means that the table structure, attributes, and indexes will be intact: I've spent the last couple of days grappling wit the simple concept of using a php script as Save button. When pressed from a webpage the button will INSERT data from
So far I could use some help with this PHP query, as well as any guidance.
asked Sep 22, 2011 at 11:24
I would do something like this:
You can check the syntax for the insert and delete statments for SQLite here: http://www.sqlite.org/lang_insert.html http://www.sqlite.org/lang_delete.html answered Sep 22, 2011 at 11:47
Luís SousaLuís Sousa 781 silver badge7 bronze badges 3 |