July 2021
Intermediate to advanced
376 pages
6h 34m
Japanese
Content preview from 初めてのSQL 第3版Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
2章データベースの作成と設定
本章では、あなたにとって最初のデータベースを作成するために必要な情報と、本書の例で用いるテーブルとそのデータを作成するために必要な情報を提供します。また、さまざまなデータ型を紹介し、それらのデータ型を使ってテーブルを作成する方法も確認します。本書の例はMySQLデータベースで実行することを想定したものなので、MySQLの機能や構文に少し偏った内容になっていますが、ほとんどの概念はすべてのデータベースサーバーに共通するものです。
2.1 MySQLデータベースを作成する
本書の例と同じデータを使って実際に試してみたい場合は、次の2つの選択肢があります。
- MySQL 8.0（以降）をダウンロードしてインストールし、Sakilaサンプルデータベース†1を読み込む。
- MySQL Sandbox†2にアクセスする。MySQL Sandboxは、Sakilaサンプルデータベースが読み込まれたMySQLインスタンスである。Katacodaアカウントをセットアップした後（無償）、［Start Scenario］ボタンをクリックする。
[†2] https://www.katacoda.com/mysql-db-sandbox/scenarios/mysql-sandbox【第2刷追記】katacoda.comはサービスを終了したので、新しいMySQL Sandboxであるhttps://learning.oreilly.com/scenarios/mysql-sandbox/9781492079705にアクセスすること（オライリーアカウントが必要）。
2つ目の方法を選択した場合は、次のようになります。シナリオを開始すると、MySQLサーバーがインストールされ、起動したMySQLサーバーにSakilaスキーマとデータが読み込まれます。準備が整ったところで、標準の ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.