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',