The following SQL statement selects all customers with a City starting with the letter "s":
Example
SELECT * FROM CustomersWHERE City LIKE 's%';
Try...
SQL - Delete All Data
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:
DELETE FROM table_name;orDELETE * FROM table_name;
Note: Be...
SQL - DELETE Example
Assume we wish to delete the customer "Alfreds Futterkiste" from the "Customers" table.
We use the following SQL statement:
Example
DELETE FROM CustomersWHERE CustomerName='Alfreds...
Subscribe to:
Posts (Atom)
