Update SQL Query Example
I am beginner in SQL (MySQL) and trying to learn Update SQL Query with Example code. Can anyone explain me the SQL Update query with an example code?
July 12, 2016 at 9:26 AM
Failed to Call Procedure
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sum(case when c.result = '1' then 1 else 0 end ) as Pass_total, sum(case when c' at line 1
February 27, 2015 at 3:31 AM
MY Sql Query Error - Not able to Understand the issue
I am new at MYSQL,I wrote simple query as follow:
CREATE Table tblFeedBack ( FeedBackID INT AUTOIncremeNT, UserID INT, InsertedTS TIMESTAMP , FeedBackValue VARCHAR(100), PRIMARY KEY (FeedBackID) );
CREATE PROCEDURE tblFeed
February 15, 2015 at 10:53 AM
which query will be run for previous(button) question
which query will be execute on previous button to view the previous questions . for example :- i m working on online examination software so when i click on the previous button i got previous question. please provide me the answer .
October 16, 2014 at 3:15 AM
How to access data yearly from DB in C# ?
how to access data yearly from database in C#.
I have code but i m not able to retrieve data yearly from DB table.
string date1 = dateTimePicker1.Value.Date.ToString("dd/MMM/yyyy");
September 10, 2014 at 1:20 AM