Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
SQL Intro
Search
Nedval
September 24, 2013
Technology
0
93
SQL Intro
Nedval
September 24, 2013
Tweet
Share
More Decks by Nedval
See All by Nedval
if else statement
nedval
0
49
C 程式語言 I
nedval
0
110
軟體測試與驗證—CI & CU
nedval
0
76
Other Decks in Technology
See All in Technology
障害対応をちょっとずつよくしていくための 演習の作りかた
heleeen
1
1.7k
Cracking the KubeCon CfP
inductor
2
270
Microsoft Intune 勉強会 第 2 回目
tamaiyutaro
2
460
BPStudyの200回を中心にIT業界を振り返る。そしてこれから
haru860
3
410
Building a RAG-poweredAI chat appwith Python and VS Code
pamelafox
0
160
いいたいことちゃんという
tkengo
0
240
M5stackで使用できるpHセンサの開発
shinrinakamura
0
200
ルーターでプレゼンする
puhitaku
1
3.3k
require(ESM)とECMAScript仕様
uhyo
4
990
【NW X Security JAWS#3】L3-4:AWS環境のIPv6移行に向けて知っておきたいこと
shotashiratori
1
670
AWS学習者向けにAzureの解説スライドを作成した話
handy
3
200
地理空間データ可視化・解析・活用ソリューション Pacific Spatial Solutions (PSS)
pacificspatialsolutions
0
340
Featured
See All Featured
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
8
1.3k
Fashionably flexible responsive web design (full day workshop)
malarkey
398
65k
For a Future-Friendly Web
brad_frost
172
9k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
chriscoyier
501
140k
A Modern Web Designer's Workflow
chriscoyier
689
190k
Designing the Hi-DPI Web
ddemaree
276
33k
WebSockets: Embracing the real-time Web
robhawkes
59
7k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
21
1.4k
RailsConf 2023
tenderlove
8
560
The Pragmatic Product Professional
lauravandoore
26
5.8k
Art, The Web, and Tiny UX
lynnandtonic
290
19k
YesSQL, Process and Tooling at Scale
rocio
165
13k
Transcript
INTRO 2013/09/23 Tuesday, September 24, 13
認識資料庫相關名詞 Tuesday, September 24, 13
SQL Tuesday, September 24, 13
SEQUEL Tuesday, September 24, 13
Structured English QUEry Language Tuesday, September 24, 13
SQL Tuesday, September 24, 13
Structured Query Language Tuesday, September 24, 13
DBMS vs. DB Tuesday, September 24, 13
DataBase Management System vs. DataBase Tuesday, September 24, 13
DataBase Tuesday, September 24, 13
DataBase DBMS Tuesday, September 24, 13
認識各家 DBMS Tuesday, September 24, 13
Tuesday, September 24, 13
SQL Server Tuesday, September 24, 13
SQL Server IBM DB2 Tuesday, September 24, 13
ORACLE SQL Server IBM DB2 Tuesday, September 24, 13
MySQL ORACLE SQL Server IBM DB2 Tuesday, September 24, 13
MySQL PostgreSQL ORACLE SQL Server IBM DB2 Tuesday, September 24,
13
Tuesday, September 24, 13
SQL 基本指令 part I Tuesday, September 24, 13
SHOW DATABASES SHOW DATABASES; Tuesday, September 24, 13
CREATE DATABASE CREATE DATABASE `mydbname_db` DEFAULT CHARACTER SET `utf8` DEFAULT
COLLATE `utf8_unicode_ci`; Tuesday, September 24, 13
USE USE `mydbname_db`; Tuesday, September 24, 13
CREATE TABLE CREATE TABLE `students` ( `sid` CHAR(7) NOT NULL,
`name` VARCHAR(20) NOT NULL, `mobile` VARCHAR(20) NOT NULL, `sex` CHAR(1), `birth` DATE, `address` VARCHAR(255) ); Tuesday, September 24, 13
§ 實作時間 § Tuesday, September 24, 13
SQL 基本指令 part ][ Tuesday, September 24, 13
I. S. U. D. Tuesday, September 24, 13
Insert Select Update Delete Tuesday, September 24, 13
INSERT INTO INSERT INTO `students` ( `sid`, `name`, `mobile` )
VALUES ( '1003800', '無名仕', '0987654321' ); Tuesday, September 24, 13
SELECT FROM WHERE SELECT * FROM `students` WHERE `sid` =
'1003800'; Tuesday, September 24, 13
UPDATE SET WHERE UPDATE `students` SET `name` = '⾦金城武', `mobile`
= '0988776655' WHERE `sid` = '1003800'; Tuesday, September 24, 13
DELETE FROM WHERE DELETE FROM `students` WHERE `sid` = '1003800';
Tuesday, September 24, 13
§ 實作時間 § Tuesday, September 24, 13