update openquery (MYSQL_, 'select note from work')
SET note=REPLACE(note,char(10), '')

UPDATE [work]
set note = REPLACE(note,char(10), ' ')
go

DECLARE @TSQL varchar(8000), @VAR char(10), @VAR2 char(10), @VAR3 VarChar(200),
@VAR4 VarChar(10), @VAR5 VarChar(10), @VAR6 VarChar(20) 
  DECLARE @Grup VarChar(10)
  DECLARE @Nnum VarChar(10)
  DECLARE @Name VarChar(200)
  DECLARE @Ed VarChar(10)
  DECLARE @koltek int
  DECLARE @temp VarChar(20)
  declare @cur cursor
  set @cur = cursor fast_forward for
    SELECT id_grup, nnum, name, ed, koltek, temp
      FROM table1
  OPEN @cur
  WHILE (0 = 0)
  BEGIN
    FETCH NEXT
      FROM @cur
      INTO @Grup, @Nnum, @Name, @Ed, @koltek, @temp
      IF (@@FETCH_STATUS <> 0) BREAK
      SELECT  @VAR = @Grup
      SELECT  @VAR2 = @Nnum
      SELECT  @VAR3 = @Name
      SELECT  @VAR4 = @Ed
      SELECT  @VAR5 = @koltek
      SELECT  @VAR6 = @temp
      SELECT  @TSQL = 'update OPENQUERY(mysql,''SELECT * FROM table2 WHERE id_grup = ''''' + @VAR + ''''' and nnum = ''''' + @VAR2 + ''''''')
						SET name = ''' + @VAR3 + ''',
						    ed = ''' + @VAR4 + ''',
							koltek = ''' + @VAR5 + ''',
							temp = ''' + @VAR6 + ''' 
						WHERE (id_grup = ''' + @VAR + ''') AND (nnum = ''' + @VAR2 + ''')'
      EXEC (@TSQL)
  END
  CLOSE @cur
  DEALLOCATE @cur