Category "recursive-query"

Recursive query to produce edges of a path?

I have a table paths: CREATE TABLE paths ( id_travel INT, point INT, visited INT ); Sample rows: id_travel | point | visited -----------+-------+

Get a path from manager to an employee in mysql 8

I have a question in term of my database courses, hope that you can help me. The table bellow is an exemple: +------------------------------------+ |ID_EMPLOYEE

SQLite string search in rows then insert string into new rows with values of the same row last column

I want to provide a query to my database that will search if a string exists in Column2(site_id) then put that string in a new table with the value of its befor

how to get no of dates appear between Fromdt to Todt and fetching thouse dates in column

![enter image description here][1] I have table called tbl_monthly_leave in below table i am trying to take dates between fromdt to Todate like (Fromdt , Todate