본문 바로가기

MySQL6

How to change MySQL in dark mode 1. Find "code_editor.xml" in "C:\Program Files\MySQL\MySQL Workbench 8.0\data"2. Copy and make a backup of "code_editor.xml"3. Check the property/security/authority of "code_editor.xml"4. Copy "code_editor.xml" from the GitHub https://github.com/mleandrojr/mysql-workbench-dark-theme GitHub - mleandrojr/mysql-workbench-dark-theme: A MySQL Workbench dark themeA MySQL Workbench dark theme. Contribu.. 2025. 5. 2.
Basic Exercise -- 데이터 베이스 생성create database db_tenco;-- DB 에서 최소의 정보 단위는 테이블이다-- 테이블 생성하기(column 명과 제약사항을 지정한다)create table userTBL( userName char(3) not null primary key, birthYear int not null, addr char(2) not null, mobile char(12));-- 테이블 정보를 출력해주는 쿼리 구문show tables;-- 테이블 조회select * from userTBL;-- 구매 테이블 만들기create table buyTBL( id int not null auto_increment, userName char(3) not null, prod.. 2025. 5. 2.
DB? DB; Database,= 여러 사람이 함께 사용할 수 있도록 관련된 데이터를 체계적으로 정리하고 저장한 것입니다. 쉽게 말해, 데이터를 공유하고 관리하기 쉽게 모아놓은 잘 정리된 데이터 의 집합입니다. 2025. 5. 2.
Basic MySQL setting and simple things C:\employees> mysql - u root -pmysql> show databases;mysql> source employees.sqlmysql> exit;C:\employees> exit;----------------------------------------------use employees;select * from employees; // print all in employeesselect (column) from employees; // print certain column in employees----------------------------------------------Ctrl + Enter = Run for the cursored line 2025. 5. 1.
System Environment Variable Edit 2025. 5. 1.
How to install MySQL in Windows? https://downloads.mysql.com/archives/installer/ MySQL :: Download MySQL Installer (Archived Versions)Please note that these are old versions. New releases will have recent bug fixes and features! To download the latest release of MySQL Installer, please visit MySQL Downloads. MySQL open source software is provided under the GPL License.downloads.mysql.com 2025. 5. 1.