How can I insert several data from different tables into a field of another table in mysql?

0

I have a database "Cafeteria" with four main tables "menu", "client", "menu_has_cliente" and "orden" in the third are the foreign keys to connect to the multiple clients that ask for multiple foods from the table menu being a connection from several to many (n: m). I hope that until now you have understood me, what I want to do is insert the data of all the foods that a customer has requested in a field called "orders" from the "order" table, composed of the following fields idOrden, name (of the client) , orders, total and date ... so far I have been able to insert this data but in my table "order" field "orders" only shows me a product even if the client has requested several. Yes, it shows me the corresponding total and an automatic date is created, the only problem is that it does not show all the data. Please help me! :)

    
asked by Fabian 08.10.2018 в 06:43
source

0 answers