wasup

SQLyog 설치 https://github.com/webyog/sqlyog-community/wiki/Downloads GitHub - webyog/sqlyog-community: Webyog provides monitoring and management tools for open source relational databases. We devel Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solution... gith..

회원, 게시물 테이블 create DROP DATABASE IF EXISTS mydb1; CREATE DATABASE mydb1; USE mydb1; CREATE TABLE 회원( 번호 int PRIMARY KEY AUTO_INCREMENT, 성명 varchar(20), 주민번호 char(13) ); CREATE TABLE 게시물( 번호 int PRIMARY KEY AUTO_INCREMENT, 제목 varchar(20) NOT NULL UNIQUE, 내용 varchar(200) NULL, 작성자번호 int NOT NULL, 작성일 timestamp DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (작성자번호) REFERENCES 회원(번호) ); insert INSERT INTO 회..

SQL INNER JOIN Keyword www.w3schools.com/sql/sql_join_inner.asp SQL INNER JOIN Keyword SQL INNER JOIN Keyword SQL INNER JOIN Keyword The INNER JOIN keyword selects records that have matching values in both tables. INNER JOIN Syntax SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name; Demo Database I www.w3schools.com mysql 접근 C:\Users\W>docker ps -a CON..

보호되어 있는 글입니다.

JDBC(Java Database Connectivity) https://mvnrepository.com/artifact/mysql/mysql-connector-java 다운로드 후 폴더(lib)생성 -> 다운로드 파일 넣기 설정 Java Build Path > Libraries > Add JARs... > .jar 확인 테스트를 위한 TABLE생성 SHOW TABLES; CREATE TABLE tbl3( col1 int PRIMARY KEY AUTO_INCREMENT, col2 varchar(10) ); SELECT * FROM tbl3; 확인 mysql> SELECT * FROM 회원; +--------+-----------+---------------+ | 번호 | 성명 | 주민번호 | +-----..