I have a urgent MySQL test problems now.
The problems followings:
"-- this is a 10 x 10 grid representation of seats in a seating chart (100 seats total)
-- patrons can reserve seats that are adjacent to each other, in the same row (same y axis).
-- for example, Seat Id 11 (1,1) and 21 (2,1). They can not skip seats or reserve in different rows
-- given a selection of seats, we want to block off 2 seats to the left and 2 to the right, 1 above, and 1 below.
select * from seating_chart_grid;
-- if the patron has seats 11 and 21, the query should return ids 31, 41, 12, 22
-- if the patron has seat id 23 and 33, the query should return 13, 43, 53, 24, 34
-- if the patron has seat 44, the query should return 24, 34, 54, 64, 43, 45
If you can solve then please let me know immediately.
Bu iş için 8 freelancer ortalamada $21 teklif veriyor
I can get this done if we are allowed to use PHP in conjugation with MySQL. With only MySQL, I don't think its possible to achieve the logic you're aiming for.
I can do this ASAP. Give me chance. I will show you good result. Thanks.....................................
I have expertise in database programming, designing and administration. I can help you out for providing the solution. Kindly come to chat for further discussion on your project.
Hello! I am an experienced database adminstrator using SQL for a long time. I have read your project description and I have the confidence that I can do it for you. Please feel free to contact me and discuss more about Daha Fazla