MySQL 기초

mysql monitor

mysql monitor

  • mysql서버의 번들로 제공하는 기본 프로그램
  • 명령어 기반

사용법

mysql -u아이디 -p비밀번호
mysql -h호스트주소 -p포트번호 -u아이디 -p비밀번호

데이터베이스 생성

CREATE DATABASE music CHARACTER SET utf8 COLLATE utf8_general_ci;

데이터베이스 선택

use music;

테이블 생성

CREATE TABLE `favorite_music` (
  `title` varchar(255) NOT NULL,
  `musician` varchar(20) NOT NULL,
  `duration` varchar(20) NOT NULL,
  `album` varchar(30) NOT NULL
) ENGINE=innodb;

테이블에 데이터 추가

insert into favorite_music (`title`,`musician`, `duration`, `album`) values('Chasing Pavements', '아델', '3:30', 19);

입력된 데이터 조회

select * from favorite_music;

종료

mysql> exit;

댓글

댓글 본문
  1. CopyX
    ```
    mysql -h호스트주소 -p포트번호 -u아이디 -p비밀번호
    ```

    위에서 포트번호는 소문자 p가 아닌 대문자 P입니다.
  2. jerry127
    https://myrelist.com/ Shayari amazing and Interesting to read and learn. Its amazing to find something interesting and cool.
  3. Jack Parker
    Essay Help Singapore The education system we have is benefitting a lot of students invariably, but there are certain cons to it as well. It is not surprising these days to find meritorious students who are extremely good with the required aptitude but are crumbled under the pressure of assignments. Most of the students are running against the clock to complete their deadline every single day. This is much more terrifying than it sounds and it is affecting a large section of students of every university and age. These students stress so much about their assignments that they end up wrecking their mental and physical health which certainly isn’t good for their future. Many of these students are looking for My Assignmenthelp Singapore, and we are here to help! We are an assignment help portal, and we ensure that you will not have to stress about your assignments or grades anymore.

    https://www.gotoassignmenthelp.com......lp/
  4. Jack Parker
    Essay Help Singapore The education system we have is benefitting a lot of students invariably, but there are certain cons to it as well. It is not surprising these days to find meritorious students who are extremely good with the required aptitude but are crumbled under the pressure of assignments. Most of the students are running against the clock to complete their deadline every single day. This is much more terrifying than it sounds and it is affecting a large section of students of every university and age. These students stress so much about their assignments that they end up wrecking their mental and physical health which certainly isn’t good for their future. Many of these students are looking for My Assignmenthelp Singapore, and we are here to help! We are an assignment help portal, and we ensure that you will not have to stress about your assignments or grades anymore.

    https://www.gotoassignmenthelp.com......lp/
  5. hibbah
    Royale Business has over 6 ways to earn if you become a member. To give you a basic idea, these are through direct selling, uni-level, franchising,
    สมัคร Royal Online v2
    https://www.geministar777.com......v2/
  6. hibbah
    This article was written by a real thinking writer. I agree many of the with the solid points made by the writer. I’ll be back.
    best smartphones 2020
    https://smartphoneage.com/
  7. hibbah
    I was reading your article and wondered if you had considered creating an ebook on this subject. Your writing would sell it fast. You have a lot of writing talent.
    2021 Jamb cbt expo
    https://gurusanswers.com......nz/
  8. hibbah
    I’m going to read this. I’ll be sure to come back. thanks for sharing. and also This article gives the light in which we can observe the reality. this is very nice one and gives indepth information. thanks for this nice article...
    asikqq poker
    http://asikqq-q.com/
  9. hibbah
    very beautiful and emotional love poetry in Urdu that helps you to express your emotions in a beautiful way. With care of eachother romance is the thing that makes a relationship strong and keeps a sparks flying. Some love lines are the best thing to keep that spark but you should consider every choice of words beautifully.
    romantic poetry in urdu
    https://poetryinurdu.net......rs/
  10. hibbah
    very interesting post.this is my first time visit here.i found so mmany interesting stuff in your blog especially its discussion..thanks for the post!
    joker123 สมัคร
    https://www.thejoker777.com/
  11. hibbah
    Yes, I am entirely agreed with this article, and I just want say that this article is very helpful and enlightening. I also have some precious piece of concerned info !!!!!!Thanks.
    songs download
    https://www.onlymazika.com/
  12. hibbah
    Most people fantasize about being able to play the guitar at least once in their life. The dream of rock stardom is especially potent among teens. It is very easy to become overwhelmed when you first start out attempting to learn to play the guitar.
    Learn guitar online
    http://www.shanschool.com/blog/
  13. hibbah
    Experience is essential when hiring a professional translator. As there are a vast number of translators in France you can choose from, It is beneficial to turn to a professional translation company as opposed to a freelance translator as a service.
    French translator
    https://itcze.com......ne/
  14. mehreensiddique
    Wow, cool post. I'd like to write like this too - taking time and real hard work to make a great article... but I put things off too much and never seem to get started. Thanks though. https://www.youtube.com......OFg
  15. hibbah
    Many people believe that bitcoins represent a new era of digital currency and often get confused with them. However, since the bitcoin chain system is totally computerized it is quite simple and easy to buy and use them especially they are hell cheap when it comes to international transactions. Since exchanges demand a variety of payment processes such as credit or debit cards,
    Buy BTC
    https://fortunez.com......to/
  16. mehreensiddique
    Awesome article, it was exceptionally helpful! I simply began in this and I'm becoming more acquainted with it better! Cheers, keep doing awesome! https://www.youtube.com......6KU
  17. hibbah
    Have you noticed lately that live casino games people can play baccarat against one live dealer, As the gaming industry begins to mature and technology continues to advance,you'll begin seeing more and more live casino games being streamed over theInternet.
    sexy baccarat
    https://sexybaccarat.kickoffbets.com/
  18. hibbah
    As a raw material, polyurethane comes in a variety of hardnesses, densities and stiffnesses, but TPU polyurethane sheets are specifically engineered to offer top quality abrasion, corrosion and impact resistance.
    Tpu case
    https://www.wawcase.com......es/
  19. hibbah
    However, capturing people's attention isn't just about sharing an image and collecting Likes and followers. You need to spend time interacting with people and liking other users' posts - time that many business owners simply don't have.
    instagram takipçi satın al
    https://trmedya.co/
  20. hibbah
    Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info.
    Wayfair Black Friday Sale
    https://www.savingchief.com......le/
  21. hibbah
    Nation Space and Technology (NSAT), a joint venture between satellite service provider Thaicom and state telecom enterprise CAT Telecom, has rolled out an upgraded version of maritime service platform NAVA to bolster data connectivity effectiveness for vessel operations.
    nava by nsat
    https://www.itday.in.th......at/
  22. hibbah
    Once you have this information correctly in front of you and your calculator in hand, you can start working the formulas. You need to choose five regular balls and one extra ball correctly matched to the winning drawn numbers to win the multi-million dollar jackpot that most of us dream about winning someday.
    Lottery Result
    https://lotterysambadindia.com/
  23. hibbah
    This is very interesting content! I have thoroughly enjoyed reading your points and have come to the conclusion that you are right about many of them. You are great.
    judi online
    https://216.158.237.231/
  24. mehreensiddique
    The article looks magnificent, but it would be beneficial if you can share more about the suchlike subjects in the future. Keep posting. https://www.thempire.me/
  25. mehreensiddique
    I have read your blog it is very helpful for me. https://www.argadetectives.com......tml
  26. mehreensiddique
    I was reading some of your content on this website and I conceive this internet site is really informative ! Keep on putting up. https://www.tutorcity.sg......ion
  27. florahwilliams
    Nursing coursework writing services are essential and they have become very popular for those seeking custom nursing research writing services since most of them seek Nursing Assignment Writing Services.
    https://researchpapers247.com......es/
  28. mehreensiddique
    I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. https://www.tutorcity.sg......ion
  29. 홍주호
    20.5.26 완료
  30. David Millar
    Interesting article! Thank you for sharing them! I hope you will continue to have similar posts to share with everyone.
    https://www.filmstaroutfits.com......oat
  31. JackPonting
    Very helpful video on MYSQL monitor which is also explain us about how to use it, create & select database etc.

    Jack,
    Dissertation writer,
    http://www.qualitydissertation.co.uk/
  32. lestarjohnson
    A really great blog, thanks for such a good blog. https://fauxncotton.com......ket
  33. Alex Mercer
    A really great blog, thanks for sharing, i really appreciated. https://celebleatherjackets.com......ume
  34. marieclaire85
    Assignment Desk UK is one of the most recommended online assignment writing service among students. We cater the academic requirements and offer qualitative services under affordable prices. We hold the experience of more than 8 years and with such experience we exactly know what are your assignment help requirements. This is why students rely on us and approach us as soon as they are assigned with a writing task. We at Assignment Desk UK don’t just deliver word we deliver services, which are actually effective. We make sure that you pass with flying colors and so, we provide 24*7 assignment help.
    https://www.assignmentdesk.co.uk......ent
  35. wwwe
    http://www.yeezy-500.us.com
    http://www.redbottom-shoes.us.com
    http://www.cheap-airjordans.us.com
    http://www.filashoes.us.org
    http://www.nike-hyperdunk.us.com
    http://www.yeezyboost350v2.org.uk
    http://www.curry4.net
    http://www.yeezysshoes.us.com
    http://www.toryburchs.us
    http://www.chromeheartsoutletonline.com
    http://www.jordan11retro.us.com
    http://www.filashoes.org
    http://www.adidasstansmith.uk
    http://www.offwhitexjordan1.com
    http://www.air-max.us.com
    http://www.yeezy-boost.us.com
    http://www.yesyeezy.shop......tml
    http://www.jimmychoo-shoes.us.com
    http://www.nikeairmax2019.us.com
    http://www.hermes-handbags.us.com
    http://www.nikepolo.us
    http://www.outletlacoste.us.com
    http://www.fila-shoes.us.com
    http://www.goldengoosesneakers.us
    http://www.jordan13.us.com
    http://www.nikereact.org
    http://www.bapehoodie.us
    http://www.ferragamobelt.us
    http://www.adidasnmduk.com
    http://www.monclerjackets.us
    http://www.kyrieirving-shoes.us.com
    http://www.lacostepolo.us.com
    http://www.yesyeezy.shop......tml
    http://www.yeezy-shoes.us.org
    http://www.adidasyeezy.co.uk
    http://www.coachoutletstorefactory.com
    http://www.jordan4.us.com
    http://www.yeezy-boost350.us.com
    http://www.goyard.us.com
    http://www.hogan-outlet.us.com
    http://www.jordansshoes.us.org
    http://www.yslhandbags.net
    http://www.fitflops-saleclearance.us.com
    http://www.katespadehandbags-outlet.us.com
    http://www.yeezyboost350v2shoes.us.com
    http://www.adidas-tubular.us.com
    http://www.asics-shoes.us.org
    http://www.hermesbelts.com
    http://www.yesyeezy.shop......tml
    http://www.yeezyshoesuk.com
    http://www.nike-roshe.us.com
    http://www.nikejordans.us.com
    http://www.outletmichael-kors.us.com
    http://www.supremeclothing.us
    http://www.goyardbags.us
    http://www.adidas-crazyexplosive.us.com
    http://www.michael-kors-handbags.com.co
    http://www.adidasiniki.us
    http://www.yeezysshoes.org
    http://www.guccibelt.us.com
    http://www.kd11.us.com
    http://www.yesyeezy.shop
    http://www.hermesonlineshop.com
    http://www.longchamphandbags.co.uk
    http://www.lebron16.us
    http://www.hermes-birkin.us.com
    http://www.goldengoose.us.com
    http://www.yesyeezy.shop/supreme-x-nike-air-more-uptempo-varsity-redwhite-902290600-p-592.html
    http://www.kobesneakers.com
    http://www.coachoutletssale.com
    http://www.kd11.us
    http://www.nikeair-max.us.com
    http://www.hermeshandbags.us.org
    http://www.caterpillarboots.us.com
    http://www.airmax90.us.org
    http://www.coachoutlets.name
    http://www.offwhite.us.com
    http://www.yeezyboost-350v2.us.com
    http://www.adidassuperstar.us.com
    http://www.coachsonline.us.com
    http://www.yesyeezy.shop/adidas-yeezy-boost-350-v2-cream-white-cp9366-p-423.html
    http://www.jordan12.us.com
    http://www.golden-goose.us.com
    http://www.calvinkleinoutlet.us.com
    http://www.lebron16.us.com
    http://www.converseoutlet.us.com
    http://www.yesyeezy.shop/adidas-yeezy-boost-350-v2-beluga-solar-red-bb1826-p-422.html
    http://www.hardenshoes.us.com
    http://www.kobebasketballshoes.net
    http://www.goyardhandbags.org
    http://www.yeezy-boosts.us.com
    http://www.lebronjames-shoes.us.com
    http://www.nikebasketballshoes.us.com
    http://www.nike-shox.us.com
    http://www.balenciagashoes.us.com
    http://www.lebron15.net
    http://www.louboutinshoes.uk
    http://www.jordanshoes.org.uk
    http://www.yesyeezy.shop/balenciaga-17fw-triple-s-trainer-black-red-mens-w05m23972-p-613.html
    http://www.jordanssneakers.us.com
    http://www.balenciaga.us.com
    http://www.nikesneakers.us.com
    http://www.adidas-pureboost.us.com
    http://www.nike-airmax2017.us.com
    http://www.fakerolex.us.com
    http://www.nikeflyknit.us.com
    http://www.outletonline-michaelkors.us.org
    http://www.paulgeorgeshoes.us.com
    http://www.ultraboost.us.com
    http://www.adidasstansmith.us.com
    http://www.jordan-retro.us.com
    http://www.shoesjordan.us.com
    http://www.reebokoutlet.us.org
    http://www.russellwestbrookshoes.us.com
    http://www.yeezyboost-350.uk
    http://www.pandorabracelet.in.net
    http://www.airjordanretro.uk
    http://www.adidasyeezys.us.com
    http://www.outlettimberland.us.org
    http://www.kyrie4.org
    http://www.yesyeezy.shop/offwhite-air-jordan-1-retro-chicago-the-ten-aa3834101-p-837.html
    http://www.yesyeezy.shop/air-jordan-1-og-game-royal-blue-mens-555088403-p-682.html
    http://www.goldengooseoutlet.us
    http://www.valentinosshoes.us
    http://www.kyrie3.us.com
    http://www.nhljerseysshop.us.com
    http://www.nfljerseys.us.org
    http://www.coachoutletsfactory.com
    http://www.long-champ.us.com
    http://www.supremehoodie.us.com
    http://www.michael-kors-handbags.org.uk
    http://www.hermes-belt.us.com
    http://www.yeezy700.us.com
    http://www.nikefoamposite.us.com
    http://www.lebron16.net
    http://www.yesyeezy.shop/offwhite-x-nike-air-presto-black-aa3830002-p-291.html
    http://www.lacostepolosshirts.com
    http://www.yesyeezy.shop/adidas-yeezy-desert-rat-500-blush-db2908-p-425.html
    http://www.yeezysuk.com
    http://www.mbtshoesonline.com
    http://www.handbagsmichaelkors.com
    http://www.goyardhandbags.us.com
    http://www.adidasoutletonline.com
    http://www.chromehearts.com.co
    http://www.fila.us.org
    http://www.kevindurant-shoes.us.com
    http://www.vapormaxshoes.us
    http://www.michael--korsoutlet.us.org
    http://www.michaelkors-outletfactory.us.org
    http://www.chromehearts.name
    http://www.yesyeezy.shop/balenciaga-17fw-triple-s-black-pink-women-sneaker-483523w06e38080-p-618.html
    http://www.yeezyboost.in.net
    http://www.offwhiteclothing.us.com
    http://www.birkinbag.us.com
    http://www.hermesbelts.co.uk
    http://www.balenciagashoes.us.org
    http://www.bape-hoodie.us.com
    http://www.mlbjerseys.in.net
    http://www.vans-outlet.us.com
    http://www.jordan6.us.com
    http://www.michaeljordanshoes.us.com
    http://www.curry5.us.com
    http://www.polosralphlaurenuk.com
    http://www.curry4shoes.us.com
    http://www.adidasgazelle.us.com
    http://www.lacosteonlineshop.us.com
    http://www.goyard-handbags.us.com
    http://www.retro-jordans.us.com
    http://www.michael-korsoutlets.us
    http://www.goldengoose-outlet.us.com
    http://www.offwhitehoodie.us.com
    http://www.goldengoose-sneakers.com
    http://www.off-whiteshoes.us.com
    http://www.adidasyeezys.us
    http://www.kobe-shoes.us.com
    http://www.monclersoutlet.us.com
    http://www.ferragamobelt.us.org
    http://www.michaelkors-outletonlines.us.com
    http://www.nikecortez.us.com
    http://www.yeezy500.us
    http://www.adidasultraboost.us.org
    http://www.jordansforcheap.us.com
    http://www.canada-goose.in.net
    http://www.nikeairmax2018.us.com
    http://www.goldengoose-sneakers.us
    http://www.nikereact.us.com
    http://www.adidasnmds.us.com
    http://www.nikehuaracheshoes.us.com
    http://www.airmax270.us.com
    http://www.cheapnbajerseyswholesales.us.com
    http://www.nike-huarache.com
    http://www.adidasnmds.com
    http://www.yeezyboost.com.co
    http://www.nikeairforce1.us.com
    http://www.adidaseqts.com
    http://www.yeezy-shoes.org.uk
    http://www.yesyeezy.shop/nike-air-max-197-sean-wotherspoon-aj4219400-p-66.html
    http://www.adidasshoesonline.com
    http://www.kd-10.us
    http://www.longchampshandbags.us
    http://www.adidaszxflux.com
    http://www.monclerjacket.net
    http://www.rolex-replica.us.com
    wwwe
  36. alexjuvion
    Useful guidance of using MYSQL monitor, how to use it, create & select database etc. Keep sharing and helping MYSQL learners.

    Alex,
    http://www.qualityassignment.co.uk......ce/
  37. kaonmir
    강의에서 잘 안되는 부분 있으면 참고하세요~
    (저도 처음 배우고 있어서 다는 모르고 구글링 한거만..)

    1. 테이블 생성 에러
    이제는 `(~에 있는 거)를 쓰면 안되는 거 같아요
    title, musician 등을 작성할 때 그냥 문자만 치면 OK입니다.

    그리고 ENGINE=innodb라는 구문은 잘 모르겠지만 생략해도 괜찮더라구요.
    왜 그럴까요... 음...

    2. 테이블에 데이터 추가
    1번과 똑같이 title과 같은 부분은 `를 생략하시면 되고
    values에는 '(따옴표)를 적어주셔야 해요.(문자열 형식들은)

    헤헤 감사합니다.
  38. Scott Sheveland
    할 수 있는 방법으로는 엔터를 친 다음 윗 화살표를 눌러 다시 작성하는 방법 밖에 없을 거에요.
    https://spanishto-english.com
  39. jung
    컨트롤 +C ,컨트롤+V 로하시면 그냥 ^v 뜨실껀데 그러지말고 드래그로 복사하고 붙혀넣기 해보세요~
    대화보기
    • 성훈
      virtualbox 가 너무 불편해서 그냥 기본적으로 쓰는 윈도우에 비트나미로 받아놓은 MySQL을 이용중입니다.

      장치 설치까진 되지만 시작 누를시에 오류가 나며 안되는걸 옆 화살표로 떼낼 수 있도록 시작을 하니 작동은 됩니다만

      게스트 확장 CD 이미지 삽입 및 클립보드 공유 양방향을 해도 복사 붙여넣기가 먹히질 않네요..

      화면도 계속 까맣게 깜빡이는 문제 또한 쓰는데 눈이 아파서 많이 불편합니다.

      무료 프로그램은 어쩔 수 없는가봐요
    • 아니 근데 이거 복사해서 붙여넣기 하는 거 대체 어떻게 해요? 아래에 글 올리신 분 말대로 했는데 안되는데요
    • 4
      대화보기
      • 정은비
        mysql workbench를 사용하면 cmd에서는 사용이 불가능한가요?
      • mysql 업뎃 엄청됬어요
      • TempUser1
        빠른 답변 감사드립니다.
        대화보기
        • egoing
          '과 `은 서로 다른 문자입니다. '은 작은 따옴표이고, `은 grave accent라는 기호로 ~ 아래에 있습니다.
          grave accent는 테이블의 이름과 같은 것을 표현할 때 사용하고,
          따옴표는 값을 문자로 표현할 때 사용합니다.
          grave accent를 테이블 명으로 사용하는 이유는 예를 들어서
          select * from select;
          위와 같이 하면 select라는 테이블의 값을 가져오겠다는 뜻인데
          select라는 테이블은 이미 문법적으로 사용하고 있습니다.
          그래서 select가 문법이 아니라 테이블명이라는 것을 명시적으로 알려줄 때 `를 씁니다.
          대화보기
          • TempUser1
            강의의 샘플코드에는 작은따옴표 처리가 `으로 되어있습니다.
            그러나 제 키보드에서는 작은따옴표를 입력하면 '으로 입력되는데요.

            해당강좌의 샘플코드를 제가 직접치면 에러가 나고,
            붙여넣기를 하면 에러가 안나네요.

            아무리봐도 위의 작은따옴표의 차이말고는 없는 것 같은데,
            위의 문제가 맞다면, 어떻게 입력하는지 또한 알려주시면 감사하겠습니다.
          • 34t3rnull
            아마 올라가는 방법은 없어요. 할 수 있는 방법으로는 엔터를 친 다음 윗 화살표를 눌러 다시 작성하는 방법 밖에 없을 거에요.
            대화보기
            • mysql 모니터에서 입력할때
              엔터를 치면
              ->
              이게 화살표 처럼 나오잖아요
              그런데 이 때 윗줄에서 오타로 작성한 걸 인지하고 다시 올라가고 싶은데 안되면 어떻게 해야하나요?
              예를 들어
              -> insert 어쩌구 저쩌구 오타
              -> 여기 치려다가 위에 오타 발견
              윗줄의 ->로 이동하고 싶으면 어떻게 해야하나요? 찾아봐도 도무지 방법이 나오질 않아요. 도와주세요~
            • 임형준
              김성원님// ' 을 한번 더 입력하고 엔터 쳐보시길...............
            버전 관리
            egoing
            현재 버전
            선택 버전
            graphittie 자세히 보기