Muhammad Kashif Muhammad Kashif - 1 year ago 51
SQL Question

How to insert date in to the copy Table in MySQL

I have to three tables (stock,trans and sales). I copy the stock Table into the trans using

insert into trans (idProduct,product_name,product_size,product_qty,details,product_price)select idProduct,product_name,product_size,product_qty,details,product_price from stock WHERE idProduct = '" + id + "'


And also copy table values to trans to sales using

insert into sales(idProduct,product_name,Product_size,qty,product_price) select idProduct,product_name,Product_size,qty,product_price from trans


Now I want to insert the current date in to the trans table particular row's cell.

how????

Answer Source

Try using NOW() and doing it in the first insert.

insert into trans (idProduct,product_name,product_size,product_qty,details,product_price,particular_col)
select idProduct,product_name,product_size,product_qty,details,product_price,now() 
from stock WHERE idProduct = '" + id + "'

I've add to the list of column particular_column , place it in the right place with it right name, same goes for NOW()