1 개요[ | ]
sql
Copy
-- Delete the table if it exists
DROP TABLE IF EXISTS TEST;
-- Create a new table with ID and NAME columns
CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255));
-- Add a new row
INSERT INTO TEST VALUES(1, 'Hello');
-- Add another row
INSERT INTO TEST VALUES(2, 'World');
-- Query the table
SELECT * FROM TEST ORDER BY ID;
-- Change data in a row
UPDATE TEST SET NAME='Hi' WHERE ID=1;
-- Remove a row
DELETE FROM TEST WHERE ID=2;
2 같이 보기[ | ]
편집자 Jmnote
로그인하시면 댓글을 쓸 수 있습니다.