Provided it’s such a knowledgeable video, I think author should re-record this with better audio quality.
@heatherlinakridge
8 жыл бұрын
a brilliant and elegant solution; this solves so many problems. I bought your book.
@bahamu
10 жыл бұрын
Could you explain how the length column is populated on insertion? Thanks for the video!
@Dineshkumar-cy5hs
5 жыл бұрын
bahamu ok
@Dineshkumar-cy5hs
5 жыл бұрын
oh
@ivanzuna2404
5 жыл бұрын
Great explanation.
@DavitBarbakadze
4 жыл бұрын
Legendary!
@caydenIT
3 жыл бұрын
how to produce the length in insertion?
@percona
3 жыл бұрын
Hi Cayden's, Could you post this on our Percona Forum? because it's a bit broad and we need more details to know what are you trying to do. Thanks in advance. forums.percona.com/c/mysql-mariadb/36 Subscribe✅ and tap the 🔔 to be the first to see new videos on #OpenSource #Databases & more! percona.tv/subscribe
@Nallieheai
7 жыл бұрын
Im currently working of a project, the main thing is to create a treeview of the data i have in my database, however i have two three tables so far, one called Project(its a project folders destination on the pc pretty much and shown with a nicer name in the web), Subfolder(child of a project, they have things like "project_id" to know which project they belong to) then i have my 3rd table which is what i called Subfolder_link, which hold its own subfolder_link_id, subfolder_parent and subfolder_child, so a subfolder could be a parent or a child, but you dont know that before you check the link. Could i use the closure table design for this or does it only work if i have one table? Because as far as i know i cant combine Project and Subfolder into one table without having to NULL a few columns? Because stuff like a nice name is things i only care about the Project having, like a display name, but i suppose i could do that for the Subfolder as well if its the only way to solve it. Would appreciate any response that could help, at the moment im just watching through these sort of videos to learn about creating the treeview since im a bit unsure if i should do it in HTML and JavaScript or in PHP? I havent worked as much with JavaScript as PHP so i wouldnt really know where to start, but thats a different problem that ill try to figure out later.
@corythenati
10 жыл бұрын
This is a great video. Would the closure table work for a geneology heirarchy where every node has two parents? Would you have to use two closure tables, one for each parent type (Male/Female)?
@jimmysyar889
2 жыл бұрын
did you ever figure that out?
@shareapps3248
6 жыл бұрын
is Zend framework capable of doing all those kind of queries automatically, please i need some clarity, i didnt learned zend yet but is zend that powerful in Db management ??? thanks in advance
@janfranciszekkowalski8433
6 жыл бұрын
Best if you ask similar question on zendframework slack forum.
@XinWongDigital
9 жыл бұрын
correct me if i am wrong, when inserting a new node to the treepaths db, union all won't remove all the duplicates.
Пікірлер: 18