SQL question

Permabanned
Joined
22 Mar 2020
Posts
2,337
what the best way via the myphpadmin to do this.

cant sell something before you buy, using dates.
So you buy it 1 nov but you cant sell it before that given date.
 
Code:
select product_id from products where release_date > "2022-11-01 00:00:00"

What I mean is, in the gui tables you lock them so you cant enter a date before you purchase the item.

you buy car on the 10 nov, but the sell column must start from the date given in the buy column.
 
Back
Top Bottom