- CREATE DATABASE board;
- USE board;
- CREATE TABLE topic(
- board_idx INT(11) PRIMARY KEY AUTO_INCREMENT,
- title VARCHAR(45),
- description text,
- price VARCHAR(50),
- created datetime,
- image VARCHAR(100),
- author_name VARCHAR(20)
- );
- INSERT INTO topic(board_idx,title,description,price,created,image,author_name) VALUES (1,'애플워치 팔아요'치 팔아요','미개봉입니다','150\,000',now(),'1.PNG','김작성');
- INSERT INTO topic(board_idx,title,description,price,created,image,author_name) VALUES (2,'애플워치 팔아요','미개봉입니다','150\,000',now(),'2.PNG','김작성');
- INSERT INTO topic(board_idx,title,description,price,created,image,author_name) VALUES (3,'애플워치 팔아요','미개봉입니다','150\,000',now(),'3.PNG','김작성');
- INSERT INTO topic(board_idx,title,description,price,created,image,author_name) VALUES (4,'애플워치 팔아요','미개봉입니다','150\,000',now(),'4.PNG','김작성');
- INSERT INTO topic
- (image, title, description, price, author_name, created)
- VALUES(
- '애플워치.PNG',
- '애플워치 팔아요.',
- '미개볼입니다.',
- '250000',
Raw Paste