DELETE
-- deleting all table rows
DELETE FROM stock_backup;
-- deleting rows
DELETE FROM stock WHERE stock=0;
DELETE FROM stock_backup;
-- deleting rows
DELETE FROM stock WHERE stock=0;
'DataBase' 카테고리의 다른 글
| PostgreSQL - VIEW (0) | 2009.05.02 |
|---|---|
| PostgreSQL - SUB_QUERY (0) | 2009.05.02 |
| PostgreSQL - UPDATE (0) | 2009.05.02 |
| PostgreSQL - SELECT (0) | 2009.05.02 |
| PostgreSQL - INSERT (0) | 2009.05.02 |
