The invention discloses an automatic and manual extension rotating dining table, and belongs to the technical field of furniture. Ground feet are arranged on the lower portions of the two ends of a main table leg, a vertical column at one side end of the main table leg is hinged to a second folding table leg, the second folding table leg is hinged to a first folding table leg, wherein the lower ends of vertical legs at one side ends of the second folding table leg and first folding table leg are provided with universal wheels respectively; a table frame is in a frame structure, the periphery of the table frame is provided with a table cover, the table cover is supported and fixed by rotary knobs, and the lower end of the table frame is hinged to the upper end of the main table leg; a tabletop supporting plate is arranged at the upper end of the table frame, the upper end of the table top supporting plate is provided with multiple extension table tops, guide rail slide ways are correspondingly arranged at the lower ends of the separated blocks among the extension table tops, the inner sides of the extension table tops are provided with semi-grooves, and the semi-grooves are in bolted connection with connecting pieces with holes; the upper end of the table top supporting plate is provided with a case, a shaft penetrates through the case, the upper portion and lower portion of the shaft are provided with an upper layer bevel gear and a lower layer bevel gear respectively, and the portions, corresponding to the upper layer bevel gear and the lower layer bevel gear, in the caseare provided with conical gears respectively. The automatic and manual extension rotating dining table has multiple purposes, and can be used as a large dining table when being unfolded completely.