Search In
Entity framework provides numerous ways to batch delete the objects from Database. Below are the step for way 1 :
Load objects that has to be deleted in memory.
Remove the objects from context
And then save these changes. This statement will ref
Sorting the result using Order By clause:
ORDER BY clause is used to sort the data fetched using select statement either in ascending order or in descending. By default data fetched is sorted in ascending order.
Syntax:
Select columnname(s) from t
Group By :
It is used to group the result-set by one or more column. It is used in conjunction with aggregate functions provided by Structured Query Language . If order by is used then Group By must come before Order By clause.
Syntax1:
SELECT col
There are times when SQL injection is the most shocking attacks on the internet. SQL injection means a condition where user is molding a SQL query in a unexpected form.If the queries are not handled properly it can lead to results like leaking of dat
Full Text Search is a way to provide faster search on your website. Suppose you creating a website for a newspaper where lots of article written on various subject and now you want to fetch all news related to word “Modi”. Full text search is ideal f
Hello,
I would like to know if in WP PHP is possible to make something like that:
I need for the logged user a form which when compiled and submitted, send a mail to the admin with the all data of the user from db and the message he/she write. In thi
If you want to update the values of the dropdown based on the values of other dropdown. Here is the example where If I choose Chicken as my where from.
My where to should display Baked potato, Mutton, fish.
<form class="foodorder hide">
Hello Reader's if you are learning, optimizing the mysql query then in this blog you will know some new syntax offered by Mysql where you can make your query fast. Lets see the examples as below:-
In the code below, the results selects all
Sub Queries:
Sub Queries are those query which comes within another query and are written after the WHERE clause.They are also known as Inner query or nested query.
It is used to return records that are used in the main query as a condition to fil
Delete command in SQL removes the ROW based on the condition provided with the WHERE clause, if no WHERE clause is provided it deletes all the row from the table.
Syntax for delete command:
DELETE FROM table_name WHERE column_name='value';
Trunca
