Answer / sudhanshu_kmr

use anyone ....

select curdate();

select current_date();

select date(now());

Answer / john

select curdate();

select current_date();

select date(now());

I have a table like this tblData (month int,Qty int) and i am inserting three rows in this table 1.tblData Values (1,100) 2.tblData Values (2,200) 3.tblData Values (3,300) The Result I want is the Running total of the field Qty that is 1 100 100 2 200 300 3 300 600 What is the Query for that ?

4 Answers  

---

What is mvcc in mysql?

0 Answers  

---

Is there a free mysql?

0 Answers  

---

What is mysqlcheck do?

0 Answers  

---

A company wants to store their invoices in a database. They already have their customers and articles in that database. Both customer and article are each identified by an unique integer value. Please create the SQL statements for creating the necessary table(s) for storing the invoices in a MySQL database. An invoice should hold information like invoice number, customer, date, article(s) and quantity etc.

1 Answers  

---

Is mysql a relational database?

0 Answers  

---

How many triggers are possible in mysql?

0 Answers  

---

What are the difference between and myisam and innodb?

0 Answers  

---

How to show table structure mysql?

0 Answers  

---

What are the purposes of using enum and set data types?

0 Answers  

---

How to update info already in a table and delete a row(s) from a table.

0 Answers  

---

How can you do the fine tunning?

3 Answers   ACC,

---