{"id":25,"date":"2022-10-25T15:01:57","date_gmt":"2023-01-29T00:52:08","guid":{"rendered":"https:\/\/www.silicloud.com\/ja\/blog\/index.php\/2023\/11\/30\/sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82\/"},"modified":"2025-07-31T10:25:27","modified_gmt":"2025-07-31T01:25:27","slug":"sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/ja\/blog\/sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82\/","title":{"rendered":"SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002 &#8211; \u30b9\u30c6\u30c3\u30d7\u30d0\u30a4\u30b9\u30c6\u30c3\u30d7"},"content":{"rendered":"<p>\u7b46\u8005\u306f\u3001Write for Donations\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u4e00\u74b0\u3068\u3057\u3066\u3001\u5bc4\u4ed8\u91d1\u3092\u53d7\u3051\u308b\u305f\u3081\u306bDiversity in Tech Fund\u3092\u9078\u3073\u307e\u3057\u305f\u3002<\/p>\n<h3>\u30a4\u30f3\u30c8\u30ed\u30c0\u30af\u30b7\u30e7\u30f3<\/h3>\n<p>\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u8cb4\u91cd\u306a\u7279\u5fb4\u306e\u4e00\u3064\u306f\u3001\u30c7\u30fc\u30bf\u3092\u660e\u78ba\u306b\u5b9a\u7fa9\u3055\u308c\u305f\u69cb\u9020\u306b\u6574\u5f62\u3059\u308b\u3053\u3068\u3067\u3059\u3002\u3053\u306e\u69cb\u9020\u306f\u3001\u56fa\u5b9a\u3055\u308c\u305f\u5217\u3092\u6301\u3064\u30c6\u30fc\u30d6\u30eb\u3092\u4f7f\u7528\u3057\u3001\u53b3\u5bc6\u306b\u5b9a\u7fa9\u3055\u308c\u305f\u30c7\u30fc\u30bf\u578b\u3092\u9075\u5b88\u3057\u3001\u5404\u884c\u304c\u540c\u3058\u5f62\u3092\u6301\u3064\u3088\u3046\u306b\u3059\u308b\u3053\u3068\u3067\u5b9f\u73fe\u3055\u308c\u307e\u3059\u3002\u30c7\u30fc\u30bf\u3092\u30c6\u30fc\u30d6\u30eb\u306e\u884c\u3068\u3057\u3066\u4fdd\u5b58\u3059\u308b\u969b\u306b\u306f\u3001\u305d\u308c\u3089\u3092\u660e\u78ba\u306b\u7279\u5b9a\u3057\u3001\u66d6\u6627\u3055\u306a\u304f\u53c2\u7167\u3059\u308b\u3053\u3068\u304c\u540c\u3058\u304f\u91cd\u8981\u3067\u3059\u3002\u69cb\u9020\u5316\u30af\u30a8\u30ea\u8a00\u8a9e\uff08SQL\uff09\u3067\u306f\u3001\u3053\u308c\u306f\u500b\u3005\u306e\u884c\u3092\u30c6\u30fc\u30d6\u30eb\u5185\u3067\u8b58\u5225\u3059\u308b\u305f\u3081\u306e\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3067\u5b9f\u73fe\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u3001\u4e3b\u30ad\u30fc\u306b\u3064\u3044\u3066\u5b66\u3073\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u30e6\u30cb\u30fc\u30af\u306a\u884c\u3092\u7279\u5b9a\u3059\u308b\u305f\u3081\u306b\u3044\u304f\u3064\u304b\u306e\u7570\u306a\u308b\u7a2e\u985e\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002\u3044\u304f\u3064\u304b\u306e\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u3092\u4f7f\u7528\u3057\u3066\u3001\u5358\u4e00\u306e\u5217\u3084\u8907\u6570\u306e\u5217\u3001\u81ea\u52d5\u9023\u756a\u306e\u30ad\u30fc\u306b\u4e3b\u30ad\u30fc\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<h2>\u524d\u63d0\u6761\u4ef6 (\u305c\u3093\u3066\u3044\u3058\u3087\u3046\u3051\u3093)<\/h2>\n<p>\u3053\u306e\u30ac\u30a4\u30c9\u306b\u5f93\u3046\u306b\u306f\u3001SQL\u30d9\u30fc\u30b9\u306e\u95a2\u4fc2\u578b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\uff08RDBMS\uff09\u3092\u5b9f\u884c\u3059\u308b\u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u304c\u5fc5\u8981\u3067\u3059\u3002\u3053\u306e\u30ac\u30a4\u30c9\u306e\u624b\u9806\u3084\u4f8b\u306f\u3001\u4ee5\u4e0b\u306e\u74b0\u5883\u3067\u691c\u8a3c\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n<ul class=\"post-ul\">\n<li>A server running Ubuntu 20.04, with a non-root user with administrative privileges and a firewall configured with UFW, as described in our initial server setup guide for Ubuntu 20.04.<\/li>\n<li>MySQL installed and secured on the server, as outlined in How To Install MySQL on Ubuntu 20.04. This guide was verified with a non-root MySQL user, created using the process described in Step 3.<\/li>\n<li>Basic familiarity with executing SELECT queries to retrieve data from the database as described in our How To SELECT Rows FROM Tables in SQL guide.<\/li>\n<\/ul>\n<div class=\"post-conf-note\">\n<p class=\"post-conf-desc\">Note<\/p>\n<div>\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u591a\u304f\u306eRDBMS\u306f\u72ec\u81ea\u306eSQL\u5b9f\u88c5\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u3053\u3068\u306b\u6ce8\u610f\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u8aac\u660e\u3055\u308c\u3066\u3044\u308b\u30b3\u30de\u30f3\u30c9\u306f\u3001\u307b\u3068\u3093\u3069\u306eRDBMS\u3067\u6a5f\u80fd\u3057\u3001\u4e3b\u30ad\u30fc\u306fSQL\u306e\u6a19\u6e96\u306e\u4e00\u90e8\u3067\u3059\u304c\u3001\u4e00\u90e8\u306e\u6a5f\u80fd\u306f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u56fa\u6709\u3067\u3042\u308a\u3001\u305d\u306e\u305f\u3081\u306b\u4ed6\u306eMySQL\u4ee5\u5916\u306e\u30b7\u30b9\u30c6\u30e0\u3067\u30c6\u30b9\u30c8\u3059\u308b\u5834\u5408\u306f\u3001\u6b63\u78ba\u306a\u69cb\u6587\u3084\u51fa\u529b\u304c\u7570\u306a\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002<\/div>\n<\/div>\n<p>\u4ee5\u4e0b\u306e\u30cd\u30a4\u30c6\u30a3\u30d6\u306a\u65e5\u672c\u8a9e\u306e1\u3064\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u3066\u8a00\u3044\u63db\u3048\u3066\u304f\u3060\u3055\u3044\uff1a<br \/>\n\u3042\u306a\u305f\u306f\u307e\u305f\u3001\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u306e\u4f7f\u7528\u3092\u793a\u3059\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3067\u304d\u308b\u7a7a\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u5fc5\u8981\u3067\u3059\u3002\u3053\u306e\u30ac\u30a4\u30c9\u5168\u4f53\u306e\u4f8b\u3067\u4f7f\u7528\u3055\u308c\u308b\u30c6\u30b9\u30c8\u7528\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306eMySQL\u30b5\u30fc\u30d0\u30fc\u3078\u306e\u63a5\u7d9a\u3068\u8a2d\u5b9a\u306b\u95a2\u3059\u308b\u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u300cMySQL\u3078\u306e\u63a5\u7d9a\u3068\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u8a2d\u5b9a\u300d\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3092\u53c2\u7167\u3059\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002<\/p>\n<h2>MySQL\u306b\u63a5\u7d9a\u3057\u3066\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u8a2d\u5b9a\u3059\u308b\u3002<\/h2>\n<p>\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001MySQL\u30b5\u30fc\u30d0\u30fc\u306b\u63a5\u7d9a\u3057\u3001\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u3067\u3001\u3053\u306e\u30ac\u30a4\u30c9\u306e\u4f8b\u306b\u5f93\u3046\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u3082\u3057SQL\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b7\u30b9\u30c6\u30e0\u304c\u30ea\u30e2\u30fc\u30c8\u30b5\u30fc\u30d0\u30fc\u4e0a\u3067\u7a3c\u50cd\u3057\u3066\u3044\u308b\u5834\u5408\u3001\u30ed\u30fc\u30ab\u30eb\u30de\u30b7\u30f3\u304b\u3089\u30b5\u30fc\u30d0\u30fc\u306bSSH\u63a5\u7d9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"$\"><span class=\"token function\">ssh<\/span> <mark>sammy<\/mark>@<mark>your_server_ip<\/mark><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u305d\u306e\u5f8c\u3001MySQL\u30b5\u30fc\u30d0\u30fc\u30d7\u30ed\u30f3\u30d7\u30c8\u3092\u958b\u304d\u3001MySQL\u30e6\u30fc\u30b6\u30fc\u30a2\u30ab\u30a6\u30f3\u30c8\u306e\u540d\u524d\u3067\u3042\u308b&#8221; sammy &#8220;\u3092\u5165\u529b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"$\">mysql <span class=\"token parameter variable\">-u<\/span> <mark>sammy<\/mark> <span class=\"token parameter variable\">-p<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u300cprimary_keys\u300d\u3068\u3044\u3046\u540d\u524d\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">CREATE DATABASE <mark>primary_keys<\/mark><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u6b63\u5e38\u306b\u4f5c\u6210\u3055\u308c\u305f\u5834\u5408\u3001\u6b21\u306e\u3088\u3046\u306a\u51fa\u529b\u3092\u53d7\u3051\u53d6\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>Query OK, 1 row affected (0.01 sec)<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u4e3b\u30ad\u30fc\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u9078\u629e\u3059\u308b\u306b\u306f\u3001\u6b21\u306eUSE\u6587\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"$\">USE <mark>primary_keys<\/mark><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u6b21\u306e\u51fa\u529b\u3092\u53d7\u3051\u53d6\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>Database changed<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u9078\u629e\u3057\u305f\u5f8c\u3001\u305d\u306e\u5185\u90e8\u306b\u30b5\u30f3\u30d7\u30eb\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u305d\u308c\u3067\u306f\u3001\u30ac\u30a4\u30c9\u306e\u6b8b\u308a\u306e\u90e8\u5206\u306b\u5f93\u3044\u3001MySQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u3063\u305f\u4f5c\u696d\u3092\u59cb\u3081\u308b\u6e96\u5099\u304c\u6574\u3044\u307e\u3057\u305f\u3002<\/p>\n<h2>\u4e3b\u30ad\u30fc\u306b\u3064\u3044\u3066\u306e\u6982\u8981<\/h2>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u30c7\u30fc\u30bf\u306f\u3001\u500b\u3005\u306e\u884c\u306e\u7279\u5b9a\u3067\u7d71\u4e00\u7684\u306a\u69cb\u9020\u3092\u6301\u3064\u30c6\u30fc\u30d6\u30eb\u306b\u683c\u7d0d\u3055\u308c\u307e\u3059\u3002\u30c6\u30fc\u30d6\u30eb\u306e\u5b9a\u7fa9\u306b\u306f\u3001\u3069\u306e\u3088\u3046\u306a\u5217\u304c\u3042\u308b\u304b\u3001\u500b\u3005\u306e\u5217\u306b\u4fdd\u5b58\u3067\u304d\u308b\u30c7\u30fc\u30bf\u578b\u304c\u8a18\u8ff0\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u3060\u3051\u3067\u3082\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5185\u306e\u60c5\u5831\u3092\u683c\u7d0d\u3057\u3001\u5f8c\u3067WHERE\u53e5\u3092\u4f7f\u7528\u3057\u3066\u7570\u306a\u308b\u30d5\u30a3\u30eb\u30bf\u30ea\u30f3\u30b0\u6761\u4ef6\u3092\u4f7f\u3063\u3066\u691c\u7d22\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u305f\u3060\u3057\u3001\u3053\u306e\u69cb\u9020\u3067\u306f1\u3064\u306e\u884c\u3092\u660e\u78ba\u306b\u898b\u3064\u3051\u308b\u53ef\u80fd\u6027\u3092\u4fdd\u8a3c\u3057\u307e\u305b\u3093\u3002<\/p>\n<p>\u516c\u9053\u3092\u8d70\u884c\u3059\u308b\u3053\u3068\u304c\u8a31\u53ef\u3055\u308c\u3066\u3044\u308b\u5168\u767b\u9332\u8eca\u4e21\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u60f3\u50cf\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u306f\u3001\u8eca\u306e\u30d6\u30e9\u30f3\u30c9\u3001\u30e2\u30c7\u30eb\u3001\u88fd\u9020\u5e74\u3001\u5857\u88c5\u306e\u8272\u306a\u3069\u306e\u60c5\u5831\u304c\u542b\u307e\u308c\u307e\u3059\u3002\u305f\u3060\u3057\u30012007\u5e74\u88fd\u306e\u8d64\u3044\u30b7\u30dc\u30ec\u30fc\u30ab\u30de\u30ed\u3092\u63a2\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u8907\u6570\u306e\u8eca\u304c\u898b\u3064\u304b\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\u306a\u305c\u306a\u3089\u3001\u81ea\u52d5\u8eca\u30e1\u30fc\u30ab\u30fc\u306f\u4f3c\u305f\u3088\u3046\u306a\u8eca\u7a2e\u3092\u8907\u6570\u306e\u9867\u5ba2\u306b\u8ca9\u58f2\u3059\u308b\u304b\u3089\u3067\u3059\u3002\u305d\u306e\u305f\u3081\u3001\u767b\u9332\u8eca\u306b\u306f\u8eca\u4e21\u3054\u3068\u306b\u56fa\u6709\u306e\u30ca\u30f3\u30d0\u30fc\u30d7\u30ec\u30fc\u30c8\u756a\u53f7\u304c\u5272\u308a\u5f53\u3066\u3089\u308c\u3066\u3044\u307e\u3059\u3002\u3082\u3057\u3082\u3001\u30ca\u30f3\u30d0\u30fc\u30d7\u30ec\u30fc\u30c8\u304c\u300cOFP857\u300d\u306e\u8eca\u3092\u8abf\u3079\u305f\u5834\u5408\u3001\u3053\u306e\u57fa\u6e96\u3067\u306f\u305f\u30601\u53f0\u306e\u8eca\u304c\u898b\u3064\u304b\u308b\u3053\u3068\u304c\u78ba\u5b9f\u3067\u3059\u3002\u306a\u305c\u306a\u3089\u3001\u6cd5\u5f8b\u3067\u30ca\u30f3\u30d0\u30fc\u30d7\u30ec\u30fc\u30c8\u756a\u53f7\u304c\u767b\u9332\u8eca\u4e21\u3092\u4e00\u610f\u306b\u7279\u5b9a\u3059\u308b\u3082\u306e\u3068\u3055\u308c\u3066\u3044\u308b\u304b\u3089\u3067\u3059\u3002\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u306f\u3001\u3053\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u306e\u3053\u3068\u3092\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3068\u547c\u3073\u307e\u3059\u3002<\/p>\n<p>\u4e3b\u30ad\u30fc\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb\u306e\u5404\u884c\u3092\u4e00\u610f\u306b\u7279\u5b9a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3001\u5358\u4e00\u306e\u5217\u307e\u305f\u306f\u8907\u6570\u306e\u5217\u306b\u5b58\u5728\u3059\u308b\u4e00\u610f\u306e\u8b58\u5225\u5b50\u3067\u3059\u3002\u4e3b\u30ad\u30fc\u306f\u3001\u3044\u304f\u3064\u304b\u306e\u30eb\u30fc\u30eb\u306b\u3088\u3063\u3066\u6280\u8853\u7684\u306a\u7279\u6027\u304c\u53cd\u6620\u3055\u308c\u307e\u3059\u3002<\/p>\n<ul class=\"post-ul\">\n<li>A primary key must use unique values. If the primary key consists of more than one column, the combination of values in these columns must be unique across the whole table. Since the key is meant to identify every row uniquely, it can\u2019t appear more than once.<\/li>\n<li>A primary key must not contain NULL values.<\/li>\n<li>Each database table can use only one primary key.<\/li>\n<\/ul>\n<p>\u30c6\u30fc\u30d6\u30eb\u306b\u4e3b\u30ad\u30fc\u304c\u5b9a\u7fa9\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a8\u30f3\u30b8\u30f3\u306f\u3053\u308c\u3089\u306e\u30eb\u30fc\u30eb\u3092\u5f37\u5236\u3059\u308b\u305f\u3081\u3001\u305d\u308c\u3089\u306e\u7279\u6027\u304c\u771f\u3067\u3042\u308b\u3053\u3068\u3092\u4fe1\u983c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u3053\u308c\u3089\u306e\u6280\u8853\u7684\u306a\u7279\u6027\u306b\u52a0\u3048\u3066\u3001\u30c7\u30fc\u30bf\u306e\u5185\u5bb9\u3082\u8003\u616e\u3057\u3066\u3001\u3069\u306e\u3088\u3046\u306a\u30c7\u30fc\u30bf\u304c\u4e3b\u30ad\u30fc\u306b\u9069\u3057\u305f\u9078\u629e\u80a2\u304b\u3092\u6c7a\u3081\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u30ca\u30c1\u30e5\u30e9\u30eb\u30ad\u30fc\u306f\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u5185\u3067\u65e2\u306b\u5b58\u5728\u3059\u308b\u8b58\u5225\u5b50\u3067\u3042\u308a\u3001\u30b5\u30ed\u30b2\u30fc\u30c8\u30ad\u30fc\u306f\u4eba\u5de5\u7684\u306b\u4f5c\u3089\u308c\u305f\u8b58\u5225\u5b50\u3067\u3059\u3002<\/p>\n<p>\u4e00\u90e8\u306e\u30c7\u30fc\u30bf\u69cb\u9020\u306b\u306f\u3001\u81ea\u7136\u306b\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u5185\u306b\u5b58\u5728\u3059\u308b\u4e3b\u30ad\u30fc\u304c\u3042\u308a\u307e\u3059\u3002\u4f8b\u3048\u3070\u3001\u8eca\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u306f\u30ca\u30f3\u30d0\u30fc\u30d7\u30ec\u30fc\u30c8\u756a\u53f7\u3084\u30a2\u30e1\u30ea\u30ab\u5e02\u6c11\u306e\u540d\u7c3f\u3067\u306f\u793e\u4f1a\u4fdd\u969c\u756a\u53f7\u306a\u3069\u304c\u3042\u308a\u307e\u3059\u3002\u6642\u306b\u306f\u3053\u308c\u3089\u306e\u8b58\u5225\u5b50\u306f\u5358\u4e00\u306e\u5024\u3067\u306f\u306a\u304f\u3001\u8907\u6570\u306e\u5024\u306e\u7d44\u307f\u5408\u308f\u305b\u3067\u3042\u308b\u5834\u5408\u3082\u3042\u308a\u307e\u3059\u3002\u4f8b\u3048\u3070\u3001\u5730\u5143\u306e\u4f4f\u5b85\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3067\u306f\u3001\u5358\u306b\u901a\u308a\u306e\u540d\u524d\u3084\u756a\u53f7\u3060\u3051\u3067\u306f\u5bb6\u3092\u4e00\u610f\u306b\u7279\u5b9a\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3002\u540c\u3058\u901a\u308a\u306b\u306f\u8907\u6570\u306e\u5bb6\u304c\u5b58\u5728\u3059\u308b\u304b\u3001\u540c\u3058\u756a\u53f7\u304c\u8907\u6570\u306e\u901a\u308a\u306b\u5b58\u5728\u3059\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002\u3057\u304b\u3057\u3001\u901a\u308a\u306e\u540d\u524d\u3068\u756a\u53f7\u306e\u7d44\u307f\u5408\u308f\u305b\u306a\u3089\u3070\u3001\u4e00\u610f\u306e\u5bb6\u306e\u8b58\u5225\u5b50\u3068\u306a\u308a\u5f97\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u81ea\u7136\u306b\u767a\u751f\u3059\u308b\u8b58\u5225\u5b50\u3092\u300c\u30ca\u30c1\u30e5\u30e9\u30eb\u30ad\u30fc\u300d\u3068\u547c\u3073\u307e\u3059\u3002<\/p>\n<p>\u3057\u304b\u3057\u3001\u3057\u3070\u3057\u3070\u30c7\u30fc\u30bf\u306f\u5358\u4e00\u306e\u5217\u306e\u5024\u307e\u305f\u306f\u5c0f\u3055\u306a\u30b5\u30d6\u30bb\u30c3\u30c8\u306e\u5217\u306e\u5024\u3060\u3051\u3067\u306f\u4e00\u610f\u306b\u7279\u5b9a\u3067\u304d\u306a\u3044\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\u305d\u306e\u5834\u5408\u3001\u4f8b\u3048\u3070\u6570\u306e\u9023\u7d9a\u3084\u30e9\u30f3\u30c0\u30e0\u306b\u751f\u6210\u3055\u308c\u305f\u8b58\u5225\u5b50\uff08UUID\u306a\u3069\uff09\u3092\u4f7f\u7528\u3057\u3066\u3001\u4eba\u5de5\u7684\u306a\u4e3b\u30ad\u30fc\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002\u3053\u306e\u3088\u3046\u306a\u30ad\u30fc\u306f\u4ee3\u7406\u30ad\u30fc\u3068\u547c\u3070\u308c\u307e\u3059\u3002<\/p>\n<p>\u4ee5\u4e0b\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u5358\u4e00\u306e\u5217\u307e\u305f\u306f\u8907\u6570\u306e\u5217\u306b\u57fa\u3065\u3044\u3066\u81ea\u7136\u30ad\u30fc\u3092\u4f5c\u6210\u3057\u3001\u81ea\u7136\u30ad\u30fc\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u306a\u3044\u30c6\u30fc\u30d6\u30eb\u306b\u5bfe\u3057\u3066\u30b5\u30ed\u30b2\u30fc\u30c8\u30ad\u30fc\u3092\u751f\u6210\u3057\u307e\u3059\u3002<\/p>\n<h2>\u5358\u4e00\u306e\u5217\u306b\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3092\u4f5c\u6210\u3059\u308b<\/h2>\n<p>\u591a\u304f\u306e\u5834\u5408\u3001\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306b\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u884c\u3092\u4e00\u610f\u306b\u8b58\u5225\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3067\u304d\u308b\u5358\u4e00\u306e\u5217\u304c\u81ea\u7136\u306b\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u5834\u5408\u3001\u30c7\u30fc\u30bf\u3092\u8aac\u660e\u3059\u308b\u305f\u3081\u306b\u81ea\u7136\u30ad\u30fc\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u767b\u9332\u3055\u308c\u305f\u8eca\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u5148\u307b\u3069\u306e\u4f8b\u306b\u7d9a\u3044\u3066\u3001\u6b21\u306e\u69cb\u9020\u3092\u6301\u3064\u30c6\u30fc\u30d6\u30eb\u3092\u60f3\u50cf\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Sample table\">Sample table<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+&#8212;&#8212;+ | <mark>license_plate<\/mark> | brand | model | color | year | +&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+&#8212;&#8212;+ | <mark>ABC123<\/mark> | Ford | Mustang | Red | 2018 | | <mark>CES214<\/mark> | Ford | Mustang | Red | 2018 | | DEF456 | Chevrolet | Camaro | Blue | 2016 | | GHI789 | Dodge | Challenger | Black | 2014 | +&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+&#8212;&#8212;+<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u6700\u521d\u30682\u756a\u76ee\u306e\u884c\u306f\u3001\u3068\u3082\u306b2018\u5e74\u88fd\u306e\u8d64\u3044\u30d5\u30a9\u30fc\u30c9\u30fb\u30de\u30b9\u30bf\u30f3\u30b0\u3092\u8aac\u660e\u3057\u3066\u3044\u307e\u3059\u3002\u8eca\u306e\u30e1\u30fc\u30ab\u30fc\u3068\u30e2\u30c7\u30eb\u3060\u3051\u3067\u306f\u3001\u8eca\u3092\u72ec\u81ea\u306b\u8b58\u5225\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3002\u4e21\u65b9\u306e\u5834\u5408\u3001\u30ca\u30f3\u30d0\u30fc\u30d7\u30ec\u30fc\u30c8\u304c\u7570\u306a\u3063\u3066\u304a\u308a\u3001\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u5404\u884c\u306b\u5bfe\u3057\u3066\u826f\u3044\u4e00\u610f\u306e\u8b58\u5225\u5b50\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002\u30ca\u30f3\u30d0\u30fc\u30d7\u30ec\u30fc\u30c8\u756a\u53f7\u306f\u65e2\u306b\u30c7\u30fc\u30bf\u306e\u4e00\u90e8\u3068\u306a\u3063\u3066\u3044\u308b\u305f\u3081\u3001\u305d\u308c\u3092\u4e3b\u30ad\u30fc\u3068\u3057\u3066\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u81ea\u7136\u306a\u30ad\u30fc\u304c\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002\u30ca\u30f3\u30d0\u30fc\u30d7\u30ec\u30fc\u30c8\u5217\u306b\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u305b\u305a\u306b\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b\u3068\u3001\u3044\u3064\u304b\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306b\u91cd\u8907\u307e\u305f\u306f\u7a7a\u306e\u30d7\u30ec\u30fc\u30c8\u304c\u8868\u793a\u3055\u308c\u308b\u30ea\u30b9\u30af\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u6b21\u306b\u3001\u4e0a\u8a18\u306e\u30c6\u30fc\u30d6\u30eb\u306b\u4f3c\u305f\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u305d\u306e\u969b\u3001license_plate\u5217\u3092\u4e3b\u30ad\u30fc\u3068\u3057\u3066\u4f7f\u7528\u3057\u3001\u4ee5\u4e0b\u306e\u5217\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n<ul class=\"post-ul\">\n<li>license_plate: This column holds the license plate number, represented by the varchar data type.<\/li>\n<li>brand: This column holds the brand of the car, expressed using the varchar data type with a maximum of 50 characters.<\/li>\n<li>model: This column holds the car\u2019s model, expressed using the varchar data type with a maximum of 50 characters.<\/li>\n<li>color: This column holds the color, expressed using the varchar data type with a maximum of 20 characters.<\/li>\n<li>year: This column holds the year the car was made, expressed using the int data type to store numerical data.<\/li>\n<\/ul>\n<p>\u300ccars\u300d\u3068\u3044\u3046\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306b\u3001\u6b21\u306eSQL\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">CREATE TABLE cars <span class=\"token punctuation\">(<\/span><\/li>\n<li data-prefix=\"mysql&gt;\">license_plate varchar<span class=\"token punctuation\">(<\/span><span class=\"token number\">8<\/span><span class=\"token punctuation\">)<\/span> <mark>PRIMARY KEY<\/mark>,<\/li>\n<li data-prefix=\"mysql&gt;\">brand varchar<span class=\"token punctuation\">(<\/span><span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\">model varchar<span class=\"token punctuation\">(<\/span><span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\">color varchar<span class=\"token punctuation\">(<\/span><span class=\"token number\">20<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\">year int<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>PRIMARY KEY\u306e\u7bc0\u306f\u3001license_plate\u30c7\u30fc\u30bf\u578b\u306e\u5b9a\u7fa9\u306e\u5f8c\u306b\u7d9a\u304d\u307e\u3059\u3002\u5358\u4e00\u306e\u5217\u306b\u57fa\u3065\u304f\u4e3b\u30ad\u30fc\u3092\u6271\u3046\u5834\u5408\u306f\u3001\u30ad\u30fc\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306b\u7c21\u7565\u306a\u69cb\u6587\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u3053\u306e\u5834\u5408\u3001\u5217\u306e\u5b9a\u7fa9\u306bPRIMARY KEY\u3092\u8a18\u8ff0\u3057\u307e\u3059\u3002<\/p>\n<p>\u3082\u3057\u4ee5\u4e0b\u306e\u51fa\u529b\u304c\u8868\u793a\u3055\u308c\u305f\u5834\u5408\u3001\u30c6\u30fc\u30d6\u30eb\u304c\u4f5c\u6210\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>Query OK, 0 rows affected (0.00 sec)<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u305d\u308c\u306b\u7d9a\u3044\u3066\u3001\u4ee5\u4e0b\u306eINSERT INTO\u64cd\u4f5c\u3092\u5b9f\u884c\u3057\u3066\u3001\u4e0a\u8a18\u306e\u4f8b\u306b\u793a\u3055\u308c\u3066\u3044\u308b\u30b5\u30f3\u30d7\u30eb\u884c\u3092\u30c6\u30fc\u30d6\u30eb\u306b\u30ed\u30fc\u30c9\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">INSERT INTO cars VALUES<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;ABC123&#8217;<\/span>, <span class=\"token string\">&#8216;Ford&#8217;<\/span>, <span class=\"token string\">&#8216;Mustang&#8217;<\/span>, <span class=\"token string\">&#8216;Red&#8217;<\/span>, <span class=\"token number\">2018<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;CES214&#8217;<\/span>, <span class=\"token string\">&#8216;Ford&#8217;<\/span>, <span class=\"token string\">&#8216;Mustang&#8217;<\/span>, <span class=\"token string\">&#8216;Red&#8217;<\/span>, <span class=\"token number\">2018<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;DEF456&#8217;<\/span>, <span class=\"token string\">&#8216;Chevrolet&#8217;<\/span>, <span class=\"token string\">&#8216;Camaro&#8217;<\/span>, <span class=\"token string\">&#8216;Blue&#8217;<\/span>, <span class=\"token number\">2016<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;GHI789&#8217;<\/span>, <span class=\"token string\">&#8216;Dodge&#8217;<\/span>, <span class=\"token string\">&#8216;Challenger&#8217;<\/span>, <span class=\"token string\">&#8216;Black&#8217;<\/span>, <span class=\"token number\">2014<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u6210\u529f\u30e1\u30c3\u30bb\u30fc\u30b8\u3067\u5fdc\u7b54\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>Query OK, 4 rows affected (0.010 sec) Records: 4 Duplicates: 0 Warnings: 0<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u65b0\u3057\u304f\u4f5c\u6210\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u306b\u3001\u4e88\u60f3\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3068\u5f62\u5f0f\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u304b\u3092\u3001SELECT\u6587\u3092\u4f7f\u7528\u3057\u3066\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">SELECT * FROM cars<span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u51fa\u529b\u306f\u3001\u30bb\u30af\u30b7\u30e7\u30f3\u306e\u6700\u521d\u306b\u3042\u308b\u30c6\u30fc\u30d6\u30eb\u3068\u4f3c\u305f\u3088\u3046\u306a\u3082\u306e\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+&#8212;&#8212;+ | license_plate | brand | model | color | year | +&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+&#8212;&#8212;+ | ABC123 | Ford | Mustang | Red | 2018 | | CES214 | Ford | Mustang | Red | 2018 | | DEF456 | Chevrolet | Camaro | Blue | 2016 | | GHI789 | Dodge | Challenger | Black | 2014 | +&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;-+&#8212;&#8212;+<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u6b21\u306b\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a8\u30f3\u30b8\u30f3\u306b\u3088\u3063\u3066\u4e3b\u30ad\u30fc\u306e\u30eb\u30fc\u30eb\u304c\u4fdd\u8a3c\u3055\u308c\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002\u4ee5\u4e0b\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u3066\u3001\u540c\u3058\u30ca\u30f3\u30d0\u30fc\u30d7\u30ec\u30fc\u30c8\u3092\u6301\u3064\u8eca\u4e21\u3092\u633f\u5165\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">INSERT INTO cars VALUES <span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;<mark>DEF456<\/mark>&#8216;<\/span>, <span class=\"token string\">&#8216;Jeep&#8217;<\/span>, <span class=\"token string\">&#8216;Wrangler&#8217;<\/span>, <span class=\"token string\">&#8216;Yellow&#8217;<\/span>, <span class=\"token number\">2019<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>MySQL\u306f\u3001DEF456\u306e\u30e9\u30a4\u30bb\u30f3\u30b9\u30d7\u30ec\u30fc\u30c8\u304c\u30d7\u30e9\u30a4\u30de\u30ea\u30fc\u30ad\u30fc\u306e\u91cd\u8907\u30a8\u30f3\u30c8\u30ea\u30fc\u306b\u306a\u308b\u3053\u3068\u3092\u793a\u3059\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u3067\u5fdc\u7b54\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>ERROR 1062 (23000): Duplicate entry &#8216;DEF456&#8217; for key &#8216;cars.PRIMARY&#8217;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"post-conf-note\">\n<p class=\"post-conf-desc\">Note<\/p>\n<div>\u6ce8\u610f\uff1a\u5185\u90e8\u7684\u306b\u306f\u3001\u4e3b\u30ad\u30fc\u306f\u30e6\u30cb\u30fc\u30af\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3067\u5b9f\u88c5\u3055\u308c\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u4ed6\u306e\u5217\u306e\u305f\u3081\u306b\u624b\u52d5\u3067\u4f5c\u6210\u3059\u308b\u3053\u3068\u3082\u3042\u308b\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3068\u591a\u304f\u306e\u5171\u901a\u306e\u7279\u6027\u3092\u6301\u3063\u3066\u3044\u307e\u3059\u3002\u6700\u3082\u91cd\u8981\u306a\u3053\u3068\u306f\u3001\u4e3b\u30ad\u30fc\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306f\u3001\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u304c\u5b9a\u7fa9\u3055\u308c\u3066\u3044\u308b\u5217\u3092\u5bfe\u8c61\u3068\u3057\u305f\u30c6\u30fc\u30d6\u30eb\u306e\u30af\u30a8\u30ea\u306e\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u3082\u5411\u4e0a\u3055\u305b\u307e\u3059\u3002\u305d\u306e\u76ee\u7684\u3067\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u306e\u8a73\u7d30\u306f\u3001\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u30b7\u30ea\u30fc\u30ba\u306e\u300c\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u306e\u4f7f\u7528\u65b9\u6cd5\u300d\u30ac\u30a4\u30c9\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/div>\n<\/div>\n<p>\u4eca\u3067\u306f\u3001\u91cd\u8907\u3057\u305f\u30ca\u30f3\u30d0\u30fc\u30d7\u30ec\u30fc\u30c8\u306f\u8a31\u53ef\u3055\u308c\u3066\u3044\u306a\u3044\u3053\u3068\u304c\u78ba\u5b9f\u3067\u3059\u3002\u6b21\u306b\u3001\u7a7a\u306e\u30ca\u30f3\u30d0\u30fc\u30d7\u30ec\u30fc\u30c8\u3092\u6301\u3064\u8eca\u3092\u633f\u5165\u3067\u304d\u308b\u304b\u3069\u3046\u304b\u3092\u78ba\u8a8d\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">INSERT INTO cars VALUES <span class=\"token punctuation\">(<\/span><mark>NULL<\/mark>, <span class=\"token string\">&#8216;Jeep&#8217;<\/span>, <span class=\"token string\">&#8216;Wrangler&#8217;<\/span>, <span class=\"token string\">&#8216;Yellow&#8217;<\/span>, <span class=\"token number\">2019<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u4eca\u56de\u306f\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u5225\u306e\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u3067\u8fd4\u7b54\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>ERROR 1048 (23000): Column &#8216;license_plate&#8217; cannot be null<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u3053\u308c\u3089\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u3088\u3063\u3066\u5f37\u5236\u3055\u308c\u305f2\u3064\u306e\u30eb\u30fc\u30eb\u306b\u3088\u3063\u3066\u3001\u30e9\u30a4\u30bb\u30f3\u30b9\u30d7\u30ec\u30fc\u30c8\u304c\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u3059\u3079\u3066\u306e\u884c\u3092\u4e00\u610f\u306b\u8b58\u5225\u3059\u308b\u3053\u3068\u304c\u78ba\u5b9f\u306b\u306a\u308a\u307e\u3059\u3002\u30c6\u30fc\u30d6\u30eb\u3092\u30e9\u30a4\u30bb\u30f3\u30b9\u30d7\u30ec\u30fc\u30c8\u306b\u57fa\u3065\u3044\u3066\u30af\u30a8\u30ea\u3059\u308b\u5834\u5408\u3001\u6bce\u56de\u5fc5\u305a1\u884c\u304c\u8fd4\u3055\u308c\u308b\u3053\u3068\u304c\u671f\u5f85\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u8907\u6570\u5217\u3092\u6301\u3064\u4e3b\u30ad\u30fc\u306e\u4f7f\u7528\u65b9\u6cd5\u306b\u3064\u3044\u3066\u5b66\u3073\u307e\u3059\u3002<\/p>\n<h2>\u8907\u6570\u306e\u5217\u306b\u4e3b\u30ad\u30fc\u3092\u4f5c\u6210\u3059\u308b<\/h2>\n<p>\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u884c\u3092\u4e00\u610f\u306b\u7279\u5b9a\u3059\u308b\u305f\u3081\u306b\u30011\u3064\u306e\u5217\u3060\u3051\u3067\u306f\u5341\u5206\u3067\u306a\u3044\u5834\u5408\u3001\u8907\u6570\u306e\u5217\u3092\u4f7f\u7528\u3059\u308b\u4e3b\u30ad\u30fc\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u305f\u3068\u3048\u3070\u3001\u500b\u3005\u306e\u5bb6\u3092\u7279\u5b9a\u3059\u308b\u305f\u3081\u306b\u9053\u8def\u540d\u3084\u4f4f\u6240\u756a\u53f7\u306e\u3044\u305a\u308c\u304b\u3060\u3051\u3067\u306f\u4e0d\u5341\u5206\u306a\u5bb6\u5c4b\u767b\u9332\u3092\u60f3\u50cf\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Sample table\">Sample table<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;+ | street_name | street_number | house_owner | year | +&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;+ | 5th Avenue | <mark>100<\/mark> | Bob Johnson | 2018 | | Broadway | 1500 | Jane Smith | 2016 | | <mark>Central Park West<\/mark> | <mark>100<\/mark> | John Doe | 2014 | | <mark>Central Park West<\/mark> | 200 | Tom Thompson | 2015 | | Lexington Avenue | 5001 | Samantha Davis | 2010 | | Park Avenue | 7000 | Michael Rodriguez | 2012 | +&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;+<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u8868\u306e\u4e2d\u306b\u306f\u3001Central Park West\u3068\u3044\u3046\u9053\u8def\u540d\u304c\u8907\u6570\u56de\u73fe\u308c\u3001\u540c\u3058\u304f100\u3068\u3044\u3046\u9053\u8def\u756a\u53f7\u3082\u8907\u6570\u56de\u73fe\u308c\u307e\u3059\u3002\u3057\u304b\u3057\u3001\u9053\u8def\u540d\u3068\u9053\u8def\u756a\u53f7\u306e\u7d44\u307f\u5408\u308f\u305b\u306e\u91cd\u8907\u306f\u898b\u3089\u308c\u307e\u305b\u3093\u3002\u3053\u306e\u5834\u5408\u3001\u5358\u4e00\u306e\u5217\u3067\u306f\u4e3b\u30ad\u30fc\u306b\u306f\u306a\u308a\u5f97\u307e\u305b\u3093\u304c\u3001\u3053\u306e2\u3064\u306e\u5024\u306e\u7d44\u307f\u5408\u308f\u305b\u306f\u5404\u884c\u3092\u4e00\u610f\u306b\u8b58\u5225\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u6b21\u306b\u3001\u4ee5\u4e0b\u306e\u5217\u3092\u6301\u3064\u4e0a\u8a18\u306e\u8868\u306b\u4f3c\u305f\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<ul class=\"post-ul\">\n<li>street_name: This column holds the name of the street where the house is located, represented by the varchar data type limited to 50 characters.<\/li>\n<li>street_number: This column holds the house\u2019s street number, represented by the varchar data type. This column can store up to 5 characters. It doesn\u2019t use numerical int data type because some street numbers might contain letters (for example, 200B).<\/li>\n<li>house_owner: This column holds the name of the house\u2019s owner, represented by the varchar data type limited to 50 characters.<\/li>\n<li>year: This column holds the year the house was built, represented by the int data type to store numerical values.<\/li>\n<\/ul>\n<p>\u4eca\u56de\u306f\u3001\u5358\u4e00\u306e\u5217\u3067\u306f\u306a\u304f\u3001street_name\u3068street_number\u306e\u4e21\u65b9\u3092\u4f7f\u7528\u3057\u3066\u4e3b\u30ad\u30fc\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002\u6b21\u306eSQL\u6587\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">CREATE TABLE houses <span class=\"token punctuation\">(<\/span><\/li>\n<li data-prefix=\"mysql&gt;\">street_name varchar<span class=\"token punctuation\">(<\/span><span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\">street_number varchar<span class=\"token punctuation\">(<\/span><span class=\"token number\">5<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\">house_owner varchar<span class=\"token punctuation\">(<\/span><span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\">year int,<\/li>\n<li data-prefix=\"mysql&gt;\"><mark>PRIMARY KEY<span class=\"token punctuation\">(<\/span>street_name, street_number<span class=\"token punctuation\">)<\/span><\/mark><\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u4eca\u56de\u306f\u3001\u4ee5\u524d\u306e\u4f8b\u3068\u306f\u7570\u306a\u308a\u3001PRIMARY KEY\u7bc0\u306f\u5217\u306e\u5b9a\u7fa9\u306e\u4e0b\u306b\u73fe\u308c\u307e\u3059\u3002PRIMARY KEY\u6587\u306f\u3001\u62ec\u5f27\u5185\u306bstreet_name\u3068street_number\u3068\u3044\u30462\u3064\u306e\u5217\u540d\u3092\u6301\u3063\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u69cb\u6587\u306b\u3088\u3063\u3066\u3001houses\u30c6\u30fc\u30d6\u30eb\u306e\u4e3b\u30ad\u30fc\u304c2\u3064\u306e\u5217\u306b\u307e\u305f\u304c\u3063\u3066\u4f5c\u6210\u3055\u308c\u307e\u3059\u3002<\/p>\n<p>\u3082\u3057\u4ee5\u4e0b\u306e\u51fa\u529b\u304c\u8868\u793a\u3055\u308c\u305f\u5834\u5408\u3001\u30c6\u30fc\u30d6\u30eb\u304c\u4f5c\u6210\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>Query OK, 0 rows affected (0.00 sec)<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u305d\u308c\u306b\u7d9a\u3044\u3066\u3001\u6b21\u306eINSERT INTO\u64cd\u4f5c\u3092\u5b9f\u884c\u3057\u3066\u3001\u524d\u306e\u4f8b\u3067\u63d0\u793a\u3055\u308c\u305f\u30b5\u30f3\u30d7\u30eb\u884c\u3092\u30c6\u30fc\u30d6\u30eb\u306b\u8aad\u307f\u8fbc\u3093\u3067\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">INSERT INTO houses VALUES<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;Central Park West&#8217;<\/span>, <span class=\"token string\">&#8216;100&#8217;<\/span>, <span class=\"token string\">&#8216;John Doe&#8217;<\/span>, <span class=\"token number\">2014<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;Broadway&#8217;<\/span>, <span class=\"token string\">&#8216;1500&#8217;<\/span>, <span class=\"token string\">&#8216;Jane Smith&#8217;<\/span>, <span class=\"token number\">2016<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;5th Avenue&#8217;<\/span>, <span class=\"token string\">&#8216;100&#8217;<\/span>, <span class=\"token string\">&#8216;Bob Johnson&#8217;<\/span>, <span class=\"token number\">2018<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;Lexington Avenue&#8217;<\/span>, <span class=\"token string\">&#8216;5001&#8217;<\/span>, <span class=\"token string\">&#8216;Samantha Davis&#8217;<\/span>, <span class=\"token number\">2010<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;Park Avenue&#8217;<\/span>, <span class=\"token string\">&#8216;7000&#8217;<\/span>, <span class=\"token string\">&#8216;Michael Rodriguez&#8217;<\/span>, <span class=\"token number\">2012<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;Central Park West&#8217;<\/span>, <span class=\"token string\">&#8216;200&#8217;<\/span>, <span class=\"token string\">&#8216;Tom Thompson&#8217;<\/span>, <span class=\"token number\">2015<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u6210\u529f\u30e1\u30c3\u30bb\u30fc\u30b8\u3067\u5fdc\u7b54\u3057\u307e\u3059\u3002 (D\u0113tab\u0113su wa seik\u014d mess\u0113ji de \u014dt\u014d shimasu.)<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>Query OK, 6 rows affected (0.000 sec) Records: 6 Duplicates: 0 Warnings: 0<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u65b0\u3057\u304f\u4f5c\u6210\u3055\u308c\u305f\u30c6\u30fc\u30d6\u30eb\u306b\u3001\u4e88\u5b9a\u3055\u308c\u305f\u30c7\u30fc\u30bf\u3068\u5f62\u5f0f\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u304b\u3092\u3001SELECT\u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8\u3092\u4f7f\u7528\u3057\u3066\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">SELECT * FROM houses<span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u51fa\u529b\u7d50\u679c\u306f\u3001\u30bb\u30af\u30b7\u30e7\u30f3\u306e\u521d\u3081\u306b\u3042\u308b\u8868\u3068\u4f3c\u305f\u8868\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;+ | street_name | street_number | house_owner | year | +&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;+ | 5th Avenue | 100 | Bob Johnson | 2018 | | Broadway | 1500 | Jane Smith | 2016 | | Central Park West | 100 | John Doe | 2014 | | Central Park West | 200 | Tom Thompson | 2015 | | Lexington Avenue | 5001 | Samantha Davis | 2010 | | Park Avenue | 7000 | Michael Rodriguez | 2012 | +&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-+&#8212;&#8212;+ 6 rows in set (0.000 sec)<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u3055\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u9053\u8def\u540d\u3068\u756a\u5730\u304c\u91cd\u8907\u3059\u308b\u884c\u306e\u633f\u5165\u3092\u8a31\u53ef\u3057\u3001\u3057\u304b\u3057\u30c6\u30fc\u30d6\u30eb\u306b\u306f\u91cd\u8907\u3057\u305f\u4f4f\u6240\u3092\u5236\u9650\u3059\u308b\u304b\u3092\u691c\u8a3c\u3057\u307e\u3057\u3087\u3046\u3002\u30d1\u30fc\u30af\u30a2\u30d9\u30cb\u30e5\u30fc\u306b\u5225\u306e\u5bb6\u3092\u8ffd\u52a0\u3057\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">INSERT INTO houses VALUES <span class=\"token punctuation\">(<\/span><mark><span class=\"token string\">&#8216;Park Avenue&#8217;<\/span><\/mark>, <span class=\"token string\">&#8216;8000&#8217;<\/span>, <span class=\"token string\">&#8216;Emily Brown&#8217;<\/span>, <span class=\"token number\">2011<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>MySQL\u306f\u3001\u4ee5\u524d\u306e\u30c6\u30fc\u30d6\u30eb\u306b8000 Park Avenue\u306e\u30a2\u30c9\u30ec\u30b9\u304c\u8868\u793a\u3055\u308c\u306a\u304b\u3063\u305f\u305f\u3081\u3001\u6210\u529f\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u8fd4\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>Query OK, 1 row affected (0.010 sec)<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u540c\u3058\u3088\u3046\u306a\u7d50\u679c\u304c\u5f97\u3089\u308c\u307e\u3059\u3002\u30e1\u30a4\u30f3\u30b9\u30c8\u30ea\u30fc\u30c88000\u756a\u306b\u5bb6\u3092\u8ffd\u52a0\u3059\u308b\u969b\u3001\u901a\u308a\u756a\u53f7\u3092\u7e70\u308a\u8fd4\u3059\u3068\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">INSERT INTO houses VALUES <span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;Main Street&#8217;<\/span>, <mark><span class=\"token string\">&#8216;8000&#8217;<\/span><\/mark>, <span class=\"token string\">&#8216;David Jones&#8217;<\/span>, <span class=\"token number\">2009<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u518d\u5ea6\u3001\u4f4f\u6240\u306e\u5168\u4f53\u304c\u91cd\u8907\u3057\u306a\u3044\u305f\u3081\u3001\u65b0\u3057\u3044\u884c\u304c\u9069\u5207\u306b\u633f\u5165\u3055\u308c\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>Query OK, 1 row affected (0.010 sec)<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u3057\u304b\u3057\u3001\u4ee5\u4e0b\u306eINSERT\u6587\u3092\u4f7f\u7528\u3057\u3066\u3001100 5th Avenue\u306b\u5225\u306e\u5bb6\u3092\u8ffd\u52a0\u3057\u3066\u307f\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">INSERT INTO houses VALUES <span class=\"token punctuation\">(<\/span><mark><span class=\"token string\">&#8216;5th Avenue&#8217;<\/span><\/mark>, <mark><span class=\"token string\">&#8216;100&#8217;<\/span><\/mark>, <span class=\"token string\">&#8216;Josh Gordon&#8217;<\/span>, <span class=\"token number\">2008<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u30015\u756a\u8857\u3068100\u306e\u5024\u306e\u7d44\u307f\u5408\u308f\u305b\u306b\u5bfe\u3057\u3066\u4e3b\u30ad\u30fc\u306e\u91cd\u8907\u30a8\u30f3\u30c8\u30ea\u304c\u3042\u308b\u3053\u3068\u3092\u901a\u77e5\u3059\u308b\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u3067\u5fdc\u7b54\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>ERROR 1062 (23000): Duplicate entry &#8216;<mark>5th Avenue<\/mark>&#8211;<mark>100<\/mark>&#8216; for key &#8216;houses.PRIMARY&#8217;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u3001\u4e3b\u30ad\u30fc\u30eb\u30fc\u30eb\u3092\u6b63\u3057\u304f\u5b9f\u65bd\u3057\u3066\u304a\u308a\u3001\u30ad\u30fc\u306f2\u3064\u306e\u5217\u306b\u5b9a\u7fa9\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u30c6\u30fc\u30d6\u30eb\u5185\u306b\u306f\u3001\u30b9\u30c8\u30ea\u30fc\u30c8\u540d\u3068\u756a\u5730\u304b\u3089\u6210\u308b\u4f4f\u6240\u304c\u91cd\u8907\u3059\u308b\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u306e\u3067\u3001\u5b89\u5fc3\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u3053\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u30cf\u30a6\u30b9\u30c6\u30fc\u30d6\u30eb\u306e\u5404\u884c\u3092\u4e00\u610f\u306b\u8b58\u5225\u3059\u308b\u305f\u3081\u306b\u30012\u3064\u306e\u5217\u3067\u81ea\u7136\u30ad\u30fc\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002\u3057\u304b\u3057\u3001\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u304b\u3089\u5e38\u306b\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3092\u5c0e\u51fa\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3002\u6b21\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3067\u306f\u3001\u30c7\u30fc\u30bf\u304b\u3089\u76f4\u63a5\u7684\u306b\u306f\u5f97\u3089\u308c\u306a\u3044\u4eba\u5de5\u7684\u306a\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<h2>\u30b7\u30fc\u30b1\u30f3\u30b7\u30e3\u30eb\u306a\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3092\u4f5c\u6210\u3059\u308b\u3002<\/h2>\n<p>\u3053\u308c\u307e\u3067\u306f\u3001\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u5185\u306e\u65e2\u5b58\u306e\u5217\u3092\u4f7f\u7528\u3057\u3066\u30e6\u30cb\u30fc\u30af\u306a\u4e3b\u30ad\u30fc\u3092\u4f5c\u6210\u3057\u3066\u304d\u307e\u3057\u305f\u3002\u3057\u304b\u3057\u3001\u3044\u304f\u3064\u304b\u306e\u5834\u5408\u3067\u306f\u3001\u30c7\u30fc\u30bf\u304c\u91cd\u8907\u3057\u3066\u3057\u307e\u3044\u3001\u3069\u306e\u5217\u3082\u826f\u3044\u4e00\u610f\u306e\u8b58\u5225\u5b50\u3068\u3057\u3066\u6a5f\u80fd\u3057\u306a\u304f\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u3088\u3046\u306a\u5834\u5408\u306b\u306f\u3001\u751f\u6210\u3055\u308c\u305f\u8b58\u5225\u5b50\u3092\u4f7f\u7528\u3057\u3066\u9023\u7d9a\u7684\u306a\u4e3b\u30ad\u30fc\u3092\u4f5c\u6210\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u624b\u5143\u306e\u30c7\u30fc\u30bf\u3092\u4e00\u610f\u306b\u8b58\u5225\u3059\u308b\u305f\u3081\u306b\u65b0\u3057\u3044\u8b58\u5225\u5b50\u3092\u8003\u6848\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u5834\u5408\u3001\u305d\u306e\u4eba\u5de5\u7684\u306a\u8b58\u5225\u5b50\u3067\u4f5c\u6210\u3055\u308c\u305f\u4e3b\u30ad\u30fc\u306f\u30b5\u30ed\u30b2\u30fc\u30c8\u30ad\u30fc\u3068\u547c\u3070\u308c\u307e\u3059\u3002<\/p>\n<p>\u3042\u308b\u65e5\u3001\u672c\u306e\u30af\u30e9\u30d6\u306e\u30e1\u30f3\u30d0\u30fc\u306e\u30ea\u30b9\u30c8\u3092\u601d\u3044\u6d6e\u304b\u3079\u3066\u304f\u3060\u3055\u3044\u3002\u3053\u3053\u3067\u306f\u3001\u5b98\u5e81\u767a\u884c\u306e\u8eab\u5206\u8a3c\u660e\u66f8\u3092\u898b\u305b\u308b\u5fc5\u8981\u306f\u306a\u304f\u3001\u8ab0\u3067\u3082\u53c2\u52a0\u3067\u304d\u308b\u3001\u30ab\u30b8\u30e5\u30a2\u30eb\u306a\u96c6\u307e\u308a\u3067\u3059\u3002\u540c\u3058\u540d\u524d\u306e\u4eba\u3005\u304c\u3044\u3064\u304b\u30af\u30e9\u30d6\u306b\u53c2\u52a0\u3059\u308b\u53ef\u80fd\u6027\u3082\u3042\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Sample table\">Sample table<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+ | first_name | last_name | +&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+ | John | Doe | | <mark>Jane<\/mark> | <mark>Smith<\/mark> | | <mark>Bob<\/mark> | <mark>Johnson<\/mark> | | Samantha | Davis | | Michael | Rodriguez | | Tom | Thompson | | Sara | Johnson | | David | Jones | | <mark>Jane<\/mark> | <mark>Smith<\/mark> | | <mark>Bob<\/mark> | <mark>Johnson<\/mark> | +&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u30c6\u30fc\u30d6\u30eb\u306b\u306f\u3001\u30dc\u30d6\u30fb\u30b8\u30e7\u30f3\u30bd\u30f3\u3068\u30b8\u30a7\u30fc\u30f3\u30fb\u30b9\u30df\u30b9\u3068\u3044\u3046\u540d\u524d\u304c\u7e70\u308a\u8fd4\u3055\u308c\u3066\u3044\u307e\u3059\u3002\u8ab0\u304c\u8ab0\u304b\u3092\u78ba\u5b9f\u306b\u7279\u5b9a\u3059\u308b\u305f\u3081\u306b\u3001\u8ffd\u52a0\u306e\u8b58\u5225\u5b50\u3092\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u3001\u305d\u306e\u30c6\u30fc\u30d6\u30eb\u3067\u306f\u884c\u3092\u4e00\u610f\u306b\u7279\u5b9a\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3002\u3082\u3057\u672c\u306e\u30af\u30e9\u30d6\u30e1\u30f3\u30d0\u30fc\u306e\u30ea\u30b9\u30c8\u3092\u7d19\u3067\u4fdd\u6301\u3057\u3066\u3044\u308b\u5834\u5408\u3001\u540c\u3058\u540d\u524d\u306e\u4eba\u3005\u3092\u533a\u5225\u3059\u308b\u305f\u3081\u306b\u88dc\u52a9\u8b58\u5225\u5b50\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u306f\u3001\u8ffd\u52a0\u306e\u5217\u3092\u4f7f\u7528\u3057\u3066\u3001\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u3059\u3079\u3066\u306e\u884c\u3092\u4e00\u610f\u306b\u533a\u5225\u3059\u308b\u305f\u3081\u306e\u76ee\u7684\u3060\u3051\u3067\u751f\u6210\u3055\u308c\u305f\u4e8b\u5b9f\u306e\u306a\u3044\u8b58\u5225\u5b50\u3092\u4fdd\u6301\u3059\u308b\u3053\u3068\u3067\u3001\u540c\u69d8\u306e\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002member_id\u3068\u547c\u3073\u307e\u3057\u3087\u3046\u3002<\/p>\n<p>\u3057\u304b\u3057\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u3082\u3046\u4e00\u4eba\u306e\u8aad\u66f8\u30af\u30e9\u30d6\u30e1\u30f3\u30d0\u30fc\u3092\u8ffd\u52a0\u3057\u305f\u3044\u5834\u5408\u306b\u3001\u305d\u306e\u3088\u3046\u306a\u8b58\u5225\u5b50\u3092\u8003\u3048\u308b\u3053\u3068\u306f\u8ca0\u62c5\u306b\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u554f\u984c\u3092\u89e3\u6c7a\u3059\u308b\u305f\u3081\u306b\u3001MySQL\u306f\u81ea\u52d5\u7684\u306b\u6570\u5024\u304c\u5897\u52a0\u3059\u308b\u5217\u306e\u81ea\u52d5\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u6a5f\u80fd\u3092\u63d0\u4f9b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u4e0a\u8a18\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u30c6\u30fc\u30d6\u30eb\u306b\u4f3c\u305f\u3082\u306e\u3092\u4f5c\u308a\u307e\u3057\u3087\u3046\u3002\u8ffd\u52a0\u306e\u81ea\u52d5\u5897\u5206\u30ab\u30e9\u30e0\uff08member_id\uff09\u3092\u4f5c\u6210\u3057\u3001\u30af\u30e9\u30d6\u30e1\u30f3\u30d0\u30fc\u3054\u3068\u306b\u81ea\u52d5\u7684\u306b\u5272\u308a\u5f53\u3066\u3089\u308c\u308b\u756a\u53f7\u3092\u4fdd\u6301\u3057\u307e\u3059\u3002\u305d\u306e\u81ea\u52d5\u7684\u306b\u5272\u308a\u5f53\u3066\u3089\u308c\u308b\u756a\u53f7\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u306e\u4e3b\u30ad\u30fc\u3068\u3057\u3066\u6a5f\u80fd\u3057\u307e\u3059\u3002<\/p>\n<ul class=\"post-ul\">\n<li>member_id: This column holds an auto-incremented, numerical identifier represented by the int data type.<\/li>\n<li>first_name: This column holds the first name of the club members, represented by the varchar data type limited to 50 characters.<\/li>\n<li>last_name: This column holds the last name of the club members, represented by the varchar data type limited to 50 characters.<\/li>\n<\/ul>\n<p>\u30c6\u30fc\u30d6\u30eb\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306b\u3001\u4ee5\u4e0b\u306eSQL\u6587\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">CREATE TABLE club_members <span class=\"token punctuation\">(<\/span><\/li>\n<li data-prefix=\"mysql&gt;\">member_id int <mark>AUTO_INCREMENT PRIMARY KEY<\/mark>,<\/li>\n<li data-prefix=\"mysql&gt;\">first_name varchar<span class=\"token punctuation\">(<\/span><span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\">last_name varchar<span class=\"token punctuation\">(<\/span><span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span><\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>PRIMARY KEY\u7bc0\u306f\u3001\u5358\u4e00\u306e\u5217\u306e\u4e3b\u30ad\u30fc\u3068\u540c\u69d8\u306b\u3001\u5217\u306e\u578b\u5b9a\u7fa9\u306e\u5f8c\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u304c\u3001\u305d\u306e\u524d\u306b\u8ffd\u52a0\u306e\u5c5e\u6027\u304c\u8868\u793a\u3055\u308c\u307e\u3059\uff1aAUTO_INCREMENT\u3067\u3059\u3002\u3053\u308c\u306fMySQL\u306b\u5bfe\u3057\u3066\u3001\u5217\u306e\u5024\u3092\u81ea\u52d5\u7684\u306b\u751f\u6210\u3059\u308b\u3088\u3046\u6307\u793a\u3057\u3001\u660e\u793a\u7684\u306b\u6307\u5b9a\u3055\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001\u6210\u9577\u3059\u308b\u6570\u5217\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n<div class=\"post-conf-note\">\n<p class=\"post-conf-desc\">Note<\/p>\n<div>\u6ce8\u610f\uff1a\u5217\u3092\u5b9a\u7fa9\u3059\u308b\u305f\u3081\u306eAUTO_INCREMENT\u30d7\u30ed\u30d1\u30c6\u30a3\u306fMySQL\u306b\u56fa\u6709\u3067\u3059\u3002\u4ed6\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3082\u9023\u7d9a\u3057\u305f\u30ad\u30fc\u3092\u751f\u6210\u3059\u308b\u305f\u3081\u306e\u985e\u4f3c\u3057\u305f\u65b9\u6cd5\u3092\u63d0\u4f9b\u3057\u3066\u3044\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u69cb\u6587\u306f\u30a8\u30f3\u30b8\u30f3\u306b\u3088\u3063\u3066\u7570\u306a\u308a\u307e\u3059\u3002\u7591\u308f\u3057\u3044\u5834\u5408\u306f\u3001\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u30b7\u30b9\u30c6\u30e0\uff08RDBMS\uff09\u306e\u516c\u5f0f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u53c2\u7167\u3059\u308b\u3088\u3046\u304a\u52e7\u3081\u3057\u307e\u3059\u3002<\/div>\n<\/div>\n<p>\u3082\u3057\u4ee5\u4e0b\u306e\u51fa\u529b\u304c\u8868\u793a\u3055\u308c\u308c\u3070\u3001\u30c6\u30fc\u30d6\u30eb\u304c\u4f5c\u6210\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>Query OK, 0 rows affected (0.00 sec)<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u305d\u306e\u5f8c\u3001\u6b21\u306eINSERT INTO\u64cd\u4f5c\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u3001\u4f8b\u306b\u793a\u3055\u308c\u305f\u30b5\u30f3\u30d7\u30eb\u884c\u3092\u30c6\u30fc\u30d6\u30eb\u306b\u30ed\u30fc\u30c9\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">INSERT INTO club_members <mark><span class=\"token punctuation\">(<\/span>first_name, last_name<span class=\"token punctuation\">)<\/span><\/mark> VALUES<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;John&#8217;<\/span>, <span class=\"token string\">&#8216;Doe&#8217;<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;Jane&#8217;<\/span>, <span class=\"token string\">&#8216;Smith&#8217;<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;Bob&#8217;<\/span>, <span class=\"token string\">&#8216;Johnson&#8217;<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;Samantha&#8217;<\/span>, <span class=\"token string\">&#8216;Davis&#8217;<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;Michael&#8217;<\/span>, <span class=\"token string\">&#8216;Rodriguez&#8217;<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;Tom&#8217;<\/span>, <span class=\"token string\">&#8216;Thompson&#8217;<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;Sara&#8217;<\/span>, <span class=\"token string\">&#8216;Johnson&#8217;<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;David&#8217;<\/span>, <span class=\"token string\">&#8216;Jones&#8217;<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;Jane&#8217;<\/span>, <span class=\"token string\">&#8216;Smith&#8217;<\/span><span class=\"token punctuation\">)<\/span>,<\/li>\n<li data-prefix=\"mysql&gt;\"><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;Bob&#8217;<\/span>, <span class=\"token string\">&#8216;Johnson&#8217;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>INSERT\u6587\u306b\u306f\u3001\u30ab\u30e9\u30e0\u540d\uff08first_name\u3068last_name\uff09\u306e\u30ea\u30b9\u30c8\u304c\u542b\u307e\u308c\u3066\u304a\u308a\u3001\u3053\u308c\u306b\u3088\u3063\u3066\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u30e1\u30f3\u30d0\u30fcID\u30ab\u30e9\u30e0\u304c\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306b\u542b\u307e\u308c\u3066\u3044\u306a\u3044\u3053\u3068\u3092\u77e5\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u305d\u306e\u305f\u3081\u3001\u4ee3\u308f\u308a\u306b\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u3092\u4f7f\u7528\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u6210\u529f\u30e1\u30c3\u30bb\u30fc\u30b8\u3067\u5fdc\u7b54\u3057\u307e\u3059\u3002 (De-ta-be-su wa seikou mess\u0113ji de \u014dto shimasu.)<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>Query OK, 10 rows affected (0.002 sec) Records: 10 Duplicates: 0 Warnings: 0<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u65b0\u3057\u304f\u4f5c\u6210\u3055\u308c\u305f\u30c6\u30fc\u30d6\u30eb\u306e\u30c7\u30fc\u30bf\u3092\u78ba\u8a8d\u3059\u308b\u305f\u3081\u306bSELECT\u6587\u3092\u4f7f\u7528\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">SELECT * FROM club_members<span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u51fa\u529b\u306f\u3001\u30bb\u30af\u30b7\u30e7\u30f3\u306e\u6700\u521d\u306b\u3042\u308b\u8868\u306b\u4f3c\u305f\u8868\u3092\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+ | <mark>member_id<\/mark> | first_name | last_name | +&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+ | 1 | John | Doe | | <mark>2<\/mark> | <mark>Jane<\/mark> | <mark>Smith<\/mark> | | <mark>3<\/mark> | <mark>Bob<\/mark> | <mark>Johnson<\/mark> | | 4 | Samantha | Davis | | 5 | Michael | Rodriguez | | 6 | Tom | Thompson | | 7 | Sara | Johnson | | 8 | David | Jones | | <mark>9<\/mark> | <mark>Jane<\/mark> | <mark>Smith<\/mark> | | <mark>10<\/mark> | <mark>Bob<\/mark> | <mark>Johnson<\/mark> | +&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+ 10 rows in set (0.000 sec)<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u3057\u304b\u3057\u3001\u4eca\u56de\u306e\u7d50\u679c\u306b\u306fmember_id\u5217\u304c\u8868\u793a\u3055\u308c\u30011\u304b\u308910\u307e\u3067\u306e\u6570\u306e\u9023\u7d9a\u304c\u542b\u307e\u308c\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u5217\u304c\u3042\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u3001\u30b8\u30a7\u30fc\u30f3\u30fb\u30b9\u30df\u30b9\u3068\u30dc\u30d6\u30fb\u30b8\u30e7\u30f3\u30bd\u30f3\u306e\u91cd\u8907\u3057\u305f\u884c\u306f\u533a\u5225\u3067\u304d\u306a\u304f\u306a\u308a\u307e\u305b\u3093\u3002\u306a\u305c\u306a\u3089\u3001\u305d\u308c\u305e\u308c\u306e\u540d\u524d\u304c\u4e00\u610f\u306e\u8b58\u5225\u5b50\uff08member_id\uff09\u3068\u95a2\u9023\u4ed8\u3051\u3089\u308c\u3066\u3044\u308b\u304b\u3089\u3067\u3059\u3002<\/p>\n<p>\u3055\u3066\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u30af\u30e9\u30d6\u30e1\u30f3\u30d0\u30fc\u30ea\u30b9\u30c8\u306b\u3082\u30461\u4eba\u306e\u30c8\u30e0\u30fb\u30c8\u30f3\u30d7\u30bd\u30f3\u306e\u8ffd\u52a0\u3092\u8a31\u53ef\u3059\u308b\u304b\u3001\u78ba\u8a8d\u3057\u307e\u3057\u3087\u3046\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">INSERT INTO club_members <span class=\"token punctuation\">(<\/span>first_name, last_name<span class=\"token punctuation\">)<\/span> VALUES <span class=\"token punctuation\">(<\/span><span class=\"token string\">&#8216;<mark>Tom<\/mark>&#8216;<\/span>, <span class=\"token string\">&#8216;<mark>Thompson<\/mark>&#8216;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>MySQL\u306f\u6210\u529f\u30e1\u30c3\u30bb\u30fc\u30b8\u3067\u5fdc\u7b54\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>Query OK, 1 row affected (0.009 sec)<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u65b0\u3057\u3044\u30a8\u30f3\u30c8\u30ea\u30fc\u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304c\u5272\u308a\u5f53\u3066\u305f\u6570\u5024\u8b58\u5225\u5b50\u3092\u78ba\u8a8d\u3059\u308b\u306b\u306f\u3001\u518d\u3073SELECT\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<ol>\n<li data-prefix=\"mysql&gt;\">SELECT * FROM club_members<span class=\"token punctuation\">;<\/span><\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u51fa\u529b\u306b\u306f\u3082\u30461\u884c\u3042\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<div class=\"secondary-code-label\" title=\"Output\">Output<\/div>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>+&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+ | member_id | first_name | last_name | +&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+ | 1 | John | Doe | | 2 | Jane | Smith | | 3 | Bob | Johnson | | 4 | Samantha | Davis | | 5 | Michael | Rodriguez | | 6 | Tom | Thompson | | 7 | Sara | Johnson | | 8 | David | Jones | | 9 | Jane | Smith | | 10 | Bob | Johnson | | <mark>11<\/mark> | <mark>Tom<\/mark> | <mark>Thompson<\/mark> | +&#8212;&#8212;&#8212;&#8211;+&#8212;&#8212;&#8212;&#8212;+&#8212;&#8212;&#8212;&#8211;+ 11 rows in set (0.000 sec)<\/p>\n<pre class=\"post-pre\"><code><\/code><\/pre>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306eAUTO_INCREMENT\u6a5f\u80fd\u306b\u3088\u308a\u3001\u65b0\u3057\u3044\u884c\u304c\u81ea\u52d5\u7684\u306b\u30e1\u30f3\u30d0\u30fcID\u5217\u306b11\u756a\u3068\u3057\u3066\u5272\u308a\u5f53\u3066\u3089\u308c\u307e\u3057\u305f\u3002<\/p>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u8ffd\u52a0\u3059\u308b\u305f\u3073\u306b\u7279\u5b9a\u306e\u4e3b\u30ad\u30fc\u5019\u88dc\u304c\u306a\u304f\u3001\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u306b\u90fd\u5ea6\u5275\u9020\u7684\u306a\u8b58\u5225\u5b50\u3092\u63d0\u4f9b\u3059\u308b\u3053\u3068\u3092\u671b\u307e\u306a\u3044\u5834\u5408\u3001\u9023\u7d9a\u7684\u306b\u751f\u6210\u3055\u308c\u305f\u8b58\u5225\u5b50\u3092\u4e3b\u30ad\u30fc\u3068\u3057\u3066\u5b89\u5168\u306b\u5229\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n<h2>\u7d50\u8ad6\u3092\u8a00\u3048\u3070<\/h2>\n<p>\u3053\u306e\u30ac\u30a4\u30c9\u306b\u5f93\u3046\u3053\u3068\u3067\u3001\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3068\u306f\u4f55\u304b\u3001MySQL\u3067\u4e00\u610f\u306e\u884c\u3092\u7279\u5b9a\u3059\u308b\u305f\u3081\u306b\u4e00\u822c\u7684\u306b\u4f5c\u6210\u3055\u308c\u308b\u30bf\u30a4\u30d7\u306e\u65b9\u6cd5\u3092\u5b66\u3073\u307e\u3057\u305f\u3002\u3042\u306a\u305f\u306f\u81ea\u7136\u306a\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3092\u4f5c\u6210\u3057\u3001\u8907\u6570\u306e\u5217\u306b\u307e\u305f\u304c\u308b\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3092\u4f5c\u6210\u3057\u3001\u81ea\u7136\u30ad\u30fc\u304c\u5b58\u5728\u3057\u306a\u3044\u5834\u5408\u306b\u306f\u81ea\u52d5\u5897\u5206\u30b7\u30fc\u30b1\u30f3\u30b7\u30e3\u30eb\u30ad\u30fc\u3092\u4f7f\u7528\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u69cb\u9020\u3092\u3088\u308a\u5177\u4f53\u7684\u306b\u3059\u308b\u305f\u3081\u306b\u3001\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u4e3b\u30ad\u30fc\u3092\u4f7f\u3046\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u306e\u884c\u306f\u4e00\u610f\u306b\u8b58\u5225\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u30c1\u30e5\u30fc\u30c8\u30ea\u30a2\u30eb\u3067\u306f\u4e3b\u30ad\u30fc\u306e\u57fa\u672c\u7684\u306a\u4f7f\u3044\u65b9\u306e\u307f\u3092\u8aac\u660e\u3057\u307e\u3057\u305f\u304c\u3001\u3055\u3089\u306b\u5b66\u3073\u305f\u3044\u5834\u5408\u306fMySQL\u306e\u5236\u7d04\u306b\u95a2\u3059\u308b\u30c9\u30ad\u30e5\u30e1\u30f3\u30c6\u30fc\u30b7\u30e7\u30f3\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u307e\u305f\u3001SQL\u5236\u7d04\u306e\u7406\u89e3\u3084SQL\u3067\u306e\u5236\u7d04\u306e\u4f7f\u3044\u65b9\u306b\u3064\u3044\u3066\u3082\u5f0a\u793e\u306e\u30ac\u30a4\u30c9\u3092\u53c2\u7167\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>SQL\u8a00\u8a9e\u3068\u305d\u306e\u4f7f\u3044\u65b9\u306b\u3064\u3044\u3066\u3088\u308a\u8a73\u3057\u304f\u5b66\u3073\u305f\u3044\u5834\u5408\u306f\u3001\u300eSQL\u306e\u4f7f\u3044\u65b9\u30b7\u30ea\u30fc\u30ba\u300f\u306e\u4ed6\u306e\u30ac\u30a4\u30c9\u3092\u30c1\u30a7\u30c3\u30af\u3057\u3066\u307f\u308b\u3053\u3068\u3092\u304a\u3059\u3059\u3081\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7b46\u8005\u306f\u3001Write for Donations\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u4e00\u74b0\u3068\u3057\u3066\u3001\u5bc4\u4ed8\u91d1\u3092\u53d7\u3051\u308b\u305f\u3081\u306bDiversity in Tech Fund\u3092\u9078\u3073\u307e\u3057\u305f\u3002 \u30a4\u30f3\u30c8\u30ed\u30c0\u30af\u30b7\u30e7\u30f3 \u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u8cb4\u91cd\u306a\u7279\u5fb4\u306e\u4e00\u3064\u306f\u3001\u30c7 [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[70,62,16,26,61],"class_list":["post-25","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-sql","tag-62","tag-16","tag-26","tag-61"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002 - \u30b9\u30c6\u30c3\u30d7\u30d0\u30a4\u30b9\u30c6\u30c3\u30d7 - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u89e3\u8aac\u3002\u521d\u5fc3\u8005\u306b\u3082\u308f\u304b\u308a\u3084\u3059\u304f\u8aac\u660e\u3057\u307e\u3059\u3002\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/ja\/blog\/sql\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002 - \u30b9\u30c6\u30c3\u30d7\u30d0\u30a4\u30b9\u30c6\u30c3\u30d7\" \/>\n<meta property=\"og:description\" content=\"SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u89e3\u8aac\u3002\u521d\u5fc3\u8005\u306b\u3082\u308f\u304b\u308a\u3084\u3059\u304f\u8aac\u660e\u3057\u307e\u3059\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/ja\/blog\/sql\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-29T00:52:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-31T01:25:27+00:00\" \/>\n<meta name=\"author\" content=\"\u685c, \u6625\u6a39\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u685c, \u6625\u6a39\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"36\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/ja\/blog\/sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82\/\",\"name\":\"SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002 - \u30b9\u30c6\u30c3\u30d7\u30d0\u30a4\u30b9\u30c6\u30c3\u30d7 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/#website\"},\"datePublished\":\"2023-01-29T00:52:08+00:00\",\"dateModified\":\"2025-07-31T01:25:27+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/#\/schema\/person\/ff22288af1a5455571aff7586b0fb341\"},\"description\":\"SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u89e3\u8aac\u3002\u521d\u5fc3\u8005\u306b\u3082\u308f\u304b\u308a\u3084\u3059\u304f\u8aac\u660e\u3057\u307e\u3059\u3002\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/ja\/blog\/sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/ja\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002 &#8211; \u30b9\u30c6\u30c3\u30d7\u30d0\u30a4\u30b9\u30c6\u30c3\u30d7\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/ja\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"ja\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/#\/schema\/person\/ff22288af1a5455571aff7586b0fb341\",\"name\":\"\u685c, \u6625\u6a39\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cee48863f3d4fd7fef222498f3e71b82312aee42b7257a2dbde56394ca4e19de?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cee48863f3d4fd7fef222498f3e71b82312aee42b7257a2dbde56394ca4e19de?s=96&d=mm&r=g\",\"caption\":\"\u685c, \u6625\u6a39\"},\"url\":\"https:\/\/www.silicloud.com\/ja\/blog\/author\/sakuraharuki\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/www.silicloud.com\/ja\/blog\/sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002 - \u30b9\u30c6\u30c3\u30d7\u30d0\u30a4\u30b9\u30c6\u30c3\u30d7 - Blog - Silicon Cloud","description":"SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u89e3\u8aac\u3002\u521d\u5fc3\u8005\u306b\u3082\u308f\u304b\u308a\u3084\u3059\u304f\u8aac\u660e\u3057\u307e\u3059\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/ja\/blog\/sql\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\/","og_locale":"ja_JP","og_type":"article","og_title":"SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002 - \u30b9\u30c6\u30c3\u30d7\u30d0\u30a4\u30b9\u30c6\u30c3\u30d7","og_description":"SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u89e3\u8aac\u3002\u521d\u5fc3\u8005\u306b\u3082\u308f\u304b\u308a\u3084\u3059\u304f\u8aac\u660e\u3057\u307e\u3059\u3002","og_url":"https:\/\/www.silicloud.com\/ja\/blog\/sql\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-01-29T00:52:08+00:00","article_modified_time":"2025-07-31T01:25:27+00:00","author":"\u685c, \u6625\u6a39","twitter_card":"summary_large_image","twitter_misc":{"\u57f7\u7b46\u8005":"\u685c, \u6625\u6a39","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"36\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/ja\/blog\/sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82\/","url":"https:\/\/www.silicloud.com\/ja\/blog\/sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82\/","name":"SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002 - \u30b9\u30c6\u30c3\u30d7\u30d0\u30a4\u30b9\u30c6\u30c3\u30d7 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/ja\/blog\/#website"},"datePublished":"2023-01-29T00:52:08+00:00","dateModified":"2025-07-31T01:25:27+00:00","author":{"@id":"https:\/\/www.silicloud.com\/ja\/blog\/#\/schema\/person\/ff22288af1a5455571aff7586b0fb341"},"description":"SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002\u306b\u3064\u3044\u3066\u8a73\u3057\u304f\u89e3\u8aac\u3002\u521d\u5fc3\u8005\u306b\u3082\u308f\u304b\u308a\u3084\u3059\u304f\u8aac\u660e\u3057\u307e\u3059\u3002","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/ja\/blog\/sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82\/#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/ja\/blog\/sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/ja\/blog\/sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/ja\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL\u3067\u4e3b\u30ad\u30fc\u3092\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u8aac\u660e\u3057\u3066\u304f\u3060\u3055\u3044\u3002 &#8211; \u30b9\u30c6\u30c3\u30d7\u30d0\u30a4\u30b9\u30c6\u30c3\u30d7"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/ja\/blog\/#website","url":"https:\/\/www.silicloud.com\/ja\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"ja"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/ja\/blog\/#\/schema\/person\/ff22288af1a5455571aff7586b0fb341","name":"\u685c, \u6625\u6a39","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/www.silicloud.com\/ja\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cee48863f3d4fd7fef222498f3e71b82312aee42b7257a2dbde56394ca4e19de?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cee48863f3d4fd7fef222498f3e71b82312aee42b7257a2dbde56394ca4e19de?s=96&d=mm&r=g","caption":"\u685c, \u6625\u6a39"},"url":"https:\/\/www.silicloud.com\/ja\/blog\/author\/sakuraharuki\/"},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/www.silicloud.com\/ja\/blog\/sql%e3%81%a7%e4%b8%bb%e3%82%ad%e3%83%bc%e3%82%92%e4%bd%bf%e7%94%a8%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%e3%82%92%e8%aa%ac%e6%98%8e%e3%81%97%e3%81%a6%e3%81%8f%e3%81%a0%e3%81%95%e3%81%84%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/posts\/25","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/comments?post=25"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/posts\/25\/revisions"}],"predecessor-version":[{"id":325651,"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/posts\/25\/revisions\/325651"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/media?parent=25"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/categories?post=25"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/ja\/blog\/wp-json\/wp\/v2\/tags?post=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}