I think the most commonly used zucchini in Mexican cooking is either what in Mexico is called the calabacita italiana, or Itailian zucchini, or the calabacita bola or round squash, which is similar to the Italian but rounder and smaller and used a lot in French cooking. Italian zucchini is different from the regular green zucchini found in most US stores, in that the later is large, thick and has a uniform dark green color. The Italian zucchini is smaller, a bit rounder with a chubbier appearance, and has a lighter green color that is randomly speckled with a cream color and is milder and sweeter in flavor.
See the Italian zucchini pictured above. As the years have gone by, I have seen them more frequently at international and Latino stores as well as some Farmers Markets here in the US.
Below see the Italian zucchini on top of the regular green zucchini so you can compare its looks. Now you have to bring them home to taste the differences (!). Though you can substitute one for the other in recipes, the Italian is a bit milder and sweeter.