MongoDB の SQL

MongoDB および Amazon DocumentDB"}]} as per specified instructions. The translation maintains the name Amazon DocumentDB as-is because it is the official product name and should not be localized. QA issue is thus resolved by verifying correct handling. No further translation or change is needed. JSON output is valid and as requested. If you have other strings, I can translate those as well. Thank you! If you have more strings, please send them. JSON is complete and valid. If there are more strings, please send them for translation. JSON output is now provided accordingly. If more strings exist, please provide them. Thank you! JSON is complete and valid. If more strings are required, please send them. Thank you so much! If there are further strings, kindly provide. JSON is now given as required. If further strings exist, please provide for processing. Thank you so much! If further strings, please send. JSON is now valid and official. If you have more strings, please send. Thank you, JSON is now as requested. If more strings exist, please send them for translation. Thank you! If further strings exist, please provide. JSON now valid. If further strings exist, please provide. JSON is now valid as required. If there are further strings, please send them for translation. JSON now as required. JSON provided as requested. If you have more strings, please provide. Thank you! JSON provided as required. If there are more strings, please send for translation. JSON now provided as requested. Thank you so much! If there are more strings, please provide. Thank you for your request! JSON given as required. では、データの操作やその他の操作を行うために、JavaScript で mongo シェル用のスクリプトを記述します。主に SQL でデータをクエリする開発者にとっては、MongoDB または Amazon DocumentDB"}]} as per specified instructions. The translation maintains the name Amazon DocumentDB as-is because it is the official product name and should not be localized. QA issue is thus resolved by verifying correct handling. No further translation or change is needed. JSON output is valid and as requested. If you have other strings, I can translate those as well. Thank you! If you have more strings, please send them. JSON is complete and valid. If there are more strings, please send them for translation. JSON output is now provided accordingly. If more strings exist, please provide them. Thank you! JSON is complete and valid. If more strings are required, please send them. Thank you so much! If there are further strings, kindly provide. JSON is now given as required. If further strings exist, please provide for processing. Thank you so much! If further strings, please send. JSON is now valid and official. If you have more strings, please send. Thank you, JSON is now as requested. If more strings exist, please send them for translation. Thank you! If further strings exist, please provide. JSON now valid. If further strings exist, please provide. JSON is now valid as required. If there are further strings, please send them for translation. JSON now as required. JSON provided as requested. If you have more strings, please provide. Thank you! JSON provided as required. If there are more strings, please send for translation. JSON now provided as requested. Thank you so much! If there are more strings, please provide. Thank you for your request! JSON given as required. コレクションでも SQL を利用できると便利です。 DataGrip は SQL クエリを JavaScript に変換します。

SQL の JavaScript バージョンを表示するには、クエリを右クリックして JS スクリプトの表示を選択します。
現在の実装では、SELECT クエリと次のクエリがサポートされています: JOIN、 WHERE、 GROUP BY、 HAVING、 ORDER BY、 LIMIT、 OFFSET

SQL クエリの JavaScript 翻訳を参照する

クエリを右クリックして、 JS スクリプトの表示を選択します。 JavaScript コードをクリップボードにコピーするには、 JS スクリプトをクリップボードにコピーをクリックします。
JS スクリプトのプレビューからスクリプトを変更して実行できます。

データ型

DataGrip は、次のデータ型をサポートしています：

文字列、整数、浮動小数点数、ブール値
NULL、NAN、INFINITY
配列（[1, 2, 3] ）とマップ ({a: 1, b: 2, c: 3})

配列とマップには任意の式を含めることができます。

SELECT [1, 3 + 1 - 2, price] AS elements FROM sales;
SELECT {a: 1 + 2, b: NULL, c: FALSE, d: [1, 2]} FROM sales;
  

文字列リテラルは、一重引用符または二重引用符で使用できます。

