Where (tablename or tablenametwo) is referenced change to your desired table name.

Note:
You can alter many tables all at once by adding a (,) between each command.

ALTER TABLE tablename AUTO_INCREMENT = 1,

ALTER TABLE tablenametwo AUTO_INCREMENT = 1