mossycode

  • 홈
  • 태그
  • 방명록

Database & SQL 3

HeidiSQL: sql commands and functions

Today we did a further dive on HeidiSQLand learnt more of its commands and functions Did you know SQL is text-based? it will export all of its files in .txt format!! radical :3How SQL reads and processes commandsthis is the order the DB reads its SQL commands:           3                4              1                2   command  selection    location  table name    SELECT         *            ..

Database & SQL 2024.07.20

Accessing DB through cmd

a quick and fun tutorial on how to access DB: hacker style :3 1.) open cmd and find the DB file   some useful CMD keywords to use:cd..: it means to go back a directory.you can see everytime we enter it we went back a space, from user1 > Users > C:/ drive dir:  see a list of all directories when you want to know where to go! 2.) find the DB bin where everything is stored 3.) log into DB and creat..

Database & SQL 2024.07.20

Setting up MariaDB, Heidi SQL

If we want to manage and oversea a database, we can use MariaDB to do just that.https://mariadb.com/downloads/ MariaDB Products & Tools Downloads | MariaDBFind MariaDB downloads, connectors, and tools including Community Server, Enterprise Server, ColumnStore, MaxScale and Xpand.mariadb.com1.) select mariaDB community and select version 11.4.2-GA and windows 64 version before clicking download2...

Database & SQL 2024.07.19
이전
1
다음
더보기
프로필사진

mossycode

  • 분류 전체보기 (23)
    • Javascript (5)
    • JAVA (11)
    • Solving Algorithms (1)
    • personal achievements (1)
    • JSP (2)
    • Database & SQL (3)
    • AWS (0)
    • REACT (0)
    • Spring (0)

Tag

최근글과 인기글

  • 최근글
  • 인기글

최근댓글

공지사항

페이스북 트위터 플러그인

  • Facebook
  • Twitter

Archives

Calendar

«   2025/06   »
일 월 화 수 목 금 토
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30

방문자수Total

  • Today :
  • Yesterday :
졸리고 슬프지만 짜맀ㅎ...

help meh....

티스토리툴바