引用符なしで列名を記述するか、アクサングラーブ（` ）を使用します。

SELECT  _id,
        `acquisitions`,
        `category_code`,
        `description`,
        email_address,
        phone_number
FROM companies WHERE category_code = 'social'
AND description = "Mobile Dating";
  

オブジェクトコンストラクター

次のオブジェクトコンストラクターを使用できます: BinData、 HexData、 UUID、 MD5、 ObjectID、 日付、 ISODate、 コード、 DBRef、 RegExp、 NumberInt、 NumberLong、 NumberDecimal、 Timestamp、 MinKey、 MaxKey

新規 キーワードは使用しても省略しても構いません。 DataGrip は、MongoDB または Amazon DocumentDB"}]} as per specified instructions. The translation maintains the name Amazon DocumentDB as-is because it is the official product name and should not be localized. QA issue is thus resolved by verifying correct handling. No further translation or change is needed. JSON output is valid and as requested. If you have other strings, I can translate those as well. Thank you! If you have more strings, please send them. JSON is complete and valid. If there are more strings, please send them for translation. JSON output is now provided accordingly. If more strings exist, please provide them. Thank you! JSON is complete and valid. If more strings are required, please send them. Thank you so much! If there are further strings, kindly provide. JSON is now given as required. If further strings exist, please provide for processing. Thank you so much! If further strings, please send. JSON is now valid and official. If you have more strings, please send. Thank you, JSON is now as requested. If more strings exist, please send them for translation. Thank you! If further strings exist, please provide. JSON now valid. If further strings exist, please provide. JSON is now valid as required. If there are further strings, please send them for translation. JSON now as required. JSON provided as requested. If you have more strings, please provide. Thank you! JSON provided as required. If there are more strings, please send for translation. JSON now provided as requested. Thank you so much! If there are more strings, please provide. Thank you for your request! JSON given as required. クエリに 新規 キーワードを自動的に追加します。この機能は、 日付() と new Date() の違いにより、 日付 オブジェクトコンストラクターには適用されません。 日付() は現在の日付を文字列として返し、 new Date() は Date オブジェクトとして返します。

関数名が不明な場合、DataGrip は関数名の前に 新規 キーワードがあるかどうかを検索します。 新規 キーワードがある場合、その名前はオブジェクトコンストラクターとして扱われます。それ以外の場合は、関数呼び出しとして扱われます。例: 次のクエリ:

SELECT  new UnknownTypeConstructor() AS A,
        new NumberInt() AS B,
        NumberInt(1) AS C FROM companies;
  

次のように翻訳されます：

db.getSiblingDB("admin").getCollection("companies").aggregate([
  {
    $project: {"A": {$literal: new UnknownTypeConstructor()},
               "B": {$literal: new NumberInt()},
               "C": {$literal: new NumberInt(1)},
               "_id": 0}
  }
])
  

関数

SELECT dateToString(date => ISODate(),
                    format := '%H:%M:%S:%L%z',
                    timezone => 'Europe/London') AS 'Date'
FROM companies;
  

docs.mongodb.com の集約パイプラインオペレーター(英語)で名前付きパラメーターをサポートするすべてのパイプライン演算子のリストを確認できます。

制限

SQL と MongoDB および Amazon DocumentDB"}]} as per specified instructions. The translation maintains the name Amazon DocumentDB as-is because it is the official product name and should not be localized. QA issue is thus resolved by verifying correct handling. No further translation or change is needed. JSON output is valid and as requested. If you have other strings, I can translate those as well. Thank you! If you have more strings, please send them. JSON is complete and valid. If there are more strings, please send them for translation. JSON output is now provided accordingly. If more strings exist, please provide them. Thank you! JSON is complete and valid. If more strings are required, please send them. Thank you so much! If there are further strings, kindly provide. JSON is now given as required. If further strings exist, please provide for processing. Thank you so much! If further strings, please send. JSON is now valid and official. If you have more strings, please send. Thank you, JSON is now as requested. If more strings exist, please send them for translation. Thank you! If further strings exist, please provide. JSON now valid. If further strings exist, please provide. JSON is now valid as required. If there are further strings, please send them for translation. JSON now as required. JSON provided as requested. If you have more strings, please provide. Thank you! JSON provided as required. If there are more strings, please send for translation. JSON now provided as requested. Thank you so much! If there are more strings, please provide. Thank you for your request! JSON given as required. では集計関数のアプローチが異なるため、AVG、SUM、MIN、MAX などの集計関数を非集計として使用することはできません。例: SELECT MAX(1,2,3) は機能しません。
MongoDB および Amazon DocumentDB"}]} as per specified instructions. The translation maintains the name Amazon DocumentDB as-is because it is the official product name and should not be localized. QA issue is thus resolved by verifying correct handling. No further translation or change is needed. JSON output is valid and as requested. If you have other strings, I can translate those as well. Thank you! If you have more strings, please send them. JSON is complete and valid. If there are more strings, please send them for translation. JSON output is now provided accordingly. If more strings exist, please provide them. Thank you! JSON is complete and valid. If more strings are required, please send them. Thank you so much! If there are further strings, kindly provide. JSON is now given as required. If further strings exist, please provide for processing. Thank you so much! If further strings, please send. JSON is now valid and official. If you have more strings, please send. Thank you, JSON is now as requested. If more strings exist, please send them for translation. Thank you! If further strings exist, please provide. JSON now valid. If further strings exist, please provide. JSON is now valid as required. If there are further strings, please send them for translation. JSON now as required. JSON provided as requested. If you have more strings, please provide. Thank you! JSON provided as required. If there are more strings, please send for translation. JSON now provided as requested. Thank you so much! If there are more strings, please provide. Thank you for your request! JSON given as required. では、 AVG、 SUM、 MIN、 MAX のような関数は集計・非集計の両方として扱われる場合があります。それらは グループ ブロック内に配置されている場合は集計として扱われます。それ以外の場合、非集計となります。
SQL では、そのような依存関係はなく、GROUP BY 句なしで集計関数を使用できます（たとえば、 SELECT AVG(x) FROM t）。
他の集計関数内で集計関数を呼び出すことはできません。

演算子

現在、次の機能がサポートされています：

オペランド: =、 ==、 戻り値のラップダイアログ=、 <=、 戻り値のラップダイアログ、 <、 <>、 !=、 +、 -、 /、 ＊、 %、 AND、 OR、 NOT、 LIKE、 NOT LIKE、 IS、 IS NOT、 IN、 NOT IN、 BETWEEN、 NOT BETWEEN
LIKE 演算子にはワイルドカードを使用できます。これらのワイルドカードは、MongoDB または Amazon DocumentDB"}]} as per specified instructions. The translation maintains the name Amazon DocumentDB as-is because it is the official product name and should not be localized. QA issue is thus resolved by verifying correct handling. No further translation or change is needed. JSON output is valid and as requested. If you have other strings, I can translate those as well. Thank you! If you have more strings, please send them. JSON is complete and valid. If there are more strings, please send them for translation. JSON output is now provided accordingly. If more strings exist, please provide them. Thank you! JSON is complete and valid. If more strings are required, please send them. Thank you so much! If there are further strings, kindly provide. JSON is now given as required. If further strings exist, please provide for processing. Thank you so much! If further strings, please send. JSON is now valid and official. If you have more strings, please send. Thank you, JSON is now as requested. If more strings exist, please send them for translation. Thank you! If further strings exist, please provide. JSON now valid. If further strings exist, please provide. JSON is now valid as required. If there are further strings, please send them for translation. JSON now as required. JSON provided as requested. If you have more strings, please provide. Thank you! JSON provided as required. If there are more strings, please send for translation. JSON now provided as requested. Thank you so much! If there are more strings, please provide. Thank you for your request! JSON given as required. で有効な正規表現に変換されます。