Klik nama instance. Halaman ringkasan instance akan ditampilkan.
Di bagian daftar Database di halaman ini, klik nama database.
Di bagian Tables, klik nama tabel.
Di panel kiri Google Cloud console, klik Data.
Masukkan data
Di halaman Data tabel, klik Sisipkan.
Konsol Google Cloud menampilkan halaman Spanner Studio tabel
dengan tab kueri baru yang berisi pernyataan INSERT dan SELECT template
yang Anda edit untuk menyisipkan baris dalam tabel dan melihat hasil
sisipan tersebut.
Edit pernyataan INSERT ke nilai yang Anda inginkan, dan edit klausa WHERE
pernyataan SELECT agar cocok dengan nilai kunci utama baris yang Anda
sisipkan.
Lihat Pernyataan INSERT dan
Literal untuk mengetahui informasi tentang sintaksis
yang didukung Spanner.
Klik Run.
Spanner menjalankan pernyataan.
Mengedit data
Di halaman Data tabel, pilih baris yang ingin Anda
edit, lalu klik Edit.
Konsol Google Cloud menampilkan halaman Spanner Studio tabel
dengan tab kueri baru yang berisi pernyataan UPDATE dan SELECT template
yang Anda edit untuk memperbarui baris dalam tabel dan melihat hasil
update tersebut.
Perhatikan bahwa klausa WHERE dari kedua pernyataan menunjukkan baris yang Anda pilih untuk diedit.
Edit pernyataan UPDATE untuk mencerminkan pembaruan yang ingin Anda buat.
Lihat Pernyataan UPDATE dan
Literal untuk mengetahui informasi tentang sintaksis
yang didukung Spanner.
Klik Run.
Spanner menjalankan pernyataan.
Menghapus data
Di halaman Data tabel, pilih satu atau beberapa baris yang ingin Anda hapus, lalu klik Hapus.
Perlu bantuan untuk menemukan baris? Ketik kunci utamanya ke dalam kotak filter.
Pada dialog yang muncul setelah Anda mengklik Hapus, klik KONFIRMASI.
Konsol Google Cloud menampilkan data dari tabel Anda, yang tidak lagi
berisi baris yang dihapus.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-08-17 UTC."],[],[],null,["# Insert and modify data using the Google Cloud console\n\nThe Google Cloud console provides an interface for inserting, editing, and deleting\ndata in a Spanner table.\n\nFind a table\n------------\n\nTo get started, select to view a Spanner table in the\nGoogle Cloud console.\n\n1. Go to the **Spanner** page in the Google Cloud console.\n\n [Go to the Spanner page](https://console.cloud.google.com/spanner)\n2. Click the name of an instance. The instance overview page is displayed.\n\n3. Under the **Databases** list on this page, click the name of a database.\n\n4. Under **Tables**, click the name of a table.\n\n5. In the left pane of the Google Cloud console, click **Data**.\n\nInsert data\n-----------\n\n| **Note:** Spanner Studio (formerly labeled **Query** in the Google Cloud console) supports SQL, DML, and DDL operations in a single editor. For more information, see [Manage your data using the Google Cloud console](/spanner/docs/manage-data-using-console).\n\n1. On the table's **Data** page, click **Insert**.\n\n The Google Cloud console displays the table's Spanner Studio page\n with a new query tab containing template `INSERT` and `SELECT` statements\n that you edit to insert a row in the table and view the result of that\n insertion.\n2. Edit the `INSERT` statement to the values you want, and edit the `SELECT`\n statement's `WHERE` clause to match the primary key value of the row you are\n inserting.\n\n See [INSERT statement](/spanner/docs/reference/standard-sql/dml-syntax#insert-statement) and\n [Literals](/spanner/docs/reference/standard-sql/lexical#literals) for information about the syntax\n Spanner supports.\n3. Click **Run**.\n\n Spanner runs the statements.\n\nEdit data\n---------\n\n1. On the table's **Data** page, select the row you want to\n edit, then click **Edit**.\n\n The Google Cloud console displays the table's **Spanner Studio** page\n with a new query tab containing template `UPDATE` and `SELECT` statements\n that you edit to update the row in the table and view the result of that\n update.\n Note that the `WHERE` clauses of both statements denote the row you selected\n to edit.\n2. Edit the `UPDATE` statement to reflect the updates you want to make.\n\n See [UPDATE statement](/spanner/docs/reference/standard-sql/dml-syntax#update-statement) and\n [Literals](/spanner/docs/reference/standard-sql/lexical#literals) for information about the syntax\n Spanner supports.\n3. Click **Run**.\n\n Spanner runs the statements.\n\nDelete data\n-----------\n\n| **Note:** Deleting a row will also delete its child rows if the child rows have `ON\n| DELETE CASCADE` enabled. However, if the child rows do not have this setting enabled, you will first have to delete all the child rows in order to delete the parent row.\n\n1. On the table's **Data** page, select one or more rows that you want to delete,\n then click **Delete**.\n\n Need help finding a row? Type its primary key into the filter box.\n2. In the dialog that appears after you click **Delete** , click **CONFIRM**.\n\n The Google Cloud console displays the data from your table, which no\n longer contains the deleted rows.\n\nFor an interactive example of inserting and modifying data in a Spanner\ntable, see the [Quickstart using the console](/spanner/docs/create-query-database-console)."]]
