SQL   50
database board
Guest on 6th February 2023 02:15:50 AM


  1. CREATE DATABASE board;
  2. USE board;
  3.  
  4. CREATE TABLE topic(
  5. board_idx INT(11) PRIMARY KEY AUTO_INCREMENT,
  6. title VARCHAR(45),
  7. description text,
  8. price VARCHAR(50),
  9. created datetime,
  10. image VARCHAR(100),
  11. author_name VARCHAR(20)
  12. );
  13.  
  14. INSERT INTO topic(board_idx,title,description,price,created,image,author_name) VALUES (1,'애플워치 팔아요'치 팔아요','미개봉입니다','150\,000',now(),'1.PNG','김작성');
  15. INSERT INTO topic(board_idx,title,description,price,created,image,author_name) VALUES (2,'애플워치 팔아요','미개봉입니다','150\,000',now(),'2.PNG','김작성');
  16. INSERT INTO topic(board_idx,title,description,price,created,image,author_name) VALUES (3,'애플워치 팔아요','미개봉입니다','150\,000',now(),'3.PNG','김작성');
  17. INSERT INTO topic(board_idx,title,description,price,created,image,author_name) VALUES (4,'애플워치 팔아요','미개봉입니다','150\,000',now(),'4.PNG','김작성');
  18.  
  19.    
  20.     INSERT INTO topic
  21.     (image, title, description, price, author_name, created)
  22.     VALUES(
  23.         '애플워치.PNG',
  24.         '애플워치 팔아요.',
  25.         '미개볼입니다.',
  26.         '250000',
  27.      

Raw Paste

Login or Register to edit or fork this paste. It's free.