목록Data/SQL (27)

짜리몽땅 매거진

[SQL] CREATE, INSERT INTO VALUES, SELECT FROM

CREATE DATABASE pokemon; USE pokemon; CREATE TABLE mypokemon ( number int, name varchar(20), type varchar(20), height float, weight float, attack float, defense float, speed float ); INSERT INTO mypokemon (number, name, type, height, weight, attack, defense, speed) VALUES (10, 'caterpie', 'bug', 0.3, 2.9, 30, 35, 45), (25, 'pikachu', 'electric', 0.4, 6, 55, 40, 90), (26, 'raichu', 'electric', 0...
Data/SQL 2023. 8. 9. 14:55
[SQL] draw.io를 이용해 ERD그려보기-개념적 데이터모델링

https://drive.google.com/file/d/1UHIduOEA3TNGjyHjisK09RQr2gwzidZt/view?usp=drive_link
Data/SQL 2023. 8. 3. 17:31
[SQL] SQL JOIN 연습하기

* 코드에 의한 출력 결과는 시트 참고 Google Sheets: 로그인 이메일 또는 휴대전화 accounts.google.com 1. 테이블 생성 코드 CREATE TABLE `author` ( `aid` int(11) NOT NULL, `name` varchar(10) DEFAULT NULL, `city` varchar(10) DEFAULT NULL, `profile_id` int(11) DEFAULT NULL, PRIMARY KEY (`aid`) ) INSERT INTO `author` VALUES (1,'egoing','seoul',1),(2,'leezche','jeju',2),(3,'blackdew','namhae',3); CREATE TABLE `profile` ( `pid` int(11) N..
Data/SQL 2023. 7. 27. 16:14
이전 Prev 1 2 3 4 Next 다음