Jump to main content
  • Support
  • Academy
  • DataStax Home
DataStax Logo
  • Glossary
  • Blog
  • Drivers
  • Community
  • Resources
  • world icon
  • Download Now
CQL for the DataStax Distribution of Apache Cassandra™ 3.11 Latest DDAC patch: 5.1.17
  • About CQL
  • CQL quickstart
  • CQL quick reference
  • CQL data modeling
  • Introduction to CQL commands
  • Managing keyspaces
  • Managing types, functions, and aggregates
  • Managing tables
  • Querying data
  • Inserting and updating data
  • Batching inserts and updates
  • CQL reference
  • Cycling keyspace
DataStax Astra — Built on Apache Cassandra and designed from the ground up to run anywhere, on any cloud, in any datacenter, and in every possible combination. DataStax delivers the ultimate hybrid and multi-cloud database.

Search other guides

  1. Home
  2. CQL quickstart

    Quickstart for CQL.

  3. Increase your knowledge

    Increase your knowledge of CQL and data modeling.

  • CQL quickstart

    Quickstart for CQL.

    • Introduction

      Introduction to CQL and data modeling.

    • Running CQL commands

      Run CQL commands using CQL shell.

    • Data modeling

      Introduction to data modeling.

    • Creating a keyspace

      Add a keyspace and set the replication factor.

    • Creating a table with a simple primary key

      Create a table with a simple primary key and populate it with data.

    • Creating a table with a compound primary key

      Create a table with a compound primary key and populate it with data.

    • Creating a table with a composite partition key

      Create a table with a composite partition key and populate it with data.

    • Using a secondary index

      Create a secondary index on a column.

    • Updating data

      The UPDATE statement writes one or more column values to a row.

    • Deleting and truncating data

      The DELETE statement removes data from one or more columns, or removes an entire row. The TRUNCATE statement removes all data from a table.

    • Dropping tables and keyspaces

      The DROP TABLE statement removes a table and the table data. The DROP KEYSPACE statement removes the keyspace and all of the objects in the keyspace.

    • Increase your knowledge

      Increase your knowledge of CQL and data modeling.

Increase your knowledge

Increase your knowledge of CQL and data modeling.

See these documents for more information:

  • Introduction to CQL commands
  • CQL reference
  • CQL data modeling
  • CQL quick reference
  • DataStax Bulk Loader (Loads data from CSV or JSON files into the database.)

DataStax Academy also has online classes about CQL and data modeling. See academy.datastax.com.

Contact Us

+1 (650) 389-6000

info@datastax.com

© DataStax | Privacy policy | Terms of use | Updated: 30 March 2020

Build time: 2020-03-30 11:25:24.234

DataStax, Titan, and TitanDB are registered trademark of DataStax, Inc. and its subsidiaries in the United States and/or other countries.

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.

ddaccql ddaccql51