study / okdevtv star
03-11
Closed
#102 데이터베이스 관리 star
03-11 Closed
허광남 @kenu
Change history
Tasks
  • 요나 소개
  • 마리아디비 설치
    • DB general
  • 디비버 연결
  • ERDcloud.com
Issue Sharer
Comment 2
  • 허광남
    kenu 허광남 03-11 Reference in new issue
    • Markdown help
    • Header
    • Text Style
    • Link
    • List
    • Checklist
    • Image
    • Blockquote
    • Code
    • Table
    • Short Link
    • Markdown Input
      Markdown Output
      # This is an H1
## This is an H2
### This is an H3
      # This is an H1 ## This is an H2 ### This is an H3
    • Markdown Input
      Markdown Output
      *This is an italic*
**This is an bold**
~~This is an strike~~
      *This is an italic* **This is an bold** ~~This is an strike~~
    • Markdown Input
      Markdown Output
      [Site](http://yobi.io/ "Yobi Site")

http://yobi.io/
      [Site](http://yobi.io/ "Yobi Site") http://yobi.io/
    • Markdown Input
      Markdown Output
      - Red
    1. White
    2. Blue
- Green.
      - Red 1. White 2. Blue - Green
    • Markdown Input
      Markdown Output
      - [ ] Todos
    - [x] To do A
    - [ ] To do B
    - [ ] To do C
      • Todos
        • To do A
        • To do B
        • To do C
    • Markdown Input
      Markdown Output
      ![title](https://repo.yona.io/assets/images/ico-like-small.png "Yobi")
      ![title](/assets/images/ico-like-small.png "Yobi")
    • Markdown Input
      Markdown Output
      > Lorem ipsum dolor sit amet, consectetuer adipiscing elit.
>
> Aenean commodo ligula eget dolor.
      > Lorem ipsum dolor sit amet, consectetuer adipiscing elit. > > Aenean commodo ligula eget dolor.
    • Markdown Input
      Markdown Output
      `function test() {console.log("hello world");}`

```javascript
function test() {
  console.log("hello world");
}
```
      `function test() {console.log("hello world");}` ```javascript function test() { console.log("hello world"); } ```
    • Markdown Input
      Markdown Output
      | Default      | Align center | Align right |
| ------------ | :----------: | ------: |
| Carrot       | Red          | 1,000   |
| Banana       | Yellow       | 32,000  |
      | Default | Align center | Align right | | ------------ | :----------: | ------: | | Carrot | Red | 1,000 | | Banana | Yellow | 32,000 | Also, you can copy & paste table from excel sheet
    • Markdown Input
      Markdown Output
      Issue no: #2
Mention: @yobi
commit: @763575 or @763575f177a4ce8b9370954de3ea1a1410205593

      Issue no: #2

      Mention: @yobi

      commit: @763575 or @763575

    Notification receivers
    Drag & Drop files here to upload.
    Tasks

    https://github.com/yona-projects/yona/releases/download/v1.16.0/yona-v1.16.0-bin.zip

    Reply
  • 허광남
    kenu 허광남 03-11 Reference in new issue
    • Markdown help
    • Header
    • Text Style
    • Link
    • List
    • Checklist
    • Image
    • Blockquote
    • Code
    • Table
    • Short Link
    • Markdown Input
      Markdown Output
      # This is an H1
## This is an H2
### This is an H3
      # This is an H1 ## This is an H2 ### This is an H3
    • Markdown Input
      Markdown Output
      *This is an italic*
**This is an bold**
~~This is an strike~~
      *This is an italic* **This is an bold** ~~This is an strike~~
    • Markdown Input
      Markdown Output
      [Site](http://yobi.io/ "Yobi Site")

http://yobi.io/
      [Site](http://yobi.io/ "Yobi Site") http://yobi.io/
    • Markdown Input
      Markdown Output
      - Red
    1. White
    2. Blue
- Green.
      - Red 1. White 2. Blue - Green
    • Markdown Input
      Markdown Output
      - [ ] Todos
    - [x] To do A
    - [ ] To do B
    - [ ] To do C
      • Todos
        • To do A
        • To do B
        • To do C
    • Markdown Input
      Markdown Output
      ![title](https://repo.yona.io/assets/images/ico-like-small.png "Yobi")
      ![title](/assets/images/ico-like-small.png "Yobi")
    • Markdown Input
      Markdown Output
      > Lorem ipsum dolor sit amet, consectetuer adipiscing elit.
>
> Aenean commodo ligula eget dolor.
      > Lorem ipsum dolor sit amet, consectetuer adipiscing elit. > > Aenean commodo ligula eget dolor.
    • Markdown Input
      Markdown Output
      `function test() {console.log("hello world");}`

```javascript
function test() {
  console.log("hello world");
}
```
      `function test() {console.log("hello world");}` ```javascript function test() { console.log("hello world"); } ```
    • Markdown Input
      Markdown Output
      | Default      | Align center | Align right |
| ------------ | :----------: | ------: |
| Carrot       | Red          | 1,000   |
| Banana       | Yellow       | 32,000  |
      | Default | Align center | Align right | | ------------ | :----------: | ------: | | Carrot | Red | 1,000 | | Banana | Yellow | 32,000 | Also, you can copy & paste table from excel sheet
    • Markdown Input
      Markdown Output
      Issue no: #2
Mention: @yobi
commit: @763575 or @763575f177a4ce8b9370954de3ea1a1410205593

      Issue no: #2

      Mention: @yobi

      commit: @763575 or @763575

    Notification receivers
    Drag & Drop files here to upload.
    Tasks
    show databases;

use information_schema;

show tables;

select * from tables where table_schema = 'yona';

select * from tables where table_schema = 'yona' order by table_rows desc;

use yona;

select * from issue_comment ic where author_id = 39;

select * from notification_event_n4user nenu;

delete from notification_event_n4user where n4user_id = 39;

select id from notification_event ne where sender_id = 39; 

select * from notification_event_n4user nenu where notification_event_id in (
  select id from notification_event ne where sender_id = 39
);

delete from notification_event_n4user where notification_event_id in (
  select id from notification_event ne where sender_id = 39
);

delete from notification_event where sender_id = 39; 

delete from issue_comment where author_id = 39;
    Reply
  • Closed 허광남 closed this issue 03-11
Add a comment
New subtask
Assignee
허광남 @kenu
Milestone
New milestone
Due date
No due date
Keyboard shortcuts