Studying programming

MySQL 시작 mysql -u root -p MySQL 비밀번호 입력 **** 전체 db보기 mysql> show databases; 특정 db 로 이동 mysql> use 이름; 이름(); mysql> create table [table name] (); CREATE TABLE customers( id INT NOT NULL AUTO_INCREMENT, name VARCHAR(255) NULL, phone VARCHAR(255) NULL, email VARCHAR(255) NULL, account_num VARCHAR(255) NULL, address VARCHAR(255) NULL, PRIMARY KEY (id) ); 전체 테이블 보기 mysql> show tables; 특정 테이블 보기 mysql..

Mac OS Java 8.0 MySQL 5.7.27 connector 8.0.17 Install MySQL Option 1. Visit MySQL website to download https://dev.mysql.com/downloads/connector/j Option 2. Use Homebrew which is a free and open-source software package management system that simplifies the installation of software on Apple's macOS. Decompress the file. We will use file mysql-connector-java-8.0.17.jar Connecting to JDBC IntelliJ -..