IN is the default parameter mode in stored procedures. IN parameters pass values into the procedure but cannot be modified within the procedure body. OUT and IN OUT are explicit modes that must be declared when parameters need to return values to the caller.