Mysql how to update complex tree data based on specific node?

246
September 06, 2017, at 4:14 PM

Suppose I have this:

F is what I want to add, when adding, I want to update D and A data, without affecting E. Any way to do this in mysql way without ascending to its parent one by one?

Tried to use ancestor but I realized their ancestor is all A, that means if I add F it will affect E too.

Rent Charter Buses Company
READ ALSO
Mysql query for Comma separated values in columns and aslo in search keywords

Mysql query for Comma separated values in columns and aslo in search keywords

I have one condition in query where I want to search resultsIn database there is region column in which region is saved as comma separated

262
Retrieve Data from phpmyadmin online 000webhost to Visual Basic Applications

Retrieve Data from phpmyadmin online 000webhost to Visual Basic Applications

Is there any example using php connect with visual basic applications between (000webhost)phpmyadmin?

309
Ubuntu migrate package PHP 7.0 and 7.1

Ubuntu migrate package PHP 7.0 and 7.1

Hi I am new with Ubuntu and have some problem with PHP1

365