Code Monkey home page Code Monkey logo

ai_study's Introduction

ai_study

Create DB

  1. XAMPP를 이용 하여 mysql server 설치
  2. DB 생성 
    CREATE DATABASE ai_study;
  3. DB User 생성 하고 권한부여 
    GRANT ALL PRIVILEGES ON `ai_study`.* TO `YOUR ID`@localhost IDENTIFIED BY `YOUR PASSWORD` WITH GRANT OPTION;
FLUSH PRIVILEGES;
  4. Table 생성
    • Member 
      CREATE TABLE `member` (
    `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `userid` VARCHAR(20) NULL DEFAULT NULL COMMENT '아이디' COLLATE 'utf8mb4_general_ci',
    `userpw` VARCHAR(200) NULL DEFAULT NULL COMMENT '비밀번호' COLLATE 'utf8mb4_general_ci',
    `name` VARCHAR(20) NULL DEFAULT NULL COMMENT '이름' COLLATE 'utf8mb4_general_ci',
    `img` VARCHAR(50) NULL DEFAULT NULL COMMENT '아바타 이미지' COLLATE 'utf8mb4_general_ci',
    `level` CHAR(1) NULL DEFAULT '1' COMMENT '권한' COLLATE 'utf8mb4_general_ci',
    `created_at` TIMESTAMP NULL DEFAULT current_timestamp(),
    `updated_at` DATETIME NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
    • News 
      CREATE TABLE `news` (
    `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `category` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `subject` VARCHAR(200) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `content` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `comment` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `name` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `userid` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `img1` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `img2` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `img3` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `likenum` INT(11) NULL DEFAULT '0',
    `viewnum` INT(11) NULL DEFAULT '0',
    `created_at` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
    `updated_at` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;
  5. 기초데이터 Insert 
    insert into member set userid = 'admin', userpw = password('123123'), name = '관리자', img = 'member.png';
    insert into news set category='정치', subject='제목', content='내용', comment='요약', name='작성자', userid='admin', img1='img_1.jpg', img2='img_2.jpg', img3='img_3.jpg';

ai_study's People

Contributors

ddasix avatar

Watchers

avatar avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.