Is it possible in a query to delete a row specifying its row index? I want to delete a row from my table. I'm trying to figure this because when I delete rows from my datagridview, it does not update. So I was thinking if I just directly delete it from sql then it's just like calling a query.
select *, row_number() over (order by date) as row
Will give you every row from your example table with its row number according to column of your choice.
Then you just select the primary key of the row with desired row number and use it in where clause of the delete.
Does it make sense?
If you post the structure of your table I can rewrite this query for you.
Hi, I am a newbie in developing a website. i have tried to connect using mysqli conncetion
Here is my simple code.
// db.php code
//$con = mysqli_connect("localhost","root","","bakery"); ...
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...