{"id":16812,"date":"2018-05-28T06:20:31","date_gmt":"2018-05-28T06:20:31","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=16812"},"modified":"2021-04-05T13:45:30","modified_gmt":"2021-04-05T08:15:30","slug":"cql-data-manipulation-commands","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/","title":{"rendered":"CQL Data Manipulation Commands (Insert, Update, Delete, Batch)"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:1934,&quot;href&quot;:&quot;https:\\\/\\\/docs.datastax.com\\\/en\\\/cql\\\/3.1\\\/cql\\\/cql_intro_c.html&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20180131045834\\\/http:\\\/\\\/docs.datastax.com:80\\\/en\\\/cql\\\/3.1\\\/cql\\\/cql_intro_c.html&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 11:47:22&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-08 15:10:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-14 23:12:46&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-21 15:36:10&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-24 21:03:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-10 02:38:21&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-12 07:53:58&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-05-12 07:53:58&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<h2>1. Objective<\/h2>\n<p><span style=\"font-size: large\">In our last <a href=\"https:\/\/data-flair.training\/blogs\/apache-cassandra-tutorial\/\"><strong>Cassandra tutorial<\/strong><\/a>, we had seen <a href=\"https:\/\/data-flair.training\/blogs\/cql-clauses\/\"><strong>CQL Clauses<\/strong><\/a>. In this article, we are going to discuss Data Manipulation Commands in Cassandra Query Language (CQL). <\/span><\/p>\n<p><span style=\"font-size: large\">These CQL Data Manipulation Commands helps to Insert, Update, Delete, and Batch Command with syntax and examples. <\/span><\/p>\n<p><span style=\"font-size: large\">So, let&#8217;s start with CQL Data Manipulation Commands.<\/span><\/p>\n<div id=\"attachment_16818\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-Data-Manipulation-Commands.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-16818\" class=\"wp-image-16818 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-Data-Manipulation-Commands.jpg\" alt=\"CQL Data Manipulation Commands (Insert, Update, Delete, Batch)\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-Data-Manipulation-Commands.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-Data-Manipulation-Commands-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-Data-Manipulation-Commands-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-Data-Manipulation-Commands-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-Data-Manipulation-Commands-1024x536.jpg 1024w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-16818\" class=\"wp-caption-text\">CQL Data Manipulation Commands (Insert, Update, Delete, Batch)<\/p><\/div>\n<h2>2. CQL Data Manipulation Commands<\/h2>\n<p><span style=\"font-size: large\">There will be many times when a user has to change the data in the tables. These commands are known as Data Manipulation Commands in CQL. <\/span><\/p>\n<p><span style=\"font-size: large\">These commands are used to manipulate data in a table. The user can use CQL Data Manipulation Commands to change the contents of the table.<\/span><br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/cassandra-shell-commands\/\">Let&#8217;s Study\u00a010 Cassandra Shell Commands | CQL Shell Commands<\/a><\/strong><\/p>\n<h3 class=\"western\">a. INSERT Command<\/h3>\n<p><span style=\"font-size: large\">In a column family\/table, there are many rows as per the requirement. These rows contain columns. A user can specify columns in advance. But sometimes the user may have to add a column after creating the table. <\/span><\/p>\n<p><span style=\"font-size: large\">The user can use a data manipulation command to perform the operation. &#8216;INSERT&#8217; keyword is used for this.<\/span><\/p>\n<p><span style=\"font-size: large\">This command works in two ways. In first the values are added in a separate command. In the other, the values are added to the same line.<\/span><br \/>\n<span style=\"font-size: large\"><strong>A Syntax of Insert Command:<\/strong><br \/>\n<\/span><\/p>\n<pre class=\"EnlighterJSRAW\">INSERT INTO &lt;table name&gt;(&lt;field name 1&gt;,&lt;field name 2&gt;,&lt;field name 3&gt;.,...)\r\n... VALUES ('value 1','value 2','value 3',....)\r\n... USING &lt;update parameter&gt;;<\/pre>\n<p><span style=\"font-size: large\">The update parameter includes either a time stamp or time to live (TTL).<\/span><br \/>\n<span style=\"font-size: large\"><strong>Another Syntax,<\/strong><br \/>\n<\/span><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/\"><strong>Do you know about Cassandra Data Manipulation Commands<\/strong><\/a><\/p>\n<pre class=\"EnlighterJSRAW\">INSERT INTO &lt;table name&gt; JSON '{\"field name 1\":\"value 1\",\"field name 2\":\"value 2\",\"field name 3\":\"value 3\",...}'<\/pre>\n<p><span style=\"font-size: large\"><strong>Example:<\/strong><\/span><br \/>\n<span style=\"font-size: large\">In the table &#8216;student&#8217; given below,<\/span><br \/>\n<strong>Table.1-\u00a0CQL Data Manipulation Commands &#8211; INSERT Command<\/strong><\/p>\n<table width=\"616\" cellspacing=\"0\" cellpadding=\"7\">\n<colgroup>\n<col width=\"139\" \/>\n<col width=\"140\" \/>\n<col width=\"140\" \/>\n<col width=\"139\" \/> <\/colgroup>\n<tbody>\n<tr valign=\"top\">\n<td width=\"139\"><span style=\"font-size: large\"><b>Id<\/b><\/span><\/td>\n<td width=\"140\"><span style=\"font-size: large\"><b>Name<\/b><\/span><\/td>\n<td width=\"140\"><span style=\"font-size: large\"><b>Branch<\/b><\/span><\/td>\n<td width=\"139\"><span style=\"font-size: large\"><b>City<\/b><\/span><\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"139\"><span style=\"font-size: large\">001<\/span><\/td>\n<td width=\"140\"><span style=\"font-size: large\">Ayush<\/span><\/td>\n<td width=\"140\"><span style=\"font-size: large\">Electrical Engg<\/span><\/td>\n<td width=\"139\"><span style=\"font-size: large\">Boston<\/span><\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"139\"><span style=\"font-size: large\">002<\/span><\/td>\n<td width=\"140\"><span style=\"font-size: large\">Aarav<\/span><\/td>\n<td width=\"140\"><span style=\"font-size: large\">Computer Engg<\/span><\/td>\n<td width=\"139\"><span style=\"font-size: large\">Stanford<\/span><\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"139\"><span style=\"font-size: large\">003<\/span><\/td>\n<td width=\"140\"><span style=\"font-size: large\">Kabir<\/span><\/td>\n<td width=\"140\"><span style=\"font-size: large\">Applied physics<\/span><\/td>\n<td width=\"139\"><span style=\"font-size: large\">Pasadena<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Read about CQL Data Definition Command in detail<\/strong><br \/>\nIn this table, a row has to be added. That row includes 004, aaron, aerospace engg, new york city.<\/p>\n<pre class=\"EnlighterJSRAW\">cqlsh;keyspace1&gt;INSERT INTO student(id, name, branch, city)\r\n... VALUES (004,'aaron','aerospace engg','new york city')\r\n... USING TTL 86400;<\/pre>\n<p><span style=\"font-size: large\"><strong>Another Syntax,<\/strong><br \/>\n<\/span><\/p>\n<pre class=\"EnlighterJSRAW\">cqlsh;keyspace1&gt;INSERT INTO student JSON '{\"id\":\"004\",\"name\":\"aaron\", \"branch\":\"aerospace engg\", \"city\":\"new york city\"}';<\/pre>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/cassandra-user-defined-types\/\">Have a look at Cassandra User Defined Types<\/a><\/strong><\/p>\n<h3 class=\"western\">b. UPDATE\u00a0Command<\/h3>\n<p><span style=\"font-size: large\">These CQL data manipulation commands are used to update an existing data in a table. The user can use &#8216;UPDATE&#8217; keyword. This execution replaces the previous value in a column of a row with a new value.<\/span><br \/>\n<span style=\"font-size: large\"><strong>A Syntax of Update Command:<br \/>\n<\/strong><\/span><\/p>\n<pre class=\"EnlighterJSRAW\">UPDATE &lt;table name&gt; USING &lt;update parameter&gt;\r\n...SET &lt;field name 1&gt;=&lt; value 1&gt;,\r\n&lt; field name 2&gt;=&lt; value 2&gt;,\r\n&lt; field name 3&gt;=&lt;value 3&gt;,\r\n.....\r\nWHERE &lt;field&gt;=&lt;value&gt;;<\/pre>\n<p><span style=\"font-size: large\"><strong>Example:<\/strong> In the previous table, let us update the branch at id=002 to computer science and city to Berkley.<\/span><\/p>\n<pre class=\"EnlighterJSRAW\">cqlsh;keyspace1&gt;UPDATE student USING TTL 400\r\n...SET branch=computer science,\r\n... city=berkley,\r\nWHERE id=002;<\/pre>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/cassandra-data-types\/\">Let&#8217;s discuss Cassandra\u00a0Data Types<\/a><\/strong><\/p>\n<h3 class=\"western\">c. DELETE\u00a0Command<\/h3>\n<p><span style=\"font-size: large\">There may be some rows that the has to delete. These CQL data manipulation commands let the user delete data from a table. We use &#8216;DELETE&#8217; keyword to perform this operation. Executing this command deletes the whole row as according to the identifier.<\/span><br \/>\n<span style=\"font-size: large\"><strong>A Syntax of Delete Command:<br \/>\n<\/strong><\/span><\/p>\n<pre class=\"EnlighterJSRAW\">DELETE &lt;table name&gt; USING &lt;update parameter&gt;\r\n... WHERE &lt;identifier&gt;<\/pre>\n<p><strong>Do you Know Cassandra vs MongoDB &#8211; 8 Major Factors of Difference<\/strong><br \/>\n<span style=\"font-size: large\"><strong>Example:<\/strong> In the table &#8216;student&#8217;, let us delete the last row &#8216;004&#8217;.<br \/>\n<\/span><\/p>\n<pre class=\"EnlighterJSRAW\">cqlsh;keyspace1&gt;DELETE student USING TTL 400\r\n... WHERE id=004;<\/pre>\n<h3 class=\"western\">d. BATCH\u00a0Command<\/h3>\n<p><span style=\"font-size: large\">There may be few statements that have to updated constantly in an application. To ease this, a\u00a0user can create a batch that will be repeated constantly. In other words, this command executes multiple data manipulation commands using a single statement.\u00a0<\/span><br \/>\n<span style=\"font-size: large\"><strong>A Syntax of Batch Command:<\/strong><\/span><\/p>\n<p><span style=\"font-size: large\"><a href=\"https:\/\/data-flair.training\/blogs\/cassandra-api\/\"><strong>You must learn about Cassandra API<\/strong><\/a><br \/>\nTo create a batch we use the following syntax.<br \/>\n<\/span><\/p>\n<pre class=\"EnlighterJSRAW\">BEGIN BATCH\r\n\/\/different data manipulation command syntax\r\n;<\/pre>\n<p><span style=\"font-size: large\">To apply the batch, the user can use the following syntax.<br \/>\n<\/span><\/p>\n<pre class=\"EnlighterJSRAW\">APPLY BATCH;<\/pre>\n<p><span style=\"font-size: large\"><strong>Example:<\/strong> In the original table &#8216;student&#8217;, let us perform all the operations in the previous examples under a BATCH.<\/span><\/p>\n<pre class=\"EnlighterJSRAW\">cqlsh;keyspace1&gt; BEGIN BATCH\r\nINSERT INTO student JSON '{\"id\":\"004\",\"name\":\"aaron\", \"branch\":\"aerospace engg\", \"city\":\"new york city\"}';\r\nUPDATE student USING TTL 400\r\n...SET branch=computer science,\r\n... city=berkley,\r\nWHERE id=002;\r\nDELETE student USING TTL 400\r\n... WHERE id=004 ;\r\nAPPLY BATCH;<\/pre>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/cassandra-quiz\/\">Test your Cassandra Knowledge and Competition<\/a><\/strong><\/p>\n<p><span style=\"font-size: large\">So, this was all about CQL Data Manipulations Commands. Hope you like the information.<\/span><\/p>\n<h2>3. Conclusion<\/h2>\n<p><span style=\"font-size: large\">Hence, in this CQL tutorial, we learned about the data manipulation commands in Cassandra Query Language. Furthermore, feel free to ask in the comment box. <\/span><br \/>\n<span style=\"font-size: large\">Related Article &#8211; <strong><a href=\"https:\/\/data-flair.training\/blogs\/hbase-vs-cassandra\/\">HBase vs Cassandra\u00a0<\/a><\/strong><\/span><br \/>\n<span style=\"font-size: large\"><strong><a href=\"https:\/\/docs.datastax.com\/en\/cql\/3.1\/cql\/cql_intro_c.html\">For reference<\/a><\/strong><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Objective In our last Cassandra tutorial, we had seen CQL Clauses. In this article, we are going to discuss Data Manipulation Commands in Cassandra Query Language (CQL). These CQL Data Manipulation Commands helps&#46;&#46;&#46;<\/p>\n","protected":false},"author":7,"featured_media":16818,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[1669,3025,3736,6741,15170],"class_list":["post-16812","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cassandra","tag-batch-command","tag-cql-data-manipulation-commands","tag-delete-command","tag-insert-command","tag-update-command"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>CQL Data Manipulation Commands (Insert, Update, Delete, Batch) - DataFlair<\/title>\n<meta name=\"description\" content=\"CQL Data Manipulation Commands- CQL Commands, Insert Command, Delete Command, Update Command, Batch Command with examples &amp; syntax, Cassandra Query Language\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CQL Data Manipulation Commands (Insert, Update, Delete, Batch) - DataFlair\" \/>\n<meta property=\"og:description\" content=\"CQL Data Manipulation Commands- CQL Commands, Insert Command, Delete Command, Update Command, Batch Command with examples &amp; syntax, Cassandra Query Language\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-28T06:20:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-05T08:15:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-Data-Manipulation-Commands.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CQL Data Manipulation Commands (Insert, Update, Delete, Batch) - DataFlair","description":"CQL Data Manipulation Commands- CQL Commands, Insert Command, Delete Command, Update Command, Batch Command with examples & syntax, Cassandra Query Language","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:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/","og_locale":"en_US","og_type":"article","og_title":"CQL Data Manipulation Commands (Insert, Update, Delete, Batch) - DataFlair","og_description":"CQL Data Manipulation Commands- CQL Commands, Insert Command, Delete Command, Update Command, Batch Command with examples & syntax, Cassandra Query Language","og_url":"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-05-28T06:20:31+00:00","article_modified_time":"2021-04-05T08:15:30+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-Data-Manipulation-Commands.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd"},"headline":"CQL Data Manipulation Commands (Insert, Update, Delete, Batch)","datePublished":"2018-05-28T06:20:31+00:00","dateModified":"2021-04-05T08:15:30+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/"},"wordCount":613,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-Data-Manipulation-Commands.jpg","keywords":["BATCH Command","CQL Data Manipulation Commands","DELETE Command","INSERT Command","UPDATE Command"],"articleSection":["Cassandra Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/","url":"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/","name":"CQL Data Manipulation Commands (Insert, Update, Delete, Batch) - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-Data-Manipulation-Commands.jpg","datePublished":"2018-05-28T06:20:31+00:00","dateModified":"2021-04-05T08:15:30+00:00","description":"CQL Data Manipulation Commands- CQL Commands, Insert Command, Delete Command, Update Command, Batch Command with examples & syntax, Cassandra Query Language","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-Data-Manipulation-Commands.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/05\/CQL-Data-Manipulation-Commands.jpg","width":1200,"height":628,"caption":"CQL Data Manipulation Commands (Insert, Update, Delete, Batch)"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/cql-data-manipulation-commands\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Cassandra Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/cassandra\/"},{"@type":"ListItem","position":3,"name":"CQL Data Manipulation Commands (Insert, Update, Delete, Batch)"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team specializes in creating clear, actionable content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Backed by industry expertise, we make learning easy and career-oriented for beginners and pros alike.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam3\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/16812","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=16812"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/16812\/revisions"}],"predecessor-version":[{"id":90510,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/16812\/revisions\/90510"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/16818"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=16812"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=16812"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=16812"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}