2,306
edits
Changes
Jump to navigation
Jump to search
Line 36:
Line 36: − + + + + + + + + + + + +
no edit summary
);
);
DROP TABLE table_name</nowiki>
DROP TABLE table_name;</nowiki>
== List tables ==
\d
\dt
== ADD, QUERY, DELETE from table ==
Add
INSERT INTO table_name (column_name1, column_name2, column_name3, column_name4)
VALUES ('value1', 'value2', 'value3', 'value4');
Query
SELECT * FROM table_name;
Delete
DELETE FROM table_name WHERE column_name = 'value1';