Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

SQL Basic Commands

SQL stands for Structured Query Language. SQL is a language which allow us to access data or modify data from the database. Before proceeding towards the SQL we should also know about database. DataBase can be defined as the collection of multipl...

Delete an azure blob by blob Name

We can delete any blob from our storage by identifying it with its name. Here is the sample code for deleting a blob from azure storage. StorageCredentials creds = new StorageCredentials("StorageAcocuntName", "StorageAccountKey"); Cl...

Methods in REST approach

REST (Representational State Transfer) is based on resources and actions. A resource can be an URL referencing a object or any entity on which we want to perform action for example: /listUser or /searchUser. Action can be one of the following: ...

Deleting Cells of tableview ios

Hello friends, To delete a cell at a particular indexpath you may use the following code: -(void)removeItemAtIndexPath:(NSIndexPath *)indexPath{ [(name of table) beginUpdates]; // I am assuming that you're just using a plain NSMut...

Difference between DELETE and TRUNCATE in MySQL.

In MySQL, DELETE and TRUNCATE both are used for deleting data from table. DELETE DELETE comes under DML(Data Manipulation Language). DELETE can be used to delete a particular row by using WHERE clause. It is slower than TRUNCATE as...

How to delete data from a table in MySQL?

To delete data from a table we can use either DELETE or TRUNCATE. DELETE If we want to delete a record from table then we use DELETE FROM statement. Syntax: Below statement deletes rows from table on the basis of where condition, we...

Using reject in ruby to delete elements selectively from an array

1> To delete an element from an array, use reject as shown below: arr = ['a','b','c','d','e'] arr.reject! { |i| i.match('d')} Result :=> ["a", "b", "c", "e"] 2> To delete particular keys from the array whose elements are ...

Delete all documents form solr

Hello all, If you want to Delete all documents from solr, follow any one of the step given below. There are 2 ways to do this. 1. http://localhost:8983/solr/update?stream.body=<delete><query>*:*</query></delete>&a...

Delete Test Sales/Order data from Magento

To **delete the test sales/Order data from magento** run the below queries in your magento database -- SET FOREIGN_KEY_CHECKS=0; ############################## # SALES RELATED TABLES ############################## TRUNCATE `sales_flat_c...

Delete duplicate row in table

You can delete the duplicate row without using the temporary table. You can use the self join concept. Suppose we have person table contain 3 columns named id, name, and city. INSERT INTO person(id,name,city) VALUES (1,'a', 'aa'), (2,'b','b...
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: